[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ZX_REP_TRX_DETAIL_T |
|---|---|
| Object Type: | TABLE |
| Owner: | ZX |
| FND Design Data: |  ZX.ZX_REP_TRX_DETAIL_T
|
| Subobject Name: | |
| Status: | VALID |
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| ZX_REP_TRX_DETAIL_T_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 DETAIL_TAX_LINE_ID
|
| 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 | (10) | 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 | (15) | 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 | (15) | 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 | (15) | 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 | (15) | 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 | (15) | 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 | (15) | Applied from document application identifier | |
| APPLIED_FROM_LINE_ID | NUMBER | (15) | Transaction line identifier for the applied from document | |
| APPLIED_FROM_ENTITY_CODE | VARCHAR2 | (30) | Applied from document entity code | |
| APPLIED_FROM_TRX_ID | NUMBER | (15) | 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 | (15) | 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 | (15) | 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 | (15) | Applied to document application identifier | |
| APPLIED_TO_TRX_ID | NUMBER | (15) | Applied to document transaction identifier | |
| APPLIED_TO_TRX_LINE_ID | NUMBER | (15) | 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 | (15) | 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 | (15) | Reference document transaction identifier | |
| REF_DOC_LINE_ID | NUMBER | (15) | Transaction line identifier for the reference document | |
| REF_DOC_LINE_QUANTITY | NUMBER | (15) | 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 | (30) | 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 | (30) | 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 | (30) | 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 | (30) | 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 | (15) | Ship to location identifier | |
| SHIP_FROM_LOCATION_ID | NUMBER | (15) | Ship from location identifier | |
| BILL_TO_LOCATION_ID | NUMBER | (15) | Bill to location identifier | |
| BILL_FROM_LOCATION_ID | NUMBER | (15) | 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 | VARCHAR2 | (80) | 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 |
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;
ZX.ZX_REP_TRX_DETAIL_T does not reference any database object
ZX.ZX_REP_TRX_DETAIL_T is referenced by following:
APPS
ZX_REP_TRX_DETAIL_T
|
|
|
|