INSTALLATION_OM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	STATUS_DT	Date(10)	DATE	Status Date
3	CB_PROCESS	Character(1)	VARCHAR2(1) NOT NULL	Process Claimback Y/N Table Edit Default Value: N
4	COMMIT_BATCH	Number(6,0)	INTEGER NOT NULL	Commit Batch
5	ESTORE_BASE_IMGDIR	Character(254)	VARCHAR2(254) NOT NULL	EStore Base Image Directory
6	HWB_MAX_LINES	Number(5,0)	INTEGER NOT NULL	Maximum Hold Workbench Rows Default Value: 100
7	HWB_MAX_SRC_DOCS	Number(5,0)	INTEGER NOT NULL	Maximum Online Source Creation Default Value: 100
8	MAX_LINES_SCROLL	Number(5,0)	INTEGER NOT NULL	Maximum Lines Displayed Default Value: 50
9	MAX_SCHEDS_SCROLL	Number(5,0)	INTEGER NOT NULL	Maximum Schedules Per Line Default Value: 10
10	MAX_SOURCE_LINES	Number(5,0)	INTEGER NOT NULL	Maximum Source of Supply Rows Default Value: 100
11	OM_BASE_IMG_DIR	Character(254)	VARCHAR2(254) NOT NULL	OM Base Image Directory
12	OM_MAX_PRC_ROWS	Number(5,0)	INTEGER NOT NULL	This field is used to determine the maximum number of rows to do on-line pricing for Order Management. Default Value: 1000
13	PROC_FTR_SECURITY	Character(1)	VARCHAR2(1) NOT NULL	Process Feature Security Y/N Table Edit Default Value: N
14	NULL_DATE	Date(10)	DATE	Date field with NULL value
15	NULL_DTTM	DateTime(26)	TIMESTAMP	Null Date Time
16	NULL_TIME	Time(15)	TIMESTAMP	Null Time
17	PROMPT_FOR_SAVE	Character(1)	VARCHAR2(1) NOT NULL	Prompt for save when chunking Y/N Table Edit Default Value: Y
18	SCON_MAX_LINES	Number(5,0)	INTEGER NOT NULL	Maximum Lines Displayed Default Value: 50
19	PTSF_FLAG	Character(1)	VARCHAR2(1) NOT NULL	PTSF Search Y/N Table Edit Default Value: N
20	CC_CVNUM_REQ	Character(1)	VARCHAR2(1) NOT NULL	Security Code is Required Y/N Table Edit Default Value: N
21	CC_REAUTH_STALE	Character(1)	VARCHAR2(1) NOT NULL	Reauthorize Stale Transactions Y/N Table Edit Default Value: N
22	CR_CARD_INTFC_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	Credit Card Interface Seq Num
23	CR_CHK_ALG_INSTALL	Character(1)	VARCHAR2(1) NOT NULL	Corporate Cr. Check Algorithm A=Basic, Allow Override B=Basic, Do Not Allow Override C=Advanced, Allow Override D=Advanced, Do Not Allow Ovr Default Value: B
24	CR_CHK_CRM	Character(1)	VARCHAR2(1) NOT NULL	Include CRM Service Orders Y/N Table Edit Default Value: N
25	CR_CHK_BI	Character(1)	VARCHAR2(1) NOT NULL	Include Non-OM Invoices Y/N Table Edit Default Value: N
26	CR_SUM_INSTALL	Character(1)	VARCHAR2(1) NOT NULL	Use Corporate Summary Table A=Yes, Override Allowed B=Yes, Override Not Allowed C=No, Override Allowed D=Disabled Default Value: D
27	CR_SUM_HOURS	Number(5,0)	INTEGER NOT NULL	Summary Table Valid for
28	CR_SUM_AR	Character(1)	VARCHAR2(1) NOT NULL	Aged Credit Balance Y/N Table Edit Default Value: N
29	CR_SUM_BL	Character(1)	VARCHAR2(1) NOT NULL	Sales Order Backlog Y/N Table Edit Default Value: N
30	CR_SUM_PP	Character(1)	VARCHAR2(1) NOT NULL	Pending Payments & Deposits Y/N Table Edit Default Value: N
31	OM_MAX_CUSTHIST	Number(5,0)	INTEGER NOT NULL	Maximum Lines Displayed in RMA Default Value: 300