BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW
LOAD_IDDefault Value: NEXT
Prompt Table: LOAD_AN_VW
Prompt Table: CARRIER_ID
Prompt Table: SHIP_METHOD
C=Closed
O=Open
S=Shipped
Default Value: O
LOAD_INV(SQL Table) |
Index Back |
|---|---|
Load Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
| 2 | LOAD_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Load ID
Default Value: NEXT Prompt Table: LOAD_AN_VW |
| 3 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table: CARRIER_ID |
| 4 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table: SHIP_METHOD |
| 5 | SCHED_DATE | Date(10) | DATE | Schedule Date |
| 6 | SCHED_TIME | Time(15) | TIMESTAMP | Schedule Time |
| 7 | LOAD_ID_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Load Status
C=Closed O=Open S=Shipped Default Value: O |