[Home] [Help] [Dependency Information]
Object Name: | TX_HIST_TAX |
---|---|
Object Type: | TABLE |
Owner: | GML |
FND Design Data: | GML.TX_HIST_TAX |
Subobject Name: | |
Status: | VALID |
This table is held over from a previous release of OPM and held tax history based on OPM Invoices. For Release 4.10, 11.0 and afterwards, this table is not used in the application.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
TX_HIST_TAX_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
INVOICE_ID
TAXAUTH_ID ICTAX_CLASS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_ID | NUMBER | (10) | Yes | Fk to op_invc_mst |
TAXAUTH_ID | NUMBER | (10) | Yes | Fk to tx_taxa_mst |
ICTAX_CLASS | VARCHAR2 | (8) | Yes | Fk to ic_taxn_cls |
INVOICE_DATE | DATE | Yes | Date of the invoice from op_invc_mst | |
PAYMENT_DATE | DATE | Yes | Invoice payment date. | |
TAXPOINT_DATE | DATE | Yes | Date on which tax liability is recognized. | |
INVOICE_AMOUNT | NUMBER | Yes | Total amount of the invoice | |
TAXABLE_AMOUNT | NUMBER | Yes | Amount of invoice which is considered taxable by tax authority. | |
TAX_AMOUNT | NUMBER | Yes | Amount of the tax for the invoice | |
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 | |
DELETE_MARK | NUMBER | (5) | Yes | Standard: 0=Active record (default); 1=Marked for (logical) deletion. |
TAX_CATEGORY_ID | NUMBER | Category Id for TAX_CLASS |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, TAXAUTH_ID
, ICTAX_CLASS
, INVOICE_DATE
, PAYMENT_DATE
, TAXPOINT_DATE
, INVOICE_AMOUNT
, TAXABLE_AMOUNT
, TAX_AMOUNT
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, DELETE_MARK
, TAX_CATEGORY_ID
FROM GML.TX_HIST_TAX;
GML.TX_HIST_TAX does not reference any database object
GML.TX_HIST_TAX is referenced by following:
|
|
|