INSTALLATION_PO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FAX_FILENUM_LAST	Number(5,0)	INTEGER NOT NULL	Last Used Fax File Number
2	LAST_LOADER_ID	Number(10,0)	DECIMAL(10) NOT NULL	Last PO Req Loader ID Default Value: 0
3	MIN_LOADER_ID	Number(10,0)	DECIMAL(10) NOT NULL	Min Loader ID
4	MAX_LOADER_ID	Number(10,0)	DECIMAL(10) NOT NULL	Max Loader ID Default Value: 9999999999
5	MAX_LOAD_LINES	Number(5,0)	INTEGER NOT NULL	Max Load Lines
6	QTY_MAX_DEFAULT	Number(16,4)	DECIMAL(15,4) NOT NULL	Value for Max Qty on Breaks
7	LAST_PO_STG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Last Stage ID used
8	EDI_FILENUM_LAST	Number(5,0)	INTEGER NOT NULL	Last EDX File Number
9	ITMLD_LAST_ITEM_ID	Number(18,0)	DECIMAL(18) NOT NULL	Last Item Number Assigned
10	PYMNT_ID_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Payment Number Numeric Default Value: 1
11	MAX_ROW_PO_APPR	Number(5,0)	INTEGER NOT NULL	PO Approval Monitor Max Rows Default Value: 5
12	MAX_ROW_REQ_APPR	Number(5,0)	INTEGER NOT NULL	Req Approval Monitor Max Rows Default Value: 5
13	MAX_ROWS_CONTRACTS	Number(5,0)	INTEGER NOT NULL	Max number of rows that can be retrieved for Contracts. Default Value: 50
14	MAX_ROWS_PO	Number(5,0)	INTEGER NOT NULL	PO Max Rows To Retrieve Default Value: 20
15	MAX_ROWS_REQ_SEL	Number(5,0)	INTEGER NOT NULL	Max Rows Req to PO Select Default Value: 20
16	MAX_ROWS_SCROLL	Number(5,0)	INTEGER NOT NULL	Max Number of Rows in Scrolls Default Value: 20
17	MAX_ROWS_CLS_SHORT	Number(5,0)	INTEGER NOT NULL	Max number of rows that can be retrieved for Close Short Workbench. Default Value: 20
18	MAX_ROWS_RECV	Number(5,0)	INTEGER NOT NULL	Receiver Workbench Maximum Rows to Retrieve Default Value: 20
19	EMAIL_FILENUM_LAST	Number(5,0)	INTEGER NOT NULL	Last Used Email File Number
20	CATEGORY_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Category Type PSF=User Def UNS=UN/SPSC Default Value: PSF
21	PANELNAME	Character(18)	VARCHAR2(18) NOT NULL	Panelname
22	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
23	DISPLAY_DIGITS	Number(3,0)	SMALLINT NOT NULL	Number of Digits to Display Default Value: 4
24	MAX_VOUCHER_LINE	Number(5,0)	INTEGER NOT NULL	Default Voucher Lines Default Value: 50
25	CREATE_BILLTO_CUST	Character(1)	VARCHAR2(1) NOT NULL	Auto-Create Bill To Customer Option flag Y/N Table Edit Default Value: N
26	PO_DISP_XMLP	Character(1)	VARCHAR2(1) NOT NULL	Enable XML Publisher Y/N Table Edit Default Value: N
27	PO_DISPLAY_SRCH	Character(1)	VARCHAR2(1) NOT NULL	Purchase Orders N=Load First Set of Lines Y=Display Advanced Search Page Default Value: N
28	REQ_DISPLAY_SRCH	Character(1)	VARCHAR2(1) NOT NULL	Requisitions N=Load First Set of Lines Y=Display Advanced Search Page Default Value: N
29	ENTER_CUSTOM_FLDS	Character(1)	VARCHAR2(1) NOT NULL	Enter Custom Fields Y/N Table Edit Default Value: N
30	MAX_ROWS_RECON	Number(5,0)	INTEGER NOT NULL	Reconcile Statement Default Value: 50
31	CC_RECON_DAYS	Number(3,0)	SMALLINT NOT NULL	Transaction Date Days Default Value: 30
32	MAX_ROWS_DOCSTAT	Number(5,0)	INTEGER NOT NULL	Document Status Maximum Rows to Retrieve Default Value: 2
33	CURR_CD_KIBANA	Character(3)	VARCHAR2(3) NOT NULL	Reporting Currency Prompt Table: CURRENCY_CD_TBL
34	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Prompt Table: RT_TYPE_TBL