JG_TAX_INVOICE_REFERENCES
This table contains reference information related to the tax invoice that is obtained from the tax authority. When the information (such as the tax invoice number, tax invoice date and first party registration number) is valid, the tax authority sends back an "Invoice Reference Number" and other details and references that are needed for further processing (such as shipment). In case the information sent is not valid, the tax authority sends an error code and error message.
Details
-
Schema: FUSION
-
Object owner: JG
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
JG_TAX_INVOICE_REFERENCES_PK |
DOCUMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCUMENT_ID | NUMBER | 18 | Yes | Record identifier for the invoice. | |
| APPLICATION_ID | NUMBER | Transaction application identifier. | |||
| ENTITY_CODE | VARCHAR2 | 30 | Entity code of the transaction application event class. | ||
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Application event class of the transaction. | ||
| TRX_ID | NUMBER | Primary transaction identifier. | |||
| RECORD_TYPE_CODE | VARCHAR2 | 30 | Invoice record type. Possible values are Outbound and Inbound. | ||
| FIRST_PTY_REG_NUM | VARCHAR2 | 150 | Yes | First party tax registration number for the transaction. | |
| THIRD_PTY_REG_NUM | VARCHAR2 | 150 | Third party tax registration number for the transaction. | ||
| TAX_INVOICE_NUMBER | VARCHAR2 | 150 | Yes | Tax invoice number for the transaction. | |
| TAX_INVOICE_DATE | DATE | Tax invoice date for the transaction. | |||
| ORIGINAL_TAX_INVOICE_NUMBER | VARCHAR2 | 150 | Original tax invoice number for the transaction. | ||
| ORIGINAL_TAX_INVOICE_DATE | DATE | Original tax invoice date for the transaction. | |||
| DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | Invoice document type. Possible values are Tax invoice and Delivery challan. | ||
| SUPPLY_TYPE_CODE | VARCHAR2 | 30 | Type of supply. Possible values are B2B for Business to Business, SEZWP for SEZ with payment, SEZWOP for SEZ without payment, EXPWP for Export with Payment, EXPWOP for Export without payment, and DEXP for Deemed Export. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Financial tax period name on the invoice. | ||
| INVOICE_REFERENCE_NUMBER | VARCHAR2 | 150 | Invoice reference number for the invoice. | ||
| BATCH_NAME | VARCHAR2 | 80 | Request batch name of the invoice reference number generation process. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: Indicates the request ID of the interface load job that created the row. | ||
| BILL_TYPE_CODE | VARCHAR2 | 30 | Type of bill. Possible values are Shipping bill number and E-WAY bill number. | ||
| BILL_NUMBER | VARCHAR2 | 30 | E-WAY bill or shipping bill number. | ||
| BILL_DATE | DATE | E-WAY bill or shipping bill date. | |||
| QR_CODE_RESPONSE | CLOB | QR code response for the invoice. | |||
| ERROR_MESSAGE | VARCHAR2 | 1000 | Invoice reference number error details. | ||
| ACKNOWLEDGMENT_NUMBER | VARCHAR2 | 120 | Acknowledgment number for the invoice reference number generation process. | ||
| ACKNOWLEDGMENT_DATE | DATE | Acknowledgment date for the invoice reference number generation process. | |||
| STATUS_CODE | VARCHAR2 | 10 | Invoice reference number status. | ||
| ERROR_CODE | VARCHAR2 | 10 | Invoice reference number error code. | ||
| 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. | |
| SHIPPING_REFERENCE_NUMBER | VARCHAR2 | 150 | Shipping reference number for the tax invoice number or the invoice reference number. | ||
| SHIPPING_REFERENCE_DATE | DATE | Shipping reference date for the tax invoice number or the invoice reference number. | |||
| SELLING_REFERENCE_NUMBER | VARCHAR2 | 150 | Seller reference number for the tax invoice number or the invoice reference number. | ||
| BUYER_REFERENCE_NUMBER | VARCHAR2 | 150 | Buyer reference number for the tax invoice number or the invoice reference number. | ||
| ADDITIONAL_REFERENCE_NUMBER | VARCHAR2 | 150 | Additional reference number provided by the tax authority. | ||
| ADDITIONAL_REFERENCE_DATE | DATE | Additional reference date provided by the tax authority. | |||
| DISPATCH_REFERENCE_NUMBER | VARCHAR2 | 150 | Dispatch reference number related to the tax invoice number or the invoice reference number. | ||
| DISPATCH_REFERENCE_DATE | DATE | Dispatch date of the shipment related to the tax invoice number or the invoice reference number. | |||
| 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. | ||
| 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_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. | |||
| 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 |
|---|---|---|---|
| JG_TAX_INVOICE_REFERENCES_N1 | Non Unique | FUSION_TS_TX_DATA | FIRST_PTY_REG_NUM, PERIOD_NAME, TAX_INVOICE_NUMBER |
| JG_TAX_INVOICE_REFERENCES_N2 | Non Unique | FUSION_TS_TX_DATA | TRX_ID, APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE |
| JG_TAX_INVOICE_REFERENCES_U1 | Unique | FUSION_TS_TX_DATA | DOCUMENT_ID |