Definition Data Types
In addition to handling the simple data types used by the JDE database, the Cantara Access Server also has defined JDE 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 JDE 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 JDE 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 JDE Data Dictionary. Automatically applies display decimal conversion. | None |
| DATE | INTEGER | Yes | Integer number field with data stored in JDE Julian Date format | Converts Julian Date to YYYY/MM/DD format and back depending on input or output. | None |
| UTIME | DATE | Yes | Date field to store date and time information including timezone | Returns an XML Date format | 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 <FieldName>Description, address number <FieldName>AddressNo, company <FieldName>Company and cost center type <FieldName>CostCenterType for the business unit. |
| UDC | STRING | Yes | User-Defined Code key stored as a string | Limits maximum string length to the value defined in the JDE Data Dictionary. | Retrieves description line 1 <FieldName>Description, description line 2 <FieldName>Description2 and special handling code <FieldName>SpecialHandling for the UDC value. |
| SHORTITEM | INTEGER | No | Short Item Number for item master records | Limits maximum integer value to the value defined in the JDE Data Dictionary. | Retrieves the primary item number <FieldName>ItemNumber, secondary item number <FieldName>SecondItemNumber, third item number <FieldName>ThirdItemNumber, description line 1 <FieldName>Description, description line 2 <FieldName>Descripition2, primary unit of measure <FieldName>UomPrimary and secondary unit of measure <FieldName>UomSecondary for the item master. |
| ERRORALIAS | STRING | No | Error alias code | Limits maximum string length to the value defined in the JDE Data Dictionary. | Retrieves the error message description <FieldName>Description and error code type <FieldName>CodeType for the error alias. |
| ASSETNUMBER | INTEGER | No | Asset number for asset master records | Limits maximum integer value to the value defined in the JDE Data Dictionary. | Retrieves the asset company <FieldName>Company, responsible business unit <FieldName>BusinessUnit, location <FieldName>Location, equipment status code <FieldName>EquipmentStatus, serial number <FieldName>SerialNumber, unit number <FieldName>UnitNumber and description <FieldName>Description for the asset. |
| ADDRESSNUMBER | INTEGER | No | Address number for address book records | Limits maximum integer value to the value defined in the JDE Data Dictionary. | Retrieves the alpha name <FieldName>AlphaName for the address book number. |
| LOCATION | STRING | No | Unformatted location code string | Limits maximum string length to the value defined in the JDE Data Dictionary. | Attempts to format the location string utilizing 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. |
| ACCOUNTID | INTEGER | No | Account ID number for Account Master | Limits maximum integer value to the value defined in the JDE Data Dictionary. | Retrieves the account company <FieldName>Company, business unit <FieldName>BusinessUnit, object code <FieldName>ObjectCode, subsidiary <FieldName>Subsidiary, description <FieldName>Description and posting edit code <FieldName>PostingEditCode for the account. |
| COMPANY | STRING | NO | Company identifier for company master record | Limits maximum string length to the value defined in the JDE Data Dictionary. Left pads with "0" character to maximum field size on input. | Retrieves the address number <FieldName>AddressNo, name <FieldName>Name, fiscal year start date <FieldName>FiscalYearBegins, current period <FieldName>Period and currency code <FieldName>CurrencyCode for the company. |