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

SQL Marketing Documents and Receipts / Gross Profit Adjustment - JE Details Accounts

API GPA4

GPA4 - Gross Profit Adjustment - JE Details Accounts Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal Key	Int		11	OGPA Gross Profit Adjustment		PRIMARY	Yes
LineId	Row No.	Int		11
LineType	Line Type	VarChar	T) Total A) Account	1		T
CurrCogs	Current COGS	Num		20
CalcCogs	Calculated COGS	Num		20
CogsDebit	COGS Debit	Num		20
CogsCredit	COGS Credit	Num		20
CogsAcct	COGS Account	nVarChar		15
PrDiffAcct	Price Difference Account	nVarChar		15
AutoPost	Automatic Posting	VarChar	Y) Yes N) No	1		Y

SELECT statement

SELECT
   GPA4.AbsEntry AS 'Internal Key', 
   GPA4.LineId AS 'Row No.', 
   GPA4.LineType AS 'Line Type', 
   GPA4.CurrCogs AS 'Current COGS', 
   GPA4.CalcCogs AS 'Calculated COGS', 
   GPA4.CogsDebit AS 'COGS Debit', 
   GPA4.CogsCredit AS 'COGS Credit', 
   GPA4.CogsAcct AS 'COGS Account', 
   GPA4.PrDiffAcct AS 'Price Difference Account', 
   GPA4.AutoPost AS 'Automatic Posting'
FROM GPA4 AS GPA4

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