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_TRANSACTION

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZX_TRANSACTION_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRX_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FIRST_PTY_ORG_ID	NUMBER			Party tax profile identifier for the first party organization of the transaction
INTERNAL_ORGANIZATION_ID	NUMBER		Yes	Internal organization 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	(15)	Yes	Primary transaction identifier
TRX_NUMBER	VARCHAR2	(150)	Yes	Transaction number, typically the number that enables a user to identify a transaction
INTERNAL_ORG_LOCATION_ID	NUMBER			Internal organization location identifier of the transaction
TAX_EVENT_TYPE_CODE	VARCHAR2	(30)		Tax event type code of the transaction
TRX_DATE	DATE		Yes	Transaction date
DOCUMENT_EVENT_TYPE	VARCHAR2	(30)		Document event type
LEDGER_ID	NUMBER	(15)		Ledger defining column
TRX_CURRENCY_CODE	VARCHAR2	(15)		Transaction currency code
CURRENCY_CONVERSION_DATE	DATE			Date of the exchange rate
CURRENCY_CONVERSION_RATE	NUMBER			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_PTP_ID	NUMBER	(15)		Party tax profile identifier for legal entity of the transaction
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
BILL_FROM_PARTY_SITE_ID	NUMBER			Bill from party site identifier
BILL_TO_PARTY_SITE_ID	NUMBER			Bill to party site identifier
SHIP_FROM_PARTY_SITE_ID	NUMBER			Ship from party site identifier
SHIP_TO_PARTY_SITE_ID	NUMBER			Ship to party site identifier
SHIP_TO_PARTY_ID	NUMBER			Ship to party identifier
SHIP_FROM_PARTY_ID	NUMBER			Ship from party identifier
BILL_TO_PARTY_ID	NUMBER			Bill to party identifier
BILL_FROM_PARTY_ID	NUMBER			Bill from party identifier
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
POA_LOCATION_ID	NUMBER			Point of acceptance location identifier
POO_LOCATION_ID	NUMBER			Point of origin location identifier
PAYING_LOCATION_ID	NUMBER			Not currently used
OWN_HQ_LOCATION_ID	NUMBER			Not currently used
TRADING_HQ_LOCATION_ID	NUMBER			Not currently used
POC_LOCATION_ID	NUMBER			Not currently used
POI_LOCATION_ID	NUMBER			Not currently used
POD_LOCATION_ID	NUMBER			Not currently used
TRX_DESCRIPTION	VARCHAR2	(240)		Transaction description
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
TITLE_TRANSFER_LOCATION_ID	NUMBER			Not currently used
TAX_MANUAL_ENTRY_FLAG	VARCHAR2	(1)		Not currently used
ESTABLISHMENT_ID	NUMBER			Establishment identifier of the first party
RECEIVABLES_TRX_TYPE_ID	NUMBER			Transaction type identifier for Receivables transactions
DEFAULT_TAXATION_COUNTRY	VARCHAR2	(2)		Default taxation country code
QUOTE_FLAG	VARCHAR2	(1)		Y or N indicates whether the tax claculation API should be called in quote only mode
CTRL_TOTAL_HDR_TX_AMT	NUMBER			Control amount at the header level for the total tax amount
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
APPLIED_TO_TRX_NUMBER	VARCHAR2	(20)		Applied to document transaction number
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
VALIDATION_CHECK_FLAG	VARCHAR2	(1)		Not currently used
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number
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

Query Text

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


SELECT FIRST_PTY_ORG_ID
,      INTERNAL_ORGANIZATION_ID
,      APPLICATION_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      EVENT_TYPE_CODE
,      TRX_ID
,      TRX_NUMBER
,      INTERNAL_ORG_LOCATION_ID
,      TAX_EVENT_TYPE_CODE
,      TRX_DATE
,      DOCUMENT_EVENT_TYPE
,      LEDGER_ID
,      TRX_CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      MINIMUM_ACCOUNTABLE_UNIT
,      PRECISION
,      LEGAL_ENTITY_PTP_ID
,      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
,      BILL_FROM_PARTY_SITE_ID
,      BILL_TO_PARTY_SITE_ID
,      SHIP_FROM_PARTY_SITE_ID
,      SHIP_TO_PARTY_SITE_ID
,      SHIP_TO_PARTY_ID
,      SHIP_FROM_PARTY_ID
,      BILL_TO_PARTY_ID
,      BILL_FROM_PARTY_ID
,      SHIP_TO_LOCATION_ID
,      SHIP_FROM_LOCATION_ID
,      BILL_TO_LOCATION_ID
,      BILL_FROM_LOCATION_ID
,      POA_LOCATION_ID
,      POO_LOCATION_ID
,      PAYING_LOCATION_ID
,      OWN_HQ_LOCATION_ID
,      TRADING_HQ_LOCATION_ID
,      POC_LOCATION_ID
,      POI_LOCATION_ID
,      POD_LOCATION_ID
,      TRX_DESCRIPTION
,      DOCUMENT_SUB_TYPE
,      SUPPLIER_TAX_INVOICE_NUMBER
,      SUPPLIER_TAX_INVOICE_DATE
,      SUPPLIER_EXCHANGE_RATE
,      TAX_INVOICE_DATE
,      TAX_INVOICE_NUMBER
,      TITLE_TRANSFER_LOCATION_ID
,      TAX_MANUAL_ENTRY_FLAG
,      ESTABLISHMENT_ID
,      RECEIVABLES_TRX_TYPE_ID
,      DEFAULT_TAXATION_COUNTRY
,      QUOTE_FLAG
,      CTRL_TOTAL_HDR_TX_AMT
,      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
,      APPLIED_TO_TRX_NUMBER
,      SHIP_THIRD_PTY_ACCT_ID
,      BILL_THIRD_PTY_ACCT_ID
,      SHIP_THIRD_PTY_ACCT_SITE_ID
,      BILL_THIRD_PTY_ACCT_SITE_ID
,      VALIDATION_CHECK_FLAG
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ZX.ZX_TRANSACTION;

Dependencies

[top of page]

ZX.ZX_TRANSACTION does not reference any database object

ZX.ZX_TRANSACTION is referenced by following:

APPS: ZX_TRANSACTION