biuan SAP® BUSINESS ONE SDK
API RCC4
RCC4 - Incoming Payment - Credit Vouchers Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument NumberInt
11ORCT
Incoming Payment
PRIMARYYes
LineIdRow NumberInt
11
AcctCodeCredit CardnVarChar
15OCRC
Credit Cards
-1
SumAppliedCredit AmountNum
20
AppliedFCCredit Card NumberNum
20
AppliedSysCredit Card ValidityNum
20
DescripVoucher NumbernVarChar
127
VatGroupID NumbernVarChar
8OVTG
Tax Definition
VatPrcntTelephoneNum
20
AcctNamePayment Method CodenVarChar
100
-1
ObjTypeNumber of PaymentsnVarChar
20ADP1
Object Settings - History
1
LogInstancFirst Payment DateInt
11
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
ProjectProject CodenVarChar
20OPRJ
Project Codes
GrossAmntGross AmountNum
20
GrssAmntFCGross Amount (FC)Num
20
GrssAmntSCGross Amount (SC)Num
20
AmntBaseBase AmountVarChar
E) Exclude Tax
I) Include Tax
1
VatAmntVAT AmountNum
20
VatAmntFCVAT Amount (FC)Num
20
VatAmntSCVAT Amount (SC)Num
20
UserChaVatUser Changed VATVarChar
N) No
Y) Yes
1
N
TaxTypeIDTax Type Component IDInt
11OSTT
Sales Tax Authorities Type
OcrCode2Distribution Rule2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule5nVarChar
8OOCR
Distribution Rule
SectionSectionInt
11OSEC
Sections
AsseTypeAssessee TypeVarChar
C) Company
P) Others
1
LocCodeLocation CodeInt
11OLCT
Location
MatTypeMaterial TypeInt
11
0
EquVatPerEqualization Tax RateNum
20
EquVatSumEqualization VAT AmountNum
20
EquVatSumFEqualization VAT Amount (FC)Num
20
EquVatSumSEqualization VAT Amount (SC)Num
20

Table relationship map

SELECT statement

SELECT RCC4.DocNum AS 'Document Number', RCC4.LineId AS 'Row Number', RCC4.AcctCode AS 'Credit Card', RCC4.SumApplied AS 'Credit Amount', RCC4.AppliedFC AS 'Credit Card Number', RCC4.AppliedSys AS 'Credit Card Validity', RCC4.Descrip AS 'Voucher Number', RCC4.VatGroup AS 'ID Number', RCC4.VatPrcnt AS 'Telephone', RCC4.AcctName AS 'Payment Method Code', RCC4.ObjType AS 'Number of Payments', RCC4.LogInstanc AS 'First Payment Date', RCC4.OcrCode AS 'Distribution Rule', RCC4.Project AS 'Project Code', RCC4.GrossAmnt AS 'Gross Amount', RCC4.GrssAmntFC AS 'Gross Amount (FC)', RCC4.GrssAmntSC AS 'Gross Amount (SC)', RCC4.AmntBase AS 'Base Amount', RCC4.VatAmnt AS 'VAT Amount', RCC4.VatAmntFC AS 'VAT Amount (FC)', RCC4.VatAmntSC AS 'VAT Amount (SC)', RCC4.UserChaVat AS 'User Changed VAT', RCC4.TaxTypeID AS 'Tax Type Component ID', RCC4.OcrCode2 AS 'Distribution Rule2', RCC4.OcrCode3 AS 'Distribution Rule3', RCC4.OcrCode4 AS 'Distribution Rule4', RCC4.OcrCode5 AS 'Distribution Rule5', RCC4.Section AS 'Section', RCC4.AsseType AS 'Assessee Type', RCC4.LocCode AS 'Location Code', RCC4.MatType AS 'Material Type', RCC4.EquVatPer AS 'Equalization Tax Rate', RCC4.EquVatSum AS 'Equalization VAT Amount', RCC4.EquVatSumF AS 'Equalization VAT Amount (FC)', RCC4.EquVatSumS AS 'Equalization VAT Amount (SC)' FROM RCC4 AS RCC4

Related information


Credit Cards OCRC SQL Table

Incoming Payment ORCT SQL Table

Location OLCT SQL Table

Object Settings - History ADP1 SQL Table

Distribution Rule OOCR SQL Table

Project Codes OPRJ SQL Table

Sections OSEC SQL Table

Sales Tax Authorities Type OSTT SQL Table

Tax Definition OVTG 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