OEI22 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Marketing Documents and Receipts / Outgoing Excise Invoice - Resource Costs

API OEI22

OEI22 - Outgoing Excise Invoice - Resource Costs Table

SBO SQL database table details

Field	Description	Type	Size	Related	Default	Primary_Key	Unique
DocEntry ^KEY ^UNIQUE	Document Internal ID	Int	11	OEI1 Outgoing Excise Invoice - Rows		PRIMARY	Yes
LineNum	Row Number	Int	11	OEI1 Outgoing Excise Invoice - Rows
StdCostNum	Resource Standard Cost Number	Int	11
Price	Price	Num	20
Total	Total	Num	20
ObjectType	Object Type	nVarChar	20		140000009
LogInstanc	Log Instance	Int	11		0

SELECT statement

SELECT
   OEI22.DocEntry AS 'Document Internal ID', 
   OEI22.LineNum AS 'Row Number', 
   OEI22.StdCostNum AS 'Resource Standard Cost Number', 
   OEI22.Price AS 'Price', 
   OEI22.Total AS 'Total', 
   OEI22.ObjectType AS 'Object Type', 
   OEI22.LogInstanc AS 'Log Instance'
FROM OEI22 AS OEI22

Related information

OEI1 SQL Table

biuan SAP® BUSINESS ONE

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