[Home] [Help] [Dependency Information]
Object Name: | TX_CALC_MST |
---|---|
Object Type: | TABLE |
Owner: | GML |
FND Design Data: | GML.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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
TX_CALC_MST_PK | NORMAL | UNIQUE | APPS_TS_SEED | TAXCALC_CODE |
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 |
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;
GML.TX_CALC_MST does not reference any database object
GML.TX_CALC_MST is referenced by following:
|
|
|