Skip to content

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

VIEW: ZX.ZX_REP_TRX_DETAIL_T#

Object Details
Object Name: ZX_REP_TRX_DETAIL_T#
Object Type: VIEW
Owner: ZX
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DETAIL_TAX_LINE_ID NUMBER (15) Yes
REP_CONTEXT_ID NUMBER (15)
EXTRACT_LINE_ID NUMBER (15)
EXTRACT_REPORT_LINE_NUMBER NUMBER

LEDGER_ID NUMBER (15)
LEDGER_NAME VARCHAR2 (30)
CHART_OF_ACCOUNTS_ID NUMBER (15)
EXTRACT_SOURCE_LEDGER VARCHAR2 (30)
EVENT_CLASS_CODE VARCHAR2 (30)
EVENT_CLASS_MAPPING_ID NUMBER

DOC_EVENT_STATUS VARCHAR2 (30)
APPLICATION_DOC_STATUS VARCHAR2 (30)
ESTABLISHMENT_ID NUMBER

APPLICATION_ID NUMBER

INTERNAL_ORGANIZATION_ID NUMBER

TRX_ID NUMBER

TRX_NUMBER VARCHAR2 (150)
TRX_DESCRIPTION VARCHAR2 (240)
TRX_CURRENCY_CODE VARCHAR2 (15)
TRX_LINE_ID NUMBER

TRX_LINE_NUMBER NUMBER

TRX_LINE_DESCRIPTION VARCHAR2 (240)
TRX_LINE_TYPE VARCHAR2 (30)
TRX_DATE DATE

DEPOSIT_DATE DATE

TRX_DUE_DATE DATE

TRX_SHIPPING_DATE DATE

TRX_COMMUNICATED_DATE DATE

TRX_TYPE_DESCRIPTION VARCHAR2 (240)
TRX_TYPE_ID NUMBER (15)
TRX_LEVEL_TYPE VARCHAR2 (30)
TRX_BATCH_SOURCE_NAME VARCHAR2 (150)
TRX_SIC_CODE VARCHAR2 (150)
FOB_POINT VARCHAR2 (30)
TRX_WAYBILL_NUMBER VARCHAR2 (50)
TRX_LINE_CLASS VARCHAR2 (30)
PRODUCT_ID NUMBER

PRODUCT_DESCRIPTION VARCHAR2 (240)
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (30)
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_RATE NUMBER

PRECISION NUMBER

MINIMUM_ACCOUNTABLE_UNIT NUMBER

GDF_FND_CURRENCIES_ATT1 VARCHAR2 (150)
CURRENCY_CODE_DESC VARCHAR2 (240)
TERRITORY_SHORT_NAME VARCHAR2 (80)
DOC_SEQ_ID NUMBER

DOC_SEQ_NAME VARCHAR2 (150)
DOC_SEQ_VALUE VARCHAR2 (240)
TRX_LINE_QUANTITY NUMBER

TRX_LINE_AMT NUMBER

UOM_CODE VARCHAR2 (30)
RECEIPT_CLASS_ID NUMBER (15)
TRX_BATCH_SOURCE_ID NUMBER (15)
TRX_BATCH_SOURCE_DATE DATE

APPLIED_FROM_APPLICATION_ID NUMBER

APPLIED_FROM_LINE_ID NUMBER

APPLIED_FROM_ENTITY_CODE VARCHAR2 (30)
APPLIED_FROM_TRX_ID NUMBER

APPLIED_FROM_EVENT_CLASS_CODE VARCHAR2 (30)
APPLIED_FROM_TRX_NUMBER VARCHAR2 (150)
TRX_APPLIED_FROM_CLASS_MNG VARCHAR2 (80)
ADJUSTED_DOC_APPLICATION_ID NUMBER

ADJUSTED_DOC_ENTITY_CODE VARCHAR2 (30)
ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
ADJUSTED_DOC_TRX_ID NUMBER

ADJUSTED_DOC_NUMBER VARCHAR2 (150)
ADJUSTED_DOC_DATE DATE

APPLIED_TO_APPLICATION_ID NUMBER

APPLIED_TO_TRX_ID NUMBER

