biuan SAP® BUSINESS ONE SDK
DTW Production / NCM Code
API NCM Codes Setup Service / NCM Code Setup
ONCM - NCM Code Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEIDInt
11
PRIMARYYes
NcmCode KEY UNIQUENCM CodenVarChar
15
CODEYes
DescripDescriptionnVarChar
127
LogInstancLog InstanceInt
11
0
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8
GroupCodeGroup CodeVarChar
1
L

Table relationship map

SELECT statement

SELECT ONCM.AbsEntry AS 'ID', ONCM.NcmCode AS 'NCM Code', ONCM.Descrip AS 'Description', ONCM.LogInstanc AS 'Log Instance', ONCM.UserSign2 AS 'Updating User', ONCM.UpdateDate AS 'Update Date', ONCM.GroupCode AS 'Group Code' FROM ONCM AS ONCM

Related information


NCM Code Setup NCMCodeSetup Object· Table: ONCM
Represents an NCM code that can be assigned to an item. Source table: ONCM Mandatory properties: NCMCode, Description
   Parent: NCM Codes Setup Service NCMCodesSetupService Service· Table: ONCM

NCM Codes Setup Service NCMCodesSetupService Service· Table: ONCM
The NCMCodesSetupService service enables you to add, look up and remove NCM codes in the NCM codes master data table. NCM codes can be assigned to items via the NCMCode field of the Items object. To see the list of NCM codes, select Inventory...

ONCM 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