biuan SAP® BUSINESS ONE SDK
API Credit Lines / Credit Line
OCRH - Credit Card Management Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUESeq. No. in AmountInt
11
PRIMARYYes
CreditCardCredit CardInt
6OCRC
Credit Cards
0
CrdCardNumCredit Card No.nVarChar
64
CardValidCredit Card ValidityDate
8
VoucherNum KEYVoucher NumbernVarChar
20
IS_VALIDNo
OwnerIdNumID NumbernVarChar
15
OwnerPhoneTelephonenVarChar
20
CrTypeCodePayment Method CodeInt
6OCRP
Payment Methods
NumOfPmntsNumber of PaymentsInt
6
1
PayDatePayment DateDate
8
FirstSumFirst Partial PaymentNum
20
AddPmntSumEach Additional PaymentNum
20
CreditSumCredit AmountNum
20
CreditCurrCredit CurrencynVarChar
3
CreditRateCredit RateNum
20
ConfNumConfirmation NumbernVarChar
20
CreditType KEYCredit Transaction TypeVarChar
U) Telephone Transaction
S) Regular
I) Internet Transaction
1
SCRED_TYPENo
CreditDpsCredit Deposit TypeVarChar
Y) Manual
N) Automatic
1
Y
DepositedPaidVarChar
Y) Yes
N) No
1
N
DeposDatePayment DateDate
8
RctAbs KEYReceipt No.Int
11ORCT
Incoming Payment
RECEIPTNo
DepNum KEYPayment Internal IDInt
11ODPS
Deposit
DEP_ABSNo
AcctCodeAccount for PaymentsnVarChar
15OACT
G/L Accounts
CreditAcct KEYCredit AccountnVarChar
15
CRED_ACCTNo
CardCode KEYBP/Account CodenVarChar
15OCRD
Business Partner
CUST_CODENo
CanceledCanceledVarChar
Y) Yes
N) No
1
N
StornoCancel TransactionVarChar
Y) Yes
N) No
1
N
RcptLineIdRow Number in ReceiptInt
11
RecivedReceivedNum
20
ConvertedEndorsedVarChar
Y) Yes
N) No
1
N
ConvertToEndorsed fornVarChar
15
TransferedPostponed to Next YearVarChar
Y) Yes
N) No
1
N
InstanceInstanceInt
6
0
UserSignUser SignatureInt
6OUSR
Users
TransRefTrans. ReferencenVarChar
20
CreateDateCreation DateDate
8
ConsolNumVendor Credit CodeInt
11
-1
ProjectProject CodenVarChar
20OPRJ
Project Codes
CardNameBP/Account NamenVarChar
100

Table relationship map

SELECT statement

SELECT OCRH.AbsId AS 'Seq. No. in Amount', OCRH.CreditCard AS 'Credit Card', OCRH.CrdCardNum AS 'Credit Card No.', OCRH.CardValid AS 'Credit Card Validity', OCRH.VoucherNum AS 'Voucher Number', OCRH.OwnerIdNum AS 'ID Number', OCRH.OwnerPhone AS 'Telephone', OCRH.CrTypeCode AS 'Payment Method Code', OCRH.NumOfPmnts AS 'Number of Payments', OCRH.PayDate AS 'Payment Date', OCRH.FirstSum AS 'First Partial Payment', OCRH.AddPmntSum AS 'Each Additional Payment', OCRH.CreditSum AS 'Credit Amount', OCRH.CreditCurr AS 'Credit Currency', OCRH.CreditRate AS 'Credit Rate', OCRH.ConfNum AS 'Confirmation Number', OCRH.CreditType AS 'Credit Transaction Type', OCRH.CreditDps AS 'Credit Deposit Type', OCRH.Deposited AS 'Paid', OCRH.DeposDate AS 'Payment Date', OCRH.RctAbs AS 'Receipt No.', OCRH.DepNum AS 'Payment Internal ID', OCRH.AcctCode AS 'Account for Payments', OCRH.CreditAcct AS 'Credit Account', OCRH.CardCode AS 'BP/Account Code', OCRH.Canceled AS 'Canceled', OCRH.Storno AS 'Cancel Transaction', OCRH.RcptLineId AS 'Row Number in Receipt', OCRH.Recived AS 'Received', OCRH.Converted AS 'Endorsed', OCRH.ConvertTo AS 'Endorsed for', OCRH.Transfered AS 'Postponed to Next Year', OCRH.Instance AS 'Instance', OCRH.UserSign AS 'User Signature', OCRH.TransRef AS 'Trans. Reference', OCRH.CreateDate AS 'Creation Date', OCRH.ConsolNum AS 'Vendor Credit Code', OCRH.Project AS 'Project Code', OCRH.CardName AS 'BP/Account Name' FROM OCRH AS OCRH

Related information


Credit Line CreditLine Object· Table: OCRH
Represents the deposits for credit card vouchers. Source table: OCRH.
   Parent: Credit Lines CreditLines Collection

Credit Lines Service CreditLinesService Service· Table: OCRH
The CreditLinesService service enables you to get deposits for credit card vouchers. Source table: OCRH.

OCRH SQL Table

G/L Accounts OACT SQL Table

Business Partner OCRD SQL Table

Credit Cards OCRC SQL Table

Payment Methods OCRP SQL Table

Deposit ODPS SQL Table

Project Codes OPRJ SQL Table

Incoming Payment ORCT SQL Table

Users OUSR 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