1. Tables and Views for Financials
  2. ZX_EXEMPTIONS_STG

ZX_EXEMPTIONS_STG

This table stores tax exemption details that need to be imported into tax exemptions table.

Details

  • Schema: FUSION

  • Object owner: ZX

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Not-null Comments Status
BATCH_NAME VARCHAR2 30 Yes Batch name to identify the set of records to be processed. Active
PARTY_NUMBER VARCHAR2 240 Yes Party number used to identify the party Active
PARTY_NAME VARCHAR2 240 Party name used to identify the party Active
PARTY_TYPE_CODE VARCHAR2 30 Yes Lookup code to indicate the party type for party tax profile. Active
PARTY_TYPE_FLAG VARCHAR2 1 Yes Flag to identify party type of the exemption. Active
EXEMPTION_TYPE_CODE VARCHAR2 30 Lookup code that indicates the type of this exemption. Possible values are DISCOUNT and SPECIAL_RATE.This is the method of calculating the exemption percentage. Active
EXEMPTION_STATUS_CODE VARCHAR2 30 Lookup code that indicates approval status for this exemption. Active
TAX_REGIME_CODE VARCHAR2 30 Tax regime code for this exemption Active
TAX_STATUS_CODE VARCHAR2 30 Tax status code for this exemption Active
TAX_CODE VARCHAR2 30 Stores tax code for this exemption Active
TAX_RATE_CODE VARCHAR2 30 Tax rate code for this exemption Active
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 80 Exemption certificate number. This is the certificate number that applies to this exemption and considered during tax calculation, if entered on the transaction line. Active
EXEMPT_REASON_CODE VARCHAR2 30 Lookup code that indicates the reason for this exemption. This is the exempt reason that applies to this exemption and considered during tax calculation, if entered on the transaction line. Active
ISSUING_TAX_AUTHORITY_NAME VARCHAR2 360 The tax authority that has issued the exemption certificate for this exemption. Active
EFFECTIVE_FROM DATE Yes Effective from date. This date should be within the date range of the entities (tax regime, tax, tax status, tax rate, and tax jurisdiction) related to this tax exemption. Active
EFFECTIVE_TO DATE Effective to date. This date should be within the date range of the entities (tax regime, tax, tax status, tax rate, and tax jurisdiction) related to this tax exemption. Active
CONTENT_OWNER_NAME VARCHAR2 240 Configuration owner of this tax. Active
ITEM_NUMBER VARCHAR2 240 Item number to identify the Item Active
INVENTORY_ORG_NAME VARCHAR2 240 Name of the inventory organization for the item. This is applicable for product-specific exemption. Active
RATE_MODIFIER NUMBER Percentage of the original tax rate that is exempt if exemption type is discount. Percentage of tax rate if exemption type is special / surcharge. Active
TAX_JURISDICTION_CODE VARCHAR2 30 Tax jurisdiction for the exemption. Active
APPLY_TO_LOWER_LEVELS_FLAG VARCHAR2 1 Y or N Indicates if this exemption is applicable to taxes at lower levels. This indicates that this exemption applies to all taxes that use this tax as the tax exemptions source. Active
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
RECORD_STATUS NUMBER Gives the validation status of the record being processed: NULL - only these records will be picked up for processing by program 0 - record picked up by concurrent program for validation 1 -all id???s validated 2 - successful record 3 - error record Active
LOAD_REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. Active
LOAD_STATUS VARCHAR2 30 Enterprise Service Scheduler: indicates the request status of the interface load job that created the row. Active
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
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. Active

Indexes

Index Uniqueness Tablespace Columns Status
ZX_EXEMPTIONS_STG_N1 Non Unique FUSION_TS_TX_IDX PARTY_NAME, PARTY_TYPE_CODE, PARTY_NUMBER Active