APPLIED_TO_TRX_LINE_ID NUMBER

APPLIED_TO_ENTITY_CODE VARCHAR2 (30)
APPLIED_TO_EVENT_CLASS_CODE VARCHAR2 (30)
APPLIED_TO_TRX_NUMBER VARCHAR2 (150)
TRX_APPLIED_TO_CLASS_MNG VARCHAR2 (80)
REF_DOC_APPLICATION_ID NUMBER

REF_DOC_ENTITY_CODE VARCHAR2 (30)
REF_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
REF_DOC_TRX_ID NUMBER

REF_DOC_LINE_ID NUMBER

REF_DOC_LINE_QUANTITY NUMBER

MERCHANT_PARTY_DOCUMENT_NUMBER VARCHAR2 (150)
MERCHANT_PARTY_NAME VARCHAR2 (150)
MERCHANT_PARTY_REFERENCE VARCHAR2 (250)
MERCHANT_PARTY_TAX_REG_NUMBER VARCHAR2 (150)
MERCHANT_PARTY_TAXPAYER_ID VARCHAR2 (150)
COUNTRY_OF_SUPPLY VARCHAR2 (150)
START_EXPENSE_DATE DATE

DEFAULT_TAXATION_COUNTRY VARCHAR2 (2)
TRX_CLASS_MNG VARCHAR2 (80)
TRX_TYPE_MNG VARCHAR2 (80)
TAX_RATE_CODE_REG_TYPE_MNG VARCHAR2 (80)
TAX_EXEMPT_REASON_MNG VARCHAR2 (80)
TAX_EXCEPTION_REASON_MNG VARCHAR2 (80)
TRX_QUANTITY_UOM_MNG VARCHAR2 (80)
TAX_RATE_CODE_VAT_TRX_TYPE_MNG VARCHAR2 (240)
DOCUMENT_SUB_TYPE VARCHAR2 (240)
SUPPLIER_TAX_INVOICE_NUMBER VARCHAR2 (150)
SUPPLIER_TAX_INVOICE_DATE DATE

SUPPLIER_EXCHANGE_RATE NUMBER

TAX_INVOICE_DATE DATE

TAX_INVOICE_NUMBER VARCHAR2 (150)
LINE_INTENDED_USE VARCHAR2 (240)
PRODUCT_FISC_CLASSIFICATION VARCHAR2 (240)
PRODUCT_CATEGORY VARCHAR2 (240)
USER_DEFINED_FISC_CLASS VARCHAR2 (30)
TRX_BUSINESS_CATEGORY VARCHAR2 (240)
ASSESSABLE_VALUE NUMBER

PORT_OF_ENTRY_CODE VARCHAR2 (30)
TAXABLE_LINE_ITEM_FLEXFIELD VARCHAR2 (2000)
TAXABLE_LINE_SOURCE_TABLE VARCHAR2 (30)
TAXABLE_LINE_TOTAL_AMOUNT NUMBER

TAX_LINE_ID NUMBER (15)
TAX_LINE_NUMBER NUMBER

TAX_AMT NUMBER

TAX_AMT_FUNCL_CURR NUMBER

TAXABLE_AMT NUMBER

TAXABLE_AMT_FUNCL_CURR NUMBER

TAXABLE_DISC_AMT NUMBER

TAXABLE_DISC_AMT_FUNCL_CURR NUMBER

TAX_DISC_AMT NUMBER

TAX_DISC_AMT_FUNCL_CURR NUMBER

TAX_RATE_CODE VARCHAR2 (50)
TAX_RATE NUMBER

TAX_RATE_VAT_TRX_TYPE_CODE VARCHAR2 (30)
TAX_RATE_VAT_TRX_TYPE_DESC VARCHAR2 (240)
TAX_TYPE_CODE VARCHAR2 (30)
TAX_TYPE_MNG VARCHAR2 (80)
TAX_STATUS_ID NUMBER (15)
TAX_RATE_CODE_NAME VARCHAR2 (240)
TAX_RATE_CODE_DESCRIPTION VARCHAR2 (240)
TAX_RATE_ID NUMBER (15)
TAX_RATE_REGISTER_TYPE_CODE VARCHAR2 (30)
TAX_APPLIED NUMBER

