eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: ZX.ZX_TRX_HEADERS_GT

Object Details

Object Name:	ZX_TRX_HEADERS_GT
Object Type:	TABLE
Owner:	ZX
FND Design Data:	ZX.ZX_TRX_HEADERS_GT
Subobject Name:
Status:	VALID

Temporary Table Details

ZX.ZX_TRX_HEADERS_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZX_TRX_HEADERS_GT_U1	NORMAL	UNIQUE		APPLICATION_ID ENTITY_CODE EVENT_CLASS_CODE TRX_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INTERNAL_ORGANIZATION_ID	NUMBER		Yes	Internal organization identifier of the transaction
INTERNAL_ORG_LOCATION_ID	NUMBER			Internal organization location identifier of the transaction
APPLICATION_ID	NUMBER		Yes	Application Identifier of the transaction
ENTITY_CODE	VARCHAR2	(30)	Yes	Entity code of the application event class for the transaction
EVENT_CLASS_CODE	VARCHAR2	(30)	Yes	Application event class of the transaction
EVENT_TYPE_CODE	VARCHAR2	(30)	Yes	Application event type for the transaction
TRX_ID	NUMBER		Yes	Primary transaction identifier
HDR_TRX_USER_KEY1	VARCHAR2	(150)		First component of the user composite key to uniquely identify the transaction
HDR_TRX_USER_KEY2	VARCHAR2	(150)		Second component of the user composite key to uniquely identify the transaction
HDR_TRX_USER_KEY3	VARCHAR2	(150)		Third component of the user composite key to uniquely identify the transaction
HDR_TRX_USER_KEY4	VARCHAR2	(150)		Fourth component of the user composite key to uniquely identify the transaction
HDR_TRX_USER_KEY5	VARCHAR2	(150)		Fifth component of the user composite key to uniquely identify the transaction
HDR_TRX_USER_KEY6	VARCHAR2	(150)		Sixth component of the user composite key to uniquely identify the transaction
TRX_DATE	DATE		Yes	Transaction date
TRX_DOC_REVISION	VARCHAR2	(150)		Revision number for the transaction.
LEDGER_ID	NUMBER	(15)		Ledger identifying column
TRX_CURRENCY_CODE	VARCHAR2	(15)		Transaction currency code
CURRENCY_CONVERSION_DATE	DATE			Date of the exchange rate
CURRENCY_CONVERSION_RATE	NUMBER			Date of the exchange rate
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Exchange rate type
MINIMUM_ACCOUNTABLE_UNIT	NUMBER			Minimum accountable unit of the transaction currency
PRECISION	NUMBER			Precision of the transaction currency
LEGAL_ENTITY_ID	NUMBER		Yes	Legal entity identifier for the transaction
ROUNDING_SHIP_TO_PARTY_ID	NUMBER			Party identifier for the ship to party of the transaction used for rounding of tax amounts
ROUNDING_SHIP_FROM_PARTY_ID	NUMBER			Party identifier for the ship from party of the transaction used for rounding of tax amounts
ROUNDING_BILL_TO_PARTY_ID	NUMBER			Party identifier for the bill to party of the transaction used for rounding of tax amounts
ROUNDING_BILL_FROM_PARTY_ID	NUMBER			Party identifier for the bill from party of the transaction used for rounding of tax amounts
RNDG_SHIP_TO_PARTY_SITE_ID	NUMBER			Party site identifier for the ship to party site of the transaction used for rounding of tax amounts
RNDG_SHIP_FROM_PARTY_SITE_ID	NUMBER			Party site identifier for the ship from party site of the transaction used for rounding of tax amounts
RNDG_BILL_TO_PARTY_SITE_ID	NUMBER			Party site identifier for the bill to party site of the transaction used for rounding of tax amounts
RNDG_BILL_FROM_PARTY_SITE_ID	NUMBER			Party site identifier for the bill from party site of the transaction used for rounding of tax amounts
ESTABLISHMENT_ID	NUMBER			Establishment identifier of the first party
RECEIVABLES_TRX_TYPE_ID	NUMBER			Transaction type identifier for Receivables transactions
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
REL_DOC_HDR_TRX_USER_KEY1	VARCHAR2	(150)		First component of the user composite key for uniquely identifying the related document
REL_DOC_HDR_TRX_USER_KEY2	VARCHAR2	(150)		Second component of the user composite key for uniquely identifying the related document
REL_DOC_HDR_TRX_USER_KEY3	VARCHAR2	(150)		Third component of the user composite key for uniquely identifying the related document
REL_DOC_HDR_TRX_USER_KEY4	VARCHAR2	(150)		Fourth component of the user composite key for uniquely identifying the related document
REL_DOC_HDR_TRX_USER_KEY5	VARCHAR2	(150)		Fifth component of the user composite key for the uniquely identifying related document
REL_DOC_HDR_TRX_USER_KEY6	VARCHAR2	(150)		Sixth component of the user composite key for the uniquely identifying related document
RELATED_DOC_NUMBER	VARCHAR2	(150)		Transaction number for related document
RELATED_DOC_DATE	DATE			Related document date
DEFAULT_TAXATION_COUNTRY	VARCHAR2	(2)		Default taxation country code
QUOTE_FLAG	VARCHAR2	(1)		Y or N indicates whether the tax calculation call is for estimate purpose only
CTRL_TOTAL_HDR_TX_AMT	NUMBER			Control amount at the header level for the total tax amount
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_COMMUNICATED_DATE	DATE			Printed or Received date of the transaction
BATCH_SOURCE_ID	NUMBER			Batch source identifier for Receivables transactions
BATCH_SOURCE_NAME	VARCHAR2	(150)		Batch source name for Receivables transactions
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_DUE_DATE	DATE			Payment due date of the transaction
TRX_TYPE_DESCRIPTION	VARCHAR2	(240)		Transaction type description for Receivables transactions
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			Transaction date for tax invoice generated by Receivables
TAX_INVOICE_NUMBER	VARCHAR2	(150)		Number for tax invoice generated by Receivables
FIRST_PTY_ORG_ID	NUMBER			Party tax profile identifier for the first party organization of the transaction
TAX_EVENT_CLASS_CODE	VARCHAR2	(30)		Tax event class code of the transaction
TAX_EVENT_TYPE_CODE	VARCHAR2	(30)		Tax event type code of the transaction
DOC_EVENT_STATUS	VARCHAR2	(30)		Lookup code that indicates event status of the transaction
RDNG_SHIP_TO_PTY_TX_PROF_ID	NUMBER			Party tax profile identifier for the ship to party of the transaction used for rounding of tax amounts
RDNG_SHIP_FROM_PTY_TX_PROF_ID	NUMBER			Party tax profile identifier for the ship from party of the transaction used for rounding of tax amounts
RDNG_BILL_TO_PTY_TX_PROF_ID	NUMBER			Party tax profile identifier for the bill to party of the transaction used for rounding of tax amounts
RDNG_BILL_FROM_PTY_TX_PROF_ID	NUMBER			Party tax profile identifier for the bill from party of the transaction used for rounding of tax amounts
RDNG_SHIP_TO_PTY_TX_P_ST_ID	NUMBER			Party tax profile identifier for the ship to party site of the transaction used for rounding of tax amounts
RDNG_SHIP_FROM_PTY_TX_P_ST_ID	NUMBER			Party tax profile identifier for the ship from party of the transaction used for rounding of tax amounts
RDNG_BILL_TO_PTY_TX_P_ST_ID	NUMBER			Party tax profile identifier for the bill to party site of the transaction used for rounding of tax amounts
RDNG_BILL_FROM_PTY_TX_P_ST_ID	NUMBER			Party tax profile identifier for the bill from party of the transaction used for rounding of tax amounts
VALIDATION_CHECK_FLAG	VARCHAR2	(1)		Y or N indicates whether this transaction is valid from tax perspective if it is imported
PORT_OF_ENTRY_CODE	VARCHAR2	(30)		Port of entry code
TAX_REPORTING_FLAG	VARCHAR2	(1)		Tax reporting flag for lease management
SHIP_TO_CUST_ACCT_SITE_USE_ID	NUMBER			Column to record ship to customer account site use identifier for Receivables.
BILL_TO_CUST_ACCT_SITE_USE_ID	NUMBER			Column to record bill to customer account site use identifier for Receivables
PROVNL_TAX_DETERMINATION_DATE	DATE			Transaction date of the original transaction in case of lease management when a lease contract is revised
DOC_LEVEL_RECALC_FLAG	VARCHAR2	(1)		Y or N indicates whether tax lines of all transaction lines are modified due to recalculation
TRX_BATCH_ID	NUMBER	(15)		Transaction batch identifier
APPLIED_TO_TRX_NUMBER	VARCHAR2	(20)		Applied to document transaction number
APPLICATION_DOC_STATUS	VARCHAR2	(30)		Transaction status as stored by the application
SHIP_THIRD_PTY_ACCT_ID	NUMBER			Column to record ship to customer account identifier for Receivables or ship from supplier identifier for Payables
BILL_THIRD_PTY_ACCT_ID	NUMBER			Column to record bill to customer account identifier for Receivables or bill from supplier identifier for Payables
SHIP_THIRD_PTY_ACCT_SITE_ID	NUMBER			Column to record ship to customer account site identifier for Receivables or ship from supplier site identifier for Payables
BILL_THIRD_PTY_ACCT_SITE_ID	NUMBER			Column to record bill to customer account site identifier for Receivables or bill from supplier site identifier for Payables
ICX_SESSION_ID	NUMBER	(15)		ICX user session identifier

