IN_DELIVERY_FRT(SQL Table) |
Index Back |
|---|---|
Delivery freight dataFreight data at the delivery level. For each delivery, there will be at most one row of data for each application that calculates freight for the delivery. |
| # | 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 | FREIGHT_APP |
Character(2) | VARCHAR2(2) NOT NULL |
Identifier with regards to which product calculated freight for a delivery
IN=Inventory OM=Order Management Default Value: IN |
| 4 | COMM_ARRV_DTTM | DateTime(26) | TIMESTAMP | Communicated Arrival Datetime |
| 5 | COMM_SHIP_DTTM | DateTime(26) | TIMESTAMP | Communicated Ship Datetime |
| 6 | FREIGHT_CALC_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Freight Calculate Flag
Default Value: N |
| 7 | FREIGHT_CHARGE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge |
| 8 | FREIGHT_CURRNCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | FRT_CHRG_AUDIT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge |
| 10 | FRT_CHRG_OPEN | Character(1) | VARCHAR2(1) NOT NULL |
Freight can be modified
Y/N Table Edit Default Value: Y |
| 11 | FRT_CHRG_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Freight Charge Override
Y/N Table Edit Default Value: N |
| 12 | FRT_ROLLUP_IND | Character(1) | VARCHAR2(1) NOT NULL |
Freight Rollup Flag
1=Delivery 2=Rollup Default Value: 1 |
| 13 | FRT_REF_NO | Character(30) | VARCHAR2(30) NOT NULL | Freight Reference Number |
| 14 | EXT_SHIP_ID | Character(30) | VARCHAR2(30) NOT NULL | External Shipment Identifier |
| 15 | FRT_SRVC_DEFN | Character(50) | VARCHAR2(50) NOT NULL |
Freight Service Definition
Prompt Table: %EDITTABLE10 |
| 16 | FRT_TYPE_CODE | Character(10) | VARCHAR2(10) NOT NULL |
Freight Type Code
Prompt Table: IN_FRT_DFLT |
| 17 | PRO_NUMBER | Character(40) | VARCHAR2(40) NOT NULL | Pro Number |
| 18 | IN_FRT_USAGE | Character(2) | VARCHAR2(2) NOT NULL |
Indicator of internal or external freight
10=Internal 20=External 30=None 40=Both |
| 19 | RATE_SHOPPED | Character(1) | VARCHAR2(1) NOT NULL |
Delivery is Rate Shopped
Y/N Table Edit Default Value: N |
| 20 | FREIGHT_NET_PRC | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Freight Net Value |
| 21 | FREIGHT_PRC_BASE | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Freight Net Value (base) |
| 22 | FREIGHT_QUANTITY | Number(17,4) | DECIMAL(16,4) NOT NULL | Freight Quantity |
| 23 | FREIGHT_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Volume |
| 24 | FREIGHT_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Weight |
| 25 | OVERRIDE_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Override Volume |
| 26 | OVERRIDE_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Override Weight |
| 27 | TOTAL_NBR_PIECES | Number(6,0) | INTEGER NOT NULL | Total Number of Pieces |