biuan SAP® BUSINESS ONE SDK
DTW Banking / Outgoing Payments / Outgoing Payments
API NNM6
NNM6 - Documents Numbering - Supplementary Code Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ObjectCode KEY UNIQUEDocumentnVarChar
20ONNM
Document Numbering
PRIMARYYes
PeriodTypeSequence Period TypeVarChar
Y) Annually
M) Monthly
W) Weekly
P) Permanent
1
StartDateStart DateDate
8
EndDateEnd DateDate
8
SequenceCurrent SequenceInt
11
FormatStrFormat String for Create CodenVarChar
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


Document Numbering ONNM 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