FINANCIALS_SYSTEM_PARAMS_ALL
FINANCIALS_SYSTEM_PARAMETERS_ALL contains options and defaults you share between your Oracle Payables application, and your Oracle Purchasing and Oracle Assets applications. You can define these options and defaults according to the way you run your business. This table corresponds to the Financials Options window. There is only one row in this table. There is no primary key for this table.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
FINANCIALS_SYSTEM_PARAMS_PK |
ORG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| SET_OF_BOOKS_ID | NUMBER | 18 | Yes | The ledger for which the control options and defaults have been setup for your Payables application. | |
| PAYMENT_METHOD_LOOKUP_CODE | VARCHAR2 | 25 | Payment method default used during supplier entry | ||
| USER_DEFINED_VENDOR_NUM_CODE | VARCHAR2 | 25 | Method of entering supplier numbers | ||
| VENDOR_NUM_START_NUM | NUMBER | Next automatic supplier number (Oracle Payables applications update as you enter suppliers) | |||
| BILL_TO_LOCATION_ID | NUMBER | 18 | Bill-to location identifier, default used during supplier entry | ||
| TERMS_ID | NUMBER | 18 | Payment terms identifier, default used during supplier entry | ||
| ALWAYS_TAKE_DISC_FLAG | VARCHAR2 | 1 | Flag that indicates if available discount for a supplier will be taken, regardless of when the invoice is paid (Y or N), default used during supplier entry | ||
| PAY_DATE_BASIS_LOOKUP_CODE | VARCHAR2 | 25 | Basis Oracle Payables applications use for selecting invoices for payment (DUE or DISCOUNT), default used during supplier entry | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 15 | Currency code for invoices, default used during supplier entry | ||
| PAYMENT_CURRENCY_CODE | VARCHAR2 | 15 | Currency code for payments, default used during supplier entry | ||
| ACCTS_PAY_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield identifier for the accounts payable liability account, default used during supplier entry | ||
| PREPAY_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield identifier for the prepayment account, default used during supplier entry | ||
| DISC_TAKEN_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield identifier for the discount taken account | ||
| FUTURE_PERIOD_LIMIT | NUMBER | 3 | Maximum number of future periods allowed | ||
| RES_ENCUMB_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield identifier for the reserve for encumbrance account | ||
| REQ_ENCUMBRANCE_FLAG | VARCHAR2 | 1 | Flag that indicates if Oracle Purchasing will create an encumbrance journal entry when a purchase requisition is created (Y or N) | ||
| REQ_ENCUMBRANCE_TYPE_ID | NUMBER | 18 | Requisition encumbrance type identifier | ||
| PURCH_ENCUMBRANCE_FLAG | VARCHAR2 | 1 | Flag that indicates if Oracle Purchasing will create an encumbrance journal entry when a purchase order is created | ||
| PURCH_ENCUMBRANCE_TYPE_ID | NUMBER | 18 | Purchase order encumbrance type identifier | ||
| INV_ENCUMBRANCE_TYPE_ID | NUMBER | 18 | Identifier for encumbrance type assigned to invoice encumbrances | ||
| MANUAL_VENDOR_NUM_TYPE | VARCHAR2 | 25 | Type of supplier number Oracle Payables uses for either automatic or manual supplier number entry | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| RECEIPT_ACCEPTANCE_DAYS | NUMBER | 18 | Number of days in receipt acceptance period | ||
| TERMS_DATE_BASIS | VARCHAR2 | 25 | Date Oracle Payables uses together with payment terms and invoice amount to create an invoice scheduled payment, default used during supplier entry | ||
| RATE_VAR_CODE_COMBINATION_ID | NUMBER | 18 | Not used | ||
| HOLD_UNMATCHED_INVOICES_FLAG | VARCHAR2 | 1 | Default Hold Unmatched Invoices value for supplier (Y or N) | ||
| EXCLUSIVE_PAYMENT_FLAG | VARCHAR2 | 1 | Default Pay Alone value for suppliers; defaults from supplier to invoices for supplier | ||
| VAT_REGISTRATION_NUM | VARCHAR2 | 20 | Value-Added Tax registration number for your organization | ||
| VAT_COUNTRY_CODE | VARCHAR2 | 15 | European Union (EU)) member state for your organization | ||
| RATE_VAR_GAIN_CCID | NUMBER | 18 | Accounting Flexfield identifier for account used to record exchange rate gains for invoices matched to purchase orders | ||
| RATE_VAR_LOSS_CCID | NUMBER | 18 | Accounting Flexfield identifier for account used to record exchange rate losses for invoices matched to purchase orders | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| BANK_CHARGE_BEARER | VARCHAR2 | 1 | Indicates whether the deploying company or your supplier pays bank charges for electronic payments. | ||
| MATCH_OPTION | VARCHAR2 | 25 | Flag to indicate whether to match invoices to purchase orders (P) or receipts (R) | ||
| NR_TAX_ROUNDING | VARCHAR2 | 30 | Tax rounding | ||
| FUTURE_DATED_PAYMENT_CCID | NUMBER | 18 | Accounting Flexfield identifier for future dated payment account default for Suppliers and Bank accounts | ||
| MISC_CHARGE_CCID | NUMBER | 18 | Accounting flexfield identifier for the accounts payable miscellaneous account, which is used for supplier portal Invoices. | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| RETAINAGE_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield Identifier for the account associated with a retainage distribution. | ||
| BUYING_COMPANY_IDENTIFIER | VARCHAR2 | 10 | A unique identifier that identifies the buying business unit. The identifier is included on the invoice number of invoices created by the pay on receipt process or debit memos from return on receipt transactions. | ||
| EXPENSE_ACCRUAL_CCID | NUMBER | 18 | Expense Accrual Account Code Combination Identifier | ||
| GAPLESS_INV_NUM_FLAG | VARCHAR2 | 1 | Gapless Invoice Numbering Option Flag | ||
| EXPENSE_ACCRUAL_CODE | VARCHAR2 | 25 | Defines accrue expense items options. | ||
| DEFAULT_EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Specifies the default conversion rate type when you enter invoices or create payments. | ||
| AUTOMATIC_OFFSETS_FLAG | VARCHAR2 | 1 | A flag that allows overriding of either the primary balancing segment or all segments, except the natural account segment when creating the liability account. | ||
| AUTOMATIC_OFFSETS_CHANGE_FLAG | VARCHAR2 | 1 | A yes or no flag that indicates whether the Automatic Offset option has changed. | ||
| LIABILITY_POST_LOOKUP_CODE | VARCHAR2 | 25 | Code for method used to build offsetting Accounting flexfields for invoice and payment distributions (automatic offsets/fund accounting). | ||
| GAIN_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield identifier for account to which realized exchange rate gains are posted | ||
| LOSS_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield identifier for account to which realized exchange rate losses are posted | ||
| MAKE_RATE_MANDATORY_FLAG | VARCHAR2 | 1 | Flag that indicates if exchange rates must be entered for multiple currency invoices and payments (Y or N) | ||
| FREIGHT_CODE_COMBINATION_ID | NUMBER | 18 | Accounting Flexfield identifier for accounts payable freight account | ||
| PREPAY_TAX_DIFF_CCID | NUMBER | 18 | Account to which any prepayment tax difference amount will be charged. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| MAKE_RATE_MANDATORY_PMT_FLAG | VARCHAR2 | 1 | Require Conversion Rate Information for Payments | ||
| DEFAULT_PMT_EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Payment Conversion Rate Type | ||
| ONE_TIME_PAY_LIAB_CCID | NUMBER | 18 | Account combination to which the invoice liability is booked for One Time Payments functionality. | ||
| ONE_TIME_PAY_EXPENSE_CCID | NUMBER | 18 | Account combination to which the invoice expense is booked for One Time Payments functionality. | ||
| UNCLAIMED_FUNDS_CCID | NUMBER | 18 | Unclaimed funds account used for escheatment. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FINANCIALS_SYSTEM_PARAMS_ALL | ap_terms_b | TERMS_ID |
| FINANCIALS_SYSTEM_PARAMS_ALL | gl_ledgers | SET_OF_BOOKS_ID |
| FINANCIALS_SYSTEM_PARAMS_ALL | gl_code_combinations | RATE_VAR_CODE_COMBINATION_ID |
| FINANCIALS_SYSTEM_PARAMS_ALL | gl_code_combinations | RATE_VAR_GAIN_CCID |
| FINANCIALS_SYSTEM_PARAMS_ALL | gl_code_combinations | RATE_VAR_LOSS_CCID |
| FINANCIALS_SYSTEM_PARAMS_ALL | gl_code_combinations | ACCTS_PAY_CODE_COMBINATION_ID |
| FINANCIALS_SYSTEM_PARAMS_ALL | gl_code_combinations | PREPAY_CODE_COMBINATION_ID |
| FINANCIALS_SYSTEM_PARAMS_ALL | gl_code_combinations | DISC_TAKEN_CODE_COMBINATION_ID |
| FINANCIALS_SYSTEM_PARAMS_ALL | gl_code_combinations | FUTURE_DATED_PAYMENT_CCID |
| FINANCIALS_SYSTEM_PARAMS_ALL | gl_code_combinations | RES_ENCUMB_CODE_COMBINATION_ID |
| FINANCIALS_SYSTEM_PARAMS_ALL | gl_code_combinations | UNCLAIMED_FUNDS_CCID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FINANCIALS_SYSTEM_PARAMS_U1 | Unique | Default | SET_OF_BOOKS_ID, ORG_ID |
| FINANCIALS_SYSTEM_PARAMS_U2 | Unique | Default | ORG_ID |