biuan SAP® BUSINESS ONE SDK
API OHSV
OHSV - Hasavsevet Journal Entry Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
RecordKey KEY UNIQUERecord NumbernVarChar
7
PRIMARYYes
Ref1Reference 1nVarChar
5
Ref2Reference 2nVarChar
5
RefDatePosting DatenVarChar
6
DueDateDue DatenVarChar
6
CurrCodeCurrency CodenVarChar
3
MemoDetailsnVarChar
22
DebAcct1Debit Account 1nVarChar
8
CredAcct1Credit Account 1nVarChar
8
DebAmnt1DebitnVarChar
12
credAmnt1CreditnVarChar
12
FDebAmnt1Debit Amount 1 in FCnVarChar
12
FCredAmnt1Credit in FCnVarChar
12
FillerFillernVarChar
60
EndFieldEnding FieldnVarChar
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




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