[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 |
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.
| 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 - user who last updated this row (foreign key to FND_USER.USER_ID). |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of books identifier |
| BASE_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Functional currency code |
| RECALC_PAY_SCHEDULE_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates if scheduled payments automatically recalculate for Automatic Interest Calculation (Y or N) |
| 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 | |
| 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) | Default terms | |
| 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 | (15) | Accounting Flexfield identifier for accounts payable liability account | |
| 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) | Accounting Flexfield identifier for discounts taken account | |
| 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) | 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 | (15) | Location identifier for headquarters location of your 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) | Employee terms identifier | |
| EMPLOYEE_PAY_GROUP_LOOKUP_CODE | VARCHAR2 | (25) | Name of Pay Group used for payment of employee expense reports | |
| EMPLOYEE_PAYMENT_PRIORITY | NUMBER | (2) | Payment priority number for payment of employee expense reports | |
| 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) | Flag that indicates if changes to supplier payment address on manual payments or Quick payments is allowed (Y or N) | |
| DEFAULT_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type | |
| 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) | Flag that indicates if exchange rates must be entered for multiple currency invoices and payments (Y or N) | |
| MULTI_CURRENCY_FLAG | VARCHAR2 | (1) | Flag that indicates if multiple currency features used (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) | |
| 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) | Flag that 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 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) | Name of supplier Pay Group | |
| 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) | 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 | (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) | Date used together with payment terms and invoice amount to create invoice scheduled payment | |
| ALLOW_FUTURE_PAY_FLAG | VARCHAR2 | (1) | No longer used | |
| AUTO_TAX_CALC_FLAG | VARCHAR2 | (1) | No longer used | |
| AUTOMATIC_OFFSETS_FLAG | VARCHAR2 | (1) | Flag that indicates whether offsetting, balancing accounting entries are automatically created for invoice and payment distributions (Y or N) | |
| LIABILITY_POST_LOOKUP_CODE | VARCHAR2 | (25) | Code for method used to build offsetting Accounting Flexfields for invoice and payment distributions (Automatic Offsets/Fund Accounting) | |
| 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 | |
| RATE_VAR_CODE_COMBINATION_ID | NUMBER | (15) | No longer used | |
| 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 | |
| HOLD_UNMATCHED_INVOICES_FLAG | VARCHAR2 | (1) | Default Hold Unmatched Invoices value for suppliers created from employees on an expense report | |
| ALLOW_DIST_MATCH_FLAG | VARCHAR2 | (1) | Flag that indicates whether you 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 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) | |
| 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) | Flag to indicate whether Automatic Withholding Tax is allowed (Y or N) | |
| DEFAULT_AWT_GROUP_ID | NUMBER | (15) | 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 | (15) | Organization identifier | |
| RECON_ACCOUNTING_FLAG | VARCHAR2 | (1) | Flag to indicate if cash clearing account is used | |
| 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 to indicate if Bank Charge feature is used | |
| BANK_CHARGE_BEARER | VARCHAR2 | (1) | Default bank charge bearer | |
| ROUNDING_ERROR_CCID | NUMBER | (15) | Rounding error account code combination | |
| 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) | 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 | |
| MATCH_OPTION | VARCHAR2 | (25) | Flag to indicate whether to match invoices to purchase orders (P) or receipts (R) | |
| 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) | Specifies the source for the future dated payment account | |
| 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) | Not currently 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) | If this option is set to 'Y' then all MRC reporting SOB's will automatically be selected for transfer with the same selection criteria as the main SOB's | |
| EXPENSE_REPORT_ID | NUMBER | (15) | Default expense report template | |
| PREPAYMENT_TERMS_ID | NUMBER | (15) | Default terms for prepayment | |
| CALC_USER_XRATE | VARCHAR2 | (1) | 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) | Sort reports by alternate field value. | |
| 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 online 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) | Flag that indicates if the XML Payment Automatic Confirmation feature is enabled | |
| PRORATE_INT_INV_ACROSS_DISTS | VARCHAR2 | (1) | No longer used | |
| BUILD_PREPAYMENT_ACCOUNTS_FLAG | VARCHAR2 | (1) | Flag indicating whether the prepayment account should be built or defaulted | |
| ENABLE_1099_ON_AWT_FLAG | VARCHAR2 | (1) | This flag corresponds to the Include Income Tax Type on Withholding Distributions Payables option, which helps you 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 | |
| PREPAY_TAX_DIFF_CCID | NUMBER | (15) | Account to which any prepayment tax difference amount will be charged. | |
| CE_BANK_ACCT_USE_ID | NUMBER | (15) | Bank account identifier | |
| 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) | Number of days in receipt acceptance period | |
| 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) | Used to store value to allow third party override in invoices | |
| ALLOW_PYMT_THIRD_PARTY_OVRD | VARCHAR2 | (1) | Used to store value to allow third party override in payments | |
| WITHHOLDING_DATE_BASIS | VARCHAR2 | (20) | Date basis used to derive AWT rate | |
| INVRATE_FOR_PREPAY_TAX | VARCHAR2 | (1) | INVRATE_FOR_PREPAY_TAX for storing the Option which would determine what rate (Prepay Invoice Rate or Std Invoice rate) would be used for Prepaid Expense records (while accounting Prepayment application events) which correspond to Advance taxes. |
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
, WITHHOLDING_DATE_BASIS
, INVRATE_FOR_PREPAY_TAX
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:
AP
AP_SYSTEM_PARAMETERS_ALL#
|
|
|
|