TMS_ORDER_EVW(SQL View) |
Index Back |
|---|---|
TMS Upload Order LevelTMS Upload Order Level |
| SELECT EIP_TRANS_SRC_SEQ ,DEVICE_DTTIME ,TMS_EXT_REF_ID ,TMS_LOAD_STP_NBR ,SHIP_EARLY_DATE ,SHIP_EARLY_TIME ,SCHED_DATE ,SCHED_TIME ,SCHED_ARRV_DTTM ,INCL_LL_FLG FROM PS_BCT_DTL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EIP_TRANS_SRC_SEQ | Number(15,0) | DECIMAL(15) NOT NULL | Source Transaction Sequence |
| 2 | DEVICE_DTTIME | DateTime(26) | TIMESTAMP | Device Date Time |
| 3 | TMS_EXT_REF_ID | Character(10) | VARCHAR2(10) NOT NULL | TMS Reference ID |
| 4 | TMS_LOAD_STP_NBR | Number(5,0) | INTEGER NOT NULL | Load Stop Number |
| 5 | SHIP_EARLY_DATE | Date(10) | DATE | Earliest Ship Date |
| 6 | SHIP_EARLY_TIME | Time(15) | TIMESTAMP | Earliest Ship Time |
| 7 | SCHED_DATE | Date(10) | DATE | Schedule Date |
| 8 | SCHED_TIME | Time(15) | TIMESTAMP | Schedule Time |
| 9 | SCHED_ARRV_DTTM | DateTime(26) | TIMESTAMP | Schedule Arrival Dt/Tm |
| 10 | INCL_LL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Include Line Level |