DBA Data[Home] [Help] [Dependency Information]

TABLE: ZX.ZX_REP_TRX_DETAIL_T

Object Details
Object Name: ZX_REP_TRX_DETAIL_T
Object Type: TABLE
Owner: ZX
FND Design Data: TableZX.ZX_REP_TRX_DETAIL_T
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ZX_REP_TRX_DETAIL_T_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDETAIL_TAX_LINE_ID
ZX_REP_TRX_DETAIL_T_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_ID
ColumnTRX_LINE_ID
Columns
Name Datatype Length Mandatory Comments
DETAIL_TAX_LINE_ID NUMBER (15) Yes Detail tax line identifier
REP_CONTEXT_ID NUMBER (15)
Report context identifier
EXTRACT_LINE_ID NUMBER (15)
Unique identifier
EXTRACT_REPORT_LINE_NUMBER NUMBER

Sequential line number generated within the tax ledger for this tax line
LEDGER_ID NUMBER (15)
Ledger defining column
LEDGER_NAME VARCHAR2 (30)
Ledger name
CHART_OF_ACCOUNTS_ID NUMBER (15)
Accounting key flexfield structure defining column
EXTRACT_SOURCE_LEDGER VARCHAR2 (30)
Column to store the source ledger for this line. Possible values are AP, AR and GL
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

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

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_ID NUMBER (15)
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

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 (15)
Receipt class identifier
TRX_BATCH_SOURCE_ID NUMBER (15)
Batch source identifier
TRX_BATCH_SOURCE_DATE DATE

Transaction batch date
RELATED_DOC_APPLICATION_ID NUMBER

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

Primary itransaction dentifier 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

Applied from document application identifier
APPLIED_FROM_LINE_ID NUMBER

Transaction line identifier for the applied from document
APPLIED_FROM_ENTITY_CODE VARCHAR2 (30)
Applied from document entity code
APPLIED_FROM_TRX_ID NUMBER

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

Adjusted document application identifier
ADJUSTED_DOC_ENTITY_CODE VARCHAR2 (30)
Adjusted document entity code
ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
Adjusted document event class code
ADJUSTED_DOC_TRX_ID NUMBER

Adjusted document transaction identifier
ADJUSTED_DOC_NUMBER VARCHAR2 (150)
Transaction number of the adjusted document
ADJUSTED_DOC_DATE DATE

Adjusted document date
APPLIED_TO_APPLICATION_ID NUMBER

Applied to document application identifier
APPLIED_TO_TRX_ID NUMBER

Applied to document transaction identifier
APPLIED_TO_TRX_LINE_ID NUMBER

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

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

Reference document transaction identifier
REF_DOC_LINE_ID NUMBER

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 the Payables expense report
MERCHANT_PARTY_NAME VARCHAR2 (150)
Merchant party name recorded for the Payables expense report
MERCHANT_PARTY_REFERENCE VARCHAR2 (250)
Merchant party reference recorded for the Payables expense report
MERCHANT_PARTY_TAX_REG_NUMBER VARCHAR2 (150)
Merchant party tax registration number recorded for the Payables expense report
MERCHANT_PARTY_TAXPAYER_ID VARCHAR2 (150)
Merchant party taxpayer ID recorded for the Payables expense report
COUNTRY_OF_SUPPLY VARCHAR2 (150)
Country of supply
START_EXPENSE_DATE DATE

Start expense date of a Payables 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 (15)
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 (50)
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 (15)
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 (15)
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 (50)
Offset tax rate code
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 (15)
Tax exemption identifier
TAX_EXCEPTION_ID NUMBER (15)
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)
Tax currency code
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 (320)
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 namefor Receivables transaction
SHIPPING_TP_NAME_ALT VARCHAR2 (320)
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 (15)
Party identifier of the trading partner - customer or supplier - that is used to bill or pay this transaction
BILLING_TP_SITE_ID NUMBER (15)
Party site identifier of the trading partner - customer or supplier - that is used to bill or pay this transaction
BILLING_TP_ADDRESS_ID NUMBER (15)
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 (15)
Party identifier of the ship to customer for Receivables transaction
SHIPPING_TP_SITE_ID NUMBER (15)
Party site identifier of the ship to customer for Receivables transaction
SHIPPING_TP_ADDRESS_ID NUMBER (15)
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 (15)
Bank account identifier
BANK_BRANCH_ID NUMBER (15)
Bank branch identifier
BILLING_TP_SITE_NAME VARCHAR2 (40)
Party site name for the trading partner - customer or supplier - that is used to bill or pay this transaction
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 (40)
Party site name for the ship to customer of Receivables transaction
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

