CREATE TABLE cmf_fd_lines_int_gt (
    FD_LINES_INT_ID                NUMBER(18, 0) ,
    REFERENCE_DOC_ACCESS_KEY       VARCHAR2(256) ,
    REFERENCE_DOC_LINE_NUMBER      NUMBER        ,
    SEL_TAX_CLASSSIF_CODE          VARCHAR2(60)  ,
    IBS_CBS_TAX_CLASSIF_CODE       VARCHAR2(60)  ,
    FD_HEADERS_INT_ID              NUMBER(18, 0) ,
    DOCUMENT_LINE_ID               NUMBER(18, 0) ,
    DOCUMENT_HEADER_ID             NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)      NOT NULL,
    LINE_NUMBER                    NUMBER(9, 0)  ,
    FISCAL_CLASSIFICATION          VARCHAR2(960) ,
    UNIT_OF_MEASURE                VARCHAR2(24)  ,
    QUANTITY                       NUMBER        ,
    UNIT_PRICE                     NUMBER        ,
    LINE_AMOUNT                    NUMBER        ,
    FREIGHT_LINE_AMOUNT            NUMBER        ,
    INSURANCE_LINE_AMOUNT          NUMBER        ,
    OTHER_EXPENSES_LINE_AMOUNT     NUMBER        ,
    DISCOUNT_LINE_AMOUNT           NUMBER        ,
    SOURCE_DOCUMENT_NUMBER         VARCHAR2(400) ,
    SOURCE_DOCUMENT_LINE           NUMBER        ,
    ITEM_CODE                      VARCHAR2(240) ,
    ITEM_ID                        NUMBER(18, 0) ,
    ITEM_DESCRIPTION               VARCHAR2(1000),
    CFOP                           VARCHAR2(120) ,
    SOURCE_DOC_HEADER_ID           NUMBER(18, 0) ,
    SOURCE_DOC_LINE_ID             NUMBER(18, 0) ,
    SOURCE_DOC_SCHEDULE_ID         NUMBER(18, 0) ,
    SOURCE_DOCUMENT_TYPE           VARCHAR2(120) ,
    LINE_TYPE                      VARCHAR2(120) ,
    SOURCE_DOC_BU_ID               NUMBER(18, 0) ,
    CHARGES_AMOUNT                 NUMBER        ,
    INTENDED_USE                   NUMBER(18, 0) ,
    VALIDATION_STATUS              VARCHAR2(40)  ,
    REF_DOCUMENT_HEADER_ID         NUMBER(18, 0) ,
    REF_DOCUMENT_LINE_ID           NUMBER(18, 0) ,
    PRODUCT_FISCAL_CLASSIF_ID      VARCHAR2(80)  ,
    FD_CONVERTED_CFOP              VARCHAR2(960) ,
    FREIGHT_MODAL                  VARCHAR2(960) ,
    PRODUCT_CATEGORY               VARCHAR2(960) ,
    EXTERNAL_SYSTEM_REFERENCE      VARCHAR2(960) ,
    EXTERNAL_SYSTEM_REF_ID         VARCHAR2(120) ,
    REQUEST_ID                     NUMBER(18, 0) ,
    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) ,
    SOURCE_CURRENCY_CODE           VARCHAR2(120) ,
    REF_FD_DOCUMENT_TYPE           VARCHAR2(128) ,
    REQ_BU_ID                      NUMBER(18, 0) ,
    SOURCE_REF_DOC_LINE_ID         NUMBER(18, 0) ,
    ASSESSABLE_VALUE               NUMBER        ,
    FINAL_DISCHARGE_LOCATION_ID    NUMBER(18, 0) ,
    TAX_CLASSIFICATION_CODE        VARCHAR2(120) ,
    EFD_PROD_ADD_INFO              VARCHAR2(2000),
    EFD_ITEM_CODE                  VARCHAR2(1200),
    EFD_ITEM_DESCRIPTION           VARCHAR2(1000),
    TUOM_TO_SUOM_CONV_FACT         NUMBER        ,
    SECONDARY_UOM_CODE             VARCHAR2(120) ,
    SECONDARY_QUANTITY             NUMBER        ,
    FCI_CONTROL_NUMBER             VARCHAR2(144) ,
    ICMS_ORIGIN_CODE               VARCHAR2(8)   ,
    FD_LINES_INT_ID                NUMBER(18, 0) ,
    REFERENCE_DOC_ACCESS_KEY       VARCHAR2(256) ,
    REFERENCE_DOC_LINE_NUMBER      NUMBER        ,
    SEL_TAX_CLASSSIF_CODE          VARCHAR2(60)  ,
    IBS_CBS_TAX_CLASSIF_CODE       VARCHAR2(60)  ,
    FD_HEADERS_INT_ID              NUMBER(18, 0) ,
    DOCUMENT_LINE_ID               NUMBER(18, 0) ,
    DOCUMENT_HEADER_ID             NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)      NOT NULL,
    LINE_NUMBER                    NUMBER(9, 0)  ,
    FISCAL_CLASSIFICATION          VARCHAR2(960) ,
    UNIT_OF_MEASURE                VARCHAR2(24)  ,
    QUANTITY                       NUMBER        ,
    UNIT_PRICE                     NUMBER        ,
    LINE_AMOUNT                    NUMBER        ,
    FREIGHT_LINE_AMOUNT            NUMBER        ,
    INSURANCE_LINE_AMOUNT          NUMBER        ,
    OTHER_EXPENSES_LINE_AMOUNT     NUMBER        ,
    DISCOUNT_LINE_AMOUNT           NUMBER        ,
    SOURCE_DOCUMENT_NUMBER         VARCHAR2(400) ,
    SOURCE_DOCUMENT_LINE           NUMBER        ,
    ITEM_CODE                      VARCHAR2(240) ,
    ITEM_ID                        NUMBER(18, 0) ,
    ITEM_DESCRIPTION               VARCHAR2(1000),
    CFOP                           VARCHAR2(120) ,
    SOURCE_DOC_HEADER_ID           NUMBER(18, 0) ,
    SOURCE_DOC_LINE_ID             NUMBER(18, 0) ,
    SOURCE_DOC_SCHEDULE_ID         NUMBER(18, 0) ,
    SOURCE_DOCUMENT_TYPE           VARCHAR2(120) ,
    LINE_TYPE                      VARCHAR2(120) ,
    SOURCE_DOC_BU_ID               NUMBER(18, 0) ,
    CHARGES_AMOUNT                 NUMBER        ,
    INTENDED_USE                   NUMBER(18, 0) ,
    VALIDATION_STATUS              VARCHAR2(40)  ,
    REF_DOCUMENT_HEADER_ID         NUMBER(18, 0) ,
    REF_DOCUMENT_LINE_ID           NUMBER(18, 0) ,
    PRODUCT_FISCAL_CLASSIF_ID      VARCHAR2(80)  ,
    FD_CONVERTED_CFOP              VARCHAR2(960) ,
    FREIGHT_MODAL                  VARCHAR2(960) ,
    PRODUCT_CATEGORY               VARCHAR2(960) ,
    EXTERNAL_SYSTEM_REFERENCE      VARCHAR2(960) ,
    EXTERNAL_SYSTEM_REF_ID         VARCHAR2(120) ,
    REQUEST_ID                     NUMBER(18, 0) ,
    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) ,
    SOURCE_CURRENCY_CODE           VARCHAR2(120) ,
    REF_FD_DOCUMENT_TYPE           VARCHAR2(128) ,
    REQ_BU_ID                      NUMBER(18, 0) ,
    SOURCE_REF_DOC_LINE_ID         NUMBER(18, 0) ,
    ASSESSABLE_VALUE               NUMBER        ,
    FINAL_DISCHARGE_LOCATION_ID    NUMBER(18, 0) ,
    TAX_CLASSIFICATION_CODE        VARCHAR2(120) ,
    EFD_PROD_ADD_INFO              VARCHAR2(2000),
    EFD_ITEM_CODE                  VARCHAR2(1200),
    EFD_ITEM_DESCRIPTION           VARCHAR2(1000),
    TUOM_TO_SUOM_CONV_FACT         NUMBER        ,
    SECONDARY_UOM_CODE             VARCHAR2(120) ,
    SECONDARY_QUANTITY             NUMBER        ,
    FCI_CONTROL_NUMBER             VARCHAR2(144) ,
    ICMS_ORIGIN_CODE               VARCHAR2(8)   ,
    CONSTRAINT pk_cmf_fd_lines_int_gt PRIMARY KEY (FD_LINES_INT_ID, FD_LINES_INT_ID)
);
