FREIGHT_TERMS

(SQL Table)
 Index Back

Freight Terms Codes Definition

This table holds the freight terms and FOB information associated with a shipment. Freight terms may be assigned to a customer, product or an order.

  • Related Language Record: FRGHT_TRMS_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 TITLE_PASSAGE Character(1) VARCHAR2(1) NOT NULL Title Passage
    B=Buyer's Destination-Ship To
    I=Intermediate Consignee
    S=Seller's Origination-Ship From

    Default Value: B

    6 CIF Character(2) VARCHAR2(2) NOT NULL Cost/Insurance/Freight Paid By
    B=Buyer
    S=Seller

    Default Value: S

    7 IST_DELIVERY_TRM1 Character(3) VARCHAR2(3) NOT NULL Delivery Terms 1
    CFR=Cost and Freight
    CIF=Cost, Insurance, Freight
    CIP=Carriage and Insurance Paid To
    CPT=Carriage Paid To
    DAF=Delivered at Frontier
    DDP=Delivered Duty Paid
    DDU=Delivered Duty Unpaid
    DEQ=Delivered Ex-Quay
    DES=Delivered Ex-Ship
    EXW=Ex-Works
    FAS=Free Alongside Ship
    FCA=Franco Carrier
    FOB=Free on Board
    XXX=Other Delivery Terms