博客

select * from T_GL_VoucherEntry vouEntry             --凭证分录
where vouEntry.FBillID='ezZx/Wq4SnelVSQfqL5PnyZS4B4='--凭证ID

select * from T_BD_AccountView                       --科目
where fid ='IjpvZIbySIGxYxqXK7PbEp2pmCY='            --凭证分录FAccountID
select * from T_BD_AsstAccount                       --本级辅助帐类型(辅助帐)
where fid ='mRo/IgETEADgAEoMwKgSZUZaEPg='            --科目FCAA
select * from T_BD_AssistantHG                       --辅助帐横表
where FAsstAccountID='mRo/IgETEADgAEoMwKgSZUZaEPg='  --本级辅助帐类型(辅助帐)ID
and FProviderID='vRKZNQETEADgABDMwKgSZTfGffw='       --供应商ID
and FMaterialID='mRo/IgETEADgABCjwKgSZUQJ5/A='       --物料ID

select * from T_BD_AsstActGroupDetail                --辅助帐明细
where FAsstAccountID='mRo/IgETEADgAEoMwKgSZUZaEPg='  --本级辅助帐类型(辅助帐)ID
select 
FMappingFieldname                                    --在辅助帐横表里的字段名
from T_BD_AsstActType                                --核算项目
where fid ='YW3xsAEJEADgAAVEwKgTB0c4VZA='            --辅助帐明细FAsstActTypeID