📚 SAP Business One SDK Help

Table Name: OCRV

Table Description: Credit Payments

Field Description Type Size Related Default Value Constraints
AbsId Seq. No. in Amount Int 11 OCRH      
PayId Payment No. Int 11 - 0    
CreditCard Credit Card Int 6 OCRC 0    
CrdCardNum Credit Card No. nVarChar 254 -      
CardValid Credit Card Validity Date 8 -      
VoucherNum Voucher Number nVarChar 27 -      
OwnerIdNum ID Number nVarChar 15 -      
OwnerPhone Telephone nVarChar 50 -      
PayDate Payment Date Date 8 -      
PayAmount Payment Amount Num 19.6 -      
CreditCurr Credit Currency nVarChar 3 -      
CreditRate Credit Rate Num 19.6 -      
Deposited Paid VarChar 1 - O C Closed
            O Open
            S Postdated
DepNum2 Postdated Deposit Key Int 11 ODPT 0    
DepNum Payment Internal ID Int 11 ODPS      
AcctCode Account for Payments nVarChar 15 OACT      
VouchAcct Voucher Account nVarChar 15 OACT      
CreditAcct Credit Account nVarChar 15 -      
CardCode BP/Account Code nVarChar 15 OCRD      
CrTypeCode Payment Method Code Int 6 OCRP      
NumOfPmnts Number of Payments Int 6 - 1    
Canceled Canceled VarChar 1 - N Y Yes
            N No
Storno Cancel Transaction VarChar 1 - N Y Yes
            N No
Transfered Postponed to Next Year VarChar 1 - N Y Yes
            N No
Instance Instance Int 6 OCRH 0    
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
UserSign User Signature Int 6 OUSR      
TransRef Trans. Reference nVarChar 20 -      
CardName BP/Account Name nVarChar 200 -      
EnOwnerId Encryption of ID Number Text 16 -      
EncryptIV Encrypt IV nVarChar 100 -      
Key Unique Field
PRIMARY Yes AbsId
    PayId
    Instance
CRED_CARD No CreditCard
CUST_CODE No CardCode
DEP_ABS1 No DepNum
IS_VALID No VoucherNum
    PayId
    CreditCard
    Storno
CRED_ACCT No CreditAcct
DEP_ABS2 No DepNum2
DEPOSITED No Deposited
VOUCHER_ID No AbsId