IN_FL_MSR_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
3	DUMMY_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Dummy Field for Hiding Groups
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	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
6	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
7	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
8	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
9	ORDER_INT_LINE_NO1	Number(5,0)	INTEGER NOT NULL	Order Line
10	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
11	SCHED_LINE_NBR1	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
12	DTL_SEQ_NBR	Number(10,0)	DECIMAL(10) NOT NULL	Sequence used to uniquely identify a row in the Fulfillment Details stage table.
13	BCKORDR_CNCL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Cancel Backorder N=Cancel Backorder No Y=Cancel Backorder Yes
14	PARTIAL_QTY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Partial Qtys Can Ship
15	PARTIAL_ORDER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Partial Orders Can Ship N=No Y=Yes
16	IN_LINE_BO_RULE	Character(10)	VARCHAR2(10) NOT NULL	Line Backorder Rule
17	IN_LINE_RESV_RULE	Character(10)	VARCHAR2(10) NOT NULL	Line Reservation Rule
18	IN_LN_RESV_BO_RULE	Character(10)	VARCHAR2(10) NOT NULL	Line Reservation - Backorder
19	IN_ORDER_RESV_RULE	Character(10)	VARCHAR2(10) NOT NULL	Order Reservation Rule
20	ALLOW_SUB_ITEM_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate whether item substitutions are allowed on the order schedule.
21	ALLOW_OVERPICK_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate whether or not overpicking is allowed for a customer or business unit.
22	MAX_PICK_TOLERANCE	Number(6,2)	DECIMAL(5,2) NOT NULL	Used to indicate the allowable percentage of overshipment for a customer or business unit.
23	PRICE_MARKUP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Price Markup
24	AUTO_DEMD_APPROVE	Character(1)	VARCHAR2(1) NOT NULL	Auto Stock Approval
25	SOFT_ALLOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Soft Reserve
26	IN_NSFT_RSV_ST_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates whether non-soft-reserved items should be added to the demand table in an Unfulfilled or Releasable state. 0=Unfulfilled 1=Releasable
27	USE_ROUTE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Determines whether route functionality will be used for a business unit.
28	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
29	GL_BU_DISPLAY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Display Destination GL BU
30	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
31	IU_METHOD	Character(1)	VARCHAR2(1) NOT NULL	InterUnit Method D=Direct I=Indirect P=Pairs
32	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
33	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).