TAX_PROVIDER_ID NUMBER

DEF_REC_SETTLEMENT_OPTION_CODE VARCHAR2 (30)
OFFSET_TAX_RATE_CODE VARCHAR2 (50)
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 (80)
EXEMPT_REASON_CODE VARCHAR2 (30)
TAX_EXCEPTION_REASON_CODE VARCHAR2 (30)
TAX_EXEMPTION_ID NUMBER (15)
TAX_EXCEPTION_ID NUMBER (15)
TAX_RECOVERY_RATE NUMBER

TAX_REGIME_CODE VARCHAR2 (30)
TAX VARCHAR2 (30)
TAX_JURISDICTION_CODE VARCHAR2 (30)
TAX_STATUS_CODE VARCHAR2 (30)
TAX_CURRENCY_CODE VARCHAR2 (15)
EXCEPTION_RATE NUMBER

EXEMPT_RATE_MODIFIER NUMBER

TAX_DATE DATE

TAX_DETERMINE_DATE DATE

TAX_APPORTIONMENT_LINE_NUMBER NUMBER

TAX_AMT_TAX_CURR NUMBER

TAXABLE_AMT_TAX_CURR NUMBER

ORIG_TAXABLE_AMT NUMBER

ORIG_TAXABLE_AMT_TAX_CURR NUMBER

ORIG_TAX_AMT NUMBER

ORIG_TAX_AMT_TAX_CURR NUMBER

ORIG_REC_NREC_TAX_AMT NUMBER

REC_TAX_AMT_TAX_CURR NUMBER

NREC_TAX_AMT_TAX_CURR NUMBER

