REM INSERTING into EXPORT_TABLE
SET DEFINE OFF;
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('NUM_PAGO','VARCHAR2(20 BYTE)','No',null,1,'NUMERO DE IDENTIFICACION DEL PAGO');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('FECHA_PAGO','DATE','No',null,2,'FECHA DE PAGO');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('STS_PAGO','VARCHAR2(1 BYTE)','No','''V''




',3,'STATUS DEL PAGO (V=Activo, A=Anulado)');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('REF_PAGO','VARCHAR2(30 BYTE)','Yes',null,4,'REFERENCIA DEL PAGO');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('RAMO','NUMBER(11,0)','No',null,5,'RAMO DE IMPUESTO INVOLUCRADO EN EL PAGO');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('MTO_TOT_PAGO','NUMBER(25,7)','No',null,6,'MONTO TOTAL DEL PAGO');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('ID_PERSONA','NUMBER(10,0)','No',null,7,'IDENTIFICACION DEL CONTRIBUYENTE');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('ENT_COD','VARCHAR2(3 BYTE)','No',null,8,'CODIGO DE LA ENTIDAD(SEDE O ENTE DESCENTRALIZADO RECAUDADOR, ETC)');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('NRO_CAJA','NUMBER(3,0)','No',null,9,'NUMERO ASIGNADO A LA CAJA');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('USR_CREA','VARCHAR2(32 BYTE)','No',null,10,'USUARIO QUE CREO EL REGISTRO DE PAGO');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('FEC_CREA','DATE','No',null,11,'FECHA DE CREACION DEL REGISTRO DE PAGO');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('USR_MOD','VARCHAR2(32 BYTE)','Yes',null,12,'USUARIO QUE MODIFICO EL REGISTRO DE PAGO');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('FEC_MOD','DATE','Yes',null,13,'FECHA DE MODIFICACION DEL REGISTRO DE PAGO');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('TAN_REC','NUMBER(38,0)','Yes',null,14,'NUMERO DE RECIBO DEL TANQUE DE SIGAP');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('OBSERVA','VARCHAR2(4000 BYTE)','Yes',null,15,'OBSERVACION DE LA ANULACION DEL RECIBO');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('CHQ_DVTO','VARCHAR2(1 BYTE)','Yes',null,16,'1 = ANULACION X CHQ DVTO');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('CALCOMANIA','NUMBER(20,0)','Yes',null,17,null);
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('COD_ANUL','VARCHAR2(3 BYTE)','Yes',null,18,'CODIGO DE ANULACION (TE_MOT_ANUL)');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('FEC_ANUL','DATE','Yes',null,19,'FECHA DE ANULACION');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('USR_ANUL','VARCHAR2(32 BYTE)','Yes',null,20,'USUARIO  DE ANULACION');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('MAR_CHQ','VARCHAR2(1 BYTE)','Yes',null,21,'1 = NO AUTORIZADO PARA CANCELAR CON CHEQUE   0=AUTORIZADO');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('UND_COD','VARCHAR2(10 BYTE)','Yes',null,22,'UBICACION DEL ENTE');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('ANO','NUMBER(4,0)','Yes',null,23,'ANO DEL RAMO');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('NRO_ORDEN_LIQ','VARCHAR2(20 BYTE)','Yes',null,24,null);
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('ORIGEN','NUMBER(1,0)','Yes',null,25,'ES PARA INDICARLE AL TRIGGER QUE NO VALIDE SI EL DIA ESTA CERRADO');
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('DIRECCION_IP','VARCHAR2(50 BYTE)','Yes',null,26,null);
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('MTO_TOT_PAGO_BCK','NUMBER(23,5)','Yes',null,27,null);
Insert into EXPORT_TABLE (COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,COLUMN_ID,COMMENTS) values ('ENT_ORIGEN','VARCHAR2(3 BYTE)','Yes','''001''',28,null);
