1. Tables and Views for Financials
  2. ZX_REP_TRX_DETAIL_T

ZX_REP_TRX_DETAIL_T

ZX_REP_TRX_DETAIL_T contains tax information for tax reporting purposes from Accounts Payable and Accounts Receivable, and Tax repository.

Details

  • Schema: FUSION

  • Object owner: ZX

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

ZX_REP_TRX_DETAIL_T_PK

DETAIL_TAX_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments
DETAIL_TAX_LINE_ID NUMBER 18 Yes Detail tax line identifier
TAX_EVENT_CLASS_CODE VARCHAR2 30 Tax event class short name of the transaction.
REP_CONTEXT_ID NUMBER 18 Report context identifier
EXTRACT_LINE_ID NUMBER 18 Unique identifier
EXTRACT_REPORT_LINE_NUMBER NUMBER Sequential line number generated within the tax ledger for this tax line
LEDGER_ID NUMBER 18 Ledger defining column
LEDGER_NAME VARCHAR2 30 Ledger name
CHART_OF_ACCOUNTS_ID NUMBER 18 Accounting key flexfield structure defining column
EXTRACT_SOURCE_LEDGER VARCHAR2 30 Source ledger for this line. Possible values are Accounts Payable, Accounts Receivable and General Ledger.
EVENT_CLASS_CODE VARCHAR2 30 Application event class code
EVENT_CLASS_MAPPING_ID NUMBER Event class mapping identifier
DOC_EVENT_STATUS VARCHAR2 30 Document event status for this line in tax repository
APPLICATION_DOC_STATUS VARCHAR2 30 Transaction status as stored by the application.
ESTABLISHMENT_ID NUMBER Establishment identifier of the first party for this line
APPLICATION_ID NUMBER Application identifier of the transaction
INTERNAL_ORGANIZATION_ID NUMBER Internal organization identifier of the transaction
TRX_ID NUMBER 18 Primary transaction identifier
TRX_NUMBER VARCHAR2 150 Transaction number, typically the number that enables a user to identify a transaction
TRX_DESCRIPTION VARCHAR2 240 Description for the transaction
TRX_CURRENCY_CODE VARCHAR2 15 Transaction currency code
TRX_LINE_ID NUMBER 18 Transaction line identifier
TRX_LINE_NUMBER NUMBER Transaction line number
TRX_LINE_DESCRIPTION VARCHAR2 240 Description for the transaction line
TRX_LINE_TYPE VARCHAR2 30 Column to store type of the transaction line. Possible values are ITEM, FREIGHT and MISC.
TRX_DATE DATE Transaction date
DEPOSIT_DATE DATE Deposit date
TRX_DUE_DATE DATE Transaction due date
TRX_SHIPPING_DATE DATE Shipping date of the transaction at header or line level
TRX_COMMUNICATED_DATE DATE Receipt date of the transaction at header or line level
TRX_TYPE_DESCRIPTION VARCHAR2 240 Receivables transaction type description
TRX_TYPE_SEQ_ID NUMBER 18 Receivables transaction type identifier
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.
TRX_BATCH_SOURCE_NAME VARCHAR2 150 Transaction batch source name
TRX_SIC_CODE VARCHAR2 150 Standard industry classification code of the transaction
FOB_POINT VARCHAR2 30 Free on Board point
TRX_WAYBILL_NUMBER VARCHAR2 50 Waybill number of the transaction
TRX_LINE_CLASS VARCHAR2 30 Column to store event class for the transaction line
PRODUCT_ID NUMBER Column to store internal identifier of the inventory item or memo line used on this transaction line.
PRODUCT_DESCRIPTION VARCHAR2 240 Description of the inventory item or memo line used on the transaction line
FUNCTIONAL_CURRENCY_CODE VARCHAR2 30 Functional currency code
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Exchange rate type
CURRENCY_CONVERSION_DATE DATE Date of the exchange rate
CURRENCY_CONVERSION_RATE NUMBER Exchange rate
PRECISION NUMBER Precision of the transaction currency
MINIMUM_ACCOUNTABLE_UNIT NUMBER Minimum accountable unit of the transaction currency
GDF_FND_CURRENCIES_ATT1 VARCHAR2 150 Reserved for country specific localizations
CURRENCY_CODE_DESC VARCHAR2 240 Currency code description
TERRITORY_SHORT_NAME VARCHAR2 80 Territory short name
DOC_SEQ_ID NUMBER 18 Identifies the document sequence
DOC_SEQ_NAME VARCHAR2 150 Name of the document sequence
DOC_SEQ_VALUE VARCHAR2 240 Value of the document sequence
TRX_LINE_QUANTITY NUMBER Transaction line quantity
TRX_LINE_AMT NUMBER Transaction line amount
UOM_CODE VARCHAR2 30 Unit of measure code for the inventory item
RECEIPT_CLASS_ID NUMBER 18 Receipt class identifier
TRX_BATCH_SOURCE_SEQ_ID NUMBER 18 Batch source identifier
TRX_BATCH_SOURCE_DATE DATE Transaction batch date
RELATED_DOC_APPLICATION_ID NUMBER 18 Related document application identifier
RELATED_DOC_ENTITY_CODE VARCHAR2 30 Related document entity code
RELATED_DOC_EVENT_CLASS_CODE VARCHAR2 30 Related document event class code
RELATED_DOC_TRX_ID NUMBER 18 Primary transaction identifier for the related document.
RELATED_DOC_NUMBER VARCHAR2 150 Transaction number for related document
RELATED_DOC_DATE DATE Related document date
APPLIED_FROM_APPLICATION_ID NUMBER 18 Applied from document application identifier
APPLIED_FROM_LINE_ID NUMBER 18 Transaction line identifier for the applied from document
APPLIED_FROM_ENTITY_CODE VARCHAR2 30 Applied from document entity code
APPLIED_FROM_TRX_ID NUMBER 18 Applied from document transaction identifier
APPLIED_FROM_EVENT_CLASS_CODE VARCHAR2 30 Applied from document event class code
APPLIED_FROM_TRX_NUMBER VARCHAR2 150 Transaction number of the applied from document
TRX_APPLIED_FROM_CLASS_MNG VARCHAR2 80 Transaction class meaning for applied from document
ADJUSTED_DOC_APPLICATION_ID NUMBER 18 Adjusted document application identifier
ADJUSTED_DOC_ENTITY_CODE VARCHAR2 30 Adjusted document entity code
ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2 30 Adjusted document event class code
ADJUSTED_DOC_TRX_ID NUMBER 18 Adjusted document transaction identifier
ADJUSTED_DOC_NUMBER VARCHAR2 150 Transaction number of the adjusted document
ADJUSTED_DOC_DATE DATE Adjusted document date
APPLIED_TO_APPLICATION_ID NUMBER 18 Applied to document application identifier
APPLIED_TO_TRX_ID NUMBER 18 Applied to document transaction identifier
APPLIED_TO_TRX_LINE_ID NUMBER 18 Transaction line identifier for the applied to document
APPLIED_TO_ENTITY_CODE VARCHAR2 30 Applied to document entity code
APPLIED_TO_EVENT_CLASS_CODE VARCHAR2 30 Applied to document event class code
APPLIED_TO_TRX_NUMBER VARCHAR2 150 Transaction number of the applied to document
TRX_APPLIED_TO_CLASS_MNG VARCHAR2 80 Transaction class meaning for applied to document
REF_DOC_APPLICATION_ID NUMBER 18 Reference document application identifier
REF_DOC_ENTITY_CODE VARCHAR2 30 Reference document entity code
REF_DOC_EVENT_CLASS_CODE VARCHAR2 30 Reference document event class code
REF_DOC_TRX_ID NUMBER 18 Reference document transaction identifier
REF_DOC_LINE_ID NUMBER 18 Transaction line identifier for the reference document
REF_DOC_LINE_QUANTITY NUMBER Reference document line quantity
MERCHANT_PARTY_DOCUMENT_NUMBER VARCHAR2 150 Merchant party document number recorded for Expense Report.
MERCHANT_PARTY_NAME VARCHAR2 150 Merchant party name recorded for Expense Report.
MERCHANT_PARTY_REFERENCE VARCHAR2 250 Merchant party reference recorded for Expense Report.
MERCHANT_PARTY_TAX_REG_NUMBER VARCHAR2 150 Merchant party Tax Registration Number recorded for Expense Report.
MERCHANT_PARTY_TAXPAYER_ID VARCHAR2 150 Merchant party Taxpayer Identification number recorded for Expense Report.
COUNTRY_OF_SUPPLY VARCHAR2 150 Country of supply
START_EXPENSE_DATE DATE Start expense date of an Accounts Payable invoice distribution.
DEFAULT_TAXATION_COUNTRY VARCHAR2 2 Default taxation country code
TRX_CLASS_MNG VARCHAR2 80 Meaning for the transaction class
TRX_TYPE_MNG VARCHAR2 80 Meaning for the transaction type
TAX_RATE_CODE_REG_TYPE_MNG VARCHAR2 80 Meaning for the registration type of the tax rate
TAX_EXEMPT_REASON_MNG VARCHAR2 80 Exempt reason meaning
TAX_EXCEPTION_REASON_MNG VARCHAR2 80 Exception reason meaning
TRX_QUANTITY_UOM_MNG VARCHAR2 80 Unit of measure meaning
TAX_RATE_CODE_VAT_TRX_TYPE_MNG VARCHAR2 240 Meaning associated with VAT transaction type code for the tax rate
DOCUMENT_SUB_TYPE VARCHAR2 240 Document sub type code
SUPPLIER_TAX_INVOICE_NUMBER VARCHAR2 150 Transaction number on the supplier tax invoice
SUPPLIER_TAX_INVOICE_DATE DATE Transaction date on the supplier tax invoice
SUPPLIER_EXCHANGE_RATE NUMBER Exchange rate on the supplier tax invoice
TAX_INVOICE_DATE DATE Number for tax invoice generated by Receivables
TAX_INVOICE_NUMBER VARCHAR2 150 Transaction date for tax invoice generated by Receivables
LINE_INTENDED_USE VARCHAR2 240 Intended use code of the transaction line. This identifies the purpose for which the product is used.
PRODUCT_FISC_CLASSIFICATION VARCHAR2 240 Product fiscal classification code of the inventory item
PRODUCT_CATEGORY VARCHAR2 240 Product category code of the transaction line
USER_DEFINED_FISC_CLASS VARCHAR2 30 User defined fiscal classification code of the transaction line
TRX_BUSINESS_CATEGORY VARCHAR2 240 Transaction business category code of the transaction line
ASSESSABLE_VALUE NUMBER Assessable value is the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes
PORT_OF_ENTRY_CODE VARCHAR2 30 Port of entry code
TAXABLE_LINE_ITEM_FLEXFIELD VARCHAR2 2000 Description of the inventory item used on this invoice line
TAXABLE_LINE_SOURCE_TABLE VARCHAR2 30 Column to identify the source table for the taxable line
TAXABLE_LINE_TOTAL_AMOUNT NUMBER Sum of taxable and exempt amounts for Receivables invoice lines
TAX_LINE_ID NUMBER 18 Tax line Identifier
TAX_LINE_NUMBER NUMBER Tax line number
TAX_AMT NUMBER Tax amount in transaction currency
TAX_AMT_FUNCL_CURR NUMBER Tax amount in functional currency
TAXABLE_AMT NUMBER Taxable amount in transaction currency
TAXABLE_AMT_FUNCL_CURR NUMBER Taxable amount in functional currency
TAXABLE_DISC_AMT NUMBER Taxable discount amount in transaction currency
TAXABLE_DISC_AMT_FUNCL_CURR NUMBER Taxable discount amount in functional currency
TAX_DISC_AMT NUMBER Tax amount of the discount in transaction currency
TAX_DISC_AMT_FUNCL_CURR NUMBER Tax amount of the discount in functional currency
TAX_RATE_CODE VARCHAR2 150 Tax rate code
TAX_RATE NUMBER Tax rate
TAX_RATE_VAT_TRX_TYPE_CODE VARCHAR2 30 VAT transaction type code for the tax rate
TAX_RATE_VAT_TRX_TYPE_DESC VARCHAR2 240 VAT transaction type description
TAX_TYPE_CODE VARCHAR2 30 Tax type code
TAX_TYPE_MNG VARCHAR2 80 Tax type meaning
TAX_STATUS_ID NUMBER 18 Tax status identifier
TAX_RATE_CODE_NAME VARCHAR2 240 Tax rate name
TAX_RATE_CODE_DESCRIPTION VARCHAR2 240 Tax rate description
TAX_RATE_ID NUMBER 18 Tax rate identifier
TAX_RATE_REGISTER_TYPE_CODE VARCHAR2 30 Tax rate registration type
TAX_APPLIED NUMBER Tax amount applied
TAX_PROVIDER_ID NUMBER Party tax profile identifier of the third party service provider that has determined the tax on this line.
DEF_REC_SETTLEMENT_OPTION_CODE VARCHAR2 30 Default settlement option
OFFSET_TAX_RATE_CODE VARCHAR2 150 Offset tax rate code associated with the tax line.
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 80 Exempt certificate number
EXEMPT_REASON_CODE VARCHAR2 30 Exempt reason code
TAX_EXCEPTION_REASON_CODE VARCHAR2 30 Exception reason code
TAX_EXEMPTION_ID NUMBER 18 Tax exemption identifier
TAX_EXCEPTION_ID NUMBER 18 Tax exception identifier
TAX_RECOVERY_RATE NUMBER Tax recovery rate
TAX_REGIME_CODE VARCHAR2 30 Tax regime code
TAX VARCHAR2 30 Tax
TAX_JURISDICTION_CODE VARCHAR2 30 Tax jurisdiction code
TAX_STATUS_CODE VARCHAR2 30 Tax status code
TAX_CURRENCY_CODE VARCHAR2 15 Unique identification of a currency in which the tax transactions are to be reported.
EXCEPTION_RATE NUMBER Exception rate
EXEMPT_RATE_MODIFIER NUMBER Exempt rate modifier
TAX_DATE DATE Tax date
TAX_DETERMINE_DATE DATE Tax determination date
TAX_APPORTIONMENT_LINE_NUMBER NUMBER Tax apportionment line number
TAX_AMT_TAX_CURR NUMBER Tax amount in tax currency
TAXABLE_AMT_TAX_CURR NUMBER Taxable amount in tax currency
ORIG_TAXABLE_AMT NUMBER Original taxable amount in transaction currency prior to user override
ORIG_TAXABLE_AMT_TAX_CURR NUMBER Original taxable amount in tax currency prior to user override
ORIG_TAX_AMT NUMBER Original tax amount prior to user override
ORIG_TAX_AMT_TAX_CURR NUMBER Original tax amount in tax currency prior to user override
ORIG_REC_NREC_TAX_AMT NUMBER Original recoverable or non-recoverable tax amount in tax currency prior to user override
REC_TAX_AMT_TAX_CURR NUMBER Recoverable tax amount in tax currency
NREC_TAX_AMT_TAX_CURR NUMBER Non-recoverable tax amount in tax currency
TAX_LINE_USER_CATEGORY VARCHAR2 150 Tax line descriptive flexfield structure defining column
TAX_LINE_USER_ATTRIBUTE1 VARCHAR2 150 Tax line descriptive flexfield segment column
TAX_LINE_USER_ATTRIBUTE2 VARCHAR2 150 Tax line descriptive flexfield segment column
TAX_LINE_USER_ATTRIBUTE3 VARCHAR2 150 Tax line descriptive flexfield segment column
TAX_LINE_USER_ATTRIBUTE4 VARCHAR2 150 Tax line descriptive flexfield segment column
TAX_LINE_USER_ATTRIBUTE5 VARCHAR2 150 Tax line descriptive flexfield segment column
TAX_LINE_USER_ATTRIBUTE6 VARCHAR2 150 Tax line descriptive flexfield segment column
TAX_LINE_USER_ATTRIBUTE7 VARCHAR2 150 Tax line descriptive flexfield segment column
TAX_LINE_USER_ATTRIBUTE8 VARCHAR2 150 Tax line descriptive flexfield segment column
TAX_LINE_USER_ATTRIBUTE9 VARCHAR2 150 Tax line descriptive flexfield segment column
TAX_LINE_USER_ATTRIBUTE10 VARCHAR2 150 Tax line descriptive flexfield segment column
TAX_LINE_USER_ATTRIBUTE11 VARCHAR2 150 Tax line descriptive flexfield segment column
TAX_LINE_USER_ATTRIBUTE12 VARCHAR2 150 Tax line descriptive flexfield segment column
TAX_LINE_USER_ATTRIBUTE13 VARCHAR2 150 Tax line descriptive flexfield segment column
TAX_LINE_USER_ATTRIBUTE14 VARCHAR2 150 Tax line descriptive flexfield segment column
TAX_LINE_USER_ATTRIBUTE15 VARCHAR2 150 Tax line descriptive flexfield segment column
RECOVERY_TYPE_CODE VARCHAR2 30 Recovery type code
RECOVERY_RATE_CODE VARCHAR2 150 Recovery rate code
BILLING_TP_NAME VARCHAR2 360 Ship to customer name for Receivables transaction
BILLING_TP_NUMBER VARCHAR2 240 Number of the trading partner - customer or supplier - that is used to bill or pay this transaction
BILLING_TP_TAX_REG_NUM VARCHAR2 50 Billing trading partner tax registration number
BILLING_TP_TAXPAYER_ID VARCHAR2 50 Taxpayer identifier of the trading partner - customer or supplier - that is used to bill or pay this transaction
BILLING_TP_SITE_NAME_ALT VARCHAR2 320 Billing trading partner alternative site name
BILLING_TP_NAME_ALT VARCHAR2 360 Alternative or phonetic name of the trading partner
BILLING_TP_SIC_CODE VARCHAR2 30 Standard industry classification code of trading partner
BILLING_TP_CITY VARCHAR2 60 City field of the billing trading partner address
BILLING_TP_COUNTY VARCHAR2 60 County field of the billing trading partner address
BILLING_TP_STATE VARCHAR2 150 State field of the billing trading partner address
BILLING_TP_PROVINCE VARCHAR2 60 Province field of the billing trading partner address
BILLING_TP_ADDRESS1 VARCHAR2 240 Address line 1 of the billing trading partner address
BILLING_TP_ADDRESS2 VARCHAR2 240 Address line 2 of the billing trading partner address
BILLING_TP_ADDRESS3 VARCHAR2 240 Address line 3 of the billing trading partner address
BILLING_TP_ADDRESS_LINES_ALT VARCHAR2 560 Billing trading partner alternative address line
BILLING_TP_COUNTRY VARCHAR2 60 Country field of the billing trading partner address
BILLING_TP_POSTAL_CODE VARCHAR2 60 Postal code field of the billing trading partner address
SHIPPING_TP_NUMBER VARCHAR2 60 Ship to customer name for Receivables transaction
SHIPPING_TP_TAX_REG_NUM VARCHAR2 50 Tax Registration number of the ship to customer for Receivables transaction
SHIPPING_TP_TAXPAYER_ID VARCHAR2 50 Taxpayer identifier of the ship to customer for Receivables transaction
SHIPPING_TP_NAME VARCHAR2 360 Ship to customer site name for Accounts Receivable transaction.
SHIPPING_TP_NAME_ALT VARCHAR2 360 Alternative or phonetic name of the ship to customer for Receivables transaction
SHIPPING_TP_SIC_CODE VARCHAR2 30 Standard industry classification code of the ship to customer for Receivables transaction
SHIPPING_TP_CITY VARCHAR2 60 City field of the ship to customer address for Receivables transaction
SHIPPING_TP_COUNTY VARCHAR2 60 County field of the ship to customer address for Receivables transaction
SHIPPING_TP_STATE VARCHAR2 60 State field of the ship to customer address for Receivables transaction
SHIPPING_TP_PROVINCE VARCHAR2 60 Province field of the ship to customer address for Receivables transaction
SHIPPING_TP_ADDRESS1 VARCHAR2 240 Address line 1 of the ship to customer address for Receivables transaction
SHIPPING_TP_ADDRESS2 VARCHAR2 240 Address line 2 of the ship to customer address for Receivables transaction
SHIPPING_TP_ADDRESS3 VARCHAR2 240 Address line 3 of the ship to customer address for Receivables transaction
SHIPPING_TP_ADDRESS_LINES_ALT VARCHAR2 560 Alternative address line of the ship to customer address for Receivables transaction
SHIPPING_TP_COUNTRY VARCHAR2 60 Country field of the ship to customer address for Receivables transaction
SHIPPING_TP_POSTAL_CODE VARCHAR2 60 Postal code field of the ship to customer address for Receivables transaction
BILLING_TP_PARTY_NUMBER VARCHAR2 30 Party number of the trading partner - customer or supplier - that is used to bill or pay this transaction
BANK_ACCOUNT_NAME VARCHAR2 80 Bank account name
BANK_ACCOUNT_NUM VARCHAR2 30 Bank account number
BILLING_TRADING_PARTNER_ID NUMBER 18 Party identifier of the trading partner - customer or supplier - that is used to bill or pay this transaction
BILLING_TP_SITE_ID NUMBER 18 Party site identifier of the trading partner - customer or supplier - that is used to bill or pay this transaction
BILLING_TP_ADDRESS_ID NUMBER 18 Address identifier of the trading partner - customer or supplier - that is used to bill or pay this transaction
BILLING_TP_TAX_REPORTING_FLAG VARCHAR2 1 Y or N indicates whether taxes are to be reported for the trading partner - customer or supplier - that is used to bill or pay this transaction
SHIPPING_TRADING_PARTNER_ID NUMBER 18 Party identifier of the ship to customer for Receivables transaction
SHIPPING_TP_SITE_ID NUMBER 18 Party site identifier of the ship to customer for Receivables transaction
SHIPPING_TP_ADDRESS_ID NUMBER 18 Address identifier of the ship to customer for Receivables transaction
BANKING_TP_NAME VARCHAR2 360 Banking trading partner name
BANKING_TP_TAXPAYER_ID VARCHAR2 50 Banking trading partner taxpayer identifier
BANK_ACCOUNT_ID NUMBER 18 Bank account identifier
BANK_BRANCH_ID NUMBER 18 Bank branch identifier
BILLING_TP_SITE_NAME VARCHAR2 240 Third-party site name for billing.
BILLING_TP_SITE_TAX_REG_NUM VARCHAR2 50 Tax registration number for the trading partner - customer or supplier - that is used to bill or pay this transaction
SHIPPING_TP_SITE_NAME VARCHAR2 240 Third-party site name for shipping.
SHIPPING_TP_SITE_TAX_REG_NUM VARCHAR2 50 Tax registration number for the ship to customer of Receivables transaction
OFFICE_SITE_FLAG VARCHAR2 1 Office site flag
SHIP_TO_LOCATION_ID NUMBER 18 Ship to location identifier
SHIP_FROM_LOCATION_ID NUMBER 18 Ship from location identifier
BILL_TO_LOCATION_ID NUMBER 18 Bill to location identifier
BILL_FROM_LOCATION_ID NUMBER 18 Bill from location identifier
SHIP_TO_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for the ship to party
SHIP_FROM_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for the ship from party
BILL_TO_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for the bill to party
BILL_FROM_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for the bill from party
OWN_HQ_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for the own HQ party
SHIP_TO_SITE_TAX_PROF_ID NUMBER Party tax site profile identifier for ship to party site
BILL_TO_SITE_TAX_PROF_ID NUMBER Party tax profile identifier for bill to party site of the transaction line
SHIP_FROM_SITE_TAX_PROF_ID NUMBER Party tax site profile identifier for ship from party site
BILL_FROM_SITE_TAX_PROF_ID NUMBER Party tax site profile identifier for bill from party site
OWN_HQ_PARTY_SITE_PROF_ID NUMBER Party tax site profile identifier for own HQ party site
SHIP_TO_PARTY_ID NUMBER 18 Ship to party identifier
SHIP_FROM_PARTY_ID NUMBER 18 Ship from party identifier
BILL_TO_PARTY_ID NUMBER 18 Bill to party identifier
BILL_FROM_PARTY_ID NUMBER 18 Bill from party identifier
OWN_HQ_PARTY_ID NUMBER 18 Own HQ party identifier
SHIP_TO_PARTY_SITE_ID NUMBER 18 Ship to party site identifier
SHIP_FROM_PARTY_SITE_ID NUMBER 18 Ship from party site identifier
BILL_TO_PARTY_SITE_ID NUMBER 18 Bill to party site identifier
BILL_FROM_PARTY_SITE_ID NUMBER 18 Bill from party site identifier
REGISTRATION_STATUS_CODE VARCHAR2 30 Registration status code
REG_PARTY_TAX_PROF_ID NUMBER 18 Party tax profile identifier for registration party
REG_PARTY_TAX_SITE_PROF_ID NUMBER 18 Party tax profile identifier for registration party site
POS_TAX_PARTY_PROF_ID NUMBER 18 Party tax profile identifier for place of supply party
POS_TAX_PARTY_SITE_PROF_ID NUMBER 18 Party tax profile identifier for place of supply party site
POA_LOCATION_ID NUMBER Point of acceptance location identifier
PLACE_OF_SUPPLY_TYPE_CODE VARCHAR2 30 Place of supply type code
DEF_PLACE_OF_SUPPLY_TYPE_CODE VARCHAR2 30 Default place of supply type code
POO_LOCATION_ID NUMBER Point of origin location identifier
LEGAL_ENTITY_TAX_REG_NUMBER VARCHAR2 30 Legal entity tax registration number
HQ_ESTB_REG_NUMBER VARCHAR2 30 HQ establishment registration number
TAX_LINE_REGISTRATION_NUMBER VARCHAR2 50 Tax registration number on the tax line
REGISTRATION_PARTY_TYPE VARCHAR2 30 Party type for which the registration number on the tax line was determined
BALANCING_SEGMENT_VALUE VARCHAR2 25 Balancing segment value
BALANCING_SEGMENT_DESC VARCHAR2 240 Balancing segment description
CANCELLED_DATE DATE Date canceled
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.
CANCEL_FLAG VARCHAR2 1 Yes or No indicates if the tax line is canceled.
SELF_ASSESSED_FLAG VARCHAR2 1 Y or N indicates if this tax line is self-assessed
REPORTING_ONLY_FLAG VARCHAR2 1 Y or N indicates if this tax is to be reported
TAX_ONLY_FLAG VARCHAR2 1 Y or N indicates if this is a tax only line
OFFSET_FLAG VARCHAR2 1 Y or N indicates if this is a offset tax line
POSTED_FLAG VARCHAR2 1 Y or N indicates if the tax distributions for this tax line are posted
MRC_TAX_LINE_FLAG VARCHAR2 1 Yes or No indicates if the tax line is for one of the multiple reporting currencies.
SMALL_BUSINESS_FLAG VARCHAR2 1 Small business flag
RECONCILIATION_FLAG VARCHAR2 1 Reconciliation flag
TAX_RECOVERABLE_FLAG VARCHAR2 1 Y or N indicates whether tax can be recovered
REVERSE_FLAG VARCHAR2 1 Y or N indicates if the tax distribution is reversed by another tax distribution
AR_CASH_RECEIPT_REVERSE_STATUS VARCHAR2 30 Column to identify whether the status of this payment entry is reverse payment or not
AR_CASH_RECEIPT_REVERSE_DATE DATE Date on which receipt is reversed
TAXABLE_ITEM_SOURCE_ID NUMBER Identifier of the source table for taxable item
AMOUNT_APPLIED NUMBER For same currency applications, the total amount of the application in the currency of the receipt and transaction. For cross currency applications, the total amount of the application in the currency of the transaction.
BR_REF_CUSTOMER_TRX_ID NUMBER Transaction identifier of the transaction exchanged for a bills receivable
TAX_AMT_INCLUDED_FLAG VARCHAR2 1 Y or N indicates if this an inclusive tax line
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PROGRAM_APP_NAME VARCHAR2 50 Application identifier of last concurrent program to update this record
PROGRAM_NAME VARCHAR2 30 Program identifier of last concurrent program to update this record
PROGRAM_LOGIN_ID NUMBER Login user identifier of last concurrent program to update this record
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
GDF_PARTY_SITES_BILL_ATT8 VARCHAR2 150 Reserved for country specific localizations
GDF_RA_CUST_BILL_ATT10 VARCHAR2 150 Reserved for country specific localizations
GDF_RA_CUST_BILL_ATT12 VARCHAR2 150 Reserved for country specific localizations
GDF_RA_ADDRESSES_BILL_ATT8 VARCHAR2 150 Reserved for country specific localizations
GDF_RA_ADDRESSES_BILL_ATT9 VARCHAR2 150 Reserved for country specific localizations
GDF_PARTY_SITES_SHIP_ATT8 VARCHAR2 150 Reserved for country specific localizations
GDF_RA_CUST_SHIP_ATT10 VARCHAR2 150 Reserved for country specific localizations
GDF_RA_CUST_SHIP_ATT12 VARCHAR2 150 Reserved for country specific localizations
GDF_RA_ADDRESSES_SHIP_ATT8 VARCHAR2 150 Reserved for country specific localizations
GDF_RA_ADDRESSES_SHIP_ATT9 VARCHAR2 150 Reserved for country specific localizations
GDF_PO_VENDOR_SITE_ATT17 VARCHAR2 150 Reserved for country specific localizations
ACCTD_AMOUNT_CR NUMBER Journal entry accounted credit amount
ACCTD_AMOUNT_DR NUMBER Journal entry accounted debit amount
REC_APPLICATION_STATUS VARCHAR2 30 Lookup type for the status of the application
SUB_LEDGER_INVOICE_IDENTIFIER VARCHAR2 20 Subledger invoice identifier
ACCOUNT_CLASS VARCHAR2 20 Account class
LATEST_REC_FLAG VARCHAR2 1 Y indicates latest record with REC accounting class - N indicates not the latest record with REC account class - NULL indicates not a record with REC account class
ENTITY_CODE VARCHAR2 30 Entity code
POSTED_DATE DATE Date posted
ACTG_SOURCE_ID NUMBER Revenue distribution identifier
UNIT_PRICE NUMBER Unit price
GL_DATE DATE General ledger date
TAX_POINT_BASIS VARCHAR2 30 The event on which the tax is levied, accounted in the books and reported to the tax authorities.
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.
LEGAL_MESSAGE_APPL_2 NUMBER A mandatory, standardized message provided for tax applicability on a fiscal document to conform to legal requirements. It can be associated for example to a tax status, tax, tax regime, etc.
LEGAL_MESSAGE_STATUS NUMBER A mandatory, standardized message provided for status determination on a fiscal document to conform to legal requirements. It can be associated for example to a tax status, tax, tax regime, etc.
LEGAL_MESSAGE_RATE NUMBER A mandatory, standardized message provided for rate determination on a fiscal document to conform to legal requirements. It can be associated for example to a tax status, tax, tax regime, etc.
LEGAL_MESSAGE_BASIS NUMBER A mandatory, standardized message provided for taxable basis on a fiscal document to conform to legal requirements. It can be associated for example to a tax status, tax, tax regime, etc.
LEGAL_MESSAGE_CALC NUMBER A mandatory, standardized message provided for tax calculation on a fiscal document to conform to legal requirements. It can be associated for example to a tax status, tax, tax regime, etc.
LEGAL_MESSAGE_THRESHOLD NUMBER A mandatory, standardized message provided for thresholds defined in the tax setup on a fiscal document to conform to legal requirements. It can be associated for example to a tax status, tax, tax regime, etc.
LEGAL_MESSAGE_POS NUMBER A mandatory, standardized message provided for tax applicability on a fiscal document to conform to legal requirements. It can be associated for example to a tax status, tax, tax regime, etc.
LEGAL_MESSAGE_TRN NUMBER A mandatory, standardized message provided for tax registration number on a fiscal document to conform to legal requirements. It can be associated for example to a tax status, tax, tax regime, etc.
LEGAL_MESSAGE_EXCPT NUMBER A mandatory, standardized message provided for exceptions defined in tax setup on a fiscal document to conform to legal requirements. It can be associated for example to a tax status, tax, tax regime, etc.
LEGAL_MESSAGE_EXMPT NUMBER A mandatory, standardized message provided for tax applicability on a fiscal document to conform to legal requirements. It can be associated for example to a tax status, tax, tax regime, etc.
REPORTABLE_FLAG VARCHAR2 1 The flag which determines whether the tax extract program should pick the tax transaction to reporting or not.
APPLIED_TO_TRX_LEVEL_TYPE VARCHAR2 30 Level at which the applied to document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
LEGAL_REPORTING_STATUS VARCHAR2 15 The status for legal reporting to indicates whether the line has been finally reported.
APPLIED_TO_TAX_DIST_ID NUMBER 18 Tax distribution identifier applied to document.
APPL_TO_TRX_CURR_UNIT_NR_AMT NUMBER Amount derived by dividing non-recoverable tax amount by quantity and price of the applied to document.
APPL_TO_PER_UNIT_NREC_TAX_AMT NUMBER Non recoverable tax amount by unit for the applied to document.
APPLIED_TO_UNIT_PRICE NUMBER Non recoverable tax amount by unit price for the applied to document.
APPLIED_TO_TRX_LINE_DIST_QTY NUMBER Tax applied to document transaction line distribution quantity.
APPLIED_TO_DIST_ID NUMBER 18 Indicates tax has been applied to distribution line.
MATCH_TYPE VARCHAR2 25 Indicates if the Payables invoice is matched to a purchasing document or to a receipt of material.
FOS_TRANSACTION_ID NUMBER 18 The unique column to identify the transactions in SFO. It is FLOW_INSTANCE_ID in SFO table FOS_FLOW_INSTANCES.
RECEIPT_SOURCE_CODE VARCHAR2 25 Values are "internal" and "external". Describes where the source of fulfillment (e.g. from an internal warehouse or drop shipped from an external source).
DROPSHIP_TYPE_ID NUMBER 18 Identifier to describes where the source of fulfillment (e.g. from an internal warehouse or drop shipped from an external source).
REQUISITION_TYPE VARCHAR2 25 Indicator to determine if the requisition is type of internal or external.
PURCHASING_CATEGORY_ID NUMBER 18 A code associated with the categorization of goods purchased.
DROP_SHIP_FLAG VARCHAR2 1 Indicator to determine shipment has a backing sales order line.
CONSIGNED_FLAG VARCHAR2 1 Attribute indicating the item is residing at your location, but owned by the supplier. It is the consigned_flag in po_line_location_all table.
DESTINATION_TYPE_CODE VARCHAR2 25 The destination type on the purchase order. Possible values are receiving, inventory or expense.
CONSIGN_ITM_UPON_RECPT_FLAG VARCHAR2 1 Attribute indicating the item is residing at your location, but owned by the supplier at the time the item is received.
PORT_OF_DISCHARGE VARCHAR2 150 Indicates location a shipment is delivered. It is the port_of_discharge from wsh_new_deliveries table.
EXPENDITURE_TYPE VARCHAR2 30 A classification of cost that you assign to each expenditure item. Expenditure types are grouped into cost groups (expenditure categories) and revenue groups (revenue categories).
PORT_OF_LOADING VARCHAR2 150 Indicates location a shipment originates. It is the port_of_loading from wsh_new_deliveries table.
DELIVERY_TYPE VARCHAR2 30 The manner in which a shipment will be delievered for example., standard, consolidated. It is the delivery_type from wsh_new_deliveries table.
DOCUMENT_TYPE VARCHAR2 30 Description of the kind of document being recorded. It is the document_type from wsh_transaction_history table.
SHIPMENT_TYPE VARCHAR2 30 Indicates whether the purchase order shipment record is a schedule or a price break.
HDR_GL_DATE DATE The date, referenced from Oracle General Ledger, used to determine the accounting period for transactions at the header level.
GL_POSTED_DATE DATE The date a journal entry is posted to the general ledger.
POSTED_TO_SLA_FLAG VARCHAR2 1 Indicates if the distribution is posted to Subledger Accounting.
FINAL_DISCHARGE_LOCATION_ID NUMBER 18 The final discharge location identifier
FINAL_TRANSACTION_NODE_FLAG VARCHAR2 1 Costing/Receiving accounting should pass 'Y' to this field in case the shipment or receiving transaction is not backed by Invoice.
COUNTRY_OF_ORIGIN_CODE VARCHAR2 2 The country from which goods are exported after being imported from another country where they were produced.
FIRST_PTY_REG_ID NUMBER 18 A unique internal sequence number assigned to a first party, by a tax authority, when it is registered and by which the first party registration will be identified.
TAX_RATE_SCHED_ID NUMBER 18 Identifies the rate schedule associated with the tax line.
REPORTING_CURRENCY_CODE VARCHAR2 15 Used for financial reporting to investors or other stakeholders in a currency other than the primary ledger currency. The accounting method, calendar, and chart of account are the same as the ledger they represent.
PRODUCT_TYPE VARCHAR2 240 Any goods or services produced for sale, barter, or internal use.
ASSET_FLAG VARCHAR2 1 Y indicates that the item should be treated as an asset.
INTERNAL_ORG_LOCATION_ID NUMBER 18 Sequential number identifier generated to indicate the physical location of the internal organization.
MERCHANT_PARTY_TAX_PROF_ID NUMBER 18 Party tax profile identifier for merchant party of the transaction line
POA_PARTY_TAX_PROF_ID NUMBER 18 Party tax profile identifier for point of acceptance party of the transaction line
POO_PARTY_TAX_PROF_ID NUMBER 18 Party tax profile identifier for merchant party of the transaction line.
POA_SITE_TAX_PROF_ID NUMBER 18 Party tax profile identifier for point of acceptance party of the transaction line
POO_SITE_TAX_PROF_ID NUMBER 18 Party tax profile identifier for point of origin party of the transaction line
PAYING_SITE_TAX_PROF_ID NUMBER 18 Party tax profile identifier for point of acceptance party site of the transaction line
TAX_RATE_EFFECTIVE_FROM DATE Date at the beginning of the date range during which a tax rate is available for transacting.
TAX_RATE_EFFECTIVE_TO DATE Date at the end of the date range during which a tax rate is available for transacting.
THIRD_PTY_REG_ID NUMBER 18 An internal unique seqence identifier for a party belonging to the selected legal reporting unit located on a transaction.
THIRD_PTY_REG_NUMBER VARCHAR2 50 A unique sequence of letters and/or numbers assigned to a third party or third party site, bya tax authority, when it is registered and by which the party or party site registration will be identified.
PAYMENT_MATURITY_DATE DATE An option that limits which transactions are included in a payment batch.
PAYMENT_CHECK_ID NUMBER 18 Internally generated number used to identify payment in Payables.
PAYMENT_CLEARED_DATE DATE Date on which a payment is deducted from the issueing bank account.
PAYMENT_TYPE_FLAG VARCHAR2 25 The mode of payment for the invoice.
IBAN_NUMBER VARCHAR2 40 An alphanumeric sequence that conforms to the ISO standard for uniquely identifying a bank account number internationally. The standard IBAN carries all the routing information needed to get a payment from one bank to another, wherever it may be.
TRX_AMOUNT_REMAINING NUMBER Indicates the tax amount remaining to be paid on an invoice.
TAX_AMOUNT_REMAINING NUMBER Indicates the tax amount remaining to be paid on an invoice.
PRODUCT_CODE VARCHAR2 300 Inventory item code defined on an inventory item.
ITEM_UOM VARCHAR2 50 A predetermined amount or quantity or quality, such as of length, time, heat, value that is adopted as a standard of measurement assigned to an inventory item.
EFT_SWIFT_CODE VARCHAR2 30 The identifier code used by SWIFT to identify a bank or bank branch. The BIC is a universal method of identifying financial institutions to facilitate the automated processing of telecommunication messages in banking and related financial environments.
PAYMENT_METHOD_CODE VARCHAR2 30 The name assigned to a payment method or receipt method which indicates how something is paid or received.
COUNTRY_OF_PAYMENT VARCHAR2 60 Country from where payment is issued for a transaction.
REC_NREC_TAX_DIST_ID NUMBER 18 Foreign key identifier to ZX_REC_NREC_DIST table.
TAX_DIST_ID NUMBER 18 Foreign key identifier to ZX_TRX_TAX_DISTRIBUTIONS table.
ADJUSTED_DOC_LINE_ID NUMBER Transaction line identifier for the adjusted document.
ADJUSTED_DOC_TAX_LINE_ID NUMBER Adjusted document tax line identifier.
APPLIED_TO_LINE_ID NUMBER Transaction line identifier for the applied to document.
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.
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.
BASIS_RESULT_ID NUMBER 18 Identifies the process result obtained from the taxable basis determination process for this tax line.
COMPOUNDING_TAX_FLAG VARCHAR2 1 Indicates whether there is any other tax line that is compounded on top of this tax line. Valid values are Y and N.
CONTENT_OWNER_ID NUMBER 18 Party tax profile identifier for the first-party organization of the transaction.
DEBIT_ACCOUNT_CCID NUMBER 18 Debit account identifier for the transaction line.
DELETE_FLAG VARCHAR2 1 Indicates whether this tax line is marked for deletion by the user. Valid values are Y and N.
DIRECT_RATE_RESULT_ID NUMBER 18 Identifies the process result obtained from line determination process for this tax line.
EVAL_EXCPT_RESULT_ID NUMBER 18 Identifies the process result obtained from exception evaluation process for this tax line.
EVAL_EXMPT_RESULT_ID NUMBER 18 Identifies the process result obtained from exemption evaluation process for this tax line.
EVENT_TYPE_CODE VARCHAR2 30 Unique abbreviated name assigned to an event type and used for reporting or in reference to an option.
HQ_ESTB_PARTY_TAX_PROF_ID NUMBER Party tax profile identifier for the first party HQ establishment.
INCLUSIVE_TAX_OVERRIDE_FLAG VARCHAR2 1 Indicates whether any system determined inclusive tax line is updated or overridden by the user for this transaction line. Valid values are Y and N.
LAST_MANUAL_ENTRY VARCHAR2 30 Indicates which column is last overridden by the user. Possible values are TAX_STATUS, TAX_RATE, TAX_RATE_CODE, and TAX_AMOUNT.
LEGAL_ENTITY_ID NUMBER Legal entity identifier for the transaction.
LINE_AMT_INCLUDES_TAX_FLAG VARCHAR2 1 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.
LINE_LEVEL_ACTION VARCHAR2 30 Action at the transaction line level.
LINK_TO_TRX_LINE_ID NUMBER 18 Link from the reference item line to the charge line.
MANUALLY_ENTERED_FLAG VARCHAR2 1 Indicates whether this tax line is manually entered by the user. Valid values are Y and N.
OVERRIDDEN_FLAG VARCHAR2 1 Indicates whether user has overridden this tax line. Valid values are Y and N.
PLACE_OF_SUPPLY_RESULT_ID NUMBER 18 Identifies the process result obtained from place of supply determination process for this tax line.
PURGE_FLAG VARCHAR2 1 Indicates whether this tax line is marked for purge. Valid values are Y and N.
RATE_RESULT_ID NUMBER 18 Identifies the process result obtained from rate determination process for this tax line.
REPORTING_BATCH_ID NUMBER 18 Selection process batch identifier.
REVERSED_TAX_LINE_ID NUMBER Identifier of the tax line that is reversed by this tax line.
REVERSED_TRX_ID NUMBER Reversed transaction identifier.
REVERSED_TRX_LINE_ID NUMBER Reversed transaction line identifier.
STATUS_RESULT_ID NUMBER 18 Identifies the process result obtained from status determination process for this tax line.
TAX_APPLICABILITY_RESULT_ID NUMBER 18 Identifies the process result obtained from tax applicability process for this tax line.
TAX_DATE_RULE_ID NUMBER 18 Identifies tax rule used to determine tax date.
TAX_ID NUMBER 18 Tax identifier for the classification of a charge imposed by a government through a fiscal or tax authority.
TAX_JURISDICTION_ID NUMBER 18 Tax jurisdiction identifier applicable for the transaction line.
TAX_REGIME_ID NUMBER 18 Tax regime identifier applicable for the transaction line.
TAX_REGISTRATION_ID NUMBER 18 Tax registration identifier for a party determined in the transaction based on tax rules.
TAX_REG_NUM_DET_RESULT_ID NUMBER 18 Identifies the process result obtained from tax registration number determination process for this tax line.
TAX_REPORTING_FLAG VARCHAR2 1 Tax reporting flag for lease management.
TAX_EVENT_TYPE_CODE VARCHAR2 30 Tax event type code of the transaction.
EVENT_ID NUMBER 18 Identifier of the categorization of accounting events that is unique within an application and event class.
AE_HEADER_ID NUMBER 18 Identifier of accounting entry.
AE_LINE_NUM NUMBER 18 Number that is associated with each subledger journal entry line.
REVERSED_TAX_DIST_ID NUMBER Identifier of tax distribution that has been reversed.
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield.
IBY_PAYMENT_PROFILE_ID NUMBER 18 Identifier of the payment profile.
IBY_PROCESSING_TYPE_CODE VARCHAR2 30 Specifies the type of processing required. Values from the IBY_PROCESSING_TYPES lookup include ELECTRONIC and PRINTED.
AR_RECEIPT_METHOD_ID NUMBER 18 Identifier of the receipt method.
AR_PAYMENT_CHANNEL_CODE VARCHAR2 30 Identifier of the payment channel code.
PAYMENT_TRX_ID NUMBER 18 Payment identifier when payment is made at transaction level.
PAYMENT_TRX_LINE_ID NUMBER 18 Payment identifier when payment is made at transaction line level.
PAYMENT_TRX_DIST_ID NUMBER 18 Payment identifier when payment is made at transaction distribution level.
PAYMENT_TRX_TAX_DIST_ID NUMBER 18 Payment identifier when payment is made at tax distribution level.
TRX_TAX_DIST_ID NUMBER 18 Distribution identifier in transaction table for tax line or tax distribution.
LINES_DET_FACTOR_ID NUMBER 18 Line identification for tax determining factor.
LINE_AMT_FUNC_CURR NUMBER Tax line amount in ledger currency.
REP_TRX_TAX_DIST_ID NUMBER 18 Line identifier from identification table.
TRX_LINE_CCID NUMBER 18 Transaction line account code combination identifier.
TAX_LINE_CCID NUMBER 18 Tax line account code combination identifier.

Indexes

Index Uniqueness Tablespace Columns
ZX_REP_TRX_DETAIL_T_N1 Non Unique Default REQUEST_ID, TRX_ID, TRX_LINE_ID
ZX_REP_TRX_DETAIL_T_N2 Non Unique Default REQUEST_ID, APPLICATION_ID, ENTITY_CODE, TAX_POINT_BASIS
ZX_REP_TRX_DETAIL_T_U1 Unique Default DETAIL_TAX_LINE_ID