Tabela |
CT2 |
Lancamentos Contabeis |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
CT2_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
CT2_DATA |
D |
8 |
0 |
Data Lcto |
99/99/9999 |
|
|
|
|
|
S |
CT2_LOTE |
C |
6 |
0 |
Numero Lote |
@! |
|
|
|
|
|
S |
CT2_SBLOTE |
C |
3 |
0 |
Sub Lote |
@! |
ExistCpo("SX5", "SB" + M->CT2_SBLOTE) |
SB |
|
|
|
S |
CT2_DOC |
C |
6 |
0 |
Numero Doc |
@! |
|
|
|
|
|
S |
CT2_LINHA |
C |
3 |
0 |
Numero Linha |
@! |
|
|
|
|
|
S |
CT2_MOEDLC |
C |
2 |
0 |
Moeda Lancto |
@! |
|
|
|
|
|
S |
CT2_DC |
C |
1 |
0 |
Tipo Lcto |
! |
Pertence("123456") .And. CtTipoLan(m->CT2_DC) |
|
|
1=Debito;2=Credito;3=Partida Dobrada;4=Cont.Hist;5=Rateio;6=Lcto Padrao |
|
S |
CT2_DEBITO |
C |
20 |
0 |
Cta Debito |
@! |
CTB105CTA(m->CT2_DEBITO,"1") .And. CtbAmarra(TMP->CT2_DEBITO,TMP->CT2_CCD,TMP->CT2_ITEMD,TMP->CT2_CLVLDB, .T.) |
CT1 |
|
|
|
S |
CT2_CREDIT |
C |
20 |
0 |
Cta Credito |
@! |
CTB105CTA(m->CT2_CREDIT,"2") .And. CtbAmarra(TMP->CT2_CREDIT,TMP->CT2_CCC,TMP->CT2_ITEMC,TMP->CT2_CLVLCR,.T.) |
CT1 |
|
|
|
S |
CT2_DCD |
C |
1 |
0 |
Dig Cont Deb |
! |
|
|
|
|
|
S |
CT2_DCC |
C |
1 |
0 |
Dig Cont Crd |
! |
|
|
|
|
|
S |
CT2_VALOR |
N |
16 |
2 |
Valor |
@E 9,999,999,999,999.99 |
ValidaValor(M->CT2_VALOR) .And. Ctb105Conv(M->CT2_VALOR,,) |
|
|
|
|
S |
CT2_MOEDAS |
C |
5 |
0 |
Moedas Lanca |
@! |
ValidaMoedas(m->CT2_MOEDAS) .And. Ctb105Conv(,,M->CT2_MOEDAS) |
|
|
|
|
S |
CT2_HP |
C |
3 |
0 |
Hist Pad |
@! |
Vazio() .Or. ExistCpo("CT8",,1) .And. ValidaHist(m->CT2_HP) |
CT8 |
|
|
|
S |
CT2_HIST |
C |
40 |
0 |
Hist Lanc |
@! |
|
|
|
|
|
S |
CT2_CONVER |
C |
5 |
0 |
Crit Conv |
@! |
ValidaCriter(M->CT2_CONVER) .And. Ctb105Conv(,M->CT2_CONVER,) |
|
V |
|
|
S |
CT2_CCD |
C |
9 |
0 |
C Custo Deb |
@! |
CTB105CC(m->CT2_CCD,"1") .And. CtbAmarra(TMP->CT2_DEBITO,TMP->CT2_CCD,TMP->CT2_ITEMD,TMP->CT2_CLVLDB,.T.) |
CTT |
|
|
CtbMovSaldo("CTT") |
S |
CT2_CCC |
C |
9 |
0 |
C Custo Crd |
@! |
CTB105CC(m->CT2_CCC,"2") .And. CtbAmarra(TMP->CT2_CREDIT,TMP->CT2_CCC,TMP->CT2_ITEMC,TMP->CT2_CLVLCR, .T.) |
CTT |
|
|
CtbMovSaldo("CTT") |
S |
CT2_ITEMD |
C |
9 |
0 |
Item Debito |
@! |
CTB105ITEM(m->CT2_ITEMD,"1") .And. CtbAmarra(TMP->CT2_DEBITO,TMP->CT2_CCD,TMP->CT2_ITEMD,TMP->CT2_CLVLDB,.T.) |
CTD |
|
|
CtbMovSaldo("CTD") |
S |
CT2_ITEMC |
C |
9 |
0 |
Item Credito |
@! |
CTB105ITEM(m->CT2_ITEMC,"2") .And. CtbAmarra(TMP->CT2_CREDIT,TMP->CT2_CCC,TMP->CT2_ITEMC,TMP->CT2_CLVLCR,.T.) |
CTD |
|
|
CtbMovSaldo("CTD") |
S |
CT2_CLVLDB |
C |
9 |
0 |
Cl Vlr Deb |
@! |
CTB105CLVL(m->CT2_CLVLDB,"1") .And. CtbAmarra(TMP->CT2_DEBITO,TMP->CT2_CCD,TMP->CT2_ITEMD,TMP->CT2_CLVLDB,.T.) |
CTH |
|
|
CtbMovSaldo("CTH") |
S |
CT2_CLVLCR |
C |
9 |
0 |
Cl Vlr Cred |
@! |
CTB105CLVL(m->CT2_CLVLCR,"2") .And. CtbAmarra(TMP->CT2_CREDIT,TMP->CT2_CCC,TMP->CT2_ITEMC,TMP->CT2_CLVLCR,.T.) |
CTH |
|
|
CtbMovSaldo("CTH") |
S |
CT2_ATIVDE |
C |
40 |
0 |
Ativ Deb |
@! |
|
|
|
|
|
S |
CT2_ATIVCR |
C |
40 |
0 |
Ativ Crd |
@! |
|
|
|
|
|
S |
CT2_EMPORI |
C |
2 |
0 |
Empresa Orig |
@! |
|
|
|
|
|
S |
CT2_FILORI |
C |
2 |
0 |
Filial Orig |
|
|
|
|
|
|
S |
CT2_INTERC |
C |
1 |
0 |
Intercompany |
@! |
|
|
|
1=Sim;2=Nao |
|
S |
CT2_IDENTC |
C |
50 |
0 |
Ident IntCp |
@! |
|
|
|
|
|
S |
CT2_TPSALD |
C |
1 |
0 |
Tipo do Sld |
! |
|
SLW |
|
|
|
S |
CT2_SEQUEN |
C |
10 |
0 |
Seq CTK |
@! |
|
|
|
|
|
S |
CT2_MANUAL |
C |
1 |
0 |
Lcto Manual |
! |
Pertence("12") |
|
|
|
|
S |
CT2_ORIGEM |
C |
100 |
0 |
Origem |
@! |
|
|
|
|
|
S |
CT2_ROTINA |
C |
10 |
0 |
Rotina |
@! |
|
|
|
|
|
S |
CT2_AGLUT |
C |
1 |
0 |
Aglutinado |
@! |
|
|
|
|
|
S |
CT2_LP |
C |
3 |
0 |
Lanc Padrao |
@! |
|
CVA |
|
|
|
S |
CT2_SEQHIS |
C |
3 |
0 |
Seq Historic |
@! |
|
|
|
|
|
S |
CT2_SEQLAN |
C |
3 |
0 |
Seq Auxiliar |
@! |
|
|
|
|
|
S |
CT2_DTVENC |
D |
8 |
0 |
Data Venc |
99/99/9999 |
|
|
|
|
|
S |
CT2_SLBASE |
C |
1 |
0 |
Flag Sld Bas |
|
|
|
|
|
|
S |
CT2_DTLP |
D |
8 |
0 |
Dt Apuracao |
99/99/9999 |
|
|
|
|
|
S |
CT2_VALR02 |
N |
16 |
2 |
Valor Moeda2 |
@E 9,999,999,999,999.99 |
CtVlOutVlr(M->CT2_VALR02,2) |
|
V |
|
|
S |
CT2_VALR03 |
N |
16 |
2 |
Valor Moeda3 |
@E 9,999,999,999,999.99 |
CtVlOutVlr(M->CT2_VALR03,3) |
|
V |
|
|
S |
CT2_VALR04 |
N |
16 |
2 |
Valor Moeda4 |
@E 9,999,999,999,999.99 |
CtVlOutVlr(M->CT2_VALR04,4) |
|
V |
|
|
S |
CT2_VALR05 |
N |
16 |
2 |
Valor Moeda5 |
@E 9,999,999,999,999.99 |
CtVlOutVlr(M->CT2_VALR05,5) |
|
V |
|
|
S |
CT2_DATATX |
D |
8 |
0 |
Data Conv. |
99/99/9999 |
|
|
|
|
|
S |
CT2_TAXA |
N |
8 |
4 |
Taxa Conv. |
@E 999.9999 |
|
|
|
|
|
S |
CT2_VLR01 |
N |
16 |
2 |
Valor Moeda1 |
@E 9,999,999,999,999.99 |
ValidaValor(m->CT2_VLR01) .And. Ctb105Conv(M->CT2_VLR01,,) |
|
|
|
|
S |
CT2_VLR02 |
N |
16 |
2 |
Valor Moeda2 |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
CT2_VLR03 |
N |
16 |
2 |
Valor Moeda3 |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
CT2_VLR04 |
N |
16 |
2 |
Valor Moeda4 |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
CT2_VLR05 |
N |
16 |
2 |
Valor Moeda5 |
@E 9,999,999,999,999.99 |
|
|
|
|
|
S |
CT2_DTTX02 |
D |
8 |
0 |
Data Conv.02 |
99/99/9999 |
CtbDtVenc(M->CT2_DTTX02,TMP->CT2_VALOR,2) |
|
V |
|
|
S |
CT2_TAXA02 |
N |
8 |
4 |
Taxa Conv.02 |
@E 999.9999 |
|
|
V |
|
|
S |
CT2_DTTX03 |
D |
8 |
0 |
Data Conv.03 |
99/99/9999 |
CtbDtVenc(M->CT2_DTTX03,TMP->CT2_VALOR,3) |
|
V |
|
|
S |
CT2_TAXA03 |
N |
8 |
4 |
Taxa Conv.03 |
@E 999.9999 |
|
|
V |
|
|
S |
CT2_DTTX04 |
D |
8 |
0 |
Data Conv.04 |
99/99/9999 |
CtbDtVenc(M->CT2_DTTX04,TMP->CT2_VALOR,4) |
|
V |
|
|
S |
CT2_TAXA04 |
N |
8 |
4 |
Taxa Conv.04 |
@E 999.9999 |
|
|
V |
|
|
S |
CT2_DTTX05 |
D |
8 |
0 |
Data Conv.05 |
99/99/9999 |
CtbDtVenc(M->CT2_DTTX05,TMP->CT2_VALOR,5) |
|
V |
|
|
S |
CT2_TAXA05 |
N |
8 |
4 |
Taxa Conv.05 |
@E 999.9999 |
|
|
V |
|
|
S |
CT2_CRCONV |
C |
1 |
0 |
Crit. Conver |
@! |
|
|
|
1=Diaria;2=Media;3=Mensal;4=Informada;5=Nao tem Conversao;6=Fixo;7=Mensal Historica;8=Media Historica;9=Vencimento;A=Nao Ajusta |
|
S |
CT2_CRITER |
C |
4 |
0 |
Crit Conv |
@! |
ValidaCriter(m->CT2_CRITER) .And. Ctb105Conv(,M->CT2_CRITER,) |
|
|
|
|
S |
CT2_KEY |
C |
200 |
0 |
Key |
|
|
|
|
|
|
S |
CT2_SEGOFI |
C |
10 |
0 |
Correlativo |
@! |
|
|
R |
|
|
S |
CT2_DTCV3 |
D |
8 |
0 |
Data Rastrea |
99/99/9999 |
|
|
|
|
|
S |
CT2_SEQIDX |
C |
5 |
0 |
Seq Chv Unic |
@! |
|
|
|
|
|
S |
CT2_CONFST |
C |
1 |
0 |
Status Conf. |
|
|
|
|
|
|
S |
CT2_OBSCNF |
C |
40 |
0 |
Obs Conf |
|
|
|
|
|
|
S |
CT2_USRCNF |
C |
15 |
0 |
Usuario Conf |
|
|
|
|
|
|
S |
CT2_DTCONF |
D |
8 |
0 |
Data Conf |
|
|
|
|
|
|
S |
CT2_HRCONF |
C |
10 |
0 |
Hora Conf |
|
|
|
R |
|
|
S |
CT2_MLTSLD |
C |
20 |
0 |
Tps Saldos |
@! |
|
|
R |
|
|
S |
CT2_CTLSLD |
C |
1 |
0 |
Status Copia |
@! |
|
|
R |
|
|
S |
CT2_CODPAR |
C |
6 |
0 |
Cod.Partic. |
@! |
ExistCPO("CVC") |
CVC |
|
|
|
S |
CT2_NODIA |
C |
10 |
0 |
Nro Diario |
@! |
|
|
R |
|
|
S |
CT2_DIACTB |
C |
2 |
0 |
Cod. Diario |
@! |
VldCodSeq() |
|
|
|
|
S |
CT2_AT01DB |
C |
20 |
0 |
Ativ.01 DB |
@! |
|
|
R |
|
|
S |
CT2_AT01CR |
C |
20 |
0 |
Ativ.01 CR |
@! |
|
|
R |
|
|
S |
CT2_AT02DB |
C |
20 |
0 |
Ativ.02 DB |
@! |
|
|
R |
|
|
S |
CT2_AT02CR |
C |
20 |
0 |
Ativ.02 CR |
@! |
|
|
R |
|
|
S |
CT2_AT03DB |
C |
20 |
0 |
Ativ.03 DB |
@! |
|
|
R |
|
|
S |
CT2_AT03CR |
C |
20 |
0 |
Ativ.03 CR |
@! |
|
|
R |
|
|
S |
CT2_AT04DB |
C |
20 |
0 |
Ativ.04 DB |
@! |
|
|
R |
|
|
S |
CT2_AT04CR |
C |
20 |
0 |
Ativ.04 CR |
@! |
|
|
R |
|
|
S |
CT2_LANCSU |
C |
3 |
0 |
Sequencial |
@! |
|
|
R |
|
|
S |
CT2_GRPDIA |
C |
3 |
0 |
Grupo |
@! |
|
|
R |
|
|
S |
CT2_LANC |
C |
15 |
0 |
Lanc |
@ |
|
|
R |
|
|
S |
CT2_CODCLI |
C |
6 |
0 |
Cod. Cliente |
@! |
|
|
|
|
|
S |
CT2_CODFOR |
C |
6 |
0 |
Cod. Fornec. |
@! |
|
|
|
|
|
S |
CT2_MOEFDB |
C |
2 |
0 |
Moed fato DB |
@! |
Vazio() .Or. ExistCpo('CTO') |
CTO |
R |
|
|
S |
CT2_MOEFCR |
C |
2 |
0 |
Moed fato CR |
@! |
Vazio() .Or. ExistCpo('CTO') |
CTO |
R |
|
|
S |
CT2_USERGI |
C |
17 |
0 |
Log de Inclu |
|
|
|
R |
|
|
S |
CT2_USERGA |
C |
17 |
0 |
Log de Alter |
|
|
|
R |
|
|
S |
CT2_CTRLSD |
C |
1 |
0 |
Control.Sald |
@! |
|
|
R |
|
|
S |