Framework functions – SQL - HxGN EAM - 12.0 - Help

REPDATEADD

Function adds Date

repdateadd (day char, numberOfDays number,Date date)

REPGETORDTERM

Getting Order Terms from R5ORDERTERM S

REPGETORDTERM (Code nvarchar)

REPGETADDRESS

Function returns address from R5ADDRESS

REPGETADDRESS (Rentity nvarchar,Rtype nvarchar,Code nvarchar)

REPFMTMONNUM

Function returns amount in user format

repfmtmonnum (User VARCHAR2, NumToFmt VARCHAR2)

REPGETADDTEXT

Function returns comments from R5ADDETAILS

REPGETADDTEXT(rentity nvarchar, lang nvarchar,code nvarchar)

REPDATEDIFF

Function returns date difference

repdatediff(day char, numberOfDays number,Date date)

TO_DATE

Function returns Datetime. It converts a string to Datetime format

TO_DATE(Date nvarchar, Format nvarchar)

REPORGDEFCUR

Function returns default currency for the Organization

REPORGDEFCUR (sOrg nvarchar)

REPGETDELADD

Function returns delivery Address from R5DELADDRESSES

REPGETDELADD (Code nvarchar)

REPGETDESC

Function returns description from R5Descriptions

REPGETDESC(sLang nvarchar,sRentity nvarchar,sEntcode nvarchar,sRtype nvarchar,sUtype nvarchar)

REPGTEXCH

Function returns exchange rate

REPGTEXCH (sCurr nvarchar)

REPGTTIME

Function returns get time

REPGTTIME(sOrg nvarchar)

REPLABOUR

Function returns labor cost

REPLABOUR(sEvent nvarchar )

REPHOURS

Function returns labor hours

REPHOURS(sEvent nvarchar)

REPMATERIAL

Function returns material cost

REPMATERIAL( sEvent nvarchar )

REPFMTNUM

Function returns number field in user format

repfmtnum (r5User VARCHAR2, NumberToFormat VARCHAR2)

REPFMTNUM2

Function returns number field in user format without rounding

repfmtnum2 (r5User VARCHAR2, NumberToFormat VARCHAR2)

REPFMTWHOLENUM

Function returns numbers in user locale format

repfmtwholenum (User VARCHAR2, NumToFmt NUMBER)

REPGETPARAMDESC

Function returns parameter page descriptions

REPGETPARAMDESC(Lang nvarchar, Rentity nvarchar,Code nvarchar, Rtype nvarchar, Type nvarchar)

REPALLOCATEQTY

Function returns Quantity allocated for the part

REPALLOCATEQTY(part VARCHAR2,org VARCHAR2,store VARCHAR2)

REPGETTEXT

Function returns Quantity allocated for the part

REPALLOCATEQTY(part VARCHAR2,org VARCHAR2,store VARCHAR2)

REPGETFMTDATI

Function returns the date and time based on user locale

REPGETFMTDATI (Usr, date )

REPGETFMTDATE

Function returns the date based on user locale

REPGETFMTDATE (Usr nvarchar, date datetime)

F_TRUNC_DATE

Function returns the date from datetime

F_TRUNC_DATE(@dDate datetime, @sMode nvarchar(4))

REPGETEXCHANGERATE

Function returns the exchange rate

REPGETEXCHANGERATE(@reportingCurrency nvarchar,@eventOrganisation nvarchar,@exchangeDate datetime)

GETFISCALENDDATE

Function returns the fiscal end date

GETFISCALENDDATE (ORGANIZATION nvarchar(15))

GETFISCALSTARTDATE

Function returns the fiscal end date

GETFISCALENDDATE (ORGANIZATION nvarchar(15) )

REPGETHIERCODE

Function returns the hierarchy code

REPGETHIERCODE(hierarchyType VARCHAR, parameterForHierarchyToBenerated VARCHAR,parameterToBeCheckedInHierarchy VARCHAR,numericParameterForHierarchyToBenerated NUMBER,numericParameterToBeCheckedInHierarchy NUMBER,organizationParameter VARCHAR2,sequenceNumberOfHierarchyElementNUMBER)

