📚 SAP Business One SDK Help

SBObob Object Members
See Also  Overview 

Public Methods

Public Method ConvertEnumValueToValidValueConverts a specified enumeration value of an enumeration name to the valid value defined in the company database.

See Conversion sample.

Public Method ConvertValidValueToEnumValueConverts a specified valid value of an enumeration name to the enumeration value defined in the company database.

See Conversion sample.

Public Method Format_DateToStringConverts the system date to a string.

See Formatting sample.

Public Method Format_MoneyToStringConverts a specified amount of money to a string according to a specified precision. See Formatting sample.
Public Method Format_StringToDateConverts date string to a system date.
Public Method GetAccountSegmentsByCodeReturns a Recordset object that contains the value of the FormatCode property for a specified AccountCode.
Public Method GetBPListReturns a Recordset object that contains a list of business partners keys that can be used as a parameter in many business objects.

See Get Business Partners List sample.

Public Method GetContactEmployeesReturns a Recordset object that contains a list of contact employees for a specified business partner.

See Get Contact Employees sample.

Public Method GetCurrencyRateReturns a Recordset object that contains the currency rate for a specified date and currency code.

See Currency sample.

Source table: ORTT.

Public Method GetDueDateReturns the due date for a specified business partner based on the business partner code and the reference date. See Get Due Date sample.
Public Method GetEwaParametersReturns a Recordset that defines the Early Watch Alert user parameters:
  • EWA Key
  • User Name
  • User PassWord
Public Method GetFieldValidValuesReturns a Recordset object that contains the valid values of a specified field and table in the database. Each valid value includes its name and description. For example, the valid values for CardType field in OCRD table are: C - Customer, S - Supplier, and L - Lead.
Public Method GetIndexRateReturns a Recordset object that contains the index rate for a specified date and index code.

See Get Index Rate sample.

Public Method GetItemListReturns a Recordset object that contains an item code and item name. To retrieve the items list, apply this method in a loop. See Get Items List sample.
Public Method GetItemPriceReturns a Recordset object that contains the item price for specified business partner and item, based on the amount and transaction date.

See Get Item Price sample.

Public Method GetLicenseStatusYou can get the information whether a user has a license to access a form.
Public Method GetLocalCurrencyReturns the local currency defined in the company database.

See Currency sample.

Public Method GetObjectKeyBySingleValueReturns a Recordset object that contains the object key by single value. See Get Object Key By Single Value sample.
Public Method GetObjectPermissionReturns a single record that contains the permission type (BoPermission) of a specified PermissionId and UserSignature.
Public Method GetSystemCurrencyReturns the system currency defined in the company database.

See Currency sample.

Public Method GetSystemPermissionReturns the permission for a type of permission for a specific user.
Public Method GetTableFieldListReturns a Recordset object that contains the fields list of a specified table in the database. Each field includes the following parameters (the examples in parenthesis relates to OCRD: CardCode):
  • Name (CardCode)
  • Type (nvarchar) -- a numeric value representing a BoFieldTypes enumeration value
  • Length (15)
  • Linked table name for foreign key (GroupCode)
  • Valid values indicator, which indicates whether or not this field uses valid values (no)
  • IsNullable -- specifies whether or not nulls are permitted
Public Method GetTableListReturns a Recordset object that contains a list of all the tables in the database. Each table includes its name and description (for example: OCRD, Business Partner.
Public Method GetUserListReturns a recordset that contains a list of user codes defined in the SAP Business One company database.
Public Method GetValidValueDescriptionReturns a string that contains the valid value description of a valid value.
Public Method GetWareHouseListReturns a Recordset object that contains the warehouse code and name defined the company database. To retrieve a list of warehouses, apply this method in a loop.

See Get Warehouse List sample.

Public Method PutEwaParametersSets a Recordset that contains the Early Watch Alert user parameters:
  • EWA Key
  • User Name
  • User PassWord
Public Method SetCurrencyRateSets the exchange rate for a specified date and currency in the company database.

See Currency sample.

Public Method SetSystemPermissionSets the permission for a type of permission for a specific user.

See Also