biuan SAP® BUSINESS ONE SDK
API ARC2
ARC2 - Incoming Payment - Invoices - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument NumberInt
11OVPM
Outgoing Payments
PRIMARYYes
InvoiceIdSequence No.Int
11
DocEntryInvoice KeyInt
11
SumAppliedPaid (LC)Num
20
AppliedFCPaid (FC)Num
20
AppliedSysPaid (SC)Num
20
InvTypeDocument TypenVarChar
203) A/R Down Payment
13) A/R Invoice
14) A/R Credit Memo
204) A/P Down Payment
18) A/P Invoice
19) A/P Credit Memo
24) Incoming Payment
25) Deposit
46) Payment Advice
57) Checks for Payment
76) Postdated Deposit
-2) Opening Balance
-3) Closing Balance
30) Journal Entry
-1) All Transactions
163) A/P Correction Invoice
165) A/R Correction Invoice
0
20
13
DocRateDocument RateNum
20
FlagsFlagsInt
11
0
IntrsStatInterest Letter StatusVarChar
U) Not Sent
S) Sent
C) Closed
1
U
DocLineRow KeyInt
11
0
vatAppliedTax DefinitionNum
20
vatAppldFCTax Paid (FC)Num
20
vatAppldSyTax Paid (SC)Num
20
selfInvAuto. InvoiceVarChar
N) No
Y) Yes
1
N
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
LogInstancLog InstanceInt
11
0
DcountDiscountNum
20
DcntSumDiscount AmountNum
20
DcntSumFCDiscount Amount (FC)Num
20
DcntSumSyDiscount Amount (SC)Num
20
BfDcntSumAmount Bef. DiscountNum
20
BfDcntSumFAmount Bef. Discount (FC)Num
20
BfDcntSumSAmount Bef. Discount (SC)Num
20
BfNetDcntNet Amount Bef. DiscountNum
20
BfNetDcntFNet Amount Bef. Discount (FC)Num
20
BfNetDcntSNet Amount Bef. Discount (SC)Num
20
PaidSumAmount Paid (LC)Num
20
ExpAppldFreight appliedNum
20
ExpAppldFCFreight applied FCNum
20
ExpAppldSCFreight applied SCNum
20
RounddiffRounding Diff.Num
20
RounddifFcRounding Diff. (FC)Num
20
RounddifScRounding Diff. (SC)Num
20
InstIdInstallment IDInt
6
1
WtAppldApplied WTaxNum
20
WtAppldFCApplied WT (FC)Num
20
WtAppldSCApplied WTax (SC)Num
20
LinkDateLink DateDate
8
AmtDifPstAmount Diffs. Posting DateDate
8
PaidDpmPaid Down PaymentVarChar
N) No
Y) Yes
1
N
DpmPostedLink DateVarChar
1
ExpVatSumVAT on Expenses SumNum
20
ExpVatSumFVAT on Expenses Sum (FC)Num
20
ExpVatSumSVAT on Expenses Sum (SC)Num
20
IsRateDiffIs Exchange RateVarChar
1
N
WtInvCatSWithholding Tax Invoice Categ.Num
20
WtInvCatSFWithholding Tax Invoice Categ.Num
20
WtInvCatSSWithholding Tax Invoice Categ.Num
20
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
DocTransIdTrans. ID of Paid DocumentInt
11OJDT
Journal Entry
MIEntryMI Entry Include this PaymentInt
11
0
OcrCode2Distribution Rule2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule5nVarChar
8OOCR
Distribution Rule
IsSelectedIs Record SelectedVarChar
Y) Yes
N) No
1
N
WTOnHoldWithholding Tax On HoldNum
20
WTOnhldPstWithholding Tax PostedNum
20
baseAbsBase Document NumberInt
11
MITypeMI Type Include this PaymentnVarChar
270) A/R Monthly Invoice
140000014) A/P Monthly Invoice
20

Table relationship map

SELECT statement

SELECT ARC2.DocNum AS 'Document Number', ARC2.InvoiceId AS 'Sequence No.', ARC2.DocEntry AS 'Invoice Key', ARC2.SumApplied AS 'Paid (LC)', ARC2.AppliedFC AS 'Paid (FC)', ARC2.AppliedSys AS 'Paid (SC)', ARC2.InvType AS 'Document Type', ARC2.DocRate AS 'Document Rate', ARC2.Flags AS 'Flags', ARC2.IntrsStat AS 'Interest Letter Status', ARC2.DocLine AS 'Row Key', ARC2.vatApplied AS 'Tax Definition', ARC2.vatAppldFC AS 'Tax Paid (FC)', ARC2.vatAppldSy AS 'Tax Paid (SC)', ARC2.selfInv AS 'Auto. Invoice', ARC2.ObjType AS 'Object Type', ARC2.LogInstanc AS 'Log Instance', ARC2.Dcount AS 'Discount', ARC2.DcntSum AS 'Discount Amount', ARC2.DcntSumFC AS 'Discount Amount (FC)', ARC2.DcntSumSy AS 'Discount Amount (SC)', ARC2.BfDcntSum AS 'Amount Bef. Discount', ARC2.BfDcntSumF AS 'Amount Bef. Discount (FC)', ARC2.BfDcntSumS AS 'Amount Bef. Discount (SC)', ARC2.BfNetDcnt AS 'Net Amount Bef. Discount', ARC2.BfNetDcntF AS 'Net Amount Bef. Discount (FC)', ARC2.BfNetDcntS AS 'Net Amount Bef. Discount (SC)', ARC2.PaidSum AS 'Amount Paid (LC)', ARC2.ExpAppld AS 'Freight applied', ARC2.ExpAppldFC AS 'Freight applied FC', ARC2.ExpAppldSC AS 'Freight applied SC', ARC2.Rounddiff AS 'Rounding Diff.', ARC2.RounddifFc AS 'Rounding Diff. (FC)', ARC2.RounddifSc AS 'Rounding Diff. (SC)', ARC2.InstId AS 'Installment ID', ARC2.WtAppld AS 'Applied WTax', ARC2.WtAppldFC AS 'Applied WT (FC)', ARC2.WtAppldSC AS 'Applied WTax (SC)', ARC2.LinkDate AS 'Link Date', ARC2.AmtDifPst AS 'Amount Diffs. Posting Date', ARC2.PaidDpm AS 'Paid Down Payment', ARC2.DpmPosted AS 'Link Date', ARC2.ExpVatSum AS 'VAT on Expenses Sum', ARC2.ExpVatSumF AS 'VAT on Expenses Sum (FC)', ARC2.ExpVatSumS AS 'VAT on Expenses Sum (SC)', ARC2.IsRateDiff AS 'Is Exchange Rate', ARC2.WtInvCatS AS 'Withholding Tax Invoice Categ.', ARC2.WtInvCatSF AS 'Withholding Tax Invoice Categ.', ARC2.WtInvCatSS AS 'Withholding Tax Invoice Categ.', ARC2.OcrCode AS 'Distribution Rule', ARC2.DocTransId AS 'Trans. ID of Paid Document', ARC2.MIEntry AS 'MI Entry Include this Payment', ARC2.OcrCode2 AS 'Distribution Rule2', ARC2.OcrCode3 AS 'Distribution Rule3', ARC2.OcrCode4 AS 'Distribution Rule4', ARC2.OcrCode5 AS 'Distribution Rule5', ARC2.IsSelected AS 'Is Record Selected', ARC2.WTOnHold AS 'Withholding Tax On Hold', ARC2.WTOnhldPst AS 'Withholding Tax Posted', ARC2.baseAbs AS 'Base Document Number', ARC2.MIType AS 'MI Type Include this Payment' FROM ARC2 AS ARC2

Related information


Outgoing Payments OVPM SQL Table

Journal Entry OJDT SQL Table

Object Settings - History ADP1 SQL Table

Distribution Rule OOCR 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