CREATE TABLE ar_incomplete_trx_hist (
    CUSTOMER_TRX_ID      NUMBER(18, 0),
    TRX_AMT              NUMBER       ,
    GL_DATE              DATE         ,
    CURRENCY_CODE        VARCHAR2(60) ,
    COMPLETE_FLAG        VARCHAR2(4)  ,
    ORG_ID               NUMBER(18, 0),
    CREATION_DATE        TIMESTAMP(6)     NOT NULL,
    CREATED_BY           VARCHAR2(256)    NOT NULL,
    LAST_UPDATED_BY      VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE     TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN    VARCHAR2(128),
    CUSTOMER_TRX_ID      NUMBER(18, 0),
    TRX_AMT              NUMBER       ,
    GL_DATE              DATE         ,
    CURRENCY_CODE        VARCHAR2(60) ,
    COMPLETE_FLAG        VARCHAR2(4)  ,
    ORG_ID               NUMBER(18, 0),
    CREATION_DATE        TIMESTAMP(6)     NOT NULL,
    CREATED_BY           VARCHAR2(256)    NOT NULL,
    LAST_UPDATED_BY      VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE     TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN    VARCHAR2(128),
    CONSTRAINT pk_ar_incomplete_trx_hist PRIMARY KEY (CUSTOMER_TRX_ID, CUSTOMER_TRX_ID)
);
