Skip to main content

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
UTIMEDATEYesDate field to store date and time information including timezoneReturns an XML Date formatNone
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 <FieldName>Description, address number <FieldName>AddressNo, company <FieldName>Company and cost center type <FieldName>CostCenterType for the business unit.
UDCSTRINGYesUser-Defined Code key stored as a stringLimits maximum string length to the value defined in the JD Edwards Data Dictionary.Retrieves description line 1 <FieldName>Description, description line 2 <FieldName>Description2 and special handling code <FieldName>SpecialHandling for the UDC value.
SHORTITEMINTEGERNoShort Item Number for item master recordsLimits maximum integer value to the value defined in the JD Edwards 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.
ERRORALIASSTRINGNoError alias codeLimits maximum string length to the value defined in the JD Edwards Data Dictionary.Retrieves the error message description <FieldName>Description and error code type <FieldName>CodeType for the error alias.
ASSETNUMBERINTEGERNoAsset number for asset master recordsLimits maximum integer value to the value defined in the JD Edwards 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.
ADDRESSNUMBERINTEGERNoAddress number for address book recordsLimits maximum integer value to the value defined in the JD Edwards Data Dictionary.Retrieves the alpha name <FieldName>AlphaName for the address book number.
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.
ACCOUNTIDINTEGERNoAccount ID number for Account MasterLimits maximum integer value to the value defined in the JD Edwards 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.
COMPANYSTRINGNOCompany identifier for company master recordLimits maximum string length to the value defined in the JD Edwards 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.

 

JavaScript errors detected

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

If this problem persists, please contact our support.