TAX_LINE_USER_CATEGORY VARCHAR2 (150)
TAX_LINE_USER_ATTRIBUTE1 VARCHAR2 (150)
TAX_LINE_USER_ATTRIBUTE2 VARCHAR2 (150)
TAX_LINE_USER_ATTRIBUTE3 VARCHAR2 (150)
TAX_LINE_USER_ATTRIBUTE4 VARCHAR2 (150)
TAX_LINE_USER_ATTRIBUTE5 VARCHAR2 (150)
TAX_LINE_USER_ATTRIBUTE6 VARCHAR2 (150)
TAX_LINE_USER_ATTRIBUTE7 VARCHAR2 (150)
TAX_LINE_USER_ATTRIBUTE8 VARCHAR2 (150)
TAX_LINE_USER_ATTRIBUTE9 VARCHAR2 (150)
TAX_LINE_USER_ATTRIBUTE10 VARCHAR2 (150)
TAX_LINE_USER_ATTRIBUTE11 VARCHAR2 (150)
TAX_LINE_USER_ATTRIBUTE12 VARCHAR2 (150)
TAX_LINE_USER_ATTRIBUTE13 VARCHAR2 (150)
TAX_LINE_USER_ATTRIBUTE14 VARCHAR2 (150)
TAX_LINE_USER_ATTRIBUTE15 VARCHAR2 (150)
RECOVERY_TYPE_CODE VARCHAR2 (30)
RECOVERY_RATE_CODE VARCHAR2 (150)
BILLING_TP_NAME VARCHAR2 (360)
BILLING_TP_NUMBER VARCHAR2 (240)
BILLING_TP_TAX_REG_NUM VARCHAR2 (50)
BILLING_TP_TAXPAYER_ID VARCHAR2 (50)
BILLING_TP_SITE_NAME_ALT VARCHAR2 (320)
BILLING_TP_NAME_ALT VARCHAR2 (320)
BILLING_TP_SIC_CODE VARCHAR2 (30)
BILLING_TP_CITY VARCHAR2 (60)
BILLING_TP_COUNTY VARCHAR2 (60)
BILLING_TP_STATE VARCHAR2 (150)
BILLING_TP_PROVINCE VARCHAR2 (60)
BILLING_TP_ADDRESS1 VARCHAR2 (240)
BILLING_TP_ADDRESS2 VARCHAR2 (240)
BILLING_TP_ADDRESS3 VARCHAR2 (240)
BILLING_TP_ADDRESS_LINES_ALT VARCHAR2 (560)
BILLING_TP_COUNTRY VARCHAR2 (60)
BILLING_TP_POSTAL_CODE VARCHAR2 (60)
SHIPPING_TP_NUMBER VARCHAR2 (60)
SHIPPING_TP_TAX_REG_NUM VARCHAR2 (50)
SHIPPING_TP_TAXPAYER_ID VARCHAR2 (50)
SHIPPING_TP_NAME VARCHAR2 (360)
SHIPPING_TP_NAME_ALT VARCHAR2 (320)
SHIPPING_TP_SIC_CODE VARCHAR2 (30)
SHIPPING_TP_CITY VARCHAR2 (60)
SHIPPING_TP_COUNTY VARCHAR2 (60)
SHIPPING_TP_STATE VARCHAR2 (60)
SHIPPING_TP_PROVINCE VARCHAR2 (60)
SHIPPING_TP_ADDRESS1 VARCHAR2 (240)
SHIPPING_TP_ADDRESS2 VARCHAR2 (240)
SHIPPING_TP_ADDRESS3 VARCHAR2 (240)
SHIPPING_TP_ADDRESS_LINES_ALT VARCHAR2 (560)
SHIPPING_TP_COUNTRY VARCHAR2 (60)
SHIPPING_TP_POSTAL_CODE VARCHAR2 (60)
BILLING_TP_PARTY_NUMBER VARCHAR2 (30)
BANK_ACCOUNT_NAME VARCHAR2 (80)
BANK_ACCOUNT_NUM VARCHAR2 (30)
BILLING_TRADING_PARTNER_ID NUMBER (15)
BILLING_TP_SITE_ID NUMBER (15)
BILLING_TP_ADDRESS_ID NUMBER (15)
BILLING_TP_TAX_REPORTING_FLAG VARCHAR2 (1)
SHIPPING_TRADING_PARTNER_ID NUMBER (15)
SHIPPING_TP_SITE_ID NUMBER (15)
SHIPPING_TP_ADDRESS_ID NUMBER (15)
BANKING_TP_NAME VARCHAR2 (360)
BANKING_TP_TAXPAYER_ID VARCHAR2 (50)
BANK_ACCOUNT_ID NUMBER (15)
BANK_BRANCH_ID NUMBER (15)
BILLING_TP_SITE_NAME VARCHAR2 (40)
BILLING_TP_SITE_TAX_REG_NUM VARCHAR2 (50)
SHIPPING_TP_SITE_NAME VARCHAR2 (40)
SHIPPING_TP_SITE_TAX_REG_NUM VARCHAR2 (50)
OFFICE_SITE_FLAG VARCHAR2 (1)
SHIP_TO_LOCATION_ID NUMBER

SHIP_FROM_LOCATION_ID NUMBER

BILL_TO_LOCATION_ID NUMBER

BILL_FROM_LOCATION_ID NUMBER

SHIP_TO_PARTY_TAX_PROF_ID NUMBER

SHIP_FROM_PARTY_TAX_PROF_ID NUMBER

BILL_TO_PARTY_TAX_PROF_ID NUMBER

BILL_FROM_PARTY_TAX_PROF_ID NUMBER

OWN_HQ_PARTY_TAX_PROF_ID NUMBER

SHIP_TO_SITE_TAX_PROF_ID NUMBER

BILL_TO_SITE_TAX_PROF_ID NUMBER

SHIP_FROM_SITE_TAX_PROF_ID NUMBER

BILL_FROM_SITE_TAX_PROF_ID NUMBER

OWN_HQ_PARTY_SITE_PROF_ID NUMBER

