INV_FRT_HDR_VW(SQL View) |
Index Back |
|---|---|
Freight Request Header |
| SELECT A.BUSINESS_UNIT , A.EIP_CTL_ID , A.SEQ_NBR , A.TRANSACTION_CODE , A.LAST_DTTIME , A.BCT_DET_STATUS , A.DELIVERY_ID , A.FRT_ROLLUP_IND_RUN , A.MANIFEST_FLG , A.RESPONSE_CODE , A.RESPONSE_DESCR , A.ERROR_CODE , A.ERRORMSG , B.EIP_TRANS_SRC , B.EIP_TRANS_SRC_REF , A.EIP_TRANS_SRC_SEQ , A.DEVICE_DTTIME , A.COUNTING_EVENT_ID FROM PS_BCT_DTL A , PS_BCT_CTL B WHERE A.TRANSACTION_CODE = '0380' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.EIP_CTL_ID = B.EIP_CTL_ID |
| # | 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
Prompt Table: IN_BCT_DLV_VW |
| 8 | FRT_ROLLUP_IND_RUN | Character(1) | VARCHAR2(1) NOT NULL |
Indicates to batch run how the freight will be rolled up.
1=Delivery Freight 2=Rollup Packages/Containers 3=Default from Delivery |
| 9 | MANIFEST_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Manifest
Y/N Table Edit |
| 10 | RESPONSE_CODE | Character(10) | VARCHAR2(10) NOT NULL | Response Status Code |
| 11 | RESPONSE_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Response Status Description |
| 12 | ERROR_CODE | Character(10) | VARCHAR2(10) NOT NULL | Error Code |
| 13 | ERRORMSG | Character(254) | VARCHAR2(254) NOT NULL | Error Message field |
| 14 | 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 :-) |
| 15 | EIP_TRANS_SRC_REF | Character(30) | VARCHAR2(30) NOT NULL | Source Reference |
| 16 | EIP_TRANS_SRC_SEQ | Number(15,0) | DECIMAL(15) NOT NULL | Source Transaction Sequence |
| 17 | DEVICE_DTTIME | DateTime(26) | TIMESTAMP | Device Date Time |
| 18 | COUNTING_EVENT_ID | Number(15,0) | DECIMAL(15) NOT NULL | Counting Event ID |