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

Tabela 2410 FN9

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

Salve salve, blz?

 

 

Tabela FN9. #FN9

 

 

 

 

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
FN9 DATA FN9990 Cabeçalho da Transferência Encabezado de transferencia Transfer Header C C C 0 FN9_FILIAL+FN9_IDMOV 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
FN9 01 FN9_FILIAL C 2 0 Filial Filial do Sistema 1 N A R 033 1
FN9 02 FN9_IDMOV C 6 0 ID do Mov. ID do Movimento @! ExistChav("FN9") 1 N V R 1
FN9 03 FN9_DATA D 8 0 Data do Mov. Data do Movimento dDataBase 1 N A R 1
FN9 04 FN9_FILDES C 2 0 Filial Dest. Filial de Destino ExistCpo( "SM0", cEmpAnt + M->FN9_FILDES ) SM0_01 1 N A V 033 1
FN9 05 FN9_GRPDES C 4 0 Grupo Dest. Grupo de Destino @! A060F3 1 N A V 1
FN9 06 FN9_LOCDES C 6 0 Local Dest. Local Destino do Bem @! A060F3 1 N A V 058 1
FN9 07 FN9_TXPADD C 6 0 Cod Tx Pad D Cod. da Taxa Padrão Dest. @! A060F3 1 N A V 1
FN9 08 FN9_CCDESD C 9 0 CC Desp Dest C Custo Despesa Destino @! AF060EXIFIL("CT1","","FN9","CCDESD",FN9_FILDES) A060F3 1 N A V CTBMovSaldo( "CTT" ) 004 1
FN9 36 FN9_QTDDES N 11 3 Quant. Dest. Quantidade Destino @E 9,999,999.999 1 N A V 1
FN9 09 FN9_CONTAD C 20 0 Ct Bem Dest Conta do Bem de Destino @! AF060EXIFIL("CT1","","FN9","CONTAD",FN9_FILDES) A060F3 1 N A V 003 2
FN9 10 FN9_CONCOD C 20 0 Ct Cor Mon D Conta Corr. Monet. Dest. @! AF060EXIFIL("CT1","","FN9","CONCOD",FN9_FILDES) A060F3 1 N A V 003 2
FN9 11 FN9_CONDDD C 20 0 Ct Des Dep D Conta Desp. Deprec. Dest. @! AF060EXIFIL("CT1","","FN9","CONDDD",FN9_FILDES) A060F3 1 N A V 003 2
FN9 12 FN9_CONDAD C 20 0 Ct Dep Acu D Conta Deprec Acumul Dest @! AF060EXIFIL("CT1","","FN9","CONDAD",FN9_FILDES) A060F3 1 N A V 003 2
FN9 13 FN9_CONCDD C 20 0 Ct Cor Dep D Conta Corr. Deprec. Dest. @! AF060EXIFIL("CT1","","FN9","CONCDD",FN9_FILDES) A060F3 1 N A V 003 2
FN9 14 FN9_CCBEMD C 9 0 CC Bem Dest C Custo do Bem Destino @! AF060EXIFIL("CTT","","FN9","CCBEMD",FN9_FILDES) A060F3 1 N A V CTBMovSaldo("CTT") 004 3
FN9 15 FN9_CCCORD C 9 0 CC Cor Mon D C Custo Corr Monet Dest @! AF060EXIFIL("CTT","","FN9","CCCORD",FN9_FILDES) A060F3 1 N A V CTBMovSaldo("CTT") 004 3
FN9 16 FN9_CCDDD C 9 0 CC Des Dep D C Custo Desp Deprec Dest @! AF060EXIFIL("CTT","","FN9","CCDDD",FN9_FILDES) A060F3 1 N A V CTBMovSaldo( "CTT" ) 004 3
FN9 17 FN9_CCDAD C 9 0 CC Dep Acu D C Custo Deprec Acumul Des @! AF060EXIFIL("CTT","","FN9","CCDAD",FN9_FILDES) A060F3 1 N A V CTBMovSaldo( "CTT" ) 004 3
FN9 18 FN9_CCCDD C 9 0 CC Cor Dep D C Custo Corr Deprec Dest @! AF060EXIFIL("CTT","","FN9","CCCDD",FN9_FILDES) A060F3 1 N A V CTBMovSaldo( "CTT" ) 004 3
FN9 19 FN9_ITBEMD C 9 0 It Bem Dest Item Contábil do Bem Dest @! AF060EXIFIL("CTD","","FN9","ITBEMD",FN9_FILDES) A060F3 1 N A V CTBMovSaldo("CTD") 005 4
FN9 20 FN9_ITCORD C 9 0 It Cor Mon D Item Corr. Monet. Dest. @! AF060EXIFIL("CTD","","FN9","ITCORD",FN9_FILDES) A060F3 1 N A V CTBMovSaldo( "CTD" ) 005 4
FN9 21 FN9_ITDEDD C 9 0 It Des Dep D Item Desp. Deprec. Dest. @! AF060EXIFIL("CTD","","FN9","ITDEDD",FN9_FILDES) A060F3 1 N A V CTBMovSaldo( "CTD" ) 005 4
FN9 22 FN9_ITDEAD C 9 0 It Dep Acu D Item Deprec Acumul Dest @! AF060EXIFIL("CTD","","FN9","ITDEAD",FN9_FILDES) A060F3 1 N A V CTBMovSaldo( "CTD" ) 005 4
FN9 23 FN9_ITCDED C 9 0 It Cor Dep D Item Corr. Deprec. Dest. @! AF060EXIFIL("CTD","","FN9","ITCDED",FN9_FILDES) A060F3 1 N A V CTBMovSaldo( "CTD" ) 005 4
FN9 38 FN9_ITDESD C 9 0 IT Desp Dest Item Despesa Dest @! AF060EXIFIL("CTD","","FN9","ITDESD",FN9_FILDES) A060F3 1 N A V CTBMovSaldo("CTD") 005 4
FN9 24 FN9_CVBEMD C 9 0 CV Bem Dest Classe de Val do Bem Dest @! AF060EXIFIL("CTH","","FN9","CVBEMD",FN9_FILDES) A060F3 1 N A V CTBMovSaldo( "CTH" ) 006 5
FN9 25 FN9_CVCORD C 9 0 CV Cor Mon D Cl Vl Corr. Monet. Dest. @! AF060EXIFIL("CTH","","FN9","CVCORD",FN9_FILDES) A060F3 1 N A V CTBMovSaldo( "CTH" ) 006 5
FN9 26 FN9_CVDEPD C 9 0 CV Des Dep D Cl Vl Desp. Deprec. Dest. @! AF060EXIFIL("CTH","","FN9","CVDEPD",FN9_FILDES) A060F3 1 N A V CTBMovSaldo( "CTH" ) 006 5
FN9 27 FN9_CVCDED C 9 0 CV Dep Acu D Cl Vl Deprec Acumul Dest @! AF060EXIFIL("CTH","","FN9","CVCDED",FN9_FILDES) A060F3 1 N A V CTBMovSaldo( "CTH" ) 006 5
FN9 28 FN9_CVDESD C 9 0 CV Cor Dep D Cl Vl Corr. Deprec. Dest. @! AF060EXIFIL("CTH","","FN9","CVDESD",FN9_FILDES) A060F3 1 N A V CTBMovSaldo("CTH") 006 5
FN9 29 FN9_GERNF C 1 0 Gera NF Gera Nota Fiscal Pertence('1|2') .And. AF060VldNF() "2" 1 N A V 1=Sim;2=Não 6
FN9 30 FN9_SERIE C 3 0 Serie Serie da Nota Fiscal @! 01 1 N A V FN9_GERNF =="1" 6
FN9 31 FN9_CLSNF C 1 0 Class NF Classificação NF Pertence('1|2') 1 N A V 1=A Classificar;2=Classificada FN9_GERNF == "1" 6
FN9 32 FN9_TESSAI C 3 0 TES Saída TES de Saída Vazio() .Or. AF060VTES() SF4 1 N A V FN9_GERNF == '1' 6
FN9 33 FN9_TESENT C 3 0 TES Entrada TES de Entrada Vazio() .Or. AF060VTES() A060F3 1 N A V FN9_GERNF == "1" 6
FN9 34 FN9_VALNF N 14 2 Valor da NF Valor da Nota Fiscal @E 99,999,999,999.99 Vazio() .Or. Positivo() 1 N A V FN9_GERNF == "1" 6
FN9 35 FN9_ESPECI C 5 0 Espécie NF Espécie Nota Fiscal Ent @! 42 1 S A V 6
FN9 37 FN9_ARMAZE C 2 0 Armazem Armazem Estoque Destino @! A060F3 1 A V FN9_GERNF =="1" 024 6
FN9 39 FN9_CVDSPD C 9 0 CV Desp Dest Classe de Val Desp Dest @! AF060EXIFIL("CTH","","FN9","CVDSPD",FN9_FILDES) A060F3 1 N A V CTBMovSaldo( "CTH" ) 006 5
FN9 40 FN9_TRANSP C 6 0 Transp. Codigo da Transportadora @X vazio() .or. existcpo("SA4") SA4 1 N A V 7
FN9 41 FN9_TPFRET C 1 0 Tipo Frete Tipo do Frete Utilizado X pertence("CFTRDS") 1 N A V C=CIF;F=FOB;T=Por conta terceiros;R=Por conta remetente;D=Por conta destinatario;S=Sem frete 7
FN9 42 FN9_PESOL N 11 4 Peso Liquido Peso Liquido @E 999,999.9999 positivo() .or. vazio() 1 N A V 7
FN9 43 FN9_PBRUTO N 11 4 Peso Bruto Peso Bruto @E 999,999.9999 positivo() .or. vazio() 1 N A V 7
FN9 44 FN9_VOLUM1 N 5 0 Volume 1 Qtde de Volumes tipo 1 99999 positivo() .or. vazio() 1 N A V 7
FN9 45 FN9_ESPEC1 C 10 0 Especie 1 Especie do Volume tipo 1 @X 1 N A V 7
FN9 46 FN9_VEICU1 C 8 0 Veiculo 1 Veiculo do Transporte 1 @! Vazio().Or.ExistCPO("DA3") DA3 1 N A V 7

 

 

 

 

SIX - INDICES

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST
FN9 1 FN9_FILIAL+FN9_IDMOV ID do Mov. ID del Mov. Transctn ID S S 2 3

 

 

 

 

SX9 - Relacionamento entre Tabelas

X9_DOM X9_IDENT X9_CDOM X9_EXPDOM X9_EXPCDOM X9_PROPRI X9_LIGDOM X9_LIGCDOM X9_CONDSQL X9_USEFIL X9_ENABLE X9_VINFIL X9_CHVFOR
FN9 001 FNR FN9_IDMOV FNR_IDMOV S 1 N S 2 2

 

 

 

 

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 @!
024 Código de Armazém Codigo de Almacen Warehouse Code 6 2 2 @!
033 Tamanho da Filial Tamano de la Sucursal Branch Size 12 2 2
058 Local do bem Local del bien Asset Location 12 6 6 @!

 

 

 

 

 

 

 

 

 

 

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