/******************************************************************************/
/***               Generated by IBExpert 17/11/2020 10:17:30                ***/
/******************************************************************************/

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


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



CREATE TABLE TRAN_SIMBERENCANA (
    NOTRAN  NOTRAN NOT NULL /* NOTRAN = CHAR(15) */,
    TGLTRA  TGL /* TGL = DATE */,
    TGLBYR  TGL /* TGL = DATE */,
    NOREFS  NOTRAN /* NOTRAN = CHAR(15) */,
    REKTAB  NOMPYD NOT NULL /* NOMPYD = CHAR(12) */,
    CREBRC  NOMINAL /* NOMINAL = NUMERIC(15,2) DEFAULT 0 */,
    DEBBRC  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_SIMBERENCANA ADD CONSTRAINT PK_TRAN_SIMBERENCANA PRIMARY KEY (NOTRAN);


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


SET TERM ^ ;



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



/* Trigger: TRAN_SIMBERENCANA_BI0 */
CREATE OR ALTER TRIGGER TRAN_SIMBERENCANA_BI0 FOR TRAN_SIMBERENCANA
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 ; ^



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