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

SQL Marketing Documents and Receipts / Product Cost Adjustment - Journal Entry Details

API GPA7

GPA7 - Product Cost Adjustment - Journal Entry Details Table

SBO SQL database table details

Field	Description	Type	Size	Related	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal Key	Int	11	OGPA Gross Profit Adjustment		PRIMARY	Yes
PostDate	Posting Date	Date	8
DocDate	Document Date	Date	8
Series	Series	Int	6		0
Ref2	Reference 2	nVarChar	100
JERemarks	Journal Remarks	nVarChar	50
MRVRef	MRV Entry Reference	nVarChar	11

SELECT statement

SELECT
   GPA7.AbsEntry AS 'Internal Key', 
   GPA7.PostDate AS 'Posting Date', 
   GPA7.DocDate AS 'Document Date', 
   GPA7.Series AS 'Series', 
   GPA7.Ref2 AS 'Reference 2', 
   GPA7.JERemarks AS 'Journal Remarks', 
   GPA7.MRVRef AS 'MRV Entry Reference'
FROM GPA7 AS GPA7

Related information

OGPA 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