BUSINESS_UNITSHIP_CNTR_IDY/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
SHIP_CNTR_VW5(SQL View) |
Index Back |
|---|---|
Ship Cntr Ship ID |
| SELECT A.BUSINESS_UNIT , A.SHIP_CNTR_ID , A.PARENT_SHIP_CNTR , A.OUTER_MOST_CNTR_ID , 'N' , 'N' , A.PRO_NUMBER , A.SHIP_ID , A.CARRIER_ID FROM PS_SHIP_CNTR_HDR A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SHIP_CNTR_ID |
Character(20) | VARCHAR2(20) NOT NULL | Shipping Container ID |
| 3 | PARENT_SHIP_CNTR | Character(20) | VARCHAR2(20) NOT NULL | Parent Shipping Container ID |
| 4 | OUTER_MOST_CNTR_ID | Character(20) | VARCHAR2(20) NOT NULL | Shipping Container ID |
| 5 | LOOSE_STOCK_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Loose Stock Present
Y/N Table Edit Default Value: N |
| 6 | CHILDREN_CNTR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Childern Containers Flag
Y/N Table Edit Default Value: N |
| 7 | PRO_NUMBER | Character(40) | VARCHAR2(40) NOT NULL | Pro Number |
| 8 | SHIP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shipping ID |
| 9 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |