RCL_TAX_DETERMINANTS
This table stores the tax determinants for a debrief or part line.
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 |