AP_SYSTEM_PARAMETERS_ALL

AP_SYSTEM_PARAMETERS_ALL contains the parameters and defaults you define for operating your Oracle Payables application system. This table contains information such as your set of books, your functional currency and your default bank account and payment terms. Your Oracle Payables application also uses this information to determine default values that cascade down to supplier and invoice entry. This table corresponds to the Payables 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

AP_SYSTEM_PARAMETERS_ALL_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.
RELEASE_DUP_INVOICE_HOLD_FLAG VARCHAR2 1 Flag that indicates whether invoice validation process can evaluate duplicate invoice hold and automatically release it. (Y or N)
RECALC_PAY_SCHEDULE_FLAG VARCHAR2 1 Yes Flag that indicates whether Recalculate Payment Installments (Y or N)
PREPAYMENT_AVAILABLE_MESG_FLAG VARCHAR2 1 Indicates whether available prepayments are shown during invoice entry.
SS_CHARGE_TYPES_MATCH_CODE VARCHAR2 30 Indicates the charge types that supplies are not allowed to enter while creating a matched invoice. Possible values are None, Freight only, Miscellaneous only and both.
SS_CHARGE_TYPES_UNMATCH_CODE VARCHAR2 30 Indicates the charge types that suppliers are not allowed to enter while creating an unmatched invoice. Possible values are None, Freight only, Miscellaneous only and Both.
SS_UPRICE_CHANGE_FOR_QTYMATCH VARCHAR2 30 Setting that indicates whether unit price change is allowed for purchase order matched self-service invoice.
SS_INVOICE_BACKDATING_FLAG VARCHAR2 1 Indicates whether a self-service invoice can have invoice date prior to system date.
SS_LIMIT_TO_SINGLE_PO_FLAG VARCHAR2 1 Indicates whether a self-service invoice can be matched to multiple purchase orders.
REQUIRE_INVOICE_GROUP_FLAG VARCHAR2 1 Setting that indicates whether invoice group is mandatory during invoice entry.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
SET_OF_BOOKS_ID NUMBER 18 Yes Ledger for which the parameters, control options, and defaults have been defined in order to operate your Payables application.
BASE_CURRENCY_CODE VARCHAR2 15 Yes Functional currency code associated with the ledger.
AUTO_CALCULATE_INTEREST_FLAG VARCHAR2 1 Yes Flag that indicates whether interest invoices are automatically created for past due invoice payments (Y or N)
INVOICE_CURRENCY_CODE VARCHAR2 15 Default invoice currency code that defaults on the supplier sites associated with the business unit.
PAYMENT_CURRENCY_CODE VARCHAR2 15 Default payment currency code (must be same as INVOICE_CURRENCY_CODE or must be an associated fixed-rate currency)
TERMS_ID NUMBER 18 Default payment terms identifier that defaults on the supplier sites associated with the business unit.
ALWAYS_TAKE_DISC_FLAG VARCHAR2 1 Flag that indicates if available discount for supplier will be taken, regardless of when invoice is paid (Y or N)
PAY_DATE_BASIS_LOOKUP_CODE VARCHAR2 25 Basis used for selecting invoices for payment
ACCTS_PAY_CODE_COMBINATION_ID NUMBER 18 Accounting Flexfield identifier for accounts payable liability account
DISC_TAKEN_CODE_COMBINATION_ID NUMBER 18 Accounting Flexfield identifier for discounts taken account
ADD_DAYS_SETTLEMENT_DATE NUMBER 18 Number of days added to system date to calculate settlement date for a prepayment
DAYS_BETWEEN_CHECK_CYCLES NUMBER 18 Number of days between normal payment printing cycles, used to determine Pay Through Date for automatic payment batch
FEDERAL_IDENTIFICATION_NUM VARCHAR2 20 Federal Tax Identification number of your company
LOCATION_ID NUMBER 18 Location identifier for headquarters location of your company (prints on 1099 forms)
PREPAY_CODE_COMBINATION_ID NUMBER 18 Accounting Flexfield identifier for prepayment account
UPDATE_PAY_SITE_FLAG VARCHAR2 1 Flag that indicates if changes to supplier payment address on manual payments or Quick payments is allowed (Y or N)
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)
GL_DATE_FROM_RECEIPT_FLAG VARCHAR2 25 Date used as accounting date during invoice entry
DISC_IS_INV_LESS_TAX_FLAG VARCHAR2 1 Flag that indicates if tax amount excluded from invoice amount when invoice amount applicable to discount calculated (Y or N)
ACCOUNTING_METHOD_OPTION VARCHAR2 25 Accounting method used with primary set of books
ONLINE_PRINT_FLAG VARCHAR2 1 Flag that indicates if immediate on-line printing for Quick Payments is allowed (Y or N)
EFT_USER_NUMBER VARCHAR2 30 Number which identifies your company as a user of electronic funds transfer services to bank or clearing organization
MAX_OUTLAY NUMBER Maximum amount of a payment batch
VENDOR_PAY_GROUP_LOOKUP_CODE VARCHAR2 25 Default pay group code for payment requests. Used to group a category of suppliers or invoices into a single pay run. For example: employees, merchandise, nonmerchandise, government, domestic, and international.
REQUIRE_TAX_ENTRY_FLAG VARCHAR2 1 Flag that indicates if tax entry is required during invoice entry (Y or N)
POST_DATED_PAYMENTS_FLAG VARCHAR2 1 Flag that indicates if payment date can be prior to system date (Y or N)
SECONDARY_ACCOUNTING_METHOD VARCHAR2 25 Accounting method used for secondary set of books
SECONDARY_SET_OF_BOOKS_ID NUMBER 18 Secondary set of books identifier
INTEREST_TOLERANCE_AMOUNT NUMBER Minimum interest amount owed on past due invoice for interest invoice to be automatically created
INTEREST_CODE_COMBINATION_ID NUMBER 18 Accounting Flexfield identifier for interest expense account
TERMS_DATE_BASIS VARCHAR2 25 Date used together with payment terms and invoice amount to create invoice scheduled payment
LIABILITY_POST_LOOKUP_CODE VARCHAR2 25 Code for method used to build offsetting Accounting Flexfields for invoice and payment distributions (Automatic Offsets/Fund Accounting)
DISCOUNT_DISTRIBUTION_METHOD VARCHAR2 25 Method for distributing discount amounts taken on invoice payments
COMBINED_FILING_FLAG VARCHAR2 1 Flag that indicates whether your organization participates in the Combined Filing Program for income tax reporting
INCOME_TAX_REGION VARCHAR2 10 Default income tax region assigned to invoice lines for 1099 suppliers
INCOME_TAX_REGION_FLAG VARCHAR2 1 A value of Y indicates that you use supplier tax region as the default Income Tax Region for 1099 invoice lines
ALLOW_FINAL_MATCH_FLAG VARCHAR2 1 Flag that indicates whether you allow final matching to purchase orders
ALLOW_FLEX_OVERRIDE_FLAG VARCHAR2 1 Flag that indicates whether you can override the matching Accounting Flexfield for an invoice distribution matched to a purchase order distribution line
ALLOW_PAID_INVOICE_ADJUST VARCHAR2 1 Flag that indicates whether you allow adjustments to paid invoices
USSGL_TRANSACTION_CODE VARCHAR2 30 USSGL Transaction Code for automatically generated interest invoices
USSGL_TRX_CODE_CONTEXT VARCHAR2 30 USSGL Transaction Code Descriptive Flexfield context column
INV_DOC_CATEGORY_OVERRIDE VARCHAR2 1 Flag that indicates whether you can override the default document category (Sequential Numbering) for invoices
PAY_DOC_CATEGORY_OVERRIDE VARCHAR2 1 Flag that indicates whether you can override the default document category (Sequential Numbering) for payments
VENDOR_AUTO_INT_DEFAULT VARCHAR2 1 Default Automatic Interest Calculation value that defaults to suppliers (Y or N)
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 order
TRANSFER_DESC_FLEX_FLAG VARCHAR2 1 A value of Y indicates the system will transfer descriptive flexfield information from a purchase order shipment to an invoice line and from the purchase order distribution to an invoice distribution during purchase order matching
ALLOW_AWT_FLAG VARCHAR2 1 Flag to indicate whether Automatic Withholding Tax is allowed (Y or N)
DEFAULT_AWT_GROUP_ID NUMBER 18 Default Withholding Tax group for new suppliers
ALLOW_AWT_OVERRIDE VARCHAR2 1 Flag to indicate whether override of withholding tax amount is allowed (Y, N, null)
CREATE_AWT_DISTS_TYPE VARCHAR2 25 Indicates when the system should automatically create withholding tax invoices. Possible values are Never, Validation, or Payment
CREATE_AWT_INVOICES_TYPE VARCHAR2 25 Indicates when the system should automatically create withholding tax invoices (Never, Invoice Validation, Payment).
AWT_INCLUDE_DISCOUNT_AMT VARCHAR2 1 Flag to indicate whether the discount amount is included in withholding tax calculation
AWT_INCLUDE_TAX_AMT VARCHAR2 1 Flag to indicate whether the tax amount is included in the withholding tax calculation
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
AUTO_CREATE_FREIGHT_FLAG VARCHAR2 1 Flag that indicates whether a freight line can be automatically created from a user request
FREIGHT_CODE_COMBINATION_ID NUMBER 18 Accounting Flexfield identifier for accounts payable freight account
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.
ALLOW_SUPPLIER_BANK_OVERRIDE VARCHAR2 1 Flag to indicate whether user can charge remit-to bank at payment creation time.
USE_BANK_CHARGE_FLAG VARCHAR2 1 Flag to indicate if Bank Charge feature is used
BANK_CHARGE_BEARER VARCHAR2 1 Indicates whether the deploying company or your supplier pays bank charges for electronic payments.
MRC_BASE_CURRENCY_CODE VARCHAR2 2000 Multiple Reporting Currencies only: Concatenated string of reporting set of books id, functional currency pairs
MRC_SECONDARY_SET_OF_BOOKS_ID VARCHAR2 2000 Multiple Reporting Currencies only: Concatenated string of reporting set of books id
GAIN_LOSS_CALC_LEVEL VARCHAR2 30 Level at which Payables will calculate gain and loss, either Payment or Payment Line
WHEN_TO_ACCOUNT_PMT VARCHAR2 30 Defines when accounting entries for payments will be created.
FUTURE_DATED_PMT_LIAB_RELIEF VARCHAR2 30 Specifies when the liability for future dated payments is relieved
GL_TRANSFER_ALLOW_OVERRIDE VARCHAR2 1 Option that allows the user to change the default values for program parameters when the user submits the transfer to GL process
GL_TRANSFER_MODE VARCHAR2 1 GL Interface Transfer Summary Level. Detail (D), summarized by accounting date (A), summarized by accounting period (P)
GL_TRANSFER_SUBMIT_JOURNAL_IMP VARCHAR2 1 Option for submitting Journal Import to Oracle General Ledger at the same time as the transfer to GL process
INCLUDE_REPORTING_SOB VARCHAR2 1 If this option is set to 'Y' then all multi reporting currencies ledgers will automatically be selected for transfer with the same selection criteria as the main ledger.
PREPAYMENT_TERMS_ID NUMBER 18 Default payment terms for prepayment. For example, a company may want to have immediate payment terms for all prepayment type invoices.
APPROVAL_WORKFLOW_FLAG VARCHAR2 1 Yes Select this check box value to enable invoice approval.
ALLOW_FORCE_APPROVAL_FLAG VARCHAR2 1 Yes Select this check box value if you use the Invoice Approval Workflow Program and want to allow accounts payable processors to override the workflow and manually approve invoices.
VALIDATE_BEFORE_APPROVAL_FLAG VARCHAR2 1 Yes If you select this check box value, then Invoice Approval Workflow does not select any invoice for processing unless the invoice status is Validated.
XML_PAYMENTS_AUTO_CONFIRM_FLAG VARCHAR2 1 Flag that indicates if the XML Payment Automatic Confirmation feature is enabled.
BUILD_PREPAYMENT_ACCOUNTS_FLAG VARCHAR2 1 Flag indicating whether the prepayment account should be built or defaulted
ENABLE_1099_ON_AWT_FLAG VARCHAR2 1 Select this check box value is you want to include Withholding Distribution in Income Tax Reports
TOLERANCE_ID NUMBER 18 A unique identifier for tolerance template that is used for goods tolerance.
PREPAY_TAX_DIFF_CCID NUMBER 18 Account to which any prepayment tax difference amount will be charged.
CE_BANK_ACCT_USE_ID NUMBER 18 Bank account number used for cash transactions.
APPROVAL_TIMING VARCHAR2 30 If you select this check box value, then Invoice Approval Workflow does not select any invoice for processing unless the invoice status is Accounted.
SERVICES_TOLERANCE_ID NUMBER 18 Services tolerance template identifier
RECEIPT_ACCEPTANCE_DAYS NUMBER 18 Number of days in receipt acceptance period
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.
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.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
PAYMENT_PRIORITY NUMBER A unique number between 1 (high) and 99 (low) that represents the priority of payment.
EXCLUDE_FREIGHT_FROM_DISCOUNT VARCHAR2 1 Exclude Freight From Discount Identifier
PRORATE_INT_INV_ACROSS_DISTS VARCHAR2 1 Used to display the 'Interest' Allocation method in 'Accounting Option' label.
EMPLOYEE_TERMS_ID NUMBER 18 Default payment terms identifier for payment requests.
EMPLOYEE_PAY_GROUP_LOOKUP_CODE VARCHAR2 25 Default pay group code for payment requests. Used to group a category of invoices into a single pay run. For example: employees, merchandise, nonmerchandise, government, domestic, and international.
EMPLOYEE_PAYMENT_PRIORITY NUMBER 2 A unique number between 1 (high) and 99 (low) that represents the priority of payment.
BUDGET_DATE_BASIS VARCHAR2 25 Budget Date Basis to default the budget date on invoice transactions
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.
AUTOMATIC_MATCHING_FLAG VARCHAR2 1 Indicates if automatic matching is enabled for the invoicing business unit. If users enable this option, they must select a matching rule set.
MATCHING_RULE_SET_ID NUMBER 18 Matching rule set used to perform automatic matching for an invoice when a matching rule set is not found at the invoice header and supplier site setup.
ROUTE_INTERFACE_REJECTION_FLAG VARCHAR2 1 Indicates whether rejected invoices in the interface table should be routed for correction.
OVERRIDE_MATCH_REJECTION_FLAG VARCHAR2 1 Indicates whether invoice import process allows override on rejections for scanned invoices.
ALLOW_INV_THIRD_PARTY_OVRD VARCHAR2 1 Allow override of remit-to supplier and address for third party payments
ALLOW_PYMT_THIRD_PARTY_OVRD VARCHAR2 1 Allow override of remit-to supplier and address for third party payments
BANK_CHARGE_DEDUCTION_TYPE VARCHAR2 1 Type of deduction for bank charges. Values are Standard, Negotiated, or None.
ROUTING_FLAG VARCHAR2 1 Indicates the Invoice Rounting option is enabled for the business unit.
ATTACHMENT_MANDATORY_SS_FLAG VARCHAR2 1 Yes Makes attachments mandatory for invoices created through supplier portal.
DISALLOW_ATTACHMENT_DEL_FLAG VARCHAR2 1 Yes Prevents the deletion of attachments for approved or validated invoices.
DEFAULT_CONV_RATE_DATE_BASIS VARCHAR2 25 Date used as default conversion rate date to convert an amount into another currency for an invoice
ACCOUNT_DEFAULT_BASIS_CODE VARCHAR2 30 Basis used for defaulting the accounts on the invoice transactions.
SS_QTYMATCH_OVERBILL_FLAG VARCHAR2 1 Flag that indicates whether a supplier can enter a quantity on the invoice that exceeds the purchase order for quantity based matches or not
SS_AMTMATCH_OVERBILL_FLAG VARCHAR2 1 Flag that indicates whether a supplier can enter a quantity on the invoice that exceeds the purchase order for quantity based matches or not
ESCHEATMENT_ELIGIBILITY_PERIOD NUMBER 18 Number of days after which escheatment is allowed.

