1. Tables and Views for Financials
  2. JG_FSCL_DOC_RELATIONS_ALL

JG_FSCL_DOC_RELATIONS_ALL

This table stores one or more fiscal documents details that are generated for one transaction in Fusion e.g. in drop ship case, two fiscal documents are generated corresponding to one shipment by the party shipping the goods.

Details

  • Schema: FUSION

  • Object owner: JG

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

JG_FSCL_DOC_RELATIONS_PK

DOC_RELATION_ID

Columns

Name Datatype Length Precision Not-null Comments Status
DOC_RELATION_ID NUMBER 18 Yes Document relation identifier of the transaction. Active
FISCAL_DOC_KEY VARCHAR2 64 Yes Indicates the fiscal document access key composed by adding the fiscal document number and other fiscal document information for Goods and Regular Service Fiscal Documents. For National Service Fiscal Documents, this column stores the provisional service document key by adding the provisional service document number and other fiscal document information. It is used as unique identifier for the tax authority system. Active
FISCAL_DOC_TYPE VARCHAR2 30 Yes Fiscal document type of the transaction. Possible values are Remittance Fiscal Document, Symbolic Remittance Fiscal Document, and Sale Fiscal Document. Active
DOC_HDR_ID NUMBER 18 Yes Document header identifier of the transaction. Active
APPLICATION_ID NUMBER 18 Yes Identifier of a functional area within a software suite of products. For example: Financials, or Payroll. Active
ENTITY_CODE VARCHAR2 30 Yes Entity code of the transaction, which indicates the type of transaction being created. Active
EVENT_CLASS_CODE VARCHAR2 30 Yes Application event class of the transaction, such as requisition, purchase order and agreement, and release. Active
TRX_ID NUMBER 18 Yes System-generated identification number of a transaction. Active
DOC_NUM NUMBER 18 Unique number that is assigned to a document, such as fiscal document number or tax invoice number. Active
SERIES VARCHAR2 10 Tax document series, to be filled with zero when there is no series. Active
FISCAL_DOC_DATE DATE Yes The date the transaction occurred. Active
MODEL VARCHAR2 3 Model for the fiscal document associated with the transaction. For example, 1, 1A, 55. Active
DELIVERY_NOTE_PRINTING_FORMAT VARCHAR2 30 Delivery note printing format with valid values such as 1 for portrait or 2 for landscape. Active
DOC_ISSUE_TYPE VARCHAR2 30 Fiscal document issue type with valid values such as 1 standard or 2 contingency. Active
DOC_NATURE VARCHAR2 30 Fiscal document nature. Possible values are 1 for standard, 2 for complementary, and 3 for adjustment. Active
DOC_GEN_PROCESS VARCHAR2 30 Fiscal document generation process. Possible values are 0 for issuance with taxpayer application, 1 for single issuance by the Revenue Bureau, 2 for single issuance by the taxpayer with digital certificate through the Revenue Bureaus website. Active
CONTINGENCY_DATE DATE Date and hour of entry in contingency with format YYYY-MM-DDTHH:MM:SS. Active
CONTINGENCY_JUSTIFICATION VARCHAR2 240 Justification for entry in contingency. Active
VOID_DATE DATE Date when transaction is cancelled or marked as void. Active
STATUS VARCHAR2 30 Fiscal document status associated with the transaction, such as in process, sent, finalized, error, denied or void. Active
REJECTION_REASON VARCHAR2 240 Reason provided by tax authority when fiscal document status is "Denied". Possible values include "Error access key - field identifier does not match the concatenation of the corresponding fields" or "The version of the layout used and is no longer valid". Active
REF_DOC_HDR_ID NUMBER 18 Reference document header identifier. Active
REF_DOC_NUM NUMBER 18 Reference document number of the tranaction. Active
REF_FISCAL_DOC_KEY VARCHAR2 50 Key identifier for a reference fiscal document. Active
REF_FISCAL_DOC_DATE DATE Date on which the reference transaction occurred. Active
REF_MODEL VARCHAR2 3 Model for the fiscal document associated with the reference transaction. Active
REF_SERIES VARCHAR2 10 Tax document series of the reference document. Active
REF_ISSUER_TAXPAYER_ID VARCHAR2 30 Tax registration identifier for the reference document taxpayer. Active
REF_RURAL_FLAG VARCHAR2 1 Checkbox that Identifies whether the reference document was issued in rural area. Active
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
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. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
REFERENCE_RECORD_TYPE VARCHAR2 30 Identification of reference record. Valid value are 0 for original document, 1 for reference document with internal reference, and 2 for reference with external document. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
RPS_NUMBER NUMBER Number of provisional receipt for services sent to the city tax authority.
SRVC_INVOICE_VERIFICATION_CODE VARCHAR2 255 Verification code of the fiscal document for a service invoice.
VOID_REASON VARCHAR2 240 Reason provided by the user for setting the transaction status as void.
CANCEL_REASON VARCHAR2 240 Reason provided by the user for setting the transaction status as cancelled.
CONTINGENCY_TYPE VARCHAR2 2 Fiscal document contingency type with valid values, such as Security form, Contingency system of national environment, and Declaration of issuance provided in the contingency.
DOC_LINE_ID NUMBER 18 Yes Document line identifier of the transaction.
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.
TAX_INVOICE_NUMBER_FLAG VARCHAR2 1 For multiple fiscal documents against a single transaction, track the fiscal document that is used as a tax invoice number in Oracle Fusion Receivables. Valid values are Y and N.
CONTINGENCY_SERIES NUMBER 18 Fiscal document series for contingency fiscal documents.
SENDING_FILE_NAME VARCHAR2 60 Name of the file used to request approval from tax authority during fiscal document generation process.
RECEIVED_FILE_NAME VARCHAR2 60 Name of the file received from tax authority during fiscal document generation process.
REF_DOC_ISSUER_STATE_CODE VARCHAR2 30 State code for the reference document issuer.
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 payment of taxes.
LEGAL_REPORTING_UNIT_ID NUMBER 18 Identifier of the first party associated with the transaction.
PREVIOUS_FISCAL_DOC_KEY1 VARCHAR2 64 This will be used to store the fiscal_doc_key that is getting updated to TEMPID-ERROR in case of status error during first iteration
PREVIOUS_FISCAL_DOC_KEY2 VARCHAR2 64 This will be used to store the fiscal_doc_key that is getting updated to TEMPID-ERROR in case of status error during second iteration
NATIONAL_SERVICE_FSCL_DOC_KEY VARCHAR2 80 Indicates the National Service Fiscal Document Key
CANCEL_REASON_CODE VARCHAR2 30 Indicates the Cancel Reason code you provided when setting the transaction status as cancelled

