PO_EST_SHIP

#	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	FREIGHT_CHARGE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Freight Charge
5	FREIGHT_CHARGE_BSE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Freight Charge (base)
6	FRT_CHRG_METHOD	Character(2)	VARCHAR2(2) NOT NULL	Freight Charge Method 01=Order Value 02=Weight 03=Volume 04=Order Quantity
7	FRT_CHRG_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Freight Charge Override Y/N Table Edit Default Value: N
8	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
9	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
10	CATEGORY_CD	Character(18)	VARCHAR2(18) NOT NULL	Category Code
11	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
12	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
13	X_VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Third Party Supplier
14	X_VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Third Party Supplier Location
15	VNDR_FRT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Supplier Freight Group
16	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
17	DTTIME_ADDED	DateTime(26)	TIMESTAMP	Date Time Added
18	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.
19	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID