biuan SAP® BUSINESS ONE SDK
DTW Banking / Bill of Exchange / Bill of Exchange Transactions / Deposit
API Deposits Service / Deposit
ODPS - Deposit Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DeposId KEY UNIQUEPayment Internal IDInt
11
0PRIMARYYes
DeposTypePayment TypeVarChar
K) Check Deposit
C) Cash Payment
V) Credit Deposit
B) Bill of Exchange
1
K
DeposNum KEYPayment No.Int
11
VIS_NUMNo
DeposDatePayment DateDate
8
DeposCurrCurrency for PaymentsnVarChar
3
BanckAcctDeposit AccountnVarChar
15
DeposAcctBank Account NumbernVarChar
50
DeposBrnchBranch for PaymentsnVarChar
50
MemoDetailsnVarChar
127
LocTotalTotal (LC)Num
20
FcTotalTotal (FC)Num
20
SysTotalTotal (SC)Num
20
TransAbsJournal Entry KeyInt
11OJDT
Journal Entry
Ref1Reference 1nVarChar
11
Ref2Reference 2nVarChar
11
DocTimePay-In TimeInt
6
AllocAcctCashnVarChar
15
ChkTypeCheck Deposit TypeVarChar
C) Cash Checks
S) Postdated Checks
1
C
DpsBankBank Name for PaymentsnVarChar
30
DpostorNamName of DepositornVarChar
30
PrintedOriginal/CopyVarChar
Y) Yes
N) No
1
N
DocRatePayment RateNum
20
CrdBankActVoucher AccountnVarChar
15
IsCardBusiness Partner or AccountVarChar
A) G/L Account
C) BP
1
A
TransferedYear TransferVarChar
Y) Yes
N) No
1
N
UpdateDateDate of UpdateDate
8
SplitedSplitVarChar
Y) Yes
N) No
1
N
CreateDateCreation DateDate
8
VatActTax AccountnVarChar
15
ComissActCommissions AccountnVarChar
15
VatTotalTotal TaxNum
20
ComissionCommissionNum
20
ComissDateCommission DateDate
8
TaxDateDocument DateDate
8
Series KEYSeriesInt
6
SERIESNo
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
FinncPriodPosting PeriodInt
11OFPR
Posting Period
VatTotlSysTotal Tax on Input (SC)Num
20
ComissnSysTotal Commission (SC)Num
20
UserSignUser SignatureInt
6OUSR
Users
DepostNormDeposit NormnVarChar
8
PostTypeTransaction TypeVarChar
C) Collection
D) Discounted
1
C
BankCountrBank CountrynVarChar
3OCRY
Countries
CanceledCanceledVarChar
Y) Yes
N) No
1
N
CnclDpsCancel DepositInt
11
-1
CommisVatCommission VAT GroupnVarChar
8OVTG
Tax Definition
SeqCodeSequence CodeInt
6
SerialSerial NumberInt
11
SeriesStrSeries StringnVarChar
3
SubStrSubseries StringnVarChar
3
ProjectProject CodenVarChar
20OPRJ
Project Codes
ReconAfterReconcile Amounts After DpstVarChar
1
Y
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
OcrCode2Distribution Rule 2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule 3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule 4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule 5nVarChar
8OOCR
Distribution Rule
ComisFCTotal Commission (FC)Num
20
VatTotlFCTotal Tax on Input (FC)Num
20
ComisCurrCommission CurrencynVarChar
3
SupplCodeSupplementary CodenVarChar
127
BPLIdBranchInt
11OBPL
Business Place
SysRateSystem Currency RateNum
20

Table relationship map

SELECT statement

