ZX_LINES_SUMMARY
This table stores the summary tax lines for transactions of multiple event classes.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
ZX_LINES_SUMMARY_PK |
SUMMARY_TAX_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SUMMARY_TAX_LINE_ID | NUMBER | 18 | Yes | Summary 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 | |
| TRX_ID | NUMBER | Yes | Transaction line identifier | ||
| TRX_NUMBER | VARCHAR2 | 150 | Transaction number | ||
| 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 | |||
| 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 | |||
| SUMMARY_TAX_LINE_NUMBER | NUMBER | Yes | Line number generated for this summary tax line | ||
| CONTENT_OWNER_ID | NUMBER | 18 | Party tax profile identifier for the first party organization of the transaction | ||
| TAX_REGIME_CODE | VARCHAR2 | 30 | Tax regime code | ||
| TAX | VARCHAR2 | 30 | Tax | ||
| 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 used to determine tax | |||
| TAX_AMT | NUMBER | Total tax amount in transaction currency. In case of user override, this column will be updated with the overridden value and the override flag will indicate that this amount has been overriden. | |||
| TAX_AMT_TAX_CURR | NUMBER | Total tax amount in tax currency | |||
| TAX_AMT_FUNCL_CURR | NUMBER | Total tax amount in functional currency | |||
| TAX_JURISDICTION_CODE | VARCHAR2 | 30 | Tax jurisdiction code | ||
| TOTAL_REC_TAX_AMT | NUMBER | Total recoverable tax amount in transaction currency | |||
| TOTAL_REC_TAX_AMT_FUNCL_CURR | NUMBER | Total recoverable tax amount in functional currency | |||
| TOTAL_NREC_TAX_AMT | NUMBER | Total non-recoverable tax amount in transaction currency | |||
| TOTAL_NREC_TAX_AMT_FUNCL_CURR | NUMBER | Total non-recoverable tax amount in functional currency | |||
| LEDGER_ID | NUMBER | 18 | Ledger defining column | ||
| LEGAL_ENTITY_ID | NUMBER | Legal entity identifier | |||
| ESTABLISHMENT_ID | NUMBER | Establishment identifier | |||
| 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 | |||
| SUMMARIZATION_TEMPLATE_ID | NUMBER | 18 | Identifier of determining factor template used for summarization | ||
| 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 | ||
| HISTORICAL_FLAG | VARCHAR2 | 1 | Y or N indicates whether this summary tax line is migrated from prior releases | ||
| CANCEL_FLAG | VARCHAR2 | 1 | Y or N indicates whether this summary tax line is cancelled by the user | ||
| DELETE_FLAG | VARCHAR2 | 1 | Y or N indicates whether this summary tax line is marked for delete by the user | ||
| TAX_AMT_INCLUDED_FLAG | VARCHAR2 | 1 | Y or N indicates whether this summary tax line is inclusive | ||
| 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 | ||
| 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 | ||
| REPORTING_ONLY_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax line is created for reporting only | ||
| ASSOCIATED_CHILD_FROZEN_FLAG | VARCHAR2 | 1 | Y or N indicates whether one or more of the detail tax lines associated with this summary tax line are frozen | ||
| COPIED_FROM_OTHER_DOC_FLAG | VARCHAR2 | 1 | Y or N indicates whether this summary tax line is copied from another document like a reference document | ||
| MANUALLY_ENTERED_FLAG | VARCHAR2 | 1 | Y or N indicates if this summary tax line is manually entered by the user | ||
| 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. | ||
| RECORD_TYPE_CODE | VARCHAR2 | 30 | Lookup code to indicate whether the record is migrated, seeded or defined by the user | ||
| TAX_PROVIDER_ID | NUMBER | Party tax profile identifier of the third party service provider that has determined the tax on this line. | |||
| TAX_ONLY_LINE_FLAG | VARCHAR2 | 1 | Yor N indicates if this is a tax only line | ||
| 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. | ||
| 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. | ||
| APPLIED_FROM_LINE_ID | NUMBER | Applied from document transaction line identifier | |||
| APP_FROM_LIN_TRX_USER_KEY1 | VARCHAR2 | 150 | First component of the line level user composite key for uniquely identifying the applied from document line | ||
| APP_FROM_LIN_TRX_USER_KEY2 | VARCHAR2 | 150 | Second component of the line level user composite key for uniquely identifying the applied from document line | ||
| APP_FROM_LIN_TRX_USER_KEY3 | VARCHAR2 | 150 | Third component of the line level user composite key for uniquely identifying the applied from document line | ||
| APP_FROM_LIN_TRX_USER_KEY4 | VARCHAR2 | 150 | Fourth component of the line level user composite key for uniquely identifying the applied from document line | ||
| APP_FROM_LIN_TRX_USER_KEY5 | VARCHAR2 | 150 | Fifth component of the line level user composite key for uniquely identifying the applied from document line | ||
| APP_FROM_LIN_TRX_USER_KEY6 | VARCHAR2 | 150 | Sixth component of the line level user composite key for uniquely identifying the applied from document line | ||
| ADJ_DOC_HDR_TRX_USER_KEY1 | VARCHAR2 | 150 | First component of the header level user composite key for uniquely identifying the adjusted document | ||
| ADJ_DOC_HDR_TRX_USER_KEY2 | VARCHAR2 | 150 | Second component of the header level user composite key for uniquely identifying the adjusted document | ||
| ADJ_DOC_HDR_TRX_USER_KEY3 | VARCHAR2 | 150 | Third component of the header level user composite key for uniquely identifying the adjusted document | ||
| ADJ_DOC_HDR_TRX_USER_KEY4 | VARCHAR2 | 150 | Fourth component of the header level user composite key for uniquely identifying the adjusted document | ||
| ADJ_DOC_HDR_TRX_USER_KEY5 | VARCHAR2 | 150 | Fifth component of the header level user composite key for uniquely identifying the adjusted document | ||
| ADJ_DOC_HDR_TRX_USER_KEY6 | VARCHAR2 | 150 | Sixth component of the header level user composite key for uniquely identifying the adjusted document | ||
| 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 | |||
| APP_TO_HDR_TRX_USER_KEY1 | VARCHAR2 | 150 | First component of the header level user composite key for uniquely identifying the applied to document | ||
| APP_TO_HDR_TRX_USER_KEY2 | VARCHAR2 | 150 | Second component of the header level user composite key for uniquely identifying the applied to document | ||
| APP_TO_HDR_TRX_USER_KEY3 | VARCHAR2 | 150 | Third component of the header level user composite key for uniquely identifying the applied to document | ||
| APP_TO_HDR_TRX_USER_KEY4 | VARCHAR2 | 150 | Fourth component of the header level user composite key for uniquely identifying the applied to document | ||
| APP_TO_HDR_TRX_USER_KEY5 | VARCHAR2 | 150 | Fifth component of the header level user composite key for uniquely identifying the applied to document | ||
| APP_TO_HDR_TRX_USER_KEY6 | VARCHAR2 | 150 | Sixth component of the header level user composite key for uniquely identifying the applied to document | ||
| APPLIED_TO_LINE_ID | NUMBER | Applied to document transaction line identifier | |||
| APP_TO_LIN_TRX_USER_KEY1 | VARCHAR2 | 150 | First component of the line level user composite key for uniquely identifying the applied to document line | ||
| APP_TO_LIN_TRX_USER_KEY2 | VARCHAR2 | 150 | Second component of the line level user composite key for uniquely identifying the applied to document line | ||
| APP_TO_LIN_TRX_USER_KEY3 | VARCHAR2 | 150 | Third component of the line level user composite key for uniquely identifying the applied to document line | ||
| APP_TO_LIN_TRX_USER_KEY4 | VARCHAR2 | 150 | Fourth component of the line level user composite key for uniquely identifying the applied to document line | ||
| APP_TO_LIN_TRX_USER_KEY5 | VARCHAR2 | 150 | Fifth component of the line level user composite key for uniquely identifying the applied to document line | ||
| APP_TO_LIN_TRX_USER_KEY6 | VARCHAR2 | 150 | Sixth component of the line level user composite key for uniquely identifying the applied to document line | ||
| TAX_EXEMPTION_ID | NUMBER | Tax exemption identifier | |||
| TAX_RATE_BEFORE_EXEMPTION | NUMBER | Tax rate before the exemption is applied | |||
| TAX_RATE_NAME_BEFORE_EXEMPTION | VARCHAR2 | 80 | Tax rate name before the exemption is applied | ||
| 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 | Tax exemption reason code | ||
| TAX_RATE_BEFORE_EXCEPTION | NUMBER | Tax rate before the exception is applied | |||
| TAX_RATE_NAME_BEFORE_EXCEPTION | VARCHAR2 | 80 | Tax rate name before the exception is applied | ||
| TAX_EXCEPTION_ID | NUMBER | Tax exception identifier | |||
| EXCEPTION_RATE | NUMBER | Tax exception rate | |||
| TOTAL_REC_TAX_AMT_TAX_CURR | NUMBER | Total recoverable tax amount in tax currency | |||
| TOTAL_NREC_TAX_AMT_TAX_CURR | NUMBER | Total non-recoverable tax amount in tax currency | |||
| MRC_TAX_LINE_FLAG | VARCHAR2 | 1 | Y or N indicates if this summary tax line is for one of the multiple reporting currencies (MRC) | ||
| 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. | ||
| 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. | |||
| 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. | ||
| TRX_LEVEL_TYPE | VARCHAR2 | 30 | Column to record the level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. | ||
| ADJUST_TAX_AMT_FLAG | VARCHAR2 | 1 | Y or N to indicate whether tax amount needs to be adjusted on the corresponding detail tax lines to ensure that the sum of all detail lines equals the amount on the summary line, when the user overrides or enters this summary tax line | ||
| 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. | |
| ADD_TAX_TO_INV_AMT_FLAG | VARCHAR2 | 1 | Indicates whether the invoice amount should be grossed up by the calculated tax. Valid values: Y and N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ZX_LINES_SUMMARY | zx_party_tax_profile | CONTENT_OWNER_ID |
| ZX_LINES_SUMMARY | zx_regimes_b | TAX_REGIME_CODE |
| ZX_LINES_SUMMARY | zx_rates_b | TAX_RATE_ID |
| ZX_LINES_SUMMARY | zx_exemptions | TAX_EXEMPTION_ID |
| ZX_LINES_SUMMARY | zx_exceptions | TAX_EXCEPTION_ID |
| ZX_LINES_SUMMARY | zx_party_tax_profile | TAX_PROVIDER_ID |
| zx_rec_nrec_dist | zx_lines_summary | SUMMARY_TAX_LINE_ID |
| zx_lines | zx_lines_summary | SUMMARY_TAX_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZX_LINES_SUMMARY_U1 | Unique | ZX_LINES_SUMMARY_U1 | SUMMARY_TAX_LINE_ID |
| ZX_LINES_SUMMARY_U2 | Unique | ZX_LINES_SUMMARY_U2 | APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, SUMMARY_TAX_LINE_NUMBER |