Tabela |
NJC |
Liquidacao Cetificacao da CP |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
NJC_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
NJC_CODLIQ |
C |
12 |
0 |
Liquidacao |
@! |
|
|
R |
|
.f. |
S |
NJC_COMPRO |
C |
10 |
0 |
COE |
@! |
|
|
R |
|
|
S |
NJC_STATUS |
C |
2 |
0 |
STATUS |
@! |
|
|
R |
|
|
S |
NJC_OPERAC |
C |
1 |
0 |
Operacao |
@! |
Pertence("12") |
|
R |
1= Compras Venda; 2= Consignacao de Graos |
|
S |
NJC_TROCA |
C |
1 |
0 |
Troca |
@! |
Pertence("123") |
|
R |
1=Nao;2=Troca Parcial;3=Troca Total |
|
S |
NJC_TIPLIQ |
C |
1 |
0 |
Prod.Propria |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
Iif(NJC_OPERAC == "1", .T., .F.) |
S |
NJC_PROD |
C |
15 |
0 |
Produto |
@! |
|
SB1 |
R |
|
|
S |
NJC_NOMPRO |
C |
40 |
0 |
Desc. Prod. |
@! |
|
|
V |
|
|
S |
NJC_ESPECI |
C |
3 |
0 |
Especie |
@! |
|
|
V |
|
|
S |
NJC_SALDO |
N |
12 |
2 |
Saldo |
@E 999,999,999.99 |
|
|
V |
|
|
S |
NJC_CODSAF |
C |
15 |
0 |
Safra |
@! |
|
|
V |
|
|
S |
NJC_DEPOSI |
C |
6 |
0 |
Depositante |
@! |
|
|
V |
|
|
S |
NJC_LOJA |
C |
2 |
0 |
Loja |
@! |
|
|
V |
|
|
S |
NJC_NOMDEP |
C |
40 |
0 |
Nome Deposit |
@! |
|
|
V |
|
|
S |
NJC_CODAUT |
C |
8 |
0 |
Data Autoriz |
|
|
|
R |
|
|
S |
NJC_DTAAUT |
D |
8 |
0 |
Dt. Autoriz. |
|
|
|
R |
|
|
S |
NJC_PORTO |
C |
5 |
0 |
Porto |
@! |
ExistCpo("DBD") |
|
|
|
|
S |
NJC_NOMEPO |
C |
40 |
0 |
Nome Porto |
@! |
|
|
V |
|
|
S |
NJC_VENDED |
C |
6 |
0 |
Vendedor |
@! |
ExistCpo("SA3") |
|
|
|
|
S |
NJC_NOMVED |
C |
40 |
0 |
Nome Vend. |
@! |
|
|
V |
|
|
S |
NJC_CORRED |
C |
6 |
0 |
Corretor |
@! |
ExistCpo("SYW") |
|
|
|
|
S |
NJC_NOMCOR |
C |
40 |
0 |
Nome Corret. |
@! |
|
|
V |
|
|
S |
NJC_PRECO |
N |
12 |
2 |
Preco Ref. |
@E 999,999,999.99 |
OGA600VLB() |
|
|
|
|
S |
NJC_FRETE |
N |
12 |
2 |
Frete |
@E 999,999,999.99 |
|
|
|
|
|
S |
NJC_ALIIVA |
C |
1 |
0 |
Aliquota IVA |
@! |
Naovazio() .And. OGA600VLB() |
|
|
1=10,50;2=21,00 |
|
S |
NJC_LIQUID |
N |
12 |
2 |
Peso Liquida |
@E 999,999,999.99 |
OGA600VAL() |
|
|
|
|
S |
NJC_VALORB |
N |
12 |
2 |
Valor Bruto |
@E 999,999,999.99 |
|
|
V |
|
|
S |
NJC_VLBIVA |
N |
12 |
2 |
Valor IVA |
@E 999,999,999.99 |
|
|
V |
|
|
S |
NJC_VLRLIQ |
N |
12 |
2 |
Valor Liq. |
@E 999,999,999.99 |
|
|
V |
|
|
S |
NJC_CODEDU |
C |
6 |
0 |
Deducao |
@! |
|
|
|
|
|
S |
NJC_TAXADE |
N |
7 |
2 |
Taxa Deducao |
@E 9,999.99 |
positivo() .And. OGA600CALI("NJC_VLRDED","NJC_TAXADE") |
|
|
|
|
S |
NJC_VLRDED |
N |
12 |
2 |
Valor Deduc. |
@E 999,999,999.99 |
|
|
V |
|
|
S |
NJC_CODARM |
C |
6 |
0 |
Armazenagem |
@! |
|
|
|
|
|
S |
NJC_TAXIVA |
N |
7 |
2 |
Taxa IVA |
@E 9,999.99 |
Positivo() .And. OGA600CALI("NJC_VLRARM","NJC_TAXIVA") |
|
|
|
|
S |
NJC_VLRARM |
N |
12 |
2 |
Vlr Ded Arm. |
@E 999,999,999.99 |
positivo() |
|
V |
|
|
S |
NJC_CODIVA |
C |
6 |
0 |
Cod. IVA |
@! |
|
|
|
|
|
S |
NJC_ALRIVA |
N |
7 |
2 |
Al. Ret. IVA |
@E 9,999.99 |
positivo() .And. OGA600CALI("NJC_VLRIVA","NJC_ALRIVA") |
|
|
|
|
S |
NJC_VLRIVA |
N |
12 |
2 |
Valor IVA |
@E 999,999,999.99 |
Positivo() |
|
V |
|
|
S |
NJC_CODIMP |
C |
6 |
0 |
Imposto |
@! |
|
|
|
|
|
S |
NJC_ALIIMP |
N |
7 |
2 |
Aliq Imposto |
@E 9,999.99 |
Positivo() .And. OGA600CALI("NJC_VLRIMP","NJC_ALIIMP") |
|
|
|
|
S |
NJC_VLRIMP |
N |
12 |
2 |
Valor Impost |
@E 999,999,999.99 |
|
|
V |
|
|
S |
NJC_CODDES |
C |
6 |
0 |
Cod. Descont |
@! |
|
|
|
|
|
S |
NJC_ALIDES |
N |
7 |
2 |
Aliq. Descon |
@E 9,999.99 |
positivo() .And. OGA600CALI("NJC_VLRDES","NJC_ALIDES") |
|
|
|
|
S |
NJC_VLRDES |
N |
12 |
2 |
Valor Desc. |
@E 999,999,999.99 |
|
|
V |
|
|
S |
NJC_CODDOU |
C |
6 |
0 |
Outros |
@! |
|
|
|
|
|
S |
NJC_ALIOUT |
N |
7 |
2 |
Aliq. Outros |
@E 9,999.99 |
positivo().And. OGA600CALI("NJC_VLROUT","NJC_ALIOUT") |
|
|
|
|
S |
NJC_VLROUT |
N |
12 |
2 |
Valor Outros |
@E 999,999,999.99 |
|
|
V |
|
|
S |
NJC_OBS |
M |
10 |
0 |
Observacao |
@! |
|
|
|
|
|
S |
NJC_CUITEM |
C |
14 |
0 |
CUIT Emissor |
@! |
|
|
V |
|
|
N |
NJC_EMISSA |
D |
8 |
0 |
Data Emissao |
|
|
|
R |
|
|
S |
NJC_PTOEMI |
C |
6 |
0 |
Pto Emissao |
@! |
|
|
R |
|
|
S |
NJC_CODCET |
C |
12 |
0 |
Certificado |
@! |
|
|
|
|
|
S |
NJC_TIPO |
C |
1 |
0 |
Tipo |
@! |
Pertence("12") |
|
V |
1=Proprio;2=Terceiro |
|
S |
NJC_DESESP |
C |
30 |
0 |
Desc.Especie |
@! |
|
|
V |
|
|
S |
NJC_CODCTR |
C |
15 |
0 |
Contrato |
@! |
|
|
R |
|
|
S |
NJC_LOCPRO |
C |
6 |
0 |
Provincia |
@! |
|
|
R |
|
|
S |
NJC_PROPRO |
C |
6 |
0 |
Loc.Proceden |
@! |
|
|
R |
|
|
S |
NJC_INFCER |
C |
1 |
0 |
Inf.Certific |
@! |
PERTENCE("12") |
|
R |
1=Sim; 2=Nao |
Iif(NJC_OPERAC == "1", .T., .F.) |
S |
NJC_CODPRO |
C |
6 |
0 |
Comprador |
@! |
|
SA2 |
R |
|
|
S |