biuan SAP® BUSINESS ONE SDK
API NFN5
NFN5 - NF Skipped Numbers Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
SeqCode KEY UNIQUESequence CodeInt
6
PRIMARYYes
NFeNoFromNF-e No. FromInt
11
0
NFeNoToNF-e No. ToInt
11
0
YearYearInt
6
ReasonReason for Number SkippingnVarChar
127
ReplyReply from the AuthoritynVarChar
50
StatusStatusVarChar
N) New
S) Sent
A) Approved
E) Error
1
N
VisOrderVisual OrderInt
6
CreateDateCreation DateDate
8
CreateTimeCreation TimeInt
11
UpdateDateUpdate DateDate
8
UpdateTimeUpdate TimeInt
11
UserSignUser SignatureInt
6OUSR
Users
UserSign2Updating UserInt
6OUSR
Users

SELECT statement

SELECT NFN5.SeqCode AS 'Sequence Code', NFN5.NFeNoFrom AS 'NF-e No. From', NFN5.NFeNoTo AS 'NF-e No. To', NFN5.Year AS 'Year', NFN5.Reason AS 'Reason for Number Skipping', NFN5.Reply AS 'Reply from the Authority', NFN5.Status AS 'Status', NFN5.VisOrder AS 'Visual Order', NFN5.CreateDate AS 'Creation Date', NFN5.CreateTime AS 'Creation Time', NFN5.UpdateDate AS 'Update Date', NFN5.UpdateTime AS 'Update Time', NFN5.UserSign AS 'User Signature', NFN5.UserSign2 AS 'Updating User' FROM NFN5 AS NFN5

Related information


Users OUSR 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