RCL_TAX_DETERMINANTS

Details

Schema: FUSION
Object owner: RCL
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
rcl_tax_determinants_PK	RCL_TAX_DETERMINANT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RCL_TAX_DETERMINANT_ID	NUMBER		18	Yes	Unique identifier for tax determinants.
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.
PARENT_ENTITY_CODE	VARCHAR2	30			The unique code of the parent entity of the tax determinant line.
PARENT_ENTITY_ID	NUMBER		18		The unique identifier of the parent entity of the tax determinant line.
DEFAULT_TAXATION_COUNTRY	VARCHAR2	2			The Taxation Country specifies the country for taxation for tax calculation purposes.
FIRST_PTY_REG_ID	NUMBER		18		This is the registration number which is quoted to the supplier. Supplier would use this to tax the transaction.
THIRD_PTY_REG_ID	NUMBER		18		This is the customer registration number specified by the customer in the purchase order.
DOCUMENT_SUB_TYPE	VARCHAR2	240			Document Sub Type is used for tax calculation and tax reporting depending upon the requirements of different countries.
PRODUCT_TYPE	VARCHAR2	240			The Product Type is another product related classification in Fusion Tax. The value of product type specifies whether the transaction line is for a good, or a service, or it is a memo line.
PRODUCT_CATEGORY	VARCHAR2	240			The Product Category is used to classify products for tax purposes. It is used where Oracle Inventory is not installed, or is installed but not used for classifying products for tax purposes.
PROD_FC_CATEG_ID	NUMBER		18		This is a classification of the product(s) by tax authority for tax purposes.
TRX_BUSINESS_CATEGORY	VARCHAR2	240			The Transaction Business Category is a classification or categorization of a transaction for tax purposes as required by a tax authority.
USER_DEFINED_FISC_CLASS	VARCHAR2	30			User Defined Fiscal Classification is an additional classification of the transaction into different categories for tax purposes.
INTENDED_USE_CLASSIF_ID	NUMBER		18		The classification id for intended use for tax calculation purposes.
TAX_CLASSIFICATION_CODE	VARCHAR2	50			A grouping of taxes for reporting and processing purposes.
TAX_EXEMPTION_REASON_CODE	VARCHAR2	30			The reason a tax exemption was granted and taken.
TAX_INVOICE_DATE	DATE				Tax Invoice Date is used for Tax Reporting depending on the requirements of different countries.
TAX_INVOICE_NUMBER	VARCHAR2	150			This is the Invoice Number which is used for Tax Reporting depending on the requirements of different countries.
TAX_EXEMPT_FLAG	VARCHAR2	1			Indicates that a quote or fulfillment line is exempt from taxes.
EXEMPTION_CERTIFICATE_NUMBER	VARCHAR2	80			Tax Exemption Certificate Number.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
RCL_TAX_DETERMINANTS_U1	Unique	Default	RCL_TAX_DETERMINANT_ID