biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Production Order - Base
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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates