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

Tabela 2410 SYB

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

Salve salve, blz?

 

 

Tabela SYB. #SYB

 

 

 

 

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
SYB DATA SYB990 Despesas Gastos Expenditure C E E 0 YB_FILIAL+YB_DESP N 17 YB_DESP+YB_DESCR EICA110 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
SYB 01 YB_FILIAL C 2 0 Filial Filial do Sistema 1 N 033
SYB 02 YB_DESP C 3 0 Despesa Despesa @R 9.99 ExistChav("SYB",M->YB_DESP) .AND. EA110Valid() 1 S lNaoAltera 1
SYB 03 YB_DESCR C 30 0 Descricao Descricao @! 1 S 1
SYB 04 YB_IDVL C 1 0 Tipo Tipo @! Pertence('12345') .and. EA110Valid() '1' 1 N 1=Valor;2=Percentual;3=Quantidade;4=Peso;5=Container lNaoAltera 1
SYB 05 YB_IDVLDES C 30 0 Tipo Calculo Descricao de Valor ou % @! 1 N V V lNaoAltera EA110Valid("BROWSE") 1
SYB 06 YB_PERCAPL N 8 4 % Aplicado % Aplicado @E 999.9999 Positivo() .and. EA110Valid() 1 S EA110WHEN('YB_PERCAPL') 1
SYB 07 YB_DESPBAS C 9 0 Despesa Base Despesa Base @R 9.99/9.99/9.99 EA110Valid() 1 N A R EA110WHEN('YB_DESPBAS') 1
SYB 08 YB_MOEDA C 3 0 Moeda Moeda @! EA110Valid() "R$" SYF 1 S EA110WHEN('YB_MOEDA') 1
SYB 09 YB_VALOR N 12 2 Valor Valor @E 999,999,999.99 Positivo() .and. EA110Valid() 1 S lNaoAltera 1
SYB 10 YB_QTDEDIA N 5 0 Qtde Dias Qtde Dias da Data Entrega 99999 EA110Valid() 1 N EA110WHEN('YB_QTDEDIA') 1
SYB 11 YB_RAT_FAT C 1 0 Rat_fat Rat_fat @! 1 N lNaoAltera 1
SYB 12 YB_OCORREN C 1 0 Ocorrencia Ocorrencia:=Pedido/Embar. ! Pertence("12") "1" 1 N A R 1=Pedido;2=Embarque lNaoAltera 1
SYB 62 YB_TXCV C 1 0 Tx.Vda/Comp. Taxa Venda/Compra Pertence('12') '1' 1 S A R 1=Venda;2=Compra 1
SYB 63 YB_NATURE C 4 0 Natureza Natureza @! 1 S A 1
SYB 64 YB_TPTIT C 3 0 Tipo Fina. Tipo titulos Financeiro @! 1 S A R 1
SYB 66 YB_BIPINFT C 1 0 Base IPI NFT Desp Base de IPI para NFT 1 S A R 1=Sim;2=Nao 1
SYB 67 YB_CON20 N 16 2 Valor 20' Valor 20' @E 9,999,999,999,999.99 EA110Valid() 1 N A R EA110WHEN('YB_CON20') 1
SYB 68 YB_CON40 N 16 2 Valor 40' Valor 40' @E 9,999,999,999,999.99 EA110Valid() 1 N A R EA110WHEN('YB_CON40') 1
SYB 69 YB_CON40H N 16 2 Valor 40' HC Valor 40' HC @E 9,999,999,999,999.99 EA110Valid() 1 N A R EA110WHEN('YB_CON40H') 1
SYB 70 YB_CONOUT N 16 2 Valor Outros Valor Outros @E 9,999,999,999,999.99 EA110Valid() 1 N A R EA110WHEN('YB_CONOUT') 1
SYB 71 YB_GERPRO C 1 0 Gerar Prov.? Gerar Prov.? EA110Valid() 1 N A R 1=Somente PR;2=Somente PRE;3=PR e PRE;4=Não gerar EA110WHEN('YB_GERPRO') 1
SYB 72 YB_TOTNFT C 1 0 Total NFT Total NFT? @! "1" 1 S A 1= Sim;2= Não 1
SYB 37 YB_ICMS_CE C 1 0 ICMS CE ? ICMS CE ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 38 YB_ICMS_DF C 1 0 ICMS DF ? ICMS DF ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 39 YB_ICMS_ES C 1 0 ICSM ES ? ICSM ES ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 40 YB_ICMS_GO C 1 0 ICMS GO ? ICMS GO ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 41 YB_ICMS_MA C 1 0 ICMS MA ? ICMS MA ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 42 YB_ICMS_MG C 1 0 ICMS MG ? ICMS MG ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 43 YB_ICMS_MS C 1 0 ICMS MS ? ICMS MS ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 44 YB_ICMS_MT C 1 0 ICMS MT ? ICMS MT ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 45 YB_ICMS_PA C 1 0 ICMS PA ? ICMS PA ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 46 YB_ICMS_PB C 1 0 ICMS PB ? ICMS PB ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 47 YB_ICMS_PE C 1 0 ICMS PE ? ICMS PE ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 48 YB_ICMS_PI C 1 0 ICMS PI ? ICMS PI ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 49 YB_ICMS_PR C 1 0 ICMS PR ? ICMS PR ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 50 YB_ICMS_RJ C 1 0 ICMS RJ ? ICMS RJ ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 51 YB_ICMS_RN C 1 0 ICMS RN ? ICMS RN ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 52 YB_ICMS_RO C 1 0 ICMS RO ? ICMS RO ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 53 YB_ICMS_RR C 1 0 ICMS RR ? ICMS RR ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 54 YB_ICMS_RS C 1 0 ICMS RS ? ICMS RS ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 55 YB_ICMS_SC C 1 0 ICMS SC ? ICMS SC ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 56 YB_ICMS_SE C 1 0 ICMS SE ? ICMS SE ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 57 YB_ICMS_SP C 1 0 ICMS SP ? ICMS SP ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 58 YB_ICMS_TO C 1 0 ICMS TO ? ICMS TO ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 36 YB_ICMS_BA C 1 0 ICMS BA ? ICMS BA ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 35 YB_ICMS_AP C 1 0 ICMS AP ? ICMS AP ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 34 YB_ICMS_AM C 1 0 ICMS AM ? ICMS AM ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 33 YB_ICMS_AL C 1 0 ICMS AL ? ICMS AL ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 32 YB_ICMS_AC C 1 0 ICMS AC ? ICMS AC ? @! Pertence("12") "2" 1 S A R 1=Sim;2=Nao M->YB_BASEICM=="1" .OR. M->YB_ICMSNFC=="1" 2
SYB 31 YB_ICMSNFC C 1 0 ICMS na NFC? Cobra ICMS na NFC? @! Pertence("12") .AND. EA110Valid() 1 S A R 1=Sim;2=Nao EA110WHEN('YB_ICMSNFC') 1
SYB 30 YB_RATPESO C 1 0 Rateia Peso? Rateia Peso? @! Pertence("12") .AND. EA110Valid() "2" 1 S A R 1=Sim;2=Nao EA110WHEN('YB_RATPESO') 1
SYB 29 YB_BASEICM C 1 0 Base ICMS Base I.C.M.S.? @! Pertence("12") .and. A040valid("DESPESA") .AND. EA110Valid() 1 N 1=Sim;2=Nao EA110WHEN('YB_BASEICM') 1
SYB 28 YB_BASEIMP C 1 0 Base Imposto Base Imposto ? @! Pertence("12") .AND. EA110Valid() 1 S N 1=Sim;2=Nao EA110WHEN('YB_BASEIMP') 1
SYB 27 YB_BASECUS C 1 0 Base Custos Base Custos ? @! Pertence("12") .AND. EA110Valid() 1 N 1=Sim;2=Nao EA110WHEN('YB_BASECUS') 1
SYB 26 YB_VALOR6 N 15 7 Valor p/ Kg Valor por Kg @E 9,999,999.9999999 Positivo() 1 N EA110WHEN('YB_VALOR6') 1
SYB 25 YB_KILO6 N 14 5 6) Ate 6) Ate @E 99,999,999.99999 Positivo() 1 N EA110WHEN('YB_KILO6') 1
SYB 24 YB_VALOR5 N 15 7 Valor p/ Kg Valor por Kg @E 9,999,999.9999999 Positivo() 1 N EA110WHEN('YB_VALOR5') 1
SYB 23 YB_KILO5 N 14 5 5) Ate 5) Ate @E 99,999,999.99999 Positivo() 1 N EA110WHEN('YB_KILO5') 1
SYB 22 YB_VALOR4 N 15 7 Valor p/ Kg Valor por Kg @E 9,999,999.9999999 Positivo() 1 N EA110WHEN('YB_VALOR4') 1
SYB 21 YB_KILO4 N 14 5 4) Ate 4) Ate @E 99,999,999.99999 Positivo() 1 N EA110WHEN('YB_KILO4') 1
SYB 20 YB_VALOR3 N 15 7 Valor p/ Kg Valor por Kg @E 9,999,999.9999999 Positivo() 1 N EA110WHEN('YB_VALOR3') 1
SYB 19 YB_KILO3 N 14 5 3) Ate 3) Ate @E 99,999,999.99999 Positivo() 1 N EA110WHEN('YB_KILO3') 1
SYB 18 YB_VALOR2 N 15 7 Valor p/ Kg Valor por Kg @E 9,999,999.9999999 Positivo() 1 N EA110WHEN('YB_VALOR2') 1
SYB 17 YB_KILO2 N 14 5 2) Ate 2) Ate @E 99,999,999.99999 Positivo() 1 N EA110WHEN('YB_KILO2') 1
SYB 16 YB_VALOR1 N 15 7 Valor p/ Kg Valor por Kg @E 9,999,999.9999999 Positivo() 1 N EA110WHEN('YB_VALOR1') 1
SYB 15 YB_KILO1 N 14 5 1) Ate 1) Ate @E 99,999,999.99999 Positivo() 1 N EA110WHEN('YB_KILO1') 1
SYB 14 YB_VAL_MIN N 12 2 Valor Min. Valor Minimo @E 999,999,999.99 Positivo() .and. EA110Valid() 1 S EA110WHEN('YB_VAL_MIN') 1
SYB 13 YB_VAL_MAX N 12 2 Valor Max. Valor Maximo @E 999,999,999.99 Positivo() .and. EA110Valid() 1 S EA110WHEN('YB_VAL_MAX') 1
SYB 65 YB_PREFIX C 3 0 Prefixo Prefixo @! 1 S A
SYB 61 YB_ESPECIE C 6 0 Espec.Docum. Especie do documento @! Vazio() .or. ExistCpo("SX5","42"+M->YB_ESPECIE) 42 1
SYB 60 YB_PRODUTO C 15 0 Cod.Produto Codigo do produto @! ExistCpo("SB1") SB1 1 S A R 030
SYB 59 YB_EVENT C 3 0 Evento Evento @! E21 1 S

 

 

 

 

