biuan SAP® BUSINESS ONE SDK
API OFNS
OFNS - Folio Numbering - Series Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Series KEY UNIQUESeries IDInt
11
PRIMARYYes
Name KEY UNIQUENamenVarChar
100
NAMEYes
PTICodePOI CodenVarChar
5OPTI
Point of Issue
FirstNumFirst NumberInt
11
NextNumNext NumberInt
11
LastNumLast NumberInt
11
LetterLetterVarChar
A) A
B) B
C) C
E) E
M) M
R) R
1
CAICAInVarChar
14
CAIDueDateCAI Due DateDate
8
RemarksRemarksnVarChar
100
LockedLockedVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT OFNS.Series AS 'Series ID', OFNS.Name AS 'Name', OFNS.PTICode AS 'POI Code', OFNS.FirstNum AS 'First Number', OFNS.NextNum AS 'Next Number', OFNS.LastNum AS 'Last Number', OFNS.Letter AS 'Letter', OFNS.CAI AS 'CAI', OFNS.CAIDueDate AS 'CAI Due Date', OFNS.Remarks AS 'Remarks', OFNS.Locked AS 'Locked' FROM OFNS AS OFNS

Related information


OFNS SQL Table

Point of Issue OPTI 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