Indexes

Index Uniqueness Tablespace Columns Status
JG_FSCL_DOC_RELATIONS_N1 Non Unique Default DOC_NUM, LEGAL_REPORTING_UNIT_ID
JG_FSCL_DOC_RELATIONS_N2 Non Unique Default RPS_NUMBER
JG_FSCL_DOC_RELATIONS_N3 Non Unique Default REQUEST_ID
JG_FSCL_DOC_RELATIONS_N4 Non Unique Default TRX_ID, ORG_ID, EVENT_CLASS_CODE
JG_FSCL_DOC_RELATIONS_N5 Non Unique Default FISCAL_DOC_DATE
JG_FSCL_DOC_RELATIONS_N6 Non Unique JG_FSCL_DOC_RELATIONS_N6 STATUS, ORG_ID, LEGAL_REPORTING_UNIT_ID
JG_FSCL_DOC_RELATIONS_N7 Non Unique Default NATIONAL_SERVICE_FSCL_DOC_KEY
JG_FSCL_DOC_RELATIONS_U1 Unique FUSION_TS_TX_IDX DOC_RELATION_ID Active
JG_FSCL_DOC_RELATIONS_U3 Unique FUSION_TS_TX_IDX FISCAL_DOC_KEY, FISCAL_DOC_TYPE, APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID Active