| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| DBC | Itens das Invoices | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| DBC_FILIAL | C | 2 | 0 | Filial | N | ||||||
| DBC_ITEM | C | 4 | 0 | Item | @! | N | |||||
| DBC_CODPRO | C | 15 | 0 | Produto | @! | Vazio().or.(A143Produto(M->DBC_CODPRO).and.MaFisRef("IT_PRODUTO","MT120",M->DBC_CODPRO)) | SB1 | N | |||
| DBC_DESCRI | C | 30 | 0 | Descricao | @! | N | |||||
| DBC_UM | C | 2 | 0 | Unidade | ExistCpo("SAH") | SAH | N | ||||
| DBC_SEGUM | C | 2 | 0 | Segunda UM | @! | ExistCpo("SAH") | SAH | N | |||
| DBC_QUANT | N | 12 | 2 | Quantidade | @E 999999999.99 | Positivo().And.A143Quant(M->DBC_QUANT).And.MaFisRef("IT_QUANT","MT120",M->DBC_QUANT) | N | ||||
| DBC_PRECO | N | 14 | 2 | Prc Unitario | @E 999,999,999.99 | Positivo().and.A143Preco(M->DBC_PRECO).And.MaFisRef("IT_PRCUNI","MT120",M->DBC_PRECO) | N | ||||
| DBC_TOTAL | N | 14 | 2 | Vlr.Total | @E 999,999,999.99 | A143Total(M->DBC_TOTAL).And.MaFisRef("IT_VALMERC","MT120",M->DBC_TOTAL) | N | ||||
| DBC_QTSEGU | N | 11 | 2 | Qtd. 2a UM | @E 99999999.99 | (Positivo().or.Vazio()).and.A143Segum() | N | ||||
| DBC_LOCAL | C | 2 | 0 | Armazem | @! | N | |||||
| DBC_DATPRF | D | 8 | 0 | Dt. Entrega | N | ||||||
| DBC_PEDIDO | C | 6 | 0 | Numero P.O. | @! | N | |||||
| DBC_ITEMPC | C | 4 | 0 | Item P.O. | @! | N | |||||
| DBC_TES | C | 3 | 0 | Tipo Entrada | @! | (Vazio().Or.ExistCpo("SF4")) .And. (MaAvalTes("E",M->DBC_TES).And.MaFisRef("IT_TES","MT120",M->DBC_TES)) | SF4 | N | |||
| DBC_VALFRE | N | 14 | 2 | Vlr.Frete | @E 999,999,999.99 | Positivo().And.MaFisRef("IT_FRETE","MT120",M->DBC_VALFRE) | N | ||||
| DBC_DESPES | N | 14 | 2 | Vlr.Despesas | @E 999,999,999.99 | Positivo().And.MaFisRef("IT_DESPESA","MT120",M->DBC_DESPESA) | N | ||||
| DBC_SEGURO | N | 14 | 2 | Vlr.Seguro | @E 999,999,999.99 | Positivo().And.MaFisRef("IT_SEGURO","MT120",M->DBC_SEGURO) | N | ||||
| DBC_VALEMB | N | 16 | 2 | Vlr Embalag. | @E 999,999,999.99 | Positivo().And.MaFisRef("IT_VALEMB","MT120",M->DBC_VALEMB) | N | ||||
| DBC_VLDESC | N | 14 | 2 | Vl. Desconto | @E 999,999,999.99 | Positivo().And.MaFisRef("IT_DESCONTO","MT120",M->DBC_VLDESC) | N | ||||
| DBC_CC | C | 9 | 0 | Centro Custo | @! | Vazio() .Or. Ctb105CC() | CTT | N | |||
| DBC_CONTA | C | 20 | 0 | Cta Contabil | @! | Vazio() .Or. Ctb105Cta() | CT1 | N | |||
| DBC_ITCTA | C | 9 | 0 | Item Conta | @! | Vazio() .Or. Ctb105Item() | CTD | N | |||
| DBC_CLVL | C | 9 | 0 | Classe Valor | @! | Vazio() .Or. Ctb105CLVL() | CTH | CtbInUse() | N | ||
| DBC_HAWB | C | 17 | 0 | Processo | @! | N | |||||
| DBC_ITDOC | C | 3 | 0 | Item Docto. | 999 | .F. | N | ||||
| DBC_BSIMP1 | N | 14 | 2 | Base Imp. 1 | @E 99,999,999,999.99 | MaFisRef("IT_BASEIV1","MT120",M->DBC_BSIMP1) | S | ||||
| DBC_ALIMP1 | N | 6 | 2 | Aliq. Imp. 1 | @E 999.99 | MaFisRef("IT_ALIQIV1","MT120",M->DBC_ALIMP1) | S | ||||
| DBC_VLIMP1 | N | 14 | 2 | Valor Imp. 1 | @E 99,999,999,999.99 | MaFisRef("IT_VALIV1","MT120",M->DBC_VLIMP1) | S | ||||
| DBC_BSIMP2 | N | 14 | 2 | Base Imp. 2 | @E 99,999,999,999.99 | MaFisRef("IT_BASEIV2","MT120",M->DBC_BSIMP2) | S | ||||
| DBC_ALIMP2 | N | 6 | 2 | Aliq. Imp. 2 | @E 999.99 | MaFisRef("IT_ALIQIV2","MT120",M->DBC_ALIMP2) | S | ||||
| DBC_VLIMP2 | N | 14 | 2 | Valor Imp. 2 | @E 99,999,999,999.99 | MaFisRef("IT_VALIV2","MT120",M->DBC_VLIMP2) | S | ||||
| DBC_BSIMP3 | N | 14 | 2 | Base Imp. 3 | @E 99,999,999,999.99 | MaFisRef("IT_BASEIV3","MT120",M->DBC_BSIMP3) | S | ||||
| DBC_ALIMP3 | N | 6 | 2 | Aliq. Imp. 3 | @E 999.99 | MaFisRef("IT_ALIQIV3","MT120",M->DBC_ALIMP3) | S | ||||
| DBC_VLIMP3 | N | 14 | 2 | Valor Imp. 3 | @E 99,999,999,999.99 | MaFisRef("IT_VALIV3","MT120",M->DBC_VLIMP3) | S | ||||
| DBC_BSIMP4 | N | 14 | 2 | Base Imp. 4 | @E 99,999,999,999.99 | MaFisRef("IT_BASEIV4","MT120",M->DBC_BSIMP4) | S | ||||
| DBC_ALIMP4 | N | 6 | 2 | Aliq. Imp. 4 | @E 999.99 | MaFisRef("IT_ALIQIV4","MT120",M->DBC_ALIMP4) | S | ||||
| DBC_VLIMP4 | N | 14 | 2 | Valor Imp. 4 | @E 99,999,999,999.99 | MaFisRef("IT_VALIV4","MT120",M->DBC_VLIMP4) | S | ||||
| DBC_BSIMP5 | N | 14 | 2 | Base Imp. 5 | @E 99,999,999,999.99 | MaFisRef("IT_BASEIV5","MT120",M->DBC_BSIMP5) | S | ||||
| DBC_ALIMP5 | N | 6 | 2 | Aliq. Imp. 5 | @E 999.99 | MaFisRef("IT_ALIQIV5","MT120",M->DBC_ALIMP5) | S | ||||
| DBC_VLIMP5 | N | 14 | 2 | Valor Imp. 5 | @E 99,999,999,999.99 | MaFisRef("IT_VALIV5","MT120",M->DBC_VLIMP5) | S | ||||
| DBC_BSIMP6 | N | 14 | 2 | Base Imp. 6 | @E 99,999,999,999.99 | MaFisRef("IT_BASEIV6","MT120",M->DBC_BSIMP6) | S | ||||
| DBC_ALIMP6 | N | 6 | 2 | Aliq. Imp. 6 | @E 999.99 | MaFisRef("IT_ALIQIV6","MT120",M->DBC_ALIMP6) | S | ||||
| DBC_VLIMP6 | N | 14 | 2 | Valor Imp. 6 | @E 99,999,999,999.99 | MaFisRef("IT_VALIV6","MT120",M->DBC_VLIMP6) | S | ||||
| DBC_BSIMP7 | N | 14 | 2 | Base Imp. 7 | @E 99,999,999,999.99 | MaFisRef("IT_BASEIV7","MT120",M->DBC_BSIMP7) | S | ||||
| DBC_ALIMP7 | N | 6 | 2 | Aliq. Imp. 7 | @E 999.99 | MaFisRef("IT_ALIQIV7","MT120",M->DBC_ALIMP7) | S | ||||
| DBC_VLIMP7 | N | 14 | 2 | Valor Imp. 7 | @E 99,999,999,999.99 | MaFisRef("IT_VALIV7","MT120",M->DBC_VLIMP7) | S | ||||
| DBC_BSIMP8 | N | 14 | 2 | Base Imp. 8 | @E 99,999,999,999.99 | MaFisRef("IT_BASEIV8","MT120",M->DBC_BSIMP8) | S | ||||
| DBC_ALIMP8 | N | 6 | 2 | Aliq. Imp. 8 | @E 999.99 | MaFisRef("IT_ALIQIV8","MT120",M->DBC_ALIMP8) | S | ||||
| DBC_VLIMP8 | N | 14 | 2 | Valor Imp. 8 | @E 99,999,999,999.99 | MaFisRef("IT_VALIV8","MT120",M->DBC_VLIMP8) | S | ||||
| DBC_BSIMP9 | N | 14 | 2 | Base Imp. 9 | @E 99,999,999,999.99 | MaFisRef("IT_BASEIV9","MT120",M->DBC_BSIMP9) | S | ||||
| DBC_ALIMP9 | N | 6 | 2 | Aliq. Imp. 9 | @E 999.99 | MaFisRef("IT_ALIQIV9","MT120",M->DBC_ALIMP9) | S | ||||
| DBC_VLIMP9 | N | 14 | 2 | Valor Imp. 9 | @E 99,999,999,999.99 | MaFisRef("IT_VALIV9","MT120",M->DBC_VLIMP9) | S | ||||
| DBC_TEC | C | 10 | 0 | Pos.IPI/NCM | @R 9999.99.99 | R | N | ||||
| DBC_EX_NCM | C | 3 | 0 | Ex-NCM | @R 999 | R | N | ||||
| DBC_EX_NBM | C | 3 | 0 | Ex-NBM | @! | R | N | ||||