CREATE TABLE fa_asset_invoices (
    ASSET_ID                          NUMBER(18, 0)     NOT NULL,
    PO_VENDOR_ID                      NUMBER(18, 0) ,
    ASSET_INVOICE_ID                  NUMBER(18, 0) ,
    FIXED_ASSETS_COST                 NUMBER        ,
    DATE_EFFECTIVE                    DATE              NOT NULL,
    DATE_INEFFECTIVE                  DATE          ,
    INVOICE_TRANSACTION_ID_IN         NUMBER(18, 0) ,
    INVOICE_TRANSACTION_ID_OUT        NUMBER(18, 0) ,
    DELETED_FLAG                      VARCHAR2(12)      NOT NULL,
    PO_NUMBER                         VARCHAR2(120) ,
    INVOICE_NUMBER                    VARCHAR2(200) ,
    PAYABLES_BATCH_NAME               VARCHAR2(200) ,
    PAYABLES_CODE_COMBINATION_ID      NUMBER(18, 0) ,
    FEEDER_SYSTEM_NAME                VARCHAR2(160) ,
    CREATE_BATCH_DATE                 DATE          ,
    CREATE_BATCH_ID                   NUMBER(18, 0) ,
    INVOICE_DATE                      DATE          ,
    PAYABLES_COST                     NUMBER        ,
    POST_BATCH_ID                     NUMBER(18, 0) ,
    INVOICE_ID                        NUMBER(18, 0) ,
    AP_DISTRIBUTION_LINE_NUMBER       NUMBER(18, 0) ,
    PAYABLES_UNITS                    NUMBER        ,
    SPLIT_MERGED_CODE                 VARCHAR2(12)  ,
    DESCRIPTION                       VARCHAR2(320) ,
    PARENT_MASS_ADDITION_ID           NUMBER(18, 0) ,
    CREATION_DATE                     TIMESTAMP(6)      NOT NULL,
    CREATED_BY                        VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                  TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                   VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER             NUMBER(9, 0)      NOT NULL,
    ATTRIBUTE1                        VARCHAR2(600) ,
    ATTRIBUTE2                        VARCHAR2(600) ,
    ATTRIBUTE3                        VARCHAR2(600) ,
    ATTRIBUTE4                        VARCHAR2(600) ,
    ATTRIBUTE5                        VARCHAR2(600) ,
    ATTRIBUTE6                        VARCHAR2(600) ,
    ATTRIBUTE7                        VARCHAR2(600) ,
    ATTRIBUTE8                        VARCHAR2(600) ,
    ATTRIBUTE9                        VARCHAR2(600) ,
    ATTRIBUTE10                       VARCHAR2(600) ,
    ATTRIBUTE11                       VARCHAR2(600) ,
    ATTRIBUTE12                       VARCHAR2(600) ,
    ATTRIBUTE13                       VARCHAR2(600) ,
    ATTRIBUTE14                       VARCHAR2(600) ,
    ATTRIBUTE15                       VARCHAR2(600) ,
    ATTRIBUTE_CATEGORY_CODE           VARCHAR2(120) ,
    ATTRIBUTE_NUMBER1                 NUMBER        ,
    ATTRIBUTE_NUMBER2                 NUMBER        ,
    ATTRIBUTE_NUMBER3                 NUMBER        ,
    ATTRIBUTE_NUMBER4                 NUMBER        ,
    ATTRIBUTE_NUMBER5                 NUMBER        ,
    ATTRIBUTE_DATE1                   DATE          ,
    ATTRIBUTE_DATE2                   DATE          ,
    ATTRIBUTE_DATE3                   DATE          ,
    ATTRIBUTE_DATE4                   DATE          ,
    ATTRIBUTE_DATE5                   DATE          ,
    UNREVALUED_COST                   NUMBER        ,
    MERGED_CODE                       VARCHAR2(12)  ,
    SPLIT_CODE                        VARCHAR2(12)  ,
    MERGE_PARENT_MASS_ADDITIONS_ID    NUMBER(18, 0) ,
    SPLIT_PARENT_MASS_ADDITIONS_ID    NUMBER(18, 0) ,
    PROJECT_ASSET_LINE_ID             NUMBER(18, 0) ,
    PROJECT_ID                        NUMBER(18, 0) ,
    TASK_ID                           NUMBER(18, 0) ,
    SOURCE_LINE_ID                    NUMBER(18, 0) ,
    DEPRECIATE_IN_GROUP_FLAG          VARCHAR2(4)   ,
    MATERIAL_INDICATOR_FLAG           VARCHAR2(4)   ,
    PRIOR_SOURCE_LINE_ID              NUMBER(18, 0) ,
    INVOICE_DISTRIBUTION_ID           NUMBER(18, 0) ,
    INVOICE_LINE_NUMBER               NUMBER        ,
    PO_DISTRIBUTION_ID                NUMBER(18, 0) ,
    INVOICE_LINE_TYPE                 VARCHAR2(120) ,
    LINE_TYPE_LOOKUP_CODE             VARCHAR2(100) ,
    INVOICE_LINE_DESCRIPTION          VARCHAR2(960) ,
    PROJECT_ORGANIZATION_ID           NUMBER(18, 0) ,
    TASK_ORGANIZATION_ID              NUMBER(18, 0) ,
    EXPENDITURE_ORGANIZATION_ID       NUMBER(18, 0) ,
    PROJECT_TXN_DOC_ENTRY_ID          NUMBER(18, 0) ,
    INVOICE_PAYMENT_ID                NUMBER(18, 0) ,
    EXPENDITURE_TYPE_ID               NUMBER(18, 0) ,
    GLOBAL_ATTRIBUTE_CATEGORY         VARCHAR2(120) ,
    GLOBAL_ATTRIBUTE1                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE2                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE3                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE4                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE5                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE6                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE7                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE8                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE9                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE10                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE11                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE12                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE13                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE14                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE15                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE16                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE17                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE18                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE19                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE20                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE_NUMBER1          NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER2          NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER3          NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER4          NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER5          NUMBER        ,
    GLOBAL_ATTRIBUTE_DATE1            DATE          ,
    GLOBAL_ATTRIBUTE_DATE2            DATE          ,
    GLOBAL_ATTRIBUTE_DATE3            DATE          ,
    GLOBAL_ATTRIBUTE_DATE4            DATE          ,
    GLOBAL_ATTRIBUTE_DATE5            DATE          ,
    BOOK_TYPE_CODE                    VARCHAR2(120) ,
    CORP_SOURCE_LINE_ID               NUMBER(18, 0) ,
    VENDOR_NUMBER                     VARCHAR2(120) ,
    VENDOR_NAME                       VARCHAR2(1440),
    INVOICE_VOUCHER_NUMBER            VARCHAR2(200) ,
    INVOICE_PAYMENT_NUMBER            NUMBER(18, 0) ,
    PROJECT_NUMBER                    VARCHAR2(100) ,
    PROJECT_TASK_NUMBER               VARCHAR2(400) ,
    SHIP_TO_CUST_LOCATION_ID          NUMBER(18, 0) ,
    SHIP_TO_LOCATION_ID               NUMBER(18, 0) ,
    IB_REFERENCE_ID                   NUMBER(18, 0) ,
    PURCHASING_CATEGORY_ID            NUMBER(18, 0) ,
    INVENTORY_ITEM_ID                 NUMBER(18, 0) ,
    ITEM_ORGANIZATION_ID              NUMBER(18, 0) ,
    RCV_TRANSACTION_ID                NUMBER(18, 0) ,
    ASSET_ID                          NUMBER(18, 0)     NOT NULL,
    PO_VENDOR_ID                      NUMBER(18, 0) ,
    ASSET_INVOICE_ID                  NUMBER(18, 0) ,
    FIXED_ASSETS_COST                 NUMBER        ,
    DATE_EFFECTIVE                    DATE              NOT NULL,
    DATE_INEFFECTIVE                  DATE          ,
    INVOICE_TRANSACTION_ID_IN         NUMBER(18, 0) ,
    INVOICE_TRANSACTION_ID_OUT        NUMBER(18, 0) ,
    DELETED_FLAG                      VARCHAR2(12)      NOT NULL,
    PO_NUMBER                         VARCHAR2(120) ,
    INVOICE_NUMBER                    VARCHAR2(200) ,
    PAYABLES_BATCH_NAME               VARCHAR2(200) ,
    PAYABLES_CODE_COMBINATION_ID      NUMBER(18, 0) ,
    FEEDER_SYSTEM_NAME                VARCHAR2(160) ,
    CREATE_BATCH_DATE                 DATE          ,
    CREATE_BATCH_ID                   NUMBER(18, 0) ,
    INVOICE_DATE                      DATE          ,
    PAYABLES_COST                     NUMBER        ,
    POST_BATCH_ID                     NUMBER(18, 0) ,
    INVOICE_ID                        NUMBER(18, 0) ,
    AP_DISTRIBUTION_LINE_NUMBER       NUMBER(18, 0) ,
    PAYABLES_UNITS                    NUMBER        ,
    SPLIT_MERGED_CODE                 VARCHAR2(12)  ,
    DESCRIPTION                       VARCHAR2(320) ,
    PARENT_MASS_ADDITION_ID           NUMBER(18, 0) ,
    CREATION_DATE                     TIMESTAMP(6)      NOT NULL,
    CREATED_BY                        VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                  TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                   VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER             NUMBER(9, 0)      NOT NULL,
    ATTRIBUTE1                        VARCHAR2(600) ,
    ATTRIBUTE2                        VARCHAR2(600) ,
    ATTRIBUTE3                        VARCHAR2(600) ,
    ATTRIBUTE4                        VARCHAR2(600) ,
    ATTRIBUTE5                        VARCHAR2(600) ,
    ATTRIBUTE6                        VARCHAR2(600) ,
    ATTRIBUTE7                        VARCHAR2(600) ,
    ATTRIBUTE8                        VARCHAR2(600) ,
    ATTRIBUTE9                        VARCHAR2(600) ,
    ATTRIBUTE10                       VARCHAR2(600) ,
    ATTRIBUTE11                       VARCHAR2(600) ,
    ATTRIBUTE12                       VARCHAR2(600) ,
    ATTRIBUTE13                       VARCHAR2(600) ,
    ATTRIBUTE14                       VARCHAR2(600) ,
    ATTRIBUTE15                       VARCHAR2(600) ,
    ATTRIBUTE_CATEGORY_CODE           VARCHAR2(120) ,
    ATTRIBUTE_NUMBER1                 NUMBER        ,
    ATTRIBUTE_NUMBER2                 NUMBER        ,
    ATTRIBUTE_NUMBER3                 NUMBER        ,
    ATTRIBUTE_NUMBER4                 NUMBER        ,
    ATTRIBUTE_NUMBER5                 NUMBER        ,
    ATTRIBUTE_DATE1                   DATE          ,
    ATTRIBUTE_DATE2                   DATE          ,
    ATTRIBUTE_DATE3                   DATE          ,
    ATTRIBUTE_DATE4                   DATE          ,
    ATTRIBUTE_DATE5                   DATE          ,
    UNREVALUED_COST                   NUMBER        ,
    MERGED_CODE                       VARCHAR2(12)  ,
    SPLIT_CODE                        VARCHAR2(12)  ,
    MERGE_PARENT_MASS_ADDITIONS_ID    NUMBER(18, 0) ,
    SPLIT_PARENT_MASS_ADDITIONS_ID    NUMBER(18, 0) ,
    PROJECT_ASSET_LINE_ID             NUMBER(18, 0) ,
    PROJECT_ID                        NUMBER(18, 0) ,
    TASK_ID                           NUMBER(18, 0) ,
    SOURCE_LINE_ID                    NUMBER(18, 0) ,
    DEPRECIATE_IN_GROUP_FLAG          VARCHAR2(4)   ,
    MATERIAL_INDICATOR_FLAG           VARCHAR2(4)   ,
    PRIOR_SOURCE_LINE_ID              NUMBER(18, 0) ,
    INVOICE_DISTRIBUTION_ID           NUMBER(18, 0) ,
    INVOICE_LINE_NUMBER               NUMBER        ,
    PO_DISTRIBUTION_ID                NUMBER(18, 0) ,
    INVOICE_LINE_TYPE                 VARCHAR2(120) ,
    LINE_TYPE_LOOKUP_CODE             VARCHAR2(100) ,
    INVOICE_LINE_DESCRIPTION          VARCHAR2(960) ,
    PROJECT_ORGANIZATION_ID           NUMBER(18, 0) ,
    TASK_ORGANIZATION_ID              NUMBER(18, 0) ,
    EXPENDITURE_ORGANIZATION_ID       NUMBER(18, 0) ,
    PROJECT_TXN_DOC_ENTRY_ID          NUMBER(18, 0) ,
    INVOICE_PAYMENT_ID                NUMBER(18, 0) ,
    EXPENDITURE_TYPE_ID               NUMBER(18, 0) ,
    GLOBAL_ATTRIBUTE_CATEGORY         VARCHAR2(120) ,
    GLOBAL_ATTRIBUTE1                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE2                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE3                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE4                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE5                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE6                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE7                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE8                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE9                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE10                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE11                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE12                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE13                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE14                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE15                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE16                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE17                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE18                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE19                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE20                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE_NUMBER1          NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER2          NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER3          NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER4          NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER5          NUMBER        ,
    GLOBAL_ATTRIBUTE_DATE1            DATE          ,
    GLOBAL_ATTRIBUTE_DATE2            DATE          ,
    GLOBAL_ATTRIBUTE_DATE3            DATE          ,
    GLOBAL_ATTRIBUTE_DATE4            DATE          ,
    GLOBAL_ATTRIBUTE_DATE5            DATE          ,
    BOOK_TYPE_CODE                    VARCHAR2(120) ,
    CORP_SOURCE_LINE_ID               NUMBER(18, 0) ,
    VENDOR_NUMBER                     VARCHAR2(120) ,
    VENDOR_NAME                       VARCHAR2(1440),
    INVOICE_VOUCHER_NUMBER            VARCHAR2(200) ,
    INVOICE_PAYMENT_NUMBER            NUMBER(18, 0) ,
    PROJECT_NUMBER                    VARCHAR2(100) ,
    PROJECT_TASK_NUMBER               VARCHAR2(400) ,
    SHIP_TO_CUST_LOCATION_ID          NUMBER(18, 0) ,
    SHIP_TO_LOCATION_ID               NUMBER(18, 0) ,
    IB_REFERENCE_ID                   NUMBER(18, 0) ,
    PURCHASING_CATEGORY_ID            NUMBER(18, 0) ,
    INVENTORY_ITEM_ID                 NUMBER(18, 0) ,
    ITEM_ORGANIZATION_ID              NUMBER(18, 0) ,
    RCV_TRANSACTION_ID                NUMBER(18, 0) ,
    CONSTRAINT pk_fa_asset_invoices PRIMARY KEY (SOURCE_LINE_ID, SOURCE_LINE_ID)
);
