ORD_HOLD_AUDIT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	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
3	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
4	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
5	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
6	SHIP_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Ship from INV BU
7	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
8	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: BU_ITM_INV_VW2
9	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
10	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.
11	HOLD_CD	Character(6)	VARCHAR2(6) NOT NULL	Hold Code
12	HOLD_ACTION	Character(2)	VARCHAR2(2) NOT NULL	Hold action to determine what the action was taken against the hold to cause an audit record to be written 10=Add Hold 20=Apply Hold 30=Release Hold 40=Release/Delete Hold 50=Modify Hold 60=Delete Hold
13	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
14	STATUS_DT	Date(10)	DATE NOT NULL	Status Date Default Value: %date
15	SYSTEM_MAINTAINED	Character(1)	VARCHAR2(1) NOT NULL	System Maintained Y/N Table Edit Default Value: N
16	HOLD_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Hold Level A=Arrival Date (sch) B=Bill To (hdr) C=Customer (hdr) D=No VAT Country Ship From F=Configurator Hold G=Freight H=Ship To (sch) K=No Prod Kit Comps (line) M=Min/Max Margin (sch) N=Min Selling Price (sch) O=SCN Line Max Amt (line) P=Product (line) Q=Min/Max Quantity (line) R=Credit Check (all) S=Sold To (hdr) T=Price Discrepancy (Sch) U=Cancel Hold V=VMI Order W=Customer Pick-up X=SCN Min/Max Qty (line) Y=FSS Customer Z=FSS Order
17	PASS_HOLD_LEVEL	Character(4)	VARCHAR2(4) NOT NULL	Hold Code Level CUST=Customer Hold HDR=Header Hold LINE=Line Hold PROD=Product Hold SCH=Schedule Hold SYS=System Holds
18	PASS_HOLD_CD	Character(6)	VARCHAR2(6) NOT NULL	System Hold Code
19	MESSAGE_CD	Character(6)	VARCHAR2(6) NOT NULL	Message Code
20	REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code
21	ACTIVE_HOLD_DTTM	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.
22	PROD_COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product Component ID
23	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID