1. Tables and Views for SCM
  2. CMF_FD_HEADERS_INT

CMF_FD_HEADERS_INT

Stores the interface headers information of the Fiscal Documents.

Details

  • Schema: FUSION

  • Object owner: CMF

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

CMF_FD_HEADERS_INT_PK

FD_HEADERS_INT_ID

Columns

Name Datatype Length Precision Not-null Comments Status
FD_HEADERS_INT_ID NUMBER 18 Yes Stores the unique key which identifies the row. Active
SOURCE_REF_DOC_HEADER_ID NUMBER 18 Identifies the source document header for the fiscal document. Example: shipment header for the ASN/ASBN associated with drop ship seller flow, consumption advice header for the consigned flow etc.
SOLD_TO_LE_ID NUMBER 18 Stores the Sold to LE Identifier Id.
SHIPFROM_TAXPAYER_ID VARCHAR2 64 Taxpayer ID of the company which ships the material.
SHIPTO_TAXPAYER_ID VARCHAR2 64 Taxpayer ID of the company which receives the material.
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 Fiscal Document status for taxes calculation before 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
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 VARCHAR2 64 Stores the Number of Fiscal Document. Active
SERIES VARCHAR2 64 Stores the Series of Fiscal Document. Active
SUBSERIES VARCHAR2 64 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 VARCHAR2 64 Taxpayer ID of the company which creates the FD. Active
ISSUER_NAME VARCHAR2 360 Name of the company which creates the FD. Active
ISSUER_ADDRESS VARCHAR2 4000 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_CITY_NAME VARCHAR2 60 Address city name of the company which creates the FD. Active
ISSUER_ADDRESS_CITY_CODE VARCHAR2 64 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 VARCHAR2 64 Address Zip Code of the company which creates the FD. Active
RECEIVER_TAXPAYER_ID VARCHAR2 64 Taxpayer ID of the company which receives the FD. Active
RECEIVER_NAME VARCHAR2 360 Name of the company which receives the FD. Active
RECEIVER_ADDRESS VARCHAR2 4000 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_CITY_NAME VARCHAR2 60 Address city name of the company which receives the FD. Active
RECEIVER_ADDRESS_CITY_CODE VARCHAR2 64 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 VARCHAR2 64 Address Zip Code 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_ADDRESS VARCHAR2 4000 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_CITY_NAME VARCHAR2 60 Address city name of the company location where the goods will be delivered. Active
SHIP_TO_ADDRESS_CITY_CODE VARCHAR2 64 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 VARCHAR2 64 Address Zip Code of the company location where the goods will be delivered. Active
SHIP_FROM_ADDRESS VARCHAR2 4000 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_ADDR_COMPLEMENT VARCHAR2 60 Address complement 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 VARCHAR2 64 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 VARCHAR2 64 Address Zip Code of 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
USAGE_AUTHORIZATION VARCHAR2 64 Stores the code that indicates whether FD is authorized to use Active
ISSUER_PARTY_TYPE VARCHAR2 20 Indicates whether the company which created the FD is a third or first party. Active
RECEIVER_PARTY_TYPE VARCHAR2 20 Indicates whether the company which receives the FD is a third or first party. Active
SHIP_FROM_PARTY_TYPE VARCHAR2 20 Indicates whether the company where the goods will be withdrawn is a third or first party. Active
SHIP_TO_PARTY_TYPE VARCHAR2 20 Indicates whether the company where the goods are delivered is a third or first party.
BILL_TO_BU_ID NUMBER 18 Stores the Bill to Business Unit Identifier Id. Active
COUNTRY_CODE VARCHAR2 2 This is the country information related to the fiscal document origin. Active
FISCAL_DOC_ASSOCTNS_ID NUMBER 18 It associated the Fiscal Document with a FD Process/Type.
FISCAL_PROC_OPTIONS_ID NUMBER 18 This is the reference with Process Option that defines the FD type and process.
ISSUER_TAX_ID NUMBER 18 Stores the Issuer Taxpayer Identifier ID.
ISSUER_PARTY_ID NUMBER 18 Identifier of the company which creates the FD.
ISSUER_PARTY_SITE_ID NUMBER 18 Identifier of the company site which creates the FD.
ISSUER_LOCATION_ID NUMBER 18 Identifier of the company site location which creates the FD.
RECEIVER_PARTY_ID NUMBER 18 Identifier of the company which receives the FD.
RECEIVER_PARTY_SITE_ID NUMBER 18 Identifier of the company site which receives the FD.
RECEIVER_LOCATION_ID NUMBER 18 Identifier of the company site location which receives the FD.
SHIPFROM_NAME VARCHAR2 360 Name of the company from where the goods getting shipped.
SHIPFROM_TAX_ID NUMBER 18 Stores the Ship-from Taxpayer Identifier ID.
SHIPFROM_PARTY_ID NUMBER 18 Identifier of the company which ships the material.
SHIPFROM_PARTY_SITE_ID NUMBER 18 Identifier of the company site which ships the material.
SHIPFROM_LOCATION_ID NUMBER 18 Identifier of the company site location which ships the material.
SHIPTO_NAME VARCHAR2 360 Name of the company to where the goods getting shipped.
SHIPTO_TAX_ID NUMBER 18 Stores the Ship-to Taxpayer Identifier ID.
SHIPTO_PARTY_ID NUMBER 18 Identifier of the company which receives the material.
SHIPTO_PARTY_SITE_ID NUMBER 18 Identifier of the company site which receives the material.
SHIPTO_LOCATION_ID NUMBER 18 Identifier of the company site location which receives the material.
SHIPFROM_IBGE_CITY_ID NUMBER 18 Identifier of the city which ships the material.
SHIPTO_IBGE_CITY_ID NUMBER 18 Identifier of the city which receives the material.

Indexes

Index Uniqueness Tablespace Columns Status
CMF_FD_HEADERS_INT_U1 Unique FUSION_TS_TX_DATA FD_HEADERS_INT_ID Active