Ship to location identifier
SHIP_FROM_LOCATION_ID NUMBER

Ship from location identifier
BILL_TO_LOCATION_ID NUMBER

Bill to location identifier
BILL_FROM_LOCATION_ID NUMBER

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 (15)
Ship to party identifier
SHIP_FROM_PARTY_ID NUMBER (15)
Ship from party identifier
BILL_TO_PARTY_ID NUMBER (15)
Bill to party identifier
BILL_FROM_PARTY_ID NUMBER (15)
Bill from party identifier
OWN_HQ_PARTY_ID NUMBER (15)
Own HQ party identifier
SHIP_TO_PARTY_SITE_ID NUMBER (15)
Ship to party site identifier
SHIP_FROM_PARTY_SITE_ID NUMBER (15)
Ship from party site identifier
BILL_TO_PARTY_SITE_ID NUMBER (15)
Bill to party site identifier
BILL_FROM_PARTY_SITE_ID NUMBER (15)
Bill from party site identifier
REGISTRATION_STATUS_CODE VARCHAR2 (30)
Registration status code
REG_PARTY_TAX_PROF_ID NUMBER (15)
Party tax profile identifier for registration party
REG_PARTY_TAX_SITE_PROF_ID NUMBER (15)
Party tax profile identifier for registration party site
POS_TAX_PARTY_PROF_ID NUMBER (15)
Party tax profile identifier for place of supply party
POS_TAX_PARTY_SITE_PROF_ID NUMBER (15)
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 NUMBER

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 descripiton
CANCELLED_DATE DATE

Cancelled date
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)
Y or N indicates if this tax line is cancelled
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)
Y or N indicates if this tax line is for one of the multiple reporting currencies - MRC
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 NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER

Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER

