ODNF - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Inventory and Production / DNF Code / DNF Code

DTW DNF Code

API DNF Code Setup Service / DNF Code Setup

SBO SQL database table details

Field	Description	Type	Size	Related	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal Key	Int	11			PRIMARY	Yes
NCMEntry ^KEY ^UNIQUE	NCM Code	Int	11	ONCM NCM Code		NCM_DNF	Yes
DNFCode	DNF Code	nVarChar	5
DNFUoM	DNF UoM	nVarChar	10
DNFFactor	DNF Factor	Num	20
LogInstanc	Log Instance	Int	11		0
UserSign2	Updating User	Int	6	OUSR Users
UpdateDate	Update Date	Date	8

Table relationship map

SELECT statement

SELECT
   ODNF.AbsEntry AS 'Internal Key', 
   ODNF.NCMEntry AS 'NCM Code', 
   ODNF.DNFCode AS 'DNF Code', 
   ODNF.DNFUoM AS 'DNF UoM', 
   ODNF.DNFFactor AS 'DNF Factor', 
   ODNF.LogInstanc AS 'Log Instance', 
   ODNF.UserSign2 AS 'Updating User', 
   ODNF.UpdateDate AS 'Update Date'
FROM ODNF AS ODNF

Related information

DNFCodeSetup Object· Table: ODNF

Represents a DNF code that can be assigned to an item. Source table: ODNF Mandatory properties: DNFCode, NCMCode

Parent: DNF Code Setup Service DNFCodeSetupService Service· Table: ODNF

DNFCodeSetupService Service· Table: ODNF

The DNFCodeSetupService service enables you to add, look up and remove DNF codes in the DNF codes master data table. NCM codes are assigned to items, and then DNF codes can be assigned to that NCM code for that item. To see the list of DNF...

ODNF SQL Table

ONCM SQL Table

OUSR SQL Table

biuan SAP® BUSINESS ONE

Service
DNFCodeSetupService

Object
DNFCodeSetup

Method

FromXMLFile

FromXMLString

GetXMLSchema

ToXMLFile

ToXMLString

Property

AbsEntry

DNFCode

Factor

NCMCode

UoM

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