1. Tables and Views for SCM
  2. CMF_I_FISCAL_DOC_HEADERS

CMF_I_FISCAL_DOC_HEADERS

Stores the Interface Headers Information of the FISCAL Documents.

Details

  • Schema: FUSION

  • Object owner: CMF

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CMF_I_FISCAL_DOC_HEADERS_PK

EFD_INTERFACE_HEADER_ID

Columns

Name Datatype Length Precision Not-null Comments Status
EFD_INTERFACE_HEADER_ID NUMBER 18 Yes Stores the Unique key which identifies the row. Active
DOCUMENT_HEADER_ID NUMBER 18 Stores the foreign key which identifies the FD Header 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
IMPORTING_STATUS VARCHAR2 30 Stores the Status of the XML importing Process. Active
JG_STATUS VARCHAR2 30 Status of the FISCAL Interface Record. Active
ZX_STATUS VARCHAR2 30 Status of the Tax Interface Record. Active
ACKNOWLEDGED_DATE TIMESTAMP Stores the Date of acknowledgement of the FISCAL Document. Active
CURRENCY VARCHAR2 30 Stores the Currency used in the FISCAL Document. Active
DOCUMENT_STATUS VARCHAR2 30 Stores the Document Status before the persistence. Active
CHARGE_ALLOCATION_STATUS VARCHAR2 30 Stores the Document Charge Allocation Status before the persistence. Active
TAX_CALCULATION_STATUS VARCHAR2 30 Stores the Document Status for taxes calculation defore the persistence. Active
REFERENCED_STATUS VARCHAR2 30 Reflect if the document is referenced in another one. Active
APPROVED_STATUS VARCHAR2 30 Stores the Approval status of the document. Active
DOCUMENT_TYPE VARCHAR2 30 Keeps the FISCAL Document Type Information. Active
SOURCE_DOCUMENT_TYPE VARCHAR2 30 Document type for source document. Active
SOURCE_DOC_CURRENCY_CODE VARCHAR2 30 Currency code used in source document. Active
SOURCE_DOC_CUR_CONVERSION_TYPE VARCHAR2 30 Currency conversion type used in source document. Active
ACCESS_KEY_NUMBER VARCHAR2 64 Access Key number generated by issuer for each Fiscal Document. Active
OPERATION_TYPE VARCHAR2 30 Type of FISCAL Document operation. Active
DOCUMENT_NUMBER NUMBER 9 Stores the Number of FISCAL Document. Active
SERIES NUMBER 9 Stores the Series of FISCAL Document. Active
SUBSERIES NUMBER 9 Subseries of referenced freight FISCAL Document. Active
MODEL VARCHAR2 64 Stores the Model of FISCAL Document. Active
ISSUE_DATE TIMESTAMP Stores the Issue date of FISCAL Document. Active
TOTAL_AMOUNT NUMBER Stores the FISCAL Document Header Amount. Active
ITEM_LINE_TOTAL NUMBER Total amount of goods or service (under incidence or taxed by ICMS) without accessory expenses. Active
ISSUER_TAXPAYER_ID NUMBER 18 Taxpayer Id of the company which creates the FD. Active
ISSUER_NAME VARCHAR2 60 Name of the company which creates the FD. Active
ISSUER_ADDRESS VARCHAR2 60 Address street of the company which creates the FD. Active
ISSUER_ADDRESS_NUMBER VARCHAR2 60 Address number of the company which creates the FD. Active
ISSUER_ADDRESS_COMPLEMENT VARCHAR2 60 Address complement of the company which creates the FD. Active
ISSUER_ADDRESS_ZONE VARCHAR2 60 Address Zone of the company which creates the FD. Active
ISSUER_ADDRESS_CITY_NAME VARCHAR2 60 Address city name of the company which creates the FD. Active
ISSUER_ADDRESS_CITY_CODE NUMBER 7 Address City IBGE Code of the company which creates the FD. Active
ISSUER_ADDRESS_STATE VARCHAR2 2 Address State of the company which creates the FD. Active
ISSUER_ADDRESS_ZIP_CODE NUMBER 8 Address Zip Code of the company which creates the FD. Active
ISSUER_ID NUMBER 18 Identifier of the company which creates the FD. Active
ISSUER_ADDRESS_ID NUMBER 18 Identifier for the address of the company which creates the FD. Active
RECEIVER_TAXPAYER_ID NUMBER 18 Taxpayer Id of the company which receives the FD. Active
RECEIVER_NAME VARCHAR2 60 Name of the company which receives the FD. Active
RECEIVER_ADDRESS VARCHAR2 60 Address street of the company which receives the FD. Active
RECEIVER_ADDRESS_NUMBER VARCHAR2 60 Address number of the company which receives the FD. Active
RECEIVER_ADDRESS_COMPLEMENT VARCHAR2 60 Address complement of the company which receives the FD. Active
RECEIVER_ADDRESS_ZONE VARCHAR2 60 Address Zone of the company which receives the FD. Active
RECEIVER_ADDRESS_CITY_NAME VARCHAR2 60 Address city name of the company which receives the FD. Active
RECEIVER_ADDRESS_CITY_CODE NUMBER 7 Address City IBGE Code of the company which receives the FD. Active
RECEIVER_ADDRESS_STATE VARCHAR2 2 Address State of the company which receives the FD. Active
RECEIVER_ADDRESS_ZIP_CODE NUMBER 8 Address Zip Code of the company which receives the FD. Active
RECEIVER_ID NUMBER 18 Identifier of the company which receives the FD. Active
RECEIVER_ADDRESS_ID NUMBER 18 Identifier of address of the company which receives the FD. Active
RECEIVER_TAX_ID NUMBER 18 Tax identifier of the company which receives the FD. Active
SHIP_TO_TAXPAYER_ID NUMBER 18 Taxpayer Id of the company location where the goods will be delivered. Active
SHIP_TO_ADDRESS VARCHAR2 60 Address street of the company location where the goods will be delivered. Active
SHIP_TO_ADDRESS_NUMBER VARCHAR2 60 Address number of the company location where the goods will be delivered. Active
SHIP_TO_ADDRESS_COMPLEMENT VARCHAR2 60 Address complement of the company location where the goods will be delivered. Active
SHIP_TO_ADDRESS_ZONE VARCHAR2 60 Address Zone of the company location where the goods will be delivered. Active
SHIP_TO_ADDRESS_CITY_NAME VARCHAR2 60 Address city name of the company location where the goods will be delivered. Active
SHIP_TO_ADDRESS_CITY_CODE NUMBER 7 Address City IBGE Code of the company location where the goods will be delivered. Active
SHIP_TO_ADDRESS_STATE VARCHAR2 2 Address State of the company location where the goods will be delivered. Active
SHIP_TO_ADDRESS_ZIP_CODE NUMBER 8 Address Zip Code of the company location where the goods will be delivered. Active
SHIP_TO_LOCATION_ADDRESS_ID NUMBER 18 Location of the company location where the goods will be delivered. Active
SHIP_TO_LOCATION_TAX_ID NUMBER 18 Tax identifier for the location of the company location where the goods will be delivered. Active
SHIP_FROM_TAXPAYER_ID NUMBER 18 Taxpayer Id of the company location where the goods will be withdrawn. Active
SHIP_FROM_ADDRESS VARCHAR2 60 Address street of the location where the goods will be withdrawn. Active
SHIP_FROM_ADDRESS_NUMBER VARCHAR2 60 Address number of the location where the goods will be withdrawn. Active
SHIP_FROM_ADDRESS_COMPLEMENT VARCHAR2 60 Address complement of the location where the goods will be withdrawn. Active
SHIP_FROM_ADDRESS_ZONE VARCHAR2 60 Address Zone of the location where the goods will be withdrawn. Active
SHIP_FROM_ADDRESS_CITY_NAME VARCHAR2 60 Address city of the location where the goods will be withdrawn. Active
SHIP_FROM_ADDRESS_CITY_CODE NUMBER 7 Address City IBGE Code of the location where the goods will be withdrawn. Active
SHIP_FROM_ADDRESS_STATE VARCHAR2 2 Address State of the location where the goods will be withdrawn. Active
SHIP_FROM_ADDRESS_ZIP_CODE NUMBER 8 Address Zip Code of the location where the goods will be withdrawn. Active
SHIP_FROM_ADDRESS_ID NUMBER 18 Identifier for the address of the location where the goods will be withdrawn. Active
SHIP_FROM_TAX_ID NUMBER 18 Tax identifier for the location where the goods will be withdrawn. Active
FREIGHT_AMOUNT NUMBER Stores the Total amount of freight. Active
INSURANCE_AMOUNT NUMBER Stores the Total amount of insurance. Active
OTHER_EXPENSES_AMOUNT NUMBER Stores the Total amount of other expenses. Active
DISCOUNT_AMOUNT NUMBER Stores the Total amount of discount. Active
ISSUING_PURPOSE VARCHAR2 30 Purpose of the FISCAL Document. Active
VALIDATION_STATUS VARCHAR2 10 Stores the Status of the validation results of the current entity. Active
EXTERNAL_SYSTEM_REFERENCE VARCHAR2 240 Is used for backend processing based on the interface records. Active
EXTERNAL_SYSTEM_REF_ID VARCHAR2 30 Is used for backend processing based on the interface records. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. 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
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
APROVED_STATUS VARCHAR2 30 Stores the Approval status of the document. Active

Foreign Keys

Table Foreign Table Foreign Key Column
cmf_i_fiscal_doc_ref_attr cmf_i_fiscal_doc_headers EFD_INTERFACE_HEADER_ID
cmf_i_legal_doc_assoc cmf_i_fiscal_doc_headers EFD_INTERFACE_HEADER_ID
cmf_i_fiscal_doc_lines cmf_i_fiscal_doc_headers EFD_INTERFACE_HEADER_ID

Indexes

Index Uniqueness Tablespace Columns Status
CMF_I_FISCAL_DOC_HEADERS_U1 Unique FUSION_TS_TX_DATA EFD_INTERFACE_HEADER_ID Active