BCT_VMI_HD_EVW(SQL View) |
Index Back |
|---|---|
VMI Interunit Receipt HeaderVMI Interunit Receipt Header |
| SELECT A.EIP_TRANS_SRC , A.EIP_TRANS_SRC_REF , B.EIP_TRANS_SRC_SEQ , A.OPRID , A.DEVICE_ID , B.DEVICE_DTTIME , B.BUSINESS_UNIT , B.RECEIVER_ID , B.SOURCE_BUS_UNIT , B.BUSINESS_UNIT_IN , B.INTERUNIT_ID , B.CARRIER_ID , B.BILL_OF_LADING , B.VMI_OM_BU , B.SHIP_TO_CUST_ID , B.SOLD_TO_CUST_ID , B.IU_REC_ID_GRP_FLG , B.COMPLETE_FLG FROM PS_BCT_DTL B , PS_BCT_CTL A WHERE A.EIP_CTL_ID = B.EIP_CTL_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EIP_TRANS_SRC | Character(30) | VARCHAR2(30) NOT NULL | 08/02/99 NAS: Created the field for MES but it will be owned by Entreprise, they just don't know it yet :-) |
| 2 | EIP_TRANS_SRC_REF | Character(30) | VARCHAR2(30) NOT NULL | Source Reference |
| 3 | EIP_TRANS_SRC_SEQ | Number(15,0) | DECIMAL(15) NOT NULL | Source Transaction Sequence |
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | DEVICE_ID | Character(10) | VARCHAR2(10) NOT NULL | Device ID |
| 6 | DEVICE_DTTIME | DateTime(26) | TIMESTAMP | Device Date Time |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 9 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 10 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 11 | INTERUNIT_ID | Character(10) | VARCHAR2(10) NOT NULL | InterUnit Order ID |
| 12 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |
| 13 | BILL_OF_LADING | Character(30) | VARCHAR2(30) NOT NULL | Specifies a bill of lading number associated with a Receivables item. |
| 14 | VMI_OM_BU | Character(5) | VARCHAR2(5) NOT NULL | OM Business Unit Related to VMI |
| 15 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
| 16 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 17 | IU_REC_ID_GRP_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Interunit Receipt Identification Group Flag
0 = Group by Receiving Business Unit, Receiver ID. (Default)
1 = Group by Receiving Business Unit, Source Business Unit (origination), Interunit ID, Dest Inventory Business Unit.
2 = Receiving Business Unit, Carrier, Bill of Lading
0=Receiver ID 1=Source BU,InterUnit ID,Dest BU 2=Carrier, Bill of Lading Default Value: 0 |
| 18 | COMPLETE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Complete Flag
0=Process Location 1=Pick Line Complete 2=Pick Batch Complete 3=Pick Line as Planned 4=Pick Batch as Planned 5=Process Location - Incomplete 6=Complete Pick - Zero Quantity 7=Complete Pick - Leave Alone 8=Complete Pick - Dft Ship Loc A=Use Defaults B=No Action |