PO_FRT_CHRG

(SQL Table)
Index Back

PO Estimated Shipments

PO Estimated Shipments

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 SHIP_ID_EST Character(10) VARCHAR2(10) NOT NULL Estimated Ship ID
4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
6 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
7 FREIGHT_CHARGE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge
8 FREIGHT_CHARGE_BSE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge (base)
9 FRT_BREAK_ID Number(10,0) DECIMAL(10) NOT NULL Frt Break ID
10 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity
11 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
12 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
13 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
14 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
15 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
16 X_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Third Party Supplier
17 X_VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Third Party Supplier Location
18 VNDR_FRT_GROUP Character(10) VARCHAR2(10) NOT NULL Supplier Freight Group
19 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
20 TRFT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Arbitration Rule Code.
21 TRFT_SET_ID Character(10) VARCHAR2(10) NOT NULL Rule Cd
22 DTTIME_ADDED DateTime(26) TIMESTAMP Date Time Added
23 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
24 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID