1. Tables and Views for Financials
  2. AP_TAX_CODES_ALL

AP_TAX_CODES_ALL

AP_TAX_CODES_ALL contains information about the tax codes you define. You need one row for each tax code you want to use when entering invoices. When you enter invoices, you can use a list of values to select a tax code defined in this table. Your Oracle Payables application also uses TAX_RATE to calculate use tax when you enter a taxable amount for an invoice. . This table corresponds to the Tax Codes window.

Details

  • Schema: FUSION

  • Object owner: AP

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

AP_TAX_CODES_PK

TAX_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping
NAME VARCHAR2 15 Yes A unique code that identifies the withholding tax rates applicable on supplier invoices.
TAX_ID NUMBER 18 Yes A unique identifier for withholding tax code.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
TAX_TYPE VARCHAR2 25 Yes Type of tax code (for example, SALES or USE)
SET_OF_BOOKS_ID NUMBER 18 Yes Ledger on which the withholding tax code is applicable.
DESCRIPTION VARCHAR2 240 Description of the withholding tax code.
TAX_RATE NUMBER Rate used to calculate withholding tax.
TAX_CODE_COMBINATION_ID NUMBER 18 Accounting Flexfield identifier for tax expense account
INACTIVE_DATE DATE Date when the withholding tax code will become inactive.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield. Tax Codes (AP_TAX_CODES)
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Tax Codes (AP_TAX_CODES)
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Tax Codes (AP_TAX_CODES)
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Tax Codes (AP_TAX_CODES)
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Tax Codes (AP_TAX_CODES)
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Tax Codes (AP_TAX_CODES)
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Tax Codes (AP_TAX_CODES)
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Tax Codes (AP_TAX_CODES)
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Tax Codes (AP_TAX_CODES)
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Tax Codes (AP_TAX_CODES)
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Tax Codes (AP_TAX_CODES)
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Tax Codes (AP_TAX_CODES)
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Tax Codes (AP_TAX_CODES)
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Tax Codes (AP_TAX_CODES)
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Tax Codes (AP_TAX_CODES)
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Tax Codes (AP_TAX_CODES)
AWT_VENDOR_ID NUMBER 18 Tax authority supplier identifier
AWT_VENDOR_SITE_ID NUMBER 18 Tax authority supplier site identifier
AWT_PERIOD_TYPE VARCHAR2 15 Name given to a payables calendar used for withholding taxes.
AWT_PERIOD_LIMIT NUMBER Amount limit for withheld amount per supplier
RANGE_AMOUNT_BASIS VARCHAR2 25 Indicates whether amount ranges apply to amount subject to withholding or to the amount withheld
RANGE_PERIOD_BASIS VARCHAR2 25 Indicates whether amount ranges apply to the amount withheld to-date per period or to the amount per invoice
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
VAT_TRANSACTION_TYPE VARCHAR2 30 Value-added tax transaction type.
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.
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.
WEB_ENABLED_FLAG VARCHAR2 1 Flag that indicates if Tax Name is enabled for Self-Service Expenses
AWT_RATE_TYPE VARCHAR2 30 Specifies the type of rate for a withholding tax (F - Flat rate, P - Period limit, R - Amount ranges)
TAX_RECOVERY_RULE_ID NUMBER 18 A tax recovery rule identifier assigned to this tax code. Foreign Key to AP_TAX_RECVRY_RULES_ALL, reference RULE_ID
TAX_RECOVERY_RATE NUMBER Tax recovery rate assigned to this tax code as an alternative to a tax recovery rule
START_DATE DATE Effective start date for this tax code
ENABLED_FLAG VARCHAR2 1 Enabled flag for this tax code. This provides additional flexibility for effective date handling across tax codes
OFFSET_TAX_CODE_ID NUMBER 18 Tax Code ID for related offset tax
SUPPRESS_ZERO_AMOUNT_FLAG VARCHAR2 1 Don't Create Zero Amount Accounting or Invoices
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.

Foreign Keys

Table Foreign Table Foreign Key Column
AP_TAX_CODES_ALL gl_ledgers SET_OF_BOOKS_ID
AP_TAX_CODES_ALL gl_code_combinations TAX_CODE_COMBINATION_ID
AP_TAX_CODES_ALL poz_suppliers AWT_VENDOR_ID
AP_TAX_CODES_ALL ap_tax_codes_all OFFSET_TAX_CODE_ID
ap_tax_codes_all ap_tax_codes_all OFFSET_TAX_CODE_ID
zx_id_tcc_mapping_all ap_tax_codes_all TAX_RATE_CODE_ID
zx_lines_det_factors ap_tax_codes_all HISTORICAL_TAX_CODE_ID
ap_invoice_lines_interface ap_tax_codes_all TAX_CODE_ID
ap_invoice_distributions_all ap_tax_codes_all TAX_CODE_ID

Indexes

Index Uniqueness Columns
AP_TAX_CODES_N1 Non Unique NAME
AP_TAX_CODES_U1 Unique TAX_ID