Tabela
EX3 Tabela de Fretes Maritimos
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
EX3_FILIAL C 2 0 Filial N
EX3_ORIGEM C 3 0 Porto Origem @! NaoVazio() .AND. ExistCpo("SY9",M->EX3_ORIGEM,2) EY9 N
EX3_VIA C 2 0 Via @! N
EX3_DSCORI C 20 0 Desc. Origem @! N
EX3_DEST C 3 0 Porto Dest. @! NaoVazio() .AND. ExistCpo("SY9",M->EX3_DEST,2) EY9 N
EX3_DSCDES C 20 0 Desc. Dest. @! N
EX3_TRATIM N 3 0 Transit Time 999 Positivo() N
EX3_AGENTE C 3 0 Agencia @! NaoVazio() .AND. ExistCpo("SY5",M->EX3_AGENTE) .And. CV200VldAg("EX3_AGENTE") EMB N
EX3_DSCAGE C 40 0 Nome Agencia @! V N
EX3_OBS C 20 0 Observacao N
EX3_MOEDA C 3 0 Moeda @! ExistCpo("SYF",M->EX3_MOEDA) SYF N
EX3_VL_MIN N 14 4 Valor Minimo @E 999,999,999.9999 Positivo() N
EX3_KILO1 N 12 3 1) Ate @E 99,999,999.999 Positivo() N
EX3_VALOR1 N 14 4 Valor p/ Kg1 @E 999,999,999.9999 Positivo() N
EX3_KILO2 N 12 3 2) Ate @E 99,999,999.999 Positivo() N
EX3_VALOR2 N 14 4 Valor p/ Kg2 @E 999,999,999.9999 Positivo() N
EX3_KILO3 N 12 3 3) Ate @E 99,999,999.999 Positivo() N
EX3_VALOR3 N 14 4 Valor p/ Kg3 @E 999,999,999.9999 Positivo() N
EX3_KILO4 N 12 3 4) Ate @E 99,999,999.999 Positivo() N
EX3_VALOR4 N 14 4 Valor p/ Kg4 @E 999,999,999.9999 Positivo() N
EX3_KILO5 N 12 3 5) Ate @E 99,999,999.999 Positivo() N
EX3_VALOR5 N 14 4 Valor p/ Kg5 @E 999,999,999.9999 Positivo() N
EX3_KILO6 N 12 3 6) Acima de @E 99,999,999.999 Positivo() N
EX3_VALOR6 N 14 4 Valor p/ Kg6 @E 999,999,999.9999 Positivo() N