Reference: Currency Format Requirements for External Data
External data that you bring into a table or dataset might contain fields with currency
values. If Workday recognizes the format of a Currency field, it automatically assigns the
Currency field type.
For Workday to recognize a single field value as valid currency data, it must meet these
requirements:
- It must contain a numeric amount.
- The numeric amount can only use a period as the decimal separator.
- The numeric amount can't use any character to separate thousands.
- It must contain a valid 3-digit currency code that Workday recognizes.
- The 3-digit currency code can occur either before or after the numeric amount.
- It can contain valid currency symbols that Workday recognizes, but it must also contain the 3-digit currency code.
- It can't contain extraneous characters, but can contain extra spaces before or after the numeric amount or currency code.
If a Currency field contains any value that doesn't meet these requirements, Workday treats
the value as NULL.
Example: Workday recognizes these single data values as valid currency data:
- 3000.00 USD
- $3000.00 USD
- USD 3000.00
- USD $3000.00
- -$3,000.00 USD
- ($3,000.00) USD