[Home] [Help] [Dependency Information]
Object Name: | AP_SYSTEM_PARAMETERS_ALL# |
---|---|
Object Type: | VIEW |
Owner: | AP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
BASE_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
RECALC_PAY_SCHEDULE_FLAG | VARCHAR2 | (1) | Yes | |
AUTO_CALCULATE_INTEREST_FLAG | VARCHAR2 | (1) | Yes | |
INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | ||
PAYMENT_CURRENCY_CODE | VARCHAR2 | (15) | ||
INVOICE_NET_GROSS_FLAG | VARCHAR2 | (1) | ||
BANK_ACCOUNT_ID | NUMBER | (15) | ||
CHECK_OVERFLOW_LOOKUP_CODE | VARCHAR2 | (25) | ||
BATCH_CONTROL_FLAG | VARCHAR2 | (1) | ||
TERMS_ID | NUMBER | (15) | ||
ALWAYS_TAKE_DISC_FLAG | VARCHAR2 | (1) | ||
PAY_DATE_BASIS_LOOKUP_CODE | VARCHAR2 | (25) | ||
ACCTS_PAY_CODE_COMBINATION_ID | NUMBER | (15) | ||
SALES_TAX_CODE_COMBINATION_ID | NUMBER | (15) | ||
DISC_LOST_CODE_COMBINATION_ID | NUMBER | (15) | ||
DISC_TAKEN_CODE_COMBINATION_ID | NUMBER | (15) | ||
HOLD_GAIN_CODE_COMBINATION_ID | NUMBER | (15) | ||
TRANS_GAIN_CODE_COMBINATION_ID | NUMBER | (15) | ||
APPLY_ADVANCES_DEFAULT | VARCHAR2 | (4) | ||
ADD_DAYS_SETTLEMENT_DATE | NUMBER | (15) | ||
COST_OF_MONEY | NUMBER | |||
DAYS_BETWEEN_CHECK_CYCLES | NUMBER | (15) | ||
FEDERAL_IDENTIFICATION_NUM | VARCHAR2 | (20) | ||
LOCATION_ID | NUMBER | (15) | ||
CREATE_EMPLOYEE_VENDOR_FLAG | VARCHAR2 | (1) | ||
EMPLOYEE_TERMS_ID | NUMBER | (15) | ||
EMPLOYEE_PAY_GROUP_LOOKUP_CODE | VARCHAR2 | (25) | ||
EMPLOYEE_PAYMENT_PRIORITY | NUMBER | (2) | ||
PREPAY_CODE_COMBINATION_ID | NUMBER | (15) | ||
CONFIRM_DATE_AS_INV_NUM_FLAG | VARCHAR2 | (1) | ||
UPDATE_PAY_SITE_FLAG | VARCHAR2 | (1) | ||
DEFAULT_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
GAIN_CODE_COMBINATION_ID | NUMBER | (15) | ||
LOSS_CODE_COMBINATION_ID | NUMBER | (15) | ||
MAKE_RATE_MANDATORY_FLAG | VARCHAR2 | (1) | ||
MULTI_CURRENCY_FLAG | VARCHAR2 | (1) | ||
GL_DATE_FROM_RECEIPT_FLAG | VARCHAR2 | (25) | ||
DISC_IS_INV_LESS_TAX_FLAG | VARCHAR2 | (1) | ||
MATCH_ON_TAX_FLAG | VARCHAR2 | (1) | ||
ACCOUNTING_METHOD_OPTION | VARCHAR2 | (25) | ||
EXPENSE_POST_OPTION | VARCHAR2 | (25) | ||
DISCOUNT_TAKEN_POST_OPTION | VARCHAR2 | (25) | ||
GAIN_LOSS_POST_OPTION | VARCHAR2 | (25) | ||
CASH_POST_OPTION | VARCHAR2 | (25) | ||
FUTURE_PAY_POST_OPTION | VARCHAR2 | (25) | ||
DATE_FORMAT_LOOKUP_CODE | VARCHAR2 | (25) | ||
REPLACE_CHECK_FLAG | VARCHAR2 | (1) | ||
ONLINE_PRINT_FLAG | VARCHAR2 | (1) | ||
EFT_USER_NUMBER | VARCHAR2 | (30) | ||
MAX_OUTLAY | NUMBER | |||
VENDOR_PAY_GROUP_LOOKUP_CODE | VARCHAR2 | (25) | ||
REQUIRE_TAX_ENTRY_FLAG | VARCHAR2 | (1) | ||
APPROVALS_OPTION | VARCHAR2 | (25) | ||
POST_DATED_PAYMENTS_FLAG | VARCHAR2 | (1) | ||
SECONDARY_ACCOUNTING_METHOD | VARCHAR2 | (25) | ||
SECONDARY_SET_OF_BOOKS_ID | NUMBER | (15) | ||
TAKE_VAT_BEFORE_DISCOUNT_FLAG | VARCHAR2 | (1) | ||
INTEREST_TOLERANCE_AMOUNT | NUMBER | |||
INTEREST_CODE_COMBINATION_ID | NUMBER | (15) | ||
TERMS_DATE_BASIS | VARCHAR2 | (25) | ||
ALLOW_FUTURE_PAY_FLAG | VARCHAR2 | (1) | ||
AUTO_TAX_CALC_FLAG | VARCHAR2 | (1) | ||
AUTOMATIC_OFFSETS_FLAG | VARCHAR2 | (1) | ||
LIABILITY_POST_LOOKUP_CODE | VARCHAR2 | (25) | ||
INTEREST_ACCTS_PAY_CCID | NUMBER | (15) | ||
LIABILITY_POST_OPTION | VARCHAR2 | (25) | ||
DISCOUNT_DISTRIBUTION_METHOD | VARCHAR2 | (25) | ||
RATE_VAR_CODE_COMBINATION_ID | NUMBER | (15) | ||
COMBINED_FILING_FLAG | VARCHAR2 | (1) | ||
INCOME_TAX_REGION | VARCHAR2 | (10) | ||
INCOME_TAX_REGION_FLAG | VARCHAR2 | (1) | ||
HOLD_UNMATCHED_INVOICES_FLAG | VARCHAR2 | (1) | ||
ALLOW_DIST_MATCH_FLAG | VARCHAR2 | (1) | ||
ALLOW_FINAL_MATCH_FLAG | VARCHAR2 | (1) | ||
ALLOW_FLEX_OVERRIDE_FLAG | VARCHAR2 | (1) | ||
ALLOW_PAID_INVOICE_ADJUST | VARCHAR2 | (1) | ||
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
USSGL_TRX_CODE_CONTEXT | VARCHAR2 | (30) | ||
INV_DOC_CATEGORY_OVERRIDE | VARCHAR2 | (1) | ||
PAY_DOC_CATEGORY_OVERRIDE | VARCHAR2 | (1) | ||
VENDOR_AUTO_INT_DEFAULT | VARCHAR2 | (1) | ||
SUMMARY_JOURNALS_DEFAULT | VARCHAR2 | (1) | ||
RATE_VAR_GAIN_CCID | NUMBER | (15) | ||
RATE_VAR_LOSS_CCID | NUMBER | (15) | ||
TRANSFER_DESC_FLEX_FLAG | VARCHAR2 | (1) | ||
ALLOW_AWT_FLAG | VARCHAR2 | (1) | ||
DEFAULT_AWT_GROUP_ID | NUMBER | (15) | ||
ALLOW_AWT_OVERRIDE | VARCHAR2 | (1) | ||
CREATE_AWT_DISTS_TYPE | VARCHAR2 | (25) | ||
CREATE_AWT_INVOICES_TYPE | VARCHAR2 | (25) | ||
AWT_INCLUDE_DISCOUNT_AMT | VARCHAR2 | (1) | ||
AWT_INCLUDE_TAX_AMT | VARCHAR2 | (1) | ||
ORG_ID | NUMBER | (15) | ||
RECON_ACCOUNTING_FLAG | VARCHAR2 | (1) | ||
AUTO_CREATE_FREIGHT_FLAG | VARCHAR2 | (1) | ||
FREIGHT_CODE_COMBINATION_ID | NUMBER | (15) | ||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | ||
GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | ||
ALLOW_SUPPLIER_BANK_OVERRIDE | VARCHAR2 | (1) | ||
USE_MULTIPLE_SUPPLIER_BANKS | VARCHAR2 | (1) | ||
AUTO_TAX_CALC_OVERRIDE | VARCHAR2 | (1) | ||
AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2 | (1) | ||
AMOUNT_INCLUDES_TAX_OVERRIDE | VARCHAR2 | (1) | ||
VAT_CODE | VARCHAR2 | (15) | ||
USE_BANK_CHARGE_FLAG | VARCHAR2 | (1) | ||
BANK_CHARGE_BEARER | VARCHAR2 | (1) | ||
ROUNDING_ERROR_CCID | NUMBER | (15) | ||
ROUNDING_ERROR_POST_OPTION | VARCHAR2 | (25) | ||
TAX_FROM_PO_FLAG | VARCHAR2 | (1) | ||
TAX_FROM_VENDOR_SITE_FLAG | VARCHAR2 | (1) | ||
TAX_FROM_VENDOR_FLAG | VARCHAR2 | (1) | ||
TAX_FROM_ACCOUNT_FLAG | VARCHAR2 | (1) | ||
TAX_FROM_SYSTEM_FLAG | VARCHAR2 | (1) | ||
TAX_FROM_INV_HEADER_FLAG | VARCHAR2 | (1) | ||
TAX_FROM_TEMPLATE_FLAG | VARCHAR2 | (1) | ||
TAX_HIER_PO_SHIPMENT | NUMBER | |||
TAX_HIER_VENDOR | NUMBER | |||
TAX_HIER_VENDOR_SITE | NUMBER | |||
TAX_HIER_ACCOUNT | NUMBER | |||
TAX_HIER_SYSTEM | NUMBER | |||
TAX_HIER_INVOICE | NUMBER | |||
TAX_HIER_TEMPLATE | NUMBER | |||
ENFORCE_TAX_FROM_ACCOUNT | VARCHAR2 | (1) | ||
MRC_BASE_CURRENCY_CODE | VARCHAR2 | (2000) | ||
MRC_SECONDARY_SET_OF_BOOKS_ID | VARCHAR2 | (2000) | ||
MATCH_OPTION | VARCHAR2 | (25) | ||
GAIN_LOSS_CALC_LEVEL | VARCHAR2 | (30) | ||
WHEN_TO_ACCOUNT_PMT | VARCHAR2 | (30) | ||
WHEN_TO_ACCOUNT_GAIN_LOSS | VARCHAR2 | (30) | ||
FUTURE_DATED_PMT_ACCT_SOURCE | VARCHAR2 | (30) | ||
FUTURE_DATED_PMT_LIAB_RELIEF | VARCHAR2 | (30) | ||
GL_TRANSFER_ALLOW_OVERRIDE | VARCHAR2 | (1) | ||
GL_TRANSFER_PROCESS_DAYS | NUMBER | (15) | ||
GL_TRANSFER_MODE | VARCHAR2 | (1) | ||
GL_TRANSFER_SUBMIT_JOURNAL_IMP | VARCHAR2 | (1) | ||
INCLUDE_REPORTING_SOB | VARCHAR2 | (1) | ||
EXPENSE_REPORT_ID | NUMBER | (15) | ||
PREPAYMENT_TERMS_ID | NUMBER | (15) | ||
CALC_USER_XRATE | VARCHAR2 | (1) | ||
SORT_BY_ALTERNATE_FIELD | VARCHAR2 | (1) | ||
APPROVAL_WORKFLOW_FLAG | VARCHAR2 | (1) | Yes | |
ALLOW_FORCE_APPROVAL_FLAG | VARCHAR2 | (1) | Yes | |
VALIDATE_BEFORE_APPROVAL_FLAG | VARCHAR2 | (1) | Yes | |
XML_PAYMENTS_AUTO_CONFIRM_FLAG | VARCHAR2 | (1) | ||
PRORATE_INT_INV_ACROSS_DISTS | VARCHAR2 | (1) | ||
BUILD_PREPAYMENT_ACCOUNTS_FLAG | VARCHAR2 | (1) | ||
ENABLE_1099_ON_AWT_FLAG | VARCHAR2 | (1) | ||
STOP_PREPAY_ACROSS_BAL_FLAG | VARCHAR2 | (1) | ||
AUTOMATIC_OFFSETS_CHANGE_FLAG | VARCHAR2 | (1) | ||
TOLERANCE_ID | NUMBER | (15) | ||
PREPAY_TAX_DIFF_CCID | NUMBER | (15) | ||
CE_BANK_ACCT_USE_ID | NUMBER | (15) | ||
APPROVAL_TIMING | VARCHAR2 | (30) | ||
SERVICES_TOLERANCE_ID | NUMBER | (15) | ||
RECEIPT_ACCEPTANCE_DAYS | NUMBER | (15) | ||
TAX_TOLERANCE | NUMBER | |||
TAX_TOL_AMT_RANGE | NUMBER | |||
ALLOW_INV_THIRD_PARTY_OVRD | VARCHAR2 | (1) | ||
ALLOW_PYMT_THIRD_PARTY_OVRD | VARCHAR2 | (1) | ||
WITHHOLDING_DATE_BASIS | VARCHAR2 | (20) | ||
INVRATE_FOR_PREPAY_TAX | VARCHAR2 | (1) |
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#;
|
|
|