DLV_FRT_AET(SQL Table) |
Index Back |
|---|---|
Delivery Freight Temp |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | DELIVERY_ID | Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 4 | FREIGHT_APP | Character(2) | VARCHAR2(2) NOT NULL |
Identifier with regards to which product calculated freight for a delivery
IN=Inventory OM=Order Management |
| 5 | INSERT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
insert flag
Default Value: N |
| 6 | UPDATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Update Prior Operations
Default Value: N |
| 7 | DELETE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Deletion Flag
Default Value: N |
| 8 | COMM_ARRV_DTTM | DateTime(26) | TIMESTAMP | Communicated Arrival Datetime |
| 9 | COMM_SHIP_DTTM | DateTime(26) | TIMESTAMP | Communicated Ship Datetime |
| 10 | FREIGHT_CALC_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Freight Calculate Flag
Default Value: N |
| 11 | FREIGHT_CHARGE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge |
| 12 | FREIGHT_CURRNCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 13 | FRT_CHRG_AUDIT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge |
| 14 | FRT_CHRG_OPEN | Character(1) | VARCHAR2(1) NOT NULL |
Freight can be modified
Y/N Table Edit Default Value: Y |
| 15 | FRT_CHRG_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Freight Charge Override
Y/N Table Edit Default Value: N |
| 16 | FRT_ROLLUP_IND | Character(1) | VARCHAR2(1) NOT NULL |
Freight Rollup Flag
1=Delivery 2=Rollup Default Value: 1 |
| 17 | FRT_REF_NO | Character(30) | VARCHAR2(30) NOT NULL | Freight Reference Number |
| 18 | EXT_SHIP_ID | Character(30) | VARCHAR2(30) NOT NULL | External Shipment Identifier |
| 19 | FRT_SRVC_DEFN | Character(50) | VARCHAR2(50) NOT NULL |
Freight Service Definition
Prompt Table: %EDITTABLE10 |
| 20 | FRT_TYPE_CODE | Character(10) | VARCHAR2(10) NOT NULL |
Freight Type Code
Prompt Table: IN_FRT_DFLT |
| 21 | PRO_NUMBER | Character(40) | VARCHAR2(40) NOT NULL | Pro Number |
| 22 | IN_FRT_USAGE | Character(2) | VARCHAR2(2) NOT NULL |
Indicator of internal or external freight
10=Internal 20=External 30=None 40=Both |
| 23 | RATE_SHOPPED | Character(1) | VARCHAR2(1) NOT NULL |
Delivery is Rate Shopped
Y/N Table Edit Default Value: N |
| 24 | FREIGHT_NET_PRC | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Freight Net Value |
| 25 | FREIGHT_PRC_BASE | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Freight Net Value (base) |
| 26 | FREIGHT_QUANTITY | Number(17,4) | DECIMAL(16,4) NOT NULL | Freight Quantity |
| 27 | FREIGHT_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Volume |
| 28 | FREIGHT_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Weight |
| 29 | OVERRIDE_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Override Volume |
| 30 | OVERRIDE_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Override Weight |
| 31 | TOTAL_NBR_PIECES | Number(6,0) | INTEGER NOT NULL | Total Number of Pieces |