Tabela
TF0 Composicao de carga
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
TF0_FILIAL C 2 0 Filial R N
TF0_TIPO C 1 0 Tp. Destin. @! Pertence("123456") R 1=Tratamento;2=Reutilizacao;3=Co-Processamento;4=Disposicao Final;5=Outros;6=Acondicionamento N
TF0_TPRECE C 1 0 Tp. Receptor @! Pertence("12") .and. SGA280LIMPA("TF0_FORREC","SA1",aLimpa,,,"TF0_FORREC") R 1=Fornecedor;2=Cliente lExterno N
TF0_MENNOT M 10 0 Descri. NF R TF0->TF0_STATUS = "1" N
TF0_CODCOM C 6 0 Cod.Composi. @! R N
TF0_CODRES C 15 0 Cod Residuo @! ExistCpo("SB1",M->TF0_CODRES) .And. SGAA750RES(M->TF0_CODRES) TAX R N
TF0_DESCRE C 30 0 Desc. Resid. @! V N
TF0_DESEST C 15 0 Est. Fisico V N
TF0_DTCOMP D 8 0 Data M->TF0_DTCOMP <= dDataBase R N
TF0_HRCOMP C 5 0 Hora 99:99 VALHORA(M->TF0_HRCOMP) .AND. M->TF0_HRCOMP <= Substr(Time(),1,5) R N
TF0_NUMMTR C 15 0 Numero MTR @! SGAExistMTR() TF0->TF0_STATUS = '1' N
TF0_PESOTO N 9 2 Peso Total @E 999,999.99 NAOVAZIO() R N
TF0_UNIDAD C 2 0 Unid. Med. @! R N
TF0_PESOBA N 9 2 Peso Balan @E 999,999.99 NAOVAZIO() R INCLUI .OR. TF0->TF0_STATUS = '1' N
TF0_UNIBAL C 1 0 Unid. Balan. @! Pertence("123") R 1=Tonelada;2=Quilo;3=Metro Cubico INCLUI .OR. TF0->TF0_STATUS = '1' N
TF0_STATUS C 1 0 Status @! Pertence("123") .And. SGA750STAT() R 1=Ativo;2=Inativo N
TF0_ORIGEM C 3 0 Origem CMBVALMTR("TF0_ORIGEM") R TF0->TF0_STATUS = '1' N
TF0_DESORI C 20 0 Desc. Orig. @! SGAVALMTR("TF0_PROCED") V N
TF0_PROCED C 3 0 Procedencia. CMBVALMTR("TF0_PROCED") R TF0->TF0_STATUS = '1' N
TF0_DESPRO C 20 0 Desc. Proc. @! V N
TF0_CODTRA C 3 0 Tratamento SGAVALMTR("TF0_CODTRA") R TF0->TF0_STATUS = '1' N
TF0_DESTRA C 20 0 Desc. Trat. @! V N
TF0_CODTIP C 6 0 Cod. Tipo @! ExistCpo("TB7",M->TF0_CODRES+M->TF0_TIPO+M->TF0_CODTIP) R N
TF0_DESTIP C 30 0 Descricao @! V N
TF0_EMPGER C 2 0 Emp. Gerad. R N
TF0_FILGER C 2 0 Fil. Gerad. R N
TF0_LICGER C 12 0 Nr. Licenca @! ExistCpo("TA0",M->TF0_LICGER) TA0 R TF0->TF0_STATUS = '1' N
TF0_RESPEX C 10 0 Resp. Exped. 9999999999 ExistCpo("QAA",M->TF0_RESPEX) QAA R TF0->TF0_STATUS = '1' N
TF0_DTEGE D 8 0 Data Entrega R N
TF0_CDTRAN C 6 0 Transport. @! NaoVazio() .And. ExistCpo("SA4",M->TF0_CDTRAN) SA4 R TF0->TF0_STATUS = '1' N
TF0_NOMTRA C 40 0 Razao @! V N
TF0_RESPTR C 40 0 Resp. Transp @! R TF0->TF0_STATUS = '1' N
TF0_CODMOT C 6 0 Condutor @! NaoVazio() .And. ExistCpo("DA4",M->TF0_CODMOT) R N
TF0_DTRTRA D 8 0 Data Receb. R N
TF0_FORREC C 6 0 Documento Mo @! SGA750VAL() R N
TF0_LOJREC C 2 0 Loja @! R TF0->TF0_STATUS = '1' S
TF0_NOMREC C 40 0 Razao Social @! V N
TF0_ENDREC C 40 0 Morada/nš @! V N
TF0_CIDREC C 15 0 Concelho @! V N
TF0_ESTREC C 2 0 Distrito @! V N
TF0_TELREC C 18 0 Telefone @! V N
TF0_LICREC C 12 0 Nr. Licenca @! V N
TF0_RESPRE C 40 0 Resp. Receb. @! R TF0->TF0_STATUS = '1' N
TF0_CARGRR C 40 0 Cargo @! R TF0->TF0_STATUS = '1' N
TF0_DTEREC D 8 0 Data Entrega R N
TF0_CONPAG C 15 0 Cond. Pagto. PesqPict("SC5","C5_CONDPAG") ExistCpo("SE4") SE4 R TF0->TF0_STATUS = '1' N
TF0_TES C 15 0 Tipo Saida PesqPict("SC6","C6_TES") ExistCpo("SF4",M->TF0_TES) SF4 R TF0->TF0_STATUS = '1' N
TF0_NUM C 15 0 Nr. Pedido PesqPict("SC5","C5_NUM") R N
TF0_PREVEN N 15 2 Preco Venda @E 999,999,999,999.99 R TF0->TF0_STATUS = '1' N
TF0_DTALTE D 8 0 Data Alter. R N
TF0_HRALTE C 5 0 Hora Alter. 99:99 R N
TF0_TPDEST C 1 0 Tp. Destin. @! Pertence("12") .and. SGAVLTP750() R 1=Fornecedor;2=Cliente TF0->TF0_STATUS = "1" N
TF0_FORNNF C 6 0 Dest. Fact. @! SGADEST750() R TF0->TF0_STATUS = "1" N
TF0_LOJANF C 2 0 Loja. Dest. @! R TF0->TF0_STATUS = "1" N
TF0_NOMDES C 40 0 Razao Social @! V N
TF0_MENPAD C 15 0 Mens. Padrao @! Vazio().Or.ExistCpo("SM4") SM4 R TF0->TF0_STATUS = "1" N
TF0_ESPEC1 C 15 0 Especie 1 PesqPict("SC5","C5_ESPECI1") TF0->TF0_STATUS = "1" N
TF0_PESOL N 15 0 Peso Liquido @E 999,999,999,999,999 Positivo() .or. Vazio() TF0->TF0_STATUS = "1" N
TF0_PBRUTO N 15 0 Peso Bruto @E 999,999,999,999,999 Positivo() .or. Vazio() TF0->TF0_STATUS = "1" N
TF0_VOLUM1 N 5 0 Volume 1 @E 99,999 Positivo() .or. Vazio() TF0->TF0_STATUS = "1" N