BUSINESS_UNIT0=Receiver ID
1=Source BU,InterUnit ID,Dest BU
2=Carrier, Bill of Lading
Default Value: 0
BCT_IURV_EN_EVW(SQL View) |
Index Back |
|---|---|
BCT InterUnit Receiving |
| SELECT A.BUSINESS_UNIT , A.DEVICE_DTTIME , A.RECEIVER_ID , B.OPRID , B.DEVICE_ID , A.SOURCE_BUS_UNIT , A.CARRIER_ID , A.BILL_OF_LADING , A.BUSINESS_UNIT_IN , A.INTERUNIT_ID , A.IU_REC_ID_GRP_FLG FROM PS_BCT_DTL A , PS_BCT_CTL B 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 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | DEVICE_DTTIME | DateTime(26) | TIMESTAMP | Device Date Time |
| 3 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 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 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 7 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |
| 8 | BILL_OF_LADING | Character(30) | VARCHAR2(30) NOT NULL | Specifies a bill of lading number associated with a Receivables item. |
| 9 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 10 | INTERUNIT_ID | Character(10) | VARCHAR2(10) NOT NULL | InterUnit Order ID |
| 11 | 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 |