biuan SAP® BUSINESS ONE SDK
API GPA3
GPA3 - Gross Profit Adjustment - JE Details Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal KeyInt
11OGPA
Gross Profit Adjustment
PRIMARYYes
PostDatePosting DateDate
8
DocDateDocument DateDate
8
DueDateDue DateDate
8
SeriesSeriesInt
6
0
JERemarksJournal RemarksnVarChar
50
TransCodeTransaction CodenVarChar
4
Ref1Reference 1nVarChar
100
Ref2Reference 2nVarChar
100
JERefJournal Entry ReferencenVarChar
11

SELECT statement

SELECT GPA3.AbsEntry AS 'Internal Key', GPA3.PostDate AS 'Posting Date', GPA3.DocDate AS 'Document Date', GPA3.DueDate AS 'Due Date', GPA3.Series AS 'Series', GPA3.JERemarks AS 'Journal Remarks', GPA3.TransCode AS 'Transaction Code', GPA3.Ref1 AS 'Reference 1', GPA3.Ref2 AS 'Reference 2', GPA3.JERef AS 'Journal Entry Reference' FROM GPA3 AS GPA3

Related information


Gross Profit Adjustment OGPA SQL Table



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