ZX_PRODUCT_OPTIONS

Details

Schema: FUSION
Object owner: ZX
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
ZX_PRODUCT_OPTIONS_ALL_PK	PRODUCT_OPTIONS_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
ORG_ID	NUMBER		18	Yes	Indicates the identifier of the business unit associated to the row.	Active
APPLICATION_ID	NUMBER			Yes	Application identifier	Active
DEF_OPTION_HIER_1_CODE	VARCHAR2	30			Lookup code to indicate the first precedence for defauting tax classification code	Active
DEF_OPTION_HIER_2_CODE	VARCHAR2	30			Code to indicate the second precedence for defauting tax classification code	Active
DEF_OPTION_HIER_3_CODE	VARCHAR2	30			Code to indicate the third precedence for defauting tax classification code	Active
DEF_OPTION_HIER_4_CODE	VARCHAR2	30			Code to indicate the fourth precedence for defauting tax classification code	Active
DEF_OPTION_HIER_5_CODE	VARCHAR2	30			Code to indicate the fifth precedence for defauting tax classification code	Active
DEF_OPTION_HIER_6_CODE	VARCHAR2	30			Code to indicate the sixth precedence for defauting tax classification code	Active
TAX_CLASSIFICATION_CODE	VARCHAR2	50			Tax classification code to be defualted if it is not obtained from any of the defaulting hierarchy precedences	Active
TAX_METHOD_CODE	VARCHAR2	30			Type of tax method used to determine taxes. Possible values are LTE and EBTAX.	Active
INCLUSIVE_TAX_USED_FLAG	VARCHAR2	1			Y or N indicates if inclusive taxes are used for Latin Tax Engine	Active
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	Active
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	Active
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	Active
TAX_ALLOW_COMPOUND_FLAG	VARCHAR2	1			Y or N indicates if compound taxes are calculated by Latin Tax Engine	Active
TAX_ROUNDING_RULE	VARCHAR2	30			Tax rounding rule used by Latin Tax Engine	Active
TAX_PRECISION	NUMBER		1		Precision used by Latin Tax Engine	Active
TAX_MINIMUM_ACCOUNTABLE_UNIT	NUMBER				Minimum accountable unit used by Latin Tax Engine	Active
USE_TAX_CLASSIFICATION_FLAG	VARCHAR2	1			Y or N indicates if the tax classification code is in use for this application and operating unit	Active
ALLOW_TAX_ROUNDING_OVRD_FLAG	VARCHAR2	1			Y or N indicates whether tax rounding override is allowed for Latin Tax Engine	Active
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	Active
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.	Active
RECORD_TYPE_CODE	VARCHAR2	30			Lookup code to indicate whether the record is migrated, seeded or defined by the user	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
EVENT_CLASS_MAPPING_ID	NUMBER		18		Event class mapping identifier	Active
DEF_OPTION_HIER_7_CODE	VARCHAR2	30			Code to indicate the seventh precedence for defauting tax classification code	Active
PRODUCT_OPTIONS_ID	NUMBER		18	Yes	Unique identifier	Active
SALES_TAX_GEOCODE	VARCHAR2	30			State and local tax jurisdiction geocode for United States provided by Taxware for point of order acceptance location	Active
TAX_CURRENCY_CODE	VARCHAR2	15			Currency used to pay the tax authority and to report on all tax transactions.
WHT_TAX_FLAG	VARCHAR2	1			Type of tax in the product options. Possible values are I for indirect tax and W for withholding.

Foreign Keys

Table	Foreign Table	Foreign Key Column
ZX_PRODUCT_OPTIONS_ALL	zx_evnt_cls_mappings	EVENT_CLASS_MAPPING_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
ZX_PRODUCT_OPTIONS_ALL_U1	Unique	FUSION_TS_TX_DATA	PRODUCT_OPTIONS_ID	Active
ZX_PRODUCT_OPTIONS_ALL_U2	Unique	FUSION_TS_TX_DATA	ORG_ID, APPLICATION_ID, EVENT_CLASS_MAPPING_ID, WHT_TAX_FLAG	Active