1. Tables and Views for SCM
  2. CMF_I_FD_HEADERS_GT

CMF_I_FD_HEADERS_GT

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_FD_HEADERS_GT_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
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
DOCUMENT_HEADER_ID NUMBER 18 Stores the foreign key which identifies the FD Header row. 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_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_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_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_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 30 Stores the Status of the validation results of the current entity. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.

Indexes

Index Uniqueness Columns Status
CMF_I_FD_HEADERS_GT_U1 Unique EFD_INTERFACE_HEADER_ID Active