Tabela |
SLR |
Itens do Orcamento |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
LR_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
LR_NUM |
C |
6 |
0 |
No Orcamento |
@! |
|
|
|
|
|
S |
LR_ITEM |
C |
2 |
0 |
Item |
|
|
|
|
|
|
S |
LR_PRODUTO |
C |
15 |
0 |
Produto |
@! |
IF( nModulo == 12,Lj7Prod(.T.,,.T.), .T.) |
SB1LIK |
|
|
|
S |
LR_DESCRI |
C |
100 |
0 |
Descricao |
@! |
|
|
|
|
|
S |
LR_QUANT |
N |
7 |
2 |
Quantidade |
@E 9,999.99 |
Lj7VlItem( 1 ) |
|
|
|
|
S |
LR_VRUNIT |
N |
16 |
4 |
Preco Unit. |
@E 99,999,999,999.9999 |
IF( nModulo == 12,Lj7VlItem(2), .T.) |
|
|
|
|
S |
LR_VLRITEM |
N |
14 |
2 |
Vlr.Item |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
LR_LOCAL |
C |
2 |
0 |
Armazem |
@! |
ExistCpo("NNR") |
NNR |
|
|
|
S |
LR_UM |
C |
2 |
0 |
Unidade |
@! |
ExistCpo("SAH") |
SAH |
|
|
|
S |
LR_DESC |
N |
5 |
2 |
Desconto |
@E 99.99 |
LjNDesGE() .AND. Positivo() .AND. Lj7VlItem( 3 ) |
|
|
|
|
S |
LR_VALDESC |
N |
12 |
2 |
Valor Desc |
@E 999,999,999.99 |
LjNDesGE() .AND. Positivo() .AND. Lj7VlItem( 4 ) |
|
|
|
|
S |
LR_TES |
C |
3 |
0 |
Tipo E/S |
|
NaoVazio() .AND. Existcpo("SF4") .AND. M->LR_TES>"500" .AND. IIF(nModulo <> 5, LJ7ALTCF(),LJ7ALTCF() .AND. LJ7VlItem()) |
SF4 |
|
|
|
S |
LR_CF |
C |
5 |
0 |
Cod. Fiscal |
@9 |
|
13 |
|
|
|
S |
LR_VENDIDO |
C |
1 |
0 |
Status |
|
|
|
|
|
|
S |
LR_DOC |
C |
9 |
0 |
Nota NF |
@! |
|
|
|
|
|
S |
LR_SEGUM |
C |
2 |
0 |
Seg.Un.Medi. |
|
ExistCpo("SAH") |
SAH |
|
|
|
S |
LR_SERIE |
C |
3 |
0 |
Serie NF |
|
Lj7VLRSERIE() |
|
|
|
|
S |
LR_PDV |
C |
10 |
0 |
Numero PDV |
@! |
|
|
|
|
|
S |
LR_VALIPI |
N |
14 |
2 |
Valor do IPI |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
LR_VALICM |
N |
14 |
2 |
Valor de ICM |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
LR_VALISS |
N |
14 |
2 |
Valor do ISS |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
LR_BASEICM |
N |
14 |
2 |
Base ICMS |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
LR_TABELA |
C |
1 |
0 |
Tabela Preco |
@! |
|
|
|
|
|
S |
LR_STATUS |
C |
1 |
0 |
Status Troca |
@! |
|
|
|
|
|
S |
LR_EMISSAO |
D |
8 |
0 |
Dt Emissao |
|
|
|
|
|
|
S |
LR_DESCPRO |
N |
16 |
4 |
Desc.Proporc |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
LR_CUSTO1 |
N |
14 |
2 |
Custo 1 |
@E 99,999,999.999,99 |
|
|
|
|
|
S |
LR_CUSTO2 |
N |
14 |
2 |
Custo 2 |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
LR_PRCTAB |
N |
16 |
4 |
Preco Tabela |
@E 99,999,999,999.9999 |
|
|
|
|
|
S |
LR_GRADE |
C |
1 |
0 |
Grade |
! |
|
|
|
|
|
N |
LR_VEND |
C |
6 |
0 |
Vendedor |
@! |
Vazio() .OR. (ExistCpo("SA3") .AND. LJ7VldUs() .AND. LJ7VldVen(M->LR_VEND) ) |
SA3LJ |
|
|
|
S |
LR_LOTECTL |
C |
10 |
0 |
Lote |
|
Lj7Lote() |
SB8 |
|
|
|
S |
LR_NLOTE |
C |
6 |
0 |
Sub Lote |
@! |
|
|
|
|
|
S |
LR_LOCALIZ |
C |
15 |
0 |
Endereco |
@! |
Lj7SaldoBF() |
SBE |
|
|
|
S |
LR_NSERIE |
C |
20 |
0 |
Numero Serie |
@! |
Lj7Serial() .And. Lj7VL2SERIE() |
BF1 |
|
|
|
S |
LR_BCONTA |
C |
44 |
0 |
Cod.Barras |
@! |
|
|
|
|
|
S |
LR_SITUA |
C |
2 |
0 |
Situacao |
|
|
|
|
|
|
S |
LR_CODGRP |
C |
4 |
0 |
Grupo |
@!!!! |
VldAuxCod1("L2_CODGRP","L2_CODITE") |
SBM |
V |
|
|
S |
LR_CODITE |
C |
27 |
0 |
Cod. Produto |
|
|
B00 |
V |
|
|
S |
LR_RESERVA |
C |
6 |
0 |
Num.Reserva |
|
|
SC0 |
|
|
|
S |
LR_LOJARES |
C |
6 |
0 |
Loja Reserv. |
|
|
|
|
|
|
S |
LR_PEDFAT |
C |
6 |
0 |
Num.Pedido |
|
|
|
|
|
|
S |
LR_VALFRE |
N |
14 |
2 |
Valor Frete |
@E 999,999,999.99 |
|
|
|
|
|
S |
LR_SEGURO |
N |
14 |
2 |
Vlr.Seguro |
@E 999,999,999.99 |
|
|
|
|
|
S |
LR_DESPESA |
N |
14 |
2 |
Vlr.Desp.Ac. |
@E 999,999,999.99 |
|
|
|
|
|
S |
LR_NUMLAY |
C |
6 |
0 |
Num. LayAway |
@! |
|
|
V |
|
|
S |
LR_ITEMLAY |
C |
2 |
0 |
Item LayAway |
@! |
|
|
V |
|
|
S |
LR_EMPRES |
C |
2 |
0 |
Emp.Reserva |
|
|
|
|
|
|
S |
LR_FILRES |
C |
2 |
0 |
Fil.Reserva |
|
|
|
|
|
|
S |
LR_ORCRES |
C |
6 |
0 |
Orc.Reserva |
|
|
|
|
|
|
S |
LR_PREMIO |
C |
1 |
0 |
Premio |
@! |
|
|
R |
|
|
S |
LR_ICMSRET |
N |
14 |
2 |
ICMS Ret |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
LR_ENTREGA |
C |
1 |
0 |
Entrega? |
@! |
Pertence("1234") |
|
R |
1=Retira Posterior;2=Retira;3=Entrega;4=Retira Posterior c/ Pedido |
|
S |
LR_BRICMS |
N |
14 |
2 |
Ret. ICMS |
@E 999,999,999,999.99 |
|
|
R |
|
|
S |
LR_VALPIS |
N |
14 |
2 |
Val.PIS |
@E 999,999,999.99 |
|
|
R |
|
|
S |
LR_VALCOFI |
N |
14 |
2 |
Val.COFINS |
@E 999,999,999.99 |
|
|
R |
|
|
S |
LR_VALCSLL |
N |
14 |
2 |
Val.CSLL |
@E 999,999,999.99 |
|
|
R |
|
|
S |
LR_VALPS2 |
N |
14 |
2 |
Val.PIS |
@E 999,999,999.99 |
|
|
R |
|
|
S |
LR_VALCF2 |
N |
14 |
2 |
Val.COFINS |
@E 999,999,999.99 |
|
|
R |
|
|
S |
LR_BASEPS2 |
N |
14 |
2 |
Base PIS |
@E 999,999,999.99 |
|
|
R |
|
|
S |
LR_BASECF2 |
N |
14 |
2 |
Base COFINS |
|
|
|
R |
|
|
S |
LR_ALIQPS2 |
N |
14 |
2 |
Aliq.PIS |
@E 999,999,999.99 |
|
|
R |
|
|
S |
LR_ALIQCF2 |
N |
14 |
2 |
Aliq.COFINS |
@E 999,999,999.99 |
|
|
R |
|
|
S |
LR_ITEMSD1 |
C |
6 |
0 |
Item do SD1 |
|
|
|
|
|
|
S |
LR_DTVALID |
D |
8 |
0 |
Valid. Lote |
|
|
|
|
|
|
S |
LR_PEDRES |
C |
6 |
0 |
Num. Pedido |
|
|
|
|
|
|
S |
LR_FDTENTR |
D |
8 |
0 |
Data Entrega |
|
Lj7VLRENTR() |
|
R |
|
|
S |
LR_CODCONT |
C |
6 |
0 |
Contato |
|
|
CNTLJ |
R |
|
|
S |
LR_FDTMONT |
D |
8 |
0 |
Dt. Montagem |
|
Lj7VLRMONT() |
|
R |
|
|
S |
LR_CODREG |
C |
6 |
0 |
Cod. R. Desc |
|
|
|
R |
|
|
S |
LR_VLDESRE |
N |
14 |
2 |
Per Desc Reg |
|
|
|
R |
|
|
S |
LR_TURNO |
C |
1 |
0 |
Turno |
|
|
|
|
|
|
S |
LR_NUMORIG |
C |
6 |
0 |
Orc.Original |
@! |
|
|
R |
|
|
S |
LR_SITTRIB |
C |
5 |
0 |
Aliquota |
|
|
|
|
|
|
S |
LR_VALEPRE |
C |
15 |
0 |
Vale Present |
|
ExistCpo('MDD',M->LR_VALEPRE) |
MDD |
|
|
|
S |
LR_CODLAN |
C |
6 |
0 |
Cod. CAT83 |
|
ExistCpo('CDZ') |
|
|
|
|
S |
LR_VDMOST |
C |
1 |
0 |
Tipo de Peca |
@! |
Pertence("NMS") .AND. LjVldNDesc() |
|
R |
N=Normal;M=Mostruario;S=Saldao |
|
S |
LR_VDOBS |
M |
10 |
0 |
Obs. Peca |
@! |
|
|
R |
|
|
S |
LR_DESCORC |
N |
15 |
2 |
Desc Orcamen |
@E 999,999,999.99 |
|
|
|
|
|
S |
LR_MARCA |
C |
30 |
0 |
Marca |
|
|
|
|
|
|
S |
LR_TIPO |
C |
3 |
0 |
Tipo |
|
|
|
|
|
|
S |
LR_MODELO |
C |
30 |
0 |
Modelo |
|
|
|
|
|
|
S |
LR_ESPECIE |
C |
30 |
0 |
Especie Prod |
|
|
|
|
|
|
S |
LR_QUALIDA |
C |
30 |
0 |
Qualidade |
|
|
|
|
|
|
S |
LR_ALQIMP2 |
N |
6 |
2 |
Alq.Imp.2 |
@E 999.99 |
MAFISREF("IT_ALIQIV2","MT100",M->L2_ALQIMP2) |
|
|
|
|
S |
LR_PEDSC5 |
C |
6 |
0 |
Num Ped Vend |
|
|
|
R |
|
|
N |
LR_ITESC6 |
C |
2 |
0 |
Item Pedido |
@! |
|
|
R |
|
|
N |
LR_SEQUEN |
C |
2 |
0 |
Sequencia |
@! |
|
|
R |
|
|
N |
LR_CODLPRE |
C |
6 |
0 |
Lista Pres. |
@! |
|
|
R |
|
|
S |
LR_SOLCOM |
C |
6 |
0 |
No Sol.Compr |
@! |
|
|
R |
|
|
S |
LR_GARANT |
C |
15 |
0 |
Garantia |
@! |
|
|
|
|
|
N |
LR_ITLPRE |
C |
3 |
0 |
Item L.Pres. |
@! |
|
|
R |
|
|
S |
LR_MSMLPRE |
C |
6 |
0 |
Cod. Msg. |
@! |
|
|
R |
|
|
S |
LR_MSGLPRE |
M |
250 |
0 |
Mensagem |
@! |
|
|
V |
|
|
S |
LR_REMLPRE |
C |
6 |
0 |
Cod.Remet. |
@! |
|
|
R |
|
|
S |
LR_REVLPRE |
C |
30 |
0 |
Remetente |
@! |
|
|
V |
|
|
S |
LR_NUMCFID |
C |
40 |
0 |
Cart.Fidelid |
@! |
|
|
|
|
|
N |
LR_MESREC |
N |
16 |
0 |
Recno MES |
@E 9,999,999,999,999,999 |
|
|
R |
|
|
S |
LR_DTSDFID |
D |
8 |
0 |
Valid. Rec. |
|
|
|
|
|
|
N |
LR_VLRCFID |
N |
14 |
2 |
Val.Recarga |
@E 99,999,999,999.99 |
Positivo() |
|
|
|
|
N |
LR_PROCFID |
C |
1 |
0 |
Proc. Fid |
|
Pertence("WB") |
|
|
|
|
N |
LR_LEGCOD |
C |
10 |
0 |
Codigo LEG |
|
|
|
|
|
|
S |
LR_ITEMNF |
C |
2 |
0 |
Num Item NF |
@! |
|
|
R |
|
|
S |
LR_VALACRS |
N |
14 |
2 |
Acre. Financ |
@E 99,999,999,999.99 |
Positivo() |
|
|
|
|
S |
LR_CODBAR |
C |
15 |
0 |
Cod Barras |
@! |
|
|
|
|
|
S |
LR_ORIGEM |
C |
1 |
0 |
Origem |
|
|
|
|
|
|
S |
LR_MODBC |
C |
1 |
0 |
Mod.BC |
|
|
|
|
|
|
S |
LR_CODISS |
C |
9 |
0 |
Cod.Serv.ISS |
|
|
|
|
|
|
S |
LR_POSIPI |
C |
10 |
0 |
Pos.IPI/NCM |
@R 9999.99.99 |
|
|
|
|
|
S |
LR_VLGAPRO |
N |
5 |
0 |
Vld Produto |
@E 99,999 |
|
|
R |
|
|
S |
LR_PAFMD5 |
C |
32 |
0 |
MD5 |
|
|
|
|
|
|
S |
LR_VLIMPOR |
N |
14 |
2 |
Vl.Import |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
LR_FCICOD |
C |
36 |
0 |
Codigo FCI |
@! |
|
|
R |
|
|
S |
LR_CONTDOC |
C |
9 |
0 |
CONTDOC |
|
|
|
|
|
|
S |
LR_SERPDV |
C |
20 |
0 |
Serie ECF |
|
|
|
|
|
|
S |
LR_CLASFIS |
C |
3 |
0 |
Sit. Tribut. |
@! |
|
|
R |
|
|
S |
LR_ECPRESN |
C |
1 |
0 |
Present SN |
|
|
|
R |
|
|
S |
LR_ECSEDEX |
C |
13 |
0 |
Sedex EC |
|
|
|
|
|
|
S |
LR_DOCPED |
C |
9 |
0 |
Nota Fiscal |
@! |
|
|
|
|
|
S |
LR_SERPED |
C |
3 |
0 |
Serie |
!!! |
|
|
|
|
|
S |
LR_PEDPRS |
C |
6 |
0 |
Ped Presente |
|
|
|
R |
|
|
S |
LR_ECMSGPR |
M |
10 |
0 |
Msg Presente |
|
|
|
R |
|
|
S |
LR_CLIENT |
C |
6 |
0 |
Cli Entrega |
@! |
ExistCpo("SA1", M->LR_CLIENT) .AND. Lj7ValCli() |
SA1 |
R |
|
|
S |
LR_CLILOJA |
C |
2 |
0 |
Loja Entrega |
@! |
|
|
R |
|
|
S |
LR_VLTROCA |
C |
1 |
0 |
Vale Troca? |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
!SuperGetMV( "MV_VLTROCA",,.F. ) |
S |
LR_INDPAR |
C |
6 |
0 |
Parceiro |
|
Vazio() .OR. (ExistCpo("SA3") .AND. LJ7VldPar(M->LR_INDPAR) ) |
SA3PAR |
|
|
|
S |
LR_TOTIMP |
N |
14 |
2 |
Tot. de Imp. |
@E 99,999,999,999.99 |
|
|
|
|
|
S |
LR_DTUMOV |
D |
8 |
0 |
Data uMov.me |
|
|
|
R |
|
|
N |
LR_HRUMOV |
C |
5 |
0 |
Hora uMov.me |
99:99 |
|
|
R |
|
|
N |
LR_REV |
N |
2 |
0 |
Rev.Montagem |
99 |
|
|
R |
|
|
N |
LR_FLUMOV |
C |
1 |
0 |
Flag uMov.me |
|
|
|
|
|
|
S |
LR_BLEST |
C |
2 |
0 |
Bloq Estoque |
@! |
|
|
|
|
|
S |
LR_GARDEV |
D |
8 |
0 |
Data Dev Gar |
|
|
|
R |
|
|
S |
LR_QTDEDEV |
N |
11 |
0 |
Qtd. Devolv. |
@E 99,999,999,999 |
|
|
R |
|
|
S |
LR_ITEMGAR |
C |
2 |
0 |
Item Gar Est |
|
|
|
R |
|
|
S |
LR_ITEMCOB |
C |
1 |
0 |
Item Cobertu |
@! |
|
|
R |
|
|
S |
LR_PRDCOBE |
C |
15 |
0 |
Produto Cob. |
|
|
|
R |
|
|
S |
LR_PREDIC |
N |
5 |
2 |
%Red.do ICMS |
@E 99.99 |
|
|
R |
|
|
S |
LR_CEST |
C |
9 |
0 |
CEST |
@! |
|
|
R |
|
|
S |
LR_TOTEST |
N |
14 |
2 |
Crg.Trb.Est. |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
LR_SDOC |
C |
3 |
0 |
Serie Doc. |
!!! |
|
|
R |
|
|
S |
LR_TOTFED |
N |
14 |
2 |
Crg.Trb.Fed. |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
LR_TOTMUN |
N |
14 |
2 |
Crg.Trb.Mun |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
LR_SDOCPED |
C |
3 |
0 |
Serie |
!!! |
|
|
R |
|
|
S |
LR_ALQFECP |
N |
5 |
2 |
Aliq. FECP |
@E 99.99 |
|
|
|
|
|
S |
LR_ALIQISS |
N |
5 |
2 |
Aliq. ISS |
@E 99.99 |
|
|
R |
|
|
S |
LR_CNAE |
C |
9 |
0 |
CNAE |
@! |
|
|
R |
|
|
S |
LR_BASEISS |
N |
14 |
2 |
Base de ISS |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
LR_KIT |
C |
15 |
0 |
Kit Prod |
|
|
|
|
|
|
S |
LR_VALFECP |
N |
14 |
2 |
Valor FECP |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
LR_ECVALOR |
N |
12 |
2 |
EC Vlr Item |
@E 999,999,999.99 |
|
|
R |
|
|
S |
LR_CCUSTO |
C |
9 |
0 |
Centro Custo |
@! |
|
|
R |
|
|
S |
LR_DESCICM |
N |
14 |
2 |
Desc.Icms |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
LR_DECQTD |
N |
1 |
0 |
Dec. Qtde |
9 |
|
|
|
|
|
S |
LR_MOTDICM |
C |
1 |
0 |
Mot.Desone |
@! |
Pertence(" 123456789") |
|
R |
|
|
S |
LR_DECVLU |
N |
1 |
0 |
Dec.Vl.Unt. |
9 |
|
|
|
|
|
S |
LR_IAT |
C |
1 |
0 |
Trunc ou Arr |
|
|
|
R |
A=Arredondamento;T=Truncamento |
|
S |
LR_IPPT |
C |
1 |
0 |
Prop ou Terc |
|
|
|
R |
P=Propria;T=Terceiros |
|
S |
LR_ALIQPIS |
N |
5 |
2 |
Aliq. Pis |
@E 99.99 |
|
|
R |
|
|
S |
LR_ALIQCOF |
N |
5 |
2 |
Aliq. Cofins |
@E 99.99 |
|
|
R |
|
|
S |
LR_BASEPIS |
N |
14 |
2 |
Base Pis |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
LR_PICM |
N |
5 |
2 |
Aliq. ICMS |
@E 99.99 |
|
|
R |
|
|
S |
LR_VALIRRF |
N |
14 |
2 |
Valor IRRF |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
LR_BASCSLL |
N |
14 |
2 |
Base de CSLL |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
LR_BASIRRF |
N |
14 |
2 |
Base de IRRF |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
LR_BASECOF |
N |
14 |
2 |
Base Confins |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
LR_CLVL |
C |
9 |
0 |
Classe Valor |
@! |
|
|
R |
|
|
S |
LR_ALQIRRF |
N |
5 |
2 |
Aliq. IRRF |
@E 99.99 |
|
|
R |
|
|
S |
LR_ITEMCC |
C |
9 |
0 |
Item Conta |
@! |
|
|
R |
|
|
S |
LR_ALQCSLL |
N |
5 |
2 |
Aliq. CSLL |
@E 99.99 |
|
|
R |
|
|
S |
LR_IDITREL |
C |
3 |
0 |
Id Item Rela |
!@ |
|
|
|
|
|
S |
LR_VFECPST |
N |
14 |
2 |
Vlr. FECP ST |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
LR_ALQFCST |
N |
5 |
2 |
Aliq FECP ST |
@E 99.99 |
|
|
R |
|
|
S |
LR_IPI |
N |
5 |
2 |
Aliq. IPI |
@E 99.99 |
|
|
R |
|
|
S |
LR_ALIQSOL |
N |
6 |
2 |
Alq ICMS Sol |
@E 999.99 |
|
|
R |
|
|
S |
LR_BASEIPI |
N |
14 |
2 |
Vlr.Base IPI |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
LR_BSFCPST |
N |
14 |
2 |
Base FCP ST |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
LR_CSTPIS |
C |
2 |
0 |
CST PIS |
@! |
|
|
|
|
|
S |
LR_CSTCOF |
C |
2 |
0 |
CST COF |
@! |
|
|
|
|
|
S |
LR_BASFECP |
N |
14 |
2 |
Base FECP |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |