JG_FSCL_TAX_AUTH_TAXES_INT
This interface table contains fiscal document tax information returned by city tax authority. Since city tax authority calculates the city taxes for each fiscal document, this information needs to be captured and stored in the system.
Details
-
Schema: FUSION
-
Object owner: JG
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
JG_FSCL_TAX_AUTH_TAXES_INT_PK |
TAX_AUTHORITY_RETURN_TAX_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TAX_AUTHORITY_RETURN_TAX_ID | NUMBER | 18 | Yes | Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | |
| TAX_AUTHORITY_RETURN_ID | NUMBER | 18 | Interface identifier of the tax authority event return. | ||
| FISCAL_DOC_KEY | VARCHAR2 | 50 | Yes | Fiscal document access key composed by concatenation of fiscal document number and other fiscal document information. It is used as unique identifier for the tax authority system. | |
| FISCAL_DOC_EVENT_CODE | VARCHAR2 | 30 | Yes | Fiscal document event code representing the request that is being made to the tax authority. Possible values are Fiscal Document Status, Cancellation, Void and Contingency. | |
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created 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. | |
| TAX | VARCHAR2 | 30 | Tax code for the classification of a charge imposed by a government through a fiscal or tax authority. | ||
| TAXABLE_AMT | NUMBER | Amount in entered currency on which the tax rate is applied to calculate the tax amount. | |||
| TAX_RATE | NUMBER | Rate specified for a tax status for an effective time period. A tax rate can be expressed as a percentage or a value per unit quantity. | |||
| TAX_AMT | NUMBER | Tax amount associated with the tax distribution. | |||
| TAX_JURISDICTION_CODE | VARCHAR2 | 30 | Tax jurisdiction code for a geographic area where a tax is levied by a specific tax authority. | ||
| TAX_REGIME_CODE | VARCHAR2 | 30 | Tax regime code for the set of tax rules that determines the treatment of one or more taxes administered by a tax authority. | ||
| TAX_STATUS_CODE | VARCHAR2 | 30 | Tax status code for the taxable nature of a product in the context of a transaction for a tax. | ||
| TAX_RATE_CODE | VARCHAR2 | 30 | Tax rate code specified for a tax status for an effective time period, expressed as a percentage or a value per unit quantity. | ||
| CITY_CODE | VARCHAR2 | 30 | Unique code provided by the tax authority for a compactly settled area as distinguished from surrounding rural territory. | ||
| TAX_CREDIT_AMOUNT | NUMBER | Tax credit amount informed by city tax authority. In some cases, this tax credit amount can be deducted by tax payer from other city taxes. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JG_FSCL_TAX_AUTH_TAXES_INT_N1 | Non Unique | Default | TAX_AUTHORITY_RETURN_ID |
| JG_FSCL_TAX_AUTH_TAXES_INT_N2 | Non Unique | Default | FISCAL_DOC_KEY, FISCAL_DOC_EVENT_CODE |
| JG_FSCL_TAX_AUTH_TAXES_INT_N3 | Non Unique | Default | LOAD_REQUEST_ID |
| JG_FSCL_TAX_AUTH_TAXES_INT_U1 | Unique | Default | TAX_AUTHORITY_RETURN_TAX_ID |