BUSINESS_UNITDELIVERY_ID1=Delivery Freight
2=Rollup Packages/Containers
3=Default from Delivery
Default Value: 3
IN_IFRT_HDR_EC(SQL Table) |
Index Back |
|---|---|
Inbound Freight HeaderInbound freight header segment |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | DELIVERY_ID |
Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 3 | 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 Default Value: 3 |
| 4 | MANIFEST_FLG | Character(1) | VARCHAR2(1) NOT NULL | Manifest |
| 5 | RESPONSE_CODE | Character(10) | VARCHAR2(10) NOT NULL | Response Status Code |
| 6 | RESPONSE_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Response Status Description |
| 7 | ERROR_CODE | Character(10) | VARCHAR2(10) NOT NULL | Error Code |
| 8 | ERRORMSG | Character(254) | VARCHAR2(254) NOT NULL | Error Message field |
| 9 | 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 :-) |
| 10 | EIP_TRANS_SRC_REF | Character(30) | VARCHAR2(30) NOT NULL | Source Reference |
| 11 | EIP_TRANS_SRC_SEQ | Number(15,0) | DECIMAL(15) NOT NULL | Source Transaction Sequence |
| 12 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 13 | DEVICE_DTTIME | DateTime(26) | TIMESTAMP | Device Date Time |