📚 SAP Business One SDK Help

GetFieldValidValues Method
See Also 
TableName
Table name in the database.
FieldName
Field name in the database.

Description

Returns 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.

Syntax

Visual Basic
Public Function GetFieldValidValues( _
   ByVal TableName As String, _
   ByVal FieldName As String _
) As Recordset

Parameters

TableName
Table name in the database.
FieldName
Field name in the database.

Remarks

The following is a returned recordset that is saved in XML format:

<?xml version="1.0" encoding="UTF-16"?>
<BOM>
<BO>
<AdmInfo>
<Object>-1</Object>
</AdmInfo>
<GENREC>
<row>
<Value>C</Value>
<Description>Customer</Description>
</row>
<row>
<Value>S</Value>
<Description>Vendor</Description>
</row>
<row>
<Value>L</Value>
<Description>Lead</Description>
</row>
</GENREC>
</BO>
</BOM>

See Also