biuan SAP® BUSINESS ONE SDK
API OAMD
OAMD - Amount Differences Report Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
LineNum KEY UNIQUEInternal IDInt
11
PRIMARYYes
DateFromDate FromDate
8
DateToDate ToDate
8
CardCodeBP CodenVarChar
15OCRD
Business Partner
ApprovedConfirmedVarChar
Y) Yes
N) No
1
N
AmountDiffAmount Difference (LC)Num
20
TaxAmtDiffTax Difference (LC)Num
20
RpCurrencyCurrency Chosen for the ReportnVarChar
3OCRN
Currency Codes
VendOffActVendor Offset AccountnVarChar
15OACT
G/L Accounts

Table relationship map

SELECT statement

SELECT OAMD.LineNum AS 'Internal ID', OAMD.DateFrom AS 'Date From', OAMD.DateTo AS 'Date To', OAMD.CardCode AS 'BP Code', OAMD.Approved AS 'Confirmed', OAMD.AmountDiff AS 'Amount Difference (LC)', OAMD.TaxAmtDiff AS 'Tax Difference (LC)', OAMD.RpCurrency AS 'Currency Chosen for the Report', OAMD.VendOffAct AS 'Vendor Offset Account' FROM OAMD AS OAMD

Related information


Business Partner OCRD SQL Table

Currency Codes OCRN SQL Table

G/L Accounts OACT 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