Functions
Choose your topic of interest from the list below or use the search bar above.
Dimension functions
- SI.CUSTOMERNAME
- SI.DEPARTMENTNAME
- SI.DIMENSIONS
- SI.EMPLOYEENAME
- SI.EXPANDCLASSRANGE
- SI.EXPANDCUSTOMERRANGE
- SI.EXPANDDEPARTMENTRANGE
- SI.EXPANDEMPLOYEERANGE
- SI.EXPANDITEMRANGE
- SI.EXPANDLOCATIONRANGE
- SI.EXPANDUDDVALUERANGE
- SI.EXPANDVENDORRANGE
- SI.EXPANDWAREHOUSERANGE
- SI.ITEMNAME
- SI.LOCATIONNAME
- SI.UDDVALUEID
- SI.VENDORNAME
- SI.WAREHOUSENAME
Financial functions
- SI.ACCOUNTNAME
- SI.ADJCREDITS
- SI.ADJDEBITS
- SI.BUDGETABLEPERIODBYDATE
- SI.BUDGETTURNOVER
- SI.CLOSINGBALANCE
- SI.CONSOLIDATIONBOOKDESCRIPTION
- SI.CREDITS
- SI.DEBITS
- SI.EXPANDACCOUNTGROUPRANGE
- SI.EXPANDACCOUNTRANGE
- SI.EXPANDACCOUNTSINGROUP
- SI.EXPANDBUDGETRANGE
- SI.EXPANDCONSOLIDATIONBOOKRANGE
- SI.EXPANDGLHISTORY
- SI.EXPANDPERIODRANGE
- SI.EXPANDPERIODRANGE (Financial functions)
- SI.EXPANDTAXDETAILSRANGE
- SI.EXPANDTAXSOLUTIONRANGE
- SI.EXPANDUSERBOOKRANGE
- SI.OPENINGBALANCE
- SI.PERIODENDDATE
- SI.PERIODSTARTDATE
- SI.TAXRATE
- SI.TURNOVER
- SI.USERBOOKDESCRIPTION
Project functions
- SI.CLASSNAME
- SI.COSTTYPENAME
- SI.EXPANDCOSTTYPERANGE
- SI.EXPANDPROJECTESTIMATERANGE
- SI.EXPANDPROJECTESTIMATETYPERANGE
- SI.EXPANDPROJECTRANGE
- SI.EXPANDSTANDARDCOSTTYPERANGE
- SI.EXPANDSTANDARDTASKRANGE
- SI.EXPANDTASKRANGE
- SI.PROJECTENDDATE
- SI.PROJECTESTIMATEAMOUNT
- SI.PROJECTESTIMATEDESCRIPTION
- SI.PROJECTESTIMATEQUANTITY
- SI.PROJECTNAME
- SI.PROJECTSTARTDATE
- SI.PROJECTSTATUS
- SI.TASKNAME
Query functions
- SI.EXPANDCLASSESINGROUP
- SI.EXPANDCONTRACTSINGROUP
- SI.EXPANDCUSTOMERSINGROUP
- SI.EXPANDDEPARTMENTSINGROUP
- SI.EXPANDEMPLOYEESINGROUP
- SI.EXPANDITEMSINGROUP
- SI.EXPANDLOCATIONSINGROUP
- SI.EXPANDOBJECTRANGE
- SI.EXPANDPROJECTSINGROUP
- SI.EXPANDVENDORSINGROUP
- SI.EXPANDWAREHOUSESINGROUP
- SI.OBJECTDEFINITION
- SI.QUERY
- SI.QUERY with aggregated measures
- SI.QUERYFILTER
- SI.QUERYLOOKUP
- SI.XEXPANDOBJECTRANGE
- SI.XOBJECTDEFINITION
- SI.XQUERY
- SI.XQUERYFILTER
- SI.XQUERYLOOKUP