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

SQL Finance / Hasavsevet Journal Entry

API OHSV

SBO SQL database table details

Field	Description	Type	Size	Primary_Key	Unique
RecordKey ^KEY ^UNIQUE	Record Number	nVarChar	7	PRIMARY	Yes
Ref1	Reference 1	nVarChar	5
Ref2	Reference 2	nVarChar	5
RefDate	Posting Date	nVarChar	6
DueDate	Due Date	nVarChar	6
CurrCode	Currency Code	nVarChar	3
Memo	Details	nVarChar	22
DebAcct1	Debit Account 1	nVarChar	8
CredAcct1	Credit Account 1	nVarChar	8
DebAmnt1	Debit	nVarChar	12
credAmnt1	Credit	nVarChar	12
FDebAmnt1	Debit Amount 1 in FC	nVarChar	12
FCredAmnt1	Credit in FC	nVarChar	12
Filler	Filler	nVarChar	60
EndField	Ending Field	nVarChar	2

SELECT statement

SELECT
   OHSV.RecordKey AS 'Record Number', 
   OHSV.Ref1 AS 'Reference 1', 
   OHSV.Ref2 AS 'Reference 2', 
   OHSV.RefDate AS 'Posting Date', 
   OHSV.DueDate AS 'Due Date', 
   OHSV.CurrCode AS 'Currency Code', 
   OHSV.Memo AS 'Details', 
   OHSV.DebAcct1 AS 'Debit Account 1', 
   OHSV.CredAcct1 AS 'Credit Account 1', 
   OHSV.DebAmnt1 AS 'Debit', 
   OHSV.credAmnt1 AS 'Credit', 
   OHSV.FDebAmnt1 AS 'Debit Amount 1 in FC', 
   OHSV.FCredAmnt1 AS 'Credit in FC', 
   OHSV.Filler AS 'Filler', 
   OHSV.EndField AS 'Ending Field'
FROM OHSV AS OHSV

Related information

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