biuan SAP® BUSINESS ONE SDK
DTW Sales / AR Credit Memo
API OPCI
OPCI - Process Checklist Instance Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
InstancePk KEY UNIQUEInstance Primary KeyInt
11
PRIMARYYes
TemplateFkTemplate Foreign KeyInt
11OPCT
Process Checklist Template
InstNameInstance NamenVarChar
100
InstDescInstance DescriptionnVarChar
100
CreatorInstance CreatornVarChar
100
StatusInstance StatusVarChar
N) New
P) In Process
F) Finished
1
N
StartDateStart DateDate
8
CloseDateClose DateDate
8
CloPrcntClosing PercentageNum
20
MemoRemarksText
16
AttachmentAttachmentText
16
AtcEntryAttachment EntryInt
11

Table relationship map

SELECT statement

SELECT OPCI.InstancePk AS 'Instance Primary Key', OPCI.TemplateFk AS 'Template Foreign Key', OPCI.InstName AS 'Instance Name', OPCI.InstDesc AS 'Instance Description', OPCI.Creator AS 'Instance Creator', OPCI.Status AS 'Instance Status', OPCI.StartDate AS 'Start Date', OPCI.CloseDate AS 'Close Date', OPCI.CloPrcnt AS 'Closing Percentage', OPCI.Memo AS 'Remarks', OPCI.Attachment AS 'Attachment', OPCI.AtcEntry AS 'Attachment Entry' FROM OPCI AS OPCI

Related information


OPCI SQL Table

Process Checklist Template OPCT 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