AP_AWT_TAX_RATES_ALL

AP_AWT_TAX_RATES_ALL contains tax rates for Withholding tax type tax codes. Oracle Payables predefines the Standard and Penalty tax rate types for withholding taxes. In addition, Certificate rate types are assigned to a specific supplier site and Exception rate types are assigned to a specific invoice. START_AMOUNT and END_AMOUNT columns are only used if the parent withholding tax uses amount ranges.

Details

  • Schema: FUSION

  • Object owner: AP

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

AP_AWT_TAX_RATES_PK

TAX_RATE_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping
TAX_RATE_ID NUMBER 18 Yes Withholding tax rate identifier
TAX_NAME VARCHAR2 15 Yes Withholding tax name for which tax rates are defined.
TAX_RATE NUMBER Yes Percentage that is deducted from the amount due to the supplier and paid to the tax authority on behalf of the supplier.
RATE_TYPE VARCHAR2 25 Yes Indicates the category of the withholding tax rates, such as standard or penalty.
START_DATE DATE Start date to withhold for this rate
END_DATE DATE End date to withhold for this rate
START_AMOUNT NUMBER Start amount for given amount range.
END_AMOUNT NUMBER End amount for given amount range.
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.
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.
VENDOR_ID NUMBER 18 Unique identifier of supplier if any certificates are defined.
VENDOR_SITE_ID NUMBER 18 Supplier site identifier. Required when VENDOR_ID is populated
INVOICE_NUM VARCHAR2 50 Invoice Number. Oracle Payables stores the invoice number and not the invoice identifier because the invoice may not have been entered at the time of the creation of this record
CERTIFICATE_NUMBER VARCHAR2 50 Certificate number associated with tax exemption.
CERTIFICATE_TYPE VARCHAR2 30 Certificate type (user-definable)
COMMENTS VARCHAR2 255 Additional details that can be tracked in comments.
PRIORITY NUMBER Must be entered if two or more certificates cover the same supplier site; must be unique within the date range for the supplier site
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield. Withholding Tax Rates (AP_AWT_TAX_RATES)
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Withholding Tax Rates (AP_AWT_TAX_RATES)
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Withholding Tax Rates (AP_AWT_TAX_RATES)
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Withholding Tax Rates (AP_AWT_TAX_RATES)
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Withholding Tax Rates (AP_AWT_TAX_RATES)
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Withholding Tax Rates (AP_AWT_TAX_RATES)
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Withholding Tax Rates (AP_AWT_TAX_RATES)
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Withholding Tax Rates (AP_AWT_TAX_RATES)
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Withholding Tax Rates (AP_AWT_TAX_RATES)
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Withholding Tax Rates (AP_AWT_TAX_RATES)
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Withholding Tax Rates (AP_AWT_TAX_RATES)
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Withholding Tax Rates (AP_AWT_TAX_RATES)
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Withholding Tax Rates (AP_AWT_TAX_RATES)
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Withholding Tax Rates (AP_AWT_TAX_RATES)
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Withholding Tax Rates (AP_AWT_TAX_RATES)
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Withholding Tax Rates (AP_AWT_TAX_RATES)
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
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.
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_AWT_TAX_RATES_ALL ap_invoices_all VENDOR_ID, INVOICE_NUM, ORG_ID
AP_AWT_TAX_RATES_ALL poz_suppliers VENDOR_ID
ap_invoice_lines_all ap_awt_tax_rates_all TAX_RATE_ID
ap_invoice_distributions_all ap_awt_tax_rates_all AWT_TAX_RATE_ID
ap_awt_temp_distributions_all ap_awt_tax_rates_all TAX_RATE_ID

Indexes

Index Uniqueness Tablespace Columns
AP_AWT_TAX_RATES_ALL_U1 Unique Default TAX_RATE_ID
AP_AWT_TAX_RATES_N1 Non Unique Default TAX_NAME, RATE_TYPE