CREATE TABLE APROPED ( APR_TIP VARCHAR(3) DEFAULT ('APR') NOT NULL, APR_NUM INT DEFAULT (0) NOT NULL, APR_CIA CHAR(2) DEFAULT ('01') NOT NULL, APR_FEC SMALLDATETIME NOT NULL, APR_TPE VARCHAR(3) DEFAULT ('PED') NOT NULL, APR_PED INT DEFAULT (0) NOT NULL, APR_CPE CHAR(2) DEFAULT ('01') NOT NULL, APR_FPE SMALLDATETIME CONSTRAINT PK_APROPED PRIMARY KEY CLUSTERED (APR_TIP,APR_NUM,APR_CIA), CONSTRAINT CK__APROPED__APR_CIA__6A50C1DA CHECK ((len([APR_CIA]) > 0)), CONSTRAINT CK__APROPED__APR_CPE__6F1576F7 CHECK ((len([APR_CPE]) > 0)), CONSTRAINT CK__APROPED__APR_TIP__6774552F CHECK ((len([APR_TIP]) > 0)), CONSTRAINT CK__APROPED__APR_TPE__6C390A4C CHECK ((len([APR_TPE]) > 0))) CREATE TABLE AUTORIZA ( AUT_TIP VARCHAR(3) DEFAULT ('AUT') NOT NULL, AUT_NUM INT DEFAULT (0) NOT NULL, AUT_CIA CHAR(2) DEFAULT ('01') NOT NULL, AUT_FEC SMALLDATETIME NOT NULL, AUT_NOM VARCHAR(8) NOT NULL, AUT_NIT VARCHAR(11), AUT_CON VARCHAR(3) NOT NULL, AUT_EST BIT DEFAULT (0) NOT NULL, AUT_USU VARCHAR(10) CONSTRAINT PK_AUTORIZA PRIMARY KEY CLUSTERED (AUT_TIP,AUT_NUM,AUT_CIA), CONSTRAINT CK__AUTORIZA__AUT_CI__75C27486 CHECK ((len([AUT_CIA]) > 0)), CONSTRAINT CK__AUTORIZA__AUT_CO__77AABCF8 CHECK ((len([AUT_CON]) > 0)), CONSTRAINT CK__AUTORIZA__AUT_NO__76B698BF CHECK ((len([AUT_NOM]) > 0)), CONSTRAINT CK__AUTORIZA__AUT_TI__72E607DB CHECK ((len([AUT_TIP]) > 0))) CREATE TABLE CONSIGNACIONES ( CON_NUM INT DEFAULT (0) NOT NULL, CON_TIP VARCHAR(3) DEFAULT ('CNS') NOT NULL, CON_CIA CHAR(2) DEFAULT ('01') NOT NULL, CON_FEC SMALLDATETIME NOT NULL, CON_CON VARCHAR(3) NOT NULL, CON_CTA VARCHAR(3) NOT NULL, CON_CUE VARCHAR(16), CON_VAL MONEY DEFAULT (0) CONSTRAINT PK_CONSIGNACIONES PRIMARY KEY CLUSTERED (CON_NUM,CON_TIP,CON_CIA), CONSTRAINT CK__CONSIGNAC__CON_C__004002F9 CHECK ((len([CON_CON]) > 0)), CONSTRAINT CK__CONSIGNAC__CON_C__01342732 CHECK ((len([CON_CTA]) > 0)), CONSTRAINT CK__CONSIGNAC__CON_C__7F4BDEC0 CHECK ((len([CON_CIA]) > 0)), CONSTRAINT CK__CONSIGNAC__CON_T__7D63964E CHECK ((len([CON_TIP]) > 0))) CREATE TABLE DESPACHOS ( DES_TIP VARCHAR(3) DEFAULT ('PLT') NOT NULL, DES_NUM INT DEFAULT (0) NOT NULL, DES_CIA CHAR(2) DEFAULT ('01') NOT NULL, DES_FEC SMALLDATETIME NOT NULL, DES_HOR SMALLDATETIME, DES_NIT VARCHAR(11) NOT NULL, DES_VEH VARCHAR(10) NOT NULL, DES_CON VARCHAR(11), DES_RUT VARCHAR(3) NOT NULL, DES_ORI VARCHAR(8) NOT NULL, DES_DES VARCHAR(8) NOT NULL, DES_REM VARCHAR(11), DES_DTN VARCHAR(11), DES_FIN BIT DEFAULT (0) NOT NULL, DES_OBS VARCHAR(250), DES_TOC VARCHAR(3) DEFAULT ('OCT'), DES_OCT INT DEFAULT (0), DES_COC CHAR(2) DEFAULT ('01'), DES_FOC SMALLDATETIME, DES_USU VARCHAR(10) CONSTRAINT PK_DESPACHOS PRIMARY KEY CLUSTERED (DES_TIP,DES_NUM,DES_CIA), CONSTRAINT CK__DESPACHOS__DES_C__08D548FA CHECK ((len([DES_CIA]) > 0)), CONSTRAINT CK__DESPACHOS__DES_D__0D99FE17 CHECK ((len([DES_DES]) > 0)), CONSTRAINT CK__DESPACHOS__DES_N__09C96D33 CHECK ((len([DES_NIT]) > 0)), CONSTRAINT CK__DESPACHOS__DES_O__0CA5D9DE CHECK ((len([DES_ORI]) > 0)), CONSTRAINT CK__DESPACHOS__DES_R__0BB1B5A5 CHECK ((len([DES_RUT]) > 0)), CONSTRAINT CK__DESPACHOS__DES_T__05F8DC4F CHECK ((len([DES_TIP]) > 0)), CONSTRAINT CK__DESPACHOS__DES_V__0ABD916C CHECK ((len([DES_VEH]) > 0))) CREATE TABLE DETFIS ( DET_TIP VARCHAR(3) DEFAULT ('FIS') NOT NULL, DET_NUM INT DEFAULT (0) NOT NULL, DET_CIA CHAR(2) DEFAULT ('01') NOT NULL, DET_ITM SMALLINT DEFAULT (0) NOT NULL, DET_COD VARCHAR(16) NOT NULL, DET_SEC VARCHAR(3) NOT NULL, DET_TAN VARCHAR(3), DET_CAN DECIMAL(14,4) DEFAULT (0) NOT NULL, DET_SAL DECIMAL(14,4) DEFAULT (0), DET_COS MONEY DEFAULT (0) CONSTRAINT PK_DETFIS PRIMARY KEY CLUSTERED (DET_TIP,DET_NUM,DET_CIA,DET_ITM), CONSTRAINT CK__DETFIS__DET_CIA__18178C8A CHECK ((len([DET_CIA]) > 0)), CONSTRAINT CK__DETFIS__DET_COD__19FFD4FC CHECK ((len([DET_COD]) > 0)), CONSTRAINT CK__DETFIS__DET_SEC__1AF3F935 CHECK ((len([DET_SEC]) > 0)), CONSTRAINT CK__DETFIS__DET_TIP__153B1FDF CHECK ((len([DET_TIP]) > 0))) CREATE TABLE DETGUI ( DET_NUM INT DEFAULT (0) NOT NULL, DET_TIP VARCHAR(3) DEFAULT ('GUI') NOT NULL, DET_CIA CHAR(2) DEFAULT ('01') NOT NULL, DET_ITM SMALLINT DEFAULT (0) NOT NULL, DET_COD VARCHAR(16) NOT NULL, DET_TAN VARCHAR(3) NOT NULL, DET_COM VARCHAR(8), DET_CAN DECIMAL(14,4) DEFAULT (0) NOT NULL, DET_PCO BIT DEFAULT (0), DET_SUR VARCHAR(3) CONSTRAINT PK_DETGUI PRIMARY KEY CLUSTERED (DET_NUM,DET_TIP,DET_CIA,DET_ITM), CONSTRAINT CK__DETGUI__DET_CIA__247D636F CHECK ((len([DET_CIA]) > 0)), CONSTRAINT CK__DETGUI__DET_COD__2665ABE1 CHECK ((len([DET_COD]) > 0)), CONSTRAINT CK__DETGUI__DET_TAN__2759D01A CHECK ((len([DET_TAN]) > 0)), CONSTRAINT CK__DETGUI__DET_TIP__22951AFD CHECK ((len([DET_TIP]) > 0))) CREATE TABLE DETING ( DET_TIP VARCHAR(3) DEFAULT ('CIC') NOT NULL, DET_NUM INT DEFAULT (0) NOT NULL, DET_CIA CHAR(2) DEFAULT ('01') NOT NULL, DET_ITM SMALLINT DEFAULT (0) NOT NULL, DET_FEC SMALLDATETIME NOT NULL, DET_CON VARCHAR(3) NOT NULL, DET_DES VARCHAR(100), DET_DEB MONEY DEFAULT (0) NOT NULL, DET_CRE MONEY DEFAULT (0) NOT NULL, DET_CUE VARCHAR(16), DET_NIT VARCHAR(11), DET_BAS MONEY DEFAULT (0), DET_CC VARCHAR(3), DET_CTA VARCHAR(3), DET_TFA VARCHAR(3), DET_FAC VARCHAR(10), DET_CFA CHAR(2), DET_NV SMALLINT DEFAULT (0), DET_AGE VARCHAR(9) CONSTRAINT PK_DETING PRIMARY KEY CLUSTERED (DET_TIP,DET_NUM,DET_CIA,DET_ITM), CONSTRAINT CK__DETING__DET_CIA__2EFAF1E2 CHECK ((len([DET_CIA]) > 0)), CONSTRAINT CK__DETING__DET_CON__30E33A54 CHECK ((len([DET_CON]) > 0)), CONSTRAINT CK__DETING__DET_TIP__2C1E8537 CHECK ((len([DET_TIP]) > 0))) CREATE TABLE DETLEG ( DET_TIP VARCHAR(3) DEFAULT ('LEG') NOT NULL, DET_NUM INT DEFAULT (0) NOT NULL, DET_CIA CHAR(2) DEFAULT ('01') NOT NULL, DET_ITM SMALLINT DEFAULT (0) NOT NULL, DET_CON VARCHAR(3) NOT NULL, DET_FEC SMALLDATETIME, DET_DES VARCHAR(100), DET_VAL MONEY DEFAULT (0), DET_CUE VARCHAR(16), DET_NIT VARCHAR(11), DET_CC VARCHAR(3), DET_CTA VARCHAR(3), DET_BAS MONEY DEFAULT (0), DET_CRE MONEY DEFAULT (0), DET_CAN DECIMAL(16,4) DEFAULT ((0)), DET_TAR DECIMAL(16,4) DEFAULT ((0)) CONSTRAINT PK_DETLEG PRIMARY KEY CLUSTERED (DET_TIP,DET_NUM,DET_CIA,DET_ITM), CONSTRAINT CK__DETLEG__DET_CIA__3B60C8C7 CHECK ((len([DET_CIA]) > 0)), CONSTRAINT CK__DETLEG__DET_CON__3D491139 CHECK ((len([DET_CON]) > 0)), CONSTRAINT CK__DETLEG__DET_TIP__38845C1C CHECK ((len([DET_TIP]) > 0))) CREATE TABLE DETMOR ( DET_TIP VARCHAR(3) DEFAULT ('MOR') NOT NULL, DET_NUM INT DEFAULT (0) NOT NULL, DET_CIA CHAR(2) DEFAULT ('01') NOT NULL, DET_ITM SMALLINT DEFAULT (0) NOT NULL, DET_FEC SMALLDATETIME NOT NULL, DET_TFA VARCHAR(3) DEFAULT ('FCR') NOT NULL, DET_NFA INT DEFAULT (0) NOT NULL, DET_CFA CHAR(2) DEFAULT ('01') NOT NULL, DET_NV SMALLINT DEFAULT (0) NOT NULL, DET_FVC SMALLDATETIME NOT NULL, DET_INI SMALLDATETIME, DET_FIN SMALLDATETIME, DET_DIA SMALLINT DEFAULT (0) NOT NULL, DET_SAL MONEY DEFAULT (0) NOT NULL, DET_VAL MONEY DEFAULT (0) NOT NULL, DET_IVA MONEY DEFAULT (0), DET_NIT VARCHAR(11) NOT NULL, DET_AGE VARCHAR(9) DEFAULT ('N'), DET_NOT INT DEFAULT (0) CONSTRAINT PK_DETMOR PRIMARY KEY CLUSTERED (DET_TIP,DET_NUM,DET_CIA,DET_ITM), CONSTRAINT CK__DETMOR__DET_CFA__4C8B54C9 CHECK ((len([DET_CFA]) > 0)), CONSTRAINT CK__DETMOR__DET_CIA__46D27B73 CHECK ((len([DET_CIA]) > 0)), CONSTRAINT CK__DETMOR__DET_NIT__52442E1F CHECK ((len([DET_NIT]) > 0)), CONSTRAINT CK__DETMOR__DET_TFA__49AEE81E CHECK ((len([DET_TFA]) > 0)), CONSTRAINT CK__DETMOR__DET_TIP__43F60EC8 CHECK ((len([DET_TIP]) > 0))) CREATE TABLE DETMOV ( DET_TIP VARCHAR(3) NOT NULL, DET_NUM INT DEFAULT ((0)) NOT NULL, DET_CIA CHAR(2) DEFAULT ('01') NOT NULL, DET_ITM SMALLINT DEFAULT ((0)) NOT NULL, DET_FEC SMALLDATETIME NOT NULL, DET_TDC VARCHAR(3) DEFAULT ('RMT') NOT NULL, DET_ORD INT DEFAULT ((0)) NOT NULL, DET_COD CHAR(2) NOT NULL, DET_LIN SMALLINT DEFAULT ((0)), DET_FDC SMALLDATETIME, DET_CAR VARCHAR(13) NOT NULL, DET_DES VARCHAR(80), DET_CAN VARCHAR(10) DEFAULT ('0'), DET_PES DECIMAL(14,4) DEFAULT ((0)), DET_UNI VARCHAR(3), DET_REF VARCHAR(250), DET_EMP VARCHAR(3), DET_NAT VARCHAR(3), DET_REM VARCHAR(11), DET_NRM VARCHAR(150), DET_DTN VARCHAR(11), DET_NDE VARCHAR(150), DET_PAG VARCHAR(11), DET_ORI VARCHAR(8), DET_DOR VARCHAR(250), DET_CDE VARCHAR(8), DET_DDE VARCHAR(250), DET_VAL MONEY DEFAULT ((0)), DET_COS MONEY DEFAULT ((0)), DET_NET MONEY DEFAULT ((0)), DET_FAL MONEY DEFAULT ((0)), DET_DCT MONEY DEFAULT ((0)), DET_IVA MONEY DEFAULT ((0)), DET_FAC INT DEFAULT ((-1)), DET_CFA CHAR(2), DET_PED INT DEFAULT ((-1)), DET_CPE CHAR(2), DET_VEH VARCHAR(10), DET_TVH CHAR(1) DEFAULT ('A'), DET_CON VARCHAR(3), DET_DEV INT DEFAULT ((-1)), DET_FDV SMALLDATETIME, DET_RAN VARCHAR(3), DET_KLR DECIMAL(14,4) DEFAULT ((0)), DET_RF1 VARCHAR(250), DET_RF3 VARCHAR(250), DET_ICA MONEY DEFAULT ((0)), DET_PIC DECIMAL(10,4) DEFAULT ((0)), DET_CPI VARCHAR(3), DET_VRF MONEY DEFAULT ((0)), DET_PRF DECIMAL(10,4) DEFAULT ((0)), DET_CPR VARCHAR(3), DET_CC VARCHAR(3), DET_NMT VARCHAR(20) DEFAULT ('0'), DET_TIV VARCHAR(3), DET_INV INT DEFAULT ((0)), DET_CIV CHAR(2), DET_BOD VARCHAR(3), DET_SDR VARCHAR(4), DET_SDD VARCHAR(4) CONSTRAINT PK_DETMOV PRIMARY KEY CLUSTERED (DET_TIP,DET_NUM,DET_CIA,DET_ITM), CONSTRAINT CK__DETMOV__DET_CAR__5EAA0504 CHECK ((len([DET_CAR])>(0))), CONSTRAINT CK__DETMOV__DET_CIA__59E54FE7 CHECK ((len([DET_CIA])>(0))), CONSTRAINT CK__DETMOV__DET_TIP__5708E33C CHECK ((len([DET_TIP])>(0)))) CREATE TABLE DETSER ( DET_TIP VARCHAR(3) DEFAULT ('PDT') NOT NULL, DET_NUM INT DEFAULT (0) NOT NULL, DET_CIA CHAR(2) DEFAULT ('01') NOT NULL, DET_ITM INT DEFAULT (0) NOT NULL, DET_FEC SMALLDATETIME NOT NULL, DET_CLA VARCHAR(10) NOT NULL, DET_CAR VARCHAR(13) NOT NULL, DET_DES VARCHAR(150), DET_CAN DECIMAL(10,4) DEFAULT (0) NOT NULL, DET_PES DECIMAL(10,4) DEFAULT (0) NOT NULL, DET_UNI VARCHAR(3) NOT NULL, DET_VOL DECIMAL(10,4) DEFAULT (0) NOT NULL, DET_EMP VARCHAR(3) NOT NULL, DET_NAT VARCHAR(3), DET_TVH VARCHAR(3), DET_TCO VARCHAR(3), DET_NCO VARCHAR(50), DET_NAV VARCHAR(3), DET_CRC VARCHAR(8), DET_PRC VARCHAR(50), DET_COS MONEY DEFAULT (0) NOT NULL, DET_VAL MONEY DEFAULT (0) NOT NULL, DET_REF VARCHAR(50) CONSTRAINT PK_DETSER PRIMARY KEY CLUSTERED (DET_TIP,DET_NUM,DET_CIA,DET_ITM), CONSTRAINT CK_DETSERDET_CAR CHECK ((len([DET_CAR]) > 0)), CONSTRAINT CK_DETSERDET_CIA CHECK ((len([DET_CIA]) > 0)), CONSTRAINT CK_DETSERDET_CLA CHECK (([DET_CLA] = 'OTRO' or ([DET_CLA] = 'CUPO' or ([DET_CLA] = 'CONTENEDOR' or [DET_CLA] = 'SUELTA')))), CONSTRAINT CK_DETSERDET_EMP CHECK ((len([DET_EMP]) > 0)), CONSTRAINT CK_DETSERDET_TIP CHECK ((len([DET_TIP]) > 0)), CONSTRAINT CK_DETSERDET_UNI CHECK ((len([DET_UNI]) > 0))) CREATE TABLE DEVOLUCIONES ( DEV_NUM INT DEFAULT (0) NOT NULL, DEV_TIP VARCHAR(3) NOT NULL, DEV_CIA CHAR(2) DEFAULT ('01') NOT NULL, DEV_FEC SMALLDATETIME NOT NULL, DEV_CON VARCHAR(3) NOT NULL, DEV_CLI VARCHAR(11), DEV_AGE VARCHAR(9) DEFAULT ('N'), DEV_TDC VARCHAR(3) NOT NULL, DEV_DOC INT DEFAULT (0) NOT NULL, DEV_CDC CHAR(2) DEFAULT ('01'), DEV_VAL MONEY DEFAULT (0), DEV_IVA MONEY DEFAULT (0), DEV_DCT MONEY DEFAULT (0), DEV_RET MONEY DEFAULT (0), DEV_ICA MONEY DEFAULT (0), DEV_COS MONEY DEFAULT (0), DEV_FLE MONEY DEFAULT (0), DEV_OTR MONEY DEFAULT (0), DEV_FAL MONEY DEFAULT (0), DEV_ANT MONEY DEFAULT (0), DEV_SEG MONEY DEFAULT (0), DEV_PAG MONEY DEFAULT (0), DEV_IMP MONEY DEFAULT (0), DEV_NET MONEY DEFAULT (0) NOT NULL, DEV_PAR BIT DEFAULT (0) NOT NULL, DEV_VEN VARCHAR(11), DEV_CMS DECIMAL(14,4) DEFAULT (0), DEV_CPC VARCHAR(3), DEV_CTA VARCHAR(3), DEV_VEH VARCHAR(10), DEV_CUE VARCHAR(16), DEV_CIU VARCHAR(8), DEV_MOD VARCHAR(3), DEV_SOB BIT DEFAULT (0) NOT NULL, DEV_CC VARCHAR(3), DEV_RIV MONEY DEFAULT (0), DEV_EQV BIT DEFAULT (0), DEV_EQT VARCHAR(3), DEV_BOM MONEY DEFAULT (0), DEV_ICO MONEY DEFAULT (0), DEV_CSE MONEY DEFAULT (0), DEV_BDI MONEY DEFAULT (0), DEV_DIV MONEY DEFAULT (0), DEV_IMV MONEY DEFAULT ((0)) NOT NULL, DEV_RTC MONEY DEFAULT ((0)), DEV_TRC DECIMAL(14,4) DEFAULT ((0)), DEV_CRC VARCHAR(3), DEV_IVO MONEY DEFAULT ((0)) CONSTRAINT PK_DEVOLUCIONES PRIMARY KEY CLUSTERED (DEV_NUM,DEV_TIP,DEV_CIA), CONSTRAINT CK__DEVOLUCIO__DEV_C__6FD49106 CHECK ((len([DEV_CIA]) > 0)), CONSTRAINT CK__DEVOLUCIO__DEV_C__70C8B53F CHECK ((len([DEV_CON]) > 0)), CONSTRAINT CK__DEVOLUCIO__DEV_T__6DEC4894 CHECK ((len([DEV_TIP]) > 0)), CONSTRAINT CK__DEVOLUCIO__DEV_T__72B0FDB1 CHECK ((len([DEV_TDC]) > 0))) CREATE TABLE DOCCUENTA ( DCC_NUM INT DEFAULT (0) NOT NULL, DCC_TIP VARCHAR(3) NOT NULL, DCC_CON VARCHAR(3) NOT NULL, DCC_CIA CHAR(2) DEFAULT ('01') NOT NULL, DCC_ITM SMALLINT DEFAULT (0) NOT NULL, DCC_CUE VARCHAR(16) NOT NULL, DCC_FEC SMALLDATETIME, DCC_VAL MONEY DEFAULT (0), DCC_NIT VARCHAR(11), DCC_CC VARCHAR(3), DCC_DET VARCHAR(100), DCC_BAS MONEY DEFAULT (0) CONSTRAINT PK_DOCCUENTA PRIMARY KEY CLUSTERED (DCC_NUM,DCC_TIP,DCC_CON,DCC_CIA,DCC_ITM), CONSTRAINT CK__DOCCUENTA__DCC_C__0A888742 CHECK ((len([DCC_CON]) > 0)), CONSTRAINT CK__DOCCUENTA__DCC_C__0C70CFB4 CHECK ((len([DCC_CIA]) > 0)), CONSTRAINT CK__DOCCUENTA__DCC_C__0E591826 CHECK ((len([DCC_CUE]) > 0)), CONSTRAINT CK__DOCCUENTA__DCC_T__09946309 CHECK ((len([DCC_TIP]) > 0))) CREATE TABLE ENTRADAS ( ENT_NUM INT DEFAULT (0) NOT NULL, ENT_TIP VARCHAR(3) DEFAULT ('ENT') NOT NULL, ENT_CIA CHAR(2) DEFAULT ('01') NOT NULL, ENT_FEC SMALLDATETIME NOT NULL, ENT_CON VARCHAR(3) NOT NULL, ENT_NIT VARCHAR(11) NOT NULL, ENT_TDC VARCHAR(3) DEFAULT ('ODC'), ENT_DOC INT DEFAULT (0), ENT_CDC CHAR(2) DEFAULT ('01'), ENT_FAC VARCHAR(10), ENT_FFA SMALLDATETIME, ENT_FVC SMALLDATETIME, ENT_VAL MONEY DEFAULT (0) NOT NULL, ENT_DCT MONEY DEFAULT (0), ENT_IVA MONEY DEFAULT (0), ENT_RET MONEY DEFAULT (0), ENT_ICA MONEY DEFAULT (0), ENT_FLE MONEY DEFAULT (0), ENT_OTR MONEY DEFAULT (0), ENT_PAG MONEY DEFAULT (0), ENT_IMP MONEY DEFAULT (0), ENT_IFL MONEY DEFAULT (0), ENT_NET MONEY DEFAULT (0) NOT NULL, ENT_NFL VARCHAR(11), ENT_MOD VARCHAR(3), ENT_CXP BIT DEFAULT (0) NOT NULL, ENT_RIV MONEY DEFAULT (0), ENT_EQV BIT DEFAULT (0), ENT_EQT VARCHAR(3), ENT_BOM MONEY DEFAULT (0), ENT_ICO MONEY DEFAULT (0), ENT_FLP BIT DEFAULT ((0)), ENT_IMV MONEY DEFAULT ((0)) NOT NULL, ENT_RTC MONEY DEFAULT ((0)), ENT_TRC DECIMAL(14,4) DEFAULT ((0)), ENT_CRC VARCHAR(3), ENT_IVO MONEY DEFAULT ((0)) CONSTRAINT PK_ENTRADAS PRIMARY KEY CLUSTERED (ENT_NUM,ENT_TIP,ENT_CIA), CONSTRAINT CK__ENTRADAS__ENT_CI__15FA39EE CHECK ((len([ENT_CIA]) > 0)), CONSTRAINT CK__ENTRADAS__ENT_CO__16EE5E27 CHECK ((len([ENT_CON]) > 0)), CONSTRAINT CK__ENTRADAS__ENT_NI__17E28260 CHECK ((len([ENT_NIT]) > 0)), CONSTRAINT CK__ENTRADAS__ENT_TI__1411F17C CHECK ((len([ENT_TIP]) > 0))) CREATE TABLE FACCLI ( CLI_FAC INT DEFAULT (0) NOT NULL, CLI_CIA CHAR(2) DEFAULT ('01') NOT NULL, CLI_NIT VARCHAR(11) CONSTRAINT PK_FACCLI PRIMARY KEY CLUSTERED (CLI_FAC,CLI_CIA), CONSTRAINT CK__FACCLI__CLI_CIA__2BE97B0D CHECK ((len([CLI_CIA]) > 0))) CREATE TABLE FACTURAS ( FAC_NUM INT DEFAULT (0) NOT NULL, FAC_TIP VARCHAR(3) NOT NULL, FAC_CIA CHAR(2) DEFAULT ('01') NOT NULL, FAC_FEC SMALLDATETIME NOT NULL, FAC_CON VARCHAR(3) NOT NULL, FAC_CLI VARCHAR(11) NOT NULL, FAC_AGE VARCHAR(9) DEFAULT ('N'), FAC_VCE SMALLDATETIME, FAC_PED INT DEFAULT (0), FAC_REM INT DEFAULT (0), FAC_COT INT DEFAULT (0), FAC_CPD CHAR(2) DEFAULT ('01'), FAC_CRM CHAR(2) DEFAULT ('01'), FAC_VAL MONEY DEFAULT (0) NOT NULL, FAC_IVA MONEY DEFAULT (0), FAC_DCT MONEY DEFAULT (0), FAC_RET MONEY DEFAULT (0), FAC_ICA MONEY DEFAULT (0), FAC_FLE MONEY DEFAULT (0), FAC_COS MONEY DEFAULT (0), FAC_FAL MONEY DEFAULT (0), FAC_OTR MONEY DEFAULT (0), FAC_PAG MONEY DEFAULT (0), FAC_IMP MONEY DEFAULT (0), FAC_NET MONEY DEFAULT (0) NOT NULL, FAC_VDV MONEY DEFAULT (0), FAC_VEN VARCHAR(11), FAC_CMS DECIMAL(10,4) DEFAULT (0), FAC_CPC VARCHAR(3), FAC_FUP SMALLDATETIME, FAC_MOD VARCHAR(3), FAC_SOB BIT DEFAULT (0) NOT NULL, FAC_TAS BIT DEFAULT (0) NOT NULL, FAC_CIU VARCHAR(8), FAC_RIV MONEY DEFAULT (0), FAC_REF VARCHAR(50), FAC_ICO MONEY DEFAULT (0), FAC_CSE MONEY DEFAULT (0), FAC_VEH VARCHAR(10), FAC_BDI MONEY DEFAULT (0), FAC_DIV MONEY DEFAULT (0), FAC_RTC MONEY DEFAULT ((0)), FAC_TRC DECIMAL(14,4) DEFAULT ((0)), FAC_CRC VARCHAR(3), FAC_IVO MONEY DEFAULT ((0)) CONSTRAINT PK_FACTURAS PRIMARY KEY CLUSTERED (FAC_NUM,FAC_TIP,FAC_CIA), CONSTRAINT CK__FACTURAS__FAC_CI__31A25463 CHECK ((len([FAC_CIA]) > 0)), CONSTRAINT CK__FACTURAS__FAC_CL__338A9CD5 CHECK ((len([FAC_CLI]) > 0)), CONSTRAINT CK__FACTURAS__FAC_CO__3296789C CHECK ((len([FAC_CON]) > 0)), CONSTRAINT CK__FACTURAS__FAC_TI__2FBA0BF1 CHECK ((len([FAC_TIP]) > 0))) CREATE TABLE IFISICO ( FIS_TIP VARCHAR(3) DEFAULT ('FIS') NOT NULL, FIS_NUM INT DEFAULT (0) NOT NULL, FIS_CIA CHAR(2) DEFAULT ('01') NOT NULL, FIS_FEC SMALLDATETIME NOT NULL, FIS_CAN DECIMAL(14,4) DEFAULT (0), FIS_SAL DECIMAL(14,4) DEFAULT (0), FIS_VAL MONEY DEFAULT (0) CONSTRAINT PK_IFISICO PRIMARY KEY CLUSTERED (FIS_TIP,FIS_NUM,FIS_CIA), CONSTRAINT CK__IFISICO__FIS_CIA__4F32B74A CHECK ((len([FIS_CIA]) > 0)), CONSTRAINT CK__IFISICO__FIS_TIP__4C564A9F CHECK ((len([FIS_TIP]) > 0))) CREATE TABLE IMORA ( MOR_TIP VARCHAR(3) DEFAULT ('MOR') NOT NULL, MOR_NUM INT DEFAULT (0) NOT NULL, MOR_CIA CHAR(2) DEFAULT ('01') NOT NULL, MOR_FEC SMALLDATETIME NOT NULL, MOR_TAS DECIMAL(14,4) DEFAULT (0), MOR_GRA SMALLINT DEFAULT (0), MOR_VAL MONEY DEFAULT (0), MOR_IVA MONEY DEFAULT (0) CONSTRAINT PK_IMORA PRIMARY KEY CLUSTERED (MOR_TIP,MOR_NUM,MOR_CIA), CONSTRAINT CK__IMORA__MOR_CIA__58BC2184 CHECK ((len([MOR_CIA]) > 0)), CONSTRAINT CK__IMORA__MOR_TIP__55DFB4D9 CHECK ((len([MOR_TIP]) > 0))) CREATE TABLE INFDOC ( DOC_TIP VARCHAR(3) NOT NULL, DOC_NUM INT DEFAULT (0) NOT NULL, DOC_CIA CHAR(2) DEFAULT ('01') NOT NULL, DOC_CMP VARCHAR(3), DOC_NCP INT DEFAULT (0), DOC_DEV BIT DEFAULT (0) NOT NULL, DOC_NDV INT DEFAULT (0), DOC_FDV SMALLDATETIME, DOC_MUL BIT DEFAULT (0) NOT NULL, DOC_PAG VARCHAR(3), DOC_OBS VARCHAR(250), DOC_BAS MONEY DEFAULT (0), DOC_BA1 MONEY DEFAULT (0), DOC_BA2 MONEY DEFAULT (0), DOC_POR DECIMAL(10,4) DEFAULT (0), DOC_PO1 DECIMAL(10,4) DEFAULT (0), DOC_PO2 DECIMAL(10,4) DEFAULT (0), DOC_COP VARCHAR(3), DOC_CO1 VARCHAR(8), DOC_CO2 VARCHAR(3), DOC_CUM BIT DEFAULT (0) NOT NULL, DOC_FCU SMALLDATETIME, DOC_EST VARCHAR(3), DOC_FEC SMALLDATETIME, DOC_CAN DECIMAL(14,4) DEFAULT (0), DOC_USU VARCHAR(10), DOC_KLR DECIMAL(14,4) DEFAULT (0), DOC_TCU VARCHAR(3), DOC_SUS VARCHAR(3), DOC_CSU VARCHAR(3), DOC_DCU VARCHAR(250) CONSTRAINT PK_INFDOC PRIMARY KEY CLUSTERED (DOC_TIP,DOC_NUM,DOC_CIA), CONSTRAINT CK__INFDOC__DOC_CIA__62458BBE CHECK ((len([DOC_CIA]) > 0)), CONSTRAINT CK__INFDOC__DOC_TIP__5F691F13 CHECK ((len([DOC_TIP]) > 0))) CREATE TABLE INGEGRCAJA ( CAJ_TIP VARCHAR(3) DEFAULT ('CIC') NOT NULL, CAJ_NUM INT DEFAULT (0) NOT NULL, CAJ_CIA CHAR(2) DEFAULT ('01') NOT NULL, CAJ_FEC SMALLDATETIME NOT NULL, CAJ_CON VARCHAR(3) NOT NULL, CAJ_NIT VARCHAR(11), CAJ_CC VARCHAR(3), CAJ_CTA VARCHAR(3), CAJ_CUE VARCHAR(16), CAJ_TOT MONEY DEFAULT (0), CAJ_DEB MONEY DEFAULT (0), CAJ_CRE MONEY DEFAULT (0), CAJ_AGE VARCHAR(9) CONSTRAINT PK_INGEGRCAJA PRIMARY KEY CLUSTERED (CAJ_TIP,CAJ_NUM,CAJ_CIA), CONSTRAINT CK__INGEGRCAJ__CAJ_C__74643BF9 CHECK ((len([CAJ_CIA]) > 0)), CONSTRAINT CK__INGEGRCAJ__CAJ_C__75586032 CHECK ((len([CAJ_CON]) > 0)), CONSTRAINT CK__INGEGRCAJ__CAJ_T__7187CF4E CHECK ((len([CAJ_TIP]) > 0))) CREATE TABLE INVFISICO ( FIS_TAN VARCHAR(3) NOT NULL, FIS_CIA CHAR(2) DEFAULT ('01') NOT NULL, FIS_FEC SMALLDATETIME NOT NULL, FIS_AFO DECIMAL(14,4) DEFAULT (0) NOT NULL, FIS_SAL DECIMAL(14,4) DEFAULT (0), FIS_VAL DECIMAL(14,4) DEFAULT (0), FIS_AFA DECIMAL(14,4) DEFAULT (0), FIS_AGU DECIMAL(14,4) DEFAULT (0) CONSTRAINT PK_INVFISICO PRIMARY KEY CLUSTERED (FIS_TAN,FIS_CIA,FIS_FEC), CONSTRAINT CK__INVFISICO__FIS_C__7CF981FA CHECK ((len([FIS_CIA]) > 0)), CONSTRAINT CK__INVFISICO__FIS_T__7B113988 CHECK ((len([FIS_TAN]) > 0))) CREATE TABLE KARDEX ( KAR_TIP VARCHAR(3) NOT NULL, KAR_NUM INT DEFAULT (0) NOT NULL, KAR_CIA CHAR(2) DEFAULT ('01') NOT NULL, KAR_ITM SMALLINT DEFAULT (1) NOT NULL, KAR_DOC INT DEFAULT (0), KAR_CDC CHAR(2) DEFAULT ('01'), KAR_FEC SMALLDATETIME NOT NULL, KAR_COD VARCHAR(16) NOT NULL, KAR_SEC VARCHAR(3), KAR_ENT DECIMAL(14,4) DEFAULT (0), KAR_SAL DECIMAL(14,4) DEFAULT (0), KAR_VAL MONEY DEFAULT (0) NOT NULL, KAR_PRE MONEY DEFAULT (0), KAR_IVA DECIMAL(10,4) DEFAULT (0), KAR_VIE MONEY DEFAULT (0), KAR_VIS MONEY DEFAULT (0), KAR_DCT DECIMAL(10,4) DEFAULT (0), KAR_VDE MONEY DEFAULT (0), KAR_VDS MONEY DEFAULT (0), KAR_CON VARCHAR(3), KAR_CLI VARCHAR(11), KAR_VEN VARCHAR(11), KAR_CMS DECIMAL(10,4) DEFAULT (0), KAR_CMC DECIMAL(10,4) DEFAULT (0), KAR_TAN VARCHAR(3), KAR_LOT VARCHAR(20), KAR_REM VARCHAR(10), KAR_PED INT DEFAULT (0), KAR_COM BIT DEFAULT (0) NOT NULL, KAR_SUR VARCHAR(3), KAR_INI DECIMAL(17,4) DEFAULT (0), KAR_FIN DECIMAL(17,4) DEFAULT (0), KAR_TAS DECIMAL(10,4) DEFAULT (0), KAR_NAC DECIMAL(10,4) DEFAULT (0), KAR_DEP DECIMAL(10,4) DEFAULT (0), KAR_MUN DECIMAL(10,4) DEFAULT (0), KAR_SOL DECIMAL(10,4) DEFAULT (0), KAR_UNI DECIMAL(14,4) DEFAULT (0), KAR_IMP BIT DEFAULT (0) NOT NULL, KAR_DCO VARCHAR(3), KAR_REF VARCHAR(150) DEFAULT ('0'), KAR_CIU VARCHAR(8), KAR_CEN MONEY DEFAULT (0), KAR_CSA MONEY DEFAULT (0), KAR_PRT DECIMAL(10,4) DEFAULT (0), KAR_RET MONEY DEFAULT (0), KAR_RSA MONEY DEFAULT (0), KAR_BAS MONEY DEFAULT (0), KAR_USU VARCHAR(10), KAR_OPE VARCHAR(11), KAR_CRF VARCHAR(3), KAR_CIC VARCHAR(3), KAR_ICA MONEY DEFAULT (0), KAR_PIC DECIMAL(10,4) DEFAULT (0), KAR_GUI INT DEFAULT (0), KAR_CGU CHAR(2), KAR_ORD INT DEFAULT (0), KAR_COC CHAR(2), KAR_NCO VARCHAR(50), KAR_FOC SMALLDATETIME, KAR_AGE VARCHAR(9) DEFAULT ('N'), KAR_ICO DECIMAL(14,4) DEFAULT (0), KAR_TIC VARCHAR(3), KAR_CUS MONEY DEFAULT (0), KAR_TCV CHAR(1), KAR_TCC CHAR(1), KAR_DIV MONEY DEFAULT (0), KAR_CC VARCHAR(3), KAR_TIM DECIMAL(14,4) DEFAULT ((0)), KAR_IMV DECIMAL(16,4) DEFAULT ((0)), KAR_COB DECIMAL(14,4) DEFAULT ((0)), KAR_IOB DECIMAL(16,4) DEFAULT ((0)) CONSTRAINT PK_KARDEX PRIMARY KEY CLUSTERED (KAR_TIP,KAR_NUM,KAR_CIA,KAR_ITM), CONSTRAINT CK__KARDEX__KAR_CIA__0777106D CHECK ((len([KAR_CIA]) > 0)), CONSTRAINT CK__KARDEX__KAR_COD__0B47A151 CHECK ((len([KAR_COD]) > 0)), CONSTRAINT CK__KARDEX__KAR_TIP__049AA3C2 CHECK ((len([KAR_TIP]) > 0))) CREATE TABLE LEGALIZACION ( LEG_TIP VARCHAR(3) DEFAULT ('LEG') NOT NULL, LEG_NUM INT DEFAULT (0) NOT NULL, LEG_CIA CHAR(2) DEFAULT ('01') NOT NULL, LEG_FEC SMALLDATETIME NOT NULL, LEG_TPL VARCHAR(3) DEFAULT ('PLT'), LEG_PLA INT DEFAULT (0) NOT NULL, LEG_CPL CHAR(2) DEFAULT ('01') NOT NULL, LEG_FPL SMALLDATETIME, LEG_VEH VARCHAR(10), LEG_NIT VARCHAR(11), LEG_CDT VARCHAR(11), LEG_CON VARCHAR(3) DEFAULT ('LEG'), LEG_REG VARCHAR(20), LEG_ORI VARCHAR(8), LEG_DES VARCHAR(8), LEG_CLI VARCHAR(11), LEG_PRO VARCHAR(13), LEG_VAL MONEY DEFAULT (0), LEG_ANT MONEY DEFAULT (0), LEG_GAL DECIMAL(14,4) DEFAULT (0), LEG_COM MONEY DEFAULT (0), LEG_REC MONEY DEFAULT (0), LEG_ING MONEY DEFAULT (0), LEG_RUT VARCHAR(3), LEG_DTN VARCHAR(11), LEG_KMI INT DEFAULT (0), LEG_KMF INT DEFAULT (0) CONSTRAINT PK_LEGALIZACION PRIMARY KEY CLUSTERED (LEG_TIP,LEG_NUM,LEG_CIA), CONSTRAINT CK__LEGALIZAC__LEG_C__2E90DD8E CHECK ((len([LEG_CIA]) > 0)), CONSTRAINT CK__LEGALIZAC__LEG_C__32616E72 CHECK ((len([LEG_CPL]) > 0)), CONSTRAINT CK__LEGALIZAC__LEG_T__2BB470E3 CHECK ((len([LEG_TIP]) > 0))) CREATE TABLE LEGALIZACOMB ( COM_TIP VARCHAR(3) DEFAULT ('LEG') NOT NULL, COM_NUM INT DEFAULT ((0)) NOT NULL, COM_CIA CHAR(2) DEFAULT ('01') NOT NULL, COM_ITM INT DEFAULT ((0)) NOT NULL, COM_COD VARCHAR(3), COM_DES VARCHAR(150) NOT NULL, COM_CAN DECIMAL(14,4) DEFAULT ((0)) NOT NULL, COM_VAL MONEY DEFAULT ((0)) NOT NULL CONSTRAINT PK_LEGALIZACOMB PRIMARY KEY CLUSTERED (COM_TIP,COM_NUM,COM_CIA,COM_ITM), CONSTRAINT CK_LEGALIZACOMBCOM_CIA CHECK ((len([COM_CIA])>(0))), CONSTRAINT CK_LEGALIZACOMBCOM_DES CHECK ((len([COM_DES])>(0))), CONSTRAINT CK_LEGALIZACOMBCOM_TIP CHECK ((len([COM_TIP])>(0)))) CREATE TABLE LEGOTROS ( LEG_TIP VARCHAR(3) DEFAULT ('LOE') NOT NULL, LEG_NUM INT DEFAULT (0) NOT NULL, LEG_CIA CHAR(2) DEFAULT ('01') NOT NULL, LEG_FEC SMALLDATETIME NOT NULL, LEG_VEH VARCHAR(10) NOT NULL, LEG_NIT VARCHAR(11) NOT NULL, LEG_CON VARCHAR(11), LEG_REF VARCHAR(20), LEG_PLA INT DEFAULT (0), LEG_ORI VARCHAR(8), LEG_DES VARCHAR(8), LEG_VAL MONEY DEFAULT (0), LEG_RUT VARCHAR(3), LEG_EMP VARCHAR(11), LEG_KMI INT DEFAULT (0), LEG_KMF INT DEFAULT (0), LEG_GAL DECIMAL(14,4) DEFAULT (0), LEG_FAC INT DEFAULT (0), LEG_CFA CHAR(2), LEG_FFA SMALLDATETIME CONSTRAINT PK_LEGOTROS PRIMARY KEY CLUSTERED (LEG_TIP,LEG_NUM,LEG_CIA), CONSTRAINT CK__LEGOTROS__LEG_CI__3FBB6990 CHECK ((len([LEG_CIA]) > 0)), CONSTRAINT CK__LEGOTROS__LEG_NI__41A3B202 CHECK ((len([LEG_NIT]) > 0)), CONSTRAINT CK__LEGOTROS__LEG_TI__3CDEFCE5 CHECK ((len([LEG_TIP]) > 0)), CONSTRAINT CK__LEGOTROS__LEG_VE__40AF8DC9 CHECK ((len([LEG_VEH]) > 0))) CREATE TABLE MOVSECCDET ( DET_TIP VARCHAR(3) NOT NULL, DET_NUM INT DEFAULT (0) NOT NULL, DET_CIA CHAR(2) NOT NULL, DET_ITM INT DEFAULT (0) NOT NULL, DET_FEC SMALLDATETIME NOT NULL, DET_PRO VARCHAR(16) NOT NULL, DET_SEC VARCHAR(3) NOT NULL, DET_CAN DECIMAL(14,4) DEFAULT (0) NOT NULL, DET_DEV DECIMAL(14,4) DEFAULT (0) NOT NULL, DET_TDC VARCHAR(3) NOT NULL, DET_NDC INT DEFAULT (0) NOT NULL, DET_CDC CHAR(2) NOT NULL, DET_HOR SMALLDATETIME NOT NULL, DET_USU VARCHAR(8) NOT NULL, DET_OBS VARCHAR(150) CONSTRAINT PK_MOVSECCDET PRIMARY KEY CLUSTERED (DET_TIP,DET_NUM,DET_CIA,DET_ITM), CONSTRAINT CK_MOVSECCDETDET_CDC CHECK ((len([DET_CDC]) > 0)), CONSTRAINT CK_MOVSECCDETDET_CIA CHECK ((len([DET_CIA]) > 0)), CONSTRAINT CK_MOVSECCDETDET_PRO CHECK ((len([DET_PRO]) > 0)), CONSTRAINT CK_MOVSECCDETDET_SEC CHECK ((len([DET_SEC]) > 0)), CONSTRAINT CK_MOVSECCDETDET_TDC CHECK ((len([DET_TDC]) > 0)), CONSTRAINT CK_MOVSECCDETDET_TIP CHECK ((len([DET_TIP]) > 0)), CONSTRAINT CK_MOVSECCDETDET_USU CHECK ((len([DET_USU]) > 0))) CREATE TABLE MOVSECCION ( SEC_TIP VARCHAR(3) NOT NULL, SEC_NUM INT DEFAULT (0) NOT NULL, SEC_CIA CHAR(2) NOT NULL, SEC_ITM INT DEFAULT (0) NOT NULL, SEC_PRO VARCHAR(16) NOT NULL, SEC_COD VARCHAR(3) NOT NULL, SEC_CAN DECIMAL(14,4) DEFAULT (0) NOT NULL, SEC_ENT DECIMAL(14,4) DEFAULT (0) NOT NULL, SEC_DEV DECIMAL(14,4) DEFAULT (0) NOT NULL CONSTRAINT PK_MOVSECCION PRIMARY KEY CLUSTERED (SEC_TIP,SEC_NUM,SEC_CIA,SEC_ITM), CONSTRAINT CK_MOVSECCIONSEC_CIA CHECK ((len([SEC_CIA]) > 0)), CONSTRAINT CK_MOVSECCIONSEC_COD CHECK ((len([SEC_COD]) > 0)), CONSTRAINT CK_MOVSECCIONSEC_PRO CHECK ((len([SEC_PRO]) > 0)), CONSTRAINT CK_MOVSECCIONSEC_TIP CHECK ((len([SEC_TIP]) > 0))) CREATE TABLE MOVSERIAL ( MOV_TIP VARCHAR(3) NOT NULL, MOV_DOC INT DEFAULT (0) NOT NULL, MOV_CIA CHAR(2) DEFAULT ('01') NOT NULL, MOV_LIN SMALLINT DEFAULT (0) NOT NULL, MOV_COD VARCHAR(16) NOT NULL, MOV_NUM VARCHAR(20) NOT NULL, MOV_ITM SMALLINT DEFAULT (0), MOV_SEC VARCHAR(3), MOV_MOV VARCHAR(3), MOV_FEC SMALLDATETIME, MOV_OBS VARCHAR(50), MOV_DCM VARCHAR(10) CONSTRAINT PK_MOVSERIAL PRIMARY KEY CLUSTERED (MOV_TIP,MOV_DOC,MOV_CIA,MOV_LIN), CONSTRAINT CK__MOVSERIAL__MOV_C__4944D3CA CHECK ((len([MOV_CIA]) > 0)), CONSTRAINT CK__MOVSERIAL__MOV_C__4B2D1C3C CHECK ((len([MOV_COD]) > 0)), CONSTRAINT CK__MOVSERIAL__MOV_N__4C214075 CHECK ((len([MOV_NUM]) > 0)), CONSTRAINT CK__MOVSERIAL__MOV_T__4668671F CHECK ((len([MOV_TIP]) > 0))) CREATE TABLE MUD_BODEGAS ( BOD_TIP VARCHAR(3) NOT NULL, BOD_NUM INT DEFAULT (0) NOT NULL, BOD_CIA CHAR(2) DEFAULT ('01') NOT NULL, BOD_ITM INT DEFAULT (0) NOT NULL, BOD_COD VARCHAR(3) NOT NULL, BOD_DIR VARCHAR(150) NOT NULL, BOD_INI SMALLDATETIME NOT NULL, BOD_FIN SMALLDATETIME, BOD_VAL MONEY DEFAULT (0) NOT NULL, BOD_IVA MONEY DEFAULT (0) NOT NULL, BOD_SEG MONEY DEFAULT (0) NOT NULL, BOD_TFA VARCHAR(3) DEFAULT ('FCR') NOT NULL, BOD_FAC INT DEFAULT (0) NOT NULL, BOD_CFA CHAR(2) DEFAULT ('00') NOT NULL, BOD_OBS VARCHAR(250), BOD_USU VARCHAR(10) NOT NULL, BOD_BG2 VARCHAR(3), BOD_BG3 VARCHAR(3) CONSTRAINT PK_MUD_BODEGAS PRIMARY KEY CLUSTERED (BOD_TIP,BOD_NUM,BOD_CIA,BOD_ITM), CONSTRAINT CK_MUD_BODEGASBOD_CFA CHECK ((len([BOD_CFA]) > 0)), CONSTRAINT CK_MUD_BODEGASBOD_CIA CHECK ((len([BOD_CIA]) > 0)), CONSTRAINT CK_MUD_BODEGASBOD_COD CHECK ((len([BOD_COD]) > 0)), CONSTRAINT CK_MUD_BODEGASBOD_DIR CHECK ((len([BOD_DIR]) > 0)), CONSTRAINT CK_MUD_BODEGASBOD_TFA CHECK ((len([BOD_TFA]) > 0)), CONSTRAINT CK_MUD_BODEGASBOD_TIP CHECK ((len([BOD_TIP]) > 0)), CONSTRAINT CK_MUD_BODEGASBOD_USU CHECK ((len([BOD_USU]) > 0))) CREATE TABLE MUD_DETALLE ( DET_TIP VARCHAR(3) NOT NULL, DET_NUM INT DEFAULT (0) NOT NULL, DET_CIA CHAR(2) DEFAULT ('01') NOT NULL, DET_ITM INT DEFAULT (0) NOT NULL, DET_DES VARCHAR(250) NOT NULL, DET_CAN DECIMAL(14,4) DEFAULT (0) NOT NULL, DET_EST VARCHAR(10) NOT NULL, DET_OBS VARCHAR(150) CONSTRAINT PK_MUD_DETALLE PRIMARY KEY CLUSTERED (DET_TIP,DET_NUM,DET_CIA,DET_ITM), CONSTRAINT CK_MUD_DETALLEDET_CIA CHECK ((len([DET_CIA]) > 0)), CONSTRAINT CK_MUD_DETALLEDET_DES CHECK ((len([DET_DES]) > 0)), CONSTRAINT CK_MUD_DETALLEDET_EST CHECK ((len([DET_EST]) > 0)), CONSTRAINT CK_MUD_DETALLEDET_TIP CHECK ((len([DET_TIP]) > 0))) CREATE TABLE MUD_EMBALAJES ( EMB_TIP VARCHAR(3) NOT NULL, EMB_NUM INT DEFAULT (0) NOT NULL, EMB_CIA CHAR(2) DEFAULT ('01') NOT NULL, EMB_ORD INT DEFAULT (0) NOT NULL, EMB_FEC SMALLDATETIME NOT NULL, EMB_VAL MONEY DEFAULT (0) NOT NULL, EMB_TSA VARCHAR(3), EMB_NSA INT DEFAULT (0) NOT NULL, EMB_CSA CHAR(2), EMB_TDS VARCHAR(3), EMB_NDS INT DEFAULT (0) NOT NULL, EMB_CDS CHAR(2), EMB_DEV BIT DEFAULT (0) NOT NULL, EMB_OBS VARCHAR(250), EMB_ALM VARCHAR(150), EMB_SUP VARCHAR(150), EMB_USU VARCHAR(10) NOT NULL CONSTRAINT PK_MUD_EMBALAJES PRIMARY KEY CLUSTERED (EMB_TIP,EMB_NUM,EMB_CIA,EMB_ORD), CONSTRAINT CK_MUD_EMBALAJESEMB_CIA CHECK ((len([EMB_CIA]) > 0)), CONSTRAINT CK_MUD_EMBALAJESEMB_TIP CHECK ((len([EMB_TIP]) > 0)), CONSTRAINT CK_MUD_EMBALAJESEMB_USU CHECK ((len([EMB_USU]) > 0))) CREATE TABLE MUD_EMBDETALLE ( DET_TIP VARCHAR(3) NOT NULL, DET_NUM INT DEFAULT (0) NOT NULL, DET_CIA CHAR(2) DEFAULT ('01') NOT NULL, DET_ORD INT DEFAULT (0) NOT NULL, DET_ITM INT DEFAULT (0) NOT NULL, DET_COD VARCHAR(16) DEFAULT ('0') NOT NULL, DET_DES VARCHAR(150) NOT NULL, DET_CAN DECIMAL(14,4) DEFAULT (0) NOT NULL, DET_DEV DECIMAL(14,4) DEFAULT (0) NOT NULL CONSTRAINT PK_MUD_EMBDETALLE PRIMARY KEY CLUSTERED (DET_TIP,DET_NUM,DET_CIA,DET_ORD,DET_ITM), CONSTRAINT CK_MUD_EMBDETALLEDET_CIA CHECK ((len([DET_CIA]) > 0)), CONSTRAINT CK_MUD_EMBDETALLEDET_COD CHECK ((len([DET_COD]) > 0)), CONSTRAINT CK_MUD_EMBDETALLEDET_DES CHECK ((len([DET_DES]) > 0)), CONSTRAINT CK_MUD_EMBDETALLEDET_TIP CHECK ((len([DET_TIP]) > 0))) CREATE TABLE MUD_EMPACADORES ( EMP_TIP VARCHAR(3) NOT NULL, EMP_NUM INT DEFAULT (0) NOT NULL, EMP_CIA CHAR(2) DEFAULT ('01') NOT NULL, EMP_ORD INT DEFAULT (0) NOT NULL, EMP_ITM INT DEFAULT (0) NOT NULL, EMP_NOM VARCHAR(150) NOT NULL, EMP_ID VARCHAR(11), EMP_SER VARCHAR(10), EMP_HOR VARCHAR(50), EMP_TAR DECIMAL(14,4) DEFAULT (0) CONSTRAINT PK_MUD_EMPACADORES PRIMARY KEY CLUSTERED (EMP_TIP,EMP_NUM,EMP_CIA,EMP_ORD,EMP_ITM), CONSTRAINT CK_MUD_EMPACADORESEMP_CIA CHECK ((len([EMP_CIA]) > 0)), CONSTRAINT CK_MUD_EMPACADORESEMP_NOM CHECK ((len([EMP_NOM]) > 0)), CONSTRAINT CK_MUD_EMPACADORESEMP_TIP CHECK ((len([EMP_TIP]) > 0))) CREATE TABLE MUD_NOVEDADES ( NOV_TIP VARCHAR(3) NOT NULL, NOV_NUM INT DEFAULT (0) NOT NULL, NOV_CIA CHAR(2) DEFAULT ('01') NOT NULL, NOV_ITM INT DEFAULT (0) NOT NULL, NOV_FEC SMALLDATETIME NOT NULL, NOV_DES VARCHAR(250) NOT NULL, NOV_CON VARCHAR(10), NOV_CAN DECIMAL(14,4) DEFAULT (0) NOT NULL, NOV_NOM VARCHAR(150) CONSTRAINT PK_MUD_NOVEDADES PRIMARY KEY CLUSTERED (NOV_TIP,NOV_NUM,NOV_CIA,NOV_ITM), CONSTRAINT CK_MUD_NOVEDADESNOV_CIA CHECK ((len([NOV_CIA]) > 0)), CONSTRAINT CK_MUD_NOVEDADESNOV_DES CHECK ((len([NOV_DES]) > 0)), CONSTRAINT CK_MUD_NOVEDADESNOV_TIP CHECK ((len([NOV_TIP]) > 0))) CREATE TABLE MUD_OPERARIOS ( OPE_TIP VARCHAR(3) NOT NULL, OPE_NUM INT DEFAULT (0) NOT NULL, OPE_CIA CHAR(2) DEFAULT ('01') NOT NULL, OPE_ITM INT DEFAULT (0) NOT NULL, OPE_NOM VARCHAR(150) NOT NULL, OPE_ID VARCHAR(11) DEFAULT ('0') NOT NULL, OPE_CLA VARCHAR(20) NOT NULL, OPE_SER VARCHAR(10), OPE_HOR VARCHAR(50), OPE_TAR DECIMAL(14,4) DEFAULT (0), OPE_BAS MONEY DEFAULT (0) CONSTRAINT PK_MUD_OPERARIOS PRIMARY KEY CLUSTERED (OPE_TIP,OPE_NUM,OPE_CIA,OPE_ITM), CONSTRAINT CK_MUD_OPERARIOSOPE_CIA CHECK ((len([OPE_CIA]) > 0)), CONSTRAINT CK_MUD_OPERARIOSOPE_CLA CHECK ((len([OPE_CLA]) > 0)), CONSTRAINT CK_MUD_OPERARIOSOPE_ID CHECK ((len([OPE_ID]) > 0)), CONSTRAINT CK_MUD_OPERARIOSOPE_NOM CHECK ((len([OPE_NOM]) > 0)), CONSTRAINT CK_MUD_OPERARIOSOPE_TIP CHECK ((len([OPE_TIP]) > 0))) CREATE TABLE MUDANZAS ( MUD_TIP VARCHAR(3) NOT NULL, MUD_NUM INT DEFAULT (0) NOT NULL, MUD_CIA CHAR(2) DEFAULT ('01') NOT NULL, MUD_FEC SMALLDATETIME NOT NULL, MUD_FDE SMALLDATETIME NOT NULL, MUD_MOD VARCHAR(10) DEFAULT ('TRANSPORTE') NOT NULL, MUD_VEN VARCHAR(11) NOT NULL, MUD_CLI VARCHAR(11) NOT NULL, MUD_AGE VARCHAR(9) DEFAULT ('N'), MUD_VEH VARCHAR(10) NOT NULL, MUD_CDT VARCHAR(11) NOT NULL, MUD_EMP VARCHAR(11), MUD_NEM VARCHAR(150), MUD_DOR VARCHAR(250) NOT NULL, MUD_ORI VARCHAR(8) NOT NULL, MUD_TRC VARCHAR(10) DEFAULT ('CASA') NOT NULL, MUD_TOR VARCHAR(20), MUD_CLR VARCHAR(20), MUD_DDE VARCHAR(250) NOT NULL, MUD_DES VARCHAR(8) NOT NULL, MUD_TRD VARCHAR(10) DEFAULT ('CASA') NOT NULL, MUD_TLD VARCHAR(20), MUD_CLD VARCHAR(20), MUD_CAN INT DEFAULT (0) NOT NULL, MUD_CCL INT DEFAULT (0) NOT NULL, MUD_UND INT DEFAULT (0) NOT NULL, MUD_DEC MONEY DEFAULT (0) NOT NULL, MUD_TRA MONEY DEFAULT (0) NOT NULL, MUD_SEG MONEY DEFAULT (0) NOT NULL, MUD_BOD MONEY DEFAULT (0) NOT NULL, MUD_SGB MONEY DEFAULT (0) NOT NULL, MUD_OTR MONEY DEFAULT (0) NOT NULL, MUD_TRM VARCHAR(3) DEFAULT ('RMT') NOT NULL, MUD_REM INT DEFAULT (0) NOT NULL, MUD_CRM CHAR(2) DEFAULT ('01') NOT NULL, MUD_TFA VARCHAR(3) DEFAULT ('FCR') NOT NULL, MUD_FAC INT DEFAULT (0) NOT NULL, MUD_CFA CHAR(2) DEFAULT ('00') NOT NULL, MUD_FFA SMALLDATETIME, MUD_AUT VARCHAR(50), MUD_PED INT DEFAULT (0) NOT NULL, MUD_CPE CHAR(2), MUD_IMG VARCHAR(100) CONSTRAINT PK_MUDANZAS PRIMARY KEY CLUSTERED (MUD_TIP,MUD_NUM,MUD_CIA), CONSTRAINT CK_MUDANZASMUD_CDT CHECK ((len([MUD_CDT]) > 0)), CONSTRAINT CK_MUDANZASMUD_CFA CHECK ((len([MUD_CFA]) > 0)), CONSTRAINT CK_MUDANZASMUD_CIA CHECK ((len([MUD_CIA]) > 0)), CONSTRAINT CK_MUDANZASMUD_CLI CHECK ((len([MUD_CLI]) > 0)), CONSTRAINT CK_MUDANZASMUD_CRM CHECK ((len([MUD_CRM]) > 0)), CONSTRAINT CK_MUDANZASMUD_DDE CHECK ((len([MUD_DDE]) > 0)), CONSTRAINT CK_MUDANZASMUD_DES CHECK ((len([MUD_DES]) > 0)), CONSTRAINT CK_MUDANZASMUD_DOR CHECK ((len([MUD_DOR]) > 0)), CONSTRAINT CK_MUDANZASMUD_MOD CHECK ((len([MUD_MOD]) > 0)), CONSTRAINT CK_MUDANZASMUD_ORI CHECK ((len([MUD_ORI]) > 0)), CONSTRAINT CK_MUDANZASMUD_TFA CHECK ((len([MUD_TFA]) > 0)), CONSTRAINT CK_MUDANZASMUD_TIP CHECK ((len([MUD_TIP]) > 0)), CONSTRAINT CK_MUDANZASMUD_TRC CHECK ((len([MUD_TRC]) > 0)), CONSTRAINT CK_MUDANZASMUD_TRD CHECK ((len([MUD_TRD]) > 0)), CONSTRAINT CK_MUDANZASMUD_TRM CHECK ((len([MUD_TRM]) > 0)), CONSTRAINT CK_MUDANZASMUD_VEH CHECK ((len([MUD_VEH]) > 0)), CONSTRAINT CK_MUDANZASMUD_VEN CHECK ((len([MUD_VEN]) > 0))) CREATE TABLE MULTAS ( MUL_TIP VARCHAR(3) DEFAULT ('MUL') NOT NULL, MUL_NUM INT DEFAULT (0) NOT NULL, MUL_CIA CHAR(2) DEFAULT ('01') NOT NULL, MUL_FEC SMALLDATETIME NOT NULL, MUL_TPL VARCHAR(3) DEFAULT ('PLT') NOT NULL, MUL_PLA INT DEFAULT (0) NOT NULL, MUL_CPL CHAR(2) DEFAULT ('01') NOT NULL, MUL_NIT VARCHAR(11) NOT NULL, MUL_VEH VARCHAR(10) NOT NULL, MUL_PUE VARCHAR(3), MUL_VAL MONEY DEFAULT (0) NOT NULL, MUL_APL MONEY DEFAULT (0), MUL_DOC INT DEFAULT (0) CONSTRAINT PK_MULTAS PRIMARY KEY CLUSTERED (MUL_TIP,MUL_NUM,MUL_CIA), CONSTRAINT CK__MULTAS__MUL_CIA__53C2623D CHECK ((len([MUL_CIA]) > 0)), CONSTRAINT CK__MULTAS__MUL_CPL__5887175A CHECK ((len([MUL_CPL]) > 0)), CONSTRAINT CK__MULTAS__MUL_NIT__597B3B93 CHECK ((len([MUL_NIT]) > 0)), CONSTRAINT CK__MULTAS__MUL_TIP__50E5F592 CHECK ((len([MUL_TIP]) > 0)), CONSTRAINT CK__MULTAS__MUL_TPL__55AAAAAF CHECK ((len([MUL_TPL]) > 0)), CONSTRAINT CK__MULTAS__MUL_VEH__5A6F5FCC CHECK ((len([MUL_VEH]) > 0))) CREATE TABLE NOTAS ( NOT_NUM INT DEFAULT (0) NOT NULL, NOT_TIP VARCHAR(3) NOT NULL, NOT_CIA CHAR(2) DEFAULT ('01') NOT NULL, NOT_FEC SMALLDATETIME NOT NULL, NOT_CON VARCHAR(3) NOT NULL, NOT_CLI VARCHAR(11) NOT NULL, NOT_AGE VARCHAR(9) DEFAULT ('N'), NOT_VCE SMALLDATETIME, NOT_REF VARCHAR(10), NOT_TDC VARCHAR(3), NOT_DOC INT DEFAULT (0), NOT_CDC CHAR(2) DEFAULT ('01'), NOT_VAL MONEY DEFAULT (0), NOT_IVA MONEY DEFAULT (0), NOT_ICA MONEY DEFAULT (0), NOT_RET MONEY DEFAULT (0), NOT_COS MONEY DEFAULT (0), NOT_NET MONEY DEFAULT (0) NOT NULL, NOT_VEN VARCHAR(11), NOT_CMS DECIMAL(10,4) DEFAULT (0), NOT_CPC VARCHAR(3), NOT_CHE VARCHAR(20), NOT_CIU VARCHAR(8), NOT_CTA VARCHAR(3), NOT_PAR BIT DEFAULT (0) NOT NULL, NOT_CAJ MONEY DEFAULT (0), NOT_PRO VARCHAR(16), NOT_SAN MONEY DEFAULT (0), NOT_RTC MONEY DEFAULT ((0)), NOT_TRC DECIMAL(14,4) DEFAULT ((0)), NOT_CRC VARCHAR(3) CONSTRAINT PK_NOTAS PRIMARY KEY CLUSTERED (NOT_NUM,NOT_TIP,NOT_CIA), CONSTRAINT CK__NOTAS__NOT_CIA__6304A5CD CHECK ((len([NOT_CIA]) > 0)), CONSTRAINT CK__NOTAS__NOT_CLI__64ECEE3F CHECK ((len([NOT_CLI]) > 0)), CONSTRAINT CK__NOTAS__NOT_CON__63F8CA06 CHECK ((len([NOT_CON]) > 0)), CONSTRAINT CK__NOTAS__NOT_TIP__611C5D5B CHECK ((len([NOT_TIP]) > 0))) CREATE TABLE OPAGO ( ODP_NUM INT DEFAULT (0) NOT NULL, ODP_TIP VARCHAR(3) DEFAULT ('ODP') NOT NULL, ODP_CIA CHAR(2) DEFAULT ('01') NOT NULL, ODP_FEC SMALLDATETIME NOT NULL, ODP_TPL VARCHAR(3) DEFAULT ('PLT') NOT NULL, ODP_PLA INT DEFAULT (0) NOT NULL, ODP_CPL CHAR(2) DEFAULT ('01') NOT NULL, ODP_REF VARCHAR(20), ODP_VEH VARCHAR(10) NOT NULL, ODP_NIT VARCHAR(11) NOT NULL, ODP_CON VARCHAR(3), ODP_VAL MONEY DEFAULT (0), ODP_DCT MONEY DEFAULT (0), ODP_TOT MONEY DEFAULT (0), ODP_ICA MONEY DEFAULT (0), ODP_RET MONEY DEFAULT (0), ODP_SEG MONEY DEFAULT (0), ODP_ANT MONEY DEFAULT (0), ODP_FAL MONEY DEFAULT (0), ODP_OTR MONEY DEFAULT (0), ODP_PAG MONEY DEFAULT (0), ODP_NET MONEY DEFAULT (0) NOT NULL, ODP_FLE MONEY DEFAULT (0), ODP_REM INT DEFAULT (0), ODP_CRM CHAR(2), ODP_EGR INT DEFAULT ((-1)), ODP_CEG CHAR(2), ODP_FEG SMALLDATETIME, ODP_CHE VARCHAR(20), ODP_CXP BIT DEFAULT (0) NOT NULL, ODP_VES MONEY DEFAULT (0), ODP_BOM MONEY DEFAULT (0), ODP_MUL MONEY DEFAULT (0), ODP_RTC MONEY DEFAULT ((0)), ODP_TRC DECIMAL(14,4) DEFAULT ((0)), ODP_CRC VARCHAR(3) CONSTRAINT PK_OPAGO PRIMARY KEY CLUSTERED (ODP_NUM,ODP_TIP,ODP_CIA), CONSTRAINT CK__OPAGO__ODP_CIA__770B9E7A CHECK ((len([ODP_CIA]) > 0)), CONSTRAINT CK__OPAGO__ODP_CPL__7BD05397 CHECK ((len([ODP_CPL]) > 0)), CONSTRAINT CK__OPAGO__ODP_NIT__7DB89C09 CHECK ((len([ODP_NIT]) > 0)), CONSTRAINT CK__OPAGO__ODP_TIP__75235608 CHECK ((len([ODP_TIP]) > 0)), CONSTRAINT CK__OPAGO__ODP_TPL__78F3E6EC CHECK ((len([ODP_TPL]) > 0)), CONSTRAINT CK__OPAGO__ODP_VEH__7CC477D0 CHECK ((len([ODP_VEH]) > 0))) CREATE TABLE OPMULTAS ( OPM_TIP VARCHAR(3) NOT NULL, OPM_NUM INT DEFAULT (0) NOT NULL, OPM_CIA CHAR(2) NOT NULL, OPM_ITM INT DEFAULT (0) NOT NULL, OPM_FEC SMALLDATETIME NOT NULL, OPM_TMU VARCHAR(3) NOT NULL, OPM_MUL INT DEFAULT (0) NOT NULL, OPM_CMU CHAR(2) NOT NULL, OPM_VAL MONEY DEFAULT (0) NOT NULL CONSTRAINT PK_OPMULTAS PRIMARY KEY CLUSTERED (OPM_TIP,OPM_NUM,OPM_CIA,OPM_ITM), CONSTRAINT CK_OPMULTASOPM_CIA CHECK ((len([OPM_CIA]) > 0)), CONSTRAINT CK_OPMULTASOPM_CMU CHECK ((len([OPM_CMU]) > 0)), CONSTRAINT CK_OPMULTASOPM_TIP CHECK ((len([OPM_TIP]) > 0)), CONSTRAINT CK_OPMULTASOPM_TMU CHECK ((len([OPM_TMU]) > 0))) CREATE TABLE ORDVIAJES ( ODC_TIP VARCHAR(3) DEFAULT ('OCV') NOT NULL, ODC_NUM INT DEFAULT ((0)) NOT NULL, ODC_CIA CHAR(2) NOT NULL, ODC_FEC SMALLDATETIME NOT NULL, ODC_VEH VARCHAR(10) NOT NULL, ODC_CON VARCHAR(11) NOT NULL, ODC_TRA VARCHAR(10), ODC_ORI VARCHAR(8) NOT NULL, ODC_DES VARCHAR(8) NOT NULL, ODC_VAL MONEY DEFAULT ((0)), ODC_MUC INT DEFAULT ((0)) NOT NULL, ODC_CMC CHAR(2), ODC_NRM VARCHAR(20) CONSTRAINT PK_ORDVIAJES PRIMARY KEY CLUSTERED (ODC_TIP,ODC_NUM,ODC_CIA), CONSTRAINT CK_ORDVIAJESODC_CIA CHECK ((len([ODC_CIA])>(0))), CONSTRAINT CK_ORDVIAJESODC_CON CHECK ((len([ODC_CON])>(0))), CONSTRAINT CK_ORDVIAJESODC_DES CHECK ((len([ODC_DES])>(0))), CONSTRAINT CK_ORDVIAJESODC_ORI CHECK ((len([ODC_ORI])>(0))), CONSTRAINT CK_ORDVIAJESODC_TIP CHECK ((len([ODC_TIP])>(0))), CONSTRAINT CK_ORDVIAJESODC_VEH CHECK ((len([ODC_VEH])>(0)))) CREATE TABLE PAGOS ( PAG_NUM INT DEFAULT (0) NOT NULL, PAG_TIP VARCHAR(3) NOT NULL, PAG_CIA CHAR(2) DEFAULT ('01') NOT NULL, PAG_ITM SMALLINT DEFAULT (0) NOT NULL, PAG_FEC SMALLDATETIME NOT NULL, PAG_FOR VARCHAR(3) DEFAULT ('EFE') NOT NULL, PAG_VAL MONEY DEFAULT (0) NOT NULL, PAG_BAN VARCHAR(3), PAG_CHE VARCHAR(20), PAG_REF VARCHAR(50), PAG_CTA VARCHAR(3), PAG_CIU VARCHAR(8), PAG_DCT MONEY DEFAULT (0), PAG_DOC VARCHAR(20), PAG_NIT VARCHAR(11), PAG_USU VARCHAR(10) CONSTRAINT PK_PAGOS PRIMARY KEY CLUSTERED (PAG_NUM,PAG_TIP,PAG_CIA,PAG_ITM), CONSTRAINT CK__PAGOS__PAG_CIA__11BF94B6 CHECK ((len([PAG_CIA]) > 0)), CONSTRAINT CK__PAGOS__PAG_FOR__149C0161 CHECK ((len([PAG_FOR]) > 0)), CONSTRAINT CK__PAGOS__PAG_TIP__0FD74C44 CHECK ((len([PAG_TIP]) > 0))) CREATE TABLE PAGOSCAJA ( CAJ_TIP VARCHAR(3) NOT NULL, CAJ_NUM INT DEFAULT (0) NOT NULL, CAJ_CIA CHAR(2) DEFAULT ('01') NOT NULL, CAJ_FOR VARCHAR(3) NOT NULL, CAJ_FEC SMALLDATETIME NOT NULL, CAJ_VAL MONEY DEFAULT (0), CAJ_CAJ BIT DEFAULT (0) NOT NULL, CAJ_USU VARCHAR(10) CONSTRAINT PK_PAGOSCAJA PRIMARY KEY CLUSTERED (CAJ_TIP,CAJ_NUM,CAJ_CIA,CAJ_FOR), CONSTRAINT CK__PAGOSCAJA__CAJ_C__1C3D2329 CHECK ((len([CAJ_CIA]) > 0)), CONSTRAINT CK__PAGOSCAJA__CAJ_F__1D314762 CHECK ((len([CAJ_FOR]) > 0)), CONSTRAINT CK__PAGOSCAJA__CAJ_T__1960B67E CHECK ((len([CAJ_TIP]) > 0))) CREATE TABLE PEDCOM ( COM_TIP VARCHAR(3) NOT NULL, COM_NUM INT DEFAULT (0) NOT NULL, COM_CIA CHAR(2) DEFAULT ('01') NOT NULL, COM_COM SMALLINT DEFAULT (0) NOT NULL, COM_COD VARCHAR(16) NOT NULL, COM_CAN DECIMAL(14,4) DEFAULT (0) CONSTRAINT PK_PEDCOM PRIMARY KEY CLUSTERED (COM_TIP,COM_NUM,COM_CIA,COM_COM), CONSTRAINT CK__PEDCOM__COM_CIA__24D2692A CHECK ((len([COM_CIA]) > 0)), CONSTRAINT CK__PEDCOM__COM_COD__26BAB19C CHECK ((len([COM_COD]) > 0)), CONSTRAINT CK__PEDCOM__COM_TIP__21F5FC7F CHECK ((len([COM_TIP]) > 0))) CREATE TABLE PEDIDOS ( PED_NUM INT DEFAULT (0) NOT NULL, PED_TIP VARCHAR(3) NOT NULL, PED_CIA CHAR(2) DEFAULT ('01') NOT NULL, PED_FEC SMALLDATETIME NOT NULL, PED_CON VARCHAR(3), PED_CLI VARCHAR(11), PED_AGE VARCHAR(9) DEFAULT ('N'), PED_FDE SMALLDATETIME, PED_VCE SMALLDATETIME, PED_HOR VARCHAR(15), PED_VAL MONEY DEFAULT (0), PED_IVA MONEY DEFAULT (0), PED_DCT MONEY DEFAULT (0), PED_FLE MONEY DEFAULT (0), PED_OTR MONEY DEFAULT (0), PED_PAG MONEY DEFAULT (0), PED_IMP MONEY DEFAULT (0), PED_NET MONEY DEFAULT (0) NOT NULL, PED_VEN VARCHAR(11), PED_CDT VARCHAR(11), PED_SOL VARCHAR(150), PED_DIR VARCHAR(250), PED_CIU VARCHAR(8), PED_LUG VARCHAR(250), PED_FOR VARCHAR(3), PED_PES VARCHAR(20), PED_VOL VARCHAR(15), PED_TRA VARCHAR(11), PED_EMP VARCHAR(250), PED_PLA VARCHAR(10), PED_APL BIT DEFAULT (0) NOT NULL, PED_DOC INT DEFAULT (0), PED_CDC CHAR(2), PED_REM INT DEFAULT (0), PED_CRM CHAR(2), PED_APR INT DEFAULT ((-1)), PED_CPR CHAR(2) DEFAULT ('01'), PED_MAY BIT DEFAULT (0) NOT NULL, PED_SOB BIT DEFAULT (0) NOT NULL, PED_CAR INT DEFAULT (0), PED_ORI VARCHAR(8) CONSTRAINT PK_PEDIDOS PRIMARY KEY CLUSTERED (PED_NUM,PED_TIP,PED_CIA), CONSTRAINT CK__PEDIDOS__PED_CIA__2D67AF2B CHECK ((len([PED_CIA]) > 0)), CONSTRAINT CK__PEDIDOS__PED_TIP__2B7F66B9 CHECK ((len([PED_TIP]) > 0))) CREATE TABLE PEDTANQUES ( PTA_TIP VARCHAR(3) NOT NULL, PTA_NUM INT DEFAULT (0) NOT NULL, PTA_CIA CHAR(2) DEFAULT ('01') NOT NULL, PTA_ITM INT DEFAULT (0) NOT NULL, PTA_COD VARCHAR(16) NOT NULL, PTA_PRO VARCHAR(16) NOT NULL, PTA_TAN VARCHAR(3) NOT NULL, PTA_CAN DECIMAL(10,4) DEFAULT (0) NOT NULL, PTA_LIN INT DEFAULT (0) NOT NULL CONSTRAINT PK_PEDTANQUES PRIMARY KEY CLUSTERED (PTA_TIP,PTA_NUM,PTA_CIA,PTA_ITM), CONSTRAINT CK_PEDTANQUESPTA_CIA CHECK ((len([PTA_CIA]) > 0)), CONSTRAINT CK_PEDTANQUESPTA_COD CHECK ((len([PTA_COD]) > 0)), CONSTRAINT CK_PEDTANQUESPTA_PRO CHECK ((len([PTA_PRO]) > 0)), CONSTRAINT CK_PEDTANQUESPTA_TAN CHECK ((len([PTA_TAN]) > 0)), CONSTRAINT CK_PEDTANQUESPTA_TIP CHECK ((len([PTA_TIP]) > 0))) CREATE TABLE PEDTRANS ( PED_NUM INT DEFAULT (0) NOT NULL, PED_TIP VARCHAR(3) DEFAULT ('PDT') NOT NULL, PED_CIA CHAR(2) DEFAULT ('01') NOT NULL, PED_FEC SMALLDATETIME, PED_FDE SMALLDATETIME, PED_FVC SMALLDATETIME, PED_REM VARCHAR(11) NOT NULL, PED_DOR VARCHAR(250), PED_COR VARCHAR(8) NOT NULL, PED_DES VARCHAR(11), PED_DDE VARCHAR(250), PED_CDE VARCHAR(8) NOT NULL, PED_VAL MONEY DEFAULT (0), PED_COS MONEY DEFAULT (0), PED_PAG MONEY DEFAULT (0), PED_REF VARCHAR(20), PED_CON VARCHAR(50), PED_SIA VARCHAR(50), PED_SEG VARCHAR(50), PED_RES VARCHAR(50), PED_DOC INT DEFAULT (0), PED_CDC CHAR(2), PED_ODC INT DEFAULT (0), PED_COC CHAR(2), PED_CAR INT DEFAULT (0), PED_NVH INT DEFAULT (0), PED_NAT VARCHAR(3), PED_TVH VARCHAR(3), PED_VEN VARCHAR(11), PED_CMS DECIMAL(14,4) DEFAULT (0), PED_CPC VARCHAR(3), PED_TEL VARCHAR(30), PED_NOM VARCHAR(150), PED_INV INT DEFAULT (0), PED_CIV CHAR(2), PED_VIG VARCHAR(10), PED_APR BIT DEFAULT (0), PED_DAP VARCHAR(250), PED_UAP VARCHAR(10), PED_FAP SMALLDATETIME, PED_RUT VARCHAR(3) CONSTRAINT PK_PEDTRANS PRIMARY KEY CLUSTERED (PED_NUM,PED_TIP,PED_CIA), CONSTRAINT CK__PEDTRANS__PED_CD__4727812E CHECK ((len([PED_CDE]) > 0)), CONSTRAINT CK__PEDTRANS__PED_CI__444B1483 CHECK ((len([PED_CIA]) > 0)), CONSTRAINT CK__PEDTRANS__PED_CO__46335CF5 CHECK ((len([PED_COR]) > 0)), CONSTRAINT CK__PEDTRANS__PED_RE__453F38BC CHECK ((len([PED_REM]) > 0)), CONSTRAINT CK__PEDTRANS__PED_TI__4262CC11 CHECK ((len([PED_TIP]) > 0))) CREATE TABLE PLACONTADO ( CON_TIP VARCHAR(3) NOT NULL, CON_NUM INT DEFAULT (0) NOT NULL, CON_CIA CHAR(2) DEFAULT ('01') NOT NULL, CON_FEC SMALLDATETIME, CON_VCB MONEY DEFAULT (0) NOT NULL, CON_VCI MONEY DEFAULT (0) NOT NULL, CON_VCD MONEY DEFAULT (0) NOT NULL, CON_VCC MONEY DEFAULT (0) NOT NULL, CON_VVB MONEY DEFAULT (0) NOT NULL, CON_VVI MONEY DEFAULT (0) NOT NULL, CON_VVD MONEY DEFAULT (0) NOT NULL, CON_VVC MONEY DEFAULT (0) NOT NULL CONSTRAINT PK_PLACONTADO PRIMARY KEY CLUSTERED (CON_TIP,CON_NUM,CON_CIA), CONSTRAINT CK_PLACONTADOCON_CIA CHECK ((len([CON_CIA]) > 0)), CONSTRAINT CK_PLACONTADOCON_TIP CHECK ((len([CON_TIP]) > 0))) CREATE TABLE PLAMODFLETE ( PLA_TIP VARCHAR(3) DEFAULT ('PLT') NOT NULL, PLA_NUM INT DEFAULT ((0)) NOT NULL, PLA_CIA CHAR(2) NOT NULL, PLA_ITM INT DEFAULT ((0)) NOT NULL, PLA_FEC SMALLDATETIME NOT NULL, PLA_VAL MONEY DEFAULT ((0)) NOT NULL, PLA_RET MONEY DEFAULT ((0)) NOT NULL, PLA_ICA MONEY DEFAULT ((0)) NOT NULL, PLA_ANT MONEY DEFAULT ((0)) NOT NULL, PLA_PES DECIMAL(14,4) DEFAULT ((0)) NOT NULL, PLA_CUM INT DEFAULT ((0)) NOT NULL, PLA_RUT VARCHAR(3), PLA_ORI VARCHAR(8), PLA_DES VARCHAR(8), PLA_LUG VARCHAR(8), PLA_FPA SMALLDATETIME, PLA_HOR SMALLDATETIME NOT NULL, PLA_USU VARCHAR(10) CONSTRAINT PK_PLAMODFLETE PRIMARY KEY CLUSTERED (PLA_TIP,PLA_NUM,PLA_CIA,PLA_ITM), CONSTRAINT CK_PLAMODFLETEPLA_CIA CHECK ((len([PLA_CIA])>(0))), CONSTRAINT CK_PLAMODFLETEPLA_TIP CHECK ((len([PLA_TIP])>(0)))) CREATE TABLE PLANILLAS ( PLA_NUM INT DEFAULT (0) NOT NULL, PLA_TIP VARCHAR(3) NOT NULL, PLA_CIA CHAR(2) DEFAULT ('01') NOT NULL, PLA_FEC SMALLDATETIME NOT NULL, PLA_TUR VARCHAR(3), PLA_CLI VARCHAR(11), PLA_VAL MONEY DEFAULT (0), PLA_IVA MONEY DEFAULT (0), PLA_COS MONEY DEFAULT (0), PLA_OTR MONEY DEFAULT (0), PLA_CRE MONEY DEFAULT (0), PLA_NET MONEY DEFAULT (0) NOT NULL, PLA_VEN VARCHAR(11), PLA_CMS DECIMAL(10,4) DEFAULT (0), PLA_CPC VARCHAR(3), PLA_NIT VARCHAR(11), PLA_SOL MONEY DEFAULT (0), PLA_MOD INT DEFAULT (0) NOT NULL, PLA_COR INT DEFAULT (0) NOT NULL, PLA_FCO SMALLDATETIME, PLA_VCB MONEY DEFAULT (0) NOT NULL, PLA_VCI MONEY DEFAULT (0) NOT NULL, PLA_VCD MONEY DEFAULT (0) NOT NULL, PLA_VCC MONEY DEFAULT (0) NOT NULL, PLA_VVB MONEY DEFAULT (0) NOT NULL, PLA_VVI MONEY DEFAULT (0) NOT NULL, PLA_VVD MONEY DEFAULT (0) NOT NULL, PLA_VVC MONEY DEFAULT (0) NOT NULL, PLA_GLO MONEY DEFAULT (0) CONSTRAINT PK_PLANILLAS PRIMARY KEY CLUSTERED (PLA_NUM,PLA_TIP,PLA_CIA), CONSTRAINT CK__PLANILLAS__PLA_C__538D5813 CHECK ((len([PLA_CIA]) > 0)), CONSTRAINT CK__PLANILLAS__PLA_T__51A50FA1 CHECK ((len([PLA_TIP]) > 0))) CREATE TABLE PLATIEMPOS ( HOR_TIP VARCHAR(3) NOT NULL, HOR_NUM INT DEFAULT ((0)) NOT NULL, HOR_CIA CHAR(2) NOT NULL, HOR_ITM INT DEFAULT ((0)) NOT NULL, HOR_TDC VARCHAR(3) NOT NULL, HOR_DOC INT DEFAULT ((0)) NOT NULL, HOR_CDC CHAR(2) NOT NULL, HOR_TEC DECIMAL(14,4) DEFAULT ((0)) NOT NULL, HOR_TED DECIMAL(14,4) DEFAULT ((0)) NOT NULL, HOR_FIC SMALLDATETIME, HOR_FFC SMALLDATETIME, HOR_FID SMALLDATETIME, HOR_FFD SMALLDATETIME, HOR_TRC DECIMAL(14,4) DEFAULT ((0)), HOR_TRD DECIMAL(14,4) DEFAULT ((0)), HOR_FLC SMALLDATETIME, HOR_FSC SMALLDATETIME, HOR_FLD SMALLDATETIME, HOR_FSD SMALLDATETIME CONSTRAINT PK_PLATIEMPOS PRIMARY KEY CLUSTERED (HOR_TIP,HOR_NUM,HOR_CIA,HOR_ITM), CONSTRAINT CK_PLATIEMPOSHOR_CDC CHECK ((len([HOR_CDC])>(0))), CONSTRAINT CK_PLATIEMPOSHOR_CIA CHECK ((len([HOR_CIA])>(0))), CONSTRAINT CK_PLATIEMPOSHOR_TDC CHECK ((len([HOR_TDC])>(0))), CONSTRAINT CK_PLATIEMPOSHOR_TIP CHECK ((len([HOR_TIP])>(0)))) CREATE TABLE PLATRANS ( PLA_NUM INT DEFAULT (0) NOT NULL, PLA_TIP VARCHAR(3) DEFAULT ('PLT') NOT NULL, PLA_CIA CHAR(2) DEFAULT ('01') NOT NULL, PLA_FEC SMALLDATETIME, PLA_RUT VARCHAR(3), PLA_ORI VARCHAR(8) NOT NULL, PLA_DES VARCHAR(8) NOT NULL, PLA_VEH VARCHAR(10) NOT NULL, PLA_CON VARCHAR(11), PLA_NIT VARCHAR(11) NOT NULL, PLA_PAG VARCHAR(8), PLA_FPA SMALLDATETIME, PLA_CAR VARCHAR(20), PLA_DCG VARCHAR(20), PLA_VAL MONEY DEFAULT (0), PLA_ANT MONEY DEFAULT (0), PLA_DCT MONEY DEFAULT (0), PLA_RET MONEY DEFAULT (0), PLA_ICA MONEY DEFAULT (0), PLA_OTR MONEY DEFAULT (0), PLA_COS MONEY DEFAULT (0), PLA_NET MONEY DEFAULT (0) NOT NULL, PLA_ODP INT DEFAULT ((-1)), PLA_COP CHAR(2), PLA_LEG INT DEFAULT ((-1)), PLA_CLE CHAR(2), PLA_REM INT DEFAULT (0), PLA_CRM CHAR(2) DEFAULT ('01'), PLA_FMP BIT DEFAULT (0) NOT NULL, PLA_TRA VARCHAR(10), PLA_POL VARCHAR(30), PLA_FHD SMALLDATETIME, PLA_FEN SMALLDATETIME, PLA_KMT INT DEFAULT (0), PLA_RLF VARCHAR(3), PLA_VFR MONEY DEFAULT (0), PLA_NMT VARCHAR(20) DEFAULT ('0'), PLA_MOD VARCHAR(30) DEFAULT ('GENERAL_INTERURBANO'), PLA_CTO VARCHAR(8), PLA_CTD VARCHAR(8), PLA_KTO INT DEFAULT (0), PLA_KTD INT DEFAULT (0), PLA_CSP INT DEFAULT (0), PLA_MVA VARCHAR(3), PLA_TRU CHAR(1), PLA_VFT MONEY DEFAULT ((0)), PLA_NRA DECIMAL(16,4) DEFAULT ((0)), PLA_VHC MONEY DEFAULT ((0)), PLA_VHD MONEY DEFAULT ((0)), PLA_VAD MONEY DEFAULT ((0)), PLA_MVL VARCHAR(3), PLA_VDC MONEY DEFAULT ((0)), PLA_MVD VARCHAR(3), PLA_FED SMALLDATETIME, PLA_NIV INT DEFAULT ((0)), PLA_CIV CHAR(2), PLA_INT INT DEFAULT ((0)), PLA_ERR VARCHAR(1000) DEFAULT (''), PLA_WSP BIT DEFAULT ((0)) CONSTRAINT PK_PLATRANS PRIMARY KEY CLUSTERED (PLA_NUM,PLA_TIP,PLA_CIA), CONSTRAINT CK__PLATRANS__PLA_CI__61DB776A CHECK ((len([PLA_CIA]) > 0)), CONSTRAINT CK__PLATRANS__PLA_DE__63C3BFDC CHECK ((len([PLA_DES]) > 0)), CONSTRAINT CK__PLATRANS__PLA_NI__65AC084E CHECK ((len([PLA_NIT]) > 0)), CONSTRAINT CK__PLATRANS__PLA_OR__62CF9BA3 CHECK ((len([PLA_ORI]) > 0)), CONSTRAINT CK__PLATRANS__PLA_TI__5FF32EF8 CHECK ((len([PLA_TIP]) > 0)), CONSTRAINT CK__PLATRANS__PLA_VE__64B7E415 CHECK ((len([PLA_VEH]) > 0))) CREATE TABLE PLATURNOS ( TUR_NUM INT DEFAULT (0) NOT NULL, TUR_CIA CHAR(2) DEFAULT ('01') NOT NULL, TUR_FEC SMALLDATETIME NOT NULL, TUR_PLA INT DEFAULT (0) NOT NULL, TUR_FL1 VARCHAR(50), TUR_FL2 VARCHAR(50), TUR_USU VARCHAR(10) NOT NULL, TUR_TIM SMALLDATETIME NOT NULL, TUR_COR INT DEFAULT ((0)), TUR_FCO SMALLDATETIME CONSTRAINT PK_PLATURNOS PRIMARY KEY CLUSTERED (TUR_NUM,TUR_CIA), CONSTRAINT CK_PLATURNOSTUR_CIA CHECK ((len([TUR_CIA]) > 0)), CONSTRAINT CK_PLATURNOSTUR_USU CHECK ((len([TUR_USU]) > 0))) CREATE TABLE RECIBOS ( REC_NUM INT DEFAULT (0) NOT NULL, REC_TIP VARCHAR(3) DEFAULT ('REC') NOT NULL, REC_CIA CHAR(2) DEFAULT ('01') NOT NULL, REC_FEC SMALLDATETIME NOT NULL, REC_CON VARCHAR(3) DEFAULT ('REC') NOT NULL, REC_CLI VARCHAR(11) NOT NULL, REC_AGE VARCHAR(9) DEFAULT ('N'), REC_VAL MONEY DEFAULT (0), REC_RET MONEY DEFAULT (0), REC_IVA MONEY DEFAULT (0), REC_ICA MONEY DEFAULT (0), REC_MAS MONEY DEFAULT (0), REC_DCT MONEY DEFAULT (0), REC_OTR MONEY DEFAULT (0), REC_NET MONEY DEFAULT (0) NOT NULL, REC_VEN VARCHAR(11), REC_CMS DECIMAL(10,4) DEFAULT (0), REC_CPC VARCHAR(3), REC_CTA VARCHAR(3), REC_RTC MONEY DEFAULT ((0)), REC_TRC DECIMAL(14,4) DEFAULT ((0)), REC_CRC VARCHAR(3) CONSTRAINT PK_RECIBOS PRIMARY KEY CLUSTERED (REC_NUM,REC_TIP,REC_CIA), CONSTRAINT CK__RECIBOS__REC_CIA__78BEDCC2 CHECK ((len([REC_CIA]) > 0)), CONSTRAINT CK__RECIBOS__REC_CLI__7B9B496D CHECK ((len([REC_CLI]) > 0)), CONSTRAINT CK__RECIBOS__REC_CON__7AA72534 CHECK ((len([REC_CON]) > 0)), CONSTRAINT CK__RECIBOS__REC_TIP__76D69450 CHECK ((len([REC_TIP]) > 0))) CREATE TABLE RECPROVISIONAL ( RCP_NUM INT DEFAULT (0) NOT NULL, RCP_CIA CHAR(2) DEFAULT ('01') NOT NULL, RCP_TIP VARCHAR(3) DEFAULT ('CHE') NOT NULL, RCP_FEC SMALLDATETIME NOT NULL, RCP_CLI VARCHAR(11) NOT NULL, RCP_AGE VARCHAR(9) DEFAULT ('N'), RCP_VAL MONEY DEFAULT (0) CONSTRAINT PK_RECPROVISIONAL PRIMARY KEY CLUSTERED (RCP_NUM,RCP_CIA), CONSTRAINT CK__RECPROVIS__RCP_C__09E968C4 CHECK ((len([RCP_CIA]) > 0)), CONSTRAINT CK__RECPROVIS__RCP_C__0CC5D56F CHECK ((len([RCP_CLI]) > 0)), CONSTRAINT CK__RECPROVIS__RCP_T__0BD1B136 CHECK ((len([RCP_TIP]) > 0))) CREATE TABLE REMCON ( RCO_TIP VARCHAR(3) DEFAULT ('RMT') NOT NULL, RCO_NUM INT DEFAULT (0) NOT NULL, RCO_CIA CHAR(2) DEFAULT ('01') NOT NULL, RCO_NC1 VARCHAR(20) NOT NULL, RCO_NC2 VARCHAR(20), RCO_TA1 VARCHAR(10), RCO_TA2 VARCHAR(10), RCO_PA1 VARCHAR(15), RCO_PA2 VARCHAR(15), RCO_CO1 VARCHAR(20), RCO_CO2 VARCHAR(20), RCO_SE1 VARCHAR(250), RCO_SE2 VARCHAR(250), RCO_EN1 VARCHAR(20), RCO_EN2 VARCHAR(20), RCO_CAR VARCHAR(6) CONSTRAINT PK_REMCON PRIMARY KEY CLUSTERED (RCO_TIP,RCO_NUM,RCO_CIA), CONSTRAINT CK__REMCON__RCO_CIA__155B1B70 CHECK ((len([RCO_CIA]) > 0)), CONSTRAINT CK__REMCON__RCO_NC1__164F3FA9 CHECK ((len([RCO_NC1]) > 0)), CONSTRAINT CK__REMCON__RCO_TIP__127EAEC5 CHECK ((len([RCO_TIP]) > 0))) CREATE TABLE REMESAS ( REM_NUM INT DEFAULT (0) NOT NULL, REM_TIP VARCHAR(3) DEFAULT ('RMT') NOT NULL, REM_CIA CHAR(2) DEFAULT ('01') NOT NULL, REM_FEC SMALLDATETIME, REM_VEH VARCHAR(10) NOT NULL, REM_CON VARCHAR(11), REM_REM VARCHAR(11) NOT NULL, REM_DRM VARCHAR(250), REM_CRM VARCHAR(8), REM_DES VARCHAR(11) NOT NULL, REM_DDE VARCHAR(250), REM_CDE VARCHAR(8), REM_LUG VARCHAR(8), REM_ORD INT DEFAULT (0), REM_COR CHAR(2), REM_PLA INT DEFAULT (0), REM_CPL CHAR(2), REM_FAC INT DEFAULT ((-1)), REM_CFA CHAR(2), REM_PED INT DEFAULT (0), REM_CPE CHAR(2), REM_SAL INT DEFAULT (0), REM_CSA CHAR(2), REM_VAL MONEY DEFAULT (0), REM_COS MONEY DEFAULT (0), REM_TRA VARCHAR(10), REM_FPA SMALLDATETIME, REM_DEC MONEY DEFAULT (0), REM_SEG MONEY DEFAULT (0), REM_VEN VARCHAR(11), REM_CMS DECIMAL(14,4) DEFAULT (0), REM_CPC VARCHAR(3), REM_TEL VARCHAR(30), REM_NOM VARCHAR(150), REM_TOM CHAR(1), REM_POL VARCHAR(30), REM_ASE VARCHAR(11), REM_FVP SMALLDATETIME, REM_MOD VARCHAR(30) DEFAULT ('GENERAL_INTERURBANO'), REM_MUD INT DEFAULT (0), REM_CMU CHAR(2), REM_NPM VARCHAR(11), REM_APR BIT DEFAULT ((0)), REM_DAP VARCHAR(250), REM_UAP VARCHAR(10), REM_FAP SMALLDATETIME, REM_TRU CHAR(1), REM_PAC BIT DEFAULT ((0)), REM_HPC INT DEFAULT ((0)), REM_MPC INT DEFAULT ((0)), REM_PAD BIT DEFAULT ((0)), REM_HPD INT DEFAULT ((0)), REM_MPD INT DEFAULT ((0)), REM_FCC SMALLDATETIME, REM_FLC SMALLDATETIME, REM_FIC SMALLDATETIME, REM_FFC SMALLDATETIME, REM_FCD SMALLDATETIME, REM_FLD SMALLDATETIME, REM_FID SMALLDATETIME, REM_FFD SMALLDATETIME, REM_RCC SMALLDATETIME, REM_RLC SMALLDATETIME, REM_RIC SMALLDATETIME, REM_RFC SMALLDATETIME, REM_RCD SMALLDATETIME, REM_RLD SMALLDATETIME, REM_RID SMALLDATETIME, REM_RFD SMALLDATETIME, REM_VIG VARCHAR(10) DEFAULT ('GENERAL'), REM_RUT VARCHAR(3) CONSTRAINT PK_REMESAS PRIMARY KEY CLUSTERED (REM_NUM,REM_TIP,REM_CIA), CONSTRAINT CK__REMESAS__REM_CIA__1CFC3D38 CHECK ((len([REM_CIA]) > 0)), CONSTRAINT CK__REMESAS__REM_DES__1FD8A9E3 CHECK ((len([REM_DES]) > 0)), CONSTRAINT CK__REMESAS__REM_REM__1EE485AA CHECK ((len([REM_REM]) > 0)), CONSTRAINT CK__REMESAS__REM_TIP__1B13F4C6 CHECK ((len([REM_TIP]) > 0)), CONSTRAINT CK__REMESAS__REM_VEH__1DF06171 CHECK ((len([REM_VEH]) > 0))) CREATE TABLE REPORTES ( REP_TIP VARCHAR(3) DEFAULT ('PLT') NOT NULL, REP_NUM INT DEFAULT (0) NOT NULL, REP_CIA CHAR(2) DEFAULT ('01') NOT NULL, REP_PUE VARCHAR(3) NOT NULL, REP_ORD SMALLINT DEFAULT (0), REP_FEC SMALLDATETIME NOT NULL, REP_FPR SMALLDATETIME, REP_HPR SMALLDATETIME, REP_FRE SMALLDATETIME, REP_HRE SMALLDATETIME, REP_REP BIT DEFAULT (0) NOT NULL, REP_OBS VARCHAR(250), REP_USU VARCHAR(10) CONSTRAINT PK_REPORTES PRIMARY KEY CLUSTERED (REP_TIP,REP_NUM,REP_CIA,REP_PUE), CONSTRAINT CK__REPORTES__REP_CI__2F1AED73 CHECK ((len([REP_CIA]) > 0)), CONSTRAINT CK__REPORTES__REP_PU__300F11AC CHECK ((len([REP_PUE]) > 0)), CONSTRAINT CK__REPORTES__REP_TI__2C3E80C8 CHECK ((len([REP_TIP]) > 0))) CREATE TABLE SALIDAS ( SAL_NUM INT DEFAULT (0) NOT NULL, SAL_TIP VARCHAR(3) NOT NULL, SAL_CIA CHAR(2) DEFAULT ('01') NOT NULL, SAL_FEC SMALLDATETIME NOT NULL, SAL_CON VARCHAR(3) NOT NULL, SAL_NIT VARCHAR(11), SAL_ORD INT DEFAULT (0), SAL_VAL MONEY DEFAULT (0) NOT NULL, SAL_IVA MONEY DEFAULT (0), SAL_ORI VARCHAR(3), SAL_DES VARCHAR(3), SAL_REM INT DEFAULT (0), SAL_CRM CHAR(2), SAL_CC VARCHAR(3), SAL_MUD INT DEFAULT (0), SAL_CMU CHAR(2) CONSTRAINT PK_SALIDAS PRIMARY KEY CLUSTERED (SAL_NUM,SAL_TIP,SAL_CIA), CONSTRAINT CK__SALIDAS__SAL_CIA__37B03374 CHECK ((len([SAL_CIA]) > 0)), CONSTRAINT CK__SALIDAS__SAL_CON__38A457AD CHECK ((len([SAL_CON]) > 0)), CONSTRAINT CK__SALIDAS__SAL_TIP__35C7EB02 CHECK ((len([SAL_TIP]) > 0))) CREATE TABLE SSERVICIO ( PED_TIP VARCHAR(3) DEFAULT ('PDT') NOT NULL, PED_NUM INT DEFAULT (0) NOT NULL, PED_CIA CHAR(2) DEFAULT ('01') NOT NULL, PED_FEC SMALLDATETIME NOT NULL, PED_FCA SMALLDATETIME NOT NULL, PED_FEN SMALLDATETIME NOT NULL, PED_ORI VARCHAR(8) NOT NULL, PED_DES VARCHAR(8) NOT NULL, PED_CLI VARCHAR(11) NOT NULL, PED_CGO VARCHAR(30) NOT NULL, PED_REP VARCHAR(150) NOT NULL, PED_EML VARCHAR(100), PED_CLF VARCHAR(11) NOT NULL, PED_REM VARCHAR(11) NOT NULL, PED_DRC VARCHAR(250) NOT NULL, PED_RQC VARCHAR(250), PED_DTN VARCHAR(11) NOT NULL, PED_DRD VARCHAR(250) NOT NULL, PED_RQD VARCHAR(250), PED_MOD VARCHAR(20) NOT NULL, PED_CAR VARCHAR(13) NOT NULL, PED_MER VARCHAR(150) NOT NULL, PED_DEC MONEY DEFAULT (0) NOT NULL, PED_ASE VARCHAR(150), PED_PLE BIT DEFAULT (0) NOT NULL, PED_PEX BIT DEFAULT (0) NOT NULL, PED_VPE MONEY DEFAULT (0) NOT NULL, PED_VPX MONEY DEFAULT (0) NOT NULL, PED_ESC BIT DEFAULT (0) NOT NULL, PED_CDC VARCHAR(8), PED_PAT VARCHAR(50), PED_SEG VARCHAR(10) NOT NULL, PED_TVH VARCHAR(3) NOT NULL, PED_CIC BIT DEFAULT (0) NOT NULL, PED_CID BIT DEFAULT (0) NOT NULL, PED_COS MONEY DEFAULT (0) NOT NULL, PED_OTR MONEY DEFAULT (0) NOT NULL, PED_VAL MONEY DEFAULT (0) NOT NULL, PED_CES MONEY DEFAULT (0) NOT NULL, PED_VEN VARCHAR(11) NOT NULL, PED_EST VARCHAR(10) CONSTRAINT PK_SSERVICIO PRIMARY KEY CLUSTERED (PED_TIP,PED_NUM,PED_CIA), CONSTRAINT CK_SSERVICIOPED_CAR CHECK ((len([PED_CAR]) > 0)), CONSTRAINT CK_SSERVICIOPED_CGO CHECK ((len([PED_CGO]) > 0)), CONSTRAINT CK_SSERVICIOPED_CIA CHECK ((len([PED_CIA]) > 0)), CONSTRAINT CK_SSERVICIOPED_CLF CHECK ((len([PED_CLF]) > 0)), CONSTRAINT CK_SSERVICIOPED_CLI CHECK ((len([PED_CLI]) > 0)), CONSTRAINT CK_SSERVICIOPED_DES CHECK ((len([PED_DES]) > 0)), CONSTRAINT CK_SSERVICIOPED_DRC CHECK ((len([PED_DRC]) > 0)), CONSTRAINT CK_SSERVICIOPED_DRD CHECK ((len([PED_DRD]) > 0)), CONSTRAINT CK_SSERVICIOPED_DTN CHECK ((len([PED_DTN]) > 0)), CONSTRAINT CK_SSERVICIOPED_MER CHECK ((len([PED_MER]) > 0)), CONSTRAINT CK_SSERVICIOPED_MOD CHECK (([PED_MOD] = 'OTM' or ([PED_MOD] = 'DTA' or ([PED_MOD] = 'EXPORTACION' or [PED_MOD] = 'NACIONALIZADA')))), CONSTRAINT CK_SSERVICIOPED_ORI CHECK ((len([PED_ORI]) > 0)), CONSTRAINT CK_SSERVICIOPED_REM CHECK ((len([PED_REM]) > 0)), CONSTRAINT CK_SSERVICIOPED_REP CHECK ((len([PED_REP]) > 0)), CONSTRAINT CK_SSERVICIOPED_SEG CHECK (([PED_SEG] = 'EMPRESA' or [PED_SEG] = 'CLIENTE')), CONSTRAINT CK_SSERVICIOPED_TIP CHECK ((len([PED_TIP]) > 0)), CONSTRAINT CK_SSERVICIOPED_TVH CHECK ((len([PED_TVH]) > 0)), CONSTRAINT CK_SSERVICIOPED_VEN CHECK ((len([PED_VEN]) > 0))) CREATE TABLE SSESCOLTAS ( ESC_TIP VARCHAR(3) DEFAULT ('PDT') NOT NULL, ESC_NUM INT DEFAULT (0) NOT NULL, ESC_CIA CHAR(2) DEFAULT ('01') NOT NULL, ESC_ITM INT DEFAULT (0) NOT NULL, ESC_COD VARCHAR(3) NOT NULL, ESC_CAN INT DEFAULT (1) NOT NULL, ESC_COS MONEY DEFAULT (0) NOT NULL, ESC_OBS VARCHAR(100) CONSTRAINT PK_SSESCOLTAS PRIMARY KEY CLUSTERED (ESC_TIP,ESC_NUM,ESC_CIA,ESC_ITM), CONSTRAINT CK_SSESCOLTASESC_CIA CHECK ((len([ESC_CIA]) > 0)), CONSTRAINT CK_SSESCOLTASESC_COD CHECK ((len([ESC_COD]) > 0)), CONSTRAINT CK_SSESCOLTASESC_TIP CHECK ((len([ESC_TIP]) > 0))) CREATE TABLE SURUNIDO ( SUR_NUE VARCHAR(3) NOT NULL, SUR_TAN VARCHAR(3) NOT NULL, SUR_NUM VARCHAR(3) NOT NULL, SUR_FIN DECIMAL(17,4) DEFAULT (0) CONSTRAINT PK_SURUNIDO PRIMARY KEY CLUSTERED (SUR_NUE,SUR_TAN,SUR_NUM), CONSTRAINT CK__SURUNIDO__SUR_NU__3F51553C CHECK ((len([SUR_NUE]) > 0)), CONSTRAINT CK__SURUNIDO__SUR_NU__41399DAE CHECK ((len([SUR_NUM]) > 0)), CONSTRAINT CK__SURUNIDO__SUR_TA__40457975 CHECK ((len([SUR_TAN]) > 0))) CREATE TABLE UNIDOS ( UNI_NUE VARCHAR(3) NOT NULL, UNI_TAN VARCHAR(3) NOT NULL, UNI_FEC SMALLDATETIME, UNI_SAL DECIMAL(14,4) DEFAULT (0), UNI_CAP DECIMAL(14,4) DEFAULT (0), UNI_USU VARCHAR(10), UNI_CIA CHAR(2) DEFAULT ('01') CONSTRAINT PK_UNIDOS PRIMARY KEY CLUSTERED (UNI_NUE,UNI_TAN), CONSTRAINT CK__UNIDOS__UNI_NUE__450A2E92 CHECK ((len([UNI_NUE]) > 0)), CONSTRAINT CK__UNIDOS__UNI_TAN__45FE52CB CHECK ((len([UNI_TAN]) > 0))) CREATE TABLE VALES ( VAL_NUM INT DEFAULT (0) NOT NULL, VAL_TIP VARCHAR(3) DEFAULT ('VAL') NOT NULL, VAL_CIA CHAR(2) DEFAULT ('01') NOT NULL, VAL_FEC SMALLDATETIME NOT NULL, VAL_CON VARCHAR(3) NOT NULL, VAL_NIT VARCHAR(11), VAL_DEB MONEY DEFAULT (0), VAL_CRE MONEY DEFAULT (0) CONSTRAINT PK_VALES PRIMARY KEY CLUSTERED (VAL_NUM,VAL_TIP,VAL_CIA), CONSTRAINT CK__VALES__VAL_CIA__4F87BD05 CHECK ((len([VAL_CIA]) > 0)), CONSTRAINT CK__VALES__VAL_CON__507BE13E CHECK ((len([VAL_CON]) > 0)), CONSTRAINT CK__VALES__VAL_TIP__4D9F7493 CHECK ((len([VAL_TIP]) > 0))) GO CREATE NONCLUSTERED INDEX IX_DETMOVDET_FEC ON DETMOV(DET_FEC) CREATE NONCLUSTERED INDEX IX_DETMOVDET_ORD ON DETMOV(DET_TDC,DET_ORD,DET_COD) GO CREATE NONCLUSTERED INDEX IX_ENTRADASENT_NIT ON ENTRADAS(ENT_NIT) CREATE NONCLUSTERED INDEX IX_ENTRADASENT_FEC ON ENTRADAS(ENT_FEC) CREATE NONCLUSTERED INDEX IX_ENTRADASENT_CON ON ENTRADAS(ENT_CON) GO CREATE NONCLUSTERED INDEX IX_FACTURASFAC_CLI ON FACTURAS(FAC_CLI) CREATE NONCLUSTERED INDEX IX_FACTURASFAC_FEC ON FACTURAS(FAC_FEC) CREATE NONCLUSTERED INDEX IX_FACTURASFAC_CON ON FACTURAS(FAC_CON) CREATE NONCLUSTERED INDEX IX_FACTURASFAC_NUM ON FACTURAS(FAC_NUM) GO CREATE NONCLUSTERED INDEX IX_KARDEXKAR_COD ON KARDEX(KAR_COD) CREATE NONCLUSTERED INDEX IX_KARDEXKAR_FEC ON KARDEX(KAR_FEC) CREATE NONCLUSTERED INDEX IX_KARDEXKAR_SEC ON KARDEX(KAR_SEC) CREATE NONCLUSTERED INDEX IX_KARDEXKAR_CIA ON KARDEX(KAR_CIA) GO CREATE NONCLUSTERED INDEX IX_MUDANZASMUD_FEC ON MUDANZAS(MUD_FEC) CREATE NONCLUSTERED INDEX IX_MUDANZASMUD_CLI ON MUDANZAS(MUD_CLI) GO CREATE NONCLUSTERED INDEX IX_OPAGOODP_FEC ON OPAGO(ODP_FEC) CREATE NONCLUSTERED INDEX IX_OPAGOODP_PLA ON OPAGO(ODP_TPL,ODP_PLA,ODP_CPL) CREATE NONCLUSTERED INDEX IX_OPAGOODP_VEH ON OPAGO(ODP_VEH) CREATE NONCLUSTERED INDEX IX_OPAGOODP_NIT ON OPAGO(ODP_NIT) GO CREATE NONCLUSTERED INDEX IX_PLATURNOSTUR_PLA ON PLATURNOS(TUR_PLA) CREATE NONCLUSTERED INDEX IX_PLATURNOSTUR_FEC ON PLATURNOS(TUR_FEC) GO