biuan SAP® BUSINESS ONE SDK
API ARC3
ARC3 - Credit Vouchers History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument No.Int
11OVPM
Outgoing Payments
PRIMARYYes
LineIDRow No.Int
11
CreditCardCredit CardInt
6OCRC
Credit Cards
-1
CreditAcctCredit AmountnVarChar
15OACT
G/L Accounts
CrCardNumCredit Card No.nVarChar
64
CardValidCredit Card Valid UntilDate
8
VoucherNumCredit Voucher No.nVarChar
20
OwnerIdNumID NumbernVarChar
15
OwnerPhoneTelephonenVarChar
20
CrTypeCodePayment Method CodeInt
6OCRP
Payment Methods
-1
NumOfPmntsNo. of PaymentsInt
6
1
FirstDue1st Payment DateDate
8
FirstSumFirst Partial PaymentNum
20
AddPmntSumEach Additional PaymentNum
20
CreditSumCredit AmountNum
20
CreditCurCredit Voucher CurrencynVarChar
3OCRN
Currency Codes
CreditRateCredit Voucher RateNum
20
ConfNumConfirmation No.nVarChar
20
CreditTypeCredit Transaction TypeVarChar
U) Telephone Transaction
S) Regular
I) Internet Transaction
1
S
CredPmntsNo. of Credit PaymentsInt
6
1
PlCrdStatPelecard Debit StatusnVarChar
4
-1
MagnetStrMagnetic Stripe ContentnVarChar
40
SpiltCredSplit Credit Voucher PaymentVarChar
Y) Yes
N) No
1
N
ConsolNumVendor Credit CodeInt
11OPVL
Lender - Pelecard
-1
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT ARC3.DocNum AS 'Document No.', ARC3.LineID AS 'Row No.', ARC3.CreditCard AS 'Credit Card', ARC3.CreditAcct AS 'Credit Amount', ARC3.CrCardNum AS 'Credit Card No.', ARC3.CardValid AS 'Credit Card Valid Until', ARC3.VoucherNum AS 'Credit Voucher No.', ARC3.OwnerIdNum AS 'ID Number', ARC3.OwnerPhone AS 'Telephone', ARC3.CrTypeCode AS 'Payment Method Code', ARC3.NumOfPmnts AS 'No. of Payments', ARC3.FirstDue AS '1st Payment Date', ARC3.FirstSum AS 'First Partial Payment', ARC3.AddPmntSum AS 'Each Additional Payment', ARC3.CreditSum AS 'Credit Amount', ARC3.CreditCur AS 'Credit Voucher Currency', ARC3.CreditRate AS 'Credit Voucher Rate', ARC3.ConfNum AS 'Confirmation No.', ARC3.CreditType AS 'Credit Transaction Type', ARC3.CredPmnts AS 'No. of Credit Payments', ARC3.PlCrdStat AS 'Pelecard Debit Status', ARC3.MagnetStr AS 'Magnetic Stripe Content', ARC3.SpiltCred AS 'Split Credit Voucher Payment', ARC3.ConsolNum AS 'Vendor Credit Code', ARC3.ObjType AS 'Object Type', ARC3.LogInstanc AS 'Log Instance' FROM ARC3 AS ARC3

Related information


Lender - Pelecard OPVL SQL Table

G/L Accounts OACT SQL Table

Credit Cards OCRC SQL Table

Currency Codes OCRN SQL Table

Payment Methods OCRP SQL Table

Outgoing Payments OVPM SQL Table

Object Settings - History ADP1 SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates