BCT_SHM3_INV_VW(SQL View) |
Index Back |
|---|---|
BCT TSE Misc Shipping ViewThis view is used to edit the BCT DTL table for Misc Shipping transactions 622 and 626 (Associate and Deassociate Shipping Cntr using storage containers and the demand key) /* 06/22/04 PWF Change sched line no to sched line nbr */ |
| SELECT BUSINESS_UNIT , EIP_CTL_ID , SEQ_NBR , TRANSACTION_CODE , LAST_DTTIME , BCT_DET_STATUS , INV_ITEM_ID , CONTAINER_ID , SHIP_CNTR_ID , DEMAND_SOURCE , SOURCE_BUS_UNIT , ORDER_NO , ORDER_INT_LINE_NO , SCHED_LINE_NBR , DEMAND_LINE_NO , 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 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MST_ITM_PRPT_VW |
| 8 | CONTAINER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Container ID
Prompt Table: CNTR_ID_INV |
| 9 | SHIP_CNTR_ID | Character(20) | VARCHAR2(20) NOT NULL | Shipping Container ID |
| 10 | DEMAND_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Demand Source
IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order |
| 11 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 12 | ORDER_NO | Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 13 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
| 14 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 15 | DEMAND_LINE_NO | Number(4,0) | SMALLINT NOT NULL | Demand Line No |
| 16 | GRP_SEQ_NBR | Number(10,0) | DECIMAL(10) NOT NULL | Sequence used to uniquely identify a row in the Fulfillment Group stage table. |
| 17 | DTL_SEQ_NBR | Number(10,0) | DECIMAL(10) NOT NULL | Sequence used to uniquely identify a row in the Fulfillment Details stage table. |
| 18 | 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. |