biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Purchasing / Address Formats
API Country / Address Format
OADF - Address Formats Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodeInt
6
PRIMARYYes
Name KEY UNIQUENamenVarChar
50
ADF_NAMEYes
FormatFormatnVarChar
100
UserSignUser SignatureInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT OADF.Code AS 'Code', OADF.Name AS 'Name', OADF.Format AS 'Format', OADF.UserSign AS 'User Signature' FROM OADF AS OADF

Related information


Address Format AddressFormat Property· Table: OADF
Sets or returns the postal address format used by the country. The postal address format must be already presented in the Address Formats table (foreign key to OADF). Field name: AddrFormat.
   Parent: Country Country Object· Table: OCRY
OADF SQL Table

Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates