1. Tables and Views for Financials
  2. ZX_WITHHOLDING_LINES

ZX_WITHHOLDING_LINES

This table contains information about withholding tax detail lines for transactions of multiple event classes.

Details

  • Schema: FUSION

  • Object owner: ZX

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

ZX_WITHHOLDING_LINES_PK

TAX_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
TAX_LINE_ID NUMBER 18 Yes Withholding tax line identifier. Active
APPLICATION_ID NUMBER 18 Yes Application identifier of the transaction. Active
ENTITY_CODE VARCHAR2 30 Yes Entity code of the transaction, which indicates the type of transaction being created. Active
TRX_ID NUMBER 18 Yes System-generated identification number of a transaction. Active
TRX_LINE_ID NUMBER 18 Yes Identifier for a particular transaction line in a table. Active
TRX_LEVEL_TYPE VARCHAR2 30 Yes Level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT, FREIGHT and TAX. Active
EVENT_CLASS_CODE VARCHAR2 30 Yes Application event class of the transaction. Active
EVENT_TYPE_CODE VARCHAR2 30 Yes Application event type code of the transaction. Active
INTERNAL_ORGANIZATION_ID NUMBER 18 Yes Internal organization identifier of the transaction. Active
ADJUSTED_DOC_TAX_LINE_ID NUMBER 18 Adjusted document tax line identifier Active
APPLIED_FROM_APPLICATION_ID NUMBER 18 Application identifier for the document that is applied to a transaction. Active
APPLIED_FROM_ENTITY_CODE VARCHAR2 30 Entity code of the document that is applied to a transaction. Active
APPLIED_FROM_EVENT_CLASS_CODE VARCHAR2 30 Event class code for the document that is applied to a transaction. Active
APPLIED_FROM_LINE_ID NUMBER 18 Transaction line identifier for the document that is applied to a transaction. Active
APPLIED_FROM_TRX_ID NUMBER 18 Transaction identifier for the document that is applied to a transaction. Active
APPLIED_FROM_TRX_LEVEL_TYPE VARCHAR2 30 Level at which to store the document line identifier for a document that is applied to a transaction. Possible values are LINE, SHIPMENT and FREIGHT. Active
APPLIED_FROM_TRX_NUMBER VARCHAR2 150 Transaction number for the document that is applied to a transaction. Active
ASSOCIATED_CHILD_FROZEN_FLAG VARCHAR2 1 Yes or No indicates whether tax distributions associated with this tax line are frozen. Active
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE1 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
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
BASIS_RESULT_ID NUMBER 18 Identifier for the process result obtained from taxable basis determination process for a particular tax line. Active
CAL_TAX_AMT NUMBER System calculated tax amount in entered currency. This is same as the tax amount in entered currency if there is no user override. Active
CAL_TAX_AMT_FUNCL_CURR NUMBER System calculated tax amount in ledger currency. This is same as the tax amount in ledger currency if there is no user override. Active
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. Active
CAL_TAXABLE_AMT NUMBER Calculated taxable amount for a particular withholding tax line. Active
CALC_RESULT_ID NUMBER 18 Identifier for the process result obtained from tax calculation process for a particular tax line. Active
CANCEL_FLAG VARCHAR2 1 Yes or No indicates whether this tax line is cancelled by the user. Active
CASH_DISCOUNT_APPLICABLE_FLAG VARCHAR2 1 Yes or No indicates whether a cash discount is applicable. Active
CHAR1 VARCHAR2 150 Alphanumeric value for supporting extensibility by customers. Active
CHAR10 VARCHAR2 150 Alphanumeric value for supporting extensibility by customers. Active
CHAR2 VARCHAR2 150 Alphanumeric value for supporting extensibility by customers. Active
CHAR3 VARCHAR2 150 Alphanumeric value for supporting extensibility by customers. Active
CHAR4 VARCHAR2 150 Alphanumeric value for supporting extensibility by customers. Active
CHAR5 VARCHAR2 150 Alphanumeric value for supporting extensibility by customers. Active
CHAR6 VARCHAR2 150 Alphanumeric value for supporting extensibility by customers. Active
CHAR7 VARCHAR2 150 Alphanumeric value for supporting extensibility by customers. Active
CHAR8 VARCHAR2 150 Alphanumeric value for supporting extensibility by customers. Active
CHAR9 VARCHAR2 150 Alphanumeric value for supporting extensibility by customers. Active
CHECKRUN_ID NUMBER 18 Payment process request identifier Active
COMPOUNDING_DEP_TAX_FLAG VARCHAR2 1 Yes or No indicates whether this tax line is compounded on top of another tax line. Active
COMPOUNDING_TAX_FLAG VARCHAR2 1 Yes or No indicates whether this is a compounding tax line. Active
COMPOUNDING_TAX_MISS_FLAG VARCHAR2 1 Yes or No indicates whether the tax line on top of which this tax line is compounded is missing. Active
CONTENT_OWNER_ID NUMBER 18 Party tax profile identifier for the first party organization of the transaction. Active
COPIED_FROM_OTHER_DOC_FLAG VARCHAR2 1 Yes or No indicates whether this tax line is copied from another document like a reference document. Active
CURRENCY_CONVERSION_DATE DATE Date of the conversion rate for entered currency to ledger currency conversion. Active
CURRENCY_CONVERSION_RATE NUMBER Conversion rate for entered currency to ledger currency conversion. Active
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Conversion rate type for entered currency to ledger currency conversion. Active
DATE1 DATE Date value for supporting extensibility by customers. Active
DATE10 DATE Date value for supporting extensibility by customers. Active
DATE2 DATE Date value for supporting extensibility by customers. Active
DATE3 DATE Date value for supporting extensibility by customers. Active
DATE4 DATE Date value for supporting extensibility by customers. Active
DATE5 DATE Date value for supporting extensibility by customers. Active
DATE6 DATE Date value for supporting extensibility by customers. Active
DATE7 DATE Date value for supporting extensibility by customers. Active
DATE8 DATE Date value for supporting extensibility by customers. Active
DATE9 DATE Date value for supporting extensibility by customers. Active
DELETE_FLAG VARCHAR2 1 Yes or No indicates whether this tax line is marked for delete by the user. Active
DIRECT_RATE_RESULT_ID NUMBER 18 Identifier for the process result obtained from line determination process for a particular tax line. Active
DISCOUNT_AMT NUMBER Discount amount associated with a particular withholding tax line. Active
DOC_EVENT_STATUS VARCHAR2 30 Lookup code that indicates event status of the transaction. Active
ESTABLISHMENT_ID NUMBER 18 Establishment identifier, which is now known as the legal reporting unit. Active
EVAL_EXMPT_RESULT_ID NUMBER 18 Identifier for the process result obtained from exemption evaluation process for a particular tax line. Active
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 80 Certificate number for the exemption associated with the withholding transaction. Active
EXEMPT_RATE_MODIFIER NUMBER Percentage of the original tax rate that is exempt. Active
EXEMPT_REASON VARCHAR2 240 Identifier for the process result obtained from exemption evaluation process for this tax line. Active
EXEMPT_REASON_CODE VARCHAR2 30 Reason code for a tax exemption. Active
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 150 Global Descriptive Flexfield: structure definition of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
HISTORICAL_FLAG VARCHAR2 1 Yes or No indicates whether this tax line is created during migration from prior releases. Active
HQ_ESTB_REG_NUMBER VARCHAR2 30 First party HQ establishment tax registration number. Active
HQ_ESTB_PARTY_TAX_PROF_ID NUMBER 18 Party tax profile identifier for the first party HQ establishment. Active
INDIRECT_TAX_LINE_ID NUMBER 18 Indirect tax line identifier to which a withholding line is allocated. Active
INTERNAL_ORG_LOCATION_ID NUMBER 18 Internal organization location identifier of the transaction Active
LAST_MANUAL_ENTRY VARCHAR2 30 Indicates which column was last overridden by the user. Possible values are TAX_STATUS, TAX_RATE, TAX_RATE_CODE and TAX_AMOUNT. Active
LEDGER_ID NUMBER 18 Ledger identifier for the self-contained accounting information set for single or multiple legal or management entities. Active
LEGAL_ENTITY_ID NUMBER 18 Legal entity identifier for a particular withholding transaction. Active
LEGAL_ENTITY_TAX_REG_NUMBER NUMBER Legal entity tax registration number. Active
LEGAL_MSG_APPL_2_ID NUMBER 18 Legal message identifier for tax applicability. Active
LEGAL_MSG_BASIS_ID NUMBER 18 Legal message identifier for taxable basis. Active
LEGAL_MSG_CALC_ID NUMBER 18 Legal message identifier for tax calculation. Active
LEGAL_MSG_EXMPT_ID NUMBER 18 Legal message identifier for exemptions. Active
LEGAL_MSG_POS_ID NUMBER 18 Legal message identifier for place of supply. Active
LEGAL_MSG_RATE_ID NUMBER 18 Legal message identifier for rate determination. Active
LEGAL_MSG_STATUS_ID NUMBER 18 Legal message identifier for status determination. Active
LEGAL_MSG_THRESHOLD_ID NUMBER 18 Legal message identifier for thresholds. Active
LEGAL_MSG_TRN_ID NUMBER 18 Legal message identifier for tax registration number Active
LINE_AMT NUMBER Monetary amount associated to the transaction line. Active
LINE_ASSESSABLE_VALUE NUMBER Deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes. Active
MANUALLY_ENTERED_FLAG VARCHAR2 1 Yes or No indicates whether this tax line is manually entered by the user. Active
MINIMUM_ACCOUNTABLE_UNIT NUMBER Minimum accountable unit of the entered currency. Active
MULTIPLE_JURISDICTIONS_FLAG VARCHAR2 1 Yes or No indicates whether tax associated to this tax line has multiple jurisdictions. Active
NUMERIC1 NUMBER Numeric value for supporting extensibility by customers. Active
NUMERIC10 NUMBER Numeric value for supporting extensibility by customers. Active
NUMERIC2 NUMBER Numeric value for supporting extensibility by customers. Active
NUMERIC3 NUMBER Numeric value for supporting extensibility by customers. Active
NUMERIC4 NUMBER Numeric value for supporting extensibility by customers. Active
NUMERIC5 NUMBER Numeric value for supporting extensibility by customers. Active
NUMERIC6 NUMBER Numeric value for supporting extensibility by customers. Active
NUMERIC7 NUMBER Numeric value for supporting extensibility by customers. Active
NUMERIC8 NUMBER Numeric value for supporting extensibility by customers. Active
NUMERIC9 NUMBER Numeric value for supporting extensibility by customers. Active
ORIG_TAX_AMT NUMBER Tax amount in entered currency before user override. Active
ORIG_TAX_AMT_TAX_CURR NUMBER Tax amount in tax currency before user override. Active
ORIG_TAX_JURISDICTION_CODE VARCHAR2 30 Tax jurisdiction code before user override. Active
ORIG_TAX_JURISDICTION_ID NUMBER 18 Tax jurisdiction identifier before user override. Active
ORIG_TAX_RATE NUMBER Tax rate before user override. Active
ORIG_TAX_RATE_CODE VARCHAR2 150 Tax rate code before user override. Active
ORIG_TAX_RATE_ID NUMBER 18 Tax rate identifier before user override. Active
ORIG_TAX_STATUS_CODE VARCHAR2 30 Tax status code before user override. Active
ORIG_TAX_STATUS_ID NUMBER 18 Tax status identifier before user override. Active
ORIG_TAXABLE_AMT NUMBER Taxable amount before user override. Active
ORIG_TAXABLE_AMT_TAX_CURR NUMBER Taxable amount in tax currency before user override. Active
OTHER_DOC_LINE_AMT NUMBER Line amount on the other document Active
OTHER_DOC_LINE_TAX_AMT NUMBER Line tax amount on the other document Active
OTHER_DOC_LINE_TAXABLE_AMT NUMBER Taxable amount on the other document Active
OVERRIDDEN_FLAG VARCHAR2 1 Yes or No indicates whether user has overridden this tax line. Active
PAYMENT_AMT NUMBER Payment amount associated with a particular withholding tax line. Active
PAYMENT_DATE DATE Payment date associated with a particular withholding tax line. Active
PAYMENT_ID NUMBER 18 Payment identifier associated with a particular withholding tax line. Active
PLACE_OF_SUPPLY_RESULT_ID NUMBER 18 Identifier for the process result obtained from place of supply determination process for a particular tax line. Active
PLACE_OF_SUPPLY_TYPE_CODE VARCHAR2 30 Lookup code for place of supply type Active
PRD_TOTAL_TAX_AMT NUMBER Tax amount derived by the tax rate on prepayment based on applied amount handling method. Active
PRD_TOTAL_TAX_AMT_FUNCL_CURR NUMBER Prorated total tax amount in ledger currency. Active
PRD_TOTAL_TAX_AMT_TAX_CURR NUMBER Prorated total tax amount in tax currency Active
PRECISION NUMBER Precision of the entered currency. Active
PURGE_FLAG VARCHAR2 1 Yes or No indicates whether this tax line is marked for purge. Active
RATE_RESULT_ID NUMBER 18 Identifier for the process result obtained from rate determination process for a particular tax line. Active
RECALC_REQUIRED_FLAG VARCHAR2 1 Yes or No 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. Active
RECORD_TYPE_CODE VARCHAR2 30 Lookup code to indicate whether the record is migrated, seeded or defined by the user Active
REGISTRATION_PARTY_TYPE VARCHAR2 30 Lookup code for party type that is used to determine the tax registration number Active
REPORTING_PERIOD_ID NUMBER 18 Identifier of the period when this tax line is reported Active
REVERSED_TAX_LINE_ID NUMBER 18 Identifier of the tax line that is reversed by this tax line Active
ROUNDING_LEVEL_CODE VARCHAR2 30 Level that specifies the rounding to apply to tax amounts on a transaction. Possible values are "Line" and "Header". Active
ROUNDING_LVL_PARTY_TAX_PROF_ID NUMBER 18 Party tax profile identifier of the party used for determining rounding level code Active
ROUNDING_LVL_PARTY_TYPE VARCHAR2 30 Lookup code for the type of party used for determining rounding level code. Active
ROUNDING_RULE_CODE VARCHAR2 30 Withholding rounding rule code for the tax Active
STATUS_RESULT_ID NUMBER 18 Identifier for the process result obtained from status determination process for a particular tax line. Active
SUMMARY_TAX_LINE_ID NUMBER 18 Summary tax line identifier for a particular tax line. Active
TAX VARCHAR2 30 Tax code for the classification of a charge imposed by a government through a fiscal or tax authority. Active
TAX_AMT NUMBER Tax amount in entered currency. Active
TAX_AMT_FUNCL_CURR NUMBER Tax amount in ledger currency. Active
TAX_AMT_TAX_CURR NUMBER Amount in entered currency converted into tax currency. Active
TAX_APPLICABILITY_RESULT_ID NUMBER 18 Identifier for the process result obtained from tax applicability process for a particular tax line. Active
TAX_APPORTIONMENT_FLAG VARCHAR2 1 Yes or No indicates whether there are multiple tax lines created for the tax of this line during migration from prior releases. Active
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. Active
TAX_BASE_MODIFIER_RATE NUMBER Modifier rate used for taxable basis determination Active
TAX_CALCULATION_FORMULA VARCHAR2 30 Formula code used for determining tax amount Active
TAX_CODE VARCHAR2 30 Withholding tax classification code Active
TAX_CURRENCY_CODE VARCHAR2 15 Unique identification of a currency in which the tax transactions are to be reported. Active
TAX_CURRENCY_CONVERSION_DATE DATE Date of the conversion rate for entered currency to tax currency conversion. Active
TAX_CURRENCY_CONVERSION_RATE NUMBER Conversion rate for entered currency to tax currency conversion. Active
TAX_CURRENCY_CONVERSION_TYPE VARCHAR2 30 Conversion rate type for entered currency to tax currency conversion. Active
TAX_DATE DATE Date on the current transaction used to determine the applicable tax rates and rules. Active
TAX_DATE_RULE_ID NUMBER 18 Identifier for a tax rule used to determine the tax date. Active
TAX_DETERMINE_DATE DATE Actual date used for determining applicable tax rates and rules. If 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. Active
TAX_EVENT_CLASS_CODE VARCHAR2 30 Tax event class code of the transaction. Active
TAX_EVENT_TYPE_CODE VARCHAR2 30 Tax event type code of the transaction. Active
TAX_EXEMPTION_ID NUMBER 18 Identifier of the tax exemption used in determination of the effective tax rate. Active
TAX_ID NUMBER 18 Tax identifier for the classification of a charge imposed by a government through a fiscal or tax authority. Active
TAX_JURISDICTION_CODE VARCHAR2 30 Tax jurisdiction code for a geographic area where a tax is levied by a specific tax authority. Active
TAX_JURISDICTION_ID NUMBER 18 Tax jurisdiction identifier for a geographic area where a tax is levied by a specific tax authority. Active
TAX_LINE_NUMBER NUMBER Line number generated for this tax line. Active
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 Active
TAX_RATE NUMBER Rate specified for a tax status for an effective time period. A tax rate can be expressed as a percentage or a value per unit quantity. Active
TAX_RATE_BEFORE_EXEMPTION NUMBER Tax rate that is determined before applying the tax exemption. Active
TAX_RATE_CODE VARCHAR2 150 Tax rate code specified for a tax status for an effective time period, expressed as a percentage or a value per unit quantity. Active
TAX_RATE_ID NUMBER 18 Identifier for the rate specified for a tax status for an effective time period. Active
TAX_RATE_NAME_BEFORE_EXEMPTION VARCHAR2 150 Tax rate name that is determined before applying the tax exemption. Active
TAX_RATE_TYPE VARCHAR2 30 Lookup code that indicates type of the tax rate. Possible values include PERCENTAGE, QUANTITY and RECOVERY. Active
TAX_REG_NUM_DET_RESULT_ID NUMBER 18 Identifier for the process result obtained from tax registration number determination process for a particular tax line. Active
TAX_REGIME_CODE VARCHAR2 30 Tax regime code for the set of tax rules that determines the treatment of one or more taxes administered by a tax authority. Active
TAX_REGIME_ID NUMBER 18 Withholding tax regime identifier. Active
TAX_REGIME_TEMPLATE_ID NUMBER 18 Identifier of determining factor template used for regime determination Active
TAX_REGISTRATION_ID NUMBER 18 Tax registration identifier for a party determined in the transaction based on tax rules. Active
TAX_REGISTRATION_NUMBER VARCHAR2 50 Withholding tax registration number Active
TAX_STATUS_CODE VARCHAR2 30 Tax status code for the taxable nature of a product in the context of a transaction for a tax. Active
TAX_STATUS_ID NUMBER 18 Withholding tax status identifier. Active
TAX_TYPE_CODE VARCHAR2 30 Lookup code for withholding tax type Active
TAXABLE_AMT NUMBER Taxable amount in entered currency. Active
TAXABLE_AMT_FUNCL_CURR NUMBER Taxable amount in ledger currency. Active
TAXABLE_AMT_TAX_CURR NUMBER Taxable amount shown in the tax currency after the tax rules are taken into consideration for a specific tax. Active
TAXABLE_BASIS_FORMULA VARCHAR2 30 Formula code used for determining taxable basis amount Active
TAXING_JURIS_GEOGRAPHY_ID NUMBER 18 Geography identifier for the tax jurisdiction of a particular tax line. Active
THRESH_RESULT_ID NUMBER 18 Identifier for the process result obtained from threshold evaluation process for a particular tax line. Active
TRX_CURRENCY_CODE VARCHAR2 15 Three-letter ISO (International Organization for Standardization) code for the entered currency. Active
TRX_DATE DATE Date the transaction occurred. Active
TRX_ID_LEVEL2 NUMBER Transaction identifier at a level between trx_id and trx_line_id. Active
TRX_ID_LEVEL3 NUMBER Transaction identifier at a level between trx_id_level2 and trx_line_id. Active
TRX_ID_LEVEL4 NUMBER Transaction identifier at a level between trx_id_level3 and trx_line_id. Active
TRX_ID_LEVEL5 NUMBER Transaction identifier at a level between trx_id_level4 and trx_line_id. Active
TRX_ID_LEVEL6 NUMBER Transaction identifier at a level between trx_id_level5 and trx_line_id. Active
TRX_LINE_DATE DATE Date of the withholding transaction line. Active
TRX_LINE_NUMBER VARCHAR2 30 Number of a particular transaction line in a table. Active
TRX_LINE_QUANTITY NUMBER Quantity of the associated transaction line. Active
TRX_NUMBER VARCHAR2 150 Transaction number, typically the number that enables a user to identify a transaction. Active
TRX_USER_KEY_LEVEL1 VARCHAR2 120 First component of the user composite key to uniquely identify the transaction. Active
TRX_USER_KEY_LEVEL2 VARCHAR2 120 Second component of the user composite key to uniquely identify the transaction. Active
TRX_USER_KEY_LEVEL3 VARCHAR2 120 Third component of the user composite key to uniquely identify the transaction. Active
TRX_USER_KEY_LEVEL4 VARCHAR2 120 Fourth component of the user composite key to uniquely identify the transaction. Active
TRX_USER_KEY_LEVEL5 VARCHAR2 120 Fifth component of the user composite key to uniquely identify the transaction. Active
TRX_USER_KEY_LEVEL6 VARCHAR2 120 Sixth component of the user composite key to uniquely identify the transaction. Active
TXBL_THRSHLD_GRP_LVL_CODE VARCHAR2 30 Taxable threshold grouping level code. Possible values are NULL, L (line), P (period), D (document), U (unit) and S (set). Active
UNIT_PRICE NUMBER Unit price of the good or service on a transaction line. Active
UNROUNDED_TAX_AMT NUMBER Unrounded tax amount for a particular tax line. Active
UNROUNDED_TAXABLE_AMT NUMBER Unrounded taxable amount for a particular tax line. Active
WHT_GROUP_ID NUMBER 18 Withholding tax group identifier for a particular withholding tax line. Active
WHT_REGION VARCHAR2 10 Oracle internal use only. Active
WHT_REPORT_BOX VARCHAR2 10 Oracle internal use only. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes 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
OTHER_DOC_SOURCE VARCHAR2 30 Source of related document in the transaction. 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
ENFORCE_FROM_NATURAL_ACCT_FLAG VARCHAR2 1 Y or N indicates whether this tax line is enforced from natural account Active
TAX_THREHLDS_SCHDL_CNTRL_ID NUMBER 18 Threshold configuration identifier for a withholding tax line. Foreign key to ZX_THREHLDS_SCHDL_CNTRLS. Active
TAX_RATE_SCHED_ID NUMBER 18 To store the schedule identifier for the tax rate. Active
THRSHLD_SCHDL_GRP_LVL_FLAG VARCHAR2 1 To store a value to indicate the threshold schedule grouping level. Active
TAX_EXCEPTION_ID NUMBER 18 Identifier of the tax exception used in determination of the effective tax rate. Active
TAX_RATE_NAME_BEFORE_EXCEPTION VARCHAR2 150 Tax rate name that is determined before applying the tax exception. Active
TAX_RATE_BEFORE_EXCEPTION NUMBER Tax rate that is determined before applying the tax exception. Active
EXCEPTION_RATE NUMBER Percentage of the original tax rate that is treated as an exception. Active
TAX_BUCKET_ID NUMBER 18 Identifier for tax bucket applied to this tax line. Foreign key to ZX_BUCKETS_F.
PAYMENT_NUMBER NUMBER 18 Payment number associated with the withholding tax line.
ACCUM_TAX_AMT_TAX_CURR NUMBER Accumulated tax amount at the time when the current tax line is created or updated.
ACCUM_TXBL_AMT_TAX_CURR NUMBER Accumulated taxable amount at the time when the current tax line is created or updated.
ORIG_ACCUM_TAX_AMT_TAX_CURR NUMBER Original accumulated tax amount at the time when the current tax line is canceled.
ORIG_ACCUM_TXBL_AMT_TAX_CURR NUMBER Original accumulated taxable amount at the time when the current tax line is canceled.
GROSS_NET_FLAG VARCHAR2 1 Apply tax on the gross or net amount on retainage indicator.
REPORTING_ONLY_FLAG VARCHAR2 1 Y or N indicates whether this tax line is created for reporting only

Foreign Keys

Table Foreign Table Foreign Key Column
ap_invoice_distributions_all zx_withholding_lines DETAIL_TAX_LINE_ID

Indexes

Index Uniqueness Tablespace Columns Status
ZX_WITHHOLDING_LINES_N1 Non Unique FUSION_TS_TX_IDX SUMMARY_TAX_LINE_ID Active
ZX_WITHHOLDING_LINES_N2 Non Unique FUSION_TS_TX_IDX TAX_BUCKET_ID Active
ZX_WITHHOLDING_LINES_U1 Unique FUSION_TS_TX_IDX TAX_LINE_ID Active
ZX_WITHHOLDING_LINES_U2 Unique FUSION_TS_TX_IDX APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE, TAX_REGIME_CODE, TAX, TAX_APPORTIONMENT_LINE_NUMBER, INDIRECT_TAX_LINE_ID, PAYMENT_ID, CHECKRUN_ID, PAYMENT_NUMBER Active