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