biuan SAP® BUSINESS ONE SDK
API AMD1
AMD1 - Amout Differences Report Lines Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
LineNum KEY UNIQUEInternal IDInt
11
PRIMARYYes
PmnNumPayment NumberInt
11ORCT
Incoming Payment
PmnInvIDInvoice Seq. No. in PaymentInt
11
PmnDatePayment DateDate
8
CardCodeBP CodenVarChar
15OCRD
Business Partner
InvTypeInvoice CategorynVarChar
13) Sales Invoice
20
13
InvEntryInvoice KeyInt
11OINV
A/R Invoice
InstIdInstallment IDInt
6
InvTransIDInvoice Transaction NumberInt
11OJDT
Journal Entry
FCCurrencyForeign CurrencynVarChar
3OCRN
Currency Codes
InvRateRate, InvoiceNum
20
PmnRateRate, PaymentNum
20
ApprovedConfirmedVarChar
Y) Yes
N) No
1
Y
AmountDiffAmount Difference (LC)Num
20
TaxAmtDiffTax Difference (LC)Num
20
TMP_JETemporary Transaction IDnVarChar
50

Table relationship map

SELECT statement

SELECT AMD1.LineNum AS 'Internal ID', AMD1.PmnNum AS 'Payment Number', AMD1.PmnInvID AS 'Invoice Seq. No. in Payment', AMD1.PmnDate AS 'Payment Date', AMD1.CardCode AS 'BP Code', AMD1.InvType AS 'Invoice Category', AMD1.InvEntry AS 'Invoice Key', AMD1.InstId AS 'Installment ID', AMD1.InvTransID AS 'Invoice Transaction Number', AMD1.FCCurrency AS 'Foreign Currency', AMD1.InvRate AS 'Rate, Invoice', AMD1.PmnRate AS 'Rate, Payment', AMD1.Approved AS 'Confirmed', AMD1.AmountDiff AS 'Amount Difference (LC)', AMD1.TaxAmtDiff AS 'Tax Difference (LC)', AMD1.TMP_JE AS 'Temporary Transaction ID' FROM AMD1 AS AMD1

Related information


Business Partner OCRD SQL Table

Currency Codes OCRN SQL Table

A/R Invoice OINV SQL Table

Journal Entry OJDT SQL Table

Incoming Payment ORCT 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