IF OBJECT_ID('IMP_CLIENTE') IS NULL
BEGIN
CREATE TABLE IMP_CLIENTE
	(
	CD_CLI BIGINT PRIMARY KEY,
	RZ_CLI VARCHAR(150) NOT NULL,
	NM_FANT VARCHAR(150) NULL,
	CPF_CGC VARCHAR(20) NOT NULL,
	END_CLI VARCHAR(200) NOT NULL,
	BAIRRO VARCHAR(100) NOT NULL,
	CEP  VARCHAR(10) NULL,
	CIDADE VARCHAR(100) NOT NULL,
	UF VARCHAR(2) NOT NULL,
	DDD BIGINT NULL,
	TEL BIGINT NOT NULL,
	DT_NASC DATE NULL,
	MATRICULA  VARCHAR(10) NULL,
	NR_CARTAO  VARCHAR(10) NULL,
	INSC_EST VARCHAR(100) NOT NULL,
	INSC_MUNI  VARCHAR(100) NOT NULL,
	ESP_CLI  BIGINT NOT NULL DEFAULT 0,
	COD_PLU_CONV BIGINT NOT NULL DEFAULT 0,
	VLR_CRED MONEY NOT NULL,
	NUMERO  VARCHAR(10) NULL,
	VLR_PARC_CRED MONEY NOT NULL DEFAULT 0,
	TITULAR BIGINT NOT NULL,
	STS_CLI VARCHAR(10) NOT NULL,
	STS_CRED_CLI BIGINT NOT NULL DEFAULT 0,
	MDL_VENDA BIGINT NOT NULL DEFAULT 0,
	OBS1 VARCHAR(100) NULL,
	OBS2 VARCHAR(100) NULL,
	PROCESSADO INT NOT NULL DEFAULT 0
	)
END