PRCR_UPD_TMP1R(SQL Table) |
Index Back |
|---|---|
Prcr Upd Temp for Receipts |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PRCR_YEAR |
Number(4,0) | SMALLINT NOT NULL | Procurement Year |
| 3 | PRCR_PERIOD |
Number(3,0) | SMALLINT NOT NULL | Procurement Period |
| 4 | ITM_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 5 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | CATEGORY_ID |
Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 7 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 8 | BUSINESS_UNIT_PO |
Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 9 | SHIPTO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 10 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 11 | UNIT_MEASURE_STD |
Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 12 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 13 | RECV_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 14 | RECV_SHIP_SEQ_NBR |
Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 15 | BUSINESS_UNIT_RECV |
Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
| 16 | BUYER_ID |
Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 17 | REPORT_ENTITY | Character(5) | VARCHAR2(5) NOT NULL | Reporting Entity ID |
| 18 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 19 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit |
| 20 | SHIPTO_SETID | Character(5) | VARCHAR2(5) NOT NULL | ShipTo SetID |
| 21 | QTY_SH_RECVD_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Receipt Quantity |
| 22 | QTY_SH_REJCT_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Rejected Quantity |
| 23 | QTY_RETURN | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Returned |
| 24 | QTY_DEFECTIVE | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Defective |
| 25 | QTY_EARLY | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Early |
| 26 | QTY_LATE | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Late |
| 27 | AMT_RECEIVED | Number(27,3) | DECIMAL(26,3) NOT NULL | Amount Received |
| 28 | AMT_REJECTED | Number(27,3) | DECIMAL(26,3) NOT NULL | Amount Rejected |
| 29 | NUM_OF_RECEIPTS | Number(7,0) | INTEGER NOT NULL | Number of Receipts |
| 30 | EARLY_SHIPMENTS | Number(7,0) | INTEGER NOT NULL | Number of Early Shipments |
| 31 | LATE_SHIPMENTS | Number(7,0) | INTEGER NOT NULL | Number of Late Shipments |
| 32 | NUM_OF_RETURNS | Number(7,0) | INTEGER NOT NULL | Number of Returns |
| 33 | OVER_SHIPMENTS | Number(7,0) | INTEGER NOT NULL | Number of Over Shipments |
| 34 | UNDER_SHIPMENTS | Number(7,0) | INTEGER NOT NULL | Number of Under Shipments |
| 35 | NUM_DAYS_DEVIATION | Number(9,0) | DECIMAL(9) NOT NULL | Number Days of Deviation |
| 36 | LEAD_TIME | Number(3,0) | SMALLINT NOT NULL | Lead Time Days |
| 37 | LEAD_TIME_MAD | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Lead Time Deviation |
| 38 | RECEIPT_UM | Character(3) | VARCHAR2(3) NOT NULL | Receiving UOM |
| 39 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 40 | SHIP_QTY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Quantity Status
1=Passes Quantity Check 2=Over Shipment 3=Under Shipment |
| 41 | SHIP_DATE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Ship Date Status
1=Passes Date Check 2=Early Shipment 3=Late Shipment |
| 42 | PRICE_PO_BSE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Price Base |