ZX_PRODUCT_OPTIONS_ALL_

This table stores the tax system options for multiple applications. Each record stores tax options of a business unit for a specific application.

Details

• Schema: FUSION

• Object owner: ZX

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
ZX_PRODUCT_OPTIONS_ALL_PK_	LAST_UPDATE_DATE, LAST_UPDATED_BY, PRODUCT_OPTIONS_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
ORG_ID	NUMBER		18		Indicates the identifier of the business unit associated to the row.	Active
APPLICATION_ID	NUMBER				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		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				Who column: indicates the date and time of the creation of the row.	Active
CREATED_BY	VARCHAR2	64			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.
AUDIT_ACTION_TYPE_	VARCHAR2	10			Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_	VARCHAR2	1000			Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_	VARCHAR2	64			Original Impersonator User.

Indexes

Index	Uniqueness	Tablespace	Columns	Status
ZX_PRODUCT_OPTIONS_ALL_N1_	Non Unique	Default	PRODUCT_OPTIONS_ID
ZX_PRODUCT_OPTIONS_ALL_U1_	Unique	FUSION_TS_TX_DATA	LAST_UPDATE_DATE, LAST_UPDATED_BY, PRODUCT_OPTIONS_ID	Active