Query Text

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


SELECT INTERNAL_ORGANIZATION_ID
,      INTERNAL_ORG_LOCATION_ID
,      APPLICATION_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      EVENT_TYPE_CODE
,      TRX_ID
,      HDR_TRX_USER_KEY1
,      HDR_TRX_USER_KEY2
,      HDR_TRX_USER_KEY3
,      HDR_TRX_USER_KEY4
,      HDR_TRX_USER_KEY5
,      HDR_TRX_USER_KEY6
,      TRX_DATE
,      TRX_DOC_REVISION
,      LEDGER_ID
,      TRX_CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      MINIMUM_ACCOUNTABLE_UNIT
,      PRECISION
,      LEGAL_ENTITY_ID
,      ROUNDING_SHIP_TO_PARTY_ID
,      ROUNDING_SHIP_FROM_PARTY_ID
,      ROUNDING_BILL_TO_PARTY_ID
,      ROUNDING_BILL_FROM_PARTY_ID
,      RNDG_SHIP_TO_PARTY_SITE_ID
,      RNDG_SHIP_FROM_PARTY_SITE_ID
,      RNDG_BILL_TO_PARTY_SITE_ID
,      RNDG_BILL_FROM_PARTY_SITE_ID
,      ESTABLISHMENT_ID
,      RECEIVABLES_TRX_TYPE_ID
,      RELATED_DOC_APPLICATION_ID
,      RELATED_DOC_ENTITY_CODE
,      RELATED_DOC_EVENT_CLASS_CODE
,      RELATED_DOC_TRX_ID
,      REL_DOC_HDR_TRX_USER_KEY1
,      REL_DOC_HDR_TRX_USER_KEY2
,      REL_DOC_HDR_TRX_USER_KEY3
,      REL_DOC_HDR_TRX_USER_KEY4
,      REL_DOC_HDR_TRX_USER_KEY5
,      REL_DOC_HDR_TRX_USER_KEY6
,      RELATED_DOC_NUMBER
,      RELATED_DOC_DATE
,      DEFAULT_TAXATION_COUNTRY
,      QUOTE_FLAG
,      CTRL_TOTAL_HDR_TX_AMT
,      TRX_NUMBER
,      TRX_DESCRIPTION
,      TRX_COMMUNICATED_DATE
,      BATCH_SOURCE_ID
,      BATCH_SOURCE_NAME
,      DOC_SEQ_ID
,      DOC_SEQ_NAME
,      DOC_SEQ_VALUE
,      TRX_DUE_DATE
,      TRX_TYPE_DESCRIPTION
,      DOCUMENT_SUB_TYPE
,      SUPPLIER_TAX_INVOICE_NUMBER
,      SUPPLIER_TAX_INVOICE_DATE
,      SUPPLIER_EXCHANGE_RATE
,      TAX_INVOICE_DATE
,      TAX_INVOICE_NUMBER
,      FIRST_PTY_ORG_ID
,      TAX_EVENT_CLASS_CODE
,      TAX_EVENT_TYPE_CODE
,      DOC_EVENT_STATUS
,      RDNG_SHIP_TO_PTY_TX_PROF_ID
,      RDNG_SHIP_FROM_PTY_TX_PROF_ID
,      RDNG_BILL_TO_PTY_TX_PROF_ID
,      RDNG_BILL_FROM_PTY_TX_PROF_ID
,      RDNG_SHIP_TO_PTY_TX_P_ST_ID
,      RDNG_SHIP_FROM_PTY_TX_P_ST_ID
,      RDNG_BILL_TO_PTY_TX_P_ST_ID
,      RDNG_BILL_FROM_PTY_TX_P_ST_ID
,      VALIDATION_CHECK_FLAG
,      PORT_OF_ENTRY_CODE
,      TAX_REPORTING_FLAG
,      SHIP_TO_CUST_ACCT_SITE_USE_ID
,      BILL_TO_CUST_ACCT_SITE_USE_ID
,      PROVNL_TAX_DETERMINATION_DATE
,      DOC_LEVEL_RECALC_FLAG
,      TRX_BATCH_ID
,      APPLIED_TO_TRX_NUMBER
,      APPLICATION_DOC_STATUS
,      SHIP_THIRD_PTY_ACCT_ID
,      BILL_THIRD_PTY_ACCT_ID
,      SHIP_THIRD_PTY_ACCT_SITE_ID
,      BILL_THIRD_PTY_ACCT_SITE_ID
,      ICX_SESSION_ID
FROM ZX.ZX_TRX_HEADERS_GT;

Dependencies

[top of page]

ZX.ZX_TRX_HEADERS_GT does not reference any database object

ZX.ZX_TRX_HEADERS_GT is referenced by following:

APPS: ZX_TRX_HEADERS_GT