biuan SAP® BUSINESS ONE SDK
API WOR2V
WOR2V - Production Order - Base Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal NumberInt
11OWOR
Production Order
PRIMARYYes
BaseEntryProduction Order Base EntryInt
11ORDR
Sales Order
BaseNumProduction Order Base NumberInt
11
CardCodeCustomer CodenVarChar
15
PostDatePosting DatenVarChar
8
DueDateDue DatenVarChar
8
DocTotalDocument TotalNum
20
RemarkDocument RemarksnVarChar
127
DocCurDocument CurrencynVarChar
3

Table relationship map

SELECT statement

SELECT WOR2V.DocEntry AS 'Document Internal Number', WOR2V.BaseEntry AS 'Production Order Base Entry', WOR2V.BaseNum AS 'Production Order Base Number', WOR2V.CardCode AS 'Customer Code', WOR2V.PostDate AS 'Posting Date', WOR2V.DueDate AS 'Due Date', WOR2V.DocTotal AS 'Document Total', WOR2V.Remark AS 'Document Remarks', WOR2V.DocCur AS 'Document Currency' FROM WOR2V AS WOR2V

Related information


Sales Order ORDR SQL Table

Production Order OWOR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates