1. Tables and Views for Financials
  2. ZX_LINES_DET_FACTORS

ZX_LINES_DET_FACTORS

This table stores Lines Determing Factors

Details

  • Schema: FUSION

  • Object owner: ZX

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

ZX_LINES_DET_FACTORS_PK

LINES_DET_FACTOR_ID

Columns

Name Datatype Length Precision Not-null Comments Status
INTERNAL_ORGANIZATION_ID NUMBER Yes Internal organization identifier of the transaction Active
ACKNOWLEDGEMENT_NUMBER VARCHAR2 30 Acknowledgement number provided after tax data has been loaded
INVOICE_TYPE_CODE VARCHAR2 30 Invoice type identifier to indicate India specific invoice classifications.
HDR_TAXPAYER_ACTION_CODE VARCHAR2 30 Upload action identifier for each invoice header. Valid values are A - ACCEPT, D - DELETE, M - MODIFY, R - REJECT.
LINE_TAXPAYER_ACTION_CODE VARCHAR2 30 Upload action identifier for each invoice line. Valid values are A - ACCEPT, R - REJECT.
APPLICATION_ID NUMBER Yes Application Identifier of the transaction Active
ENTITY_CODE VARCHAR2 30 Yes Entity code of the application event class for the transaction Active
EVENT_CLASS_CODE VARCHAR2 30 Yes Application event class of the transaction Active
EVENT_CLASS_MAPPING_ID NUMBER Event class mapping identifier for an application event class that indicates the tax event class. Active
EVENT_TYPE_CODE VARCHAR2 30 Yes Application event type for the transaction Active
DOC_EVENT_STATUS VARCHAR2 30 Lookup code that indicates event status of the transaction Active
LINE_LEVEL_ACTION VARCHAR2 30 Yes Column to store action at the transaction line level Active
TRX_ID NUMBER Yes Primary transaction identifier Active
TRX_LINE_ID NUMBER Transaction line identifier Active
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. Active
HDR_TRX_USER_KEY1 VARCHAR2 150 First component of the user composite key to uniquely identify the transaction Active
HDR_TRX_USER_KEY2 VARCHAR2 150 Second component of the user composite key to uniquely identify the transaction Active
HDR_TRX_USER_KEY3 VARCHAR2 150 Third component of the user composite key to uniquely identify the transaction Active
HDR_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the user composite key to uniquely identify the transaction Active
HDR_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the user composite key to uniquely identify the transaction Active
HDR_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the user composite key to uniquely identify the transaction Active
LINE_TRX_USER_KEY1 VARCHAR2 150 First component of the line user composite key for uniquely identifying the transaction line Active
LINE_TRX_USER_KEY2 VARCHAR2 150 Second component of the line user composite key for uniquely identifying the transaction line Active
LINE_TRX_USER_KEY3 VARCHAR2 150 Third component of the line user composite key for uniquely identifying the transaction line Active
LINE_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the line user composite key for uniquely identifying the transaction line Active
LINE_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the line user composite key for uniquely identifying the transaction line Active
LINE_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the line user composite key for uniquely identifying the transaction line Active
TRX_DATE DATE Yes Transaction date Active
TRX_DOC_REVISION VARCHAR2 150 Revision number for the transaction. Active
LEDGER_ID NUMBER 18 Ledger identifying column Active
TRX_CURRENCY_CODE VARCHAR2 15 Transaction currency code Active
CURRENCY_CONVERSION_DATE DATE Date of the exchange rate Active
CURRENCY_CONVERSION_RATE NUMBER Exchange rate Active
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Exchange rate type Active
MINIMUM_ACCOUNTABLE_UNIT NUMBER Minimum accountable unit of the transaction currency Active
PRECISION NUMBER Precision of the transaction currency Active
LEGAL_ENTITY_ID NUMBER Yes Legal entity identifier for the transaction Active
ESTABLISHMENT_ID NUMBER Establishment identifier of the first party Active
RECEIVABLES_TRX_TYPE_ID NUMBER Transaction type identifier for Receivables transactions Active
RECEIVABLES_TRX_TYPE_SEQ_ID NUMBER Transaction type identifier for Receivables transactions Active
DEFAULT_TAXATION_COUNTRY VARCHAR2 2 Default taxation country code Active
TRX_NUMBER VARCHAR2 150 Transaction number, typically the number that enables a user to identify a transaction Active
TRX_LINE_NUMBER NUMBER Transaction line number Active
TRX_LINE_DESCRIPTION VARCHAR2 240 Description for the transaction line Active
TRX_DESCRIPTION VARCHAR2 240 Description for the transaction Active
TRX_COMMUNICATED_DATE DATE Printed or Received date of the transaction Active
BATCH_SOURCE_ID NUMBER Batch source identifier for Receivables transactions Active
BATCH_SOURCE_SEQ_ID NUMBER Batch source identifier for Receivables transactions Active
BATCH_SOURCE_NAME VARCHAR2 150 Batch source name for Receivables transactions Active
DOC_SEQ_ID NUMBER Identifies the document sequence Active
DOC_SEQ_NAME VARCHAR2 150 Name of the document sequence Active
DOC_SEQ_VALUE VARCHAR2 240 Value of the document sequence Active
TRX_DUE_DATE DATE Payment due date of the transaction Active
TRX_TYPE_DESCRIPTION VARCHAR2 240 Transaction type description for Receivables transactions Active
DOCUMENT_SUB_TYPE VARCHAR2 240 Document sub type code Active
SUPPLIER_TAX_INVOICE_NUMBER VARCHAR2 150 Transaction number on the supplier tax invoice Active
SUPPLIER_TAX_INVOICE_DATE DATE Transaction date on the supplier tax invoice Active
SUPPLIER_EXCHANGE_RATE NUMBER Exchange rate on the supplier tax invoice Active
TAX_INVOICE_DATE DATE Number for tax invoice generated by Receivables Active
TAX_INVOICE_NUMBER VARCHAR2 150 Transaction date for tax invoice generated by Receivables Active
FIRST_PTY_ORG_ID NUMBER Party tax profile identifier for the first party organization of the transaction 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
RDNG_SHIP_TO_PTY_TX_PROF_ID NUMBER Party tax profile identifier for the ship to party of the transaction used for rounding of tax amounts Active
RDNG_SHIP_FROM_PTY_TX_PROF_ID NUMBER Party tax profile identifier for the ship from party of the transaction used for rounding of tax amounts Active
RDNG_BILL_TO_PTY_TX_PROF_ID NUMBER Party tax profile identifier for the bill to party of the transaction used for rounding of tax amounts Active
RDNG_BILL_FROM_PTY_TX_PROF_ID NUMBER Party tax profile identifier for the bill from party of the transaction used for rounding of tax amounts Active
RDNG_SHIP_TO_PTY_TX_P_ST_ID NUMBER Party tax profile identifier for the ship to party site of the transaction used for rounding of tax amounts Active
RDNG_SHIP_FROM_PTY_TX_P_ST_ID NUMBER Party tax profile identifier for the ship from party site of the transaction used for rounding of tax amounts Active
RDNG_BILL_TO_PTY_TX_P_ST_ID NUMBER Party tax profile identifier for the bill to party site of the transaction used for rounding of tax amounts Active
RDNG_BILL_FROM_PTY_TX_P_ST_ID NUMBER Party tax profile identifier for the bill from party site of the transaction used for rounding of tax amounts Active
LINE_INTENDED_USE VARCHAR2 240 Intended use code of the transaction line. This identifies the purpose for which the product is used. Active
TRX_LINE_TYPE VARCHAR2 30 Column to store type of the transaction line. Possible values are ITEM, FREIGHT and MISC. Active
TRX_SHIPPING_DATE DATE Shipping date of the transaction at header or line level Active
TRX_RECEIPT_DATE DATE Receipt date of the transaction at header or line level Active
TRX_SIC_CODE VARCHAR2 150 Standard industry classification code of the transaction Active
FOB_POINT VARCHAR2 30 Free on Board point Active
TRX_WAYBILL_NUMBER VARCHAR2 50 Waybill number of the transaction Active
PRODUCT_ID NUMBER Column to store internal identifier of the inventory item or memo line used on this transaction line. Active
PRODUCT_FISC_CLASSIFICATION VARCHAR2 240 Product fiscal classification code of the inventory item Active
PRODUCT_ORG_ID NUMBER Identifier of the organization for the inventory item Active
UOM_CODE VARCHAR2 30 Unit of measure code for the inventory item Active
PRODUCT_TYPE VARCHAR2 240 Product type code of the inventory item. Possible values are GOODS and SERVICES. Active
PRODUCT_CODE VARCHAR2 300 Inventory item code Active
PRODUCT_CATEGORY VARCHAR2 240 Product category code of the transaction line Active
PRODUCT_DESCRIPTION VARCHAR2 240 Description of the inventory item or memo line used on the transaction line Active
USER_DEFINED_FISC_CLASS VARCHAR2 30 User defined fiscal classification code of the transaction line Active
LINE_AMT NUMBER Yes Transaction line amount Active
TRX_LINE_QUANTITY NUMBER Transaction line quantity Active
CASH_DISCOUNT NUMBER Cash discount amount Active
VOLUME_DISCOUNT NUMBER Volume discount quantity Active
TRADING_DISCOUNT NUMBER Trading discount amount Active
TRANSFER_CHARGE NUMBER Transfer charge Active
TRANSPORTATION_CHARGE NUMBER Transportation charge Active
INSURANCE_CHARGE NUMBER Insurance charge Active
OTHER_CHARGE NUMBER Other charge Active
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 Active
ASSET_FLAG VARCHAR2 1 Not currently used Active
ASSET_NUMBER VARCHAR2 150 Not currently used Active
ASSET_ACCUM_DEPRECIATION NUMBER Not currently used Active
ASSET_TYPE VARCHAR2 150 Not currently used Active
ASSET_COST NUMBER Not currently used Active
RELATED_DOC_APPLICATION_ID NUMBER Related document application identifier Active
RELATED_DOC_ENTITY_CODE VARCHAR2 30 Related document entity code Active
RELATED_DOC_EVENT_CLASS_CODE VARCHAR2 30 Related document event class code Active
RELATED_DOC_TRX_ID NUMBER Primary itransaction dentifier for the related document Active
REL_DOC_HDR_TRX_USER_KEY1 VARCHAR2 150 First component of the user composite key for uniquely identifying the related document Active
REL_DOC_HDR_TRX_USER_KEY2 VARCHAR2 150 Second component of the user composite key for uniquely identifying the related document Active
REL_DOC_HDR_TRX_USER_KEY3 VARCHAR2 150 Third component of the user composite key for uniquely identifying the related document Active
REL_DOC_HDR_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the user composite key for uniquely identifying the related document Active
REL_DOC_HDR_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the user composite key for the uniquely identifying related document Active
REL_DOC_HDR_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the user composite key for the uniquely identifying related document Active
RELATED_DOC_NUMBER VARCHAR2 150 Transaction number for related document Active
RELATED_DOC_DATE DATE Related document date Active
APPLIED_FROM_APPLICATION_ID NUMBER Applied from document application identifier Active
APPLIED_FROM_ENTITY_CODE VARCHAR2 30 Applied from document entity code Active
APPLIED_FROM_EVENT_CLASS_CODE VARCHAR2 30 Applied from document event class code Active
APPLIED_FROM_TRX_ID NUMBER Applied from document transaction identifier Active
APP_FROM_HDR_TRX_USER_KEY1 VARCHAR2 150 First component of the header level user composite key for uniquely identifying the applied from document Active
APP_FROM_HDR_TRX_USER_KEY2 VARCHAR2 150 Second component of the header level user composite key for uniquely identifying the applied from document Active
APP_FROM_HDR_TRX_USER_KEY3 VARCHAR2 150 Third component of the header level user composite key for uniquely identifying the applied from document Active
APP_FROM_HDR_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the header level user composite key for uniquely identifying the applied from document Active
APP_FROM_HDR_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the header level user composite key for uniquely identifying the applied from document Active
APP_FROM_HDR_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the header level user composite key for uniquely identifying the applied from document Active
APPLIED_FROM_LINE_ID NUMBER Transaction line identifier for the applied from document Active
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 Active
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 Active
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 Active
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 Active
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 Active
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 Active
ADJUSTED_DOC_APPLICATION_ID NUMBER Adjusted document application identifier Active
ADJUSTED_DOC_ENTITY_CODE VARCHAR2 30 Adjusted document entity code Active
ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2 30 Adjusted document event class code Active
ADJUSTED_DOC_TRX_ID NUMBER Adjusted document transaction identifier Active
ADJ_DOC_HDR_TRX_USER_KEY1 VARCHAR2 150 First component of the header level user composite key for uniquely identifying the adjusted document Active
ADJ_DOC_HDR_TRX_USER_KEY2 VARCHAR2 150 Second component of the header level user composite key for uniquely identifying the adjusted document Active
ADJ_DOC_HDR_TRX_USER_KEY3 VARCHAR2 150 Third component of the header level user composite key for uniquely identifying the adjusted document Active
ADJ_DOC_HDR_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the header level user composite key for uniquely identifying the adjusted document Active
ADJ_DOC_HDR_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the header level user composite key for uniquely identifying the adjusted document Active
ADJ_DOC_HDR_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the header level user composite key for uniquely identifying the adjusted document Active
ADJUSTED_DOC_LINE_ID NUMBER Transaction line identifier for the adjusted document Active
ADJ_DOC_LIN_TRX_USER_KEY1 VARCHAR2 150 First component of the line level user composite key for uniquely identifying the adjusted document line Active
ADJ_DOC_LIN_TRX_USER_KEY2 VARCHAR2 150 Second component of the line level user composite key for uniquely identifying the adjusted document line Active
ADJ_DOC_LIN_TRX_USER_KEY3 VARCHAR2 150 Third component of the line level user composite key for uniquely identifying the adjusted document line Active
ADJ_DOC_LIN_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the line level user composite key for uniquely identifying the adjusted document line Active
ADJ_DOC_LIN_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the line level user composite key for uniquely identifying the adjusted document line Active
ADJ_DOC_LIN_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the line level user composite key for uniquely identifying the adjusted document line Active
ADJUSTED_DOC_NUMBER VARCHAR2 150 Transaction number of the adjusted document Active
ADJUSTED_DOC_DATE DATE Adjusted document date Active
APPLIED_TO_APPLICATION_ID NUMBER Applied to document application identifier Active
APPLIED_TO_ENTITY_CODE VARCHAR2 30 Applied to document entity code Active
APPLIED_TO_EVENT_CLASS_CODE VARCHAR2 30 Applied to document event class code Active
APPLIED_TO_TRX_ID NUMBER Applied to document transaction identifier Active
APP_TO_HDR_TRX_USER_KEY1 VARCHAR2 150 First component of the header level user composite key for uniquely identifying the applied to document Active
APP_TO_HDR_TRX_USER_KEY2 VARCHAR2 150 Second component of the header level user composite keyfor uniquely identifying the applied to document Active
APP_TO_HDR_TRX_USER_KEY3 VARCHAR2 150 Third component of the header level user composite key for uniquely identifying the applied to document Active
APP_TO_HDR_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the header level user composite key for uniquely identifying the applied to document Active
APP_TO_HDR_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the header level user composite key for uniquely identifying the applied to document Active
APP_TO_HDR_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the header level user composite key for uniquely identifying the applied to document Active
APPLIED_TO_TRX_LINE_ID NUMBER Transaction line identifier for the applied to document Active
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 Active
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 Active
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 Active
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 Active
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 Active
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 Active
TRX_BUSINESS_CATEGORY VARCHAR2 240 Transaction business category code of the transaction line Active
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 80 Tax exemption certificate number Active
EXEMPT_REASON VARCHAR2 240 Tax exemption reason Active
HISTORICAL_FLAG VARCHAR2 1 Y or N represents whether the document or invoice has been upgraded from a prior release or whether it has been newly created. Active
TRX_LINE_GL_DATE DATE Accounting date for the transaction line Active
LINE_AMT_INCLUDES_TAX_FLAG VARCHAR2 1 Yes Lookup code to indicate whether any tax is included in the transaction line amount and unit price. Possible values are A, N, S and I. Active
ACCOUNT_CCID NUMBER Account identifier Active
ACCOUNT_STRING VARCHAR2 2000 Column to store concatanated account string value Active
MERCHANT_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for merchant party of the transaction line Active
HQ_ESTB_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for HQ establishment of the transaction line Active
NUMERIC1 NUMBER Not currently used Active
NUMERIC2 NUMBER Not currently used Active
NUMERIC3 NUMBER Not currently used Active
NUMERIC4 NUMBER Not currently used Active
NUMERIC5 NUMBER Not currently used Active
NUMERIC6 NUMBER Not currently used Active
NUMERIC7 NUMBER Not currently used Active
NUMERIC8 NUMBER Not currently used Active
NUMERIC9 NUMBER Not currently used Active
NUMERIC10 NUMBER Not currently used Active
CHAR1 VARCHAR2 150 Not currently used Active
CHAR2 VARCHAR2 150 Not currently used Active
CHAR3 VARCHAR2 150 Not currently used Active
CHAR4 VARCHAR2 150 Not currently used Active
CHAR5 VARCHAR2 150 Not currently used Active
CHAR6 VARCHAR2 150 Not currently used Active
CHAR7 VARCHAR2 150 Not currently used Active
CHAR8 VARCHAR2 150 Not currently used Active
CHAR9 VARCHAR2 150 Not currently used Active
CHAR10 VARCHAR2 150 Not currently used Active
DATE1 DATE Not currently used Active
DATE2 DATE Not currently used Active
DATE3 DATE Not currently used Active
DATE4 DATE Not currently used Active
DATE5 DATE Not currently used Active
DATE6 DATE Not currently used Active
DATE7 DATE Not currently used Active
DATE8 DATE Not currently used Active
DATE9 DATE Not currently used Active
DATE10 DATE Not currently used Active
MERCHANT_PARTY_NAME VARCHAR2 150 Merchant party name recorded for the Payables expense report Active
MERCHANT_PARTY_DOCUMENT_NUMBER VARCHAR2 150 Merchant party document number recorded for the Payables expense report Active
MERCHANT_PARTY_REFERENCE VARCHAR2 250 Merchant party reference recorded for the Payables expense report Active
MERCHANT_PARTY_TAXPAYER_ID VARCHAR2 150 Merchant party taxpayer ID recorded for the Payables expense report Active
MERCHANT_PARTY_TAX_REG_NUMBER VARCHAR2 150 Merchant party tax registration number recorded for the Payables expense report Active
MERCHANT_PARTY_ID NUMBER Merchant party identifier recorded for the Payables expense report Active
MERCHANT_PARTY_COUNTRY VARCHAR2 150 Merchant party country code Active
SHIP_TO_LOCATION_ID NUMBER Ship to location identifier Active
SHIP_FROM_LOCATION_ID NUMBER Ship from location identifier Active
POA_LOCATION_ID NUMBER Point of Acceptance location identifier Active
POO_LOCATION_ID NUMBER Point of Origin location identifier Active
BILL_TO_LOCATION_ID NUMBER Bill to location identifier Active
BILL_FROM_LOCATION_ID NUMBER Bill from location identifier Active
PAYING_LOCATION_ID NUMBER Not currently used Active
OWN_HQ_LOCATION_ID NUMBER Not currently used Active
TRADING_HQ_LOCATION_ID NUMBER Not currently used Active
POC_LOCATION_ID NUMBER Not currently used Active
POI_LOCATION_ID NUMBER Not currently used Active
POD_LOCATION_ID NUMBER Not currently used Active
TITLE_TRANSFER_LOCATION_ID NUMBER Not currently used Active
SHIP_TO_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for ship to party of the transaction line Active
SHIP_FROM_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for ship from party of the transaction line Active
POA_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for point of acceptance party of the transaction line Active
POO_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for point of origin party of the transaction line Active
PAYING_PARTY_TAX_PROF_ID NUMBER Not currently used Active
OWN_HQ_PARTY_TAX_PROF_ID NUMBER Not currently used Active
TRADING_HQ_PARTY_TAX_PROF_ID NUMBER Not currently used Active
POI_PARTY_TAX_PROF_ID NUMBER Not currently used Active
POD_PARTY_TAX_PROF_ID NUMBER Not currently used Active
BILL_TO_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for bill to party of the transaction line Active
BILL_FROM_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for bill from party of the transaction line Active
TITLE_TRANS_PARTY_TAX_PROF_ID NUMBER Not currently used Active
SHIP_TO_SITE_TAX_PROF_ID NUMBER Party tax profile identifier for ship to party site of the transaction line Active
SHIP_FROM_SITE_TAX_PROF_ID NUMBER Party tax profile identifier for ship from party site of the transaction line Active
POA_SITE_TAX_PROF_ID NUMBER Party tax profile identifier for point of acceptance party site of the transaction line Active
POO_SITE_TAX_PROF_ID NUMBER Party tax profile identifier for point of origin party site of the transaction line Active
PAYING_SITE_TAX_PROF_ID NUMBER Not currently used Active
OWN_HQ_SITE_TAX_PROF_ID NUMBER Not currently used Active
TRADING_HQ_SITE_TAX_PROF_ID NUMBER Not currently used Active
POI_SITE_TAX_PROF_ID NUMBER Not currently used Active
POD_SITE_TAX_PROF_ID NUMBER Not currently used Active
BILL_TO_SITE_TAX_PROF_ID NUMBER Party tax profile identifier for bill to party site of the transaction line Active
BILL_FROM_SITE_TAX_PROF_ID NUMBER Party tax profile identifier for bill from party site of the transaction line Active
TITLE_TRANS_SITE_TAX_PROF_ID NUMBER Not currently used Active
CTRL_HDR_TX_APPL_FLAG VARCHAR2 1 Y or N indicates whether the control amount for the total tax amount is available at the header level Active
CTRL_TOTAL_LINE_TX_AMT NUMBER Control amount for the total tax amount at the line level Active
CTRL_TOTAL_HDR_TX_AMT NUMBER Control amount at the header level for the total tax amount Active
REF_DOC_APPLICATION_ID NUMBER Reference document application identifier Active
REF_DOC_ENTITY_CODE VARCHAR2 30 Reference document entity code Active
REF_DOC_EVENT_CLASS_CODE VARCHAR2 30 Reference document event class code Active
REF_DOC_TRX_ID NUMBER Reference document transaction identifier Active
REF_DOC_HDR_TRX_USER_KEY1 VARCHAR2 150 First component of the header level user composite key for uniquely identifying the reference document Active
REF_DOC_HDR_TRX_USER_KEY2 VARCHAR2 150 Second component of the header level user composite key for uniquely identifying the reference document Active
REF_DOC_HDR_TRX_USER_KEY3 VARCHAR2 150 Third component of the header level user composite key for uniquely identifying the reference document Active
REF_DOC_HDR_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the header level user composite key for uniquely identifying the reference document Active
REF_DOC_HDR_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the header level user composite key for uniquely identifying the reference document Active
REF_DOC_HDR_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the header level user composite key for uniquely identifying the reference document Active
REF_DOC_LINE_ID NUMBER Transaction line identifier for the reference document Active
REF_DOC_LIN_TRX_USER_KEY1 VARCHAR2 150 First component of the line level user composite key for uniquely identifying the reference document line Active
REF_DOC_LIN_TRX_USER_KEY2 VARCHAR2 150 Second component of the line level user composite key for uniquely identifying the reference document line Active
REF_DOC_LIN_TRX_USER_KEY3 VARCHAR2 150 Third component of the line level user composite key for uniquely identifying the reference document line Active
REF_DOC_LIN_TRX_USER_KEY4 VARCHAR2 150 Fourth component of the line level user composite key for uniquely identifying the reference document line Active
REF_DOC_LIN_TRX_USER_KEY5 VARCHAR2 150 Fifth component of the line level user composite key for uniquely identifying the reference document line Active
REF_DOC_LIN_TRX_USER_KEY6 VARCHAR2 150 Sixth component of the line level user composite key for uniquely identifying the reference document line Active
REF_DOC_LINE_QUANTITY NUMBER Reference document line quantity Active
LINE_CLASS VARCHAR2 30 Column to store event class for the transaction line Active
TRX_LINE_DATE DATE Transaction line date Active
INPUT_TAX_CLASSIFICATION_CODE VARCHAR2 50 Tax classifiation code for Procure To Pay products Active
OUTPUT_TAX_CLASSIFICATION_CODE VARCHAR2 50 Tax classifiation code for Order To Cash products Active
INTERNAL_ORG_LOCATION_ID NUMBER Internal organization location identifier of the transaction Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
PORT_OF_ENTRY_CODE VARCHAR2 30 Port of entry code Active
TAX_REPORTING_FLAG VARCHAR2 1 Tax reporting flag for lease management Active
TAX_AMT_INCLUDED_FLAG VARCHAR2 1 Y or N indicates if the transaction line amount includes tax amount Active
COMPOUNDING_TAX_FLAG VARCHAR2 1 Y or N indicates if one of the taxes is compounded with another tax for the transaction line Active
TRX_ID_LEVEL5 NUMBER Transaction identifier at a level between trx_id_level4 and trx_line_id 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
EVENT_ID NUMBER 18 Unique identifier of a specific event that triggers call to a tax processing API. This value will be stamped on all transaction lines passed as input during that API call. Active
THRESHOLD_INDICATOR_FLAG VARCHAR2 1 Y or N indicates if there are thresholds applied at the document level or not. This column is used for supporting integration with third party tax vendors. Active
PROVNL_TAX_DETERMINATION_DATE DATE Transaction date of the original transaction in case of lease management when a lease contract is revised Active
UNIT_PRICE NUMBER Unit Price of the transaction line item or product Active
SHIP_TO_CUST_ACCT_SITE_USE_ID NUMBER Column to record ship to customer account site use identifier for Receivables. Active
BILL_TO_CUST_ACCT_SITE_USE_ID NUMBER Column to record bill to customer account site use identifier for Receivables Active
TRX_BATCH_ID NUMBER 18 Transaction batch identifier Active
APPLIED_TO_TRX_NUMBER VARCHAR2 150 Applied to document transaction number Active
START_EXPENSE_DATE DATE Start expense date of a Payables Invoice distribution Active
SOURCE_APPLICATION_ID NUMBER Source document application identifier Active
SOURCE_ENTITY_CODE VARCHAR2 30 Source document entity code Active
SOURCE_EVENT_CLASS_CODE VARCHAR2 30 Source document event class code Active
SOURCE_TRX_ID NUMBER Source document transaction identifier Active
SOURCE_LINE_ID NUMBER Source document transaction line identifier Active
SOURCE_TRX_LEVEL_TYPE VARCHAR2 30 Column to record the level at which the source document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. Active
RECORD_TYPE_CODE VARCHAR2 30 Yes Lookup code to indicate whether the record is migrated, seeded or defined by the user Active
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. Active
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. Active
APPLIED_FROM_TRX_LEVEL_TYPE VARCHAR2 30 Level at which the applied from document line identifier is stored. Possible values are LINE, SHIPMENT, et cetera. Active
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. Active
INCLUSIVE_TAX_OVERRIDE_FLAG VARCHAR2 1 Y or N indicates whether any system determined inclusive tax line is updated or overridden by the user for this transaction line Active
TAX_PROCESSING_COMPLETED_FLAG VARCHAR2 1 Y or N indicates whether the tax calculation is pending for this transaction line 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
APPLICATION_DOC_STATUS VARCHAR2 30 Transaction status as stored by the application Active
USER_UPD_DET_FACTORS_FLAG VARCHAR2 1 Yes or No indicates whether the user has updated additional tax determining factors such as transaction business category, assessable value, et cetera. Active
SOURCE_TAX_LINE_ID NUMBER Column to record source document tax line identifier that is represented by the current transaction line for billing purposes Active
REVERSED_APPLN_ID NUMBER Reversed transaction application Identifier Active
REVERSED_ENTITY_CODE VARCHAR2 30 Reversed transaction entity code Active
REVERSED_EVNT_CLS_CODE VARCHAR2 30 Reversed transaction event class code Active
REVERSED_TRX_ID NUMBER Reversed transaction identifier Active
REVERSED_TRX_LEVEL_TYPE VARCHAR2 30 Column to record the level at which the reversed transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. Active
REVERSED_TRX_LINE_ID NUMBER Reversed transaction line identifier Active
TAX_CALCULATION_DONE_FLAG VARCHAR2 1 Y or N indicates whether the taxes have been determined for this transaction line previously Active
APPLIED_FROM_TRX_NUMBER VARCHAR2 150 Transaction number of the applied from document Active
PARTNER_MIGRATED_FLAG VARCHAR2 1 Y or N indicates if the transaction is migrated to third party tax vendor repository. Null for newly created transactions. Active
SHIP_THIRD_PTY_ACCT_SITE_ID NUMBER Column to record ship to customer account site identifier for Receivables or ship from supplier site identifier for Payables Active
BILL_THIRD_PTY_ACCT_SITE_ID NUMBER Column to record bill to customer account site identifier for Receivables or bill from supplier site identifier for Payables Active
SHIP_THIRD_PTY_ACCT_ID NUMBER Column to record ship to customer account identifier for Receivables or ship from supplier identifier for Payables Active
BILL_THIRD_PTY_ACCT_ID NUMBER Column to record bill to customer account identifier for Receivables or bill from supplier identifier for Payables Active
EXEMPTION_CONTROL_FLAG VARCHAR2 1 Lookup code to control the application of exemptions to the transaction line during tax lines calculation. Possible values are R, S and E. Active
EXEMPT_REASON_CODE VARCHAR2 30 Exemption reason code Active
INTERFACE_ENTITY_CODE VARCHAR2 30 Column to temporarily store entity code of the transaction line interface table Active
INTERFACE_LINE_ID NUMBER Column to temporarily store identifier of the interface line corresponding to the transaction line during import of transactions into Receivables Active
DEFAULTING_ATTRIBUTE1 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
DEFAULTING_ATTRIBUTE2 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
DEFAULTING_ATTRIBUTE3 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
DEFAULTING_ATTRIBUTE4 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
DEFAULTING_ATTRIBUTE5 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
DEFAULTING_ATTRIBUTE6 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
DEFAULTING_ATTRIBUTE7 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
DEFAULTING_ATTRIBUTE8 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
DEFAULTING_ATTRIBUTE9 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
DEFAULTING_ATTRIBUTE10 VARCHAR2 150 Attribute used in rules for defaulting one of the tax determining factors Active
TRX_ID_LEVEL6 NUMBER Transaction identifier at a level between trx_id_level5 and trx_line_id Active
HISTORICAL_TAX_CODE_ID NUMBER 18 Tax classification code identifier stored on the historical transactions Active
ICX_SESSION_ID NUMBER 18 ICX user session identifier Active
TRX_LINE_CURRENCY_CODE VARCHAR2 15 Transaction line currency code Active
TRX_LINE_CURRENCY_CONV_RATE NUMBER Transaction line exchange rate Active
TRX_LINE_CURRENCY_CONV_DATE DATE Transaction line date of the exchange rate Active
TRX_LINE_PRECISION NUMBER Precision of the transaction line currency Active
TRX_LINE_MAU NUMBER Minimum accountable unit of the transaction line currency Active
TRX_LINE_CURRENCY_CONV_TYPE VARCHAR2 30 Transaction line exchange rate type Active
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 150 Global Descriptive Flexfield: structure definition of the global descriptive flexfield. Active
TOTAL_INC_TAX_AMT NUMBER Total inclusive tax amount for a specific line item. Active
LINES_DET_FACTOR_ID NUMBER 18 Yes ID Column Active
PROD_FC_CATEG_ID NUMBER Product fiscal category unique identifier
INTENDED_USE_CLASSIF_ID NUMBER Default intended use code for transactions for a specified country.
FIRST_PTY_REG_ID NUMBER 18 First Party Tax Registration ID for the transaction.
THIRD_PTY_REG_ID NUMBER 18 Third Party Tax Registration ID for the transaction.
MATCH_TYPE VARCHAR2 25 Indicates the type of match for Payables transaction.
TRX_SOURCE VARCHAR2 30 Source identifier of the transaction.
FOS_TRANSACTION_ID NUMBER 18 Supply chain financial orchestration agreement identifier.
RECEIPT_SOURCE_CODE VARCHAR2 25 Source type of a shipment associated with a transaction.
DROPSHIP_TYPE_ID NUMBER 18 Identifier for a drop ship transaction.
REQUISITION_TYPE VARCHAR2 25 Requisition type associated a transaction line.
PURCHASING_CATEGORY_ID NUMBER 18 Item category identifier for a transaction line.
DROP_SHIP_FLAG VARCHAR2 1 Yes or No indicates whether a transaction line is a drop ship transaction.
CONSIGNED_FLAG VARCHAR2 1 Yes or No indicates whether a transaction line is consigned.
DESTINATION_TYPE_CODE VARCHAR2 25 Destination type code for a good or service on a transaction line.
CONSIGN_ITM_UPON_RECPT_FLAG VARCHAR2 1 Yes or No indicates a consigned item upon receipt.
EXPENDITURE_TYPE VARCHAR2 30 Project expenditure type used to build accounting flexfield for project-related distribution line.
PORT_OF_DISCHARGE VARCHAR2 150 Location code where a ship voluntarily and without cause of necessity breaks bulk and discharges part or all of its cargo.
PORT_OF_LOADING VARCHAR2 150 Location code where shipments are loaded and secured aboard a vessel.
DELIVERY_TYPE VARCHAR2 30 Delivery type for a good or service on a transaction line.
DOCUMENT_TYPE VARCHAR2 30 Document type for a good or service on a transaction line.
SHIPMENT_TYPE VARCHAR2 25 Shipment type associated with a transaction line.
GL_DATE DATE Default accounting date for transactions.
HDR_GL_DATE DATE Transaction header level accounting date.
WHT_GROUP_ID NUMBER 18 Withholding group identifier for the transaction line.
WITHHELD_TAX_AMT NUMBER Withheld tax amount for the transaction.
FINAL_DISCHARGE_LOCATION_ID NUMBER 18 Final destination location identifier for the purchases made by the customer.
FINAL_TRANSACTION_NODE_FLAG VARCHAR2 1 Yes or No indicates whether an internal material transfer is backed by an invoice.
COUNTRY_OF_ORIGIN_CODE VARCHAR2 2 Code for the country of the manufacture.
PROCESS_TAX_DISTS_FLAG VARCHAR2 1 Indicates whether to create tax distributions for both receivables and payables.
DEFAULT_ADDNL_ATTRIBS_FLAG VARCHAR2 1 Yes or No indicates whether additional attributes should be defaulted on transaction line.
TAX_CALC_MODE_FLAG VARCHAR2 1 Indicates if transaction processing is done in quote mode.
BATCH_NAME VARCHAR2 80 To identify the name of the batch for external transactions.
CREDIT_ACCOUNT_CCID NUMBER 18 Credit account identifier for the transaction line.
DEBIT_ACCOUNT_CCID NUMBER 18 Debit account identifier for the transaction line.
LINK_TO_TRX_LINE_ID NUMBER 18 Link from the reference item line to the charge line.
PACKING_CHARGE NUMBER Amount of the packing charge on a transaction.
PURCHASE_BASIS VARCHAR2 30 Monetary value basis of the line type.
ACCRUE_ON_RECEIPT_FLAG VARCHAR2 1 Yes or No indicates whether the underlying procure-to-pay transaction allows accrual on receipt.
LINE_GROUP_ID NUMBER 18 Identifer to group multiple transaction lines together, such as grouping mutiple shipment lines as one fulfillment line.
PAYMENT_METHOD VARCHAR2 30 Name of payment method on a transaction.
WHT_CALCULATION_FLAG VARCHAR2 1 Indicates whether withholding tax is calculated. Valid values: Y and N.
EXPENDITURE_TYPE_ID NUMBER 18 Project expenditure type identifier.
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.
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.
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.
RETAINAGE_AMT NUMBER Retainage amount for the item line.
RETAINAGE_PERCENTAGE NUMBER Retainage percentage for the item line.
TAX_GROSS_NET_FLAG VARCHAR2 1 Transaction tax calculated on the gross or net amount identifier.
WHT_GROSS_NET_FLAG VARCHAR2 1 Withholding tax calculated on the gross or net amount identifier.
TRANSACTION_LINE_GEOGRAPHY_ID NUMBER 18 Column to store the geography ID of the place where the transaction took place. For example, the geography ID of the city where an employee incurred a meal.

Foreign Keys

Table Foreign Table Foreign Key Column
ZX_LINES_DET_FACTORS hz_cust_acct_sites_all BILL_THIRD_PTY_ACCT_SITE_ID
ZX_LINES_DET_FACTORS hz_cust_accounts SHIP_THIRD_PTY_ACCT_ID
ZX_LINES_DET_FACTORS hz_cust_accounts BILL_THIRD_PTY_ACCT_ID
ZX_LINES_DET_FACTORS zx_evnt_cls_mappings EVENT_CLASS_MAPPING_ID
ZX_LINES_DET_FACTORS ap_tax_codes_all HISTORICAL_TAX_CODE_ID
ZX_LINES_DET_FACTORS hz_locations SHIP_TO_LOCATION_ID
ZX_LINES_DET_FACTORS hz_locations SHIP_FROM_LOCATION_ID
ZX_LINES_DET_FACTORS hz_locations BILL_TO_LOCATION_ID
ZX_LINES_DET_FACTORS hz_locations BILL_FROM_LOCATION_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile SHIP_TO_PARTY_TAX_PROF_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile SHIP_FROM_PARTY_TAX_PROF_ID
ZX_LINES_DET_FACTORS hz_cust_site_uses_all SHIP_TO_CUST_ACCT_SITE_USE_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile POA_PARTY_TAX_PROF_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile POO_PARTY_TAX_PROF_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile BILL_TO_PARTY_TAX_PROF_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile BILL_FROM_PARTY_TAX_PROF_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile TITLE_TRANS_PARTY_TAX_PROF_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile SHIP_TO_SITE_TAX_PROF_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile SHIP_FROM_SITE_TAX_PROF_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile POA_SITE_TAX_PROF_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile POO_SITE_TAX_PROF_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile BILL_TO_SITE_TAX_PROF_ID
ZX_LINES_DET_FACTORS hz_cust_site_uses_all BILL_TO_CUST_ACCT_SITE_USE_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile BILL_FROM_SITE_TAX_PROF_ID
ZX_LINES_DET_FACTORS gl_code_combinations ACCOUNT_CCID
ZX_LINES_DET_FACTORS zx_event_classes_b TAX_EVENT_CLASS_CODE
ZX_LINES_DET_FACTORS zx_evnt_cls_typs TAX_EVENT_CLASS_CODE, TAX_EVENT_TYPE_CODE
ZX_LINES_DET_FACTORS zx_party_tax_profile RDNG_SHIP_TO_PTY_TX_PROF_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile RDNG_SHIP_FROM_PTY_TX_PROF_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile RDNG_BILL_TO_PTY_TX_PROF_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile RDNG_BILL_FROM_PTY_TX_PROF_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile RDNG_SHIP_TO_PTY_TX_P_ST_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile RDNG_SHIP_FROM_PTY_TX_P_ST_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile RDNG_BILL_TO_PTY_TX_P_ST_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile RDNG_BILL_FROM_PTY_TX_P_ST_ID
ZX_LINES_DET_FACTORS zx_lines SOURCE_TAX_LINE_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile MERCHANT_PARTY_TAX_PROF_ID
ZX_LINES_DET_FACTORS zx_party_tax_profile HQ_ESTB_PARTY_TAX_PROF_ID
ZX_LINES_DET_FACTORS ra_batches_all TRX_BATCH_ID
ZX_LINES_DET_FACTORS hz_cust_acct_sites_all SHIP_THIRD_PTY_ACCT_SITE_ID

Indexes

Index Uniqueness Tablespace Columns Status
ZX_LINES_DET_FACTORS_N1 Non Unique FUSION_TS_TX_IDX EVENT_ID, TRX_ID, EVENT_CLASS_CODE, ENTITY_CODE, APPLICATION_ID Active
ZX_LINES_DET_FACTORS_N2 Non Unique Default TRX_ID, LEDGER_ID
ZX_LINES_DET_FACTORS_N3 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_DET_FACTORS_U1 Unique FUSION_TS_TX_IDX LINES_DET_FACTOR_ID Active
ZX_LINES_DET_FACTORS_U2 Unique FUSION_TS_TX_IDX EVENT_CLASS_MAPPING_ID, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE, ICX_SESSION_ID Active
ZX_LINES_DET_FACTORS_U3 Unique FUSION_TS_TX_IDX APPLICATION_ID, EVENT_CLASS_CODE, ENTITY_CODE, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE, ICX_SESSION_ID Active