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

SQL

Finance /

Credit Memo - Area Journal Transactions

API ACD2

ACD2 - Credit Memo - Area Journal Transactions Table

SBO SQL database table details

Field	Description	Type	Size	Related	Default	Primary_Key	Unique
DocEntry ^KEY ^UNIQUE	Document Internal ID	Int	11	OACD Credit Memo		PRIMARY	Yes
LineNum	Row Number	Int	11
DprArea	Depreciation Area	nVarChar	15	ODPA Fixed Asset Depreciation Areas
JrnlMemo	Journal Remarks	nVarChar	50
ObjType	Object Type	nVarChar	20
LogInstanc	Log Instance	Int	11		0
TransNum	Transaction Number	Int	11	OJDT Journal Entry
JrnlMemo1	Cancellation Journal Remarks	nVarChar	50
TransNum1	Cancellation Transaction No.	Int	11	OJDT Journal Entry

Table relationship map

SELECT statement

SELECT
   ACD2.DocEntry AS 'Document Internal ID', 
   ACD2.LineNum AS 'Row Number', 
   ACD2.DprArea AS 'Depreciation Area', 
   ACD2.JrnlMemo AS 'Journal Remarks', 
   ACD2.ObjType AS 'Object Type', 
   ACD2.LogInstanc AS 'Log Instance', 
   ACD2.TransNum AS 'Transaction Number', 
   ACD2.JrnlMemo1 AS 'Cancellation Journal Remarks', 
   ACD2.TransNum1 AS 'Cancellation Transaction No.'
FROM ACD2 AS ACD2

Related information

OACD SQL Table

ODPA SQL Table

OJDT 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates