CREATE TABLE fla_accounting_transactions (
    ACCOUNTING_TRANSACTION_ID      NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)      NOT NULL,
    TRANSACTION_TYPE_CODE          VARCHAR2(120)     NOT NULL,
    LEASE_ID                       NUMBER(18, 0)     NOT NULL,
    SCHEDULE_DATE                  DATE              NOT NULL,
    VERSION_NUM                    NUMBER(9, 0)      NOT NULL,
    PAYMENT_NUMBER                 VARCHAR2(120)     NOT NULL,
    SCHEDULE_HEADER_ID             NUMBER(18, 0)     NOT NULL,
    SHORT_TERM_LIABILITY_AMOUNT    NUMBER        ,
    LONG_TERM_LIABILITY_AMOUNT     NUMBER        ,
    ACCOUNTED_FLAG                 VARCHAR2(4)   ,
    REVERSAL_FLAG                  VARCHAR2(4)   ,
    PERIOD_NAME                    VARCHAR2(60)      NOT NULL,
    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) ,
    ACCOUNTING_TRANSACTION_ID      NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)      NOT NULL,
    TRANSACTION_TYPE_CODE          VARCHAR2(120)     NOT NULL,
    LEASE_ID                       NUMBER(18, 0)     NOT NULL,
    SCHEDULE_DATE                  DATE              NOT NULL,
    VERSION_NUM                    NUMBER(9, 0)      NOT NULL,
    PAYMENT_NUMBER                 VARCHAR2(120)     NOT NULL,
    SCHEDULE_HEADER_ID             NUMBER(18, 0)     NOT NULL,
    SHORT_TERM_LIABILITY_AMOUNT    NUMBER        ,
    LONG_TERM_LIABILITY_AMOUNT     NUMBER        ,
    ACCOUNTED_FLAG                 VARCHAR2(4)   ,
    REVERSAL_FLAG                  VARCHAR2(4)   ,
    PERIOD_NAME                    VARCHAR2(60)      NOT NULL,
    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) ,
    CONSTRAINT pk_fla_accounting_transactions PRIMARY KEY (ACCOUNTING_TRANSACTION_ID, ACCOUNTING_TRANSACTION_ID)
);
