Definition Data Types
In addition to handling the simple data types used by the JD Edwards database, the Cantara Access Server also has defined JD Edwards specific data types that provide a richer functionality set when defining function, query or report definitions.
| Data Type | Base Data Type | Auto Discovery | Description | Formatting | Lookup Behaviour |
|---|---|---|---|---|---|
| STRING | STRING | Yes | String field containing one or more characters | Limits maximum string length to the value defined in the JD Edwards Data Dictionary. | None |
| CHARACTER | CHARACTER | Yes | Single character field | None | None |
| INTEGER | INTEGER | Yes | Integer number field | Limits maximum integer value to the value defined in the JD Edwards Data Dictionary. | None |
| FLOAT | FLOAT | Yes | Integer number field with floating point defined in data dictionary | Limits maximum float value to the value defined in the JD Edwards Data Dictionary. Automatically applies display decimal conversion. | None |
| DATE | INTEGER | Yes | Integer number field with data stored in JD Edwards Julian Date format | Converts Julian Date to YYYY/MM/DD format and back depending on input or output. | None |
| TIME | INTEGER | No | Integer number field with data stored in HHMMSS format | Converts number representation of time to HH:mm:ss format and back depending on input or output. | None |
| BUSINESSUNIT | STRING | No | String field left padding with spaces to fill 12 characters | Strips spaces off the start of the string or adds spaces as required depending on input or output. | Retrieves the first description line from the F0006 table for the business unit. Value is returned in field <FieldName>Description. |
| UDC | STRING | Yes | User-Defined Code key stored as a string | Limits maximum string length to the value defined in the JD Edwards Data Dictionary. | Retrieves the first description line for the UDC key. Value is returned in field <FieldName>Description. |
| SHORTITEM | INTEGER | No | Short Item Number for item master records | Limits maximum integer value to the value defined in the JD Edwards Data Dictionary. | Retrieves the item number and first description line from the F4101 for the short item number. Values are returned in fields <FieldName>ItemNumber and <FieldName>Description respectively. |
| ERRORALIAS | STRING | No | Error alias code | Limits maximum string length to the value defined in the JD Edwards Data Dictionary. | Retrieves the error message description for the error alias. Values is returned in field <FieldName>Description. |
| ASSETNUMBER | INTEGER | No | Asset number for asset master records | Limits maximum integer value to the value defined in the JD Edwards Data Dictionary. | Retrieves the unit number, serial number and first description line from the F1201 for the asset number. Values are returned in fields <FieldName>UnitNumber, <FieldName>SerialNumber and <FieldName>Description respectively. |
| ADDRESSNUMBER | INTEGER | No | Address number for address book records | Limits maximum integer value to the value defined in the JD Edwards Data Dictionary. | Retrieves the alpha name for the address book number. Value is returned in field <FieldName>Description. |
| LOCATION | STRING | No | Unformatted location code string | Limits maximum string length to the value defined in the JD Edwards Data Dictionary. | Attempts to format the location string utilising the first business unit record found in the result set. Business units are identified by having the data type BUSINESSUNIT set or having the data alias MCU or MMCU. Value is returned in field <FieldName>Formatted. |