biuan SAP® BUSINESS ONE SDK
API OPTI
OPTI - Point of Issue Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodenVarChar
5
PRIMARYYes
DescDescriptionnVarChar
100
TypeTypeVarChar
P) Domestic Printing
E) Domestic Electronic
F) Fiscal
X) Export Printing
T) Export Electronic
1
P
SOpDateStart Operating DateDate
8
EndOpDateEnd Operating DateDate
8
RemarksRemarksnVarChar
100
EDocExpFrmElectronic Doc. Export FormatInt
11
BPLIdBranchInt
11OBPL
Business Place

Table relationship map

SELECT statement

SELECT OPTI.Code AS 'Code', OPTI.Desc AS 'Description', OPTI.Type AS 'Type', OPTI.SOpDate AS 'Start Operating Date', OPTI.EndOpDate AS 'End Operating Date', OPTI.Remarks AS 'Remarks', OPTI.EDocExpFrm AS 'Electronic Doc. Export Format', OPTI.BPLId AS 'Branch' FROM OPTI AS OPTI

Related information


OPTI SQL Table

Business Place OBPL 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