BUSINESS_UNITEIP_CTL_IDSEQ_NBR0=Open
1=Error
2=Complete
3=Cancel
Prompt Table: CNTR_ID_INV
BCT_SHM4_INV_VW(SQL View) |
Index Back |
|---|---|
BCT TSE Misc Shipping ViewThis view is used to edit the BCT DTL table for Misc Shipping transactions 623 and 627 (Associate and Deassociate Shipping Cntr using storage containers and pick batch) |
| SELECT BUSINESS_UNIT , EIP_CTL_ID , SEQ_NBR , TRANSACTION_CODE , LAST_DTTIME , BCT_DET_STATUS , CONTAINER_ID , PICK_BATCH_ID , PICKLIST_LINE_NO , SHIP_CNTR_ID , 0 , 0 , 0 FROM PS_BCT_DTL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 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 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP NOT NULL | Date Timestamp |
| 6 | BCT_DET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
BCTP Detail Status
0=Open 1=Error 2=Complete 3=Cancel |
| 7 | CONTAINER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Container ID
Prompt Table: CNTR_ID_INV |
| 8 | PICK_BATCH_ID | Number(10,0) | DECIMAL(10) NOT NULL | Pick Batch ID |
| 9 | PICKLIST_LINE_NO | Number(7,0) | INTEGER NOT NULL | Pick List Sorting Line Number |
| 10 | SHIP_CNTR_ID | Character(20) | VARCHAR2(20) NOT NULL | Shipping Container ID |
| 11 | GRP_SEQ_NBR | Number(10,0) | DECIMAL(10) NOT NULL | Sequence used to uniquely identify a row in the Fulfillment Group stage table. |
| 12 | DTL_SEQ_NBR | Number(10,0) | DECIMAL(10) NOT NULL | Sequence used to uniquely identify a row in the Fulfillment Details stage table. |
| 13 | LLS_SEQ_NBR | Number(10,0) | DECIMAL(10) NOT NULL | Sequence used to uniquely identify a row in the Fulfillment Location / :pt / Serial stage table. |