SHIP_TO_PARTY_ID NUMBER (15)
SHIP_FROM_PARTY_ID NUMBER (15)
BILL_TO_PARTY_ID NUMBER (15)
BILL_FROM_PARTY_ID NUMBER (15)
OWN_HQ_PARTY_ID NUMBER (15)
SHIP_TO_PARTY_SITE_ID NUMBER (15)
SHIP_FROM_PARTY_SITE_ID NUMBER (15)
BILL_TO_PARTY_SITE_ID NUMBER (15)
BILL_FROM_PARTY_SITE_ID NUMBER (15)
REGISTRATION_STATUS_CODE VARCHAR2 (30)
REG_PARTY_TAX_PROF_ID NUMBER (15)
REG_PARTY_TAX_SITE_PROF_ID NUMBER (15)
POS_TAX_PARTY_PROF_ID NUMBER (15)
POS_TAX_PARTY_SITE_PROF_ID NUMBER (15)
POA_LOCATION_ID NUMBER

PLACE_OF_SUPPLY_TYPE_CODE VARCHAR2 (30)
DEF_PLACE_OF_SUPPLY_TYPE_CODE VARCHAR2 (30)
POO_LOCATION_ID NUMBER

HQ_ESTB_REG_NUMBER VARCHAR2 (30)
TAX_LINE_REGISTRATION_NUMBER VARCHAR2 (50)
REGISTRATION_PARTY_TYPE VARCHAR2 (30)
BALANCING_SEGMENT_VALUE VARCHAR2 (25)
BALANCING_SEGMENT_DESC VARCHAR2 (240)
CANCELLED_DATE DATE

HISTORICAL_FLAG VARCHAR2 (1)
CANCEL_FLAG VARCHAR2 (1)
SELF_ASSESSED_FLAG VARCHAR2 (1)
REPORTING_ONLY_FLAG VARCHAR2 (1)
TAX_ONLY_FLAG VARCHAR2 (1)
OFFSET_FLAG VARCHAR2 (1)
POSTED_FLAG VARCHAR2 (1)
MRC_TAX_LINE_FLAG VARCHAR2 (1)
SMALL_BUSINESS_FLAG VARCHAR2 (1)
RECONCILIATION_FLAG VARCHAR2 (1)
TAX_RECOVERABLE_FLAG VARCHAR2 (1)
REVERSE_FLAG VARCHAR2 (1)
AR_CASH_RECEIPT_REVERSE_STATUS VARCHAR2 (30)
AR_CASH_RECEIPT_REVERSE_DATE DATE

TAXABLE_ITEM_SOURCE_ID NUMBER

AMOUNT_APPLIED NUMBER

BR_REF_CUSTOMER_TRX_ID NUMBER

TAX_AMT_INCLUDED_FLAG VARCHAR2 (1)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_LOGIN_ID NUMBER

GDF_PARTY_SITES_BILL_ATT8 VARCHAR2 (150)
GDF_RA_CUST_BILL_ATT10 VARCHAR2 (150)
GDF_RA_CUST_BILL_ATT12 VARCHAR2 (150)
GDF_RA_ADDRESSES_BILL_ATT8 VARCHAR2 (150)
GDF_RA_ADDRESSES_BILL_ATT9 VARCHAR2 (150)
GDF_PARTY_SITES_SHIP_ATT8 VARCHAR2 (150)
GDF_RA_CUST_SHIP_ATT10 VARCHAR2 (150)
GDF_RA_CUST_SHIP_ATT12 VARCHAR2 (150)
GDF_RA_ADDRESSES_SHIP_ATT8 VARCHAR2 (150)
GDF_RA_ADDRESSES_SHIP_ATT9 VARCHAR2 (150)
GDF_PO_VENDOR_SITE_ATT17 VARCHAR2 (150)
ACCTD_AMOUNT_CR NUMBER

ACCTD_AMOUNT_DR NUMBER

REC_APPLICATION_STATUS VARCHAR2 (30)
SUB_LEDGER_INVOICE_IDENTIFIER VARCHAR2 (20)
ACCOUNT_CLASS VARCHAR2 (20)
LATEST_REC_FLAG VARCHAR2 (1)
ENTITY_CODE VARCHAR2 (30)
POSTED_DATE DATE

ACTG_SOURCE_ID NUMBER

UNIT_PRICE NUMBER

GL_DATE 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# references the following:

SchemaZX
TableZX_REP_TRX_DETAIL_T
ZX.ZX_REP_TRX_DETAIL_T# is referenced by following:

SchemaAPPS
SynonymZX_REP_TRX_DETAIL_T