[Home] [Help] [Dependency Information]
Object Name: | ZX_PRODUCT_OPTIONS_ALL |
---|---|
Object Type: | TABLE |
Owner: | ZX |
FND Design Data: | ZX.ZX_PRODUCT_OPTIONS_ALL |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ZX_PRODUCT_OPTIONS_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PRODUCT_OPTIONS_ID |
ZX_PRODUCT_OPTIONS_ALL_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ORG_ID
APPLICATION_ID EVENT_CLASS_MAPPING_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | (15) | Yes | Internal organization identifier |
APPLICATION_ID | NUMBER | Yes | Application identifier | |
DEF_OPTION_HIER_1_CODE | VARCHAR2 | (30) | Lookup code to indicate the first precedence for defauting tax classification code | |
DEF_OPTION_HIER_2_CODE | VARCHAR2 | (30) | Code to indicate the second precedence for defauting tax classification code | |
DEF_OPTION_HIER_3_CODE | VARCHAR2 | (30) | Code to indicate the third precedence for defauting tax classification code | |
DEF_OPTION_HIER_4_CODE | VARCHAR2 | (30) | Code to indicate the fourth precedence for defauting tax classification code | |
DEF_OPTION_HIER_5_CODE | VARCHAR2 | (30) | Code to indicate the fifth precedence for defauting tax classification code | |
DEF_OPTION_HIER_6_CODE | VARCHAR2 | (30) | Code to indicate the sixth precedence for defauting tax classification code | |
TAX_CLASSIFICATION_CODE | VARCHAR2 | (50) | Tax classification code to be defualted if it is not obtained from any of the defaulting hierarchy precedences | |
TAX_METHOD_CODE | VARCHAR2 | (30) | Type of tax method used to determine taxes. Possible values are LTE and EBTAX. | |
INCLUSIVE_TAX_USED_FLAG | VARCHAR2 | (1) | Y or N indicates if inclusive taxes are used for Latin Tax Engine | |
TAX_USE_CUSTOMER_EXEMPT_FLAG | VARCHAR2 | (1) | Y or N indicates if customer exemptions are included when calculating taxes for transactions of this application and operating unit | |
TAX_USE_PRODUCT_EXEMPT_FLAG | VARCHAR2 | (1) | Y or N indicates if item exemptions are included when calculating taxes for transactions of this application and operating unit | |
TAX_USE_LOC_EXC_RATE_FLAG | VARCHAR2 | (1) | Y or N indicates if the tax rate that was defined for specific products based on the customers ship-to address is used for transactions of this application and operating unit | |
TAX_ALLOW_COMPOUND_FLAG | VARCHAR2 | (1) | Y or N indicates if compound taxes are calculated by Latin Tax Engine | |
TAX_ROUNDING_RULE | VARCHAR2 | (30) | Tax rounding rule used by Latin Tax Engine | |
TAX_PRECISION | NUMBER | (1) | Precision used by Latin Tax Engine | |
TAX_MINIMUM_ACCOUNTABLE_UNIT | NUMBER | Minimum accountable unit used by Latin Tax Engine | ||
USE_TAX_CLASSIFICATION_FLAG | VARCHAR2 | (1) | Y or N indicates if the tax classification code is in use for this application and operating unit | |
ALLOW_TAX_ROUNDING_OVRD_FLAG | VARCHAR2 | (1) | Y or N indicates whether tax rounding override is allowed for Latin Tax Engine | |
HOME_COUNTRY_DEFAULT_FLAG | VARCHAR2 | (1) | Y or N indicates whether country code is to be defaulted when the country of location for this operating unit is same as bill to or ship to location | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object version number | |
RECORD_TYPE_CODE | VARCHAR2 | (30) | Lookup code to indicate whether the record is migrated, seeded or defined by the user | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
EVENT_CLASS_MAPPING_ID | NUMBER | (15) | Event class mapping identifier | |
DEF_OPTION_HIER_7_CODE | VARCHAR2 | (30) | Code to indicate the seventh precedence for defauting tax classification code | |
PRODUCT_OPTIONS_ID | NUMBER | (15) | Unique identifier | |
SALES_TAX_GEOCODE | VARCHAR2 | (30) | State and local tax jurisdiction geocode for United States provided by Taxware for point of order acceptance location |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, APPLICATION_ID
, DEF_OPTION_HIER_1_CODE
, DEF_OPTION_HIER_2_CODE
, DEF_OPTION_HIER_3_CODE
, DEF_OPTION_HIER_4_CODE
, DEF_OPTION_HIER_5_CODE
, DEF_OPTION_HIER_6_CODE
, TAX_CLASSIFICATION_CODE
, TAX_METHOD_CODE
, INCLUSIVE_TAX_USED_FLAG
, TAX_USE_CUSTOMER_EXEMPT_FLAG
, TAX_USE_PRODUCT_EXEMPT_FLAG
, TAX_USE_LOC_EXC_RATE_FLAG
, TAX_ALLOW_COMPOUND_FLAG
, TAX_ROUNDING_RULE
, TAX_PRECISION
, TAX_MINIMUM_ACCOUNTABLE_UNIT
, USE_TAX_CLASSIFICATION_FLAG
, ALLOW_TAX_ROUNDING_OVRD_FLAG
, HOME_COUNTRY_DEFAULT_FLAG
, OBJECT_VERSION_NUMBER
, RECORD_TYPE_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, EVENT_CLASS_MAPPING_ID
, DEF_OPTION_HIER_7_CODE
, PRODUCT_OPTIONS_ID
, SALES_TAX_GEOCODE
FROM ZX.ZX_PRODUCT_OPTIONS_ALL;
ZX.ZX_PRODUCT_OPTIONS_ALL does not reference any database object
ZX.ZX_PRODUCT_OPTIONS_ALL is referenced by following:
|
|
|