TRFT_SET_KEYVAL

(SQL Table)
 Index Back

Freight Set Key values

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 TRFT_SET_ID Character(10) VARCHAR2(10) NOT NULL Rule Cd
3 TRFT_FEATURE_CD Character(1) VARCHAR2(1) NOT NULL Feature Code
1=Freight & Transportation Lead
2=Backorder Rule Defaulting
3=Supply Sources
4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
5 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

Prompt Table: SP_BUIN_NONVW

6 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
7 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

Prompt Table: CARRIER_ID

8 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID
9 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
10 COMMODITY_CD Character(10) VARCHAR2(10) NOT NULL Commodity Code
11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
12 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group
13 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
14 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code
15 HARMONIZED_CD Character(14) VARCHAR2(14) NOT NULL Harmonized Code
16 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
17 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
18 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
19 ORDER_GRP Character(6) VARCHAR2(6) NOT NULL Order Group
20 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group
21 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
22 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
23 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.
24 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
25 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code
26 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
27 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
28 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Prompt Table: SHIP_METHOD

29 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method
30 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
31 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code
32 STATE Character(6) VARCHAR2(6) NOT NULL State
33 TRFT_KEY_CD Character(50) VARCHAR2(50) NOT NULL Select Key Fields
34 TRFT_KEY_VALUE1 Character(50) VARCHAR2(50) NOT NULL Freight Key value 1
35 TRFT_KEY_VALUE2 Character(50) VARCHAR2(50) NOT NULL Freight Key value 2
36 TRFT_KEY_VALUE3 Character(50) VARCHAR2(50) NOT NULL Freight Key value 3
37 TRFT_KEY_VALUE4 Character(50) VARCHAR2(50) NOT NULL Freight Key value 4
38 TRFT_KEY_VALUE5 Character(50) VARCHAR2(50) NOT NULL Freight Key value 5
39 TRFT_KEY_VALUE6 Character(50) VARCHAR2(50) NOT NULL Freight Key value 6
40 TRFT_KEY_VALUE7 Character(50) VARCHAR2(50) NOT NULL Freight Key value 7
41 TRFT_KEY_VALUE8 Character(50) VARCHAR2(50) NOT NULL Freight Key value 8
42 TRFT_KEY_VALUE9 Character(50) VARCHAR2(50) NOT NULL Freight Key value 9
43 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
44 VNDR_FRT_GROUP Character(10) VARCHAR2(10) NOT NULL Supplier Freight Group
45 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
46 X_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Third Party Supplier
47 X_VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Third Party Supplier Location
48 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
49 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.
50 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID