| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 2 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 3 |
SHOW_SETID |
Character(1) |
VARCHAR2(1) NOT NULL |
Show SetID Summary
|
| 4 |
DETAIL_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Detail Level
|
| 5 |
DS_NW_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Network Flag
|
| 6 |
DS_NETWORK_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Distribution Network Code
|
| 7 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 8 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
|
| 9 |
SHIPTO_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
ShipTo SetID
|
| 10 |
DS_NW_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Distribution Network SetID
|
| 11 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 12 |
BU_NODE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit Nodes Present
|