CREATE TABLE cmf_fd_headers_int_gt (
    FD_HEADERS_INT_ID              NUMBER(18, 0) ,
    DOCUMENT_HEADER_ID             NUMBER(18, 0) ,
    DOCUMENT_NUMBER                VARCHAR2(256) ,
    ACCESS_KEY_NUMBER              VARCHAR2(256) ,
    BILL_TO_BU_ID                  NUMBER(18, 0) ,
    SOLD_TO_LE_ID                  NUMBER(18, 0) ,
    FISCAL_DOC_ASSOCTNS_ID         NUMBER(18, 0) ,
    FISCAL_PROC_OPTIONS_ID         NUMBER(18, 0) ,
    IMPORTING_STATUS               VARCHAR2(120) ,
    DOCUMENT_STATUS                VARCHAR2(120) ,
    ISSUER_PARTY_TYPE              VARCHAR2(80)  ,
    RECEIVER_PARTY_TYPE            VARCHAR2(80)  ,
    SHIP_FROM_PARTY_TYPE           VARCHAR2(80)  ,
    SHIP_TO_PARTY_TYPE             VARCHAR2(120) ,
    ISSUING_PURPOSE                VARCHAR2(120) ,
    TYPE_OF_DEBIT                  VARCHAR2(40)  ,
    TYPE_OF_CREDIT                 VARCHAR2(40)  ,
    DOCUMENT_UNIQUE_IDENTIFIER     VARCHAR2(480) ,
    INTEREST_INDICATOR             VARCHAR2(4)   ,
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)      NOT NULL,
    JG_STATUS                      VARCHAR2(120) ,
    ZX_STATUS                      VARCHAR2(120) ,
    ACKNOWLEDGED_DATE              TIMESTAMP(6)  ,
    CURRENCY                       VARCHAR2(120) ,
    CHARGE_ALLOCATION_STATUS       VARCHAR2(120) ,
    TAX_CALCULATION_STATUS         VARCHAR2(120) ,
    REFERENCED_STATUS              VARCHAR2(120) ,
    APPROVED_STATUS                VARCHAR2(120) ,
    DOCUMENT_TYPE                  VARCHAR2(120) ,
    SOURCE_DOCUMENT_TYPE           VARCHAR2(120) ,
    SOURCE_DOC_CURRENCY_CODE       VARCHAR2(120) ,
    OPERATION_TYPE                 VARCHAR2(120) ,
    SERIES                         VARCHAR2(256) ,
    SUBSERIES                      VARCHAR2(256) ,
    MODEL                          VARCHAR2(256) ,
    ISSUE_DATE                     TIMESTAMP(6)  ,
    TOTAL_AMOUNT                   NUMBER        ,
    ITEM_LINE_TOTAL                NUMBER        ,
    ISSUER_TAXPAYER_ID             VARCHAR2(256) ,
    ISSUER_NAME                    VARCHAR2(1440),
    ISSUER_ADDRESS                 VARCHAR2(4000),
    RECEIVER_TAXPAYER_ID           VARCHAR2(256) ,
    RECEIVER_NAME                  VARCHAR2(1440),
    RECEIVER_ADDRESS               VARCHAR2(4000),
    RECEIVER_TAX_ID                NUMBER(18, 0) ,
    SHIP_TO_ADDRESS                VARCHAR2(4000),
    SHIP_FROM_ADDRESS              VARCHAR2(4000),
    FREIGHT_AMOUNT                 NUMBER        ,
    INSURANCE_AMOUNT               NUMBER        ,
    OTHER_EXPENSES_AMOUNT          NUMBER        ,
    DISCOUNT_AMOUNT                NUMBER        ,
    VALIDATION_STATUS              VARCHAR2(40)  ,
    REQUEST_ID                     NUMBER(18, 0) ,
    ISSUER_ADDRESS_CITY_NAME       VARCHAR2(240) ,
    ISSUER_ADDRESS_STATE           VARCHAR2(8)   ,
    ISSUER_ADDRESS_ZIP_CODE        VARCHAR2(256) ,
    RECEIVER_ADDRESS_CITY_NAME     VARCHAR2(240) ,
    RECEIVER_ADDRESS_STATE         VARCHAR2(8)   ,
    RECEIVER_ADDRESS_ZIP_CODE      VARCHAR2(256) ,
    SHIP_TO_ADDRESS_CITY_NAME      VARCHAR2(240) ,
    SHIP_TO_ADDRESS_STATE          VARCHAR2(8)   ,
    SHIP_TO_ADDRESS_ZIP_CODE       VARCHAR2(256) ,
    SHIP_FROM_ADDRESS_CITY_NAME    VARCHAR2(240) ,
    SHIP_FROM_ADDRESS_STATE        VARCHAR2(8)   ,
    SHIP_FROM_ADDRESS_ZIP_CODE     VARCHAR2(256) ,
    COUNTRY_CODE                   VARCHAR2(8)   ,
    ISSUER_ADDRESS_NUMBER          VARCHAR2(240) ,
    ISSUER_ADDRESS_COMPLEMENT      VARCHAR2(240) ,
    ISSUER_ADDRESS_CITY_CODE       VARCHAR2(256) ,
    RECEIVER_ADDRESS_NUMBER        VARCHAR2(240) ,
    RECEIVER_ADDRESS_COMPLEMENT    VARCHAR2(240) ,
    RECEIVER_ADDRESS_CITY_CODE     VARCHAR2(256) ,
    SHIP_TO_ADDRESS_NUMBER         VARCHAR2(240) ,
    SHIP_TO_ADDRESS_COMPLEMENT     VARCHAR2(240) ,
    SHIP_TO_ADDRESS_CITY_CODE      VARCHAR2(256) ,
    SHIP_FROM_ADDRESS_NUMBER       VARCHAR2(240) ,
    SHIP_FROM_ADDR_COMPLEMENT      VARCHAR2(240) ,
    SHIP_FROM_ADDRESS_CITY_CODE    VARCHAR2(256) ,
    EXTERNAL_SYSTEM_REFERENCE      VARCHAR2(960) ,
    EXTERNAL_SYSTEM_REF_ID         VARCHAR2(120) ,
    JOB_DEFINITION_NAME            VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE         VARCHAR2(3600),
    CREATED_BY                     VARCHAR2(256)     NOT NULL,
    CREATION_DATE                  TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE               TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN              VARCHAR2(128) ,
    USAGE_AUTHORIZATION            VARCHAR2(256) ,
    ISSUER_TAX_ID                  NUMBER(18, 0) ,
    ISSUER_PARTY_ID                NUMBER(18, 0) ,
    ISSUER_PARTY_SITE_ID           NUMBER(18, 0) ,
    ISSUER_LOCATION_ID             NUMBER(18, 0) ,
    RECEIVER_PARTY_ID              NUMBER(18, 0) ,
    RECEIVER_PARTY_SITE_ID         NUMBER(18, 0) ,
    RECEIVER_LOCATION_ID           NUMBER(18, 0) ,
    SHIPFROM_NAME                  VARCHAR2(1440),
    SHIPFROM_TAX_ID                NUMBER(18, 0) ,
    SHIPFROM_PARTY_ID              NUMBER(18, 0) ,
    SHIPFROM_PARTY_SITE_ID         NUMBER(18, 0) ,
    SHIPFROM_LOCATION_ID           NUMBER(18, 0) ,
    SHIPTO_NAME                    VARCHAR2(1440),
    SHIPTO_TAX_ID                  NUMBER(18, 0) ,
    SHIPTO_PARTY_ID                NUMBER(18, 0) ,
    SHIPTO_PARTY_SITE_ID           NUMBER(18, 0) ,
    SHIPTO_LOCATION_ID             NUMBER(18, 0) ,
    SHIPFROM_TAXPAYER_ID           VARCHAR2(256) ,
    SHIPTO_TAXPAYER_ID             VARCHAR2(256) ,
    SOURCE_REF_DOC_HEADER_ID       NUMBER(18, 0) ,
    SHIPFROM_IBGE_CITY_ID          NUMBER(18, 0) ,
    SHIPTO_IBGE_CITY_ID            NUMBER(18, 0) ,
    FD_HEADERS_INT_ID              NUMBER(18, 0) ,
    DOCUMENT_HEADER_ID             NUMBER(18, 0) ,
    DOCUMENT_NUMBER                VARCHAR2(256) ,
    ACCESS_KEY_NUMBER              VARCHAR2(256) ,
    BILL_TO_BU_ID                  NUMBER(18, 0) ,
    SOLD_TO_LE_ID                  NUMBER(18, 0) ,
    FISCAL_DOC_ASSOCTNS_ID         NUMBER(18, 0) ,
    FISCAL_PROC_OPTIONS_ID         NUMBER(18, 0) ,
    IMPORTING_STATUS               VARCHAR2(120) ,
    DOCUMENT_STATUS                VARCHAR2(120) ,
    ISSUER_PARTY_TYPE              VARCHAR2(80)  ,
    RECEIVER_PARTY_TYPE            VARCHAR2(80)  ,
    SHIP_FROM_PARTY_TYPE           VARCHAR2(80)  ,
    SHIP_TO_PARTY_TYPE             VARCHAR2(120) ,
    ISSUING_PURPOSE                VARCHAR2(120) ,
    TYPE_OF_DEBIT                  VARCHAR2(40)  ,
    TYPE_OF_CREDIT                 VARCHAR2(40)  ,
    DOCUMENT_UNIQUE_IDENTIFIER     VARCHAR2(480) ,
    INTEREST_INDICATOR             VARCHAR2(4)   ,
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)      NOT NULL,
    JG_STATUS                      VARCHAR2(120) ,
    ZX_STATUS                      VARCHAR2(120) ,
    ACKNOWLEDGED_DATE              TIMESTAMP(6)  ,
    CURRENCY                       VARCHAR2(120) ,
    CHARGE_ALLOCATION_STATUS       VARCHAR2(120) ,
    TAX_CALCULATION_STATUS         VARCHAR2(120) ,
    REFERENCED_STATUS              VARCHAR2(120) ,
    APPROVED_STATUS                VARCHAR2(120) ,
    DOCUMENT_TYPE                  VARCHAR2(120) ,
    SOURCE_DOCUMENT_TYPE           VARCHAR2(120) ,
    SOURCE_DOC_CURRENCY_CODE       VARCHAR2(120) ,
    OPERATION_TYPE                 VARCHAR2(120) ,
    SERIES                         VARCHAR2(256) ,
    SUBSERIES                      VARCHAR2(256) ,
    MODEL                          VARCHAR2(256) ,
    ISSUE_DATE                     TIMESTAMP(6)  ,
    TOTAL_AMOUNT                   NUMBER        ,
    ITEM_LINE_TOTAL                NUMBER        ,
    ISSUER_TAXPAYER_ID             VARCHAR2(256) ,
    ISSUER_NAME                    VARCHAR2(1440),
    ISSUER_ADDRESS                 VARCHAR2(4000),
    RECEIVER_TAXPAYER_ID           VARCHAR2(256) ,
    RECEIVER_NAME                  VARCHAR2(1440),
    RECEIVER_ADDRESS               VARCHAR2(4000),
    RECEIVER_TAX_ID                NUMBER(18, 0) ,
    SHIP_TO_ADDRESS                VARCHAR2(4000),
    SHIP_FROM_ADDRESS              VARCHAR2(4000),
    FREIGHT_AMOUNT                 NUMBER        ,
    INSURANCE_AMOUNT               NUMBER        ,
    OTHER_EXPENSES_AMOUNT          NUMBER        ,
    DISCOUNT_AMOUNT                NUMBER        ,
    VALIDATION_STATUS              VARCHAR2(40)  ,
    REQUEST_ID                     NUMBER(18, 0) ,
    ISSUER_ADDRESS_CITY_NAME       VARCHAR2(240) ,
    ISSUER_ADDRESS_STATE           VARCHAR2(8)   ,
    ISSUER_ADDRESS_ZIP_CODE        VARCHAR2(256) ,
    RECEIVER_ADDRESS_CITY_NAME     VARCHAR2(240) ,
    RECEIVER_ADDRESS_STATE         VARCHAR2(8)   ,
    RECEIVER_ADDRESS_ZIP_CODE      VARCHAR2(256) ,
    SHIP_TO_ADDRESS_CITY_NAME      VARCHAR2(240) ,
    SHIP_TO_ADDRESS_STATE          VARCHAR2(8)   ,
    SHIP_TO_ADDRESS_ZIP_CODE       VARCHAR2(256) ,
    SHIP_FROM_ADDRESS_CITY_NAME    VARCHAR2(240) ,
    SHIP_FROM_ADDRESS_STATE        VARCHAR2(8)   ,
    SHIP_FROM_ADDRESS_ZIP_CODE     VARCHAR2(256) ,
    COUNTRY_CODE                   VARCHAR2(8)   ,
    ISSUER_ADDRESS_NUMBER          VARCHAR2(240) ,
    ISSUER_ADDRESS_COMPLEMENT      VARCHAR2(240) ,
    ISSUER_ADDRESS_CITY_CODE       VARCHAR2(256) ,
    RECEIVER_ADDRESS_NUMBER        VARCHAR2(240) ,
    RECEIVER_ADDRESS_COMPLEMENT    VARCHAR2(240) ,
    RECEIVER_ADDRESS_CITY_CODE     VARCHAR2(256) ,
    SHIP_TO_ADDRESS_NUMBER         VARCHAR2(240) ,
    SHIP_TO_ADDRESS_COMPLEMENT     VARCHAR2(240) ,
    SHIP_TO_ADDRESS_CITY_CODE      VARCHAR2(256) ,
    SHIP_FROM_ADDRESS_NUMBER       VARCHAR2(240) ,
    SHIP_FROM_ADDR_COMPLEMENT      VARCHAR2(240) ,
    SHIP_FROM_ADDRESS_CITY_CODE    VARCHAR2(256) ,
    EXTERNAL_SYSTEM_REFERENCE      VARCHAR2(960) ,
    EXTERNAL_SYSTEM_REF_ID         VARCHAR2(120) ,
    JOB_DEFINITION_NAME            VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE         VARCHAR2(3600),
    CREATED_BY                     VARCHAR2(256)     NOT NULL,
    CREATION_DATE                  TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE               TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN              VARCHAR2(128) ,
    USAGE_AUTHORIZATION            VARCHAR2(256) ,
    ISSUER_TAX_ID                  NUMBER(18, 0) ,
    ISSUER_PARTY_ID                NUMBER(18, 0) ,
    ISSUER_PARTY_SITE_ID           NUMBER(18, 0) ,
    ISSUER_LOCATION_ID             NUMBER(18, 0) ,
    RECEIVER_PARTY_ID              NUMBER(18, 0) ,
    RECEIVER_PARTY_SITE_ID         NUMBER(18, 0) ,
    RECEIVER_LOCATION_ID           NUMBER(18, 0) ,
    SHIPFROM_NAME                  VARCHAR2(1440),
    SHIPFROM_TAX_ID                NUMBER(18, 0) ,
    SHIPFROM_PARTY_ID              NUMBER(18, 0) ,
    SHIPFROM_PARTY_SITE_ID         NUMBER(18, 0) ,
    SHIPFROM_LOCATION_ID           NUMBER(18, 0) ,
    SHIPTO_NAME                    VARCHAR2(1440),
    SHIPTO_TAX_ID                  NUMBER(18, 0) ,
    SHIPTO_PARTY_ID                NUMBER(18, 0) ,
    SHIPTO_PARTY_SITE_ID           NUMBER(18, 0) ,
    SHIPTO_LOCATION_ID             NUMBER(18, 0) ,
    SHIPFROM_TAXPAYER_ID           VARCHAR2(256) ,
    SHIPTO_TAXPAYER_ID             VARCHAR2(256) ,
    SOURCE_REF_DOC_HEADER_ID       NUMBER(18, 0) ,
    SHIPFROM_IBGE_CITY_ID          NUMBER(18, 0) ,
    SHIPTO_IBGE_CITY_ID            NUMBER(18, 0) ,
    CONSTRAINT pk_cmf_fd_headers_int_gt PRIMARY KEY (FD_HEADERS_INT_ID, FD_HEADERS_INT_ID)
);
