📚 SAP Business One SDK Help

Table Name: ODPS

Table Description: Deposit

Field Description Type Size Related Default Value Constraints
DeposId Payment Internal ID Int 11 - 0    
DeposType Payment Type VarChar 1 - K K Check Deposit
            C Cash Payment
            V Credit Deposit
            B Bill of Exchange
DeposNum Payment No. Int 11 -      
DeposDate Payment Date Date 8 -      
DeposCurr Currency for Payments nVarChar 3 -      
BanckAcct Deposit Account nVarChar 15 -      
DeposAcct Bank Account Number nVarChar 50 -      
DeposBrnch Branch for Payments nVarChar 50 -      
Memo Details nVarChar 254 -      
LocTotal Total (LC) Num 19.6 -      
FcTotal Total (FC) Num 19.6 -      
SysTotal Total (SC) Num 19.6 -      
TransAbs Journal Entry Key Int 11 OJDT      
Ref1 Reference 1 nVarChar 11 -      
Ref2 Reference 2 nVarChar 11 -      
DocTime Pay-In Time Int 6 -      
AllocAcct Cash nVarChar 15 -      
ChkType Check Deposit Type VarChar 1 - C C Cash Checks
            S Postdated Checks
DpsBank Bank Name for Payments nVarChar 30 -      
DpostorNam Name of Depositor nVarChar 30 -      
Printed Original/Copy VarChar 1 - N Y Yes
            N No
DocRate Payment Rate Num 19.6 -      
CrdBankAct Voucher Account nVarChar 15 -      
IsCard Business Partner or Account VarChar 1 - A A G/L Account
            C BP
Transfered Year Transfer VarChar 1 - N Y Yes
            N No
UpdateDate Date of Update Date 8 -      
Splited Split VarChar 1 - N Y Yes
            N No
CreateDate Creation Date Date 8 -      
VatAct Tax Account nVarChar 15 -      
ComissAct Commissions Account nVarChar 15 -      
VatTotal Total Tax Num 19.6 -      
Comission Commission Num 19.6 -      
ComissDate Commission Date Date 8 -      
TaxDate Document Date Date 8 -      
Series Series Int 11 -      
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
ObjType Object Type nVarChar 20 ADP1      
FinncPriod Posting Period Int 11 OFPR      
VatTotlSys Total Tax on Input (SC) Num 19.6 -      
ComissnSys Total Commission (SC) Num 19.6 -      
UserSign User Signature Int 6 OUSR      
DepostNorm Deposit Norm nVarChar 8 -      
PostType Transaction Type VarChar 1 - C C Collection
            D Discounted
BankCountr Bank Country/Region nVarChar 3 OCRY      
Canceled Canceled VarChar 1 - N Y Yes
            N No
CnclDps Cancel Deposit Int 11 - -1    
CommisVat Commission VAT Group nVarChar 8 OVTG      
SeqCode Sequence Code Int 6 -      
Serial Serial Number Int 11 -      
SeriesStr Series String nVarChar 3 -      
SubStr Subseries String nVarChar 3 -      
Project Project Code nVarChar 20 OPRJ      
ReconAfter Reconcile Amounts After Dpst VarChar 1 - Y    
OcrCode Distribution Rule nVarChar 8 OOCR      
OcrCode2 Distribution Rule 2 nVarChar 8 OOCR      
OcrCode3 Distribution Rule 3 nVarChar 8 OOCR      
OcrCode4 Distribution Rule 4 nVarChar 8 OOCR      
OcrCode5 Distribution Rule 5 nVarChar 8 OOCR      
ComisFC Total Commission (FC) Num 19.6 -      
VatTotlFC Total Tax on Input (FC) Num 19.6 -      
ComisCurr Commission Currency nVarChar 3 -      
SupplCode Supplementary Code nVarChar 254 -      
BPLId Branch Int 11 OBPL      
SysRate System Currency Rate Num 19.6 -      
AtcEntry Attachment Entry Int 11 OATC      
Attachment Attachment Text 16 -      
IncomeAct Withholding Income Tax Account nVarChar 15 -      
IncomeLC Withholding Income Tax LC Num 19.6 -      
IncomeFC Withholding Income Tax FC Num 19.6 -      
IncomeSC Withholding Income Tax SC Num 19.6 -      
UpdateTS Update Full Time Int 11 -      
VersionNum Version Number nVarChar 13 -      
EncryptIV Encrypt IV nVarChar 100 -      
EnDeposAcc Encryption of Bank Account No. Text 16 -      
LogInstanc Log Instance Int 11 - 0    
UserSign2 Updating User Int 6 OUSR      
Key Unique Field
PRIMARY Yes DeposId
VIS_NUM Yes DeposNum
    Series
SERIES No Series