ORD_DFINV_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
2	PICKING_PLAN	Character(3)	VARCHAR2(3) NOT NULL	Picking Plan 01=Fixed Pick Location 03=Default Putaway Location 05=Default Shipment Location 08=Container Option 09=Pick by Date 10=All Available Locations Default Value: 09
3	PICK_PLAN_BY_UOM	Character(1)	VARCHAR2(1) NOT NULL	Order Unit of Measure Y/N Table Edit Default Value: N
4	PICKING_LEAD_DAYS	Number(3,0)	SMALLINT NOT NULL	Picking Lead Days
5	PICKING_LEAD_HRS	Time(15)	TIMESTAMP	Picking Lead Hours
6	PICKING_NOTES	Character(3)	VARCHAR2(3) NOT NULL	Picking Notes 00=None 01=Largest Batch First 02=Smallest Batch First 03=Broken Pallet First Default Value: 03
7	PICKING_DT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Used to determine the Date selection criteria used when submitting jobs to the Picking Plan. 01=Date/Time Range 02=Lead Days/Minutes 03=Today/Until Default Value: 03
8	PICKING_DT_FROM	Date(10)	DATE	Picking Selection From Date
9	PICKING_TIME_FROM	Time(15)	TIMESTAMP	Picking Selection From Time
10	PICKING_DT_TO	Date(10)	DATE	Picking Selection To Date
11	PICKING_TIME_TO	Time(15)	TIMESTAMP	Picking Selection Time To
12	PICKING_SORT	Character(3)	VARCHAR2(3) NOT NULL	Used as the highest level sort parameter for the order lines which appear on the Picking Plan. 01=Item ID 02=Order No 03=Carrier ID 04=Ship To 05=Load ID 06=Location 07=Route 08=Route Stop 09=Priority 10=Ship Via 11=TMS ID 12=Load Stop 13=Freight 14=Customer 15=Address 16=Product ID 17=Parent Product 18=Delivery ID 30=Work Order 31=Task 32=Shop 33=Part Default Value: 02
13	TSE_TRIGGER	Character(1)	VARCHAR2(1) NOT NULL	Perform Validation Y/N Table Edit Default Value: N
14	SOFT_ALLOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Soft Reserve Y/N Table Edit Default Value: N
15	ALLOC_LEAD_DAYS	Number(3,0)	SMALLINT NOT NULL	Reservation Lead Days
16	ALLOC_SORT	Character(1)	VARCHAR2(1) NOT NULL	Final Sort Option D=Date O=Order Nbr P=Priority Default Value: D
17	ATP_LEAD_DAYS	Number(3,0)	SMALLINT NOT NULL	This field determines the window in which an order line can be ATP-reserved. If the scheduled shipment date is within today + ATP lead days, then the order line may be ATP-reserved; if the scheduled shipment date is outside this window, the order line cannot be ATP-reserved.
18	AUTO_DEMD_APPROVE	Character(1)	VARCHAR2(1) NOT NULL	Auto Stock Approval Y/N Table Edit Default Value: N
19	AUTO_BCK_APPROVE	Character(1)	VARCHAR2(1) NOT NULL	Auto Backorder Approval Y/N Table Edit Default Value: N
20	AUTO_PRT_APPROVE	Character(1)	VARCHAR2(1) NOT NULL	Auto Partial Qty Approval Y/N Table Edit Default Value: N
21	PRICE_MARKUP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Price Markup Y/N Table Edit Default Value: N
22	ADHOC_REQ_FLG	Character(1)	VARCHAR2(1) NOT NULL	Create Adhoc Requisitions Y/N Table Edit Default Value: N
23	INTERUNIT_QTY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allow Interunit BackOrders
24	SHIP_PREP	Number(6,0)	INTEGER NOT NULL	KPN 08/21/02: Changed long name of SHIP_PREP from Ship Preparation Time [Min] to Ship Preparation Time (Min)
25	ONLINE_RES_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Online Reservation Flag