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 |