INSTALLATION_FS

(SQL Table)
Index Back

System Options - PS/Financials

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 JOURNAL_NUM_ASSIGN Number(10,0) DECIMAL(10) NOT NULL Journal Number - Auto Assigned
2 SECURITY_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Security
C=Permission List Level Security
N=No Security
O=User ID Level Security

Default Value: N

3 BU_SECURITY Character(1) VARCHAR2(1) NOT NULL Business Unit Security

Y/N Table Edit

Default Value: N

4 SETID_SECURITY Character(1) VARCHAR2(1) NOT NULL TableSet ID Security

Y/N Table Edit

Default Value: N

5 LEDGER_SECURITY Character(1) VARCHAR2(1) NOT NULL Ledger Security

Y/N Table Edit

Default Value: N

6 BOOK_SECURITY Character(1) VARCHAR2(1) NOT NULL Book Security

Y/N Table Edit

Default Value: N

7 ANALYSIS_SECURITY Character(1) VARCHAR2(1) NOT NULL Analysis Group

Y/N Table Edit

Default Value: N

8 PROJECT_SECURITY Character(1) VARCHAR2(1) NOT NULL Project Security

Y/N Table Edit

Default Value: N

9 ITEM_APPROVALS Character(1) VARCHAR2(1) NOT NULL Item Approval Required

Y/N Table Edit

Default Value: N

10 ITEM_APPROV_OPT Character(3) VARCHAR2(3) NOT NULL Approval Method
1=Manual
2=WorkFlow
11 SUBCUST_USE_SW Character(1) VARCHAR2(1) NOT NULL SubCustomer Use
1=Use First SubCustomer Field
B=Use Both SubCustomer Fields
N=Do Not Use SubCustomer Fields

Default Value: N

12 VAT_AR Character(1) VARCHAR2(1) NOT NULL Enable VAT Processing

Y/N Table Edit

Default Value: N

13 PYCYCL_SECURITY Character(1) VARCHAR2(1) NOT NULL Pay Cycle Security

Y/N Table Edit

Default Value: N

14 RECON_LEVEL Character(1) VARCHAR2(1) NOT NULL Reconciliation Level
A=All Business Units
B=Single Business Unit

Default Value: A

15 RECON_USE_TRAN Character(1) VARCHAR2(1) NOT NULL Use Transaction Types

Y/N Table Edit

Default Value: Y

16 DOC_SEQ Character(1) VARCHAR2(1) NOT NULL Enable Document Sequencing

Y/N Table Edit

Default Value: N