biuan SAP® BUSINESS ONE SDK
DTW Banking
API ODMW
ODMW - Data Migration Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUEPackage CodeInt
11
PRIMARYYes
Name KEY UNIQUEPackage NamenVarChar
20
NAMEYes
CategoryIdCategory IDInt
11OQCN
Query Catagories
DestPathDest. PathText
16
ExtantionExportednVarChar
5
UserSignUser SignatureInt
6OUSR
Users
DelimInclude TitlenVarChar
T) Tab
K) ,
D) ;
S) Space
10
T
InclTitleSet to ExportedVarChar
Y) Yes
N) No
1
N
SetExpNew RecordsVarChar
Y) Yes
N) No
1
N
NewRecsSaveVarChar
Y) Yes
N) No
1
N
SummarySummaryText
16

Table relationship map

SELECT statement

SELECT ODMW.Code AS 'Package Code', ODMW.Name AS 'Package Name', ODMW.CategoryId AS 'Category ID', ODMW.DestPath AS 'Dest. Path', ODMW.Extantion AS 'Exported', ODMW.UserSign AS 'User Signature', ODMW.Delim AS 'Include Title', ODMW.InclTitle AS 'Set to Exported', ODMW.SetExp AS 'New Records', ODMW.NewRecs AS 'Save', ODMW.Summary AS 'Summary' FROM ODMW AS ODMW

Related information


ODMW SQL Table

Query Catagories OQCN 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates