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


TABLE: GML.TX_CALC_MST

Object Details
Object Name: TX_CALC_MST
Object Type: TABLE
Owner: GML
FND Design Data: TableGML.TX_CALC_MST
Subobject Name:
Status: VALID


This table allows the user to establish different processing for tax calculations used in OPM. At least one record must exist in this table, with the column DEFAULT_IND set to 1. Only one "default" record can be established. The remaining records entered in this table are calculations that must be assigned to a customer for specific calculations by customer.
There are several indicators in this table that are not used by the OPM tax calculation. They are: INVC_TAXPT, ADJTERMS_IND, and PAY_TAXPT.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
TX_CALC_MST_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTAXCALC_CODE
Columns
Name Datatype Length Mandatory Comments
TAXCALC_CODE VARCHAR2 (4) Yes Primary key.
TAXCALC_DESC VARCHAR2 (70) Yes Tax calculation description as entered by the user
INVC_TAXPT NUMBER (5) Yes 0=invoice date is not tax point date; 1=invoice date is tax point date.
INVCPRICE_IND NUMBER (5) Yes 0=use net price for tax calc; 1=use base price for tax calc.
INCLPRICE_IND NUMBER (5) Yes 0=price does not include tax; 1=price includes tax.
COMPTERMS_IND NUMBER (5) Yes 0=do not compute terms before tax; 1=compute terms before tax.
COMPGOODS_IND NUMBER (5) Yes 0=compute goods amt before terms; 1=compute goods amt after terms.
INCLTAX_IND NUMBER (5) Yes 0=do not include previous tax; 1=include previous calculated taxes.
ADJTERMS_IND NUMBER (5) Yes 0=do not adjust ar for terms; 1=adjust ar for terms.
PAY_TAXPT NUMBER (5) Yes 0=do not use payment date as tax point; 1-use payment date as tax point date
DEFAULT_IND NUMBER (5) Yes 0=no default calculation; 1=default calculation.
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
Query Text

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


SELECT TAXCALC_CODE
,      TAXCALC_DESC
,      INVC_TAXPT
,      INVCPRICE_IND
,      INCLPRICE_IND
,      COMPTERMS_IND
,      COMPGOODS_IND
,      INCLTAX_IND
,      ADJTERMS_IND
,      PAY_TAXPT
,      DEFAULT_IND
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
FROM GML.TX_CALC_MST;

Dependencies

[top of page]

GML.TX_CALC_MST does not reference any database object

GML.TX_CALC_MST is referenced by following:

SchemaAPPS
SynonymTX_CALC_MST