SIX - INDICES

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST
SYB 1 YB_FILIAL+YB_DESP Despesa Gasto Expense S S 2 3
SYB 2 YB_FILIAL+YB_DESCR Descricao Descripcion Description S S 2 3

 

 

 

 

SX7 - GATILHOS

X7_CAMPO X7_SEQUENC X7_REGRA X7_CDOMIN X7_TIPO X7_SEEK X7_ALIAS X7_ORDEM X7_CHAVE X7_CONDIC X7_PROPRI
YB_BASEIMP 001 '1' YB_BASECUS P N 0 M->YB_BASEIMP == '1' S

 

 

 

 

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
SYB 001 EIC YB_DESP EIC_DESPES S 1 1 S 2 2
SYB 002 EWG YB_DESP EWG_DESPES S 1 N S S 2 2
SYB 003 SWD YB_DESP WD_DESPESA S 1 N S 2 2
SYB 004 EET YB_DESP EET_DESPES S 1 N S S 2 2
SYB 005 EI9 YB_DESP EI9_DESP S 1 N S S 2 2
SYB 006 SWI YB_DESP WI_DESP S 1 N S S 2 2
SYB 007 EEU YB_DESP EEU_DESPES S 1 N S S 2 2

 

 

 

 

SXG - Grupo de Campos

XG_GRUPO XG_DESCRI XG_DESSPA XG_DESENG XG_SIZEMAX XG_SIZEMIN XG_SIZE XG_PICTURE
030 Tamanho do Produto Tamano del Producto Product Size 30 15 15 @!
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  

 

 

 

 

 

📰 Posts Relacionados

ASSINE A NEWSLETTER

Cadastrando...

PIX uDesenv

PIX QR Code para depósito

Clique para doar

Siga-nos

YouTube GitHub LinkedIn

Parceiros

Tudo em ADVPL - Blog parceiro

Blog ADVPL