Tabela |
SL2 |
Itens do Orcamento |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
L2_NUM |
C |
6 |
0 |
No Orcamento |
@! |
|
|
|
|
|
S |
L2_PRODUTO |
C |
15 |
0 |
Produto |
@! |
|
SL2 |
|
|
|
S |
L2_ITEM |
C |
2 |
0 |
Nš Item |
|
|
|
|
|
|
S |
L2_DESCRI |
C |
100 |
0 |
Descricao |
@! |
|
|
|
|
|
S |
L2_QUANT |
N |
7 |
2 |
Quantidade |
@E 9,999.99 |
|
|
|
|
|
S |
L2_VRUNIT |
N |
16 |
4 |
Preco Unit. |
@E 99,999,999,999.9999 |
|
|
|
|
|
S |
L2_VLRITEM |
N |
14 |
2 |
Vlr.Item |
@E 999,999,999.99 |
|
|
|
|
|
S |
L2_LOCAL |
C |
2 |
0 |
Armazem |
@! |
|
NNR |
|
|
|
S |
L2_UM |
C |
2 |
0 |
Unidade |
@! |
|
SAH |
|
|
|
S |
L2_DESC |
N |
5 |
2 |
Desconto |
@E 99.99 |
|
|
|
|
|
S |
L2_VALDESC |
N |
12 |
2 |
Valor Desc |
@E 999,999,999.99 |
|
|
|
|
|
S |
L2_TES |
C |
3 |
0 |
Tipo E/S |
|
|
SF4 |
|
|
|
S |
L2_CF |
C |
5 |
0 |
Cod. Fiscal |
@9 |
|
13 |
|
|
|
S |
L2_VENDIDO |
C |
1 |
0 |
Status |
|
|
|
|
|
|
S |
L2_DOC |
C |
9 |
0 |
Nota NF |
@! |
|
|
|
|
|
S |
L2_SERIE |
C |
3 |
0 |
Serie NF |
|
|
|
|
|
|
S |
L2_PDV |
C |
10 |
0 |
Numero PDV |
@! |
|
|
|
|
|
S |
L2_VALIPI |
N |
14 |
2 |
Valor do IPI |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
L2_VALICM |
N |
14 |
2 |
Valor de ICM |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
L2_VALISS |
N |
14 |
2 |
Valor do ISS |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
L2_BASEICM |
N |
14 |
2 |
Base ICMS |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
L2_TABELA |
C |
1 |
0 |
Tabela Preco |
@! |
|
|
|
|
|
S |
L2_STATUS |
C |
1 |
0 |
Status Troca |
@! |
|
|
|
|
|
S |
L2_EMISSAO |
D |
8 |
0 |
Dt Emissao |
|
|
|
|
|
|
S |
L2_DESCPRO |
N |
16 |
2 |
Desc.Proporc |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
L2_CUSTO1 |
N |
14 |
2 |
Custo 1 |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
L2_CUSTO2 |
N |
14 |
2 |
Custo 2 |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
L2_PRCTAB |
N |
14 |
2 |
Preco Tabela |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
L2_GRADE |
C |
1 |
0 |
Grade |
! |
|
|
|
|
|
N |
L2_PREMIO |
C |
1 |
0 |
Premio |
@! |
|
|
R |
|
|
S |
L2_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
L2_VEND |
C |
6 |
0 |
Vendedor |
@! |
|
SA3 |
|
|
|
S |
L2_LOTECTL |
C |
10 |
0 |
Lote |
|
|
SB8 |
|
|
|
S |
L2_NLOTE |
C |
6 |
0 |
Sub Lote |
@! |
|
|
|
|
|
S |
L2_LOCALIZ |
C |
15 |
0 |
Endereco |
@! |
|
SBE |
|
|
|
S |
L2_NSERIE |
C |
20 |
0 |
Numero Serie |
@! |
|
BF1 |
|
|
|
S |
L2_BCONTA |
C |
44 |
0 |
Cod.Barras |
@! |
|
|
|
|
|
S |
L2_SITUA |
C |
2 |
0 |
Situacao |
|
|
|
|
|
|
S |
L2_CODITE |
C |
27 |
0 |
Cod. Produto |
|
|
B00 |
V |
|
|
S |
L2_RESERVA |
C |
6 |
0 |
Num.Reserva |
|
|
SC0 |
|
|
|
S |
L2_LOJARES |
C |
6 |
0 |
Loja Reserv. |
|
|
|
|
|
|
S |
L2_PEDFAT |
C |
6 |
0 |
Num.Pedido |
|
|
|
|
|
|
S |
L2_VALFRE |
N |
14 |
2 |
Valor Frete |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
L2_SEGURO |
N |
14 |
2 |
Vlr.Seguro |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
L2_DESPESA |
N |
14 |
2 |
Vlr.Desp.Ac. |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
L2_NUMLAY |
C |
6 |
0 |
Num. LayAway |
@! |
|
|
V |
|
|
S |
L2_ITEMLAY |
C |
2 |
0 |
Item LayAway |
@! |
|
|
V |
|
|
S |
L2_EMPRES |
C |
2 |
0 |
Emp.Reserva |
|
|
|
|
|
|
S |
L2_FILRES |
C |
2 |
0 |
Fil.Reserva |
|
|
|
|
|
|
S |
L2_ORCRES |
C |
6 |
0 |
Orc.Reserva |
|
|
|
|
|
|
S |
L2_ICMSRET |
N |
14 |
2 |
ICMS Retido |
@E 999,999,999,999.99 |
|
|
|
|
|
S |
L2_ENTREGA |
C |
1 |
0 |
Entrega? |
@! |
|
|
R |
1=Retira Posterior;2=Retira;3=Entrega;4=Retira Posterior c/ Pedido |
|
S |
L2_BRICMS |
N |
14 |
2 |
Ret. ICMS |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
L2_VALPIS |
N |
14 |
2 |
Val.PIS |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_VALCOFI |
N |
14 |
2 |
Val.COFINS |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_VALCSLL |
N |
14 |
2 |
Val.CSLL |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_VALPS2 |
N |
14 |
2 |
Val.PIS |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_VALCF2 |
N |
14 |
2 |
Val.COFINS |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_BASEPS2 |
N |
14 |
2 |
Base do PIS |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_BASECF2 |
N |
14 |
2 |
Base COFINS |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_ALIQPS2 |
N |
14 |
2 |
Aliq.PIS |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_ALIQCF2 |
N |
14 |
2 |
Aliq.COFINS |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_ITEMSD1 |
C |
6 |
0 |
Item do SD1 |
|
|
|
|
|
|
S |
L2_DTVALID |
D |
8 |
0 |
Valid. Lote |
|
|
|
|
|
|
S |
L2_SEGUM |
C |
2 |
0 |
Segunda UM |
|
|
SAH |
|
|
|
S |
L2_PEDRES |
C |
6 |
0 |
Num. Pedido |
|
|
|
|
|
|
S |
L2_FDTENTR |
D |
8 |
0 |
Data Entrega |
|
|
|
R |
|
|
S |
L2_CODCONT |
C |
6 |
0 |
Contato |
|
|
|
R |
|
|
S |
L2_FDTMONT |
D |
8 |
0 |
Dt. Montagem |
|
|
|
R |
|
|
S |
L2_CODREG |
C |
6 |
0 |
Cod. R. Desc |
|
|
|
R |
|
|
S |
L2_VLDESRE |
N |
14 |
2 |
Per Desc Reg |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_TURNO |
C |
1 |
0 |
Turno |
|
|
|
|
|
|
S |
L2_NUMORIG |
C |
6 |
0 |
Orc.Original |
@! |
|
|
R |
|
|
S |
L2_SITTRIB |
C |
5 |
0 |
Aliquota |
|
|
|
|
|
|
S |
L2_VALEPRE |
C |
15 |
0 |
Vale Present |
|
|
MDD |
|
|
|
S |
L2_CODLAN |
C |
6 |
0 |
Cod. CAT83 |
@! |
|
|
|
|
|
S |
L2_VDMOST |
C |
1 |
0 |
Tipo de peca |
@! |
|
|
R |
N=Normal;M=Mostruario;S=Saldao |
|
S |
L2_VDOBS |
M |
10 |
0 |
Obs. Peca |
@! |
|
|
R |
|
|
S |
L2_MARCA |
C |
30 |
0 |
Marca |
|
|
|
|
|
|
S |
L2_DESCORC |
N |
15 |
2 |
Desc Orcamen |
@E 999,999,999,999.99 |
|
|
|
|
|
S |
L2_TIPO |
C |
3 |
0 |
Tipo |
|
|
|
|
|
|
S |
L2_MODELO |
C |
30 |
0 |
Modelo |
@! |
|
|
|
|
|
S |
L2_PEDSC5 |
C |
6 |
0 |
Nr. Ped.Vend |
@! |
|
|
R |
|
|
N |
L2_ESPECIE |
C |
30 |
0 |
Especie Prod |
@! |
|
|
|
|
|
S |
L2_QUALIDA |
C |
30 |
0 |
Qualidade |
@! |
|
|
|
|
|
S |
L2_ITESC6 |
C |
2 |
0 |
Item Pedido |
@! |
|
|
R |
|
|
N |
L2_SEQUEN |
C |
2 |
0 |
Sequencia |
@! |
|
|
R |
|
|
N |
L2_SOLCOM |
C |
6 |
0 |
No Sol.Compr |
@! |
|
|
R |
|
|
S |
L2_SERPDV |
C |
20 |
0 |
Serie ECF |
|
|
|
|
|
|
S |
L2_CONTDOC |
C |
9 |
0 |
CONTDOC |
@! |
|
|
|
|
|
S |
L2_PAFMD5 |
C |
32 |
0 |
MD5 |
|
|
|
|
|
|
S |
L2_CODLPRE |
C |
6 |
0 |
Lista Pres. |
@! |
|
|
R |
|
|
S |
L2_GARANT |
C |
15 |
0 |
Garantia |
@! |
|
|
R |
|
|
N |
L2_ITLPRE |
C |
3 |
0 |
Item L.Pres. |
@! |
|
|
R |
|
|
S |
L2_MSMLPRE |
C |
6 |
0 |
Cod. Msg |
@! |
|
|
R |
|
|
S |
L2_MSGLPRE |
M |
250 |
0 |
Mensagem |
@! |
|
|
V |
|
|
S |
L2_REMLPRE |
C |
6 |
0 |
Cod.Remet. |
@! |
|
|
R |
|
|
S |
L2_REVLPRE |
C |
30 |
0 |
Remetente |
@! |
|
|
V |
|
|
S |
L2_NUMCFID |
C |
40 |
0 |
Cart.Fidelid |
@! |
|
|
R |
|
|
N |
L2_MESREC |
N |
16 |
0 |
Recno MES |
@E 9,999,999,999,999,999 |
|
|
R |
|
|
S |
L2_DTSDFID |
D |
8 |
0 |
Valid. Rec. |
|
|
|
|
|
|
N |
L2_VLRCFID |
N |
16 |
2 |
Val.Recarga |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
N |
L2_PROCFID |
C |
1 |
0 |
Proc. Fid |
|
|
|
|
|
|
N |
L2_CODBAR |
C |
15 |
0 |
Cod Barras |
@! |
|
|
|
|
|
S |
L2_ORIGEM |
C |
1 |
0 |
Origem |
|
|
|
|
|
|
S |
L2_MODBC |
C |
1 |
0 |
Mod.BC |
|
|
|
|
|
|
S |
L2_CODISS |
C |
9 |
0 |
Cod.Serv.ISS |
@9 |
|
|
|
|
|
S |
L2_POSIPI |
C |
10 |
0 |
Pos.IPI/NCM |
@R 9999.99.99 |
|
|
|
|
|
S |
L2_LEGCOD |
C |
10 |
0 |
Codigo LEG |
|
|
|
|
|
|
S |
L2_ITEMNF |
C |
2 |
0 |
Num Item NF |
@! |
|
|
R |
|
|
S |
L2_VALACRS |
N |
14 |
2 |
Acre. Financ |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
L2_VLGAPRO |
N |
5 |
0 |
Vld Produto |
@E 99,999 |
|
|
R |
|
|
S |
L2_VLIMPOR |
N |
14 |
2 |
Vl.Import |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_FCICOD |
C |
36 |
0 |
Codigo FCI |
@! |
|
|
R |
|
|
S |
L2_CLASFIS |
C |
3 |
0 |
Sit. Tribut. |
@! |
|
|
R |
|
|
S |
L2_ECPRESN |
C |
1 |
0 |
Presente SN |
|
|
|
R |
|
|
S |
L2_ECSEDEX |
C |
13 |
0 |
Sedex EC |
|
|
|
R |
|
|
S |
L2_DOCPED |
C |
9 |
0 |
Nota Fiscal |
@! |
|
|
|
|
|
S |
L2_SERPED |
C |
3 |
0 |
Serie |
@! |
|
|
|
|
|
S |
L2_PEDPRS |
C |
6 |
0 |
Ped Presente |
|
|
|
R |
|
|
S |
L2_ECMSGPR |
M |
10 |
0 |
Msg Presente |
|
|
|
R |
|
|
S |
L2_CLIENT |
C |
6 |
0 |
Cli Entrega |
@! |
|
|
R |
|
|
S |
L2_CLILOJA |
C |
2 |
0 |
Loja Entrega |
@! |
|
|
R |
|
|
S |
L2_BLEST |
C |
2 |
0 |
Bloq Estoque |
@! |
|
|
|
|
|
S |
L2_VLTROCA |
C |
1 |
0 |
Vale Troca? |
|
|
|
R |
|
|
S |
L2_INDPAR |
C |
6 |
0 |
Parceiro |
|
|
|
|
|
|
S |
L2_DTUMOV |
D |
8 |
0 |
Data uMov.me |
|
|
|
R |
|
|
N |
L2_HRUMOV |
C |
8 |
0 |
Hora uMov.me |
99:99:99 |
|
|
R |
|
|
N |
L2_REV |
N |
2 |
0 |
Rev.Montagem |
99 |
|
|
R |
|
|
N |
L2_FLUMOV |
C |
1 |
0 |
Flag uMov.me |
|
|
|
|
|
|
S |
L2_QTDEDEV |
N |
11 |
0 |
Qtd. Devolv. |
@E 99,999,999,999 |
|
|
R |
|
|
S |
L2_ITEMGAR |
C |
2 |
0 |
Item Gar Est |
|
|
|
R |
|
|
S |
L2_GARDEV |
D |
8 |
0 |
Data Dev Gar |
|
|
|
R |
|
|
S |
L2_TOTIMP |
N |
14 |
2 |
Tot. de Imp. |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
L2_ITEMCOB |
C |
2 |
0 |
Item Cobertu |
|
|
|
R |
|
|
S |
L2_PRDCOBE |
C |
15 |
0 |
Produto Cob. |
@! |
|
|
R |
|
|
S |
L2_TOTFED |
N |
14 |
2 |
Crg.Trb.Fed. |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_PREDIC |
N |
5 |
2 |
%Red.do ICMs |
@E 99.99 |
|
|
R |
|
|
S |
L2_CEST |
C |
9 |
0 |
CEST |
@! |
|
|
R |
|
|
S |
L2_TOTEST |
N |
14 |
2 |
Crg.Trb.Est. |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_SDOCPED |
C |
3 |
0 |
Serie |
!!! |
|
|
R |
|
|
S |
L2_TOTMUN |
N |
14 |
2 |
Crg.Trb.Mun |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_SDOC |
C |
3 |
0 |
Serie Doc. |
!!! |
|
|
R |
|
|
S |
L2_CNAE |
C |
9 |
0 |
CNAE |
@! |
|
|
|
|
|
S |
L2_ALQFECP |
N |
5 |
2 |
Aliq. FECP |
@E 99.99 |
|
|
|
|
|
S |
L2_BASEISS |
N |
14 |
2 |
Base de ISS |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_VALFECP |
N |
14 |
2 |
Valor FECP |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_ALIQISS |
N |
5 |
2 |
Aliq. ISS |
@E 99.99 |
|
|
R |
|
|
S |
L2_ECVALOR |
N |
12 |
2 |
EC Vlr Item |
@E 999,999,999.99 |
|
|
R |
|
|
S |
L2_KIT |
C |
15 |
0 |
Kit Prod |
|
|
|
|
|
|
S |
L2_ITEMCC |
C |
9 |
0 |
Item Conta |
@! |
|
|
R |
|
|
S |
L2_ALIQCOF |
N |
5 |
2 |
Aliq. Cofins |
@E 99.99 |
|
|
R |
|
|
S |
L2_CCUSTO |
C |
9 |
0 |
Centro Custo |
@! |
|
|
R |
|
|
S |
L2_DESCICM |
N |
14 |
2 |
Desc.Icms |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_DECQTD |
N |
1 |
0 |
Dec. Qtde |
9 |
|
|
|
|
|
S |
L2_IAT |
C |
1 |
0 |
Trunc ou Arr |
|
|
|
R |
A=Arredondamento;T=Truncamento |
|
S |
L2_IPPT |
C |
1 |
0 |
Prop ou Terc |
|
|
|
R |
P=Propria;T=Terceiros |
|
S |
L2_DECVLU |
N |
1 |
0 |
Dec.Vl.Unt. |
9 |
|
|
|
|
|
S |
L2_BASIRRF |
N |
14 |
2 |
Base de IRRF |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_BASECOF |
N |
14 |
2 |
Base Confins |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_ALIQPIS |
N |
5 |
2 |
Aliq. Pis |
@E 99.99 |
|
|
R |
|
|
S |
L2_ALQCSLL |
N |
5 |
2 |
Aliq. CSLL |
@E 99.99 |
|
|
R |
|
|
S |
L2_PICM |
N |
5 |
2 |
Aliq. ICMS |
@E 99.99 |
|
|
R |
|
|
S |
L2_VALIRRF |
N |
14 |
2 |
Valor IRRF |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_BASEPIS |
N |
14 |
2 |
Base Pis |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_ALQIRRF |
N |
5 |
2 |
Aliq. IRRF |
@E 99.99 |
|
|
R |
|
|
S |
L2_BASCSLL |
N |
14 |
2 |
Base de CSLL |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_CLVL |
C |
9 |
0 |
Classe Valor |
@! |
|
|
R |
|
|
S |
L2_MOTDICM |
C |
1 |
0 |
Mot.Desone |
@! |
|
|
R |
|
|
S |
L2_ALQFCST |
N |
5 |
2 |
Aliq FECP ST |
@E 99.99 |
|
|
R |
|
|
S |
L2_VFECPST |
N |
14 |
2 |
Vlr. FECP ST |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
L2_IDITREL |
C |
3 |
0 |
ID Item rela |
@! |
|
|
|
|
|
S |
L2_BASFECP |
N |
14 |
2 |
Base FECP |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_CSTCOF |
C |
2 |
0 |
CST COF |
@! |
|
|
|
|
|
S |
L2_BASEIPI |
N |
14 |
2 |
Vlr.Base IPI |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_IPI |
N |
5 |
2 |
Aliq. IPI |
@E 99.99 |
|
|
R |
|
|
S |
L2_CSTPIS |
C |
2 |
0 |
CST Pis |
@! |
|
|
|
|
|
S |
L2_BSFCPST |
N |
14 |
2 |
Base FECP ST |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
L2_ALIQSOL |
N |
6 |
2 |
Alq ICMS Sol |
@E 999.99 |
|
|
R |
|
|
S |