REPGETSYSDATE

Function returns the Offset date of the user org

REPGETSYSDATE( Org nvarchar)

REPONREQUIQTY

Function returns the requisitioned quantity for the part

REPONREQUIQTY (Part nvarchar,Org nvarchar,Store nvarchar)

REPRESERVEDQTY

Function returns the reserved quantity for the part

REPRESERVEDQTY(Part nvarchar,Org nvarchar,Store nvarchar)

REPGETHOURS

Function returns the time of day in HH24 MI SS

REPGETHOURS(seconds Number)

REPTOOLS

Function returns tools cost

REPTOOLS(sEvent nvarchar)

REPGETWODESC

Function Returns WorkOrder Description

REPGETWODESC (sLang nvarchar(2), sRentity nvarchar(4), sEntcode nvarchar(4000), sRtype nvarchar(4), sUtype nvarchar(4))

REPPRINTED

Function updates the print Flag in Tables

REPPRINTED(Code nvarchar,DESTYPE nvarchar,Code1 nvarchar,Code2 nvarchar,Code3 nvarchar,Code4 nvarchar,Code5 nvarchar)

BZSNAP_DESC

Function used by Electronic Signature report to return description

R5REP_BZSNAP_DESC(sLang nvarchar(2), sEntity nvarchar(4), sEntcode nvarchar(256), sEntparentcode nvarchar(256), sEntorg nvarchar(15), sRtype nvarchar(256), sUtype nvarchar(256))

REPGETCOMPDATE

Returns Date in the format YYYY- MM-DD

REPGETCOMPDATE (date datetime)

REPPARAMDATE

Returns Date parameter string in user format

Paramter date should be in YYYY-MM-DD format.

REPACTDMA

Returns Direct Material Cost

repactdma ( 'EVT', WCL_EVENT, NULL, NULL, NULL, WCL_WARRANTY)

REPACTHIR

Returns Hired Labor Cost

repacthir ( 'EVT', WCL_EVENT, NULL, NULL, NULL, WCL_WARRANTY)

REPACTLAB

Returns Labor Cost

repactlab( 'EVT', WCL_EVENT, NULL, NULL, NULL, WCL_WARRANTY)

REPACTMAT

Returns Material Cost

repactmat ( 'EVT', WCL_EVEN, NULL, NULL, NULL, WCL_WARRANTY)

REPACTFIX

Returns Service Cost

repactfix( 'EVT', WCL_EVENT, NULL, NULL, NULL, WCL_WARRANTY)

F_GREATEST_NUMBER

Returns the greatest of the 2 numbers

F_GREATEST_NUMBER (nNum1 numeric,nNum2 numeric)

REPINTRANSITQTY

Returns the intransit quantity for the part

REPINTRANSITQTY (part nvarchar,org nvarchar,store nvarchar)

REPONORDERQTY

Returns the Ordered Quantity for the Part

REPONORDERQTY (Part nvarchar,Org nvarchar,Store nvarchar)

REPEVTSYSTEMS

Returns the systems associated with event code passed to the function

REPEVTSYSTEMS (defaultOrganisation varchar, eventcode varchar)

REPGETVMRSDESC

Returns the VMRS description

repgetvmrsdesc ('EN', R5ACTIVITIES.ACT_SYSLEVEL, R5ACTIVITIES.ACT_ASMLEVEL,R5ACTIVITIES.ACT_COMPLEVEL) repgetvmrsdesc (lang string, syslevel string, asmlevel string, complevel string)

REPACTTOOL

Returns Tool Cost

repacttool ('EVT', WCL_EVENT, NULL, NULL, NULL, WCL_WARRANTY)

O7OZCLAIVMRS

Returns the VMRS description

O7OZCLAIVMRS ('EN', SYSLEVEL, ASMLEVEL, COMPLEVEL, 'SYS')