П7. Колонки для провеки названия Счета и привязанного ШФ (шаблона финансирования)

=КБК (!)=
IIF (Left(AllT(vaccbase.account),17) ==
Left(AllT(GetTableField("ffunccl","code",GetTableField("fsbfbase","fkrr_rn",vAccBase.rn_tfin))),2)+
Right(AllT(GetTableField("ffunccl","code",GetTableField("fsbfbase","fkrpr_rn",vAccBase.rn_tfin))),2)+
AllT(GetTableField("bcelesta","code",GetTableField("fsbfbase","rn_csr",vAccBase.rn_tfin)))+
AllT(GetTableField("bexpkind","code",GetTableField("fsbfbase","rn_vidr",vAccBase.rn_tfin))), "", "==> (!)")

=СЧЕТ (!)=
IIF (SubSTR(AllT(vaccbase.account),18,11) ==
AllT(GetTableField("acbbase","acbount",vAccBase.rn_acb)), "", "==> (!)")

=АвтоГенСчет=
Left(AllT(GetTableField("ffunccl","code",GetTableField("fsbfbase","fkrr_rn",vAccBase.rn_tfin))),2)+
Right(AllT(GetTableField("ffunccl","code",GetTableField("fsbfbase","fkrpr_rn",vAccBase.rn_tfin))),2) +
AllT(GetTableField("bcelesta","code",GetTableField("fsbfbase","rn_csr",vAccBase.rn_tfin)))+
AllT(GetTableField("bexpkind","code",GetTableField("fsbfbase","rn_vidr",vAccBase.rn_tfin)))+
AllT(GetTableField("acbbase","acbount",vAccBase.rn_acb))