biuan SAP® BUSINESS ONE SDK
DTW Incoming Payments - Invoices
API Payments Invoices / Applied FC
RCT2 - Incoming Payments - Invoices Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument NumberInt
11ORCT
Incoming Payment
PRIMARYYes
InvoiceIdSequence No.Int
11
DocEntryInvoice KeyInt
11
SumAppliedPaid to InvoiceNum
20
AppliedFCPaid (FC)Num
20
AppliedSysPaid (SC)Num
20
InvTypeInvoice CategorynVarChar
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
selfInvAutom. InvoiceVarChar
N) No
Y) Yes
1
N
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
24
LogInstancLog InstanceInt
11
0
DcountDiscount RateNum
20
DcntSumDiscount AmountNum
20
DcntSumFCDiscount Amount (FC)Num
20
DcntSumSyDiscount Amount (SC)Num
20
BfDcntSumAmount Before DiscountNum
20
BfDcntSumFAmount Before Discount (FC)Num
20
BfDcntSumSAmount Before Discount (SC)Num
20
BfNetDcntNet Amount Before DiscountNum
20
BfNetDcntFNet Amt Before Discount (FC)Num
20
BfNetDcntSNet Amt Before Discount (SC)Num
20
PaidSumPaid Amount (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 WTax (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 Freight SumNum
20
ExpVatSumFVAT on Freight Sum (FC)Num
20
ExpVatSumSVAT on Freight 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
DocTransId KEYTrans. ID of Paid DocumentInt
11OJDT
Journal Entry
JDTNo
MIEntryMI Entry Include this PaymentInt
11
0
OcrCode2Distribution Rule 2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule 3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule 4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule 5nVarChar
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 RCT2.DocNum AS 'Document Number', RCT2.InvoiceId AS 'Sequence No.', RCT2.DocEntry AS 'Invoice Key', RCT2.SumApplied AS 'Paid to Invoice', RCT2.AppliedFC AS 'Paid (FC)', RCT2.AppliedSys AS 'Paid (SC)', RCT2.InvType AS 'Invoice Category', RCT2.DocRate AS 'Document Rate', RCT2.Flags AS 'Flags', RCT2.IntrsStat AS 'Interest Letter Status', RCT2.DocLine AS 'Row Key', RCT2.vatApplied AS 'Tax Definition', RCT2.vatAppldFC AS 'Tax Paid (FC)', RCT2.vatAppldSy AS 'Tax Paid (SC)', RCT2.selfInv AS 'Autom. Invoice', RCT2.ObjType AS 'Object Type', RCT2.LogInstanc AS 'Log Instance', RCT2.Dcount AS 'Discount Rate', RCT2.DcntSum AS 'Discount Amount', RCT2.DcntSumFC AS 'Discount Amount (FC)', RCT2.DcntSumSy AS 'Discount Amount (SC)', RCT2.BfDcntSum AS 'Amount Before Discount', RCT2.BfDcntSumF AS 'Amount Before Discount (FC)', RCT2.BfDcntSumS AS 'Amount Before Discount (SC)', RCT2.BfNetDcnt AS 'Net Amount Before Discount', RCT2.BfNetDcntF AS 'Net Amt Before Discount (FC)', RCT2.BfNetDcntS AS 'Net Amt Before Discount (SC)', RCT2.PaidSum AS 'Paid Amount (LC)', RCT2.ExpAppld AS 'Freight applied', RCT2.ExpAppldFC AS 'Freight applied FC', RCT2.ExpAppldSC AS 'Freight applied SC', RCT2.Rounddiff AS 'Rounding Diff.', RCT2.RounddifFc AS 'Rounding Diff. (FC)', RCT2.RounddifSc AS 'Rounding Diff. (SC)', RCT2.InstId AS 'Installment ID', RCT2.WtAppld AS 'Applied WTax', RCT2.WtAppldFC AS 'Applied WTax (FC)', RCT2.WtAppldSC AS 'Applied WTax (SC)', RCT2.LinkDate AS 'Link Date', RCT2.AmtDifPst AS 'Amount Diffs. Posting Date', RCT2.PaidDpm AS 'Paid Down Payment', RCT2.DpmPosted AS 'Link Date', RCT2.ExpVatSum AS 'VAT on Freight Sum', RCT2.ExpVatSumF AS 'VAT on Freight Sum (FC)', RCT2.ExpVatSumS AS 'VAT on Freight Sum (SC)', RCT2.IsRateDiff AS 'Is Exchange Rate', RCT2.WtInvCatS AS 'Withholding Tax Invoice Categ.', RCT2.WtInvCatSF AS 'Withholding Tax Invoice Categ.', RCT2.WtInvCatSS AS 'Withholding Tax Invoice Categ.', RCT2.OcrCode AS 'Distribution Rule', RCT2.DocTransId AS 'Trans. ID of Paid Document', RCT2.MIEntry AS 'MI Entry Include this Payment', RCT2.OcrCode2 AS 'Distribution Rule 2', RCT2.OcrCode3 AS 'Distribution Rule 3', RCT2.OcrCode4 AS 'Distribution Rule 4', RCT2.OcrCode5 AS 'Distribution Rule 5', RCT2.IsSelected AS 'Is Record Selected', RCT2.WTOnHold AS 'Withholding Tax On Hold', RCT2.WTOnhldPst AS 'Withholding Tax Posted', RCT2.baseAbs AS 'Base Document Number', RCT2.MIType AS 'MI Type Include this Payment' FROM RCT2 AS RCT2

Related information


Applied FC AppliedFC Property· Table: RCT2
Sets or returns the amount paid in foreign currency. Field name: AppliedFC.
· Table: RCT2 PDF2 VPM2    Parent: Payments Invoices Payments_Invoices Object· Table: RCT2 PDF2 VPM2
Incoming Payment ORCT 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