JG_ZZ_VAT_ALLOC_RULES
For each source, financial and VAT transaction type captures allocation rules. These rules are used by allocation process to allocate VAT box to each transaction lines for reporting purpose. Each line contains VAT box for lines of type TAX and TAXABLE.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
JG_ZZ_VAT_ALLOC_RULES_PK |
ALLOCATION_RULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ALLOCATION_RULE_ID | NUMBER | 18 | Yes | Allocation Rules Identifier | |
| VAT_REPORTING_ENTITY_ID | NUMBER | 18 | Yes | Reporting entity Identifier for the rule | |
| SOURCE | VARCHAR2 | 30 | Not currently used | ||
| FINANCIAL_DOCUMENT_TYPE | VARCHAR2 | 20 | Financial transaction type | ||
| VAT_TRANSACTION_TYPE | VARCHAR2 | 30 | VAT transaction type | ||
| TAX_ID | NUMBER | 18 | Tax Identifier | ||
| TAX_CODE | VARCHAR2 | 50 | Tax code | ||
| TAX_STATUS | VARCHAR2 | 30 | Tax Status | ||
| TAX_JURISDICTION_CODE | VARCHAR2 | 30 | Tax Jurisdiction | ||
| TAX_RATE_CODE | VARCHAR2 | 50 | Tax rate code | ||
| TAX_RATE_ID | NUMBER | 18 | Tax rate Identifier | ||
| TAX_BOX_RECOVERABLE | VARCHAR2 | 15 | Indicates recoverable VAT box number for tax lines. | ||
| TAX_BOX_NON_RECOVERABLE | VARCHAR2 | 15 | Indicates nonrecoverable VAT box number for tax lines. | ||
| TAXABLE_BOX_RECOVERABLE | VARCHAR2 | 15 | Indicates recoverable VAT box number for taxable lines. | ||
| TAXABLE_BOX_NON_RECOVERABLE | VARCHAR2 | 15 | Indicates nonrecoverable VAT box number for taxable lines | ||
| TOTAL_BOX | VARCHAR2 | 15 | Total VAT box number | ||
| SIGN_FLAG | VARCHAR2 | 15 | Not currently used | ||
| EFFECTIVE_FROM_DATE | DATE | Indicates date from which rule is effective. | |||
| EFFECTIVE_TO_DATE | DATE | Indicates till what date rule is effective. NULL value means effective for ever | |||
| PERIOD_TYPE | VARCHAR2 | 15 | Period type | ||
| 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. | ||
| TAX_REC_SIGN_FLAG | VARCHAR2 | 1 | Sign flag for recoverable tax amount | ||
| TAX_NON_REC_SIGN_FLAG | VARCHAR2 | 1 | Sign flag for nonrecoverable tax amount | ||
| TAXABLE_REC_SIGN_FLAG | VARCHAR2 | 1 | Sign flag for recoverable taxable amount | ||
| TAXABLE_NON_REC_SIGN_FLAG | VARCHAR2 | 1 | Sign flag for nonrecoverable taxable amount | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| JG_ZZ_VAT_ALLOC_RULES | jg_zz_vat_rep_entities | VAT_REPORTING_ENTITY_ID |
| JG_ZZ_VAT_ALLOC_RULES | zx_taxes_b | TAX_ID |
| jg_zz_vat_box_allocs | jg_zz_vat_alloc_rules | ALLOCATION_RULE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JG_ZZ_VAT_ALLOC_RULES_U1 | Unique | Default | ALLOCATION_RULE_ID |
| JG_ZZ_VAT_ALLOC_RULES_U2 | Unique | Default | VAT_REPORTING_ENTITY_ID, SOURCE, FINANCIAL_DOCUMENT_TYPE, VAT_TRANSACTION_TYPE, TAX_CODE, TAX_STATUS, TAX_JURISDICTION_CODE, TAX_RATE_CODE, PERIOD_TYPE, EFFECTIVE_FROM_DATE, TAX_BOX_RECOVERABLE, TAX_BOX_NON_RECOVERABLE, TAXABLE_BOX_RECOVERABLE, TAXABLE_BOX_NON_RECOVERABLE |