| # Mapping Table for Employees (bcmtc1114m000) Используйте этот сеанс чтобы specify unique codes for Employees. Also the start day of employment should be specified for each employee. Подготовка Before you can use this session, employee codes from MANMAN/HP should be loaded into this table. It is not possible to create employee codes in this session manually. Выполнение Always mandatory because duplicates are not allowed. Логика процесса There are four sources in MANMAN/HP that are used to fill the mapping table. These sources are: MANDB.WCFIL (Work Center/Employee Master File) MANDB.IM (Item Master File) FINDB.SALMAS (Sales Agent Master File) PURDB.PRAFIL (Purchase Requisition Approvers) - MANDB.WCFIL is the normal employee table in MANMAN/HP - MANDB.IM is needed for the Закупщик field in ERP LN 6.1. - FINDB.SALMAS is needed for the Работник field in ERP LN 6.1. - PURDB.PRAFIL is needed for the УтвЛицо field in ERP LN 6.1. Next to that a backflush employee is created during migration. This is done based on a parameter in session Conversion Parameters for Manufacturing (bcmti1100s000). The option “Generate Defaults” will generate a default value for the field ERP LN 6.1 Employee.The default value for this field is based on the first six characters of the MANMAN/HP field. Note: if the source field contains the character “ | ” or “ ‘ ”, then this character is replaced by “ - ”. The option "Validate" will check if all mandatory fields are filled and if no duplicates exists on field ERP LN 6.1 Employee. It will create a report when errors are detected. MANMAN Origin MANMAN Origin Допустимые значения Employee (bcmtc.mori.wcfil) Sales Agent (bcmtc.mori.salmas) Buyer / Planner (bcmtc.mori.im) Approver (bcmtc.mori.approver) Not Applicable (bcmtc.mori.not.appl) - Employee -> This value is used for fields that are derived from table MANDB.WCFIL (Work Center/Employee Master File) in MANMAN/HP. - Sales Agent -> This value is used for fields that are derived from table FINDB.SALMAS (Sales Agent Master File) in MANMAN/HP. - Buyer -> This value is used for fields that are derived from table MANDB.IM (Item Master File) in MANMAN/HP. - Not Applicable -> This value is used for fields that are derived from table bcmti100. Значение по умолчанию - Employee (bcmtc.mori.wcfil) MANMAN Employee Employee Значение по умолчанию Loaded from MANMAN/HP. Depending on the origin the value is loaded from: Table MANDB.WCFIL, field WC, Table FINDB.SALMAS, field SALNUM Table MANDB.IM, field BCODE Table PURDB.PRAFIL, field PRALOGN Table bcmti100, field bcmti100.bfem ERP LN 6.1 Employee ERP LN 6.1 Допустимые значения Any alpha-numeric string with length up to six characters. The field must be filled and must be unique. Значение по умолчанию The default value for this field is based on the first six characters of the MANMAN/HP field. Примечание If the source field contains the character “ | ” or “ ‘ ”, then this character is replaced by “ - ”. The option "Validate" will check if all mandatory fields are filled and if no duplicates exists on field ERP LN 6.1 Late Payment Surcharge (bcmtc111.bcrs). It will create a report when errors are detected. ERP LN 6.1 Start Date of Employment Start Date of Employment . Any date is allowed. Значение по умолчанию The default value for this field is 03-Jan-1970 Generate Defaults Click Generate Defaults in case you want to fill the fields with default values. If some fields are already filled, you will be asked if they may be overwritten with the defautl values. It is not mandatory to run the generate defaults, it is just convenient. Validate Click Validate to check references, duplicates and if all mandatory fields are filled. A so called integrity check of the supplied data. It is mandatory to run validate. |