OM_TRFTCHRG_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
4	SHIP_ID_EST	Character(10)	VARCHAR2(10) NOT NULL	Estimated Ship ID
5	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
6	SOURCE_CODE	Character(2)	VARCHAR2(2) NOT NULL	8/5/97 lee - inactivated source code 4 - service 1=Make 2=Buy 3=Expense 4=Service 5=Floor Stock 6=Planning
7	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
8	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID
9	CARRIER_ID_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Carrier ID
10	COMMODITY_CD	Character(10)	VARCHAR2(10) NOT NULL	Commodity Code
11	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
14	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group
15	FREIGHT_CHARGE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Freight Charge
16	FREIGHT_CHARGE_BSE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Freight Charge (base)
17	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code
18	FREIGHT_TERMS_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Freight Terms Code
19	FRT_BREAK_ID	Number(10,0)	DECIMAL(10) NOT NULL	Frt Break ID
20	FRT_CHRG_METHOD	Character(2)	VARCHAR2(2) NOT NULL	Freight Charge Method 01=Order Value 02=Weight 03=Volume 04=Order Quantity
21	HARMONIZED_CD	Character(14)	VARCHAR2(14) NOT NULL	Harmonized Code
22	INV_ITEM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	Item Group
23	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
24	LOAD_ID	Character(10)	VARCHAR2(10) NOT NULL	Load ID
25	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
26	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Product Group
27	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
28	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.
29	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.
30	SCHED_SHIP_DTTM	DateTime(26)	TIMESTAMP	Schedule Ship Datetime
31	SHIP_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Ship from INV BU
32	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
33	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
34	SHIP_TYPE_ID_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Shipping Method
35	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
36	TRFT_RULE_CD	Character(10)	VARCHAR2(10) NOT NULL	Arbitration Rule Code.
37	TRFT_SET_ID	Character(10)	VARCHAR2(10) NOT NULL	Rule Cd
38	DTTIME_ADDED	DateTime(26)	TIMESTAMP	Date Time Added
39	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.
40	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID