INV_FRT_SHP_VW(SQL View) |
Index Back |
|---|---|
Freight Request Shipment Srvcs |
| SELECT BUSINESS_UNIT , EIP_CTL_ID , SEQ_NBR , TRANSACTION_CODE , LAST_DTTIME , BCT_DET_STATUS , DELIVERY_ID , FRT_SRVC_DEFN , CARRIER_ID , SHIP_TYPE_ID , SERVICE_DESCR , FREIGHT_AMT_TOT , CURRENCY_CD , SHIPPING_WEIGHT , SHIPPING_VOLUME , UNIT_MEASURE_WT , UNIT_MEASURE_VOL , TOTAL_NBR_PIECES , SCHED_DTTM , SCHED_ARRV_DTTM , PRO_NUMBER , EXT_SHIP_ID , ERROR_CODE , ERRORMSG , EIP_TRANS_SRC_SEQ , DEVICE_DTTIME FROM PS_BCT_DTL WHERE TRANSACTION_CODE = '0381' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUIN_NONVW |
| 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 | LAST_DTTIME | DateTime(26) | TIMESTAMP NOT NULL |
Last Date Time
Default Value: %Datetime |
| 6 | BCT_DET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
BCTP Detail Status
0=Open 1=Error 2=Complete 3=Cancel Default Value: 0 |
| 7 | DELIVERY_ID | Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 8 | FRT_SRVC_DEFN | Character(50) | VARCHAR2(50) NOT NULL |
Freight Service Definition
Prompt Table: %EDITTABLE10 |
| 9 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table: CARRIER_EXT_VW |
| 10 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table: SHIP_METHOD |
| 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 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 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
Prompt Table: UNITS_TBL |
| 17 | UNIT_MEASURE_VOL | Character(3) | VARCHAR2(3) NOT NULL |
Volume UOM
Prompt Table: UNITS_TBL |
| 18 | TOTAL_NBR_PIECES | Number(6,0) | INTEGER NOT NULL | Total Number of Pieces |
| 19 | SCHED_DTTM | DateTime(26) | TIMESTAMP | 08/16/01 JNW (CN#PL900-1.0): Added |
| 20 | SCHED_ARRV_DTTM | DateTime(26) | TIMESTAMP | Schedule Arrival Dt/Tm |
| 21 | PRO_NUMBER | Character(40) | VARCHAR2(40) NOT NULL | Pro Number |
| 22 | EXT_SHIP_ID | Character(30) | VARCHAR2(30) NOT NULL | External Shipment Identifier |
| 23 | ERROR_CODE | Character(10) | VARCHAR2(10) NOT NULL | Error Code |
| 24 | ERRORMSG | Character(254) | VARCHAR2(254) NOT NULL | Error Message field |
| 25 | EIP_TRANS_SRC_SEQ | Number(15,0) | DECIMAL(15) NOT NULL | Source Transaction Sequence |
| 26 | DEVICE_DTTIME | DateTime(26) | TIMESTAMP | Device Date Time |