Histórico da Página

Tabelas que são relacionadas e necessitam de análise para realizar o compartilhamento:

Perfis:

F20, F21, F22, F23, F24, F25, F26 e CIO

Regras de calculo:

F27, F28, F29, F2B e CIN

Regra de Escrituração:

CJ2

(É necessário também analisar a SX5 - Tabela Genérica)

O compartilhamento das tabelas eventualmente poderá ser alterado se necessário, para melhor atender as configurações das regras dos tributos. As únicas tabelas que não poderão ter o modo de compartilhamento alterado são as tabelas F2D, F2F, F2H, F2I, F2J, F2K, F2L, F2M e CJ3.

Antes de aplicar compartilhamento é necessário entender o contexto na qual a companhia esta inserido.

SELECT F2D.F2D_VALURF AS F2DVALURF, F2B.F2B_TRIB AS F2BTRIB, F2D.F2D_IDCAD AS F2DIDCAD, F2D.F2D_FILIAL AS F2DFILIAL, F2D.F2D_IDREL AS F2DIDR, F2D.F2D_TRIB AS F2DTRIBUTO, F2D.F2D_BASE AS F2DBASE, 
                  F2D.F2D_ALIQ AS F2DALIQ, F2D.F2D_VALOR AS F2DVALOR, F2D.F2D_MVA AS F2DMVA, F2D.F2D_PAUTA AS F2DPAUTA, F2D.F2D_MAJORA AS F2DMAJORA, F2D.F2D_AUXMAJ AS F2DAUXMAJ, F2D.F2D_TRBMAJ AS F2DTRBMAJ, 
                  F2D.F2D_VALMAJ AS F2DVALMAJ, F2D.F2D_ALQMAJ AS F2DALQMAJ, F2D.F2D_DEDDEP AS F2DDEDDEP, F2D.F2D_BASQTD AS F2DBASQTD, F2C.F2C_CODIGO AS F2CCODIGO, F2C.F2C_DESC AS F2CDESC, 
                  CJ3.CJ3_FILIAL AS CJ3FILIAL, CJ3.CJ3_VLTRIB AS CJ3VALTRIB, CJ3.CJ3_CST AS CJ3CST, CJ3.CJ3_VLISEN AS CJ3VLISEN, CJ3.CJ3_VLOUTR AS CJ3VLOUTR, CJ3.CJ3_VLNTRI AS CJ3VLNTRI, CJ3.CJ3_VLDIFE AS CJ3VLDIFE, 
                  CJ3.CJ3_VLMAJO AS CJ3VLMAJO, CJ3.CJ3_PEMAJO AS CJ3PEMAJO, CJ3.CJ3_PEDIFE AS CJ3PEDIFE, CJ3.CJ3_PEREDU AS CJ3PEREDU, CJ3.CJ3_PAUTA AS CJ3PAUTA, CJ3.CJ3_MVA AS CJ3MVA, CJ3.CJ3_AUXMVA AS CJ3AUXMVA, 
                  CJ3.CJ3_AUXMAJ AS CJ3AUXMAJ, CJ3.CJ3_CSTCAB AS CJ3CSTCAB, CJ3.CJ3_BASORI AS CJ3BASORI, CJ3.CJ3_TRIB AS CJ3TRIB, CJ3.CJ3_CCT AS CJ3CCT, CJ3.CJ3_PREDAL AS CJ3PREDAL, CJ3.CJ3_ALIQOR AS CJ3ALIQO, 
                  F27.F27_CODIGO AS F27CODIGO, F27.F27_DESC AS F27DESC, F27.F27_VALORI AS F27VALORI, F27.F27_DESCON AS F27DESCON, F27.F27_FRETE AS F27FRETE, F27.F27_SEGURO AS F27SEGURO, F27.F27_DESPE AS F27DESPE, 
                  F27.F27_ICMDES AS F27ICMDES, F27.F27_ICMRET AS F27ICMRET, F27.F27_REDBAS AS F27REDBAS, F27.F27_TPRED AS F27TPRED, F27.F27_UM AS F27UM, BASE.CIN_ID AS BASEFID, BASE.CIN_CODIGO AS BASEFCOD, 
                  COALESCE (CAST(CAST(BASE.CIN_FORMUL AS VARBINARY(8000)) AS VARCHAR(8000)), ' ') AS BASEFOR, COALESCE (CAST(CAST(ALQ.CIN_FORMUL AS VARBINARY(8000)) AS VARCHAR(8000)), ' ') AS ALQFORM, 
                  F28.F28_CODIGO AS F28CODIGO, F28.F28_DESC AS F28DESC, F28.F28_VALORI AS F28VALORI, F28.F28_TPALIQ AS F28TPALIQ, F28.F28_ALIQ AS F28ALIQ, F28.F28_URF AS F28URF, F28.F28_UFRPER AS F28UFRPER, 
                  ALQ.CIN_ID AS ALQFID, ALQ.CIN_CODIGO AS ALQCOD, F28.F28_REDALI AS ALQREDALI, CJ2.CJ2_CODIGO AS CJ2CODIGO, CJ2.CJ2_DESCR AS CJ2DESCR, CJ2.CJ2_INCIDE AS CJ2INCIDE, CJ2.CJ2_STOTNF AS CJ2STOTNF, 
                  CJ2.CJ2_PERDIF AS CJ2PERDIF, CJ2.CJ2_IREDBS AS CJ2IREDBS, CJ2.CJ2_CST AS CJ2CST, CJ2.CJ2_CSTCAB AS CJ2CSTCAB, CJ2.CJ2_CSTDEV AS CJ2CSTDEV, CJ2.CJ2_CCT AS CJ2CCT, CJ2.CJ2_CSTCCT AS CJ2CSTCCT
