BCT_TMS_INV_VW(SQL View) |
Index Back |
|---|---|
Update TMS loadsBCT_DTL view used to maintain TMS load transactions. |
| SELECT A.BUSINESS_UNIT , A.EIP_CTL_ID , A.SEQ_NBR , A.TRANSACTION_CODE , A.EIP_TRANS_SRC_SEQ , A.LAST_DTTIME , A.BCT_DET_STATUS , A.LOAD_ID , A.TMS_EXT_REF_ID , A.TMS_EXT_REF_LN_NBR , A.TMS_LOAD_STP_NBR , A.CARRIER_ID , A.SHIP_TYPE_ID , A.SCHED_DATE , A.SCHED_TIME , A.SCHED_ARRV_DTTM , A.SHIP_EARLY_DATE , A.SHIP_EARLY_TIME , A.BILL_OF_LADING , A.UPLOAD_PICKED_FLG , A.AUDIT_ACTN , A.INCL_LL_FLG FROM PS_BCT_DTL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUIN_NONVW |
| 2 | EIP_CTL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 3 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 4 | TRANSACTION_CODE | Character(4) | VARCHAR2(4) NOT NULL | Transaction Code |
| 5 | EIP_TRANS_SRC_SEQ | Number(15,0) | DECIMAL(15) NOT NULL | Source Transaction Sequence |
| 6 | LAST_DTTIME | DateTime(26) | TIMESTAMP NOT NULL | Last Date Time |
| 7 | BCT_DET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
BCTP Detail Status
0=Open 1=Error 2=Complete 3=Cancel |
| 8 | LOAD_ID | Character(10) | VARCHAR2(10) NOT NULL | Load ID |
| 9 | TMS_EXT_REF_ID | Character(10) | VARCHAR2(10) NOT NULL |
TMS Reference ID
Prompt Table: IN_TMS_STATUS |
| 10 | TMS_EXT_REF_LN_NBR | Number(7,0) | INTEGER NOT NULL | TMS Line Number |
| 11 | TMS_LOAD_STP_NBR | Number(5,0) | INTEGER NOT NULL | Load Stop Number |
| 12 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table: CARRIER_SHP_VW |
| 13 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table: SHIP_METHOD_VW |
| 14 | SCHED_DATE | Date(10) | DATE | Schedule Date |
| 15 | SCHED_TIME | Time(15) | TIMESTAMP | Schedule Time |
| 16 | SCHED_ARRV_DTTM | DateTime(26) | TIMESTAMP | Schedule Arrival Dt/Tm |
| 17 | SHIP_EARLY_DATE | Date(10) | DATE | Earliest Ship Date |
| 18 | SHIP_EARLY_TIME | Time(15) | TIMESTAMP | Earliest Ship Time |
| 19 | BILL_OF_LADING | Character(30) | VARCHAR2(30) NOT NULL | Specifies a bill of lading number associated with a Receivables item. |
| 20 | UPLOAD_PICKED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Upload After Picking
Y/N Table Edit |
| 21 | AUDIT_ACTN | Character(1) | VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values |
| 22 | INCL_LL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Include Line Level
Y/N Table Edit |