INSTALLATION_FS(SQL Table) |
Index Back |
|---|---|
System Options - PS/FinancialsInstallation-level options for 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 | FLD_REQ_ID_ASSIGN | Number(30,0) | DECIMAL(30) NOT NULL | Field Request ID - Auto Assigned |
| 3 | 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 |
| 4 | BU_SECURITY | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit Security
Y/N Table Edit Default Value: N |
| 5 | SETID_SECURITY | Character(1) | VARCHAR2(1) NOT NULL |
TableSet ID Security
Y/N Table Edit Default Value: N |
| 6 | LEDGER_SECURITY | Character(1) | VARCHAR2(1) NOT NULL |
Ledger Security
Y/N Table Edit Default Value: N |
| 7 | BOOK_SECURITY | Character(1) | VARCHAR2(1) NOT NULL |
Book Security
Y/N Table Edit Default Value: N |
| 8 | ANALYSIS_SECURITY | Character(1) | VARCHAR2(1) NOT NULL |
Analysis Group
Y/N Table Edit Default Value: N |
| 9 | PROJECT_SECURITY | Character(1) | VARCHAR2(1) NOT NULL |
Project Security
N=Do not allow project security Y=Allow project security Default Value: N |
| 10 | PROJ_SECURITY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Indicates how the projects are selected to define security. Projects can be selected from a tree or a list.
L=Select from List T=Select from Tree |
| 11 | ITEM_APPROVALS | Character(1) | VARCHAR2(1) NOT NULL |
Item Approval Required
Y/N Table Edit Default Value: N |
| 12 | ITEM_APPROV_OPT | Character(3) | VARCHAR2(3) NOT NULL |
Approval Method
1=Manual 2=WorkFlow |
| 13 | SUBCUST_USE_SW | Character(1) | VARCHAR2(1) NOT NULL |
SubCustomer Usage
1=Use First SubCustomer Field B=Use Both SubCustomer Fields N=Do Not Use SubCustomer Fields Default Value: N |
| 14 | PYCYCL_SECURITY | Character(1) | VARCHAR2(1) NOT NULL |
Pay Cycle Security
Y/N Table Edit Default Value: N |
| 15 | RECON_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Reconciliation Level
A=All Business Units B=Single Business Unit Default Value: A |
| 16 | DOC_SEQ | Character(1) | VARCHAR2(1) NOT NULL |
Enable Document Sequencing
Y/N Table Edit Default Value: N |
| 17 | RECON_TRANS_CODE | Character(3) | VARCHAR2(3) NOT NULL |
The PeopleSoft-specific bank transaction code
ACH=Automated Clearing House B=Direct Debit BA=Bank Adjustments BOE=Bill of Exchange - Disburse BOO=Bill of Order - Disburse C=Trade Receipt CHK=Check D=Deposits DD=Direct Debit - Disburse EFT=Electronic Funds Transfer F=Fee Expense G=General Transaction I=Interest Expense M=Miscellaneous Transaction MAN=Manual Check P=Payment R=Drafts S=Stop Pay TRW=Treasury Wire U=Funding Receipt V=Voided Payment WIR=Wire - Disbursement WRI=Wire - Incoming |
| 18 | BNK_ACTIVE_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
This field determines the type of tolerance on a transaction's amount
A=Amount D=Date N=None P=Percent Default Value: A |
| 19 | BNK_LIMIT_HIGH_AMT | Number(16,2) | DECIMAL(15,2) NOT NULL | This field contains the upper amount when added to a transaction amount that will still reconcile. |
| 20 | BNK_LIMIT_HIGH_PCT | Number(8,2) | DECIMAL(7,2) NOT NULL | This field contains the high percent limit that when multiplied by the transaction amount and then added to the transaction amount will still allow the transaction to reconcile. |
| 21 | BNK_LIMIT_LOW_AMT | Number(16,2) | DECIMAL(15,2) NOT NULL | This field contains the lower amount when subtracted from a transaction amount that will still reconcile. |
| 22 | BNK_LIMIT_LOW_PCT | Number(8,2) | DECIMAL(7,2) NOT NULL | This field contains the low percent limit that when multiplied by the transaction amount and then subtracted to the transaction amount will still allow the transaction to reconcile. |
| 23 | BNK_LIMIT_HIGH_DAY | Number(3,0) | SMALLINT NOT NULL | Upper Day Limit |
| 24 | BNK_LIMIT_LOW_DAY | Number(3,0) | SMALLINT NOT NULL | Lower Day Limit |
| 25 | ACCTG_TMPL_ID | Character(15) | VARCHAR2(15) NOT NULL |
A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits.
Prompt Table: TRA_BSP_TMPL_VW |
| 26 | VAT_AUTH_LAST_USED | Number(8,0) | INTEGER NOT NULL | Last VAT Authority Number |
| 27 | IU_LEGAL_ENT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Use Legal Entity for InterUnit
Y/N Table Edit Default Value: N |
| 28 | IU_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
InterUnit Method
D=Direct I=Indirect P=Pairs Default Value: D |
| 29 | IU_SUMMARIZATION | Character(1) | VARCHAR2(1) NOT NULL |
Controls whether or not a final summarization is performed on the balancing lines created by the InterUnit Processor.
D=Default to Installation Option N=No Summarization S=Summarize Default Value: N |
| 30 | DOC_TOL_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Enable Document Tolerance
Y/N Table Edit Default Value: N |
| 31 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: DOC_TOL_VW2 |
| 32 | DOC_APPRV_REQ_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Document Approval Required
Y/N Table Edit Default Value: N |
| 33 | PL_PRBINS_SECURITY | Character(1) | VARCHAR2(1) NOT NULL |
Planning Instance
Y/N Table Edit Default Value: N |
| 34 | DB_ENABLE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Enable Realtime DNB Info.
Y/N Table Edit Default Value: N |
| 35 | DB_RTN_MAX | Number(3,0) | SMALLINT NOT NULL | Maximum Response Number |
| 36 | PROCESS_POLL | Character(1) | VARCHAR2(1) NOT NULL |
Pop Up Error/Warning Message
Y/N Table Edit Default Value: N |
| 37 | GIS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
GIS Integration
Y/N Table Edit Default Value: N |
| 38 | CF_SECURITY | Character(1) | VARCHAR2(1) NOT NULL |
Enable ChartField Securtity
0=No Security 1=User ID 2=Role 3=Permission List Default Value: 0 |
| 39 | SEC_ACCESS_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
When user has partial access
D=Deny Access G=Grant Access X=Default from Higher Level Default Value: D |
| 40 | BUDGETARY_ONLY | Character(1) | VARCHAR2(1) NOT NULL |
Budgetary Only
Default Value: N |
| 41 | FLT_TREE_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Use Flatten Tree Switch
Y/N Table Edit Default Value: N |
| 42 | EDR_CF_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Maintain Chartfield Effective Dated Range data
Y/N Table Edit Default Value: N |
| 43 | ORCL_ELOC_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Installation Option: Use Oracle eLocation Service
Y/N Table Edit Default Value: N |
| 44 | QSC_SECURITY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Query Security
0=No Security 1=User ID 2=Role 3=Permission List Default Value: 0 |
| 45 | GST_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Enable Goods and Services Tax
Y/N Table Edit Default Value: N |