Tabela |
NX0 |
PRE-FATURA |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
NX0_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
S |
NX0_SITUAC |
C |
1 |
0 |
Situacao |
|
|
JS |
R |
|
|
N |
NX0_DSITUA |
C |
25 |
0 |
Des Situacao |
|
|
|
V |
|
|
S |
NX0_COD |
C |
8 |
0 |
Cod Pre-Fat |
|
|
|
R |
|
|
N |
NX0_DTEMI |
D |
8 |
0 |
Data Emissao |
|
|
|
R |
|
|
N |
NX0_CMOEDA |
C |
2 |
0 |
Cod Moeda |
|
|
|
R |
|
|
N |
NX0_DMOEDA |
C |
10 |
0 |
Desc Moeda |
|
|
|
V |
|
|
N |
NX0_VLFATH |
N |
16 |
2 |
Valor Hon |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
N |
NX0_VLFATD |
N |
16 |
2 |
Valor Desp |
@E 9,999,999,999,999.99 |
JANX0_VDES() |
|
R |
|
J202WhDesp("NX0_VLFATD") |
N |
NX0_DESCON |
N |
16 |
2 |
V Desc Lin. |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
N |
NX0_VLREMB |
N |
16 |
2 |
Vl Desp Remb |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
NX0_VLTRIB |
N |
16 |
2 |
Vl Desp Trib |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
NX0_TPDESC |
C |
1 |
0 |
Tipo Descont |
|
Pertence('12').Or.Vazio() |
|
R |
1=Valor;2=Percentual |
|
S |
NX0_DESCH |
N |
16 |
2 |
V Desc Espec |
@E 9,999,999,999,999.99 |
J202DscAcr("NX0_DESCH") |
|
R |
|
|
N |
NX0_PDESCH |
N |
16 |
8 |
% Desc Espec |
@E 9,999,999.99999999 |
J202DscAcr("NX0_PDESCH") |
|
R |
|
|
S |
NX0_VDESCT |
N |
16 |
2 |
V Total Desc |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
NX0_TPACRE |
C |
1 |
0 |
Tipo Acresc |
|
Pertence('12').Or.Vazio() |
|
R |
1=Valor;2=Percentual |
|
S |
NX0_ACRESH |
N |
16 |
2 |
V Acrs Honor |
@E 9,999,999,999,999.99 |
J202DscAcr("NX0_ACRESH") |
|
R |
|
|
N |
NX0_PACREH |
N |
16 |
8 |
% Acrs Honor |
@E 9,999,999.99999999 |
J202DscAcr("NX0_PACREH") |
|
R |
|
|
N |
NX0_CESCR |
C |
5 |
0 |
Cod Escrit |
|
|
|
R |
|
|
N |
NX0_DESCR |
C |
100 |
0 |
Nome Escrit |
|
|
|
V |
|
|
N |
NX0_CCONTR |
C |
6 |
0 |
Cod Contrato |
|
|
|
R |
|
|
N |
NX0_DCONTR |
C |
30 |
0 |
Nome Contrat |
|
|
|
V |
|
|
N |
NX0_CJCONT |
C |
4 |
0 |
Cod Junc Con |
|
|
|
R |
|
|
N |
NX0_SIGLA |
C |
5 |
0 |
Sigla Rev |
|
Vazio().Or.(ExistCpo('RD0',FWFLDGET('NX0_SIGLA'),9).And.JURRD0('NX0MASTER','NX0_SIGLA','1',.T.)) |
RD0ATV |
V |
|
|
S |
NX0_CPART |
C |
6 |
0 |
Cod Revisor |
|
Vazio().Or.Iif(JurIsRest(),(ExistCpo('RD0',FWFLDGET('NX0_CPART'),1).And.JURRD0('NX0MASTER','NX0_CPART','1')), .T.) |
RD0 |
R |
|
|
N |
NX0_DPART |
C |
30 |
0 |
Nome Revisor |
|
|
|
V |
|
|
N |
NX0_DINITS |
D |
8 |
0 |
Data Ini TS |
|
|
|
R |
|
.F. |
N |
NX0_DFIMTS |
D |
8 |
0 |
Data Fim TS |
|
|
|
R |
|
.F. |
N |
NX0_DINIDP |
D |
8 |
0 |
Data Ini Des |
|
|
|
R |
|
.F. |
N |
NX0_DFIMDP |
D |
8 |
0 |
Data Fim Des |
|
|
|
R |
|
.F. |
N |
NX0_DINITB |
D |
8 |
0 |
Data Ini Tab |
|
|
|
R |
|
.F. |
N |
NX0_DFIMTB |
D |
8 |
0 |
Data Fim Tab |
|
|
|
R |
|
.F. |
N |
NX0_DFIMFX |
D |
8 |
0 |
Dt Fim Fixo |
|
|
|
R |
|
.F. |
N |
NX0_DINIFX |
D |
8 |
0 |
Dt Ini Fixo |
|
|
|
R |
|
.F. |
N |
NX0_USRALT |
C |
6 |
0 |
Cod Part Alt |
|
|
|
R |
|
|
N |
NX0_DTALT |
D |
8 |
0 |
Data Alt |
|
|
|
R |
|
|
N |
NX0_TS |
C |
1 |
0 |
Time Sheet? |
|
|
|
R |
1=Sim;2=Nao |
|
N |
NX0_DESP |
C |
1 |
0 |
Despesa? |
|
|
|
R |
1=Sim;2=Nao |
|
N |
NX0_LANTAB |
C |
1 |
0 |
Lanc Tab? |
|
|
|
R |
1=Sim;2=Nao |
|
N |
NX0_FIXO |
C |
1 |
0 |
Fixo? |
|
|
|
R |
1=Sim;2=Nao |
|
N |
NX0_FATADC |
C |
1 |
0 |
Fat Adic ? |
|
|
|
R |
1=Sim;2=Nao |
|
N |
NX0_CODEXI |
C |
1 |
0 |
Exito? |
|
|
|
R |
1=Sim;2=Nao |
|
N |
NX0_CGRUPO |
C |
6 |
0 |
Cod Grupo |
|
|
|
R |
|
|
N |
NX0_DGRUPO |
C |
30 |
0 |
Desc Grupo |
|
|
|
V |
|
|
N |
NX0_CCLIEN |
C |
6 |
0 |
Cod Cliente |
@! |
|
|
R |
|
|
N |
NX0_CLOJA |
C |
2 |
0 |
Cod Loja |
@! |
|
|
R |
|
|
N |
NX0_DCLIEN |
C |
30 |
0 |
Nome Cliente |
|
|
|
V |
|
|
N |
NX0_CFTADC |
C |
8 |
0 |
Cod Fat Adic |
|
|
|
R |
|
|
N |
NX0_CPAREX |
C |
6 |
0 |
Cod Exito |
|
|
|
R |
|
|
N |
NX0_CCONTA |
C |
6 |
0 |
Cod Contato |
|
(ExistCpo('SU5',M->NX0_CCONTA,1).And.JA202VSU5()).Or.Vazio() |
SU5NX0 |
R |
|
! empty(NX0_CCLIEN) |
N |
NX0_DCONTA |
C |
30 |
0 |
Nome Contato |
|
|
|
V |
|
|
N |
NX0_CTPHON |
C |
3 |
0 |
Tipo de Hon |
|
|
|
V |
|
|
N |
NX0_DTPHON |
C |
100 |
0 |
Desc Tp Hon |
|
|
|
V |
|
|
N |
NX0_SITCB |
C |
4 |
0 |
Sit. Cob Pre |
|
|
NSC |
R |
|
|
N |
NX0_DSITCB |
C |
50 |
0 |
Desc Sit Cob |
|
|
|
V |
|
|
N |
NX0_DTINC |
D |
8 |
0 |
Data Inc Pre |
|
|
|
R |
|
|
N |
NX0_REVIS |
C |
1 |
0 |
Pre Revisada |
|
|
|
R |
1=Sim;2=Nao |
|
N |
NX0_DTLIB |
D |
8 |
0 |
Data Lib Rev |
|
|
|
R |
|
|
N |
NX0_TPEMI |
C |
1 |
0 |
Tp Emi Pre |
|
|
|
R |
1=Fatura;2=Minuta;3=Aguardar |
|
N |
NX0_OBSFAT |
M |
10 |
0 |
Obs Fat |
|
|
|
R |
|
|
N |
NX0_CODUSR |
C |
6 |
0 |
Cod User |
|
|
|
R |
|
|
N |
NX0_OK |
C |
4 |
0 |
Marca OK |
|
|
|
R |
|
|
N |
NX0_ALTPER |
C |
1 |
0 |
Tp de Ajuste |
|
Pertence('123').or.Vazio() |
|
R |
1=Tempo;2=Ultimo;3=Todos |
JURA202W("NX0_ALTPER") |
N |
NX0_HRLIB |
C |
6 |
0 |
Hr Lib Revis |
@R 99:99:99 |
|
|
R |
|
|
S |
NX0_VTS |
N |
16 |
2 |
Valor TS |
@E 9,999,999,999,999.99 |
JANX0_VTS () |
|
R |
|
FwFldGet("NX0_TS") == "1" |
N |
NX0_DMAXEM |
D |
8 |
0 |
Data Max Emi |
|
|
|
R |
|
|
N |
NX0_VTSANT |
N |
16 |
2 |
Vlr TS Anter |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
NX0_PERFAT |
N |
6 |
2 |
Percentual |
@E 999.99 |
|
|
R |
|
|
N |
NX0_VLRHFA |
N |
16 |
2 |
Valor Hon Fa |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
N |
NX0_VLRDFA |
N |
16 |
2 |
Valor Des Fa |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
N |
NX0_FATOLD |
C |
9 |
0 |
Cod Fat Anti |
|
|
|
R |
|
|
N |
NX0_ESCOLD |
C |
5 |
0 |
Cod Esc Anti |
|
|
|
R |
|
|
N |
NX0_CIDIO |
C |
2 |
0 |
Cod Idi Rel |
|
|
NR1 |
R |
|
|
N |
NX0_USUEMI |
C |
6 |
0 |
Cod Part Emi |
|
|
|
R |
|
|
N |
NX0_DUSUEM |
C |
30 |
0 |
Nm Part Emi |
|
|
|
V |
|
|
N |
NX0_OBSREV |
M |
8 |
0 |
OBS Revisor |
|
|
|
R |
|
|
S |
NX0_OBSRED |
M |
10 |
0 |
Obs Redator |
|
|
|
R |
|
|
S |
NX0_DIDIO |
C |
100 |
0 |
Desc Idi Rel |
|
|
|
V |
|
|
S |
NX0_DUSRAL |
C |
30 |
0 |
Nm Usr Alter |
|
|
|
V |
|
|
S |
NX0_USRCAN |
C |
6 |
0 |
Cod Usr Canc |
|
|
|
R |
|
|
S |
NX0_DUSRCA |
C |
30 |
0 |
Nm Part Canc |
|
|
|
V |
|
|
S |
NX0_VLFATF |
N |
16 |
2 |
Valor Fixo |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
NX0_VLFATT |
N |
16 |
2 |
Valor Tab |
@E 9,999,999,999,999.99 |
|
|
R |
|
|
S |
NX0_RELPRE |
C |
4 |
0 |
Cod Rel Pre |
|
|
NZO |
R |
|
|
N |
NX0_DRELPR |
C |
50 |
0 |
Desc Rel Pre |
|
|
|
V |
|
|
N |
NX0_PONUMB |
C |
100 |
0 |
PO Number |
|
|
|
R |
|
|
S |
NX0_SERVIC |
M |
10 |
0 |
Frase Servic |
|
|
|
R |
|
|
S |
NX0_FATURA |
C |
1 |
0 |
PF Faturada? |
|
Vazio().Or. Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
NX0_TPSERV |
C |
2 |
0 |
Tipo Servico |
@! |
|
DZ |
R |
|
|
S |