JG_ZZ_VAT_BOX_ERRORS
Stores the errors that are generated during VAT box allocation processing. These errors will be flushed out when allocation processing is run again and error no more exists. This is a temporary table that stores the allocation errors
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
JG_ZZ_VAT_BOX_ERRORS_PK |
VAT_TRANSACTION_ID, PERIOD_TYPE, ALLOCATION_ERROR_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| VAT_TRANSACTION_ID | NUMBER | 18 | Yes | Indicates the VAT tax transaction. | |
| ALLOCATION_ERROR_CODE | VARCHAR2 | 30 | Yes | Error identifier of the transaction when allocation failed | |
| PERIOD_TYPE | VARCHAR2 | 15 | Yes | Indicates the period type of the allocation | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JG_ZZ_VAT_BOX_ERRORS_U1 | Unique | Default | VAT_TRANSACTION_ID, PERIOD_TYPE, ALLOCATION_ERROR_CODE |