Application identifier of last concurrent program to update this record
PROGRAM_ID NUMBER

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
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DETAIL_TAX_LINE_ID
,      REP_CONTEXT_ID
,      EXTRACT_LINE_ID
,      EXTRACT_REPORT_LINE_NUMBER
,      LEDGER_ID
,      LEDGER_NAME
,      CHART_OF_ACCOUNTS_ID
,      EXTRACT_SOURCE_LEDGER
,      EVENT_CLASS_CODE
,      EVENT_CLASS_MAPPING_ID
,      DOC_EVENT_STATUS
,      APPLICATION_DOC_STATUS
,      ESTABLISHMENT_ID
,      APPLICATION_ID
,      INTERNAL_ORGANIZATION_ID
,      TRX_ID
,      TRX_NUMBER
,      TRX_DESCRIPTION
,      TRX_CURRENCY_CODE
,      TRX_LINE_ID
,      TRX_LINE_NUMBER
,      TRX_LINE_DESCRIPTION
,      TRX_LINE_TYPE
,      TRX_DATE
,      DEPOSIT_DATE
,      TRX_DUE_DATE
,      TRX_SHIPPING_DATE
,      TRX_COMMUNICATED_DATE
,      TRX_TYPE_DESCRIPTION
,      TRX_TYPE_ID
,      TRX_LEVEL_TYPE
,      TRX_BATCH_SOURCE_NAME
,      TRX_SIC_CODE
,      FOB_POINT
,      TRX_WAYBILL_NUMBER
,      TRX_LINE_CLASS
,      PRODUCT_ID
,      PRODUCT_DESCRIPTION
,      FUNCTIONAL_CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      PRECISION
,      MINIMUM_ACCOUNTABLE_UNIT
,      GDF_FND_CURRENCIES_ATT1
,      CURRENCY_CODE_DESC
,      TERRITORY_SHORT_NAME
,      DOC_SEQ_ID
,      DOC_SEQ_NAME
,      DOC_SEQ_VALUE
,      TRX_LINE_QUANTITY
,      TRX_LINE_AMT
,      UOM_CODE
,      RECEIPT_CLASS_ID
,      TRX_BATCH_SOURCE_ID
,      TRX_BATCH_SOURCE_DATE
,      RELATED_DOC_APPLICATION_ID
,      RELATED_DOC_ENTITY_CODE
,      RELATED_DOC_EVENT_CLASS_CODE
,      RELATED_DOC_TRX_ID
,      RELATED_DOC_NUMBER
,      RELATED_DOC_DATE
,      APPLIED_FROM_APPLICATION_ID
,      APPLIED_FROM_LINE_ID
,      APPLIED_FROM_ENTITY_CODE
,      APPLIED_FROM_TRX_ID
,      APPLIED_FROM_EVENT_CLASS_CODE
,      APPLIED_FROM_TRX_NUMBER
,      TRX_APPLIED_FROM_CLASS_MNG
,      ADJUSTED_DOC_APPLICATION_ID
,      ADJUSTED_DOC_ENTITY_CODE
,      ADJUSTED_DOC_EVENT_CLASS_CODE
,      ADJUSTED_DOC_TRX_ID
,      ADJUSTED_DOC_NUMBER
,      ADJUSTED_DOC_DATE
,      APPLIED_TO_APPLICATION_ID
,      APPLIED_TO_TRX_ID
,      APPLIED_TO_TRX_LINE_ID
,      APPLIED_TO_ENTITY_CODE
,      APPLIED_TO_EVENT_CLASS_CODE
,      APPLIED_TO_TRX_NUMBER
,      TRX_APPLIED_TO_CLASS_MNG
,      REF_DOC_APPLICATION_ID
,      REF_DOC_ENTITY_CODE
,      REF_DOC_EVENT_CLASS_CODE
,      REF_DOC_TRX_ID
,      REF_DOC_LINE_ID
,      REF_DOC_LINE_QUANTITY
,      MERCHANT_PARTY_DOCUMENT_NUMBER
,      MERCHANT_PARTY_NAME
,      MERCHANT_PARTY_REFERENCE
,      MERCHANT_PARTY_TAX_REG_NUMBER
,      MERCHANT_PARTY_TAXPAYER_ID
,      COUNTRY_OF_SUPPLY
,      START_EXPENSE_DATE
,      DEFAULT_TAXATION_COUNTRY
,      TRX_CLASS_MNG
,      TRX_TYPE_MNG
,      TAX_RATE_CODE_REG_TYPE_MNG
,      TAX_EXEMPT_REASON_MNG
,      TAX_EXCEPTION_REASON_MNG
,      TRX_QUANTITY_UOM_MNG
,      TAX_RATE_CODE_VAT_TRX_TYPE_MNG
,      DOCUMENT_SUB_TYPE
,      SUPPLIER_TAX_INVOICE_NUMBER
,      SUPPLIER_TAX_INVOICE_DATE
,      SUPPLIER_EXCHANGE_RATE
,      TAX_INVOICE_DATE
,      TAX_INVOICE_NUMBER
,      LINE_INTENDED_USE
,      PRODUCT_FISC_CLASSIFICATION
,      PRODUCT_CATEGORY
,      USER_DEFINED_FISC_CLASS
,      TRX_BUSINESS_CATEGORY
,      ASSESSABLE_VALUE
,      PORT_OF_ENTRY_CODE
,      TAXABLE_LINE_ITEM_FLEXFIELD
,      TAXABLE_LINE_SOURCE_TABLE
,      TAXABLE_LINE_TOTAL_AMOUNT
,      TAX_LINE_ID
,      TAX_LINE_NUMBER
,      TAX_AMT
,      TAX_AMT_FUNCL_CURR
,      TAXABLE_AMT
,      TAXABLE_AMT_FUNCL_CURR
,      TAXABLE_DISC_AMT
,      TAXABLE_DISC_AMT_FUNCL_CURR
,      TAX_DISC_AMT
,      TAX_DISC_AMT_FUNCL_CURR
,      TAX_RATE_CODE
,      TAX_RATE
,      TAX_RATE_VAT_TRX_TYPE_CODE
,      TAX_RATE_VAT_TRX_TYPE_DESC
,      TAX_TYPE_CODE
,      TAX_TYPE_MNG
,      TAX_STATUS_ID
,      TAX_RATE_CODE_NAME
,      TAX_RATE_CODE_DESCRIPTION
,      TAX_RATE_ID
,      TAX_RATE_REGISTER_TYPE_CODE
,      TAX_APPLIED
,      TAX_PROVIDER_ID
,      DEF_REC_SETTLEMENT_OPTION_CODE
,      OFFSET_TAX_RATE_CODE
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON_CODE
,      TAX_EXCEPTION_REASON_CODE
,      TAX_EXEMPTION_ID
,      TAX_EXCEPTION_ID
,      TAX_RECOVERY_RATE
,      TAX_REGIME_CODE
,      TAX
,      TAX_JURISDICTION_CODE
,      TAX_STATUS_CODE
,      TAX_CURRENCY_CODE
,      EXCEPTION_RATE
,      EXEMPT_RATE_MODIFIER
,      TAX_DATE
,      TAX_DETERMINE_DATE
,      TAX_APPORTIONMENT_LINE_NUMBER
,      TAX_AMT_TAX_CURR
,      TAXABLE_AMT_TAX_CURR
,      ORIG_TAXABLE_AMT
,      ORIG_TAXABLE_AMT_TAX_CURR
,      ORIG_TAX_AMT
,      ORIG_TAX_AMT_TAX_CURR
,      ORIG_REC_NREC_TAX_AMT
,      REC_TAX_AMT_TAX_CURR
,      NREC_TAX_AMT_TAX_CURR
,      TAX_LINE_USER_CATEGORY
,      TAX_LINE_USER_ATTRIBUTE1
,      TAX_LINE_USER_ATTRIBUTE2
,      TAX_LINE_USER_ATTRIBUTE3
,      TAX_LINE_USER_ATTRIBUTE4
,      TAX_LINE_USER_ATTRIBUTE5
,      TAX_LINE_USER_ATTRIBUTE6
,      TAX_LINE_USER_ATTRIBUTE7
,      TAX_LINE_USER_ATTRIBUTE8
,      TAX_LINE_USER_ATTRIBUTE9
,      TAX_LINE_USER_ATTRIBUTE10
,      TAX_LINE_USER_ATTRIBUTE11
,      TAX_LINE_USER_ATTRIBUTE12
,      TAX_LINE_USER_ATTRIBUTE13
,      TAX_LINE_USER_ATTRIBUTE14
,      TAX_LINE_USER_ATTRIBUTE15
,      RECOVERY_TYPE_CODE
,      RECOVERY_RATE_CODE
,      BILLING_TP_NAME
,      BILLING_TP_NUMBER
,      BILLING_TP_TAX_REG_NUM
,      BILLING_TP_TAXPAYER_ID
,      BILLING_TP_SITE_NAME_ALT
,      BILLING_TP_NAME_ALT
,      BILLING_TP_SIC_CODE
,      BILLING_TP_CITY
,      BILLING_TP_COUNTY
,      BILLING_TP_STATE
,      BILLING_TP_PROVINCE
,      BILLING_TP_ADDRESS1
,      BILLING_TP_ADDRESS2
,      BILLING_TP_ADDRESS3
,      BILLING_TP_ADDRESS_LINES_ALT
,      BILLING_TP_COUNTRY
,      BILLING_TP_POSTAL_CODE
,      SHIPPING_TP_NUMBER
,      SHIPPING_TP_TAX_REG_NUM
,      SHIPPING_TP_TAXPAYER_ID
,      SHIPPING_TP_NAME
,      SHIPPING_TP_NAME_ALT
,      SHIPPING_TP_SIC_CODE
,      SHIPPING_TP_CITY
,      SHIPPING_TP_COUNTY
,      SHIPPING_TP_STATE
,      SHIPPING_TP_PROVINCE
,      SHIPPING_TP_ADDRESS1
,      SHIPPING_TP_ADDRESS2
,      SHIPPING_TP_ADDRESS3
,      SHIPPING_TP_ADDRESS_LINES_ALT
,      SHIPPING_TP_COUNTRY
,      SHIPPING_TP_POSTAL_CODE
,      BILLING_TP_PARTY_NUMBER
,      BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NUM
,      BILLING_TRADING_PARTNER_ID
,      BILLING_TP_SITE_ID
,      BILLING_TP_ADDRESS_ID
,      BILLING_TP_TAX_REPORTING_FLAG
,      SHIPPING_TRADING_PARTNER_ID
,      SHIPPING_TP_SITE_ID
,      SHIPPING_TP_ADDRESS_ID
,      BANKING_TP_NAME
,      BANKING_TP_TAXPAYER_ID
,      BANK_ACCOUNT_ID
,      BANK_BRANCH_ID
,      BILLING_TP_SITE_NAME
,      BILLING_TP_SITE_TAX_REG_NUM
,      SHIPPING_TP_SITE_NAME
,      SHIPPING_TP_SITE_TAX_REG_NUM
,      OFFICE_SITE_FLAG
,      SHIP_TO_LOCATION_ID
,      SHIP_FROM_LOCATION_ID
,      BILL_TO_LOCATION_ID
,      BILL_FROM_LOCATION_ID
,      SHIP_TO_PARTY_TAX_PROF_ID
,      SHIP_FROM_PARTY_TAX_PROF_ID
,      BILL_TO_PARTY_TAX_PROF_ID
,      BILL_FROM_PARTY_TAX_PROF_ID
,      OWN_HQ_PARTY_TAX_PROF_ID
,      SHIP_TO_SITE_TAX_PROF_ID
,      BILL_TO_SITE_TAX_PROF_ID
,      SHIP_FROM_SITE_TAX_PROF_ID
,      BILL_FROM_SITE_TAX_PROF_ID
,      OWN_HQ_PARTY_SITE_PROF_ID
,      SHIP_TO_PARTY_ID
,      SHIP_FROM_PARTY_ID
,      BILL_TO_PARTY_ID
,      BILL_FROM_PARTY_ID
,      OWN_HQ_PARTY_ID
,      SHIP_TO_PARTY_SITE_ID
,      SHIP_FROM_PARTY_SITE_ID
,      BILL_TO_PARTY_SITE_ID
,      BILL_FROM_PARTY_SITE_ID
,      REGISTRATION_STATUS_CODE
,      REG_PARTY_TAX_PROF_ID
,      REG_PARTY_TAX_SITE_PROF_ID
,      POS_TAX_PARTY_PROF_ID
,      POS_TAX_PARTY_SITE_PROF_ID
,      POA_LOCATION_ID
,      PLACE_OF_SUPPLY_TYPE_CODE
,      DEF_PLACE_OF_SUPPLY_TYPE_CODE
,      POO_LOCATION_ID
,      LEGAL_ENTITY_TAX_REG_NUMBER
,      HQ_ESTB_REG_NUMBER
,      TAX_LINE_REGISTRATION_NUMBER
,      REGISTRATION_PARTY_TYPE
,      BALANCING_SEGMENT_VALUE
,      BALANCING_SEGMENT_DESC
,      CANCELLED_DATE
,      HISTORICAL_FLAG
,      CANCEL_FLAG
,      SELF_ASSESSED_FLAG
,      REPORTING_ONLY_FLAG
,      TAX_ONLY_FLAG
,      OFFSET_FLAG
,      POSTED_FLAG
,      MRC_TAX_LINE_FLAG
,      SMALL_BUSINESS_FLAG
,      RECONCILIATION_FLAG
,      TAX_RECOVERABLE_FLAG
,      REVERSE_FLAG
,      AR_CASH_RECEIPT_REVERSE_STATUS
,      AR_CASH_RECEIPT_REVERSE_DATE
,      TAXABLE_ITEM_SOURCE_ID
,      AMOUNT_APPLIED
,      BR_REF_CUSTOMER_TRX_ID
,      TAX_AMT_INCLUDED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      GDF_PARTY_SITES_BILL_ATT8
,      GDF_RA_CUST_BILL_ATT10
,      GDF_RA_CUST_BILL_ATT12
,      GDF_RA_ADDRESSES_BILL_ATT8
,      GDF_RA_ADDRESSES_BILL_ATT9
,      GDF_PARTY_SITES_SHIP_ATT8
,      GDF_RA_CUST_SHIP_ATT10
,      GDF_RA_CUST_SHIP_ATT12
,      GDF_RA_ADDRESSES_SHIP_ATT8
,      GDF_RA_ADDRESSES_SHIP_ATT9
,      GDF_PO_VENDOR_SITE_ATT17
,      ACCTD_AMOUNT_CR
,      ACCTD_AMOUNT_DR
,      REC_APPLICATION_STATUS
,      SUB_LEDGER_INVOICE_IDENTIFIER
,      ACCOUNT_CLASS
,      LATEST_REC_FLAG
,      ENTITY_CODE
,      POSTED_DATE
,      ACTG_SOURCE_ID
,      UNIT_PRICE
,      GL_DATE
FROM ZX.ZX_REP_TRX_DETAIL_T;

Dependencies

[top of page]

ZX.ZX_REP_TRX_DETAIL_T does not reference any database object

ZX.ZX_REP_TRX_DETAIL_T is referenced by following:

SchemaZX
ViewZX_REP_TRX_DETAIL_T#