EIP_CTL_IDGRP_SEQ_NBRDTL_SEQ_NBRBUSINESS_UNITDELIVERY_IDFRT_SRVC_DEFN0=Open
1=Error
2=Complete
3=Cancel
1=Service Request
2=Service Reply
INV_FRT_DTL_VW(SQL View) |
Index Back |
|---|
| SELECT A.EIP_CTL_ID , 0 , 0 , A.BUSINESS_UNIT , A.DELIVERY_ID , ' ' , A.BCT_DET_STATUS , A.CARRIER_ID , A.SHIP_TYPE_ID , ' ' , ' ' , 0 , A.PRO_NUMBER , 0 , 0 , A.UNIT_MEASURE_WT , ' ' , 0 , A.SCHED_ARRV_DTTM , ' ' , ' ' , ' ' FROM %Table(BCT_DTL) A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EIP_CTL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 2 | GRP_SEQ_NBR |
Number(10,0) | DECIMAL(10) NOT NULL | Sequence used to uniquely identify a row in the Fulfillment Group stage table. |
| 3 | DTL_SEQ_NBR |
Number(10,0) | DECIMAL(10) NOT NULL | Sequence used to uniquely identify a row in the Fulfillment Details stage table. |
| 4 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | DELIVERY_ID |
Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 6 | FRT_SRVC_DEFN |
Character(50) | VARCHAR2(50) NOT NULL | Freight Service Definition |
| 7 | BCT_DET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
BCTP Detail Status
0=Open 1=Error 2=Complete 3=Cancel |
| 8 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |
| 9 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
| 10 | SERVICE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Sevice type
1=Service Request 2=Service Reply |
| 11 | SERVICE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Service Description |
| 12 | FREIGHT_AMT_TOT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 13 | PRO_NUMBER | Character(40) | VARCHAR2(40) NOT NULL | Pro Number |
| 14 | SHIPPING_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Shipping Weight |
| 15 | SHIPPING_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Shipping Volume |
| 16 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL | Weight UOM |
| 17 | UNIT_MEASURE_VOL | Character(3) | VARCHAR2(3) NOT NULL | Volume UOM |
| 18 | TOTAL_PIECES | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Pieces |
| 19 | SCHED_ARRV_DTTM | DateTime(26) | TIMESTAMP | Schedule Arrival Dt/Tm |
| 20 | EXT_SHIP_ID | Character(30) | VARCHAR2(30) NOT NULL | External Shipment Identifier |
| 21 | ERROR_CODE | Character(10) | VARCHAR2(10) NOT NULL | Error Code |
| 22 | ERRORMSG | Character(254) | VARCHAR2(254) NOT NULL | Error Message field |