Documentation

ConfigImport
in package

Application

Constants

TEMPLATE_EXCEL = ["empresasprodutores" => self::ENTIDADE_BASE, "fornecedores" => self::ENTIDADE_BASE, "clientes" => self::ENTIDADE_BASE, "terceiro" => self::ENTIDADE_BASE, "registro-de-cotacoes" => ["config" => ["name" => "Modelo_registro_cotacao.xls", "modelPk" => "CotacaoDia", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Id", "field" => "idCotacao", "comment" => "Id referente ao id da cotação", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Cotacao"], 1 => ["validation" => "", "title" => "Data", "field" => "dataCadastro", "comment" => "Data de cadastro", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Valor", "field" => "valor", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "bancos" => ["config" => ["name" => "Modelo_cadastro_banco.xls", "modelPk" => "Banco", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Código Banco", "field" => "CodBanco", "comment" => "Código Banco", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Nome do Banco", "field" => "NomeBanco", "comment" => "Nome Banco", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Site do Banco", "field" => "HomePageBanco", "comment" => "Site do Banco", "type" => "url", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Internet Banking ofx", "field" => "statusBanking", "comment" => "Status do Internet Banking (Ativo ou Inativo)", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "ATIVO, INATIVO"], "entity" => ""]]], "funcionarios_ultimo_salario" => ["config" => ["name" => "Modelo_ultimo_salario.xls", "modelPk" => "PessoaFuncionario", "modelFk" => [], "columRequired" => 0, "update" => true], "fields" => [0 => ["validation" => "", "title" => "CPF", "field" => "cpfCnpjEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Salário Registrado", "field" => "salarioRegistrado", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Último Salário Pago", "field" => "salarioRegistradoUltimoPago", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Custo Hora", "field" => "custoHora", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "funcionarios" => ["config" => ["name" => "Modelo_cadastro_funcionario.xls", "modelPk" => "Pessoa", "modelFk" => ["Endereco", "SegmentacaoEntidade", "PessoaBanco", "PessoaFuncionario"], "columRequired" => 1], "fields" => [0 => ["validation" => "", "title" => "Cliente", "field" => "ClienteEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 1 => ["validation" => "", "title" => "Fornecedor", "field" => "FornecedorEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 2 => ["validation" => "", "title" => "Transportadora", "field" => "TransportadoraEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 3 => ["validation" => "", "title" => "Funcionário", "field" => "FuncionarioEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 4 => ["validation" => "", "title" => "Produtor", "field" => "CriadorEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 5 => ["validation" => "", "title" => "Nome Completo / Fantasia", "field" => "NomeEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "self::validationCpfCnpjVerdadeiroOuFalso", "title" => "CPF ou CNPJ", "field" => "cpfCnpjEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Departamento", "field" => "idDepartamento", "comment" => "Id referente ao id do Departamento", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "Departamentos"], 8 => ["validation" => "self::validationCnpCnpj", "title" => "Tipo Pessoa", "field" => "PessoaFisiccaJuridicaEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "FISICA, JURIDICA"], "entity" => ""], 9 => ["validation" => "", "title" => "Razão Social", "field" => "razaoSocial", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "Email de Contato", "field" => "EmailEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Telefone", "field" => "TelefoneEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 12 => ["validation" => "", "title" => "Celular", "field" => "CelularEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 13 => ["validation" => "", "title" => "ID Segmentação", "field" => "idSegmentoEntidade", "comment" => "Id referente ao id da Segmento da Entidade", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Segmentacao"], 14 => ["validation" => "", "title" => "Data Admissão", "field" => "dataAdmissao", "comment" => "", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 15 => ["validation" => "", "title" => "Data Demissão", "field" => "dataDemissao", "comment" => "", "type" => "date", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 16 => ["validation" => "", "title" => "Salário Registrado", "field" => "salarioRegistrado", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 17 => ["validation" => "", "title" => "Salário Líquido", "field" => "salarioLiquido", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 18 => ["validation" => "", "title" => "Último Salário Pago", "field" => "salarioRegistradoUltimoPago", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 19 => ["validation" => "", "title" => "Custo Hora", "field" => "custoHora", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 20 => ["validation" => "", "title" => "Centro Custo INTSYS", "field" => "centroCustoINTSYS", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 21 => ["validation" => "", "title" => "Observações", "field" => "OBSEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => "Pessoa"], 22 => ["validation" => "", "title" => "CEP", "field" => "CEP", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 23 => ["validation" => "", "title" => "Endereço", "field" => "Endereco", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 24 => ["validation" => "", "title" => "Número", "field" => "Numero", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 25 => ["validation" => "", "title" => "Complemento", "field" => "Complemento", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 26 => ["validation" => "", "title" => "Bairro", "field" => "Bairro", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 27 => ["validation" => "", "title" => "Cidade", "field" => "Cidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 28 => ["validation" => "", "title" => "Estado", "field" => "UF", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "AC,AL,AP,AM,BA,CE,DF,ES,GO,MA,MT,MS,MG,PA,PB,PR,PE,PI,RJ,RN,RS,RO,RR,SC,SP,SE,TO"], "entity" => ""], 29 => ["validation" => "", "title" => "Tipo Conta", "field" => "tipoConta", "comment" => "Conta Corrente, Conta Poupança ou Conta Salário", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Conta Corrente, Conta Poupança, Conta Salário, Chave Pix"], "entity" => ""], 30 => ["validation" => "", "title" => "Banco", "field" => "idBanco", "comment" => "Id referente ao id do Banco", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Banco"], 31 => ["validation" => "", "title" => "Agência", "field" => "agencia", "comment" => "Numero da Agência", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 32 => ["validation" => "", "title" => "Dígito", "field" => "digitoAgencia", "comment" => "Numero do Dígito da Agência", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 33 => ["validation" => "", "title" => "Conta Corrente", "field" => "contacorrente", "comment" => "Número da Conta Corrente", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 34 => ["validation" => "", "title" => "Dígito", "field" => "digitoConta", "comment" => "Número do Dígito da Conta Corrente", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 35 => ["validation" => "", "title" => "Variação", "field" => "variacao", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 36 => ["validation" => "", "title" => "Nome da Conta", "field" => "nomeconta", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 37 => ["validation" => "", "title" => "CPF ou CNPJ Conta", "field" => "CpfCnpj", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 38 => ["validation" => "", "title" => "Chave Pix", "field" => "chavePix", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 39 => ["validation" => "", "title" => "Fazenda", "field" => "idFazenda", "comment" => "Id referente ao id da Fazenda", "type" => "number", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "Fazenda"]]], "culturas" => ["config" => ["name" => "Modelo_cadastro_cultura.xls", "modelPk" => "TipoPlanta", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Nome", "field" => "nomeCapim", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Atividade", "field" => "idNegocio", "comment" => "Id referente ao id da Atividade", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Negocio"]]], "contas-correntes" => ["config" => ["name" => "Modelo_cadastro_conta_corrente.xls", "modelPk" => "ContaCorrente", "modelFk" => ["BancoConvenio"], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Data Abertura", "field" => "DataAbertura", "comment" => "", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Banco", "field" => "IdBanco", "comment" => "Id referente ao id do Banco", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Banco"], 2 => ["validation" => "", "title" => "Impactar Fluxo Caixa", "field" => "statusFC", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 3 => ["validation" => "", "title" => "CPF/CNPJ Conta", "field" => "tipoCPFCNPJ", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "CPF, CNPJ, OUTROS"], "entity" => ""], 4 => ["validation" => "", "title" => "CPF/CNPJ", "field" => "CNPJCPF", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "Nome Conta", "field" => "nomeConta", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "Agência", "field" => "Agencia", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Dígito Agência", "field" => "digitoAgencia", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "Número Conta", "field" => "numeroConta", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Dígito Conta", "field" => "digitoConta", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "Descrição Conta", "field" => "DescConta", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Gerente do Banco", "field" => "GerenteBanco", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 12 => ["validation" => "", "title" => "Limite de Crédito Cheque Especial", "field" => "limiteCredito", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 13 => ["validation" => "", "title" => "Limite de Crédito Financiamento", "field" => "limiteCreditoFinanciamento", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 14 => ["validation" => "", "title" => "Saldo Mínimo", "field" => "saldoMinimo", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 15 => ["validation" => "", "title" => "Cód Conta Corrente", "field" => "codigoINTSYS", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 16 => ["validation" => "", "title" => "Cód Contábil Crédito", "field" => "codigoPlanoContaINTSYS", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 17 => ["validation" => "", "title" => "Cód Empresa INTSYS", "field" => "codigoEmpresaINTSYS", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 18 => ["validation" => "", "title" => "Nome Convênio", "field" => "nomeConvenio", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 19 => ["validation" => "", "title" => "Código Convênio", "field" => "codigoEmpresaBancoConvenio", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "variavel-de-controle" => ["config" => ["name" => "Modelo_cadastro_variavel_controle.xls", "modelPk" => "VariavelControle", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Nome da Variável de Controle", "field" => "NomeVariavelControle", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "contas-dre" => ["config" => ["name" => "Modelo_cadastro_conta_dre.xls", "modelPk" => "ContaDre", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Nome da Conta", "field" => "nomeConta", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Tipo", "field" => "tipo", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Entrada, Saída, Totalizador, Porcentagem"], "entity" => ""], 2 => ["validation" => "", "title" => "Ordem", "field" => "ordem", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Aparecer após id", "field" => "idContaDRE_vinculo", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "conta-analitica" => ["config" => ["name" => "Modelo_cadastro_conta_analitica.xls", "modelPk" => "ContaAnalitica", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Centro Gerencial", "field" => "idPlanoContaCategoria", "comment" => "Id referente ao id do Centro Gerencial", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "PlanoContaCategoria"], 1 => ["validation" => "", "title" => "Centro Custo", "field" => "idCentroCusto", "comment" => "Id referente ao id do Centro de Custo", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "CentroCusto"], 2 => ["validation" => "", "title" => "Classificação", "field" => "classificacao", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Nome da Conta", "field" => "DescricaoConta", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Status", "field" => "status", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Ativo, Inativo"], "entity" => ""], 5 => ["validation" => "", "title" => "Objetivo", "field" => "destinoConta", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Investimento, Operacional, Financiamento, Dividendos, Movimentações Caixa"], "entity" => ""], 6 => ["validation" => "", "title" => "Conta DRE", "field" => "idContaDRE", "comment" => "Id referente ao id da Conta DRE", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ContaDre"], 7 => ["validation" => "", "title" => "Alerta", "field" => "statusAlerta", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Não, Sim"], "entity" => ""], 8 => ["validation" => "", "title" => "% Alerta", "field" => "porcentagemAlerta", "comment" => "", "type" => "porcentagem", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Ordem", "field" => "ordem", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "Situação IR", "field" => "situacaoIR", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "IR com Documento Fiscal, IR sem Documento Fiscal, Não IR"], "entity" => ""], 11 => ["validation" => "", "title" => "Obrigatoriedade da Atividade no Financeiro", "field" => "idNegocioObrigatorio", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Não, Sim"], "entity" => ""], 12 => ["validation" => "", "title" => "Descrição e Detalhes", "field" => "obs", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "centro-de-custo-e-receita" => ["config" => ["name" => "Modelo_cadastro_centro_custo.xls", "modelPk" => "CentroCusto", "modelFk" => ["CentroCustoCategoria"], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Centro Gerencial", "field" => "idPlanoContaCategoria", "comment" => "Id referente ao id do Centro Gerencial", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => ["modelDAO" => "PlanoContaCategoriaDAO", "list" => ""], "entity" => "PlanoContaCategoria"], 1 => ["validation" => "", "title" => "Classificação", "field" => "classificacao", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Ordem", "field" => "ordem", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Nome", "field" => "nomeCentroCusto", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Tipo Custo/Receita", "field" => "tipoDiretoIndireto", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Indireto, Direto, Ambos"], "entity" => ""]]], "cadastro-de-tipo-ativo" => ["config" => ["name" => "Modelo_cadastro_tipo_ativo.xls", "modelPk" => "TipoAtivo", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Nome Tipo Ativo", "field" => "nomeTipoAtivo", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Uso Combustível", "field" => "usoCombustivel", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Sim, Não"], "entity" => ""], 2 => ["validation" => "", "title" => "Autonomia", "field" => "tipoUnidadeAtivo", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Litro/Hora-KM, Hora-Km/Litro"], "entity" => ""], 3 => ["validation" => "", "title" => "Tipo Depreciação", "field" => "tipoDepreciacao", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Linear, Valorização"], "entity" => ""], 4 => ["validation" => "", "title" => "Valor Residual %", "field" => "valorResidualporcent", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "Execução de Serviços em Talhão/Pasto/Área", "field" => "estiloRelatorio", "comment" => "", "type" => "text", "size" => 250, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Sim, Não"], "entity" => ""]]], "cadastro-de-ativos" => ["config" => ["name" => "Modelo_cadastro_ativo.xls", "modelPk" => "Ativo", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Data Compra", "field" => "dataCompra", "comment" => "", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "self::validationCodAtivoRepetido", "title" => "Código Ativo", "field" => "codigoAtivo", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Status", "field" => "status", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Próprio, Vendido, Sucata, Terceiros"], "entity" => ""], 3 => ["validation" => "", "title" => "Nome Ativo", "field" => "nomeAtivo", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Local Fazenda", "field" => "idFazenda", "comment" => "Id referente ao id da Fazenda", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "Fazenda"], 5 => ["validation" => "", "title" => "Tipo Ativo", "field" => "idTipoAtivo", "comment" => "Id referente ao id do Tipo de Ativo", "type" => "number", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "TipoAtivo"], 6 => ["validation" => "", "title" => "Categoria Tipo Ativo", "field" => "idTipoAtivoCategoria", "comment" => "Id referente ao id da Categoria do Tipo de Ativo", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "TipoAtivoCategoria"], 7 => ["validation" => "", "title" => "Ano de Fabricação", "field" => "ano", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "Ano do Modelo", "field" => "anoModelo", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Valor Ativo Compra", "field" => "valorAtivo", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "Valor Atual Ativo", "field" => "vidaAtualvalor", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Vida Útil Anos", "field" => "vidaUtil", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 12 => ["validation" => "", "title" => "Custo Hora Comercial", "field" => "custoHora", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 13 => ["validation" => "", "title" => "Km/Horímetro Atual", "field" => "km", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 14 => ["validation" => "", "title" => "Marca", "field" => "marca", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 15 => ["validation" => "", "title" => "Modelo", "field" => "modelo", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 16 => ["validation" => "", "title" => "Número Série", "field" => "numeroSerie", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 17 => ["validation" => "", "title" => "Chassi", "field" => "chassi", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 18 => ["validation" => "", "title" => "Placa", "field" => "placa", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 19 => ["validation" => "", "title" => "Cor", "field" => "cor", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 20 => ["validation" => "", "title" => "CRV", "field" => "crv", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 21 => ["validation" => "", "title" => "Renavam", "field" => "renavam", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 22 => ["validation" => "", "title" => "Capacidade da Bomba", "field" => "capacidadeBomba", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 23 => ["validation" => "", "title" => "Fórmula Bomba/Ha", "field" => "bombaImplemento", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 24 => ["validation" => "", "title" => "Observações", "field" => "obs", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "controle-de-chuvas" => ["config" => ["name" => "Modelo_cadastro_chuvas.xls", "modelPk" => "Chuvas", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Data da Chuva", "field" => "dataChuva", "comment" => "", "type" => "date", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Código Pluviômetro", "field" => "idChuvaLocal", "comment" => "Id referente ao id do Pluviômetro", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ChuvasLocal"], 2 => ["validation" => "", "title" => "Quantidade ml", "field" => "qtidadeChuva", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Temperatura Mín", "field" => "tempMin", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Temperatura Méd", "field" => "tempMed", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "Temperatura Máx", "field" => "tempMax", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "talhoesarea" => ["config" => ["name" => "Modelo_cadastro_talhoesarea.xls", "modelPk" => "TalhaoArea", "modelFk" => ["PastagemNegocio", "PastagemCapim"], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Código Talhão/Área", "field" => "codigoPastagem", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Nome Talhão/Área", "field" => "nomePastagem", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Status", "field" => "status", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Ativado, Inativo"], "entity" => ""], 3 => ["validation" => "", "title" => "Ordem Aparece", "field" => "ordem", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Fazenda", "field" => "idFazenda", "comment" => "Id referente ao id da Fazenda", "type" => "number", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => "Fazenda"], 5 => ["validation" => "", "title" => "Atividade", "field" => "idNegocio", "comment" => "Id referente ao id da Atividade", "type" => "number", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => "Negocio"], 6 => ["validation" => "", "title" => "Área (HA)", "field" => "areaHa", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Área Útil (HA)", "field" => "areaHaUtil", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "Latitude (MAPS)", "field" => "lat", "comment" => "", "type" => "lat", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Longitude (MAPS)", "field" => "lng", "comment" => "", "type" => "lng", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "Coordenadas Linhas", "field" => "coordinates", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Observações", "field" => "obsPastagem", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 12 => ["validation" => "", "title" => "Tipo Cultura/Planta/Capim", "field" => "idCapim", "comment" => "Id referente ao id do Tipo Cultura/Planta/Capim", "type" => "number", "size" => 180, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => "TipoPlanta"], 13 => ["validation" => "", "title" => "Porcentagem", "field" => "participacaoPorcentagem", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "10, 20, 30, 40, 50, 60, 70, 80, 90, 100"], "entity" => ""], 14 => ["validation" => "", "title" => "Quantidade Pés", "field" => "qtidadePe", "comment" => "Quantidade de Pés deve ser número inteiro, não pode ser decimal", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 15 => ["validation" => "", "title" => "Espaçamento entre Linhas", "field" => "espacamentoPeInicio", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 16 => ["validation" => "", "title" => "Espaçamento entre Plantas", "field" => "espacamentoPeFim", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "planejamento" => ["config" => ["name" => "Modelo_cadastro_planejamento.xls", "modelPk" => "Planejamento", "modelFk" => ["PlanejamentoItem"], "columRequired" => 0, "header" => true], "fields" => [0 => ["validation" => "", "title" => "Data", "field" => "DataVecto", "comment" => "", "type" => "date", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Ano Agricola", "field" => "AnoAgricola", "comment" => "", "type" => "anoSafra", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "ControleSafraDAO", "list" => ""]], 2 => ["validation" => "", "title" => "Id Plano Conta", "field" => "idPlanoConta", "comment" => "Id referente ao id do Plano Conta", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ContaAnalitica"], 3 => ["validation" => "", "title" => "Id Unidade Negocio", "field" => "idUnidadeNegocio", "comment" => "Id referente ao id da Uni. de Negócio", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "UnidadeNegocio"], 4 => ["validation" => "", "title" => "Id Atividade", "field" => "idNegocio", "comment" => "Id referente ao id da Atividade", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Negocio"], 5 => ["validation" => "", "title" => "Id Fazenda", "field" => "idFazenda", "comment" => "Id referente ao id da Fazenda", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Fazenda"], 6 => ["validation" => "", "title" => "Valor", "field" => "VlrPagar", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Descrição", "field" => "descricao", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "previsao-de-colheita" => ["config" => ["name" => "Modelo_cadastro_previsaocolheita.xls", "modelPk" => "FazendaPrevisaoColheita", "modelFk" => ["FazendaPrevisaoColheitaPastagem"], "columRequired" => 0, "header" => true], "fields" => [0 => ["validation" => "", "title" => "Data da Previsão", "field" => "data", "comment" => "", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Data Inicial de Venda Prevista para Colheita", "field" => "dataInicioColheita", "comment" => "", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Descrição", "field" => "descricao", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Atividade", "field" => "idNegocio", "comment" => "Id referente ao id da Atividade", "type" => "number", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "Negocio"], 4 => ["validation" => "", "title" => "Pessoa Responsável", "field" => "idEntidade", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "Pessoa"], 5 => ["validation" => "", "title" => "Produto Estoque", "field" => "idProduto", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "Produto"], 6 => ["validation" => "", "title" => "Ano Safra", "field" => "AnoAgricolaSafra", "comment" => "", "type" => "anoSafra", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "ControleSafraDAO", "list" => ""], "entity" => "ControleSafra"], 7 => ["validation" => "", "title" => "Fazenda", "field" => "idFazenda", "comment" => "Id referente ao id da Fazenda", "type" => "number", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "Fazenda"], 8 => ["validation" => "", "title" => "Observação", "field" => "obs", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Talhão/Área", "field" => "idPastagem", "comment" => "Id referente ao id do Talhao/Area", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "TalhaoArea"], 10 => ["validation" => "", "title" => "Ha", "field" => "areaHa", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Total de Sacas", "field" => "qtidadeProduto", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "cadastro-categorias-servicos" => ["config" => ["name" => "Modelo_cadastro_categorias_servicos.xls", "modelPk" => "CategoriaServico", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Código Interno", "field" => "idInterno", "comment" => "Código Interno", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Nome da Categoria de Serviço", "field" => "nomeCategoriaServico", "comment" => "Nome da Categoria de Serviço", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "cadastro-sub-categoria-de-servicos" => ["config" => ["name" => "Modelo_cadastro_sub_categorias_servicos.xls", "modelPk" => "SubCategoriaServico", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Código Interno", "field" => "idInterno", "comment" => "Código Interno", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Nome da Subcategoria", "field" => "nomeSubcat", "comment" => "Nome da Subcategoria", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Categoria Vinculada", "field" => "idCategoriaServico", "comment" => "Id referente ao id da Categoria Vinculada", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "CategoriaServico"]]], "cadastros-de-servicos" => ["config" => ["name" => "Modelo_cadastros_de_servicos.xls", "modelPk" => "CadPastagemServico", "modelFk" => ["ServicosCategoriaSubCat"], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Código Interno", "field" => "idInterno", "comment" => "Código Interno", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Nome Serviço", "field" => "NomeServico", "comment" => "Nome Serviço", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Utiliza Produtos", "field" => "utilizaProdutos", "comment" => "Utiliza Produtos", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Não, Sim"], "entity" => ""], 3 => ["validation" => "", "title" => "Exige Receita/Ordem de Serviço", "field" => "exigeReceita", "comment" => "Exige Receita/Ordem de Serviço", "type" => "text", "size" => 170, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Não, Sim"], "entity" => ""], 4 => ["validation" => "", "title" => "Exige Talhao", "field" => "exigePastagem", "comment" => "Exige Talhao", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Não, Sim"], "entity" => ""], 5 => ["validation" => "", "title" => "Categoria Vinculada", "field" => "idSubSub", "comment" => "Id referente ao id da Categoria Vinculada", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "SubSubCategoriaServico"]]], "categorias-de-servicos" => ["config" => ["name" => "Modelo_cadastro_categorias_servicos.xls", "modelPk" => "CategoriaServicoAdministrativo", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Nome da Categoria de Serviço", "field" => "nomeCategoriaServico", "comment" => "Nome da Categoria de Serviço", "type" => "text", "size" => 180, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "servicos" => ["config" => ["name" => "Modelo_cadastros_de_servicos.xls", "modelPk" => "ServicoAdministrativo", "modelFk" => ["CadServicoPlanoConta"], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Nome do Serviço", "field" => "NomeServicoCompra", "comment" => "Nome do Serviço", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Categoria", "field" => "idCategoriaServico", "comment" => "Id referente ao id da Categoria", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "CategoriaServicoAdministrativo"], 2 => ["validation" => "", "title" => "Plano de Contas a Pagar", "field" => "idPlanoConta", "comment" => "Id referente ao id do Plano de Contas", "type" => "number", "size" => 180, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ContaAnalitica"]]], "contas-a-receber" => ["config" => ["name" => "Modelo_cadastros_contas_receber.xls", "modelPk" => "ContasReceber", "modelFk" => ["ContasReceberItem"], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "CPF/CNPJ", "field" => "idEntidade", "comment" => "CPF/CNPJ", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Tipo Pagamento", "field" => "idTipoPagamento", "comment" => "1 - Cheque Próprio\n2 - Cartão de Crédito\n3 - Débito em Conta\n4 - Dinheiro\n5 - Transferência\n6 - Cartão de Débito\n7 - Boleto Bancário\n8 - Depósito\n11 - Transf. via Remessa\n14 - Boleto via Remessa\n15 - Trib. ou C. Consumo (Cod. de Barras) via Remessa\n20 - Crédito em Conta\n99 - Barter - Troca\n499 - PIX\n599 - Pontos\n699 - Crédito ICMS", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "TipoPagamentoDAO", "list" => ""], "entity" => ""], 2 => ["validation" => "", "title" => "Data Vencimento", "field" => "DataVecto", "comment" => "Data Vencimento", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Ano-Mês Competência", "field" => "dataEmissao", "comment" => "Exemplo: 00/0000", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Data Competência", "field" => "data", "comment" => "Exemplo: 00/00/0000", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "Valor", "field" => "VlraReceber", "comment" => "Valor", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "N. Doc/Cheque", "field" => "numeroDoc", "comment" => "N. Doc/Cheque", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Plano Conta", "field" => "idPlanoConta", "comment" => "Id referente ao id do Plano Conta", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ContaAnalitica"], 8 => ["validation" => "", "title" => "Unidade de Negócio", "field" => "idUnidadeNegocio", "comment" => "Id referente ao id da Uni. de Negócio", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "UnidadeNegocio"], 9 => ["validation" => "", "title" => "Fazenda", "field" => "idFazenda", "comment" => "Id referente ao id da Fazenda\nOBS: Campo não obrigattório\nUsar: 0", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Fazenda"], 10 => ["validation" => "", "title" => "Atividade", "field" => "idNegocio", "comment" => "Id referente ao id da Atividade\nOBS: Campo não obrigattório\nUsar: 0", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Negocio"], 11 => ["validation" => "", "title" => "Conta Banco", "field" => "idContaBancaria", "comment" => "Id referente ao id da Conta Banco\nOBS: Campo não obrigattório\nUsar: 0", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ContaCorrente"], 12 => ["validation" => "", "title" => "Departamento", "field" => "idDepartamento", "comment" => "Id referente ao id do Departamento\nOBS: Campo não obrigatório\nUsar: 0", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Departamentos"], 13 => ["validation" => "", "title" => "Variável de Controle", "field" => "idVariavelControle", "comment" => "Variável de Controle", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 14 => ["validation" => "", "title" => "Descrição", "field" => "Descricao", "comment" => "Descrição", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 15 => ["validation" => "", "title" => "Ano Safra", "field" => "AnoAgricola", "comment" => "Exemplo: 0000/0000", "type" => "anoSafra", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "ControleSafraDAO", "list" => ""], "entity" => ""], 16 => ["validation" => "", "title" => "Número de Contrato", "field" => "numeroContrato", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 17 => ["validation" => "", "title" => "Descricao Parcela", "field" => "obs", "comment" => "Descricao Parcela", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "contas-a-pagar" => ["config" => ["name" => "Modelo_cadastros_contas_pagar.xls", "modelPk" => "ContasPagar", "modelFk" => ["ContasPagarItem"], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "CPF/CNPJ", "field" => "cpfCnpj", "comment" => "CPF/CNPJ", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Tipo Pagamento", "field" => "idTipoPagamento", "comment" => "1 - Cheque Próprio\n2 - Cartão de Crédito\n3 - Débito em Conta\n4 - Dinheiro\n5 - Transferência\n6 - Cartão de Débito\n7 - Boleto Bancário\n8 - Depósito\n11 - Transf. via Remessa\n14 - Boleto via Remessa\n15 - Trib. ou C. Consumo (Cod. de Barras) via Remessa\n20 - Crédito em Conta\n99 - Barter - Troca\n499 - PIX\n599 - Pontos\n699 - Crédito ICMS", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "TipoPagamentoDAO", "list" => ""], "entity" => ""], 2 => ["validation" => "self::validationChavePix", "title" => "Chave Pix", "field" => "chavePixPlanilha", "comment" => "Chave Pix\nOBS: Campo não obrigatório", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Data Vencimento", "field" => "DataVecto", "comment" => "Data Vencimento", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Mês/Ano Competência", "field" => "mesAnoReferencia", "comment" => "Exemplo: 00/0000", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "Valor", "field" => "VlrPagar", "comment" => "Valor Pagar", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "N. Doc/Cheque", "field" => "numeroDoc", "comment" => "N. Doc/Cheque", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Plano Conta", "field" => "idPlanoConta", "comment" => "Id referente ao id do Plano Conta", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ContaAnalitica"], 8 => ["validation" => "", "title" => "Unidade de Negócio", "field" => "idUnidadeNegocio", "comment" => "Id referente ao id da Uni. de Negócio", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "UnidadeNegocio"], 9 => ["validation" => "", "title" => "Fazenda", "field" => "idFazenda", "comment" => "Id referente ao id da Fazenda\nOBS: Campo não obrigatório\nUsar: 0", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Fazenda"], 10 => ["validation" => "", "title" => "Atividade", "field" => "idNegocio", "comment" => "Id referente ao id da Atividade\nOBS: Campo não obrigatório\nUsar: 0", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Negocio"], 11 => ["validation" => "", "title" => "Conta Banco", "field" => "idContaBancaria", "comment" => "Id referente ao id da Conta Banco\nOBS: Campo não obrigatório\nUsar: 0", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ContaCorrente"], 12 => ["validation" => "", "title" => "Departamento", "field" => "idDepartamento", "comment" => "Id referente ao id do Departamento\nOBS: Campo não obrigatório\nUsar: 0", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Departamentos"], 13 => ["validation" => "", "title" => "Descrição", "field" => "Descricao", "comment" => "Descrição", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 14 => ["validation" => "", "title" => "Ano Safra", "field" => "AnoAgricola", "comment" => "Exemplo: 0000/0000", "type" => "anoSafra", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "ControleSafraDAO", "list" => ""], "entity" => ""], 15 => ["validation" => "", "title" => "Codigo Forn", "field" => "idEntidade", "comment" => "Id referente ao Codigo do Fornecedor\nOBS: Campo não obrigatório", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 16 => ["validation" => "", "title" => "Variável de Controle", "field" => "idVariavelControle", "comment" => "Id referente a variável de controle. \nOBS: Campo não obrigatório", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "VariavelControle"]]], "uso-de-combustivel" => ["config" => ["name" => "Modelo_cadastros_uso_combustivel.xls", "modelPk" => "UsoCombustivel", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "self::validationSupplyDate", "title" => "Data Abastecimento", "field" => "data", "comment" => "Data Abastecimento", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Máquina/Veículo", "field" => "idAtivo", "comment" => "Id referente ao id da Máquina/Veículo(Ativo)", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Km/Horímetro no Abastecimento", "field" => "km", "comment" => "Km/Horímetro no Abastecimento", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Responsável Abastecimento", "field" => "idEntidade", "comment" => "Id referente ao id do Responsável Abastecimento", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Condutor", "field" => "idEntidadeCondutor", "comment" => "Id referente ao id do Condutor", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "Bomba", "field" => "idBomba", "comment" => "Id referente ao id da Bomba", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "Fazenda", "field" => "idFazenda", "comment" => "Id referente ao id da Fazenda", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Quantidade Litros", "field" => "qtidade", "comment" => "Quantidade Litros", "type" => "decimal3", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "Preço/Litro", "field" => "custoUnitario", "comment" => "Preço/Litro", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Atividade", "field" => "idNegocio", "comment" => "Atividade", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Negocio"], 10 => ["validation" => "", "title" => "Ano Safra", "field" => "AnoAgricolaSafra", "comment" => "Ano Safra", "type" => "anoSafra", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Horas ou Km no Abastecimento", "field" => "kmLancado", "comment" => "Horas ou Km no Abastecimento", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""]]], "upload-import-excel-inbra" => ["config" => ["name" => "", "modelPk" => "UsoCombustivel", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "data", "field" => "data", "comment" => "Data Abastecimento", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "cod externo proprietario", "field" => "1", "comment" => "Id referente ao Ativo de Terceiro", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "cod externo cavalo", "field" => "2", "comment" => "id Ativo do sistema", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "cavalo", "field" => "placaVeiculo", "comment" => "Quando Terceiro, a placa é preenchida aqui", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "horainicio", "field" => "DataHora", "comment" => "Data Hora do Abastecimento", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "km/horimetro", "field" => "km", "comment" => "km no momento do abastecimento", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "cod externo operador", "field" => "idEntidade", "comment" => "Id referente a Entidade", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Id externo condutor(motorista)", "field" => "idEntidadeCondutor", "comment" => "id referente ao motorista", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "cod externo bico", "field" => "idBomba", "comment" => "Id referente a bomba de combustível", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "qtd litros", "field" => "qtidade", "comment" => "Quantidade Litros abastecidos", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "preco/litro", "field" => "custoUnitario", "comment" => "Preço por litro", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "classificacao", "field" => "11", "comment" => "Classificação se ativo é próprio ou de terceiro", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 12 => ["validation" => "", "title" => "Preco classficacao", "field" => "12", "comment" => "Quando Terceiro, utilizar este valor como custo por litro", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "movimentos-de-estoque" => ["config" => ["name" => "Modelo_cadastros_inventario_movimento_estoque.xls", "modelPk" => "MovimentoEstoque", "modelFk" => [], "columRequired" => 7], "fields" => [0 => ["validation" => "", "title" => "idProduto", "field" => "idProduto", "comment" => "id do Produto", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "NomeProduto", "field" => "DescricaoCurta", "comment" => "Descricao Curta do Produto", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "CodigoProduto", "field" => "codigoProduto", "comment" => "Código do Produto", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Categoria", "field" => "NomeFamiliaProduto", "comment" => "Categoria do Produto", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "SubCategoria", "field" => "nomeSubcat", "comment" => "SubCategoria do Produto", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "idDeposito", "field" => "idDeposito", "comment" => "id do Deposito", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "nomeDeposito", "field" => "nomeDeposito", "comment" => "Nome do Deposito", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Unidade", "field" => "UnidadeProduto", "comment" => "Unidade do Produto", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "QuantidadeAtual", "field" => "saldoAtual", "comment" => "Quantidade Atual", "type" => "decimal4", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""]]], "movimentos-de-estoque-lote-compra" => ["config" => ["name" => "Modelo_cadastros_inventario_lote_compra_movimento_estoque.xls", "modelPk" => "MovimentoEstoque", "modelFk" => [], "columRequired" => 7], "fields" => [0 => ["validation" => "", "title" => "idProduto", "field" => "idProduto", "comment" => "id do Produto", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "NomeProduto", "field" => "DescricaoCurta", "comment" => "Descricao Curta do Produto", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "CodigoProduto", "field" => "codigoProduto", "comment" => "Código do Produto", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Categoria", "field" => "NomeFamiliaProduto", "comment" => "Categoria do Produto", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "SubCategoria", "field" => "nomeSubcat", "comment" => "SubCategoria do Produto", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "idDeposito", "field" => "idDeposito", "comment" => "id do Deposito", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "nomeDeposito", "field" => "nomeDeposito", "comment" => "Nome do Deposito", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Unidade", "field" => "UnidadeProduto", "comment" => "Unidade do Produto", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "idLoteCompra", "field" => "idProdutoLoteCompra", "comment" => "id produto de lote de compra", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "NumeroLote", "field" => "numeroLote", "comment" => "nº do lote de compra", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "DataVecto", "field" => "dataVecto", "comment" => "data do vecto do lote de compra", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "DataFabricacao", "field" => "dataFabricacao", "comment" => "data da fabricação do lote de compra", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 12 => ["validation" => "", "title" => "QuantidadeAtual", "field" => "saldoAtual", "comment" => "Quantidade Atual", "type" => "decimal4", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""]]], "livro-caixa-digital" => ["config" => ["name" => "Modelo_livro_caixa_digital.xls", "modelPk" => "", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Data", "field" => "data", "comment" => "", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Lote", "field" => "lote", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Cod INTSYS Conta Corrente", "field" => "idContaCorrenteIntSys", "comment" => "", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Cod INTSYS Empresa", "field" => "codigoEmpresaINTSYS", "comment" => "", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "self::validationCpfCnpjLivroCaixa", "title" => "CPF/CNPJ", "field" => "cpfCnpjEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "Razão Social/Nome", "field" => "razaoSocial", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "Tipo Documento", "field" => "tipoNota", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "1 = NOTA FISCAL, 2 = FATURA, 3 = RECIBO, 4 = CONTRATO, 5 = FOLHA PAGAMENTO, 6 = OUTROS"], "entity" => ""], 7 => ["validation" => "", "title" => "Tipo Lançamento", "field" => "tipoLancamento", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "1 = RECEITA, 2 = DESPESA"], "entity" => ""], 8 => ["validation" => "", "title" => "Nº Nota/Documento", "field" => "numDocumento", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Conta Débito", "field" => "contaDebito", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "Conta Crédito", "field" => "contaCredito", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Cod. Histórico", "field" => "codHistorico", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 12 => ["validation" => "", "title" => "Valor", "field" => "valor", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 13 => ["validation" => "", "title" => "Cod. Imóvel", "field" => "codImovel", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 14 => ["validation" => "", "title" => "Observação", "field" => "observacao", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "cadastro-justificativa" => ["config" => ["name" => "justificativa_balancete.xls", "modelPk" => "CadastroJustificativa", "modelFk" => ["CadastroJustificativaItem"], "columRequired" => 0, "header" => true], "fields" => [0 => ["validation" => "", "title" => "Nome Justificativa", "field" => "nomeJustificativa", "comment" => "Exemplo: Justificativa Exemplo", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Ano Agrícola", "field" => "anoAgricola", "comment" => "Exemplo: 2022/2023", "type" => "anoSafra", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "ControleSafraDAO", "list" => ""], "entity" => ""], 2 => ["validation" => "", "title" => "Data", "field" => "data", "comment" => "Exemplo: 01/01/2023", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Unidade de Negócio", "field" => "idUnidadeNegocio", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "UnidadeNegocio"], 4 => ["validation" => "", "title" => "Fazenda", "field" => "idFazenda", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Fazenda"], 5 => ["validation" => "", "title" => "Atividade", "field" => "idNegocio", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Negocio"], 6 => ["validation" => "", "title" => "Plano de Contas", "field" => "idPlanoConta", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ContaAnalitica"], 7 => ["validation" => "", "title" => "Valor Orçado", "field" => "valorOrcado", "comment" => "Exemplo: 1.500,00", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "Valor Pago", "field" => "valorPago", "comment" => "Exemplo: 1.500,00", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Valor à Vencer", "field" => "valorAVencer", "comment" => "Exemplo: 1.500,00", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "Justificativa", "field" => "Justificativa", "comment" => "Exemplo: Justificativa Exemplo", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Ação", "field" => "acao", "comment" => "Exemplo: Ação Exemplo", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "integracao-contabil" => ["config" => ["name" => "Integracao_contabil.xls", "modelPk" => "ContaAnalitica", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "idPlanoConta", "field" => "idPlanoConta", "comment" => "Id plano conta", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "CentroGerencial", "field" => "idPlanoContaCategoria", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Categoria", "field" => "nomeSubCat", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "CentroCustoReceita", "field" => "nomeCentroCusto", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "DescricaoConta", "field" => "DescricaoConta", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "SituacaoIR", "field" => "situacaoIR", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "ContaINTSYS", "field" => "idCont1", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Historico", "field" => "idCont3", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""]]], "marcacao-apontamento-trabalhista" => ["config" => ["name" => "Apontamento_trabalhista.xls", "modelPk" => "TABFPPRDM", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Data", "field" => "COMPE_PRDM", "comment" => "", "type" => "date", "size" => 150, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Empresa", "field" => "EMPRE_PRDM", "comment" => "", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Funcionario", "field" => "FUNCI_PRDM", "comment" => "", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Evento", "field" => "CODIG_PRDM", "comment" => "", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Quantidade", "field" => "QUANT_PRDM", "comment" => "", "type" => "decimal", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "TipoPagamento", "field" => "PAGTO_PRDM", "comment" => "", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "idLocalTrabalhista", "field" => "LOCAL", "comment" => "", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Valor", "field" => "VALOR_PRDM", "comment" => "", "type" => "decimal", "size" => 150, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "departamentos" => ["config" => ["name" => "departamentos.xls", "modelPk" => "Departamentos", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Nome Departamento", "field" => "nomeDepartamento", "comment" => "", "type" => "text", "size" => 150, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "movimentacao-de-aplicacoes-financeiras" => ["config" => ["name" => "Modelo_movimentacao_aplicacao_financeira.xls", "modelPk" => "RendimentoJuros", "modelFk" => [], "columRequired" => 11], "fields" => [0 => ["validation" => "", "title" => "idRendimento", "field" => "idRendimento", "comment" => "id do Rendimento", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "NomeBanco", "field" => "NomeBanco", "comment" => "Nome do banco", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "numeroConta", "field" => "numeroConta", "comment" => "Número da Conta Bancária", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "descricaoRendimento", "field" => "descricaoRendimento", "comment" => "Descrição do Rendimento", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "saldoAtual", "field" => "saldoAtual", "comment" => "Saldo atual", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "DataMovimentacao", "field" => "data", "comment" => "Data da movimentacao", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "Safra", "field" => "AnoAgricola", "comment" => "Ano safra", "type" => "anoSafra", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "TipoMovimentacao", "field" => "tipoMovimentacao", "comment" => "Tipo da Movimentacao", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "ValorMovimentacao", "field" => "valor", "comment" => "Valor da Movimentacao", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Descricao", "field" => "descricao", "comment" => "Descricao da Movimentacao", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "NumeroDocumento", "field" => "numDoc", "comment" => "Número da documentação", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""]]], "cheque-terceiro" => ["config" => ["name" => "Modelo_cadastro_cheques_terceiros.xls", "modelPk" => "ChequeTerceiro", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "self::validationEmissorExists", "title" => "CPF/CNPJ Emissor", "field" => "idEntidadeCheque", "comment" => "Doc. Emissor Cheque", "type" => "cpfCnpj", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "self::validationClienteExists", "title" => "CPF/CNPJ Cliente", "field" => "idEntidadeCliente", "comment" => "Doc. Cliente", "type" => "cpfCnpj", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Banco", "field" => "IdBanco", "comment" => "Id referente ao id do Banco", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Banco"], 3 => ["validation" => "", "title" => "Agência", "field" => "agencia", "comment" => "Numero da Agência", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Conta Corrente", "field" => "contaCorrente", "comment" => "Numero da Conta", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "N. Cheque", "field" => "numeroCheque", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "Valor", "field" => "valor", "comment" => "Valor do Cheque", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Data Recebimento", "field" => "dataRecebimento", "comment" => "Data Recebimento do Cheque", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "Data Compensação", "field" => "dataPrevista", "comment" => "Data Prevista Compensação", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Código CMC7", "field" => "codigoCMC7", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "Descrição", "field" => "descricao", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "movimento-estoque-import-export" => ["config" => ["name" => "Modelo_cadastros_movimento_estoque.xls", "modelPk" => "ProcessoColheita", "modelFk" => ["MovimentoEstoque"], "columRequired" => 7], "fields" => [0 => ["validation" => "", "title" => "Data", "field" => "data", "comment" => "Data", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Ano Safra", "field" => "AnoAgricolaSafra", "comment" => "Ano Safra", "type" => "anoSafra", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => "ControleSafra"], 2 => ["validation" => "", "title" => "Departamento", "field" => "idDepartamento", "comment" => "Id referente ao id do Departamento", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Departamentos"], 3 => ["validation" => "", "title" => "Tipo", "field" => "tipo", "comment" => "Tipo de Movimentação", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Uso(-), Perdas (-), Outras Entradas (+), Devolução ao Estoque (+), Devolução ao Fornecedor (-)"], "entity" => ""], 4 => ["validation" => "", "title" => "Depósito da Operação", "field" => "idDeposito", "comment" => "Id referente ao id do Depósito", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => "Deposito"], 5 => ["validation" => "", "title" => "Responsável", "field" => "idEntidade", "comment" => "Id referente ao id do Responsável", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => "Pessoa"], 6 => ["validation" => "", "title" => "Solicitante", "field" => "idEntidadeSolicitante", "comment" => "Id referente ao id do Solicitante", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => "Pessoa"], 7 => ["validation" => "", "title" => "Atividade", "field" => "idNegocio", "comment" => "Id referente ao id do Solicitante", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Negocio"], 8 => ["validation" => "", "title" => "Fazenda", "field" => "idFazenda", "comment" => "Id referente ao id do Fazenda", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Fazenda"], 9 => ["validation" => "", "title" => "Planejamento Agrícola", "field" => "idReceita", "comment" => "Id referente ao id do Planejamento Agrícola", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ProdutosReceita"], 10 => ["validation" => "", "title" => "Descrição", "field" => "descricao", "comment" => "Descrição", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Produto", "field" => "idProduto", "comment" => "Id referente ao id do Produto", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Produto"], 12 => ["validation" => "", "title" => "Talhão", "field" => "idPastagem", "comment" => "Id referente ao id do Pastagem", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "TalhaoArea"], 13 => ["validation" => "", "title" => "Quantidade", "field" => "qtidade", "comment" => "Quantidade de Produto", "type" => "decimal4", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""]]]]
ENTIDADE_BASE = ["config" => ["name" => "Modelo_cadastro_pessoas.xls", "modelPk" => "Pessoa", "modelFk" => ["Endereco", "SegmentacaoEntidade", "PessoaBanco"], "columRequired" => 1], "fields" => [0 => ["validation" => "", "title" => "Cliente", "field" => "ClienteEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 1 => ["validation" => "", "title" => "Fornecedor", "field" => "FornecedorEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 2 => ["validation" => "", "title" => "Transportadora", "field" => "TransportadoraEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 3 => ["validation" => "", "title" => "Funcionário", "field" => "FuncionarioEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 4 => ["validation" => "", "title" => "Produtor", "field" => "CriadorEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 5 => ["validation" => "", "title" => "Terceiro", "field" => "TerceiroEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 6 => ["validation" => "", "title" => "Nome Completo / Fantasia", "field" => "NomeEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "self::validationCpfCnpjVerdadeiroOuFalsoEntidade", "title" => "CPF ou CNPJ", "field" => "cpfCnpjEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 8 => ["validation" => "self::validationCnpCnpj", "title" => "Física/Jurídica", "field" => "PessoaFisiccaJuridicaEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "FISICA, JURIDICA"], "entity" => ""], 9 => ["validation" => "", "title" => "Razão Social", "field" => "razaoSocial", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "Contato", "field" => "contatoEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Inscrição Estadual", "field" => "IE", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 12 => ["validation" => "", "title" => "Email de Contato", "field" => "EmailEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 13 => ["validation" => "", "title" => "Site Empresa", "field" => "SiteEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 14 => ["validation" => "", "title" => "Telefone", "field" => "TelefoneEntidade", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 15 => ["validation" => "", "title" => "Celular", "field" => "CelularEntidade", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 16 => ["validation" => "", "title" => "ID Segmentação", "field" => "idSegmentoEntidade", "comment" => "Id referente ao id da Segmento da Entidade", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Segmentacao"], 17 => ["validation" => "", "title" => "Observações", "field" => "OBSEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => "Pessoa"], 18 => ["validation" => "", "title" => "CEP", "field" => "CEP", "comment" => "", "type" => "cep", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 19 => ["validation" => "", "title" => "Endereço", "field" => "Endereco", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 20 => ["validation" => "", "title" => "Número", "field" => "Numero", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 21 => ["validation" => "", "title" => "Complemento", "field" => "Complemento", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 22 => ["validation" => "", "title" => "Bairro", "field" => "Bairro", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 23 => ["validation" => "", "title" => "Cidade", "field" => "Cidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 24 => ["validation" => "", "title" => "Estado", "field" => "UF", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "AC,AL,AP,AM,BA,CE,DF,ES,GO,MA,MT,MS,MG,PA,PB,PR,PE,PI,RJ,RN,RS,RO,RR,SC,SP,SE,TO"], "entity" => ""], 25 => ["validation" => "", "title" => "Tipo Conta", "field" => "tipoConta", "comment" => "Conta Corrente, Conta Poupança ou Conta Salário", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Conta Corrente, Conta Poupança, Conta Salário, Chave Pix"], "entity" => ""], 26 => ["validation" => "", "title" => "Banco", "field" => "idBanco", "comment" => "Id referente ao id do Banco", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Banco"], 27 => ["validation" => "", "title" => "Agência", "field" => "agencia", "comment" => "Numero da Agência", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 28 => ["validation" => "", "title" => "Dígito", "field" => "digitoAgencia", "comment" => "Numero do Dígito da Agência", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 29 => ["validation" => "", "title" => "Conta Corrente", "field" => "contacorrente", "comment" => "Número da Conta Corrente", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 30 => ["validation" => "", "title" => "Dígito", "field" => "digitoConta", "comment" => "Número do Dígito da Conta Corrente", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 31 => ["validation" => "", "title" => "Variação", "field" => "variacao", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 32 => ["validation" => "", "title" => "Nome da Conta", "field" => "nomeconta", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 33 => ["validation" => "", "title" => "CPF ou CNPJ Conta", "field" => "CpfCnpj", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 34 => ["validation" => "", "title" => "Chave Pix", "field" => "chavePix", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]]

TEMPLATE_EXCEL


    public
        mixed
    TEMPLATE_EXCEL
    = ["empresasprodutores" => self::ENTIDADE_BASE, "fornecedores" => self::ENTIDADE_BASE, "clientes" => self::ENTIDADE_BASE, "terceiro" => self::ENTIDADE_BASE, "registro-de-cotacoes" => ["config" => ["name" => "Modelo_registro_cotacao.xls", "modelPk" => "CotacaoDia", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Id", "field" => "idCotacao", "comment" => "Id referente ao id da cotação", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Cotacao"], 1 => ["validation" => "", "title" => "Data", "field" => "dataCadastro", "comment" => "Data de cadastro", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Valor", "field" => "valor", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "bancos" => ["config" => ["name" => "Modelo_cadastro_banco.xls", "modelPk" => "Banco", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Código Banco", "field" => "CodBanco", "comment" => "Código Banco", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Nome do Banco", "field" => "NomeBanco", "comment" => "Nome Banco", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Site do Banco", "field" => "HomePageBanco", "comment" => "Site do Banco", "type" => "url", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Internet Banking ofx", "field" => "statusBanking", "comment" => "Status do Internet Banking (Ativo ou Inativo)", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "ATIVO, INATIVO"], "entity" => ""]]], "funcionarios_ultimo_salario" => ["config" => ["name" => "Modelo_ultimo_salario.xls", "modelPk" => "PessoaFuncionario", "modelFk" => [], "columRequired" => 0, "update" => true], "fields" => [0 => ["validation" => "", "title" => "CPF", "field" => "cpfCnpjEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Salário Registrado", "field" => "salarioRegistrado", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Último Salário Pago", "field" => "salarioRegistradoUltimoPago", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Custo Hora", "field" => "custoHora", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "funcionarios" => ["config" => ["name" => "Modelo_cadastro_funcionario.xls", "modelPk" => "Pessoa", "modelFk" => ["Endereco", "SegmentacaoEntidade", "PessoaBanco", "PessoaFuncionario"], "columRequired" => 1], "fields" => [0 => ["validation" => "", "title" => "Cliente", "field" => "ClienteEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 1 => ["validation" => "", "title" => "Fornecedor", "field" => "FornecedorEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 2 => ["validation" => "", "title" => "Transportadora", "field" => "TransportadoraEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 3 => ["validation" => "", "title" => "Funcionário", "field" => "FuncionarioEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 4 => ["validation" => "", "title" => "Produtor", "field" => "CriadorEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 5 => ["validation" => "", "title" => "Nome Completo / Fantasia", "field" => "NomeEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "self::validationCpfCnpjVerdadeiroOuFalso", "title" => "CPF ou CNPJ", "field" => "cpfCnpjEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Departamento", "field" => "idDepartamento", "comment" => "Id referente ao id do Departamento", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "Departamentos"], 8 => ["validation" => "self::validationCnpCnpj", "title" => "Tipo Pessoa", "field" => "PessoaFisiccaJuridicaEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "FISICA, JURIDICA"], "entity" => ""], 9 => ["validation" => "", "title" => "Razão Social", "field" => "razaoSocial", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "Email de Contato", "field" => "EmailEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Telefone", "field" => "TelefoneEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 12 => ["validation" => "", "title" => "Celular", "field" => "CelularEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 13 => ["validation" => "", "title" => "ID Segmentação", "field" => "idSegmentoEntidade", "comment" => "Id referente ao id da Segmento da Entidade", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Segmentacao"], 14 => ["validation" => "", "title" => "Data Admissão", "field" => "dataAdmissao", "comment" => "", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 15 => ["validation" => "", "title" => "Data Demissão", "field" => "dataDemissao", "comment" => "", "type" => "date", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 16 => ["validation" => "", "title" => "Salário Registrado", "field" => "salarioRegistrado", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 17 => ["validation" => "", "title" => "Salário Líquido", "field" => "salarioLiquido", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 18 => ["validation" => "", "title" => "Último Salário Pago", "field" => "salarioRegistradoUltimoPago", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 19 => ["validation" => "", "title" => "Custo Hora", "field" => "custoHora", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 20 => ["validation" => "", "title" => "Centro Custo INTSYS", "field" => "centroCustoINTSYS", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 21 => ["validation" => "", "title" => "Observações", "field" => "OBSEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => "Pessoa"], 22 => ["validation" => "", "title" => "CEP", "field" => "CEP", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 23 => ["validation" => "", "title" => "Endereço", "field" => "Endereco", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 24 => ["validation" => "", "title" => "Número", "field" => "Numero", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 25 => ["validation" => "", "title" => "Complemento", "field" => "Complemento", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 26 => ["validation" => "", "title" => "Bairro", "field" => "Bairro", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 27 => ["validation" => "", "title" => "Cidade", "field" => "Cidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 28 => ["validation" => "", "title" => "Estado", "field" => "UF", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "AC,AL,AP,AM,BA,CE,DF,ES,GO,MA,MT,MS,MG,PA,PB,PR,PE,PI,RJ,RN,RS,RO,RR,SC,SP,SE,TO"], "entity" => ""], 29 => ["validation" => "", "title" => "Tipo Conta", "field" => "tipoConta", "comment" => "Conta Corrente, Conta Poupança ou Conta Salário", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Conta Corrente, Conta Poupança, Conta Salário, Chave Pix"], "entity" => ""], 30 => ["validation" => "", "title" => "Banco", "field" => "idBanco", "comment" => "Id referente ao id do Banco", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Banco"], 31 => ["validation" => "", "title" => "Agência", "field" => "agencia", "comment" => "Numero da Agência", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 32 => ["validation" => "", "title" => "Dígito", "field" => "digitoAgencia", "comment" => "Numero do Dígito da Agência", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 33 => ["validation" => "", "title" => "Conta Corrente", "field" => "contacorrente", "comment" => "Número da Conta Corrente", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 34 => ["validation" => "", "title" => "Dígito", "field" => "digitoConta", "comment" => "Número do Dígito da Conta Corrente", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 35 => ["validation" => "", "title" => "Variação", "field" => "variacao", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 36 => ["validation" => "", "title" => "Nome da Conta", "field" => "nomeconta", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 37 => ["validation" => "", "title" => "CPF ou CNPJ Conta", "field" => "CpfCnpj", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 38 => ["validation" => "", "title" => "Chave Pix", "field" => "chavePix", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 39 => ["validation" => "", "title" => "Fazenda", "field" => "idFazenda", "comment" => "Id referente ao id da Fazenda", "type" => "number", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "Fazenda"]]], "culturas" => ["config" => ["name" => "Modelo_cadastro_cultura.xls", "modelPk" => "TipoPlanta", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Nome", "field" => "nomeCapim", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Atividade", "field" => "idNegocio", "comment" => "Id referente ao id da Atividade", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Negocio"]]], "contas-correntes" => ["config" => ["name" => "Modelo_cadastro_conta_corrente.xls", "modelPk" => "ContaCorrente", "modelFk" => ["BancoConvenio"], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Data Abertura", "field" => "DataAbertura", "comment" => "", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Banco", "field" => "IdBanco", "comment" => "Id referente ao id do Banco", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Banco"], 2 => ["validation" => "", "title" => "Impactar Fluxo Caixa", "field" => "statusFC", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 3 => ["validation" => "", "title" => "CPF/CNPJ Conta", "field" => "tipoCPFCNPJ", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "CPF, CNPJ, OUTROS"], "entity" => ""], 4 => ["validation" => "", "title" => "CPF/CNPJ", "field" => "CNPJCPF", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "Nome Conta", "field" => "nomeConta", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "Agência", "field" => "Agencia", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Dígito Agência", "field" => "digitoAgencia", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "Número Conta", "field" => "numeroConta", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Dígito Conta", "field" => "digitoConta", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "Descrição Conta", "field" => "DescConta", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Gerente do Banco", "field" => "GerenteBanco", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 12 => ["validation" => "", "title" => "Limite de Crédito Cheque Especial", "field" => "limiteCredito", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 13 => ["validation" => "", "title" => "Limite de Crédito Financiamento", "field" => "limiteCreditoFinanciamento", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 14 => ["validation" => "", "title" => "Saldo Mínimo", "field" => "saldoMinimo", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 15 => ["validation" => "", "title" => "Cód Conta Corrente", "field" => "codigoINTSYS", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 16 => ["validation" => "", "title" => "Cód Contábil Crédito", "field" => "codigoPlanoContaINTSYS", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 17 => ["validation" => "", "title" => "Cód Empresa INTSYS", "field" => "codigoEmpresaINTSYS", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 18 => ["validation" => "", "title" => "Nome Convênio", "field" => "nomeConvenio", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 19 => ["validation" => "", "title" => "Código Convênio", "field" => "codigoEmpresaBancoConvenio", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "variavel-de-controle" => ["config" => ["name" => "Modelo_cadastro_variavel_controle.xls", "modelPk" => "VariavelControle", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Nome da Variável de Controle", "field" => "NomeVariavelControle", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "contas-dre" => ["config" => ["name" => "Modelo_cadastro_conta_dre.xls", "modelPk" => "ContaDre", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Nome da Conta", "field" => "nomeConta", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Tipo", "field" => "tipo", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Entrada, Saída, Totalizador, Porcentagem"], "entity" => ""], 2 => ["validation" => "", "title" => "Ordem", "field" => "ordem", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Aparecer após id", "field" => "idContaDRE_vinculo", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "conta-analitica" => ["config" => ["name" => "Modelo_cadastro_conta_analitica.xls", "modelPk" => "ContaAnalitica", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Centro Gerencial", "field" => "idPlanoContaCategoria", "comment" => "Id referente ao id do Centro Gerencial", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "PlanoContaCategoria"], 1 => ["validation" => "", "title" => "Centro Custo", "field" => "idCentroCusto", "comment" => "Id referente ao id do Centro de Custo", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "CentroCusto"], 2 => ["validation" => "", "title" => "Classificação", "field" => "classificacao", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Nome da Conta", "field" => "DescricaoConta", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Status", "field" => "status", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Ativo, Inativo"], "entity" => ""], 5 => ["validation" => "", "title" => "Objetivo", "field" => "destinoConta", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Investimento, Operacional, Financiamento, Dividendos, Movimentações Caixa"], "entity" => ""], 6 => ["validation" => "", "title" => "Conta DRE", "field" => "idContaDRE", "comment" => "Id referente ao id da Conta DRE", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ContaDre"], 7 => ["validation" => "", "title" => "Alerta", "field" => "statusAlerta", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Não, Sim"], "entity" => ""], 8 => ["validation" => "", "title" => "% Alerta", "field" => "porcentagemAlerta", "comment" => "", "type" => "porcentagem", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Ordem", "field" => "ordem", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "Situação IR", "field" => "situacaoIR", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "IR com Documento Fiscal, IR sem Documento Fiscal, Não IR"], "entity" => ""], 11 => ["validation" => "", "title" => "Obrigatoriedade da Atividade no Financeiro", "field" => "idNegocioObrigatorio", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Não, Sim"], "entity" => ""], 12 => ["validation" => "", "title" => "Descrição e Detalhes", "field" => "obs", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "centro-de-custo-e-receita" => ["config" => ["name" => "Modelo_cadastro_centro_custo.xls", "modelPk" => "CentroCusto", "modelFk" => ["CentroCustoCategoria"], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Centro Gerencial", "field" => "idPlanoContaCategoria", "comment" => "Id referente ao id do Centro Gerencial", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => ["modelDAO" => "PlanoContaCategoriaDAO", "list" => ""], "entity" => "PlanoContaCategoria"], 1 => ["validation" => "", "title" => "Classificação", "field" => "classificacao", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Ordem", "field" => "ordem", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Nome", "field" => "nomeCentroCusto", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Tipo Custo/Receita", "field" => "tipoDiretoIndireto", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Indireto, Direto, Ambos"], "entity" => ""]]], "cadastro-de-tipo-ativo" => ["config" => ["name" => "Modelo_cadastro_tipo_ativo.xls", "modelPk" => "TipoAtivo", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Nome Tipo Ativo", "field" => "nomeTipoAtivo", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Uso Combustível", "field" => "usoCombustivel", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Sim, Não"], "entity" => ""], 2 => ["validation" => "", "title" => "Autonomia", "field" => "tipoUnidadeAtivo", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Litro/Hora-KM, Hora-Km/Litro"], "entity" => ""], 3 => ["validation" => "", "title" => "Tipo Depreciação", "field" => "tipoDepreciacao", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Linear, Valorização"], "entity" => ""], 4 => ["validation" => "", "title" => "Valor Residual %", "field" => "valorResidualporcent", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "Execução de Serviços em Talhão/Pasto/Área", "field" => "estiloRelatorio", "comment" => "", "type" => "text", "size" => 250, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Sim, Não"], "entity" => ""]]], "cadastro-de-ativos" => ["config" => ["name" => "Modelo_cadastro_ativo.xls", "modelPk" => "Ativo", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Data Compra", "field" => "dataCompra", "comment" => "", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "self::validationCodAtivoRepetido", "title" => "Código Ativo", "field" => "codigoAtivo", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Status", "field" => "status", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Próprio, Vendido, Sucata, Terceiros"], "entity" => ""], 3 => ["validation" => "", "title" => "Nome Ativo", "field" => "nomeAtivo", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Local Fazenda", "field" => "idFazenda", "comment" => "Id referente ao id da Fazenda", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "Fazenda"], 5 => ["validation" => "", "title" => "Tipo Ativo", "field" => "idTipoAtivo", "comment" => "Id referente ao id do Tipo de Ativo", "type" => "number", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "TipoAtivo"], 6 => ["validation" => "", "title" => "Categoria Tipo Ativo", "field" => "idTipoAtivoCategoria", "comment" => "Id referente ao id da Categoria do Tipo de Ativo", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "TipoAtivoCategoria"], 7 => ["validation" => "", "title" => "Ano de Fabricação", "field" => "ano", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "Ano do Modelo", "field" => "anoModelo", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Valor Ativo Compra", "field" => "valorAtivo", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "Valor Atual Ativo", "field" => "vidaAtualvalor", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Vida Útil Anos", "field" => "vidaUtil", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 12 => ["validation" => "", "title" => "Custo Hora Comercial", "field" => "custoHora", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 13 => ["validation" => "", "title" => "Km/Horímetro Atual", "field" => "km", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 14 => ["validation" => "", "title" => "Marca", "field" => "marca", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 15 => ["validation" => "", "title" => "Modelo", "field" => "modelo", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 16 => ["validation" => "", "title" => "Número Série", "field" => "numeroSerie", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 17 => ["validation" => "", "title" => "Chassi", "field" => "chassi", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 18 => ["validation" => "", "title" => "Placa", "field" => "placa", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 19 => ["validation" => "", "title" => "Cor", "field" => "cor", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 20 => ["validation" => "", "title" => "CRV", "field" => "crv", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 21 => ["validation" => "", "title" => "Renavam", "field" => "renavam", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 22 => ["validation" => "", "title" => "Capacidade da Bomba", "field" => "capacidadeBomba", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 23 => ["validation" => "", "title" => "Fórmula Bomba/Ha", "field" => "bombaImplemento", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 24 => ["validation" => "", "title" => "Observações", "field" => "obs", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "controle-de-chuvas" => ["config" => ["name" => "Modelo_cadastro_chuvas.xls", "modelPk" => "Chuvas", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Data da Chuva", "field" => "dataChuva", "comment" => "", "type" => "date", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Código Pluviômetro", "field" => "idChuvaLocal", "comment" => "Id referente ao id do Pluviômetro", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ChuvasLocal"], 2 => ["validation" => "", "title" => "Quantidade ml", "field" => "qtidadeChuva", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Temperatura Mín", "field" => "tempMin", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Temperatura Méd", "field" => "tempMed", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "Temperatura Máx", "field" => "tempMax", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "talhoesarea" => ["config" => ["name" => "Modelo_cadastro_talhoesarea.xls", "modelPk" => "TalhaoArea", "modelFk" => ["PastagemNegocio", "PastagemCapim"], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Código Talhão/Área", "field" => "codigoPastagem", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Nome Talhão/Área", "field" => "nomePastagem", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Status", "field" => "status", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Ativado, Inativo"], "entity" => ""], 3 => ["validation" => "", "title" => "Ordem Aparece", "field" => "ordem", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Fazenda", "field" => "idFazenda", "comment" => "Id referente ao id da Fazenda", "type" => "number", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => "Fazenda"], 5 => ["validation" => "", "title" => "Atividade", "field" => "idNegocio", "comment" => "Id referente ao id da Atividade", "type" => "number", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => "Negocio"], 6 => ["validation" => "", "title" => "Área (HA)", "field" => "areaHa", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Área Útil (HA)", "field" => "areaHaUtil", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "Latitude (MAPS)", "field" => "lat", "comment" => "", "type" => "lat", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Longitude (MAPS)", "field" => "lng", "comment" => "", "type" => "lng", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "Coordenadas Linhas", "field" => "coordinates", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Observações", "field" => "obsPastagem", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 12 => ["validation" => "", "title" => "Tipo Cultura/Planta/Capim", "field" => "idCapim", "comment" => "Id referente ao id do Tipo Cultura/Planta/Capim", "type" => "number", "size" => 180, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => "TipoPlanta"], 13 => ["validation" => "", "title" => "Porcentagem", "field" => "participacaoPorcentagem", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "10, 20, 30, 40, 50, 60, 70, 80, 90, 100"], "entity" => ""], 14 => ["validation" => "", "title" => "Quantidade Pés", "field" => "qtidadePe", "comment" => "Quantidade de Pés deve ser número inteiro, não pode ser decimal", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 15 => ["validation" => "", "title" => "Espaçamento entre Linhas", "field" => "espacamentoPeInicio", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 16 => ["validation" => "", "title" => "Espaçamento entre Plantas", "field" => "espacamentoPeFim", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "planejamento" => ["config" => ["name" => "Modelo_cadastro_planejamento.xls", "modelPk" => "Planejamento", "modelFk" => ["PlanejamentoItem"], "columRequired" => 0, "header" => true], "fields" => [0 => ["validation" => "", "title" => "Data", "field" => "DataVecto", "comment" => "", "type" => "date", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Ano Agricola", "field" => "AnoAgricola", "comment" => "", "type" => "anoSafra", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "ControleSafraDAO", "list" => ""]], 2 => ["validation" => "", "title" => "Id Plano Conta", "field" => "idPlanoConta", "comment" => "Id referente ao id do Plano Conta", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ContaAnalitica"], 3 => ["validation" => "", "title" => "Id Unidade Negocio", "field" => "idUnidadeNegocio", "comment" => "Id referente ao id da Uni. de Negócio", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "UnidadeNegocio"], 4 => ["validation" => "", "title" => "Id Atividade", "field" => "idNegocio", "comment" => "Id referente ao id da Atividade", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Negocio"], 5 => ["validation" => "", "title" => "Id Fazenda", "field" => "idFazenda", "comment" => "Id referente ao id da Fazenda", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Fazenda"], 6 => ["validation" => "", "title" => "Valor", "field" => "VlrPagar", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Descrição", "field" => "descricao", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "previsao-de-colheita" => ["config" => ["name" => "Modelo_cadastro_previsaocolheita.xls", "modelPk" => "FazendaPrevisaoColheita", "modelFk" => ["FazendaPrevisaoColheitaPastagem"], "columRequired" => 0, "header" => true], "fields" => [0 => ["validation" => "", "title" => "Data da Previsão", "field" => "data", "comment" => "", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Data Inicial de Venda Prevista para Colheita", "field" => "dataInicioColheita", "comment" => "", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Descrição", "field" => "descricao", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Atividade", "field" => "idNegocio", "comment" => "Id referente ao id da Atividade", "type" => "number", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "Negocio"], 4 => ["validation" => "", "title" => "Pessoa Responsável", "field" => "idEntidade", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "Pessoa"], 5 => ["validation" => "", "title" => "Produto Estoque", "field" => "idProduto", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "Produto"], 6 => ["validation" => "", "title" => "Ano Safra", "field" => "AnoAgricolaSafra", "comment" => "", "type" => "anoSafra", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "ControleSafraDAO", "list" => ""], "entity" => "ControleSafra"], 7 => ["validation" => "", "title" => "Fazenda", "field" => "idFazenda", "comment" => "Id referente ao id da Fazenda", "type" => "number", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "Fazenda"], 8 => ["validation" => "", "title" => "Observação", "field" => "obs", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Talhão/Área", "field" => "idPastagem", "comment" => "Id referente ao id do Talhao/Area", "type" => "number", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => true, "comboBox" => [], "entity" => "TalhaoArea"], 10 => ["validation" => "", "title" => "Ha", "field" => "areaHa", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Total de Sacas", "field" => "qtidadeProduto", "comment" => "", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "cadastro-categorias-servicos" => ["config" => ["name" => "Modelo_cadastro_categorias_servicos.xls", "modelPk" => "CategoriaServico", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Código Interno", "field" => "idInterno", "comment" => "Código Interno", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Nome da Categoria de Serviço", "field" => "nomeCategoriaServico", "comment" => "Nome da Categoria de Serviço", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "cadastro-sub-categoria-de-servicos" => ["config" => ["name" => "Modelo_cadastro_sub_categorias_servicos.xls", "modelPk" => "SubCategoriaServico", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Código Interno", "field" => "idInterno", "comment" => "Código Interno", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Nome da Subcategoria", "field" => "nomeSubcat", "comment" => "Nome da Subcategoria", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Categoria Vinculada", "field" => "idCategoriaServico", "comment" => "Id referente ao id da Categoria Vinculada", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "CategoriaServico"]]], "cadastros-de-servicos" => ["config" => ["name" => "Modelo_cadastros_de_servicos.xls", "modelPk" => "CadPastagemServico", "modelFk" => ["ServicosCategoriaSubCat"], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Código Interno", "field" => "idInterno", "comment" => "Código Interno", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Nome Serviço", "field" => "NomeServico", "comment" => "Nome Serviço", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Utiliza Produtos", "field" => "utilizaProdutos", "comment" => "Utiliza Produtos", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Não, Sim"], "entity" => ""], 3 => ["validation" => "", "title" => "Exige Receita/Ordem de Serviço", "field" => "exigeReceita", "comment" => "Exige Receita/Ordem de Serviço", "type" => "text", "size" => 170, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Não, Sim"], "entity" => ""], 4 => ["validation" => "", "title" => "Exige Talhao", "field" => "exigePastagem", "comment" => "Exige Talhao", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Não, Sim"], "entity" => ""], 5 => ["validation" => "", "title" => "Categoria Vinculada", "field" => "idSubSub", "comment" => "Id referente ao id da Categoria Vinculada", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "SubSubCategoriaServico"]]], "categorias-de-servicos" => ["config" => ["name" => "Modelo_cadastro_categorias_servicos.xls", "modelPk" => "CategoriaServicoAdministrativo", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Nome da Categoria de Serviço", "field" => "nomeCategoriaServico", "comment" => "Nome da Categoria de Serviço", "type" => "text", "size" => 180, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "servicos" => ["config" => ["name" => "Modelo_cadastros_de_servicos.xls", "modelPk" => "ServicoAdministrativo", "modelFk" => ["CadServicoPlanoConta"], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Nome do Serviço", "field" => "NomeServicoCompra", "comment" => "Nome do Serviço", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Categoria", "field" => "idCategoriaServico", "comment" => "Id referente ao id da Categoria", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "CategoriaServicoAdministrativo"], 2 => ["validation" => "", "title" => "Plano de Contas a Pagar", "field" => "idPlanoConta", "comment" => "Id referente ao id do Plano de Contas", "type" => "number", "size" => 180, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ContaAnalitica"]]], "contas-a-receber" => ["config" => ["name" => "Modelo_cadastros_contas_receber.xls", "modelPk" => "ContasReceber", "modelFk" => ["ContasReceberItem"], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "CPF/CNPJ", "field" => "idEntidade", "comment" => "CPF/CNPJ", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Tipo Pagamento", "field" => "idTipoPagamento", "comment" => "1 - Cheque Próprio\n2 - Cartão de Crédito\n3 - Débito em Conta\n4 - Dinheiro\n5 - Transferência\n6 - Cartão de Débito\n7 - Boleto Bancário\n8 - Depósito\n11 - Transf. via Remessa\n14 - Boleto via Remessa\n15 - Trib. ou C. Consumo (Cod. de Barras) via Remessa\n20 - Crédito em Conta\n99 - Barter - Troca\n499 - PIX\n599 - Pontos\n699 - Crédito ICMS", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "TipoPagamentoDAO", "list" => ""], "entity" => ""], 2 => ["validation" => "", "title" => "Data Vencimento", "field" => "DataVecto", "comment" => "Data Vencimento", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Ano-Mês Competência", "field" => "dataEmissao", "comment" => "Exemplo: 00/0000", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Data Competência", "field" => "data", "comment" => "Exemplo: 00/00/0000", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "Valor", "field" => "VlraReceber", "comment" => "Valor", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "N. Doc/Cheque", "field" => "numeroDoc", "comment" => "N. Doc/Cheque", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Plano Conta", "field" => "idPlanoConta", "comment" => "Id referente ao id do Plano Conta", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ContaAnalitica"], 8 => ["validation" => "", "title" => "Unidade de Negócio", "field" => "idUnidadeNegocio", "comment" => "Id referente ao id da Uni. de Negócio", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "UnidadeNegocio"], 9 => ["validation" => "", "title" => "Fazenda", "field" => "idFazenda", "comment" => "Id referente ao id da Fazenda\nOBS: Campo não obrigattório\nUsar: 0", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Fazenda"], 10 => ["validation" => "", "title" => "Atividade", "field" => "idNegocio", "comment" => "Id referente ao id da Atividade\nOBS: Campo não obrigattório\nUsar: 0", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Negocio"], 11 => ["validation" => "", "title" => "Conta Banco", "field" => "idContaBancaria", "comment" => "Id referente ao id da Conta Banco\nOBS: Campo não obrigattório\nUsar: 0", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ContaCorrente"], 12 => ["validation" => "", "title" => "Departamento", "field" => "idDepartamento", "comment" => "Id referente ao id do Departamento\nOBS: Campo não obrigatório\nUsar: 0", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Departamentos"], 13 => ["validation" => "", "title" => "Variável de Controle", "field" => "idVariavelControle", "comment" => "Variável de Controle", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 14 => ["validation" => "", "title" => "Descrição", "field" => "Descricao", "comment" => "Descrição", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 15 => ["validation" => "", "title" => "Ano Safra", "field" => "AnoAgricola", "comment" => "Exemplo: 0000/0000", "type" => "anoSafra", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "ControleSafraDAO", "list" => ""], "entity" => ""], 16 => ["validation" => "", "title" => "Número de Contrato", "field" => "numeroContrato", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 17 => ["validation" => "", "title" => "Descricao Parcela", "field" => "obs", "comment" => "Descricao Parcela", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "contas-a-pagar" => ["config" => ["name" => "Modelo_cadastros_contas_pagar.xls", "modelPk" => "ContasPagar", "modelFk" => ["ContasPagarItem"], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "CPF/CNPJ", "field" => "cpfCnpj", "comment" => "CPF/CNPJ", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Tipo Pagamento", "field" => "idTipoPagamento", "comment" => "1 - Cheque Próprio\n2 - Cartão de Crédito\n3 - Débito em Conta\n4 - Dinheiro\n5 - Transferência\n6 - Cartão de Débito\n7 - Boleto Bancário\n8 - Depósito\n11 - Transf. via Remessa\n14 - Boleto via Remessa\n15 - Trib. ou C. Consumo (Cod. de Barras) via Remessa\n20 - Crédito em Conta\n99 - Barter - Troca\n499 - PIX\n599 - Pontos\n699 - Crédito ICMS", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "TipoPagamentoDAO", "list" => ""], "entity" => ""], 2 => ["validation" => "self::validationChavePix", "title" => "Chave Pix", "field" => "chavePixPlanilha", "comment" => "Chave Pix\nOBS: Campo não obrigatório", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Data Vencimento", "field" => "DataVecto", "comment" => "Data Vencimento", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Mês/Ano Competência", "field" => "mesAnoReferencia", "comment" => "Exemplo: 00/0000", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "Valor", "field" => "VlrPagar", "comment" => "Valor Pagar", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "N. Doc/Cheque", "field" => "numeroDoc", "comment" => "N. Doc/Cheque", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Plano Conta", "field" => "idPlanoConta", "comment" => "Id referente ao id do Plano Conta", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ContaAnalitica"], 8 => ["validation" => "", "title" => "Unidade de Negócio", "field" => "idUnidadeNegocio", "comment" => "Id referente ao id da Uni. de Negócio", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "UnidadeNegocio"], 9 => ["validation" => "", "title" => "Fazenda", "field" => "idFazenda", "comment" => "Id referente ao id da Fazenda\nOBS: Campo não obrigatório\nUsar: 0", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Fazenda"], 10 => ["validation" => "", "title" => "Atividade", "field" => "idNegocio", "comment" => "Id referente ao id da Atividade\nOBS: Campo não obrigatório\nUsar: 0", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Negocio"], 11 => ["validation" => "", "title" => "Conta Banco", "field" => "idContaBancaria", "comment" => "Id referente ao id da Conta Banco\nOBS: Campo não obrigatório\nUsar: 0", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ContaCorrente"], 12 => ["validation" => "", "title" => "Departamento", "field" => "idDepartamento", "comment" => "Id referente ao id do Departamento\nOBS: Campo não obrigatório\nUsar: 0", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Departamentos"], 13 => ["validation" => "", "title" => "Descrição", "field" => "Descricao", "comment" => "Descrição", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 14 => ["validation" => "", "title" => "Ano Safra", "field" => "AnoAgricola", "comment" => "Exemplo: 0000/0000", "type" => "anoSafra", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "ControleSafraDAO", "list" => ""], "entity" => ""], 15 => ["validation" => "", "title" => "Codigo Forn", "field" => "idEntidade", "comment" => "Id referente ao Codigo do Fornecedor\nOBS: Campo não obrigatório", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 16 => ["validation" => "", "title" => "Variável de Controle", "field" => "idVariavelControle", "comment" => "Id referente a variável de controle. \nOBS: Campo não obrigatório", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "VariavelControle"]]], "uso-de-combustivel" => ["config" => ["name" => "Modelo_cadastros_uso_combustivel.xls", "modelPk" => "UsoCombustivel", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "self::validationSupplyDate", "title" => "Data Abastecimento", "field" => "data", "comment" => "Data Abastecimento", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Máquina/Veículo", "field" => "idAtivo", "comment" => "Id referente ao id da Máquina/Veículo(Ativo)", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Km/Horímetro no Abastecimento", "field" => "km", "comment" => "Km/Horímetro no Abastecimento", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Responsável Abastecimento", "field" => "idEntidade", "comment" => "Id referente ao id do Responsável Abastecimento", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Condutor", "field" => "idEntidadeCondutor", "comment" => "Id referente ao id do Condutor", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "Bomba", "field" => "idBomba", "comment" => "Id referente ao id da Bomba", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "Fazenda", "field" => "idFazenda", "comment" => "Id referente ao id da Fazenda", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Quantidade Litros", "field" => "qtidade", "comment" => "Quantidade Litros", "type" => "decimal3", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "Preço/Litro", "field" => "custoUnitario", "comment" => "Preço/Litro", "type" => "decimal", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Atividade", "field" => "idNegocio", "comment" => "Atividade", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Negocio"], 10 => ["validation" => "", "title" => "Ano Safra", "field" => "AnoAgricolaSafra", "comment" => "Ano Safra", "type" => "anoSafra", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Horas ou Km no Abastecimento", "field" => "kmLancado", "comment" => "Horas ou Km no Abastecimento", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""]]], "upload-import-excel-inbra" => ["config" => ["name" => "", "modelPk" => "UsoCombustivel", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "data", "field" => "data", "comment" => "Data Abastecimento", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "cod externo proprietario", "field" => "1", "comment" => "Id referente ao Ativo de Terceiro", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "cod externo cavalo", "field" => "2", "comment" => "id Ativo do sistema", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "cavalo", "field" => "placaVeiculo", "comment" => "Quando Terceiro, a placa é preenchida aqui", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "horainicio", "field" => "DataHora", "comment" => "Data Hora do Abastecimento", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "km/horimetro", "field" => "km", "comment" => "km no momento do abastecimento", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "cod externo operador", "field" => "idEntidade", "comment" => "Id referente a Entidade", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Id externo condutor(motorista)", "field" => "idEntidadeCondutor", "comment" => "id referente ao motorista", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "cod externo bico", "field" => "idBomba", "comment" => "Id referente a bomba de combustível", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "qtd litros", "field" => "qtidade", "comment" => "Quantidade Litros abastecidos", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "preco/litro", "field" => "custoUnitario", "comment" => "Preço por litro", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "classificacao", "field" => "11", "comment" => "Classificação se ativo é próprio ou de terceiro", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 12 => ["validation" => "", "title" => "Preco classficacao", "field" => "12", "comment" => "Quando Terceiro, utilizar este valor como custo por litro", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "movimentos-de-estoque" => ["config" => ["name" => "Modelo_cadastros_inventario_movimento_estoque.xls", "modelPk" => "MovimentoEstoque", "modelFk" => [], "columRequired" => 7], "fields" => [0 => ["validation" => "", "title" => "idProduto", "field" => "idProduto", "comment" => "id do Produto", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "NomeProduto", "field" => "DescricaoCurta", "comment" => "Descricao Curta do Produto", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "CodigoProduto", "field" => "codigoProduto", "comment" => "Código do Produto", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Categoria", "field" => "NomeFamiliaProduto", "comment" => "Categoria do Produto", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "SubCategoria", "field" => "nomeSubcat", "comment" => "SubCategoria do Produto", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "idDeposito", "field" => "idDeposito", "comment" => "id do Deposito", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "nomeDeposito", "field" => "nomeDeposito", "comment" => "Nome do Deposito", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Unidade", "field" => "UnidadeProduto", "comment" => "Unidade do Produto", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "QuantidadeAtual", "field" => "saldoAtual", "comment" => "Quantidade Atual", "type" => "decimal4", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""]]], "movimentos-de-estoque-lote-compra" => ["config" => ["name" => "Modelo_cadastros_inventario_lote_compra_movimento_estoque.xls", "modelPk" => "MovimentoEstoque", "modelFk" => [], "columRequired" => 7], "fields" => [0 => ["validation" => "", "title" => "idProduto", "field" => "idProduto", "comment" => "id do Produto", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "NomeProduto", "field" => "DescricaoCurta", "comment" => "Descricao Curta do Produto", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "CodigoProduto", "field" => "codigoProduto", "comment" => "Código do Produto", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Categoria", "field" => "NomeFamiliaProduto", "comment" => "Categoria do Produto", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "SubCategoria", "field" => "nomeSubcat", "comment" => "SubCategoria do Produto", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "idDeposito", "field" => "idDeposito", "comment" => "id do Deposito", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "nomeDeposito", "field" => "nomeDeposito", "comment" => "Nome do Deposito", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Unidade", "field" => "UnidadeProduto", "comment" => "Unidade do Produto", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "idLoteCompra", "field" => "idProdutoLoteCompra", "comment" => "id produto de lote de compra", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "NumeroLote", "field" => "numeroLote", "comment" => "nº do lote de compra", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "DataVecto", "field" => "dataVecto", "comment" => "data do vecto do lote de compra", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "DataFabricacao", "field" => "dataFabricacao", "comment" => "data da fabricação do lote de compra", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 12 => ["validation" => "", "title" => "QuantidadeAtual", "field" => "saldoAtual", "comment" => "Quantidade Atual", "type" => "decimal4", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""]]], "livro-caixa-digital" => ["config" => ["name" => "Modelo_livro_caixa_digital.xls", "modelPk" => "", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Data", "field" => "data", "comment" => "", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Lote", "field" => "lote", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Cod INTSYS Conta Corrente", "field" => "idContaCorrenteIntSys", "comment" => "", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Cod INTSYS Empresa", "field" => "codigoEmpresaINTSYS", "comment" => "", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "self::validationCpfCnpjLivroCaixa", "title" => "CPF/CNPJ", "field" => "cpfCnpjEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "Razão Social/Nome", "field" => "razaoSocial", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "Tipo Documento", "field" => "tipoNota", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "1 = NOTA FISCAL, 2 = FATURA, 3 = RECIBO, 4 = CONTRATO, 5 = FOLHA PAGAMENTO, 6 = OUTROS"], "entity" => ""], 7 => ["validation" => "", "title" => "Tipo Lançamento", "field" => "tipoLancamento", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "1 = RECEITA, 2 = DESPESA"], "entity" => ""], 8 => ["validation" => "", "title" => "Nº Nota/Documento", "field" => "numDocumento", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Conta Débito", "field" => "contaDebito", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "Conta Crédito", "field" => "contaCredito", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Cod. Histórico", "field" => "codHistorico", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 12 => ["validation" => "", "title" => "Valor", "field" => "valor", "comment" => "", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 13 => ["validation" => "", "title" => "Cod. Imóvel", "field" => "codImovel", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 14 => ["validation" => "", "title" => "Observação", "field" => "observacao", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "cadastro-justificativa" => ["config" => ["name" => "justificativa_balancete.xls", "modelPk" => "CadastroJustificativa", "modelFk" => ["CadastroJustificativaItem"], "columRequired" => 0, "header" => true], "fields" => [0 => ["validation" => "", "title" => "Nome Justificativa", "field" => "nomeJustificativa", "comment" => "Exemplo: Justificativa Exemplo", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Ano Agrícola", "field" => "anoAgricola", "comment" => "Exemplo: 2022/2023", "type" => "anoSafra", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "ControleSafraDAO", "list" => ""], "entity" => ""], 2 => ["validation" => "", "title" => "Data", "field" => "data", "comment" => "Exemplo: 01/01/2023", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Unidade de Negócio", "field" => "idUnidadeNegocio", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "UnidadeNegocio"], 4 => ["validation" => "", "title" => "Fazenda", "field" => "idFazenda", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Fazenda"], 5 => ["validation" => "", "title" => "Atividade", "field" => "idNegocio", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Negocio"], 6 => ["validation" => "", "title" => "Plano de Contas", "field" => "idPlanoConta", "comment" => "", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ContaAnalitica"], 7 => ["validation" => "", "title" => "Valor Orçado", "field" => "valorOrcado", "comment" => "Exemplo: 1.500,00", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "Valor Pago", "field" => "valorPago", "comment" => "Exemplo: 1.500,00", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Valor à Vencer", "field" => "valorAVencer", "comment" => "Exemplo: 1.500,00", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "Justificativa", "field" => "Justificativa", "comment" => "Exemplo: Justificativa Exemplo", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Ação", "field" => "acao", "comment" => "Exemplo: Ação Exemplo", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "integracao-contabil" => ["config" => ["name" => "Integracao_contabil.xls", "modelPk" => "ContaAnalitica", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "idPlanoConta", "field" => "idPlanoConta", "comment" => "Id plano conta", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "CentroGerencial", "field" => "idPlanoContaCategoria", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Categoria", "field" => "nomeSubCat", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "CentroCustoReceita", "field" => "nomeCentroCusto", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "DescricaoConta", "field" => "DescricaoConta", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "SituacaoIR", "field" => "situacaoIR", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "ContaINTSYS", "field" => "idCont1", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Historico", "field" => "idCont3", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""]]], "marcacao-apontamento-trabalhista" => ["config" => ["name" => "Apontamento_trabalhista.xls", "modelPk" => "TABFPPRDM", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Data", "field" => "COMPE_PRDM", "comment" => "", "type" => "date", "size" => 150, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Empresa", "field" => "EMPRE_PRDM", "comment" => "", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Funcionario", "field" => "FUNCI_PRDM", "comment" => "", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "Evento", "field" => "CODIG_PRDM", "comment" => "", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Quantidade", "field" => "QUANT_PRDM", "comment" => "", "type" => "decimal", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "TipoPagamento", "field" => "PAGTO_PRDM", "comment" => "", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "idLocalTrabalhista", "field" => "LOCAL", "comment" => "", "type" => "text", "size" => 200, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Valor", "field" => "VALOR_PRDM", "comment" => "", "type" => "decimal", "size" => 150, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "departamentos" => ["config" => ["name" => "departamentos.xls", "modelPk" => "Departamentos", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "", "title" => "Nome Departamento", "field" => "nomeDepartamento", "comment" => "", "type" => "text", "size" => 150, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "movimentacao-de-aplicacoes-financeiras" => ["config" => ["name" => "Modelo_movimentacao_aplicacao_financeira.xls", "modelPk" => "RendimentoJuros", "modelFk" => [], "columRequired" => 11], "fields" => [0 => ["validation" => "", "title" => "idRendimento", "field" => "idRendimento", "comment" => "id do Rendimento", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "NomeBanco", "field" => "NomeBanco", "comment" => "Nome do banco", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "numeroConta", "field" => "numeroConta", "comment" => "Número da Conta Bancária", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 3 => ["validation" => "", "title" => "descricaoRendimento", "field" => "descricaoRendimento", "comment" => "Descrição do Rendimento", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "saldoAtual", "field" => "saldoAtual", "comment" => "Saldo atual", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "DataMovimentacao", "field" => "data", "comment" => "Data da movimentacao", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "Safra", "field" => "AnoAgricola", "comment" => "Ano safra", "type" => "anoSafra", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "TipoMovimentacao", "field" => "tipoMovimentacao", "comment" => "Tipo da Movimentacao", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "ValorMovimentacao", "field" => "valor", "comment" => "Valor da Movimentacao", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Descricao", "field" => "descricao", "comment" => "Descricao da Movimentacao", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "NumeroDocumento", "field" => "numDoc", "comment" => "Número da documentação", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""]]], "cheque-terceiro" => ["config" => ["name" => "Modelo_cadastro_cheques_terceiros.xls", "modelPk" => "ChequeTerceiro", "modelFk" => [], "columRequired" => 0], "fields" => [0 => ["validation" => "self::validationEmissorExists", "title" => "CPF/CNPJ Emissor", "field" => "idEntidadeCheque", "comment" => "Doc. Emissor Cheque", "type" => "cpfCnpj", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "self::validationClienteExists", "title" => "CPF/CNPJ Cliente", "field" => "idEntidadeCliente", "comment" => "Doc. Cliente", "type" => "cpfCnpj", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 2 => ["validation" => "", "title" => "Banco", "field" => "IdBanco", "comment" => "Id referente ao id do Banco", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Banco"], 3 => ["validation" => "", "title" => "Agência", "field" => "agencia", "comment" => "Numero da Agência", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 4 => ["validation" => "", "title" => "Conta Corrente", "field" => "contaCorrente", "comment" => "Numero da Conta", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 5 => ["validation" => "", "title" => "N. Cheque", "field" => "numeroCheque", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 6 => ["validation" => "", "title" => "Valor", "field" => "valor", "comment" => "Valor do Cheque", "type" => "decimal", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "", "title" => "Data Recebimento", "field" => "dataRecebimento", "comment" => "Data Recebimento do Cheque", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 8 => ["validation" => "", "title" => "Data Compensação", "field" => "dataPrevista", "comment" => "Data Prevista Compensação", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 9 => ["validation" => "", "title" => "Código CMC7", "field" => "codigoCMC7", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "Descrição", "field" => "descricao", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]], "movimento-estoque-import-export" => ["config" => ["name" => "Modelo_cadastros_movimento_estoque.xls", "modelPk" => "ProcessoColheita", "modelFk" => ["MovimentoEstoque"], "columRequired" => 7], "fields" => [0 => ["validation" => "", "title" => "Data", "field" => "data", "comment" => "Data", "type" => "date", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 1 => ["validation" => "", "title" => "Ano Safra", "field" => "AnoAgricolaSafra", "comment" => "Ano Safra", "type" => "anoSafra", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => "ControleSafra"], 2 => ["validation" => "", "title" => "Departamento", "field" => "idDepartamento", "comment" => "Id referente ao id do Departamento", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Departamentos"], 3 => ["validation" => "", "title" => "Tipo", "field" => "tipo", "comment" => "Tipo de Movimentação", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Uso(-), Perdas (-), Outras Entradas (+), Devolução ao Estoque (+), Devolução ao Fornecedor (-)"], "entity" => ""], 4 => ["validation" => "", "title" => "Depósito da Operação", "field" => "idDeposito", "comment" => "Id referente ao id do Depósito", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => "Deposito"], 5 => ["validation" => "", "title" => "Responsável", "field" => "idEntidade", "comment" => "Id referente ao id do Responsável", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => "Pessoa"], 6 => ["validation" => "", "title" => "Solicitante", "field" => "idEntidadeSolicitante", "comment" => "Id referente ao id do Solicitante", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => "Pessoa"], 7 => ["validation" => "", "title" => "Atividade", "field" => "idNegocio", "comment" => "Id referente ao id do Solicitante", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Negocio"], 8 => ["validation" => "", "title" => "Fazenda", "field" => "idFazenda", "comment" => "Id referente ao id do Fazenda", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Fazenda"], 9 => ["validation" => "", "title" => "Planejamento Agrícola", "field" => "idReceita", "comment" => "Id referente ao id do Planejamento Agrícola", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "ProdutosReceita"], 10 => ["validation" => "", "title" => "Descrição", "field" => "descricao", "comment" => "Descrição", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Produto", "field" => "idProduto", "comment" => "Id referente ao id do Produto", "type" => "number", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Produto"], 12 => ["validation" => "", "title" => "Talhão", "field" => "idPastagem", "comment" => "Id referente ao id do Pastagem", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "TalhaoArea"], 13 => ["validation" => "", "title" => "Quantidade", "field" => "qtidade", "comment" => "Quantidade de Produto", "type" => "decimal4", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => ""]]]]

ENTIDADE_BASE


    private
        mixed
    ENTIDADE_BASE
    = ["config" => ["name" => "Modelo_cadastro_pessoas.xls", "modelPk" => "Pessoa", "modelFk" => ["Endereco", "SegmentacaoEntidade", "PessoaBanco"], "columRequired" => 1], "fields" => [0 => ["validation" => "", "title" => "Cliente", "field" => "ClienteEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 1 => ["validation" => "", "title" => "Fornecedor", "field" => "FornecedorEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 2 => ["validation" => "", "title" => "Transportadora", "field" => "TransportadoraEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 3 => ["validation" => "", "title" => "Funcionário", "field" => "FuncionarioEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 4 => ["validation" => "", "title" => "Produtor", "field" => "CriadorEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 5 => ["validation" => "", "title" => "Terceiro", "field" => "TerceiroEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "SIM, NÃO"], "entity" => ""], 6 => ["validation" => "", "title" => "Nome Completo / Fantasia", "field" => "NomeEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 7 => ["validation" => "self::validationCpfCnpjVerdadeiroOuFalsoEntidade", "title" => "CPF ou CNPJ", "field" => "cpfCnpjEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => true, "foreignKey" => false, "comboBox" => [], "entity" => ""], 8 => ["validation" => "self::validationCnpCnpj", "title" => "Física/Jurídica", "field" => "PessoaFisiccaJuridicaEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => true, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "FISICA, JURIDICA"], "entity" => ""], 9 => ["validation" => "", "title" => "Razão Social", "field" => "razaoSocial", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 10 => ["validation" => "", "title" => "Contato", "field" => "contatoEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 11 => ["validation" => "", "title" => "Inscrição Estadual", "field" => "IE", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 12 => ["validation" => "", "title" => "Email de Contato", "field" => "EmailEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 13 => ["validation" => "", "title" => "Site Empresa", "field" => "SiteEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 14 => ["validation" => "", "title" => "Telefone", "field" => "TelefoneEntidade", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 15 => ["validation" => "", "title" => "Celular", "field" => "CelularEntidade", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 16 => ["validation" => "", "title" => "ID Segmentação", "field" => "idSegmentoEntidade", "comment" => "Id referente ao id da Segmento da Entidade", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Segmentacao"], 17 => ["validation" => "", "title" => "Observações", "field" => "OBSEntidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => "Pessoa"], 18 => ["validation" => "", "title" => "CEP", "field" => "CEP", "comment" => "", "type" => "cep", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 19 => ["validation" => "", "title" => "Endereço", "field" => "Endereco", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 20 => ["validation" => "", "title" => "Número", "field" => "Numero", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 21 => ["validation" => "", "title" => "Complemento", "field" => "Complemento", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 22 => ["validation" => "", "title" => "Bairro", "field" => "Bairro", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 23 => ["validation" => "", "title" => "Cidade", "field" => "Cidade", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 24 => ["validation" => "", "title" => "Estado", "field" => "UF", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "AC,AL,AP,AM,BA,CE,DF,ES,GO,MA,MT,MS,MG,PA,PB,PR,PE,PI,RJ,RN,RS,RO,RR,SC,SP,SE,TO"], "entity" => ""], 25 => ["validation" => "", "title" => "Tipo Conta", "field" => "tipoConta", "comment" => "Conta Corrente, Conta Poupança ou Conta Salário", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => ["modelDAO" => "", "list" => "Conta Corrente, Conta Poupança, Conta Salário, Chave Pix"], "entity" => ""], 26 => ["validation" => "", "title" => "Banco", "field" => "idBanco", "comment" => "Id referente ao id do Banco", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => true, "comboBox" => [], "entity" => "Banco"], 27 => ["validation" => "", "title" => "Agência", "field" => "agencia", "comment" => "Numero da Agência", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 28 => ["validation" => "", "title" => "Dígito", "field" => "digitoAgencia", "comment" => "Numero do Dígito da Agência", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 29 => ["validation" => "", "title" => "Conta Corrente", "field" => "contacorrente", "comment" => "Número da Conta Corrente", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 30 => ["validation" => "", "title" => "Dígito", "field" => "digitoConta", "comment" => "Número do Dígito da Conta Corrente", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 31 => ["validation" => "", "title" => "Variação", "field" => "variacao", "comment" => "", "type" => "number", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 32 => ["validation" => "", "title" => "Nome da Conta", "field" => "nomeconta", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 33 => ["validation" => "", "title" => "CPF ou CNPJ Conta", "field" => "CpfCnpj", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""], 34 => ["validation" => "", "title" => "Chave Pix", "field" => "chavePix", "comment" => "", "type" => "text", "size" => 140, "required" => false, "sanitize" => false, "foreignKey" => false, "comboBox" => [], "entity" => ""]]]

Documentation

ConfigImport
in package

Application

Table of Contents

Constants

Constants

TEMPLATE_EXCEL

ENTIDADE_BASE

Search results

ConfigImport in package Application

Table of Contents

Constants

Constants

TEMPLATE_EXCEL

ENTIDADE_BASE

ConfigImport
in package

Application