biuan SAP® BUSINESS ONE SDK
DTW Production / Production Orders
API NFN1
NFN1 - Not a Fiscal Sequence Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ObjectCode KEY UNIQUEDocumentnVarChar
20ONFN
Nota Fiscal Numbering
S_NAMEYes
SeqCodeSeq. CodeInt
6
0
SeqNameSeq. NamenVarChar
8
InitialNumInitial NumberInt
11
0
NextNumNext Number for UseInt
11
0
LastNumLast Number AllowedInt
11
SeriesStrSeries StringnVarChar
3
SubStrSubseries StringnVarChar
3
RemarkRemarksnVarChar
50
GroupCodeGroupInt
1)
2)
3)
4)
5)
6)
7)
8)
9)
10)
6
1
LockedLockedVarChar
Y)
N)
1
N
YearTransfYear-End ClosingVarChar
Y)
N)
1
N
IndicatorPeriod IndicatornVarChar
' ')
10OPID
Period Indicator
' '
TemplateTemplatenVarChar
20
NumSizeNumeric SizeInt
11
PrefixPrefixnVarChar
8
SuffixSuffixnVarChar
8
DocSubTypeDocument Sub-TypenVarChar
2
--
ModelNota Fiscal ModelnVarChar
6ONFM
Nota Fiscal Model
0
LocationLocation CodeInt
11OLCT
Location
BPLIdAssigned BranchInt
11OBPL
Business Place
0
IsDigitalDigital SeriesVarChar
Y) Yes
N) No
1
N
EnvTypeNFeEnvironment Type NF-eInt
11OBNI
Brazil Numeric Indexer
-1

Table relationship map

SELECT statement

SELECT NFN1.ObjectCode AS 'Document', NFN1.SeqCode AS 'Seq. Code', NFN1.SeqName AS 'Seq. Name', NFN1.InitialNum AS 'Initial Number', NFN1.NextNum AS 'Next Number for Use', NFN1.LastNum AS 'Last Number Allowed', NFN1.SeriesStr AS 'Series String', NFN1.SubStr AS 'Subseries String', NFN1.Remark AS 'Remarks', NFN1.GroupCode AS 'Group', NFN1.Locked AS 'Locked', NFN1.YearTransf AS 'Year-End Closing', NFN1.Indicator AS 'Period Indicator', NFN1.Template AS 'Template', NFN1.NumSize AS 'Numeric Size', NFN1.Prefix AS 'Prefix', NFN1.Suffix AS 'Suffix', NFN1.DocSubType AS 'Document Sub-Type', NFN1.Model AS 'Nota Fiscal Model', NFN1.Location AS 'Location Code', NFN1.BPLId AS 'Assigned Branch', NFN1.IsDigital AS 'Digital Series', NFN1.EnvTypeNFe AS 'Environment Type NF-e' FROM NFN1 AS NFN1

Related information


Business Place OBPL SQL Table

Brazil Numeric Indexer OBNI SQL Table

Period Indicator OPID SQL Table

Location OLCT SQL Table

Nota Fiscal Model ONFM SQL Table

Nota Fiscal Numbering ONFN 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