EAS人员按照公司过滤
EAS在单据开发时,有个F7字段,引用的是职员,需要按照公司做过滤,EAS中的公司和财务组织是对应的,但和人员关系最近的是行政组织,通过财务组织的number等属性找到对应的行政组织和下级行政组织。基于此,我们对人员的按照公司过滤,可以按照行政组织过滤。
职员和行政组织的关系我们可以通过F7PersonQuery来看出:
?
SELECT?
?
"PERSON".FID AS "ID",?
"PERSON".FNumber AS "NUMBER",?
"PERSON".FName_l2 AS "NAME",?
"POSITION".FName_l2 AS "POSITION.NAME",?
"ADMINORGUNIT".FName_l2 AS "ADMINORGUNIT.NAME"
?
FROM T_BD_Person AS "PERSON"
?
INNER JOIN T_ORG_PositionMember AS "POSITIONMEMBER"
ON "PERSON".FID = "POSITIONMEMBER".FPersonID
?
INNER JOIN T_ORG_Position AS "POSITION"
ON "POSITIONMEMBER".FPositionID = "POSITION".FID
?
INNER JOIN T_ORG_Admin AS "ADMINORGUNIT"
ON "POSITION".FAdminOrgUnitID = "ADMINORGUNIT".FID