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