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

SQL Administration / Documents Numbering - Supplementary Code

DTW Banking / Outgoing Payments / Outgoing Payments

API NNM6

NNM6 - Documents Numbering - Supplementary Code Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Primary_Key	Unique
ObjectCode ^KEY ^UNIQUE	Document	nVarChar		20	ONNM Document Numbering	PRIMARY	Yes
PeriodType	Sequence Period Type	VarChar	Y) Annually M) Monthly W) Weekly P) Permanent	1
StartDate	Start Date	Date		8
EndDate	End Date	Date		8
Sequence	Current Sequence	Int		11
FormatStr	Format String for Create Code	nVarChar		127

SELECT statement

SELECT
   NNM6.ObjectCode AS 'Document', 
   NNM6.PeriodType AS 'Sequence Period Type', 
   NNM6.StartDate AS 'Start Date', 
   NNM6.EndDate AS 'End Date', 
   NNM6.Sequence AS 'Current Sequence', 
   NNM6.FormatStr AS 'Format String for Create Code'
FROM NNM6 AS NNM6

Related information

ONNM SQL Table

biuan SAP® BUSINESS ONE

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