biuan SAP® BUSINESS ONE SDK
DTW Inventory / Price Lists / Special Prices
API NFN4
NFN4 - Manual Nota Fiscal Number Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ObjectCode KEY UNIQUEDocumentnVarChar
20ONFN
Nota Fiscal Numbering
PRIMARYYes
SeqCodeSequence CodeInt
6
SeqNameSeq NamenVarChar
8
SerialSerial NumberInt
11
SeriesStrSeries StringnVarChar
3
SubStrSubseries StringnVarChar
3
DocSubTypeDocument Sub-TypenVarChar
2
--
ModelNota Fiscal ModelnVarChar
6ONFM
Nota Fiscal Model
CardCodeCustomer/Vendor CodenVarChar
15OCRD
Business Partner
DocEntryDocument Abs. EntryInt
11
DocNumberDocument NumberInt
11
IsReusableIs ReusableVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT NFN4.ObjectCode AS 'Document', NFN4.SeqCode AS 'Sequence Code', NFN4.SeqName AS 'Seq Name', NFN4.Serial AS 'Serial Number', NFN4.SeriesStr AS 'Series String', NFN4.SubStr AS 'Subseries String', NFN4.DocSubType AS 'Document Sub-Type', NFN4.Model AS 'Nota Fiscal Model', NFN4.CardCode AS 'Customer/Vendor Code', NFN4.DocEntry AS 'Document Abs. Entry', NFN4.DocNumber AS 'Document Number', NFN4.IsReusable AS 'Is Reusable' FROM NFN4 AS NFN4

Related information


Business Partner OCRD 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