Description Required. Enter a unique cost allocation segment import Description/name. Segment Required. Select the appropriate Cost allocation Segment to import against. Column Required. separator Select the Column separator used in the CSV file to be imported (, or ;). No of Required. Header rows Numeric value between 0 and 2. Select number of Header rows to skip (not to be imported) at the beginning of the file. A header row can contain column separator definition (sep=,), or column headings. Invert active Required. field value If enabled (selected), the data source value will be inverted. For example, if the source column [Blocked] is mapped (Y=Blocked, N=Not blocked), inversion must be done to enable “Not blocked” records to be saved as “active” to the target table and vice versa. Column Define the mapping between data source and the target table by mappings using the mapping lookups. Active Default = Active. Activate the cost allocation segment import by enabling (selecting) the Active check box. Upload the cost allocation segment data CSV file from Pastel Partner (See on screenshot above). To upload the cost allocation segment data file, drag the file to the upload area or click on the designated area to select the CSV file to upload. Set the values for Segment, Column Separator, Header rows, and Invert active field value. (See on screenshot above). Click Analyse (See on screenshot above). Define the mapping between data source and the target table by using the mapping (See on screenshot above). lookup fields Click Save (See on screenshot above). Click on Import (See on screenshot above). The cost allocation segment data will now be imported. Review the import log file for any related errors encountered during the import session.
Description Required. Enter a unique cost allocation segment import Description/name. Segment Required. Select the appropriate Cost allocation Segment to import against. Column separator Required. Select the Column separator used in the CSV file to be imported (, or ;). No of Header rows Required. Numeric value between 0 and 2. Select number of Header rows to skip (not to be imported) at the beginning of the file. A header row can contain column separator definition (sep=,), or column headings. Invert active field value Required. If enabled (selected), the data source value will be inverted. For example, if the source column [Blocked] is mapped (Y=Blocked, N=Not blocked), inversion must be done to enable “Not blocked” records to be saved as “active” to the target table and vice versa. Column mappings Define the mapping between data source and the target table by using the mapping lookups. Active Default = Active. Activate the cost allocation segment import by enabling (selecting) the Active check box. Upload the cost allocation segment data CSV file from Pastel Partner (See on screenshot above). To upload the cost allocation segment data file, drag the file to the upload area or click on the designated area to select the CSV file to upload. Set the values for Segment, Column Separator, Header rows, and Invert active field value. (See on screenshot above). Click Analyse (See on screenshot above). Define the mapping between data source and the target table by using the mapping lookup fields (See on screenshot above). Click Save (See on screenshot above). Click on Import (See on screenshot above). The cost allocation segment data will now be imported. Review the import log file for any related errors encountered during the import session.
SWIFT-Implementation-Guide-rev3.0-1.docx