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: GML.OP_TXCU_ASC

Object Details

Object Name:	OP_TXCU_ASC
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.OP_TXCU_ASC
Subobject Name:
Status:	VALID

Customer tax exemption information is maintained in this table. The exemption information may contain an exemption certificate number and a tax status for the customer. Customers with records in this table will not have taxes computed for the tax authorities for which they hold an exemption certificate. The OPM tax calculation uses this data.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_TXCU_ASC_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CUSTTAX_ID
OP_TXCU_ASCI1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUST_ID TAXAUTH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CUST_ID	NUMBER	(15)	Yes	Customer id
CUSTTAX_ID	NUMBER	(15)	Yes	Surrogate id to uniquely identify record
EXEMPT_REASCODE	VARCHAR2	(4)	Yes	Exemption reason code
EXEMPTDATE_EXPIRE	DATE			Date when exemption certificate expires
TAX_STATUS	VARCHAR2	(4)		Tax status for customer/exemption
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
TRANS_CNT	NUMBER	(10)		Not currently used
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
TAXAUTH_ID	NUMBER	(10)	Yes	Tax Authority id
EXEMPTCERT_NO	VARCHAR2	(32)		Exemption certificate number, not validated.
OPM_CUST_ID	NUMBER	(10)		Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes.
CO_CODE	VARCHAR2	(4)		Company Code

Query Text

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


SELECT CUST_ID
,      CUSTTAX_ID
,      EXEMPT_REASCODE
,      EXEMPTDATE_EXPIRE
,      TAX_STATUS
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
,      TAXAUTH_ID
,      EXEMPTCERT_NO
,      OPM_CUST_ID
,      CO_CODE
FROM GML.OP_TXCU_ASC;

Dependencies

[top of page]

GML.OP_TXCU_ASC does not reference any database object

GML.OP_TXCU_ASC is referenced by following:

APPS: OP_TXCU_ASC