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 |