biuan SAP® BUSINESS ONE SDK
DTW Banking / Outgoing Payments / Checks for Payment / Documents Numbering - Series
API Series Service / Document Series Params
NNM1 - Documents Numbering - Series Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ObjectCode KEY UNIQUEDocumentnVarChar
20ONNM
Document Numbering
SER_NAMEYes
Series KEY UNIQUESeriesInt
6
0PRIMARYYes
SeriesNameSeries NamenVarChar
8
InitialNumInitial NumberInt
11
0
NextNumberNext Number for UseInt
11
0
LastNumLast Number AllowedInt
11
BeginStrPrefix StringnVarChar
20
EndStrSuffix StringnVarChar
20
RemarkRemarksnVarChar
50
GroupCodeGroupInt
1) Series Group 1
2) Series Group 2
3) Series Group 3
4) Series Group 4
5) Series Group 5
6) Series Group 6
7) Series Group 7
8) Series Group 8
9) Series Group 9
10) Series Group 10
6
1
LockedLockedVarChar
Y) Yes
N) No
1
N
YearTransfYear-End ClosingVarChar
Y) Yes
N) No
1
N
IndicatorPeriod IndicatornVarChar
10OPID
Period Indicator
' '
TemplateTemplatenVarChar
20
NumSizeNumeric SizeInt
11
FolioPrefFolio Prefix StringnVarChar
4
NextFolioNext Folio NumberInt
11
DocSubTypeDocument Sub-TypenVarChar
2
--
DefESeriesDefault Electronic SeriesInt
6
0
IsDigSerieIs Digital SeriesVarChar
Y) Yes
N) No
1
N
SeriesTypeSeries TypeVarChar
D) Document
B) Business Partner
I) Item
R) Resource
1
D
IsManualIs Manual SeriesVarChar
Y) Yes
N) No
1
N
BPLIdAssigned BranchInt
11OBPL
Business Place
IsForCnclIs Series for CancelationVarChar
Y) Yes
N) No
1
N
AtDocTypeAT Document TypenVarChar
GT) GT
GA) GA
GD) GD
GR) GR
GC) GC
FT) FT
FS) FS
NC) NC
ND) ND
FR) FR
2
IsElAuthElec. Authorization CodeVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT NNM1.ObjectCode AS 'Document', NNM1.Series AS 'Series', NNM1.SeriesName AS 'Series Name', NNM1.InitialNum AS 'Initial Number', NNM1.NextNumber AS 'Next Number for Use', NNM1.LastNum AS 'Last Number Allowed', NNM1.BeginStr AS 'Prefix String', NNM1.EndStr AS 'Suffix String', NNM1.Remark AS 'Remarks', NNM1.GroupCode AS 'Group', NNM1.Locked AS 'Locked', NNM1.YearTransf AS 'Year-End Closing', NNM1.Indicator AS 'Period Indicator', NNM1.Template AS 'Template', NNM1.NumSize AS 'Numeric Size', NNM1.FolioPref AS 'Folio Prefix String', NNM1.NextFolio AS 'Next Folio Number', NNM1.DocSubType AS 'Document Sub-Type', NNM1.DefESeries AS 'Default Electronic Series', NNM1.IsDigSerie AS 'Is Digital Series', NNM1.SeriesType AS 'Series Type', NNM1.IsManual AS 'Is Manual Series', NNM1.BPLId AS 'Assigned Branch', NNM1.IsForCncl AS 'Is Series for Cancelation', NNM1.AtDocType AS 'AT Document Type', NNM1.IsElAuth AS 'Elec. Authorization Code' FROM NNM1 AS NNM1

Related information


Document Series Params DocumentSeriesParams Object· Table: NNM1
The DocumentSeriesParams specifies the identification key combination (Document and Series) for which the Documents is related. Source table: NNM1. DocumentSeries
   Parent: Series Service SeriesService Service· Table: NNM1

Series Series Object· Table: NNM1
Series is a data structure related to the SeriesService. It represents the series object, a part of a document name. Source table: NNM1 (Documents Numbering - Series).
   Parent: Series Collection SeriesCollection Collection· Table: NNM1

Series Collection SeriesCollection Collection· Table: NNM1
SeriesCollection is a data collection of Series data structures. Source table: NNM1 (Documents Numbering - Series).
   Parent: Series Service SeriesService Service· Table: NNM1

Series Service SeriesService Service· Table: NNM1
SeriesService manages the Series object, a component of the document numbering system. Source table: NNM1 (Documents Numbering - Series).

NNM1 SQL Table

Business Place OBPL SQL Table

Period Indicator OPID SQL Table

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