ZX_PTNR_TAX_LINES_INT
This interface table contains the imported tax lines calculated by tax partners for a transaction.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LINES_DET_FACTOR_ID | NUMBER | 18 | Yes | Unique identifier of the transaction line. | |
| INTERNAL_ORGANIZATION_ID | NUMBER | Internal organization identifier of the transaction. | |||
| APPLICATION_ID | NUMBER | Application identifier of the transaction. | |||
| ENTITY_CODE | VARCHAR2 | 30 | Entity code of the transaction. | ||
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Event class code of the transaction. | ||
| TRX_ID | NUMBER | Yes | Transaction identifier for this tax line calculated by third-party service provider. | ||
| TRX_LINE_ID | NUMBER | Transaction line identifier for this tax line calculated by third-party service provider. | |||
| 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. | ||
| TAX_REGIME_CODE | VARCHAR2 | 30 | Tax regime code for this tax line calculated by third-party service provider. | ||
| TAX | VARCHAR2 | 30 | Tax for this tax line calculated by third-party service provider. | ||
| TAX_STATUS_CODE | VARCHAR2 | 30 | Tax status code for this tax line calculated by third-party service provider. | ||
| TAX_RATE | NUMBER | Tax rate for this tax line calculated by third-party service provider. | |||
| TAX_RATE_CODE | VARCHAR2 | 50 | Tax rate code for this tax line calculated by third-party service provider. | ||
| 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. | |||
| PLACE_OF_SUPPLY_TYPE_CODE | VARCHAR2 | 30 | Lookup code for place of supply type. | ||
| TAX_JURISDICTION_CODE | VARCHAR2 | 30 | Tax jurisdiction code for this tax line calculated by third-party service provider. | ||
| TAX_JURISDICTION_NAME | VARCHAR2 | 240 | Tax jurisdiction name for this tax line calculated by third-party service provider. | ||
| TAX_CURRENCY_CODE | VARCHAR2 | 15 | Tax currency code for this tax line calculated by third-party service provider. | ||
| TAX_AMT | NUMBER | Tax amount in transaction currency. | |||
| TAX_AMT_TAX_CURR | NUMBER | Tax amount in tax currency for this tax line calculated by third-party service provider. | |||
| UNROUNDED_TAX_AMT | NUMBER | Unrounded tax amount for this tax line. | |||
| TAXABLE_AMT | NUMBER | Taxable amount in transaction currency. | |||
| TAXABLE_AMT_TAX_CURR | NUMBER | Taxable amount in tax currency for this tax calculated by third-party service provider. | |||
| UNROUNDED_TAXABLE_AMT | NUMBER | Unrounded taxable amount for this tax line. | |||
| TAX_POINT_BASIS | VARCHAR2 | 30 | Tax point basis for this tax line calculated by third-party service provider. | ||
| EXEMPT_CERTIFICATE_NUMBER | VARCHAR2 | 80 | Tax exemption certificate number for this tax line calculated by third-party service provider. | ||
| EXEMPT_RATE_MODIFIER | NUMBER | Percentage of the original tax rate that is exempt. | |||
| EXEMPT_REASON | VARCHAR2 | 240 | Tax exemption reason for this tax line calculated by third-party service provider. | ||
| EXEMPT_REASON_CODE | VARCHAR2 | 30 | Exempt reason code for this tax calculated by third-party service provider. | ||
| END_POINT_URL | VARCHAR2 | 240 | The external end point URL. | ||
| TAX_ONLY_LINE_FLAG | VARCHAR2 | 1 | Indicates whether this is a tax only line. Valid values: Y and N. | ||
| TAX_AMT_INCLUDED_FLAG | VARCHAR2 | 1 | Indicates whether this tax line is inclusive. Valid values: Y and N. | ||
| SELF_ASSESSED_FLAG | VARCHAR2 | 1 | Indicates whether this is a self-assessed tax line. Valid values: Y and N. | ||
| REGISTRATION_PARTY_TYPE | VARCHAR2 | 30 | Lookup code for party type that is used to determine the tax registration number. | ||
| TAX_REGISTRATION_NUMBER | VARCHAR2 | 50 | Tax registration number for this tax line calculated by third-party service provider. | ||
| THRESHOLD_INDICATOR_FLAG | VARCHAR2 | 1 | Indicates if there are thresholds applied at the document level or not. Supports integration with third-party tax vendors. Valid values: Y and N. | ||
| TRX_DATE | DATE | Transaction date for this tax line calculated by third-party service provider. | |||
| OFFSET_FLAG | VARCHAR2 | 1 | Indicates whether this tax line is created for an offset tax. Valid values: Y and N. | ||
| OFFSET_TAX_RATE_CODE | VARCHAR2 | 50 | Not currently used. | ||
| TAX_LINE_GROUP_ID | NUMBER | 18 | Identifier of the source tax line with which this tax line is associated, if this tax line is created for an offset tax. | ||
| PROVIDER_REC_RATE_CODE | VARCHAR2 | 50 | Not currently used. | ||
| PROVIDER_REC_RATE | NUMBER | Not currently used. | |||
| LEGAL_JUSTIFICATION_TEXT1 | VARCHAR2 | 1000 | Legal justification text 1 for this tax calculated by third-party service provider. | ||
| LEGAL_JUSTIFICATION_TEXT2 | VARCHAR2 | 1000 | Legal justification text 2 for this tax calculated by third-party service provider. | ||
| LEGAL_JUSTIFICATION_TEXT3 | VARCHAR2 | 1000 | Legal justification text 3 for this tax calculated by third-party service provider. | ||
| 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. | ||
| 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. | |||
| LEGAL_MESSAGE_APPL_2 | NUMBER | Legal message for tax applicability for this tax line calculated by third-party service provider. | |||
| LEGAL_MESSAGE_BASIS | NUMBER | Legal message for taxable basis for this tax line calculated by third-party service provider. | |||
| LEGAL_MESSAGE_CALC | NUMBER | Legal message for tax calculation for this tax line calculated by third-party service provider. | |||
| LEGAL_MESSAGE_EXMPT | NUMBER | Legal message for exemptions for this tax line calculated by third-party service provider. | |||
| LEGAL_MESSAGE_EXCPT | NUMBER | Legal message for exceptions for this tax line calculated by third-party service provider. | |||
| LEGAL_MESSAGE_POS | NUMBER | Legal message for place of supply for this tax line calculated by third-party service provider. | |||
| LEGAL_MESSAGE_RATE | NUMBER | Legal message for rate determination for this tax line calculated by third-party service provider. | |||
| LEGAL_MESSAGE_STATUS | NUMBER | Legal message for status determination for this tax line calculated by third-party service provider. | |||
| LEGAL_MESSAGE_THRESHOLD | NUMBER | Legal message for thresholds for this tax line calculated by third-party service provider. | |||
| LEGAL_MESSAGE_TRN | NUMBER | Legal message for tax registration number for this tax line calculated by third-party service provider. | |||
| 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_REASON | VARCHAR2 | 240 | Tax hold reason code of the tax hold for this tax line calculated by third-party service provider. | ||
| 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. | |||
| 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. | ||
| 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. | |||
| 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. | |||
| MANUALLY_ENTERED_FLAG | VARCHAR2 | 1 | Indicates whether this tax line is manually entered by the user. Valid values: Y and N. | ||
| REPORTABLE_FLAG | VARCHAR2 | 1 | Indicates whether this tax line is reportable. Valid values: Y and N. | ||
| REPORTING_ONLY_FLAG | VARCHAR2 | 1 | Indicates whether this tax line is created for reporting only. Valid values: Y and N. | ||
| TAX_LINE_NUMBER | NUMBER | Line number generated for this tax line. | |||
| TAX_CURRENCY_CONVERSION_DATE | DATE | Date of the conversion rate for transaction currency to tax currency conversion. | |||
| TAX_CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Conversion rate type for transaction currency to tax currency conversion. | ||
| TAX_CURRENCY_CONVERSION_RATE | NUMBER | Conversion rate for transaction currency to tax currency conversion. | |||
| 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 the adjusted document is present, this is the tax date of the adjusted document. Else, it is same as the tax date of this tax line. | |||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | ||
| LOAD_STATUS | VARCHAR2 | 30 | Enterprise Service Scheduler: indicates the request status of the interface load job that created the row. | ||
| ERROR_MESSAGE_TYPE_FLAG | VARCHAR2 | 1 | Identifier of validation error type for this tax line calculated by third-party service provider. | ||
| ERROR_STRING | VARCHAR2 | 240 | Validation error message for this tax line calculated by third-party service provider. | ||
| ERROR_MESSAGE_CODE | VARCHAR2 | 30 | Validation error message code for this tax line calculated by third-party service provider. | ||
| MESSAGE_CAUSE | VARCHAR2 | 1000 | Validation error message cause for this tax line calculated by third-party service provider. | ||
| MESSAGE_USER_ACTION | VARCHAR2 | 1000 | Validation error message user action for this tax line calculated by third-party service provider. | ||
| ADDITIONAL_INFORMATION | VARCHAR2 | 240 | Any additional information for this tax line calculated by third-party service provider. | ||
| RESPONSE_FILE_REFERENCE | VARCHAR2 | 240 | Document identifier of the file uploaded in the Universal Content Management server by third-party service provider. | ||
| LAST_UPDATE_DATE | TIMESTAMP | 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. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZX_PTNR_TAX_LINES_INT_N1 | Non Unique | Default | LOAD_REQUEST_ID |
| ZX_PTNR_TAX_LINES_INT_U1 | Unique | Default | LINES_DET_FACTOR_ID, TAX_REGIME_CODE, TAX, TAX_APPORTIONMENT_LINE_NUMBER, LOAD_REQUEST_ID |