SELECT ODPS.DeposId AS 'Payment Internal ID', ODPS.DeposType AS 'Payment Type', ODPS.DeposNum AS 'Payment No.', ODPS.DeposDate AS 'Payment Date', ODPS.DeposCurr AS 'Currency for Payments', ODPS.BanckAcct AS 'Deposit Account', ODPS.DeposAcct AS 'Bank Account Number', ODPS.DeposBrnch AS 'Branch for Payments', ODPS.Memo AS 'Details', ODPS.LocTotal AS 'Total (LC)', ODPS.FcTotal AS 'Total (FC)', ODPS.SysTotal AS 'Total (SC)', ODPS.TransAbs AS 'Journal Entry Key', ODPS.Ref1 AS 'Reference 1', ODPS.Ref2 AS 'Reference 2', ODPS.DocTime AS 'Pay-In Time', ODPS.AllocAcct AS 'Cash', ODPS.ChkType AS 'Check Deposit Type', ODPS.DpsBank AS 'Bank Name for Payments', ODPS.DpostorNam AS 'Name of Depositor', ODPS.Printed AS 'Original/Copy', ODPS.DocRate AS 'Payment Rate', ODPS.CrdBankAct AS 'Voucher Account', ODPS.IsCard AS 'Business Partner or Account', ODPS.Transfered AS 'Year Transfer', ODPS.UpdateDate AS 'Date of Update', ODPS.Splited AS 'Split', ODPS.CreateDate AS 'Creation Date', ODPS.VatAct AS 'Tax Account', ODPS.ComissAct AS 'Commissions Account', ODPS.VatTotal AS 'Total Tax', ODPS.Comission AS 'Commission', ODPS.ComissDate AS 'Commission Date', ODPS.TaxDate AS 'Document Date', ODPS.Series AS 'Series', ODPS.DataSource AS 'Data Source', ODPS.ObjType AS 'Object Type', ODPS.FinncPriod AS 'Posting Period', ODPS.VatTotlSys AS 'Total Tax on Input (SC)', ODPS.ComissnSys AS 'Total Commission (SC)', ODPS.UserSign AS 'User Signature', ODPS.DepostNorm AS 'Deposit Norm', ODPS.PostType AS 'Transaction Type', ODPS.BankCountr AS 'Bank Country', ODPS.Canceled AS 'Canceled', ODPS.CnclDps AS 'Cancel Deposit', ODPS.CommisVat AS 'Commission VAT Group', ODPS.SeqCode AS 'Sequence Code', ODPS.Serial AS 'Serial Number', ODPS.SeriesStr AS 'Series String', ODPS.SubStr AS 'Subseries String', ODPS.Project AS 'Project Code', ODPS.ReconAfter AS 'Reconcile Amounts After Dpst', ODPS.OcrCode AS 'Distribution Rule', ODPS.OcrCode2 AS 'Distribution Rule 2', ODPS.OcrCode3 AS 'Distribution Rule 3', ODPS.OcrCode4 AS 'Distribution Rule 4', ODPS.OcrCode5 AS 'Distribution Rule 5', ODPS.ComisFC AS 'Total Commission (FC)', ODPS.VatTotlFC AS 'Total Tax on Input (FC)', ODPS.ComisCurr AS 'Commission Currency', ODPS.SupplCode AS 'Supplementary Code', ODPS.BPLId AS 'Branch', ODPS.SysRate AS 'System Currency Rate' FROM ODPS AS ODPS

Related information


Deposit Deposit Object· Table: ODPS
Represents the deposits for received checks, credit card vouchers, and cash. Source table: ODPS.
   Parent: Deposits Service DepositsService Service· Table: ODPS

Bill Of Exchange Trans Deposits BillOfExchangeTrans_Deposits Object· Table: ODPS
BillOfExchangeTrans_Deposits is a child object of the BillOfExchangeTransaction object and represents the deposits information for incoming payments. Source table: ODPS.
   Parent: Bill Of Exchange Transaction BillOfExchangeTransaction Object· Table: OBOT

Deposits Service DepositsService Service· Table: ODPS
The DepositsService service enables you to add, look up, update and cancel deposits for: Cash Checks Credit card vouchersFor Chile, France, Italy, Portugal, and Spain localizations, you can view deposited bills of exchange (BoE). Source...

ODPS SQL Table

Countries OCRY SQL Table

Business Place OBPL SQL Table

Tax Definition OVTG SQL Table

Posting Period OFPR SQL Table

Object Settings - History ADP1 SQL Table

Distribution Rule OOCR SQL Table

Project Codes OPRJ SQL Table

Journal Entry OJDT 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