BUSINESS_UNITSHIP_IDPrompt Table: SHIP_CNTR_VW2
Y/N Table Edit
Default Value: N
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
SHIPCNT_INV_TMP(SQL Table) |
Index Back |
|---|---|
Shipping Container Temp TblThis table is used to temporarily hold shipping container ids for validation in the shipping panels. The panel does not save data to the record, so there should never be data living in this record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SHIP_ID |
Character(10) | VARCHAR2(10) NOT NULL | Shipping ID |
| 3 | SHIP_CNTR_ID | Character(20) | VARCHAR2(20) NOT NULL |
Shipping Container ID
Prompt Table: SHIP_CNTR_VW2 |
| 4 | INCLUDE_SHIP_ID | Character(1) | VARCHAR2(1) NOT NULL |
Include in Ship ID
Y/N Table Edit Default Value: N |
| 5 | SHIPPED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Shipped
B=Both N=No Y=Yes Y/N Table Edit Default Value: N |
| 6 | ROW_NUMBER | Number(3,0) | SMALLINT NOT NULL | Row_Number |