EST_SHIP_IN_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SHIP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shipping ID Prompt Table: SHIP_HDR_INV
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	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
6	SHIP_DATE	Date(10)	DATE	Item Shipping Date
7	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID
8	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
9	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
10	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
11	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
12	FRT_CHRG_METHOD	Character(2)	VARCHAR2(2) NOT NULL	Freight Charge Method 01=Order Value 02=Weight 03=Volume 04=Order Quantity
13	FRT_CHRG_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Freight Charge Override
14	COMMODITY_CD	Character(10)	VARCHAR2(10) NOT NULL	Commodity Code
15	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code
16	HARMONIZED_CD	Character(14)	VARCHAR2(14) NOT NULL	Harmonized Code
17	INV_ITEM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	Item Group
18	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
19	LOAD_ID	Character(10)	VARCHAR2(10) NOT NULL	Load ID
20	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
21	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.
22	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
23	STATE	Character(6)	VARCHAR2(6) NOT NULL	State