JG_FSCL_TAX_AUTH_RET_INT
This interface table contains tax authority returned information related to multiple fiscal document events. Fiscal document events represent the requests made to the tax authority, like Fiscal Document Status, Cancellation, Void and Contingency. Tax authority response is captured in this table along with other relevant fiscal document information.
Details
-
Schema: FUSION
-
Object owner: JG
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
JG_FSCL_TAX_AUTH_RET_INT_PK |
TAX_AUTHORITY_RETURN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TAX_AUTHORITY_RETURN_ID | NUMBER | 18 | Yes | 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. | |
| BATCH_NAME | VARCHAR2 | 80 | Identifies the set of records to be processed. | ||
| TAX_AUTH_RETURN_CODE | VARCHAR2 | 30 | Internal code representing the return code from tax authority. Standard tax authority return codes will be transformed into this internal code. The return code is dependent on the request made to tax authority. Possible values are Approved, Cancelled, Contingency approved, Contingency rejected, Errors, Pending return, Rejected, Sent, Upload failed and Void. | ||
| PROCESSED_FLAG | VARCHAR2 | 1 | Indicates if the record has already being processed by fiscal document import process. | ||
| PROCESSED_DATE_TIME | TIMESTAMP | Date and time when a fiscal document was processed by the tax authority. | |||
| PROTOCOL_NUMBER | NUMBER | 18 | Number generated by the tax authority to uniquely identify the transactions of authorization, cancelation, and void related to a fiscal document. | ||
| FISCAL_DOC_DATE | DATE | Date when fiscal document is issued by city tax authority. | |||
| DOC_NUM | NUMBER | 18 | Unique number that is assigned to a document, such as fiscal document number or tax invoice number. | ||
| SRVC_INVOICE_VERIFICATION_CODE | VARCHAR2 | 255 | Verification code of the fiscal document for a service invoice. | ||
| TAX_AUTH_DOC_NUMBER | NUMBER | 18 | Certificate number provided by the muncipality on payment of taxes. | ||
| TAX_SETTLEMENT_DATE | DATE | Date of certificate provided by the muncipality on the payment of 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. | |||
| NATIONAL_SERVICE_FSCL_DOC_KEY | VARCHAR2 | 80 | Indicates the National Service Fiscal Document Key |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JG_FSCL_TAX_AUTH_RET_INT_N1 | Non Unique | Default | LOAD_REQUEST_ID |
| JG_FSCL_TAX_AUTH_RET_INT_U1 | Unique | Default | TAX_AUTHORITY_RETURN_ID |
| JG_FSCL_TAX_AUTH_RET_INT_U2 | Unique | Default | FISCAL_DOC_KEY, FISCAL_DOC_EVENT_CODE |