| # Conversion table for States/Provinces (bcmtc1122m000) Use this session to retrieve all the Country-State/Province combinations that needs to be migrated in the final conversion run. After retrieving the States/Provinces the correct time zone can be linked to these states/provinces. Preparation Before you can use this session the pre-conversion run must have been run. A prerequisite for retrieving the states/provinces is that addresses in session Mapping Table for Addresses (bcmtc1102m000) are present. Based upon this address information the states/provinces are retrieved. Execution It is always mandatory to run this session. MANMAN Country The country code present in Manman. State The state or province present in a specific country Time Zone The time zone linked to the state or province Allowed values Time zone must be present in session Time Zones (tcemm1100m000). Default value Time zone will default be filled with the parameter Time Zone Code defined in the Pre Conversion Parameters for Common (bcmtc0100s000). Retrieve Countries and States/Provinces When the specific command Retrieve Countries and States/Provinces is run then all unique combinations of Country and State/Province are selected from table bcmtc102 Validate Click the specific command 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. |