IN_RLS_DSUB_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PROCESSING_GROUP	Number(10,0)	DECIMAL(10) NOT NULL	A group of data to be processed which may be smaller than the group of data identified by the run request. When processing, if the Pass-through Level is greater than the specified Processing Level, the Processing Group should be expanded to include all data at the Pass-through Level.
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUIN_NONVW
4	DEMAND_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Demand Source IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order
5	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit Prompt Table: SP_BU_FS_NONVW
6	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
7	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
8	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
9	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: BU_ITM_INV_VW2
10	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
11	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 0
12	SUB_ITM_ID	Character(18)	VARCHAR2(18) NOT NULL	11/30/99 RML Added label "Substitute"
13	SUB_PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	03/30/99 laj...CN#EN800-1.0 This field was "cloned" for BOM mass maintenance. Any field attribute changes here need also to be to done to en_new_sub_pri_nbr.
14	ITEM_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Item Description
15	QTY_TO_REL_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Field used to determine how much Qty needs to be Allocated at the Physical Inventory level - Base
16	QTY_SUB_CONV	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Field used to determine how much Qty needs to be Allocated at the Physical Inventory level - Base
17	QTY_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Base Quantity
18	QTY_DPI_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Field used to determine how much Qty needs to be Allocated at the Physical Inventory level - Base
19	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: INV_ORDR_UOM_VW
20	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
21	CONVERSION_RATE	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Conversion Rate
22	QTY_PRECISION	Character(1)	VARCHAR2(1) NOT NULL	Quantity Precision D=Decimal W=Whole Nbr
23	IN_UOM_ERROR	Character(1)	VARCHAR2(1) NOT NULL	UOM Error 1=OrdQty: Round Down to 0 2=OrdQty: Input Mod-Auto<>1 3=OrdQty:Truncate to 0 4=OrdQty: Input Modified - Error 5=Pick Location UOM Error 6=Substitute UOM Error N=No UOM Errors Default Value: N
24	LOT_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Lot Control N=N Y=Y
25	SERIAL_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Serial Control N=N Y=Y
26	SHIP_SERIAL_CNTRL	Character(1)	VARCHAR2(1) NOT NULL	Shipping Serial Control
27	DESTIN_BU	Character(5)	VARCHAR2(5) NOT NULL	Destination Unit
28	ORIG_INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Used to identify the original item ordered, in case an item substitution has taken place.
29	MSGSET	Number(5,0)	INTEGER NOT NULL	Message Set Number
30	MSGNUM	Number(5,0)	INTEGER NOT NULL	Message Number
31	PROMISE_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Order Promise Option 2=Perform ATP Reservations
32	STAGED_DATE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Staged Date Control N=Staged Date Tracking OFF Y=Staged Date Tracking ON