FROM     F2DT10 AS F2D LEFT OUTER JOIN
                  CJ3T10 AS CJ3 ON CJ3.CJ3_FILIAL = 'X TSS17 ' AND CJ3.CJ3_IDF2D = F2D.F2D_ID AND CJ3.CJ3_IDTGEN = F2D.F2D_IDREL AND CJ3.D_E_L_E_T_ = ' ' INNER JOIN
                  F2BT10 AS F2B ON F2B.F2B_FILIAL = 'X TSS17 ' AND F2B.F2B_ID = F2D.F2D_IDCAD AND F2B.D_E_L_E_T_ = ' ' INNER JOIN
                  F2ET10 AS F2E ON F2E.F2E_FILIAL = ' ' AND F2E.F2E_TRIB = F2B.F2B_TRIB AND F2E.D_E_L_E_T_ = ' ' LEFT OUTER JOIN
                  F2CT10 AS F2C ON F2C.F2C_FILIAL = ' ' AND F2C.F2C_CODIGO = F2E.F2E_IDTRIB AND F2C.D_E_L_E_T_ = ' ' INNER JOIN
                  F27T10 AS F27 ON F27.F27_FILIAL = 'X TSS17 ' AND F27.F27_CODIGO = F2B.F2B_RBASE AND F27.F27_ALTERA IN ('2') AND F27.D_E_L_E_T_ = ' ' INNER JOIN
                  CINT10 AS BASE ON BASE.CIN_FILIAL = 'X TSS17 ' AND BASE.CIN_IREGRA = F27.F27_ID AND BASE.D_E_L_E_T_ = ' ' INNER JOIN
                  F28T10 AS F28 ON F28.F28_FILIAL = 'X TSS17 ' AND F28.F28_CODIGO = F2B.F2B_RALIQ AND F28.F28_ALTERA IN ('2') AND F28.D_E_L_E_T_ = ' ' INNER JOIN
                  CINT10 AS ALQ ON ALQ.CIN_FILIAL = 'X TSS17 ' AND ALQ.CIN_IREGRA = F28.F28_ID AND ALQ.D_E_L_E_T_ = ' ' LEFT OUTER JOIN
                  CJ2T10 AS CJ2 ON CJ2.CJ2_FILIAL = 'X TSS17 ' AND CJ2.CJ2_CODIGO = F2B.F2B_CODESC AND CJ2.CJ2_DTALT = ' ' AND CJ2.D_E_L_E_T_ = ' ' LEFT OUTER JOIN
                  CINT10 AS ESCRIT ON ESCRIT.CIN_FILIAL = 'X TSS17 ' AND ESCRIT.CIN_IREGRA = CJ2.CJ2_ID AND ESCRIT.D_E_L_E_T_ = ' '
WHERE  (F2D.F2D_IDREL IN ('8E28E3B0-3BA4-4011-8FD2-D8CB8AD27F39')) AND (F2D.F2D_DTEXCL = ' ') AND (F2D.D_E_L_E_T_ = ' ')