Tabela |
SC8 |
Cotacoes |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
C8_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
C8_NUM |
C |
6 |
0 |
Num. Cotacao |
@! |
|
|
|
|
.F. |
S |
C8_ITEM |
C |
4 |
0 |
Item Cotacao |
@! |
|
|
|
|
|
S |
C8_NUMPRO |
C |
2 |
0 |
Proposta |
@! |
|
|
|
|
|
S |
C8_PRODUTO |
C |
15 |
0 |
Produto |
@! |
MaFisRef("IT_PRODUTO","MT150",M->C8_PRODUTO) |
|
R |
|
|
S |
C8_UM |
C |
2 |
0 |
U.M. |
|
ExistCpo("SAH") |
SAH |
|
|
|
S |
C8_QTDCTR |
N |
9 |
2 |
Qtd.p/ Ctr. |
@E 999,999.99 |
Positivo() |
|
|
|
|
S |
C8_QUANT |
N |
12 |
2 |
Quantidade |
@E 999999999.99 |
A150Quant(M->C8_QUANT) |
|
|
|
|
S |
C8_PRECO |
N |
14 |
2 |
Preco Unitar |
@E 99,999,999,999.99 |
positivo() .And. A150Preco() |
|
|
|
|
S |
C8_CODTAB |
C |
3 |
0 |
Tab.Preco |
|
MaVldTabCom(M->cA150Forn,M->cA150Loj,M->C8_CODTAB,M->cCondicao,,M->dA150Emis).And.A150Tabela() |
AIA |
|
|
|
S |
C8_TOTAL |
N |
14 |
2 |
Total Item |
@E 99,999,999,999.99 |
A150Total(M->C8_TOTAL).And.MaFisRef("IT_VALMERC","MT150",M->C8_TOTAL) |
|
|
|
|
S |
C8_COND |
C |
3 |
0 |
Cond. Pagto |
@! |
existcpo("SE4") |
SE4 |
|
|
|
S |
C8_TAXAFIN |
N |
9 |
4 |
Taxa Financ. |
@E 9999.9999 |
positivo() |
|
|
|
|
S |
C8_PRAZO |
N |
5 |
0 |
Prazo Entreg |
99999 |
Positivo() |
|
|
|
|
S |
C8_DESCRI |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
C8_FORNECE |
C |
6 |
0 |
Fornecedor |
@! |
a131VldFor() |
FOR |
R |
|
|
S |
C8_LOJA |
C |
2 |
0 |
Loja |
@! |
a131VldFor() |
|
R |
|
|
S |
C8_CONTATO |
C |
15 |
0 |
Contato |
@! |
|
|
|
|
|
S |
C8_FILENT |
C |
2 |
0 |
Filial Entr. |
|
A120FilEnt(M->C8_FILENT) |
SM0 |
|
|
|
S |
C8_EMISSAO |
D |
8 |
0 |
DT Emissao |
|
|
|
|
|
|
S |
C8_ALIIPI |
N |
5 |
2 |
Aliq. IPI |
@E 99.99 |
(Positivo().Or.Vazio()).And.MaFisRef("IT_ALIQIPI","MT150",M->C8_ALIIPI) |
|
|
|
|
S |
C8_TES |
C |
3 |
0 |
Tipo Entrada |
@! |
Vazio().Or.(ExistCpo("SF4").And.MaAvalTes("E",M->C8_TES).And.MaFisRef("IT_TES","MT150",M->C8_TES)) |
SF4 |
|
|
|
S |
C8_PICM |
N |
5 |
2 |
Aliq. ICMS |
@E 99.99 |
Positivo().And.VldAliqIcm(M->C8_PICM).And.MaFisRef("IT_ALIQICM","MT150",M->C8_PICM) |
|
|
|
|
S |
C8_VALFRE |
N |
14 |
2 |
Vlr.Frete |
@E 999,999,999.99 |
Positivo() .And. MaFisRef("IT_FRETE","MT150",M->C8_VALFRE) .And. A150ValFre() |
|
|
|
|
S |
C8_VALEMB |
N |
14 |
2 |
Vlr.Embal. |
@E 999,999,999.99 |
(Positivo().or.Vazio()).And.MaFisRef("IT_VALEMB","MT150",M->C8_VALEMB) |
|
|
|
|
S |
C8_DESC1 |
N |
5 |
2 |
Desconto 1 |
@E 99.99 |
|
|
|
|
|
S |
C8_DESC2 |
N |
5 |
2 |
Desconto 2 |
@E 99.99 |
|
|
|
|
|
S |
C8_DESC3 |
N |
5 |
2 |
Desconto 3 |
@E 99.99 |
|
|
|
|
|
S |
C8_TPFRETE |
C |
1 |
0 |
Tipo Frete |
X |
|
|
|
|
|
S |
C8_TOTFRE |
N |
14 |
2 |
Frete Total |
@E 999,999,999.99 |
|
|
|
|
|
S |
C8_AVISTA |
N |
14 |
2 |
Prc a Vista |
@E 999,999,999.99 |
positivo() |
|
|
|
|
S |
C8_REAJUST |
C |
3 |
0 |
Reajuste |
@! |
|
SM4 |
|
|
|
S |
C8_DTVISTA |
D |
8 |
0 |
DT Prc.Vista |
|
M->C8_DTVISTA>=dDataBase |
|
|
|
A150DtVist() |
S |
C8_VALIDA |
D |
8 |
0 |
DT Validade |
|
|
|
|
|
|
S |
C8_NUMPED |
C |
6 |
0 |
Num.Pedido |
|
|
|
|
|
|
S |
C8_ITEMPED |
C |
4 |
0 |
Item do Ped. |
@! |
|
|
|
|
|
S |
C8_NUMSC |
C |
6 |
0 |
Numero SC |
|
|
|
|
|
|
S |
C8_ITEMSC |
C |
4 |
0 |
Item SC |
@! |
|
|
|
|
|
S |
C8_DATPRF |
D |
8 |
0 |
Necessidade |
|
|
|
|
|
|
S |
C8_IDENT |
C |
4 |
0 |
Identif. |
@! |
|
|
|
|
|
S |
C8_VLDESC |
N |
14 |
2 |
Vl. Desconto |
@E 999,999,999.99 |
Positivo().And.A150ZeraDesc().And.MaFisRef("IT_DESCONTO","MT150",M->C8_VLDESC) |
|
|
|
|
S |
C8_SEGUM |
C |
2 |
0 |
Segunda UM |
|
Vazio().Or.ExistCpo("SAH") |
SAH |
|
|
|
S |
C8_QTSEGUM |
N |
11 |
2 |
Qtd. 2a UM |
@E 99999999.99 |
Positivo().or.Vazio() |
|
|
|
|
S |
C8_MOTIVO |
C |
30 |
0 |
Motivo |
@! |
|
|
|
|
|
S |
C8_GRUPCOM |
C |
6 |
0 |
Gr. Compras |
@! |
|
|
|
|
|
S |
C8_STATME |
C |
1 |
0 |
Status do ME |
@! |
Pertence(" 0123") |
|
|
|
|
S |
C8_OK |
C |
2 |
0 |
Ok |
|
|
|
|
|
|
S |
C8_SEGURO |
N |
14 |
2 |
Vlr. Seguro |
@E 999,999,999.99 |
Positivo().And.MaFisRef("IT_SEGURO","MT150",M->C8_SEGURO) |
|
|
|
|
S |
C8_DESPESA |
N |
14 |
2 |
Vlr. Despesa |
@E 999,999,999.99 |
Positivo().And.MaFisRef("IT_DESPESA","MT150",M->C8_DESPESA) |
|
|
|
|
S |
C8_VALIPI |
N |
14 |
2 |
Vlr. IPI |
@E 999,999,999.99 |
Positivo().And.MaFisRef("IT_VALIPI","MT150",M->C8_VALIPI) |
|
|
|
|
S |
C8_VALICM |
N |
14 |
2 |
Vlr. ICMS |
@E 999,999,999.99 |
Positivo().And.MaFisRef("IT_VALICM","MT150",M->C8_VALICM) |
|
|
|
|
S |
C8_BASEICM |
N |
14 |
2 |
Base de ICMS |
@E 999,999,999.99 |
Positivo().And.MaFisRef("IT_BASEICM","MT150",M->C8_BASEICM) |
|
|
|
|
S |
C8_BASEIPI |
N |
14 |
2 |
base de IPI |
@E 999,999,999.99 |
Positivo().And.MaFisRef("IT_BASEIPI","MT150",M->C8_BASEIPI) |
|
|
|
|
S |
C8_DESC |
N |
5 |
2 |
% Desc. Item |
@E 99.99 |
Positivo() |
|
|
|
|
S |
C8_MSG |
C |
3 |
0 |
Mensagem |
@! |
|
SM4 |
|
|
|
S |
C8_MOEDA |
N |
2 |
0 |
Moeda |
99 |
M->nMoedaCot <= MoedFin() .And. M->nMoedaCot <> 0 |
|
|
|
|
S |
C8_TXMOEDA |
N |
11 |
4 |
Taxa Moeda |
@E 999999.9999 |
|
|
|
|
|
S |
C8_ORCFOR |
C |
20 |
0 |
Nr.Orcamento |
@! |
|
|
|
|
|
S |
C8_SEQFOR |
C |
10 |
0 |
Sq.Orcamento |
@! |
|
|
|
|
|
S |
C8_ITEFOR |
C |
10 |
0 |
It.Orcamento |
@! |
|
|
|
|
|
S |
C8_CODGRP |
C |
4 |
0 |
Grupo |
@!!!! |
VldAuxCod1("C8_CODGRP","C8_CODITE") |
SBM |
V |
|
|
S |
C8_CODITE |
C |
27 |
0 |
Cod. Produto |
|
VldAuxCod2("C8_PRODUTO","C8_CODGRP") |
B00 |
V |
|
|
S |
C8_ITEMGRD |
C |
3 |
0 |
Item Grade |
|
|
|
|
|
|
S |
C8_ITSCGRD |
C |
3 |
0 |
Grade SC |
|
|
|
|
|
|
S |
C8_GRADE |
C |
1 |
0 |
Grade |
|
|
|
R |
|
|
S |
C8_CODORCA |
C |
8 |
0 |
Cod. Orcam. |
|
|
N13 |
|
|
|
S |
C8_TPDOC |
C |
1 |
0 |
Tp. Doc. |
|
|
|
R |
1=Pedido de Compra; 2=Contrato |
|
S |
C8_INTCLIC |
C |
1 |
0 |
ClicBusiness |
@! |
Pertence("IEX") |
|
R |
I=Integrado;E=Encerrado;X=Excluido |
|
S |
C8_ORIGEM |
C |
8 |
0 |
Rotina Gerad |
|
|
|
|
|
|
S |
C8_FORNOME |
C |
80 |
0 |
Nome |
@! |
a131VldFor() |
|
R |
|
a150FWhen() |
S |
C8_FORMAIL |
C |
80 |
0 |
E-mail |
@! |
|
|
R |
|
|
S |
C8_WF |
L |
1 |
0 |
WF |
|
|
|
R |
|
|
S |
C8_OBS |
M |
10 |
0 |
Observacoes |
@! |
|
|
|
|
|
S |
C8_NUMCON |
C |
15 |
0 |
Num.Contrato |
@! |
|
|
R |
|
|
S |
C8_BASESOL |
N |
14 |
2 |
Bs. ICMS Sol |
@E 99,999,999,999.99 |
Positivo().And.MaFisRef("IT_BASESOL","MT150",M->C8_BASESOL) |
|
R |
|
|
S |
C8_VALSOL |
N |
14 |
2 |
Val ICMS Sol |
@E 99,999,999,999.99 |
Positivo().And.MaFisRef("IT_VALSOL","MT150",M->C8_VALSOL) |
|
R |
|
|
S |
C8_NUMPR |
C |
15 |
0 |
Nr. Processo |
@! |
|
|
R |
|
|
S |
C8_CODED |
C |
15 |
0 |
Cod. Edital |
@! |
|
|
R |
|
|
S |
C8_PRECOOR |
N |
12 |
2 |
Prc Estimado |
@E 999,999,999.99 |
|
|
R |
|
|
S |
C8_ACCNUM |
C |
50 |
0 |
Cot. ACC |
|
|
|
R |
|
|
N |
C8_ACCITEM |
C |
50 |
0 |
Item ACC |
|
|
|
R |
|
|
N |
C8_TAXAFOR |
N |
11 |
4 |
Taxa Fornece |
@E 999,999.9999 |
|
|
|
|
|
S |
C8_MARKAUD |
L |
1 |
0 |
Auditoria |
|
|
|
|
|
|
S |