Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Steps: Set Up Integration for AMEX Procurement Card Transactions

Steps: Set Up Integration for AMEX Procurement Card Transactions

Implement an integration for AMEX Cardholder Listings. Then you can upload listing files for any credit card account for which you import transactions.
The credit card secure environment is only available to tenants that Workday hosts in U.S.-based data centers. If you host your tenants in a data center outside the U.S., you can’t import files with unmasked credit card numbers. Contact Workday Support if you need assistance determining which Workday data center hosts your tenants.
Create an integration system to download American Express (AMEX) procurement card transactions. Process them in Workday using Workday tasks for procurement card verification and settlement processing. Workday supports electronic load for AMEX file format KR1075 Line Item Detail-Daily Unbilled Transactions and AMEX file format GL1076 Global Daily Line Item Details Transaction.
Workday plans to replace the AMEX KR1075 file format with the AMEX GL1076 file format in March, 2022. After March 2022, you can continue to use AMEX KR1075 to maintain existing integrations, but you must use AMEX GL1076 to create new integrations.
The AMEX KR1075 integration accepts transaction files with unmasked credit card numbers. American Express provides transaction files with all digits visible. The integration loads transaction files into a secure credit card environment, where it replaces the credit card number with a (previously generated) token. The integration then imports the transaction file into your Workday environment. Since a token (a long string of numbers and letters) replaces the number, the credit card number itself is secure.
The AMEX Gl1076 integration accepts transaction files with only masked credit card numbers. American Express provides transaction files with all but the last four credit card digits hidden to ensure security. The integration then imports the transaction file into your Workday environment.
When you configure the integration system, you can specify a retention period of up to 180 days for the imported files. You can also configure the Workday sequence generator to create a unique file name for each imported file.
  1. Access the
    Create Integration System
     task and enter
    Import PCard Transaction File (AMEX GL1076 - Masked)
     at the
    New Using Template
     prompt.
    Security:
    Integration Build
     and
    Integration Configure
     security domains.
  2. (Optional) To enable mapping of supplier codes to corresponding suppliers in Workday, enable the
    Dynamic Map Service - Suppliers
     integration service.
  3. Create an Integration System User (ISU) and grant the ISU
    Get
     and
    Put
     access to the
    Process: Credit Card
     security domains.
    See: Steps: Grant Integration or External Endpoint Access to Workday.
  4. As a related action on your integration template, select
    Integration System
    Configure Integration Attributes
    . Available attributes vary depending on whether you enabled the
    Dynamic Maps Service - Suppliers
     integration service:
    Option Description
    ISO Currency Type
    Specify whether the incoming files have alphabetic or numeric currency codes. The default is
    Numeric
    . To change the value, select the
    Override Template Values
     check box and select
    Alphabetic
     at the
    Value
     prompt.
    Truncate Leading Zeros on EMPID
    Specify if Workday can delete any leading zeros on the employee ID on import.
    Document Retention Policy
    Specify how many days to keep the imported files. The default retention period is 30 days.
    To store the files, select the
    Override Template Values
     check box, click the
    Value
     prompt, and select a retention period.
    Dynamic Map Type - Suppliers
    When implementing this integration, accept the default settings. You can modify these settings only if instructed to do so by Workday Support.
    Dynamic Map Source Type - Suppliers
    When implementing this integration, accept the default settings. You can modify these settings only if instructed to do so by Workday Support.
    Dynamic Map Fuzzy Confidence Threshold - Suppliers
    When implementing this integration, accept the default settings. You can modify these settings only if instructed to do so by Workday Support.
    Dynamic Map Fuzzy Term Similarity - Suppliers
    When implementing this integration, accept the default settings. You can modify these settings only if instructed to do so by Workday Support.
  5. Specify how the integration system retrieves the card file.
  6. Schedule how often you want Workday to launch the integration.
You can now launch or schedule the integration to load AMEX Procurement credit card transactions into Workday.