PROCESS_INSTANCEBUSINESS_UNIT_PORTV_IDRTV_LN_NBRRTV_DISTRIB_NUMINV_ITEM_IDIST_DISP10_TAO(SQL Table) |
Index Back |
|---|---|
Intrastat Dispatch 10 Temp |
| # | 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_PO |
Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 3 | RTV_ID |
Character(10) | VARCHAR2(10) NOT NULL | Return To Vendor ID |
| 4 | RTV_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Return To Vendor Line |
| 5 | RTV_DISTRIB_NUM |
Number(5,0) | INTEGER NOT NULL | RTV Distribution Number |
| 6 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |