Ajude o site desativando o bloqueador de anúncio
Cabeçalho

Tabela 2410 FNS

Autor: Eurai Criado: 01/03/2025 Atualizado: 01/03/2025 Protheus
Postagem

Salve salve, blz?

 

 

Tabela FNS. #FNS

 

 

 

 

SX2 - TABELA

X2_CHAVE X2_PATH X2_ARQUIVO X2_NOME X2_NOMESPA X2_NOMEENG X2_ROTINA X2_MODO X2_MODOUN X2_MODOEMP X2_DELET X2_TTS X2_UNICO X2_PYME X2_MODULO X2_DISPLAY X2_SYSOBJ X2_USROBJ X2_POSLGT X2_CLOB X2_AUTREC X2_TAMFIL X2_TAMUN X2_TAMEMP X2_STAMP X2_INSDT
FNS SYSTEM FNS990 Tipos de Saldo Transferidos Tipos de saldo transferidos Transferred Balance Types E E E 0 FNS_FILIAL+FNS_IDMOV+FNS_CODREL+FNS_TIPO+FNS_SEQ S 1 1 2 2 2 0 0

 

 

 

 

SX3 - CAMPOS

X3_ARQUIVO X3_ORDEM X3_CAMPO X3_TIPO X3_TAMANHO X3_DECIMAL X3_TITULO X3_DESCRIC X3_PICTURE X3_VALID X3_RELACAO X3_F3 X3_NIVEL X3_TRIGGER X3_BROWSE X3_VISUAL X3_CONTEXT X3_OBRIGAT X3_CBOX X3_PICTVAR X3_WHEN X3_INIBRW X3_GRPSXG X3_FOLDER
FNS 01 FNS_FILIAL C 2 0 Filial Filial do Sistema 1 N V R 033
FNS 53 FNS_CVDESD C 9 0 CV Cor Dep D Cl Vl Corr. Deprec. Dest. @! AF060EXIFIL("CTH","","FNS","CVDESD",FWFldGet("FNR_FILDES")) A060F3 1 N A R CTBMovSaldo( "CTH" ) 006 5
FNS 52 FNS_CVDESO C 9 0 CV Cor Dep O Cl Vl Corr. Deprec. Orig. @! 1 N V R 006 5
FNS 51 FNS_CVCDED C 9 0 CV Dep Acu D Cl Vl Deprec Acumul Dest @! AF060EXIFIL("CTH","","FNS","CVCDED",FWFldGet("FNR_FILDES")) A060F3 1 N A R CTBMovSaldo( "CTH" ) 006 5
FNS 50 FNS_CVCDEO C 9 0 CV Dep Acu O Cl Vl Deprec Acumul Orig @! 1 N V R 006 5
FNS 49 FNS_CVDEPD C 9 0 CV Des Dep D Cl Vl Desp. Deprec. Dest. @! AF060EXIFIL("CTH","","FNS","CVDEPD",FWFldGet("FNR_FILDES")) A060F3 1 N A R CTBMovSaldo( "CTH" ) 006 5
FNS 48 FNS_CVDEPO C 9 0 CV Des Dep O Cl Vl Desp. Deprec. Orig. @! 1 N V R CTBMovSaldo( "CTH" ) 006 5
FNS 47 FNS_CVCORD C 9 0 CV Cor Mon D Cl Vl Corr. Monet. Dest. @! AF060EXIFIL("CTH","","FNS","CVCORD",FWFldGet("FNR_FILDES")) A060F3 1 N A R CTBMovSaldo( "CTH" ) 006 5
FNS 46 FNS_CVCORO C 9 0 CV Cor Mon O Cl Vl Corr. Monet. Orig. @! 1 N V R CTBMovSaldo( "CTH" ) 006 5
FNS 45 FNS_CVDSPD C 9 0 CV Desp Dest Classe de Val Despesa Des @! AF060EXIFIL("CTH","","FNS","CVDSPD",FWFldGet("FNR_FILDES")) A060F3 1 N A R CTBMovSaldo("CTH") 006 5
FNS 44 FNS_CVDSPO C 9 0 CV Desp Orig Classe de Val Desp Orig @! 1 N V R 006 5
FNS 43 FNS_CVBEMD C 9 0 CV Bem Dest Classe de Val do Bem Dest @! AF060EXIFIL("CTH","","FNS","CVBEMD",FWFldGet("FNR_FILDES")) A060F3 1 N A R CTBMovSaldo( "CTH" ) 006 5
FNS 42 FNS_CVBEMO C 9 0 CV Bem Orig Classe de Val do Bem Orig @! 1 N V R CTBMovSaldo( "CTH" ) 006 5
FNS 41 FNS_ITCDED C 9 0 It Cor Dep D Item Corr. Deprec. Dest. @! AF060EXIFIL("CTD","","FNS","ITCDED",FWFldGet("FNR_FILDES")) A060F3 1 N A R CTBMovSaldo( "CTD" ) 005 4
FNS 40 FNS_ITCDEO C 9 0 It Cor Dep O Item Corr. Deprec. Orig. @! 1 N V R CTBMovSaldo( "CTD" ) 005 4
FNS 39 FNS_ITDEAD C 9 0 It Dep Acu D Item Deprec Acumul Dest @! AF060EXIFIL("CTD","","FNS","ITDEAD",FWFldGet("FNR_FILDES")) A060F3 1 N A R CTBMovSaldo( "CTD" ) 005 4
FNS 38 FNS_ITDEAO C 9 0 It Dep Acu O Item Deprec Acumul Orig @! 1 N V R CTBMovSaldo( "CTD" ) 005 4
FNS 37 FNS_ITDEDD C 9 0 It Des Dep D Item Desp. Deprec. Dest. @! AF060EXIFIL("CTD","","FNS","ITDEDD",FWFldGet("FNR_FILDES")) A060F3 1 N A R CTBMovSaldo( "CTD" ) 005 4
FNS 36 FNS_ITDEDO C 9 0 It Des Dep O Item Desp. Deprec. Orig. @! 1 N V R CTBMovSaldo( "CTD" ) 005 4
FNS 35 FNS_ITCORD C 9 0 It Cor Mon D Item Corr. Monet. Dest. @! AF060EXIFIL("CTD","","FNS","ITCORD",FWFldGet("FNR_FILDES")) A060F3 1 N A R CTBMovSaldo( "CTD" ) 005 4
FNS 34 FNS_ITCORO C 9 0 It Cor Mon O Item Corr. Monet. Orig. @! 1 N V R 005 4
FNS 33 FNS_ITDESD C 9 0 IT Desp Dest Item Despesa Dest @! AF060EXIFIL("CTD","","FNS","ITDESD",FWFldGet("FNR_FILDES")) A060F3 1 N A R CTBMovSaldo("CTD") 005 4
FNS 32 FNS_ITDESO C 9 0 IT Desp Orig Item Despesa Orig @! 1 N V R 005 4
FNS 31 FNS_ITBEMD C 9 0 It Bem Dest Item Contábil do Bem Dest @! AF060EXIFIL("CTD","","FNS","ITBEMD",FWFldGet("FNR_FILDES")) A060F3 1 N A R CTBMovSaldo( "CTD" ) 005 4
FNS 30 FNS_ITBEMO C 9 0 It Bem Orig Item Contábil do Bem Orig @! 1 N V R 005 4
FNS 29 FNS_CCCDD C 9 0 CC Cor Dep D C Custo Corr Deprec Dest @! AF060EXIFIL("CTT","","FNS","CCCDD",FWFldGet("FNR_FILDES")) A060F3 1 N A R CTBMovSaldo( "CTT" ) 004 3
FNS 28 FNS_CCCDO C 9 0 CC Cor Dep O C Custo Corr Deprec Orig @! 1 N V R CTBMovSaldo( "CTT" ) 004 3
FNS 27 FNS_CCDAD C 9 0 CC Dep Acu D C Custo Deprec Acumul Des @! AF060EXIFIL("CTT","","FNS","CCDAD",FWFldGet("FNR_FILDES")) A060F3 1 N A R CTBMovSaldo( "CTT" ) 004 3
FNS 26 FNS_CCDAO C 9 0 CC Dep Acu O C Custo Deprec Acumul Ori @! 1 N V R CTBMovSaldo( "CTT" ) 004 3
FNS 25 FNS_CCDDD C 9 0 CC Des Dep D C Custo Desp Deprec Dest @! AF060EXIFIL("CTT","","FNS","CCDDD",FWFldGet("FNR_FILDES")) A060F3 1 N A R CTBMovSaldo( "CTT" ) 004 3
FNS 24 FNS_CCDDO C 9 0 CC Des Dep O C Custo Desp Deprec Orig @! 1 N V R CTBMovSaldo( "CTT" ) 004 3
FNS 23 FNS_CCCORD C 9 0 CC Cor Mon D C Custo Corr Monet Dest @! AF060EXIFIL("CTT","","FNS","CCCORD",FWFldGet("FNR_FILDES")) A060F3 1 N A R CTBMovSaldo( "CTT" ) 004 3
FNS 22 FNS_CCCORO C 9 0 CC Cor Mon O C Custo Corr Monet Orig @! 1 N V R 004 3
FNS 21 FNS_CCBEMD C 9 0 CC Bem Dest C Custo do Bem Destino @! AF060EXIFIL("CTT","","FNS","CCBEMD",FWFldGet("FNR_FILDES")) A060F3 1 N A R CTBMovSaldo( "CTT" ) 004 3
FNS 20 FNS_CCBEMO C 9 0 CC Bem Orig C Custo do Bem Origem @! 1 N V R CTBMovSaldo( "CTT" ) 004 3
FNS 19 FNS_CONCDD C 20 0 Ct Cor Dep D Conta Corr. Deprec. Dest. @! AF060EXIFIL("CT1","","FNS","CONCDD",FWFldGet("FNR_FILDES")) A060F3 1 N A R 003 2
FNS 18 FNS_CONCDO C 20 0 Ct Cor Dep O Conta Corr. Deprec. Orig. @! 1 N V R 003 2
FNS 17 FNS_CONDAD C 20 0 Ct Dep Acu D Conta Deprec Acumul Dest @! AF060EXIFIL("CT1","","FNS","CONDAD",FWFldGet("FNR_FILDES")) A060F3 1 N A R 003 2
FNS 16 FNS_CONDAO C 20 0 Ct Dep Acu O Conta Deprec Acumul Orig @! 1 N V R 003 2
FNS 15 FNS_CONDDD C 20 0 Ct Des Dep D Conta Desp. Deprec. Dest. @! AF060EXIFIL("CT1","","FNS","CONDDD",FWFldGet("FNR_FILDES")) A060F3 1 N A R 003 2
FNS 14 FNS_CONDDO C 20 0 Ct Des Dep O Conta Desp. Deprec. Orig. @! 1 N V R 003 2
FNS 13 FNS_CONCOD C 20 0 Ct Cor Mon D Conta Corr. Monet. Dest. @! AF060EXIFIL("CT1","","FNS","CONCOD",FWFldGet("FNR_FILDES")) A060F3 1 N A R 003 2
FNS 12 FNS_CONCOO C 20 0 Ct Cor Mon O Conta Corr. Monet. Orig. @! 1 N V R 003 2
FNS 11 FNS_CONTAD C 20 0 Ct Bem Dest Conta do Bem de Destino @! AF060EXIFIL("CT1","","FNS","CONTAD",FWFldGet("FNR_FILDES")) A060F3 1 N A R 003 2
FNS 10 FNS_CONTAO C 20 0 Ct Bem Orig Conta do Bem de Origem @! 1 N V R 003 2
FNS 09 FNS_CCDESD C 9 0 CC Desp Dest C Custo Despesa Destino @! AF060EXIFIL("CTT","","FNS","CCDESD",FWFldGet("FNR_FILDES")) A060F3 1 N A R CTBMovSaldo( "CTT" ) 004 1
FNS 08 FNS_CCDESO C 9 0 CC Desp Orig C Custo Despesa Origem @! 1 N V R 004 1
FNS 07 FNS_HISTOR C 40 0 Historico Historico @! 1 N V V 1
FNS 06 FNS_SEQ C 3 0 Seq. Aquisi. Sequencia de Aquisicao @9 1 N V R 1
FNS 05 FNS_TIPO C 2 0 Tipo Ativo Tipo do Ativo @9 1 N V R 1
FNS 04 FNS_CODREL C 6 0 Cod. Rel. Cod. Relelacionamento @! 1 N V R 1
FNS 03 FNS_DATA D 8 0 Data Mov Data de Movimento AF060EXIFIL("","","FNS","DATA",FWFldGet("FNS_DATA")) dDataBase 1 N A R 1
FNS 02 FNS_IDMOV C 6 0 ID Mov ID Movimento @! 1 N V R

 

 

 

 

SIX - INDICES

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST
FNS 1 FNS_FILIAL+FNS_IDMOV+FNS_CODREL+FNS_TIPO+FNS_SEQ ID Mov + Cod. Rel. + Tipo Ativo + Seq. Aquisi. ID Mov + Cód. Rel. + Tipo Activo + Sec. Adquis. Move ID + Rel Code + Asset Type + Purch Seq S S 2 3
FNS 2 FNS_FILIAL+FNS_CCCDD CC Cor Dep D CC Cor Dep D T Dep Cor CC S S 2 3
FNS 3 FNS_FILIAL+FNS_CCCDO CC Cor Dep O CC Cor Dep O S Dep Cor CC S S 2 3
FNS 4 FNS_FILIAL+FNS_CCCORD CC Cor Mon D CC Cor Mon D T Ind Cor CC S S 2 3
FNS 5 FNS_FILIAL+FNS_CCCORO CC Cor Mon O CC Cor Mon O O IndexatnCC S S 2 3
FNS 6 FNS_FILIAL+FNS_CCDAD CC Dep Acu D CC Dep Acu D D AccrDeprCC S S 2 3
FNS 7 FNS_FILIAL+FNS_CCDAO CC Dep Acu O CC Dep Acu O O AccrDeprCC S S 2 3
FNS 8 FNS_FILIAL+FNS_CCDDO CC Des Dep O CC Gas Dep O O DepExp CC S S 2 3
FNS 9 FNS_FILIAL+FNS_CCDESD CC Desp Dest CC Gasto Des D Expense CC S S 2 3
FNS A FNS_FILIAL+FNS_CCDESO CC Desp Orig CC Gast Orig O Expense CC S S 2 3
FNS B FNS_FILIAL+FNS_CONCDD Ct Cor Dep D Ct Cor Dep D D DeprCorrAc S S 2 3
FNS C FNS_FILIAL+FNS_CONCDO Ct Cor Dep O Ct Cor Dep O O DeprCorrAc S S 2 3
FNS D FNS_FILIAL+FNS_CONCOD Ct Cor Mon D Ct Cor Mon D D Indextn Ac S S 2 3
FNS E FNS_FILIAL+FNS_CONCOO Ct Cor Mon O Ct Cor Mon O O Indextn Ac S S 2 3
FNS F FNS_FILIAL+FNS_CONDAD Ct Dep Acu D Ct Dep Acu D D AccrDeprAc S S 2 3
FNS G FNS_FILIAL+FNS_CONDAO Ct Dep Acu O Ct Dep Acu O O AccrDeprAc S S 2 3
FNS H FNS_FILIAL+FNS_CONDDD Ct Des Dep D Ct Gas Dep D D Dep Exp Ac S S 2 3
FNS I FNS_FILIAL+FNS_CONDDO Ct Des Dep O Ct Gas Dep O O Dep Exp Ac S S 2 3
FNS J FNS_FILIAL+FNS_CONTAD Ct Bem Dest Ct Bien Dest D Asset Acct S S 2 3
FNS K FNS_FILIAL+FNS_CONTAO Ct Bem Orig Ct Bien Orig Src AsstAcct S S 2 3
FNS L FNS_FILIAL+FNS_CCBEMD CC Bem Dest CC Bien Dest Trgt AssetCC S S 2 3
FNS M FNS_FILIAL+FNS_CCBEMO CC Bem Orig CC Bien Orig SrcAsset CC S S 2 3

 

 

 

 

SXG - Grupo de Campos

XG_GRUPO XG_DESCRI XG_DESSPA XG_DESENG XG_SIZEMAX XG_SIZEMIN XG_SIZE XG_PICTURE
003 Conta Contabil Cuenta Contable Ledger Account 70 20 20 @!
004 Centro de Custo Centro de Costo Cost Center 20 9 9 @!
005 Item Contabil Item Contable Accounting Item 20 9 9 @!
006 Classe de Valor Clase de Valor Value Class 20 9 9 @!
033 Tamanho da Filial Tamano de la Sucursal Branch Size 12 2 2

 

 

 

 

 

 

 

 

 

 

Gostou? Compartilhe com seus amigos e deixe um comentário! ??

Um abraço, e até a próxima  

 

 

 

 

 

ASSINE A NEWSLETTER

Cadastrando...

PIX uDesenv

PIX QR Code para depósito

Clique para doar

Parceiros

Tudo em ADVPL - Blog parceiro

Blog ADVPL