Skip to main content
Skip table of contents

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 TypeBase Data TypeAuto DiscoveryDescriptionFormattingLookup Behaviour
STRINGSTRINGYesString field containing one or more charactersLimits maximum string length to the value defined in the JD Edwards Data Dictionary.None
CHARACTERCHARACTERYesSingle character fieldNoneNone
INTEGERINTEGERYesInteger number fieldLimits maximum integer value to the value defined in the JD Edwards Data Dictionary.None
FLOATFLOATYesInteger number field with floating point defined in data dictionaryLimits maximum float value to the value defined in the JD Edwards Data Dictionary. Automatically applies display decimal conversion.None
DATEINTEGERYesInteger number field with data stored in JD Edwards Julian Date formatConverts Julian Date to YYYY/MM/DD format and back depending on input or output.None
TIMEINTEGERNoInteger number field with data stored in HHMMSS formatConverts number representation of time to HH:mm:ss format and back depending on input or output.None
BUSINESSUNITSTRINGNoString field left padding with spaces to fill 12 charactersStrips 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.
UDCSTRINGYesUser-Defined Code key stored as a stringLimits 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.
SHORTITEMINTEGERNoShort Item Number for item master recordsLimits 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.
ERRORALIASSTRINGNoError alias codeLimits 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.
ASSETNUMBERINTEGERNoAsset number for asset master recordsLimits 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.
ADDRESSNUMBERINTEGERNoAddress number for address book recordsLimits 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.
LOCATIONSTRINGNoUnformatted location code stringLimits 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.

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.