/******************************************************************************/
/***               Generated by IBExpert 15/11/2020 20:34:32                ***/
/******************************************************************************/

/******************************************************************************/
/***      Following SET SQL DIALECT is just for the Database Comparer       ***/
/******************************************************************************/


/******************************************************************************/
/***                                 Tables                                 ***/
/******************************************************************************/



CREATE TABLE TRAN_SIMPERORANGAN (
    NOTRAN     NOTRAN NOT NULL /* NOTRAN = CHAR(15) */,
    TGLTRA     TGL /* TGL = DATE */,
    TGLBYR     TGL /* TGL = DATE */,
    NOREFS     NOTRAN /* NOTRAN = CHAR(15) */,
    IDANGGOTA  IDANGG NOT NULL /* IDANGG = CHAR(10) */,
    CRESKR     NOMINAL /* NOMINAL = NUMERIC(15,2) DEFAULT 0 */,
    CREMGO     NOMINAL /* NOMINAL = NUMERIC(15,2) DEFAULT 0 */,
    CRE4PR     NOMINAL /* NOMINAL = NUMERIC(15,2) DEFAULT 0 */,
    CREPKK     NOMINAL /* NOMINAL = NUMERIC(15,2) DEFAULT 0 */,
    DEBSKR     NOMINAL /* NOMINAL = NUMERIC(15,2) DEFAULT 0 */,
    DEBMGO     NOMINAL /* NOMINAL = NUMERIC(15,2) DEFAULT 0 */,
    DEB4PR     NOMINAL /* NOMINAL = NUMERIC(15,2) DEFAULT 0 */,
    DEBPKK     NOMINAL /* NOMINAL = NUMERIC(15,2) DEFAULT 0 */,
    KDTELR     KDTELR NOT NULL /* KDTELR = CHAR(8) */,
    KETERA     KET /* KET = VARCHAR(200) */,
    FLOTOR     JENIS /* JENIS = CHAR(1) */,
    TGLOTR     TGL /* TGL = DATE */,
    IDOTOR     USERID /* USERID = CHAR(10) */,
    IDINPT     USERID /* USERID = CHAR(10) */
);




/******************************************************************************/
/***                              Primary Keys                              ***/
/******************************************************************************/

ALTER TABLE TRAN_SIMPERORANGAN ADD CONSTRAINT PK_TRAN_SIMPERORANGAN PRIMARY KEY (NOTRAN);


/******************************************************************************/
/***                                Triggers                                ***/
/******************************************************************************/


SET TERM ^ ;



/******************************************************************************/
/***                          Triggers for tables                           ***/
/******************************************************************************/



/* Trigger: TRAN_SIMPERORANGAN_BI0 */
CREATE OR ALTER TRIGGER TRAN_SIMPERORANGAN_BI0 FOR TRAN_SIMPERORANGAN
ACTIVE BEFORE INSERT POSITION 0
AS
begin
  new.tgltra=(select tglsek from pas_hprs);
  new.notran=(select onotran from pnotran);
  new.flotor='T';
end
^


SET TERM ; ^



/******************************************************************************/
/***                          Fields descriptions                           ***/
/******************************************************************************/

COMMENT ON COLUMN TRAN_SIMPERORANGAN.NOTRAN IS 
'notran=2 nokant
       2 tahun
       2 bulan
       1 aplikasi
       3 nourut

alikasi
1.daftar anggota
2.mutasi majlis
3.droping pembiayaan
4.transaksi setoran
5.pelunasan
7.penerimaan kas
8.pembayaran kas
9.jurnal umum';

COMMENT ON COLUMN TRAN_SIMPERORANGAN.NOREFS IS 
'notran=2 nokant
       2 tahun
       2 bulan
       1 aplikasi
       3 nourut

alikasi
1.daftar anggota
2.mutasi majlis
3.droping pembiayaan
4.transaksi setoran
5.pelunasan
7.penerimaan kas
8.pembayaran kas
9.jurnal umum';

COMMENT ON COLUMN TRAN_SIMPERORANGAN.FLOTOR IS 
'1.tab LWK
2.tab 5%
3.tab minggon
4.tab sukarela';



/******************************************************************************/
/***                               Privileges                               ***/
/******************************************************************************/