ZX_LINES
This table stores detail tax lines for transactions of multiple event classes.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
ZX_LINES_PK |
TAX_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TAX_LINE_ID | NUMBER | 18 | Yes | Tax line identifier | |
| INTERNAL_ORGANIZATION_ID | NUMBER | Yes | Internal organization identifier of the transaction | ||
| APPLICATION_ID | NUMBER | Yes | Application identifier of the transaction | ||
| ENTITY_CODE | VARCHAR2 | 30 | Yes | Entity code of the transaction | |
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Yes | Event class code of the transaction | |
| EVENT_TYPE_CODE | VARCHAR2 | 30 | Application event type code of the transaction | ||
| TRX_ID | NUMBER | Yes | Transaction identifier | ||
| TRX_LINE_ID | NUMBER | Yes | Transaction line identifier | ||
| TRX_LEVEL_TYPE | VARCHAR2 | 30 | Yes | Column to record the level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. | |
| TRX_LINE_NUMBER | NUMBER | Trasnaction line number | |||
| DOC_EVENT_STATUS | VARCHAR2 | 30 | Lookup code that indicates event status of the transaction | ||
| TAX_EVENT_CLASS_CODE | VARCHAR2 | 30 | Tax event class code of the transaction | ||
| TAX_EVENT_TYPE_CODE | VARCHAR2 | 30 | Tax event type code of the transaction | ||
| TAX_LINE_NUMBER | NUMBER | Yes | Line number generated for this tax line | ||
| CONTENT_OWNER_ID | NUMBER | 18 | Party tax profile identifier for the first party organization of the transaction | ||
| TAX_REGIME_ID | NUMBER | 18 | Tax regime identifier | ||
| TAX_REGIME_CODE | VARCHAR2 | 30 | Tax regime code | ||
| TAX_ID | NUMBER | 18 | Tax identifier | ||
| TAX | VARCHAR2 | 30 | Tax | ||
| TAX_STATUS_ID | NUMBER | 18 | Tax status identifier | ||
| TAX_STATUS_CODE | VARCHAR2 | 30 | Tax status code | ||
| TAX_RATE_ID | NUMBER | 18 | Tax rate identifier | ||
| TAX_RATE_CODE | VARCHAR2 | 150 | Tax rate code | ||
| TAX_RATE | NUMBER | Tax rate | |||
| TAX_APPORTIONMENT_LINE_NUMBER | NUMBER | Apportionment line number for this tax line when multiple tax lines are created for the same tax during migration from prior releases | |||
| TRX_ID_LEVEL2 | NUMBER | Transaction identifier at a level between trx_id and trx_line_id | |||
| TRX_ID_LEVEL3 | NUMBER | Transaction identifier at a level between trx_id_level2 and trx_line_id | |||
| TRX_ID_LEVEL4 | NUMBER | Transaction identifier at a level between trx_id_level3 and trx_line_id | |||
| TRX_ID_LEVEL5 | NUMBER | Transaction identifier at a level between trx_id_level4 and trx_line_id | |||
| TRX_ID_LEVEL6 | NUMBER | Transaction identifier at a level between trx_id_level5 and trx_line_id | |||
| TRX_USER_KEY_LEVEL1 | VARCHAR2 | 150 | First component of the user composite key to uniquely identify the transaction | ||
| TRX_USER_KEY_LEVEL2 | VARCHAR2 | 150 | Second component of the user composite key to uniquely identify the transaction | ||
| TRX_USER_KEY_LEVEL3 | VARCHAR2 | 150 | Third component of the user composite key to uniquely identify the transaction | ||
| TRX_USER_KEY_LEVEL4 | VARCHAR2 | 150 | Fourth component of the user composite key to uniquely identify the transaction | ||
| TRX_USER_KEY_LEVEL5 | VARCHAR2 | 150 | Fifth component of the user composite key to uniquely identify the transaction | ||
| TRX_USER_KEY_LEVEL6 | VARCHAR2 | 150 | Sixth component of the user composite key to uniquely identify the transaction | ||
| MRC_TAX_LINE_FLAG | VARCHAR2 | 1 | Y or N indicates if this tax line is for one of the multiple reporting currencies (MRC) | ||
| LEDGER_ID | NUMBER | 18 | Ledger defining column | ||
| ESTABLISHMENT_ID | NUMBER | Establishment identifier | |||
| LEGAL_ENTITY_ID | NUMBER | Legal entity identifier | |||
| LEGAL_ENTITY_TAX_REG_NUMBER | NUMBER | Legal entity tax registration number | |||
| HQ_ESTB_REG_NUMBER | VARCHAR2 | 30 | First party HQ establishment tax registration number | ||
| HQ_ESTB_PARTY_TAX_PROF_ID | NUMBER | Party tax profile identifier for the first party HQ establishment | |||
| CURRENCY_CONVERSION_DATE | DATE | Date of the exchange rate for transaction currency to functional currency conversion | |||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Exchange rate type for transaction currency to functional currency conversion | ||
| CURRENCY_CONVERSION_RATE | NUMBER | Exchange rate for transaction currency to functional currency conversion | |||
| TAX_CURRENCY_CONVERSION_DATE | DATE | Date of the exchange rate for transaction currency to tax currency conversion | |||
| TAX_CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Exchange rate type for transaction currency to tax currency conversion | ||
| TAX_CURRENCY_CONVERSION_RATE | NUMBER | Exchange rate for transaction currency to tax currency conversion | |||
| TRX_CURRENCY_CODE | VARCHAR2 | 15 | Transaction currency code | ||
| MINIMUM_ACCOUNTABLE_UNIT | NUMBER | Minimum accountable unit of the transaction currency | |||
| PRECISION | NUMBER | Precision of the transaction currency | |||
| TRX_NUMBER | VARCHAR2 | 150 | Transaction number | ||
| TRX_DATE | DATE | Transaction date | |||
| UNIT_PRICE | NUMBER | Unit Price of the transaction line item or product | |||
| LINE_AMT | NUMBER | Transaction line amount | |||
| TRX_LINE_QUANTITY | NUMBER | Transaction line quantity | |||
| TAX_BASE_MODIFIER_RATE | NUMBER | Modifier rate used for taxable basis determination | |||
| REF_DOC_APPLICATION_ID | NUMBER | Reference document application identifier | |||
| REF_DOC_ENTITY_CODE | VARCHAR2 | 30 | Reference document entity code | ||
| REF_DOC_EVENT_CLASS_CODE | VARCHAR2 | 30 | Reference document event class code | ||
| REF_DOC_TRX_ID | NUMBER | Reference document transaction identifier | |||
| REF_DOC_LINE_ID | NUMBER | Transaction line identifier for the reference document | |||
| REF_DOC_LINE_QUANTITY | NUMBER | Reference document line quantity | |||
| OTHER_DOC_LINE_AMT | NUMBER | Line amount on the other document | |||
| OTHER_DOC_LINE_TAX_AMT | NUMBER | Line tax amount on the other document | |||
| OTHER_DOC_LINE_TAXABLE_AMT | NUMBER | Taxable amount on the other document | |||
| UNROUNDED_TAXABLE_AMT | NUMBER | Unrounded taxable amount for this tax line | |||
| UNROUNDED_TAX_AMT | NUMBER | Unrounded tax amount for this tax line | |||
| RELATED_DOC_APPLICATION_ID | NUMBER | Related document application identifier | |||
| RELATED_DOC_ENTITY_CODE | VARCHAR2 | 30 | Related document entity code | ||
| RELATED_DOC_EVENT_CLASS_CODE | VARCHAR2 | 30 | Related document event class code | ||
| RELATED_DOC_TRX_ID | NUMBER | Primary itransaction dentifier for the related document | |||
| RELATED_DOC_NUMBER | VARCHAR2 | 150 | Transaction number for related document | ||
| RELATED_DOC_DATE | DATE | Related document date | |||
| APPLIED_FROM_APPLICATION_ID | NUMBER | Applied from document application identifier | |||
| APPLIED_FROM_EVENT_CLASS_CODE | VARCHAR2 | 30 | Applied from document event class code | ||
| APPLIED_FROM_ENTITY_CODE | VARCHAR2 | 30 | Applied from document entity code | ||
| APPLIED_FROM_TRX_ID | NUMBER | Applied from document transaction identifier | |||
| APPLIED_FROM_LINE_ID | NUMBER | Transaction line identifier for the applied from document | |||
| APPLIED_FROM_TRX_NUMBER | VARCHAR2 | 150 | Transaction number of the applied from document | ||
| ADJUSTED_DOC_APPLICATION_ID | NUMBER | Adjusted document application identifier | |||
| ADJUSTED_DOC_ENTITY_CODE | VARCHAR2 | 30 | Adjusted document entity code | ||
| ADJUSTED_DOC_EVENT_CLASS_CODE | VARCHAR2 | 30 | Adjusted document event class code | ||
| ADJUSTED_DOC_TRX_ID | NUMBER | Adjusted document transaction identifier | |||
| ADJUSTED_DOC_LINE_ID | NUMBER | Transaction line identifier for the adjusted document | |||
| ADJUSTED_DOC_NUMBER | VARCHAR2 | 150 | Transaction number of the adjusted document | ||
| ADJUSTED_DOC_DATE | DATE | Adjusted document date | |||
| APPLIED_TO_APPLICATION_ID | NUMBER | Applied to document application identifier | |||
| APPLIED_TO_EVENT_CLASS_CODE | VARCHAR2 | 30 | Applied to document event class code | ||
| APPLIED_TO_ENTITY_CODE | VARCHAR2 | 30 | Applied to document entity code | ||
| APPLIED_TO_TRX_ID | NUMBER | Applied to document transaction identifier | |||
| APPLIED_TO_LINE_ID | NUMBER | Transaction line identifier for the applied to document | |||
| SUMMARY_TAX_LINE_ID | NUMBER | 18 | Summary tax line identifier for this tax line | ||
| OFFSET_LINK_TO_TAX_LINE_ID | NUMBER | 18 | Identifier of the source tax line to which this tax line is associated if this tax line is created for an offset tax | ||
| OFFSET_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line is created for an offset tax | ||
| PROCESS_FOR_RECOVERY_FLAG | VARCHAR2 | 1 | Y or N indciates whether recoverable tax amount needs to be determined for this tax line | ||
| TAX_JURISDICTION_ID | NUMBER | 18 | Tax jurisdiction identifier | ||
| TAX_JURISDICTION_CODE | VARCHAR2 | 30 | Tax jurisdiction code | ||
| PLACE_OF_SUPPLY | NUMBER | Lookup code for place of supply of this tax line | |||
| PLACE_OF_SUPPLY_TYPE_CODE | VARCHAR2 | 30 | Lookup code for place of supply type | ||
| PLACE_OF_SUPPLY_RESULT_ID | NUMBER | 18 | Column to record identifier of the process result obtained from place of supply determination process for this tax line | ||
| TAX_DATE_RULE_ID | NUMBER | 18 | Column to record identifier of tax rule used to determine tax date | ||
| TAX_DATE | DATE | One of the dates on the current transaction based on which applicable tax rates and rules are determined | |||
| TAX_DETERMINE_DATE | DATE | Actual date used for determining applicable tax rates and rules. If adjusted document is persent, this is the tax date of the adjusted document; else it is same as the tax date of this tax line. | |||
| TAX_POINT_DATE | DATE | Date on which the taxpayer becomes liable for paying the tax to the tax authority. It can be the delivery date, the invoice date or the pickup date | |||
| TRX_LINE_DATE | DATE | Transaction line date | |||
| TAX_TYPE_CODE | VARCHAR2 | 30 | Lookup code for tax type | ||
| TAX_CODE | VARCHAR2 | 30 | Tax classification code | ||
| TAX_REGISTRATION_ID | NUMBER | 18 | Tax registration identifier | ||
| TAX_REGISTRATION_NUMBER | VARCHAR2 | 50 | Tax registration number | ||
| REGISTRATION_PARTY_TYPE | VARCHAR2 | 30 | Lookup code for party type that is used to determine the tax registration number | ||
| ROUNDING_LEVEL_CODE | VARCHAR2 | 30 | Rounding level code | ||
| ROUNDING_RULE_CODE | VARCHAR2 | 30 | Rounding rule code for the tax | ||
| ROUNDING_LVL_PARTY_TAX_PROF_ID | NUMBER | 18 | Party tax profile identifier of the party used for determining rounding level code | ||
| ROUNDING_LVL_PARTY_TYPE | VARCHAR2 | 30 | Lookup code for type of the party used for determining rounding level code | ||
| COMPOUNDING_TAX_FLAG | VARCHAR2 | 1 | Y or N indicates whether there exists any other tax line that is compunded on top of this tax line | ||
| ORIG_TAX_STATUS_ID | NUMBER | 18 | Column to store value of tax status identifier present prior to user override | ||
| ORIG_TAX_STATUS_CODE | VARCHAR2 | 30 | Column to store value of tax status code present prior to user override | ||
| ORIG_TAX_RATE_ID | NUMBER | 18 | Column to store value of tax rate identifier present prior to user override | ||
| ORIG_TAX_RATE_CODE | VARCHAR2 | 150 | Column to store value of tax rate code present prior to user override | ||
| ORIG_TAX_RATE | NUMBER | Column to store value of tax rate present prior to user override | |||
| ORIG_TAX_JURISDICTION_ID | NUMBER | 18 | Column to store value of tax jurisdiction identifier present prior to user override | ||
| ORIG_TAX_JURISDICTION_CODE | VARCHAR2 | 30 | Column to store value of tax jurisdiction code present prior to user override | ||
| ORIG_TAX_AMT_INCLUDED_FLAG | VARCHAR2 | 1 | Tax amount inlcuded flag before override | ||
| ORIG_SELF_ASSESSED_FLAG | VARCHAR2 | 1 | Column to store value of self-assessed flag prior to user override | ||
| TAX_CURRENCY_CODE | VARCHAR2 | 15 | Tax currency code | ||
| TAX_AMT | NUMBER | Tax amount in transaction currency | |||
| TAX_AMT_TAX_CURR | NUMBER | Tax amount in tax currency | |||
| TAX_AMT_FUNCL_CURR | NUMBER | Tax amount in functional currency | |||
| TAXABLE_AMT | NUMBER | Taxable amount in transaction currency | |||
| TAXABLE_AMT_TAX_CURR | NUMBER | Taxable amount in tax currency | |||
| TAXABLE_AMT_FUNCL_CURR | NUMBER | Taxable amount in functional currency | |||
| ORIG_TAXABLE_AMT | NUMBER | Column to store value of taxable amount prior to user override | |||
| ORIG_TAXABLE_AMT_TAX_CURR | NUMBER | Column to store value of taxable amount in tax currency prior to user override | |||
| CAL_TAX_AMT | NUMBER | System calculated tax amount in transaction currency. This is same as the tax amount in transaction currency if there is no user override. | |||
| CAL_TAX_AMT_TAX_CURR | NUMBER | System calculated tax amount in tax currency. This is same as the tax amount in tax currency if there is no user override. | |||
| CAL_TAX_AMT_FUNCL_CURR | NUMBER | System calculated tax amount in functional currency. This is same as the tax amount in functional currency if there is no user override. | |||
| ORIG_TAX_AMT | NUMBER | Column to store value of tax amount in transaction currency prior to user override | |||
| ORIG_TAX_AMT_TAX_CURR | NUMBER | Column to store value of tax amount in tax currency prior to user override | |||
| REC_TAX_AMT | NUMBER | Total recoverable tax amount in transaction currency | |||
| REC_TAX_AMT_TAX_CURR | NUMBER | Total recoverable tax amount in tax currency | |||
| REC_TAX_AMT_FUNCL_CURR | NUMBER | Total recoverable tax amount in functional currency | |||
| NREC_TAX_AMT | NUMBER | Total non-recoverable tax amount in transaction currency | |||
| NREC_TAX_AMT_TAX_CURR | NUMBER | Total non-recoverable tax amount in tax currency | |||
| NREC_TAX_AMT_FUNCL_CURR | NUMBER | Total non-recoverable tax amount in functional currency | |||
| TAX_EXEMPTION_ID | NUMBER | 18 | Identifier of the tax exemption used in determination of the effective tax rate | ||
| TAX_RATE_BEFORE_EXEMPTION | NUMBER | Tax rate that is determined before applying the tax exemption | |||
| TAX_RATE_NAME_BEFORE_EXEMPTION | VARCHAR2 | 150 | Tax rate name that is determined before applying the tax exemption | ||
| EXEMPT_RATE_MODIFIER | NUMBER | Percentage of the original tax rate that is exempt | |||
| EXEMPT_CERTIFICATE_NUMBER | VARCHAR2 | 80 | Tax exemption certificate number | ||
| EXEMPT_REASON | VARCHAR2 | 240 | Tax exemption reason | ||
| EXEMPT_REASON_CODE | VARCHAR2 | 30 | Exempt reason code | ||
| TAX_EXCEPTION_ID | NUMBER | 18 | Identifier of the tax exception used in determination of the effective tax rate | ||
| TAX_RATE_BEFORE_EXCEPTION | NUMBER | Tax rate that is determined before applying the tax exception | |||
| TAX_RATE_NAME_BEFORE_EXCEPTION | VARCHAR2 | 150 | Tax rate name that is determined before applying the tax exception | ||
| EXCEPTION_RATE | NUMBER | Percentage of the original tax rate that is treated as an exception | |||
| TAX_APPORTIONMENT_FLAG | VARCHAR2 | 1 | Y or N indicates whether there are multiple tax lines created for the tax of this line during migration from prior releases | ||
| HISTORICAL_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line is created during migration from prior releases | ||
| TAXABLE_BASIS_FORMULA | VARCHAR2 | 30 | Formula code used for determining taxable basis amount | ||
| TAX_CALCULATION_FORMULA | VARCHAR2 | 30 | Formula code used for determining tax amount | ||
| CANCEL_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line is cancelled by the user | ||
| PURGE_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line is marked for purge | ||
| DELETE_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line is marked for delete by the user | ||
| TAX_AMT_INCLUDED_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line is inclusive | ||
| SELF_ASSESSED_FLAG | VARCHAR2 | 1 | Y or N indicates whether this is a self-assessed tax line | ||
| OVERRIDDEN_FLAG | VARCHAR2 | 1 | Y or N indicates whether user has overridden this tax line | ||
| MANUALLY_ENTERED_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line is manually entered by the user | ||
| REPORTING_ONLY_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line is created for reporting only | ||
| FREEZE_UNTIL_OVERRIDDEN_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line is enforced from the reference document eventhough it is not found applicable for the current document | ||
| COPIED_FROM_OTHER_DOC_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line is copied from another document like a reference document | ||
| RECALC_REQUIRED_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line needs to be recalculated when user overrides an inclusive tax line or a tax line on top of which this tax line is compounded | ||
| SETTLEMENT_FLAG | VARCHAR2 | 1 | Not currently used | ||
| ITEM_DIST_CHANGED_FLAG | VARCHAR2 | 1 | Y or N indicates whether item distributions corresponding to the transaction line of this tax line are changed | ||
| ASSOCIATED_CHILD_FROZEN_FLAG | VARCHAR2 | 1 | Y or N indicates whether tax distributions associated with this tax line are frozen | ||
| TAX_ONLY_LINE_FLAG | VARCHAR2 | 1 | Y or N indicates whether this is a tax only line | ||
| COMPOUNDING_DEP_TAX_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line is compunded on top of another tax line | ||
| LAST_MANUAL_ENTRY | VARCHAR2 | 30 | Column to indicate which column is last overridden by the user. Possible values are TAX_STATUS, TAX_RATE, TAX_RATE_CODE and TAX_AMOUNT. | ||
| TAX_PROVIDER_ID | NUMBER | Party tax profile identifier of the third party service provider that has determined the tax on this line. | |||
| RECORD_TYPE_CODE | VARCHAR2 | 30 | Lookup code to indicate whether the record is migrated, seeded or defined by the user | ||
| REPORTING_PERIOD_ID | NUMBER | Identifier of the period when this tax line is reported | |||
| LEGAL_MESSAGE_APPL_2 | NUMBER | Legal message for tax applicability | |||
| LEGAL_MESSAGE_STATUS | NUMBER | Legal message for status determination | |||
| LEGAL_MESSAGE_RATE | NUMBER | Legal message for rate determination | |||
| LEGAL_MESSAGE_BASIS | NUMBER | Legal message for taxable basis | |||
| LEGAL_MESSAGE_CALC | NUMBER | Legal message for tax calculation | |||
| LEGAL_MESSAGE_THRESHOLD | NUMBER | Legal message for thresholds | |||
| LEGAL_MESSAGE_POS | NUMBER | Legal message for place of supply | |||
| LEGAL_MESSAGE_TRN | NUMBER | Legal message for tax registration number | |||
| LEGAL_MESSAGE_EXMPT | NUMBER | Legal message for exemptions | |||
| LEGAL_MESSAGE_EXCPT | NUMBER | Legal message for exceptions | |||
| TAX_REGIME_TEMPLATE_ID | NUMBER | 18 | Identifier of determining factor template used for regime determination | ||
| TAX_APPLICABILITY_RESULT_ID | NUMBER | 18 | Column to record identifier of the process result obtained from tax applicability process for this tax line | ||
| DIRECT_RATE_RESULT_ID | NUMBER | 18 | Column to record identifier of the process result obtained from line determination process for this tax line | ||
| STATUS_RESULT_ID | NUMBER | 18 | Column to record identifier of the process result obtained from status determination process for this tax line | ||
| RATE_RESULT_ID | NUMBER | 18 | Column to record identifier of the process result obtained from rate determination process for this tax line | ||
| BASIS_RESULT_ID | NUMBER | 18 | Column to record identifier of the process result obtained from taxable basis determination process for this tax line | ||
| THRESH_RESULT_ID | NUMBER | 18 | Column to record identifier of the process result obtained from threshold evaluation process for this tax line | ||
| CALC_RESULT_ID | NUMBER | 18 | Column to record identifier of the process result obtained from tax calculation process for this tax line | ||
| TAX_REG_NUM_DET_RESULT_ID | NUMBER | 18 | Column to record identifier of the process result obtained from tax registration number determination process for this tax line | ||
| EVAL_EXMPT_RESULT_ID | NUMBER | 18 | Column to record identifier of the process result obtained from exemption evaluation process for this tax line | ||
| EVAL_EXCPT_RESULT_ID | NUMBER | 18 | Column to record identifier of the process result obtained from exception evaluation process for this tax line | ||
| ENFORCE_FROM_NATURAL_ACCT_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line is enforced from natural account | ||
| TAX_HOLD_CODE | NUMBER | Name of tax hold code for Payables. Possible values are TAX VARIANCE, TAX AMOUNT RANGE and TAX VARIANCE+TAX AMOUNT RANGE. | |||
| TAX_HOLD_RELEASED_CODE | NUMBER | Name of tax hold release code for Payables. Possible values are TAX VARIANCE CORRECTED, TAX AMOUNT RANGE CORRECTED and TAX VARIANCE+TAX AMOUNT RANGE CORRECTED. | |||
| PRD_TOTAL_TAX_AMT | NUMBER | Prorated total tax amount | |||
| PRD_TOTAL_TAX_AMT_TAX_CURR | NUMBER | Prorated total tax amount in tax currency | |||
| PRD_TOTAL_TAX_AMT_FUNCL_CURR | NUMBER | Prorated total tax amount in functional currency | |||
| INTERNAL_ORG_LOCATION_ID | NUMBER | Internal organization location identifier of the transaction | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| 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. | ||
| NUMERIC1 | NUMBER | Not currently used | |||
| NUMERIC2 | NUMBER | Not currently used | |||
| NUMERIC3 | NUMBER | Not currently used | |||
| NUMERIC4 | NUMBER | Not currently used | |||
| NUMERIC5 | NUMBER | Not currently used | |||
| NUMERIC6 | NUMBER | Not currently used | |||
| NUMERIC7 | NUMBER | Not currently used | |||
| NUMERIC8 | NUMBER | Not currently used | |||
| NUMERIC9 | NUMBER | Not currently used | |||
| NUMERIC10 | NUMBER | Not currently used | |||
| CHAR1 | VARCHAR2 | 150 | Not currently used | ||
| CHAR2 | VARCHAR2 | 150 | Not currently used | ||
| CHAR3 | VARCHAR2 | 150 | Not currently used | ||
| CHAR4 | VARCHAR2 | 150 | Not currently used | ||
| CHAR5 | VARCHAR2 | 150 | Not currently used | ||
| CHAR6 | VARCHAR2 | 150 | Not currently used | ||
| CHAR7 | VARCHAR2 | 150 | Not currently used | ||
| CHAR8 | VARCHAR2 | 150 | Not currently used | ||
| CHAR9 | VARCHAR2 | 150 | Not currently used | ||
| CHAR10 | VARCHAR2 | 150 | Not currently used | ||
| DATE1 | DATE | Not currently used | |||
| DATE2 | DATE | Not currently used | |||
| DATE3 | DATE | Not currently used | |||
| DATE4 | DATE | Not currently used | |||
| DATE5 | DATE | Not currently used | |||
| DATE6 | DATE | Not currently used | |||
| DATE7 | DATE | Not currently used | |||
| DATE8 | DATE | Not currently used | |||
| DATE9 | DATE | Not currently used | |||
| DATE10 | DATE | Not currently used | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LEGAL_JUSTIFICATION_TEXT1 | VARCHAR2 | 2000 | Legal justification text 1 - for migration only | ||
| LEGAL_JUSTIFICATION_TEXT2 | VARCHAR2 | 2000 | Legal justification text 2 - for migration only | ||
| LEGAL_JUSTIFICATION_TEXT3 | VARCHAR2 | 2000 | Legal justification text 3 - for migration only | ||
| REPORTING_CURRENCY_CODE | VARCHAR2 | 30 | Reporting currency code | ||
| LINE_ASSESSABLE_VALUE | NUMBER | Assessable value is the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes | |||
| TRX_LINE_INDEX | VARCHAR2 | 30 | Not currently used | ||
| OFFSET_TAX_RATE_CODE | VARCHAR2 | 150 | Offset tax rate code | ||
| PRORATION_CODE | VARCHAR2 | 30 | Not currently used | ||
| OTHER_DOC_SOURCE | VARCHAR2 | 30 | Source of other document | ||
| CTRL_TOTAL_LINE_TX_AMT | NUMBER | Control amount for the total tax amount at the transaction line level | |||
| TAX_RATE_TYPE | VARCHAR2 | 30 | Lookup code that indicates type of the tax rate. Possible values include PERCENTAGE, QUANTITY and RECOVERY. | ||
| COMPOUNDING_TAX_MISS_FLAG | VARCHAR2 | 1 | Y or N indicates whether the tax line on top of which this tax line is compounded is missing | ||
| MRC_LINK_TO_TAX_LINE_ID | NUMBER | Identifier of the source tax line in transaction currency corresponding to which this tax line is created if this tax line is in one of the multiple reporting currencies | |||
| REF_DOC_TRX_LEVEL_TYPE | VARCHAR2 | 30 | Column to record the level at which the reference document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. | ||
| RELATED_DOC_TRX_LEVEL_TYPE | VARCHAR2 | 30 | Not currently used | ||
| APPLIED_FROM_TRX_LEVEL_TYPE | VARCHAR2 | 30 | Column to record the level at which the applied from document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. | ||
| ADJUSTED_DOC_TRX_LEVEL_TYPE | VARCHAR2 | 30 | Column to record the level at which the adjusted document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. | ||
| APPLIED_TO_TRX_LEVEL_TYPE | VARCHAR2 | 30 | Column to record the level at which the applied to document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. | ||
| SYNC_WITH_PRVDR_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line needs to be synchronized with the third party service provider | ||
| APPLIED_TO_TRX_NUMBER | VARCHAR2 | 150 | Applied to document transaction number | ||
| INTERFACE_ENTITY_CODE | VARCHAR2 | 30 | Column to temporarily store entity code of the tax line interface table | ||
| INTERFACE_TAX_LINE_ID | NUMBER | Column to temporarily store identifier of the interface line corresponding to this tax line during import of transactions into Receivables | |||
| TAXING_JURIS_GEOGRAPHY_ID | NUMBER | Geography Id for the tax jurisdiction of this tax line | |||
| ADJUSTED_DOC_TAX_LINE_ID | NUMBER | Adjusted document tax line identifier | |||
| 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. | |
| 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. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| REVERSED_TAX_LINE_ID | NUMBER | Identifier of the tax line that is reversed by this tax line | |||
| MULTIPLE_JURISDICTIONS_FLAG | VARCHAR2 | 1 | Y or N indicates whether the tax of this tax line has multiple jurisdictions | ||
| LEGAL_REPORTING_STATUS | VARCHAR2 | 15 | Status for legal reporting | ||
| ACCOUNT_SOURCE_TAX_RATE_ID | NUMBER | 18 | Tax Rate from which the GL account should be derived. If the tax derives its GL account from another tax, this column store the tax rate id of that tax, i.e., the source tax for accounts | ||
| TAX_POINT_BASIS | VARCHAR2 | 30 | The tax point basis for the tax line. | ||
| ORIG_TAX_POINT_DATE | DATE | Column to store value of tax point date present prior to user override. | |||
| REPORTABLE_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line is reportable. | ||
| CAL_TAXABLE_AMT | NUMBER | Taxable amount calculated for the tax line. | |||
| THRSHLD_SCHDL_GRP_LVL_FLAG | VARCHAR2 | 1 | Schedule grouping level code for the tax line. | ||
| TAX_THREHLDS_SCHDL_CNTRL_ID | NUMBER | 18 | Idendifier of the associated schedules and threshold details. | ||
| TAX_RATE_SCHED_ID | NUMBER | 18 | Identifier of the rate schedule associated with the tax line. | ||
| 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. | |||
| WHT_GROUP_ID | NUMBER | 18 | To identify the withholding tax group associated with the tax line. | ||
| TAX_BUCKET_ID | NUMBER | 18 | Identifier for tax bucket applied to this tax line. Foreign key to ZX_BUCKETS_F. | ||
| REPORTING_BATCH_ID | NUMBER | 18 | Selection process batch identifier. | ||
| LINE_GROUP_ID | NUMBER | 18 | Identifer to group multiple transaction lines together, such as grouping mutiple shipment lines as one fulfillment line. | ||
| MVA_RULE_RESULT_ID | NUMBER | 18 | Indicates the reference to the value adjustment type rule record in ZX_QUICK_RULE_RESULTS_F. | ||
| PER_UNIT_RULE_RESULT_ID | NUMBER | 18 | Indicates the reference to the per unit type rule record in ZX_QUICK_RULE_RESULTS_F. | ||
| DEFAULTING_RULE_RESULT_ID | NUMBER | 18 | Indicates the reference to the record in ZX_DEFAULTING_RULE_RESULTS_F. | ||
| WHT_CALCULATION_FLAG | VARCHAR2 | 1 | Indicates whether withholding tax is calculated. Valid values: Y and N. | ||
| PROVIDER_REC_RATE_CODE | VARCHAR2 | 50 | Tax provider returned recovery rate code for generating recoverable tax distributions. | ||
| PROVIDER_REC_RATE | NUMBER | Tax provider returned recovery rate for generating recoverable tax distributions. | |||
| TAX_HOLD_REASON | VARCHAR2 | 240 | Tax provider returned reason for hold being placed on invoice. | ||
| GROSS_NET_FLAG | VARCHAR2 | 1 | Apply tax on the gross or net amount on retainage indicator. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ZX_LINES | zx_exceptions | TAX_EXCEPTION_ID |
| ZX_LINES | zx_party_tax_profile | CONTENT_OWNER_ID |
| ZX_LINES | zx_regimes_b | TAX_REGIME_CODE |
| ZX_LINES | zx_taxes_b | TAX_ID |
| ZX_LINES | zx_status_b | TAX_STATUS_ID |
| ZX_LINES | zx_rates_b | TAX_RATE_ID |
| ZX_LINES | zx_party_tax_profile | HQ_ESTB_PARTY_TAX_PROF_ID |
| ZX_LINES | zx_process_results | CALC_RESULT_ID |
| ZX_LINES | zx_lines_summary | SUMMARY_TAX_LINE_ID |
| ZX_LINES | zx_lines | OFFSET_LINK_TO_TAX_LINE_ID |
| ZX_LINES | zx_process_results | PLACE_OF_SUPPLY_RESULT_ID |
| ZX_LINES | zx_process_results | TAX_DATE_RULE_ID |
| ZX_LINES | zx_registrations | TAX_REGISTRATION_ID |
| ZX_LINES | zx_party_tax_profile | ROUNDING_LVL_PARTY_TAX_PROF_ID |
| ZX_LINES | zx_status_b | ORIG_TAX_STATUS_ID |
| ZX_LINES | zx_lines | ADJUSTED_DOC_TAX_LINE_ID |
| ZX_LINES | zx_lines | REVERSED_TAX_LINE_ID |
| ZX_LINES | zx_process_results | TAX_REG_NUM_DET_RESULT_ID |
| ZX_LINES | zx_process_results | EVAL_EXMPT_RESULT_ID |
| ZX_LINES | zx_process_results | EVAL_EXCPT_RESULT_ID |
| ZX_LINES | zx_party_tax_profile | TAX_PROVIDER_ID |
| ZX_LINES | zx_rates_b | ORIG_TAX_RATE_ID |
| ZX_LINES | zx_process_results | TAX_APPLICABILITY_RESULT_ID |
| ZX_LINES | zx_process_results | DIRECT_RATE_RESULT_ID |
| ZX_LINES | zx_process_results | STATUS_RESULT_ID |
| ZX_LINES | zx_process_results | RATE_RESULT_ID |
| ZX_LINES | zx_process_results | BASIS_RESULT_ID |
| ZX_LINES | zx_process_results | THRESH_RESULT_ID |
| ZX_LINES | zx_evnt_typ_mappings | APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, EVENT_TYPE_CODE |
| ZX_LINES | zx_exemptions | TAX_EXEMPTION_ID |
| ZX_LINES | zx_event_classes_b | TAX_EVENT_CLASS_CODE |
| ZX_LINES | zx_evnt_cls_typs | TAX_EVENT_CLASS_CODE, TAX_EVENT_TYPE_CODE |
| zx_lines_det_factors | zx_lines | SOURCE_TAX_LINE_ID |
| zx_lines | zx_lines | OFFSET_LINK_TO_TAX_LINE_ID |
| zx_lines | zx_lines | ADJUSTED_DOC_TAX_LINE_ID |
| zx_lines | zx_lines | REVERSED_TAX_LINE_ID |
| ra_interface_lines_all | zx_lines | SOURCE_TRX_DETAIL_TAX_LINE_ID |
| ra_customer_trx_lines_all | zx_lines | TAX_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZX_LINES_N1 | Non Unique | Default | APPLICATION_ID, ADJUSTED_DOC_TAX_LINE_ID |
| ZX_LINES_N2 | Non Unique | Default | SUMMARY_TAX_LINE_ID |
| ZX_LINES_N3 | Non Unique | Default | APPLICATION_ID, LEDGER_ID, LEGAL_ENTITY_ID, TRX_DATE |
| ZX_LINES_N4 | Non Unique | Default | TRX_ID, APPLICATION_ID, TRX_CURRENCY_CODE |
| ZX_LINES_N5 | Non Unique | Default | TAX_REGIME_CODE, LEDGER_ID, APPLICATION_ID |
| ZX_LINES_N6 | Non Unique | Default | APPLIED_FROM_APPLICATION_ID, APPLIED_FROM_ENTITY_CODE, APPLIED_FROM_EVENT_CLASS_CODE, APPLIED_FROM_TRX_ID, APPLIED_FROM_LINE_ID, APPLIED_FROM_TRX_LEVEL_TYPE |
| ZX_LINES_N7 | Non Unique | Default | APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, LINE_GROUP_ID |
| ZX_LINES_U1 | Unique | Default | APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LEVEL_TYPE, TRX_LINE_ID, TAX_REGIME_CODE, TAX, TAX_APPORTIONMENT_LINE_NUMBER |
| ZX_LINES_U2 | Unique | Default | TAX_LINE_ID |