PROCESS_INSTANCEBUSINESS_UNITPO_IDPO_LINE_NBRITM_SETIDINV_ITEM_IDITM_DESCRL=Line Quantity
S=Schedule Quantity
D=Due Date
P=PO Date
N=No
Y=Yes
PO_PRC_CNTL_TMP(SQL Table) |
Index Back |
|---|---|
Pricing control info |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 4 | PO_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Purchase Order Line Number |
| 5 | ITM_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 6 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 7 | ITM_DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Item Description |
| 8 | QTY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Quantity to Use for Prices
L=Line Quantity S=Schedule Quantity |
| 9 | PRICE_DT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Date to Use for Prices
D=Due Date P=PO Date |
| 10 | PRICE_CAN_CHANGE | Character(1) | VARCHAR2(1) NOT NULL |
Price Can Be Changed on Order
N=No Y=Yes |