1. Tables and Views for SCM
  2. CMF_FISCAL_DOC_HEADERS

CMF_FISCAL_DOC_HEADERS

This table will store Fiscal Document Header information.

Details

  • Schema: FUSION

  • Object owner: CMF

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

CMF_FISCAL_DOC_HEADERS_PK

DOCUMENT_HEADER_ID

Columns

Name Datatype Length Precision Not-null Comments Status
DOCUMENT_HEADER_ID NUMBER 18 Yes Surrogate key that identifies the Fiscal Document.
INVOICE_ID NUMBER 18 Invoice identifier to uniquely identify the invoice.
INVOICE_NUM VARCHAR2 50 Invoice number generated by the fiscal document.
SOURCE_REF_DOC_HEADER_ID NUMBER 18 Identifies the source document related to this fiscal document header. Example: shipment header indicating the ASN/ASNB for drop ship seller flow or consumption advice header for consigned flow.
INTERFACED_FLAG VARCHAR2 1 Flag to determine the source of the Fiscal Document. Values: 'Y' - XML Interfaced FDs 'N' - Manually created FDs
PARENT_DOCUMENT_HEADER_ID NUMBER 18 Identifier of header of Parent Fiscal Document.
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.
DOCUMENT_NUMBER VARCHAR2 30 Yes Number for the Fiscal Document given on the Fiscal Document sent by the Supplier.
ACCESS_KEY_NUMBER VARCHAR2 64 Access Key number generated by issuer for each electronic fiscal document /electronic freight fiscal document.
ISSUE_DATE DATE Yes Issue Date of fiscal document. For manual entry will be informed when creating a fiscal document. When the document is launched from XML this attribute will be filled automatically and will be read only when editing FD. Issue Date cannot be greater than current date.
ACKNOWLEDGED_DATE DATE Date on which the Fiscal Document is acknowledged into the System. Active
MODEL VARCHAR2 30 Yes Model of fiscal document. Options are: 1-Fiscal document. 6-Electric power FD or bill. 7-Transport service FD. 8-Road bill of lading. 9-Waterway bill of lading. 10-Airway bill. 11-Rail bill of lading. 21-Communication service FD. 22-Telecommunications service FD. 26-Transport multimodal of cargo. 27-Rail service FD. 28-Piped gas FD. 29-Piped water FD. 55-Electronic fiscal document. 57-Electronic bill of lading. Active
SERIES VARCHAR2 10 Yes Series of fiscal document. For manual entry will be given when editing a fiscal document. Use values for FD Process and FD Type to go to Process Options Table and get value for Electronic Models and Series Required column. If Series Required is NOT USED then the attribute is blocked from user access. As it is a mandatory attribute let us assume 0(zero) as default value for this case. If user enters a model that is one of the models of the Electronic Models list and Series Required is ELECTRONIC or ALL then series is mandatory. If user entered model is NOT in the list of Electronic Models and Series Required is ALL or NOT ELECTRONIC then series is mandatory. Active
SUBSERIES VARCHAR2 10 Number of the freight fiscal document sub-series. Active
SOURCE_DOCUMENT_TYPE VARCHAR2 30 Yes The document type for which Fiscal Document is captured or created. The document type indicates the business flow for which a Fiscal Document is captured. The look up value for source document type will include: - Purchase Order - RMA - Internal Requisition - Consignment PO - Standard Fiscal Document (when complementary FD) Active
DOCUMENT_TYPE VARCHAR2 30 Yes The type of Fiscal Document that is sent by supplier or party for capturing and processing indicating the business flow it covers. Logical Entity Fiscal Document Type will indicate the possible types of Fiscal Documents that can be received namely, - Standard Fiscal Document - Complementary FD - Freight FD - Remittance FD - Symbolic Remittance FD Active
ISSUER_TAX_ID NUMBER 18 Yes Taxpayer Id of the company which creates the FD. The issuer can be a Supplier or Customer (when outbound document) or Inventory Organization (when inbound document). Will be informed when creating FD (Manage Fiscal Documents) and ready only when editing FD.
ISSUER_PARTY_ID NUMBER 18 Yes Identifier of the company which creates the FD.
ISSUER_PARTY_SITE_ID NUMBER 18 Yes Identifier of the company site which creates the FD.
ISSUER_LOCATION_ID NUMBER 18 Yes Identifier of the company site location which creates the FD.
COUNTRY_CODE VARCHAR2 2 This field is used to store issuer country code.
RECEIVER_TAX_ID NUMBER 18 Taxpayer Id of document receiver. For Operation Type = outbound the receiver is the legal entity (company name) which is receiving the FD. For Operation Type = inbound the receiver is the company that the issuer creates the FD on behalf. (TCA party name).
RECEIVER_PARTY_ID NUMBER 18 Yes Identifier of the company which receives the FD.
RECEIVER_PARTY_SITE_ID NUMBER 18 Yes Identifier of the company site which receives the FD.
RECEIVER_LOCATION_ID NUMBER 18 Yes Identifier of the company site location which receives the FD.
SHIPTO_TAX_ID NUMBER 18 Yes Stores the Ship-To Taxpayer identifier.
SHIPTO_PARTY_ID NUMBER 18 Yes Identifier of the company which receives the material.
SHIPTO_PARTY_SITE_ID NUMBER 18 Yes Identifier of the company site which receives the material.
SHIPTO_LOCATION_ID NUMBER 18 Yes Identifier of the company site location which receives the FD.
SHIPFROM_TAX_ID NUMBER 18 Taxpayer Id of the third party where the goods are shipped from.
SHIPFROM_PARTY_ID NUMBER 18 Yes Identifier of the company which ships the material.
SHIPFROM_PARTY_SITE_ID NUMBER 18 Yes Identifier of the company site which ships the material.
SHIPFROM_LOCATION_ID NUMBER 18 Yes Identifier of the company site location which ships the material.
SHIPFROM_IBGE_CITY_CODE VARCHAR2 360 Stores the value of city code which ships the material.
SHIPFROM_IBGE_CITY_ID NUMBER 18 Identifier of the city which ships the material.
SHIPTO_IBGE_CITY_CODE VARCHAR2 360 Stores the value of city code which receives the material.
SHIPTO_IBGE_CITY_ID NUMBER 18 Identifier of the city which receives the material.
CURRENCY VARCHAR2 30 Yes Currency of Fiscal Document. Options: BRL - Brazilian Real.
CONVERSTION_TYPE VARCHAR2 30 Yes Type of conversion from GL. Only when currency different from functional currency. For XML launching it will be informed during the Import UI. For manual entry it will be informed manually when creating fiscal document. In case the functional currency of Set of Books and FD currency are the same this will be not required.
CONVERSION_RATE NUMBER Rate of conversion to the currency of source document (PO, RMA, Internal Requisition)
TOTAL_AMOUNT NUMBER Yes Fiscal Document Header Amount for this Fiscal Document record
ITEM_LINE_AMOUNT NUMBER Yes Total amount of goods or service (under incidence or taxed by ICMS) without accessory expenses. Sum of total line amount of goods or services under incidence or taxed by ICMS (quantity x unit price) For SPED reporting.
OPERATION_TYPE VARCHAR2 30 Yes Type of fiscal document operation. For SPED Reporting and as base of entire FDC logic. Options are: 0-Inbound (when the BU issue the FD on behalf of TCA). 1-Outbound (when the TCA party issue an FD). Will be informed when creating FD (Manage Fiscal Documents) and ready only when editing FD.
DOCUMENT_STATUS VARCHAR2 30 Yes The document status for the Fiscal Document Header. It can have following values: - New - Open - Cancelled - Closed
VALIDATION_STATUS VARCHAR2 30 The validation status of Fiscal Document. It can have following values: - Never Validated - Pre-Validated - Validated - Needs Revalidation
REFERENCED_STATUS VARCHAR2 30 The Referenced status for the Fiscal Document. It can have following values: - Not Required - Referenced - Not Referenced
CHARGE_ALLOCATION_STATUS VARCHAR2 30 Yes The Allocation status for the Fiscal Document. It can have following values: - Completed (Completed when all charge lines have been allocated to Item Lines) - Pending (At least one of the Charge lines is pending for allocation) - New (Not even one charge line is allocated)
REASON VARCHAR2 30 Fiscal Document Status change reason.
TAX_CALCULATION_STATUS VARCHAR2 30 The Tax Calculation status for the Fiscal Document. It can have following values: - Completed (Tax computation is done for all the lines) - Pending (Tax computation is not done at-least for one charge line) - New (Tax Computation not yet started)
SCHEDULES_ALLOCATED_FLAG VARCHAR2 1 Yes Indicates whether the fiscal document line amounts were allocated to the schedules level by received quantity. The allocated amounts are stored in table CMF_FISCAL_DOC_SCHED_ASSOC.
CMR_INTERFACED_FLAG VARCHAR2 1 Indicates whether the fiscal document was interfaced to receipt accounting.
INVOICE_INTERFACED_FLAG VARCHAR2 1 Indicates whether the fiscal document was interfaced to payables.
BILL_TO_BUSINESS_UNIT_ID NUMBER 18 Yes User will be able to choose the right Bill to BU based on the security access. This attribute is mandatory to be entered by the user when creating the FD
SOLD_TO_LEGAL_ENTITY_ID NUMBER 18 Yes Sold to Legal Entity unique identifier. Indicates the party which is financially responsible for the purchases on a purchase order.
FISCAL_DOC_ASSOCTNS_ID NUMBER 18 Yes Its association identifier which associates the Fiscal Document with a FD Process/Type.
FISCAL_PROC_OPTIONS_ID NUMBER 18 Yes This is the reference with Process Option that defines the FD type and process.
EXTERNAL_SYSTEM_REFERENCE VARCHAR2 240 Is used for backend processing based on the interface records.
EXTERNAL_SYSTEM_REF_ID VARCHAR2 30 Is used for backend processing based on the interface records.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
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
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE_CHAR1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR20 VARCHAR2 150 Descriptive Flexfield: segment 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_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER10 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
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active

Foreign Keys

Table Foreign Table Foreign Key Column
cmf_fiscal_doc_sched_assoc cmf_fiscal_doc_headers DOCUMENT_HEADER_ID
cmr_fiscal_document_details cmf_fiscal_doc_headers FD_HEADER_ID

Indexes

Index Uniqueness Tablespace Columns
CMF_FISCAL_DOC_HEADERS_PK Unique Default DOCUMENT_HEADER_ID
CMF_FISCAL_DOC_HEADERS_U1 Unique Default DOCUMENT_NUMBER, SERIES, SUBSERIES, ISSUE_DATE, ISSUER_TAX_ID
CMF_FISCAL_DOC_HEADERS_U2 Unique Default ACCESS_KEY_NUMBER