RF_ITEM_NODE(SQL Table) |
Index Back |
|---|---|
Item NodeThis record includes distribution and ship-to information about an item. |
| # | 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 | This field is used to store the value of SetID on various setup tables. |
| 3 | SHOW_SETID | Character(1) | VARCHAR2(1) NOT NULL | Flag indicating whether or not to show the setid when requesting Inventory item balances. |
| 4 | DETAIL_LEVEL | Character(1) | VARCHAR2(1) NOT NULL | Detail level for item balance inquiries. |
| 5 | DS_NW_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Distribution network flag used in Inventory item balance request. |
| 6 | DS_NETWORK_CODE | Character(6) | VARCHAR2(6) NOT NULL | Distribution Network code - from ASN EIP |
| 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 identification number from Inventory. |
| 9 | SHIPTO_SETID | Character(5) | VARCHAR2(5) NOT NULL | Setid corresponding to the ship-to from Inventory. |
| 10 | DS_NW_SETID | Character(5) | VARCHAR2(5) NOT NULL | Distribution network setid used in Inventory item balance request. |
| 11 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 12 | BU_NODE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether Business Unit Segment is being sent as part of the Item Balance Inquiry to SCM
Default Value: N |