Reference: Currency Format Requirements for External Data
External data that you bring into a table or base dataset might contain fields with currency values. If Workday recognizes the format of a Currency field, it automatically assigns the Currency field type.
If you're new to Workday, you don't have access to create or edit base datasets.
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