FRT_TRMS_IBU_VW

(SQL View)
 Index Back

Freight Terms Codes by IBU

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.

select setid, freight_terms, descr, descrshort, title_passage, cif from PS_FREIGHT_TERMS

  • Related Language Record: FRT_TRMSVW_LNG

    • # 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: BD

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

    Default Value: S