Foreign Keys

Table Foreign Table Foreign Key Column
AP_SYSTEM_PARAMETERS_ALL ce_bank_acct_uses_all CE_BANK_ACCT_USE_ID
AP_SYSTEM_PARAMETERS_ALL gl_code_combinations DISC_TAKEN_CODE_COMBINATION_ID
AP_SYSTEM_PARAMETERS_ALL ap_income_tax_regions INCOME_TAX_REGION
AP_SYSTEM_PARAMETERS_ALL gl_code_combinations PREPAY_CODE_COMBINATION_ID
AP_SYSTEM_PARAMETERS_ALL gl_code_combinations GAIN_CODE_COMBINATION_ID
AP_SYSTEM_PARAMETERS_ALL gl_code_combinations LOSS_CODE_COMBINATION_ID
AP_SYSTEM_PARAMETERS_ALL gl_code_combinations FREIGHT_CODE_COMBINATION_ID
AP_SYSTEM_PARAMETERS_ALL ap_terms_b TERMS_ID
AP_SYSTEM_PARAMETERS_ALL gl_code_combinations RATE_VAR_GAIN_CCID
AP_SYSTEM_PARAMETERS_ALL gl_code_combinations RATE_VAR_LOSS_CCID
AP_SYSTEM_PARAMETERS_ALL ap_awt_groups DEFAULT_AWT_GROUP_ID
AP_SYSTEM_PARAMETERS_ALL ap_terms_b PREPAYMENT_TERMS_ID
AP_SYSTEM_PARAMETERS_ALL ap_tolerance_templates TOLERANCE_ID
AP_SYSTEM_PARAMETERS_ALL ap_terms_b EMPLOYEE_TERMS_ID
AP_SYSTEM_PARAMETERS_ALL gl_ledgers SET_OF_BOOKS_ID
AP_SYSTEM_PARAMETERS_ALL gl_code_combinations ACCTS_PAY_CODE_COMBINATION_ID

Indexes

Index Uniqueness Tablespace Columns
AP_SYSTEM_PARAMETERS_ALL_U2 Unique Default ORG_ID
AP_SYSTEM_PARAMETERS_U1 Unique Default SET_OF_BOOKS_ID, ORG_ID