PV_SP_POSTG_AET(SQL Table) |
Index Back |
|---|---|
Cache Record for WO/PODate Initials Issue Description 092107 dh F-AHAYT-95051 PRICE_REQ for ePro change from number to Sign to allow negative |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | WORK_ORDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 7 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 8 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 9 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 10 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 11 | OVERRIDE_SUGG_VNDR | Character(1) | VARCHAR2(1) NOT NULL | Override Suggested Vendor |
| 12 | SYSTEM_SOURCE | Character(3) | VARCHAR2(3) NOT NULL | Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen. |
| 13 | STAGE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Stage Status
B=Ready to Create C=Completed D=Inv Demand Build in Process E=Error I=In Process N=Needs Approval P=PO Create in Process R=Error Recycle S=Staged V=POCALC in Process W=Warning Issued X=Reset Req and Purge |
| 14 | ABORT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Abort Process Flag |
| 15 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 16 | SELECT_PARM1 | Character(254) | VARCHAR2(254) NOT NULL | Dynamic Where Select Parms 1 |
| 17 | SELECT_PARM2 | Character(254) | VARCHAR2(254) NOT NULL | Dynamic Where Select Parms 2 |
| 18 | RECORD_COUNT | Number(7,0) | INTEGER NOT NULL | Count of Records |
| 19 | LAST_PO_STG_ID | Number(10,0) | DECIMAL(10) NOT NULL | Last Stage ID used |
| 20 | PO_STG_ID | Character(10) | VARCHAR2(10) NOT NULL | Uniqye key to the PO Staging table |
| 21 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 22 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 23 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 24 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 25 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 26 | DUE_DT | Date(10) | DATE | Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received. |
| 27 | DUE_TIME | Time(15) | TIMESTAMP | Due Time |
| 28 | FROZEN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Frozen Flag
B=Both N=No Y=Yes |
| 29 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 30 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 31 | QTY_REQ | Number(16,4) | DECIMAL(15,4) NOT NULL | Requisition Quantity |
| 32 | PRICE_REQ | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative |
| 33 | PRICE_REQ_BSE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative |
| 34 | AE_CNV_IN_FLD_NM | Character(18) | VARCHAR2(18) NOT NULL | AE input convert field |
| 35 | AE_CNV_OUT_FLD_NM | Character(18) | VARCHAR2(18) NOT NULL | AE output converion field |
| 36 | AE_MSG_NUM | Number(5,0) | INTEGER NOT NULL | Message Number |
| 37 | COUNT_TBL | Character(18) | VARCHAR2(18) NOT NULL | Table to use for po count |
| 38 | RT_RATE_INDEX | Character(10) | VARCHAR2(10) NOT NULL | Market Rate Index |
| 39 | CATEGORY_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Category Type
PSF=User Def UNS=UN/SPSC |
| 40 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 41 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL |
Category ID
Prompt Table: ITM_CAT_VW |
| 42 | CNTRCT_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 43 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 44 | CNTRCT_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Buying Agreement Line Nbr |
| 45 | ULTIMATE_USE_CD | Character(8) | VARCHAR2(8) NOT NULL | Ultimate Use Code |
| 46 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 47 | REQ_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Requisition Line Number |
| 48 | REQ_SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Requisition Schedule Number |
| 49 | REQ_DISTRIB_NBR | Number(5,0) | INTEGER NOT NULL | Requisition Distrib Number |
| 50 | TOT_MERCH_COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Merchandising Costs |
| 51 | TOT_EXPENSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Beginning Balance |
| 52 | VERSION_NBR | Number(5,0) | INTEGER NOT NULL | Contract Version number |
| 53 | CAT_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Contract Category Line Number |