[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_SYSTEM_PARAMETERS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  SQLAP.AP_SYSTEM_PARAMETERS_ALL
|
| Subobject Name: | |
| Status: | VALID |
This table holds Payables system defaults and parameters and corresponds to the Payables Options window.
AP_SYSTEM_PARAMETERS_ALL contains the parameters and defaults defined for operating Oracle Payables application system. This table contains information such as accounting options, Invoice and Payment level controls, Withholding Tax setup, payment terms etc.,. This information in Oracle Payables application is used to determine default values that cascade down to supplier and invoice entry.
There is only one row in this table for each operating unit. There is no primary key for this table.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AP_SYSTEM_PARAMETERS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 SET_OF_BOOKS_ID
ORG_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table. Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table. |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Ledger identifier |
| BASE_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Functional currency code |
| RECALC_PAY_SCHEDULE_FLAG | VARCHAR2 | (1) | Yes | This field corresponds to 'Recalculate Scheduled Payment' checkbox in 'Invoice' tab of Payables Options window. If this flag is set to 'Y', Payables automatically recalculates scheduled payments of invoices during Invoice Validation. |
| AUTO_CALCULATE_INTEREST_FLAG | VARCHAR2 | (1) | Yes | This field corresponds to 'Allow Interest Invoices' checkbox in 'Interest' tab of Payables Options window. If this flag is set to 'Y', Payables calculate interest for overdue invoices and creates interest invoices for selected suppliers. |
| INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | No Longer Used. Moved to AP_PRODUCT_SETUP | |
| PAYMENT_CURRENCY_CODE | VARCHAR2 | (15) | Default payment currency code (must be same as INVOICE_CURRENCY_CODE or must be an associated fixed-rate currency) | |
| INVOICE_NET_GROSS_FLAG | VARCHAR2 | (1) | No longer used | |
| BANK_ACCOUNT_ID | NUMBER | (15) | No longer used | |
| CHECK_OVERFLOW_LOOKUP_CODE | VARCHAR2 | (25) | No longer used | |
| BATCH_CONTROL_FLAG | VARCHAR2 | (1) | No longer used | |
| TERMS_ID | NUMBER | (15) | No Longer Used. Moved to AP_PRODUCT_SETUP | |
| ALWAYS_TAKE_DISC_FLAG | VARCHAR2 | (1) | No Longer Used. Moved to AP_PRODUCT_SETUP | |
| PAY_DATE_BASIS_LOOKUP_CODE | VARCHAR2 | (25) | No Longer Used. Moved to AP_PRODUCT_SETUP | |
| ACCTS_PAY_CODE_COMBINATION_ID | NUMBER | (15) | No Longer used. Moved to Financial Options. | |
| SALES_TAX_CODE_COMBINATION_ID | NUMBER | (15) | No longer used | |
| DISC_LOST_CODE_COMBINATION_ID | NUMBER | (15) | No longer used | |
| DISC_TAKEN_CODE_COMBINATION_ID | NUMBER | (15) | No Longer used. Moved to Financial Options. | |
| HOLD_GAIN_CODE_COMBINATION_ID | NUMBER | (15) | No longer used | |
| TRANS_GAIN_CODE_COMBINATION_ID | NUMBER | (15) | No longer used | |
| APPLY_ADVANCES_DEFAULT | VARCHAR2 | (4) | Value that indicates if advances will be applied to employee expense reports (Y or N) | |
| ADD_DAYS_SETTLEMENT_DATE | NUMBER | (15) | Number of days added to system date to calculate settlement date for a prepayment | |
| COST_OF_MONEY | NUMBER | No longer used | ||
| DAYS_BETWEEN_CHECK_CYCLES | NUMBER | (15) | No Longer used. Moved to Payments setup (IBY) | |
| FEDERAL_IDENTIFICATION_NUM | VARCHAR2 | (20) | Federal Tax Identification number of the company. | |
| LOCATION_ID | NUMBER | (15) | Location identifier for headquarters location of the company (prints on 1099 forms). | |
| CREATE_EMPLOYEE_VENDOR_FLAG | VARCHAR2 | (1) | Flag that indicates if suppliers are automatically created from employees for whom expense reports have been entered (Y or N) | |
| EMPLOYEE_TERMS_ID | NUMBER | (15) | Default Payment terms that will be assigned to any suppliers that will be created from employees during Expense Report Export. | |
| EMPLOYEE_PAY_GROUP_LOOKUP_CODE | VARCHAR2 | (25) | Default Pay Group that will be assigned to any suppliers that will be created from employees during Expense Report Export. | |
| EMPLOYEE_PAYMENT_PRIORITY | NUMBER | (2) | Default Payment Priority that will be assigned to any suppliers that will be created from employees during Expense Report Export. | |
| PREPAY_CODE_COMBINATION_ID | NUMBER | (15) | Accounting Flexfield identifier for prepayment account | |
| CONFIRM_DATE_AS_INV_NUM_FLAG | VARCHAR2 | (1) | Flag that indicates if pop-up window will display during invoice entry to confirm that invoice date can be used as default for invoice number (Y or N) | |
| UPDATE_PAY_SITE_FLAG | VARCHAR2 | (1) | This column corresponds to 'Allow Address change' checkbox in 'Payment' tab of Payables Options window. This flag indicates if supplier payment address on Manual or Quick payments is allowed ( Y or N). | |
| DEFAULT_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | This column corresponds to 'Exchange Rate Type' field in 'Currency' tab of Payables Opiton. Payables uses this as the default exchange rate type when invoices are entered or payments are created. | |
| GAIN_CODE_COMBINATION_ID | NUMBER | (15) | Accounting Flexfield identifier for account to which realized exchange rate gains are posted | |
| LOSS_CODE_COMBINATION_ID | NUMBER | (15) | Accounting Flexfield identifier for account to which realized exchange rate losses are posted | |
| MAKE_RATE_MANDATORY_FLAG | VARCHAR2 | (1) | This column corresponds to 'Require Exchange Rate Entry' checkbox in 'Currency' tab of Payables Option. This is the flag indicate if exchange rates must be entered for multiple currency invoices and payments (Y or N). | |
| MULTI_CURRENCY_FLAG | VARCHAR2 | (1) | This column corresponds to 'Use Multiple Currencies' checkbox in 'Currency' tab of Payables Option. This is the flag that indicates if multiple currency features used (Y or N). | |
| GL_DATE_FROM_RECEIPT_FLAG | VARCHAR2 | (25) | Flag to indicate accounting date during invoice entry. Corresponds to 'GL Date Basis' option in Invoice Tab of Payables Options window | |
| DISC_IS_INV_LESS_TAX_FLAG | VARCHAR2 | (1) | This column corresponds to 'Exclude Tax from Discount Calculation' checkbox in 'Payment' tab of Payables Options window. This flag indicates if tax amount excluded from invoice amount when invoice amount applicable to discount calculated (Y or N) | |
| MATCH_ON_TAX_FLAG | VARCHAR2 | (1) | No longer used | |
| ACCOUNTING_METHOD_OPTION | VARCHAR2 | (25) | Accounting method used with primary set of books | |
| EXPENSE_POST_OPTION | VARCHAR2 | (25) | No longer used | |
| DISCOUNT_TAKEN_POST_OPTION | VARCHAR2 | (25) | No longer used | |
| GAIN_LOSS_POST_OPTION | VARCHAR2 | (25) | No longer used | |
| CASH_POST_OPTION | VARCHAR2 | (25) | No longer used | |
| FUTURE_PAY_POST_OPTION | VARCHAR2 | (25) | No longer used | |
| DATE_FORMAT_LOOKUP_CODE | VARCHAR2 | (25) | No longer used | |
| REPLACE_CHECK_FLAG | VARCHAR2 | (1) | This column corresponds to 'Allow Void and Reissue' checkbox in 'Payment' tab of Payables Options window. This flag indicates if check replacement for Quick Payments is allowed ( Y or N). | |
| 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 the company as a user of electronic funds transfer services to bank or clearing organization. | |
| MAX_OUTLAY | NUMBER | No Longer used. Moved to Payments setup (IBY) | ||
| VENDOR_PAY_GROUP_LOOKUP_CODE | VARCHAR2 | (25) | No Longer used. Moved to AP_PRODUCT_SETUP | |
| REQUIRE_TAX_ENTRY_FLAG | VARCHAR2 | (1) | Flag that indicates if tax entry is required during invoice entry (Y or N) | |
| APPROVALS_OPTION | VARCHAR2 | (25) | Method used for validating invoices. Corresponds to the Allow Online Validation option | |
| POST_DATED_PAYMENTS_FLAG | VARCHAR2 | (1) | This column corresponds to 'Allow Pre-Date' checkbox in 'Payment' tab of Payables Options window. This flag indicates if payment date can be prior to the system date ( Y or N). | |
| SECONDARY_ACCOUNTING_METHOD | VARCHAR2 | (25) | Accounting method used for secondary set of books | |
| SECONDARY_SET_OF_BOOKS_ID | NUMBER | (15) | Secondary set of books identifier | |
| TAKE_VAT_BEFORE_DISCOUNT_FLAG | VARCHAR2 | (1) | No longer used | |
| INTEREST_TOLERANCE_AMOUNT | NUMBER | Minimum interest amount owed on past due invoice for interest invoice to be automatically created | ||
| INTEREST_CODE_COMBINATION_ID | NUMBER | (15) | Accounting Flexfield identifier for interest expense account | |
| TERMS_DATE_BASIS | VARCHAR2 | (25) | No Longer used. Moved to AP_PRODUCT_SETUP | |
| ALLOW_FUTURE_PAY_FLAG | VARCHAR2 | (1) | No longer used | |
| AUTO_TAX_CALC_FLAG | VARCHAR2 | (1) | No longer used | |
| AUTOMATIC_OFFSETS_FLAG | VARCHAR2 | (1) | Automatic offset | |
| LIABILITY_POST_LOOKUP_CODE | VARCHAR2 | (25) | Code for method used to build offsetting Accounting Flexfields for invoice and payment distributions. Corresponds to 'Automatic Offset Method' radio button in Accounting Options tab of Payables Options window. | |
| INTEREST_ACCTS_PAY_CCID | NUMBER | (15) | Accounting Flexfield identifier for interest liability account | |
| LIABILITY_POST_OPTION | VARCHAR2 | (25) | No longer used | |
| DISCOUNT_DISTRIBUTION_METHOD | VARCHAR2 | (25) | Method for distributing discount amounts taken on invoice payments. Corresponds to 'Discount Method' radio button in Accounting Options tab of Payables Options window. | |
| RATE_VAR_CODE_COMBINATION_ID | NUMBER | (15) | No longer used | |
| COMBINED_FILING_FLAG | VARCHAR2 | (1) | Flag that indicates whether the 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 supplier tax region is used as the default Income Tax Region for 1099 invoice lines. | |
| HOLD_UNMATCHED_INVOICES_FLAG | VARCHAR2 | (1) | Default Hold Unmatched Invoices value for suppliers and supplier sites created from employees during expense report export. | |
| ALLOW_DIST_MATCH_FLAG | VARCHAR2 | (1) | Flag that indicates whether the user can match to a purchase order distribution line or match only across an entire purchase order shipment. | |
| ALLOW_FINAL_MATCH_FLAG | VARCHAR2 | (1) | Flag that indicates to allow final matching to purchase orders. | |
| ALLOW_FLEX_OVERRIDE_FLAG | VARCHAR2 | (1) | Flag that indicates whether user 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 to allow adjustments to paid invoices. | |
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | No longer used | |
| USSGL_TRX_CODE_CONTEXT | VARCHAR2 | (30) | No longer used | |
| INV_DOC_CATEGORY_OVERRIDE | VARCHAR2 | (1) | Flag that indicates whether user can override the default document category (Sequential Numbering) for invoices. | |
| PAY_DOC_CATEGORY_OVERRIDE | VARCHAR2 | (1) | Flag that indicates whether user 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) | |
| SUMMARY_JOURNALS_DEFAULT | VARCHAR2 | (1) | No longer used | |
| RATE_VAR_GAIN_CCID | NUMBER | (15) | Accounting Flexfield identifier for account used to record exchange rate gains for invoices matched to purchase orders | |
| RATE_VAR_LOSS_CCID | NUMBER | (15) | 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) | This column corresponds to 'Use Withholding Tax' checkbox in Withholding tab of Payables Options window. This flag indicates whether Automatic Withholding Tax is allowed or not (Y or N). | |
| DEFAULT_AWT_GROUP_ID | NUMBER | (15) | This column corresponds to 'Tax Group' field in Withholding tab of Payables Options window. Value in this column is used to 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) | This column corresponds to the options in 'Apply Withholding Tax' region in Withholding Tab of Payables Options window. This column indicates when the system should automatically calculate withholding taxes. Possible Values for this column are: - NEVER - APPROVAL - PAYMENT - BOTH | |
| CREATE_AWT_INVOICES_TYPE | VARCHAR2 | (25) | This column corresponds to the options in 'Create Withholding Invoice' region in Withholding Tab of Payables Options window. This column indicates when the system should automatically create withholding tax invoices. Possible Values for this column are: - NEVER - VALIDATION - PAYMENT - BOTH | |
| AWT_INCLUDE_DISCOUNT_AMT | VARCHAR2 | (1) | This column corresponds to 'Include Discount Amount' in Withholding Tab of Payables Options window. This flag indicates 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 | (15) | Unique internal identifier of the Operating Unit | |
| RECON_ACCOUNTING_FLAG | VARCHAR2 | (1) | This flag indicates to account gain/loss during payment clearing. This column corresponds to 'When Payment Clears' checkbox in 'Accounting Option' tab of Payables Options | |
| 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 | (15) | Accounting Flexfield identifier for accounts payable freight account | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| ALLOW_SUPPLIER_BANK_OVERRIDE | VARCHAR2 | (1) | Flag to indicate whether user can charge remit-to bank at payment creation time. | |
| USE_MULTIPLE_SUPPLIER_BANKS | VARCHAR2 | (1) | No longer used | |
| AUTO_TAX_CALC_OVERRIDE | VARCHAR2 | (1) | No longer used | |
| AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2 | (1) | No longer used | |
| AMOUNT_INCLUDES_TAX_OVERRIDE | VARCHAR2 | (1) | No longer used | |
| VAT_CODE | VARCHAR2 | (15) | No longer used | |
| USE_BANK_CHARGE_FLAG | VARCHAR2 | (1) | Flag is used to indicate whether to deduct Bank Charges from payments | |
| BANK_CHARGE_BEARER | VARCHAR2 | (1) | Bank charge bearer deduction options. Possible values are:� No - You pay bank charges.� Supplier/Negotiated - Your supplier pays bank charges at a negotiated rate.� Supplier/Standard - Your supplier pays bank charges at a standard rate | |
| ROUNDING_ERROR_CCID | NUMBER | (15) | No longer used | |
| ROUNDING_ERROR_POST_OPTION | VARCHAR2 | (25) | No longer used | |
| TAX_FROM_PO_FLAG | VARCHAR2 | (1) | No longer used | |
| TAX_FROM_VENDOR_SITE_FLAG | VARCHAR2 | (1) | No longer used | |
| TAX_FROM_VENDOR_FLAG | VARCHAR2 | (1) | No longer used | |
| TAX_FROM_ACCOUNT_FLAG | VARCHAR2 | (1) | No longer used | |
| TAX_FROM_SYSTEM_FLAG | VARCHAR2 | (1) | No longer used | |
| TAX_FROM_INV_HEADER_FLAG | VARCHAR2 | (1) | No longer used | |
| TAX_FROM_TEMPLATE_FLAG | VARCHAR2 | (1) | No longer used | |
| TAX_HIER_PO_SHIPMENT | NUMBER | No longer used | ||
| TAX_HIER_VENDOR | NUMBER | No longer used | ||
| TAX_HIER_VENDOR_SITE | NUMBER | No longer used | ||
| TAX_HIER_ACCOUNT | NUMBER | No longer used | ||
| TAX_HIER_SYSTEM | NUMBER | No longer used | ||
| TAX_HIER_INVOICE | NUMBER | No longer used | ||
| TAX_HIER_TEMPLATE | NUMBER | No longer used | ||
| ENFORCE_TAX_FROM_ACCOUNT | VARCHAR2 | (1) | No longer used | |
| MRC_BASE_CURRENCY_CODE | VARCHAR2 | (2000) | No longer used | |
| MRC_SECONDARY_SET_OF_BOOKS_ID | VARCHAR2 | (2000) | No longer used | |
| MATCH_OPTION | VARCHAR2 | (25) | No Longer Used. Moved to AP_PRODUCT_SETUP | |
| 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) | Time when Payables will account for payments, either Always (payment and clearing) or Clearing Only | |
| WHEN_TO_ACCOUNT_GAIN_LOSS | VARCHAR2 | (30) | Time when Payables will account for gain and loss, either Always (payment and clearing) or Clearing Only | |
| FUTURE_DATED_PMT_ACCT_SOURCE | VARCHAR2 | (30) | No Longer used. Moved to Financial Options. | |
| 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_PROCESS_DAYS | NUMBER | (15) | No Longer Used | |
| 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) | No longer used | |
| EXPENSE_REPORT_ID | NUMBER | (15) | The default expense report template that is used in the Payables Expense Reports window. | |
| PREPAYMENT_TERMS_ID | NUMBER | (15) | Default terms for prepayment | |
| CALC_USER_XRATE | VARCHAR2 | (1) | This column corresponds to 'Calculate User Exchange Rate' checkbox in 'Currency' tab of Payables Options window. This is the flag that indicates whether for User exchange rate type, the functional currency amount will be enterable / updatable so that the exchange rate can be calculated. | |
| SORT_BY_ALTERNATE_FIELD | VARCHAR2 | (1) | This column corresponds to 'Sort by Alternate Field' checkbox in 'Reports' tab of Payables Options window. If this flag is set to 'Y', then Payables sorts by values in the alternate fields whenever it sorts reports by supplier name, supplier site name, and bank account name | |
| APPROVAL_WORKFLOW_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the Invoice Approval Workflow process is used (Y or N) |
| ALLOW_FORCE_APPROVAL_FLAG | VARCHAR2 | (1) | Yes | Indicates whether force approval is allowed (Y or N) |
| VALIDATE_BEFORE_APPROVAL_FLAG | VARCHAR2 | (1) | Yes | Indicates whether validation must complete before the Invoice Approval Workflow process can run (Y or N) |
| XML_PAYMENTS_AUTO_CONFIRM_FLAG | VARCHAR2 | (1) | No longer used | |
| PRORATE_INT_INV_ACROSS_DISTS | VARCHAR2 | (1) | No longer used | |
| BUILD_PREPAYMENT_ACCOUNTS_FLAG | VARCHAR2 | (1) | Flag indicating from where prepayment account should be built. This column corresponds to 'Prepayment Account' option in Accounting Options tab of Payables Options window. | |
| ENABLE_1099_ON_AWT_FLAG | VARCHAR2 | (1) | This flag corresponds to the Include Income Tax Type on Withholding Distributions Payables option, which helps to perform federal 1099 reporting. | |
| STOP_PREPAY_ACROSS_BAL_FLAG | VARCHAR2 | (1) | No longer used | |
| AUTOMATIC_OFFSETS_CHANGE_FLAG | VARCHAR2 | (1) | Flag that indicates whether the Automatic Offset option has changed (Y or N) | |
| TOLERANCE_ID | NUMBER | (15) | Tolerance Template Identifier for Goods Tolerance. | |
| PREPAY_TAX_DIFF_CCID | NUMBER | (15) | Account to which any prepayment tax difference amount will be charged. | |
| CE_BANK_ACCT_USE_ID | NUMBER | (15) | No Longer used | |
| APPROVAL_TIMING | VARCHAR2 | (30) | This column corresponds to the Approval Processing Sequence Payables option. | |
| SERVICES_TOLERANCE_ID | NUMBER | (15) | Services tolerance template identifier | |
| RECEIPT_ACCEPTANCE_DAYS | NUMBER | (15) | No Longer used | |
| TAX_TOLERANCE | NUMBER | Percentage Tax Tolerance | ||
| TAX_TOL_AMT_RANGE | NUMBER | Tolerance level for total tax amount variance | ||
| ALLOW_INV_THIRD_PARTY_OVRD | VARCHAR2 | (1) | Flag to indicate whether to allow override of third party Remit-To-Supplier on Invoice | |
| ALLOW_PYMT_THIRD_PARTY_OVRD | VARCHAR2 | (1) | Flag to indicate whether to allow override of third party Remit-To-Supplier on Payment |
Cut, paste (and edit) the following text to query this object:
SELECT LAST_UPDATE_DATE
, LAST_UPDATED_BY
, SET_OF_BOOKS_ID
, BASE_CURRENCY_CODE
, RECALC_PAY_SCHEDULE_FLAG
, AUTO_CALCULATE_INTEREST_FLAG
, INVOICE_CURRENCY_CODE
, PAYMENT_CURRENCY_CODE
, INVOICE_NET_GROSS_FLAG
, BANK_ACCOUNT_ID
, CHECK_OVERFLOW_LOOKUP_CODE
, BATCH_CONTROL_FLAG
, TERMS_ID
, ALWAYS_TAKE_DISC_FLAG
, PAY_DATE_BASIS_LOOKUP_CODE
, ACCTS_PAY_CODE_COMBINATION_ID
, SALES_TAX_CODE_COMBINATION_ID
, DISC_LOST_CODE_COMBINATION_ID
, DISC_TAKEN_CODE_COMBINATION_ID
, HOLD_GAIN_CODE_COMBINATION_ID
, TRANS_GAIN_CODE_COMBINATION_ID
, APPLY_ADVANCES_DEFAULT
, ADD_DAYS_SETTLEMENT_DATE
, COST_OF_MONEY
, DAYS_BETWEEN_CHECK_CYCLES
, FEDERAL_IDENTIFICATION_NUM
, LOCATION_ID
, CREATE_EMPLOYEE_VENDOR_FLAG
, EMPLOYEE_TERMS_ID
, EMPLOYEE_PAY_GROUP_LOOKUP_CODE
, EMPLOYEE_PAYMENT_PRIORITY
, PREPAY_CODE_COMBINATION_ID
, CONFIRM_DATE_AS_INV_NUM_FLAG
, UPDATE_PAY_SITE_FLAG
, DEFAULT_EXCHANGE_RATE_TYPE
, GAIN_CODE_COMBINATION_ID
, LOSS_CODE_COMBINATION_ID
, MAKE_RATE_MANDATORY_FLAG
, MULTI_CURRENCY_FLAG
, GL_DATE_FROM_RECEIPT_FLAG
, DISC_IS_INV_LESS_TAX_FLAG
, MATCH_ON_TAX_FLAG
, ACCOUNTING_METHOD_OPTION
, EXPENSE_POST_OPTION
, DISCOUNT_TAKEN_POST_OPTION
, GAIN_LOSS_POST_OPTION
, CASH_POST_OPTION
, FUTURE_PAY_POST_OPTION
, DATE_FORMAT_LOOKUP_CODE
, REPLACE_CHECK_FLAG
, ONLINE_PRINT_FLAG
, EFT_USER_NUMBER
, MAX_OUTLAY
, VENDOR_PAY_GROUP_LOOKUP_CODE
, REQUIRE_TAX_ENTRY_FLAG
, APPROVALS_OPTION
, POST_DATED_PAYMENTS_FLAG
, SECONDARY_ACCOUNTING_METHOD
, SECONDARY_SET_OF_BOOKS_ID
, TAKE_VAT_BEFORE_DISCOUNT_FLAG
, INTEREST_TOLERANCE_AMOUNT
, INTEREST_CODE_COMBINATION_ID
, TERMS_DATE_BASIS
, ALLOW_FUTURE_PAY_FLAG
, AUTO_TAX_CALC_FLAG
, AUTOMATIC_OFFSETS_FLAG
, LIABILITY_POST_LOOKUP_CODE
, INTEREST_ACCTS_PAY_CCID
, LIABILITY_POST_OPTION
, DISCOUNT_DISTRIBUTION_METHOD
, RATE_VAR_CODE_COMBINATION_ID
, COMBINED_FILING_FLAG
, INCOME_TAX_REGION
, INCOME_TAX_REGION_FLAG
, HOLD_UNMATCHED_INVOICES_FLAG
, ALLOW_DIST_MATCH_FLAG
, ALLOW_FINAL_MATCH_FLAG
, ALLOW_FLEX_OVERRIDE_FLAG
, ALLOW_PAID_INVOICE_ADJUST
, USSGL_TRANSACTION_CODE
, USSGL_TRX_CODE_CONTEXT
, INV_DOC_CATEGORY_OVERRIDE
, PAY_DOC_CATEGORY_OVERRIDE
, VENDOR_AUTO_INT_DEFAULT
, SUMMARY_JOURNALS_DEFAULT
, RATE_VAR_GAIN_CCID
, RATE_VAR_LOSS_CCID
, TRANSFER_DESC_FLEX_FLAG
, ALLOW_AWT_FLAG
, DEFAULT_AWT_GROUP_ID
, ALLOW_AWT_OVERRIDE
, CREATE_AWT_DISTS_TYPE
, CREATE_AWT_INVOICES_TYPE
, AWT_INCLUDE_DISCOUNT_AMT
, AWT_INCLUDE_TAX_AMT
, ORG_ID
, RECON_ACCOUNTING_FLAG
, AUTO_CREATE_FREIGHT_FLAG
, FREIGHT_CODE_COMBINATION_ID
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, ALLOW_SUPPLIER_BANK_OVERRIDE
, USE_MULTIPLE_SUPPLIER_BANKS
, AUTO_TAX_CALC_OVERRIDE
, AMOUNT_INCLUDES_TAX_FLAG
, AMOUNT_INCLUDES_TAX_OVERRIDE
, VAT_CODE
, USE_BANK_CHARGE_FLAG
, BANK_CHARGE_BEARER
, ROUNDING_ERROR_CCID
, ROUNDING_ERROR_POST_OPTION
, TAX_FROM_PO_FLAG
, TAX_FROM_VENDOR_SITE_FLAG
, TAX_FROM_VENDOR_FLAG
, TAX_FROM_ACCOUNT_FLAG
, TAX_FROM_SYSTEM_FLAG
, TAX_FROM_INV_HEADER_FLAG
, TAX_FROM_TEMPLATE_FLAG
, TAX_HIER_PO_SHIPMENT
, TAX_HIER_VENDOR
, TAX_HIER_VENDOR_SITE
, TAX_HIER_ACCOUNT
, TAX_HIER_SYSTEM
, TAX_HIER_INVOICE
, TAX_HIER_TEMPLATE
, ENFORCE_TAX_FROM_ACCOUNT
, MRC_BASE_CURRENCY_CODE
, MRC_SECONDARY_SET_OF_BOOKS_ID
, MATCH_OPTION
, GAIN_LOSS_CALC_LEVEL
, WHEN_TO_ACCOUNT_PMT
, WHEN_TO_ACCOUNT_GAIN_LOSS
, FUTURE_DATED_PMT_ACCT_SOURCE
, FUTURE_DATED_PMT_LIAB_RELIEF
, GL_TRANSFER_ALLOW_OVERRIDE
, GL_TRANSFER_PROCESS_DAYS
, GL_TRANSFER_MODE
, GL_TRANSFER_SUBMIT_JOURNAL_IMP
, INCLUDE_REPORTING_SOB
, EXPENSE_REPORT_ID
, PREPAYMENT_TERMS_ID
, CALC_USER_XRATE
, SORT_BY_ALTERNATE_FIELD
, APPROVAL_WORKFLOW_FLAG
, ALLOW_FORCE_APPROVAL_FLAG
, VALIDATE_BEFORE_APPROVAL_FLAG
, XML_PAYMENTS_AUTO_CONFIRM_FLAG
, PRORATE_INT_INV_ACROSS_DISTS
, BUILD_PREPAYMENT_ACCOUNTS_FLAG
, ENABLE_1099_ON_AWT_FLAG
, STOP_PREPAY_ACROSS_BAL_FLAG
, AUTOMATIC_OFFSETS_CHANGE_FLAG
, TOLERANCE_ID
, PREPAY_TAX_DIFF_CCID
, CE_BANK_ACCT_USE_ID
, APPROVAL_TIMING
, SERVICES_TOLERANCE_ID
, RECEIPT_ACCEPTANCE_DAYS
, TAX_TOLERANCE
, TAX_TOL_AMT_RANGE
, ALLOW_INV_THIRD_PARTY_OVRD
, ALLOW_PYMT_THIRD_PARTY_OVRD
FROM AP.AP_SYSTEM_PARAMETERS_ALL;
AP.AP_SYSTEM_PARAMETERS_ALL does not reference any database object
AP.AP_SYSTEM_PARAMETERS_ALL is referenced by following:
APPS
AP_SYSTEM_PARAMETERS
AP_SYSTEM_PARAMETERS_ALL
|
|
|
|