IN_SHP_CNTR_FRT

(SQL Table)
Index Back

Ship Container Freight

Ship container freight record. This will apply only to "outer most" containers.

# 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 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID

Prompt Table: SHIP_CNTR_HDR

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 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
5 FREIGHT_CURRNCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
6 FRT_CHRG_AUDIT Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge
7 FRT_CHRG_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Freight Charge Override

Y/N Table Edit

Default Value: N

8 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
9 FRT_REF_NO Character(30) VARCHAR2(30) NOT NULL Freight Reference Number
10 EXT_PKG_ID Character(30) VARCHAR2(30) NOT NULL External Packaging ID