biuan SAP® BUSINESS ONE SDK
SQL Banking / Postdated Deposit
API ODPT
ODPT - Postdated Deposit Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DeposId KEY UNIQUEPayment Internal IDInt
11
0PRIMARYYes
DeposTypePayment TypeVarChar
K) Check Deposit
V) Credit Deposit
1
K
DeposDatePayment DateDate
8
DeposCurrCurrency for PaymentsnVarChar
3
BanckAcctSAP Business One Acct Code f.nVarChar
15
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
DocRatePayment RateNum
20
SplitedSplitVarChar
Y) Yes
N) No
1
N
VatActTax AccountnVarChar
15
ComissActCommissions AccountnVarChar
15
VatTotalTotal TaxNum
20
ComissionCommissionNum
20
ComissDateCommission DateDate
8
TaxDateDocument DateDate
8
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
CommisVatCommission VAT GroupnVarChar
8OVTG
Tax Definition
ProjectProject CodenVarChar
20OPRJ
Project Codes
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

Table relationship map

SELECT statement

SELECT ODPT.DeposId AS 'Payment Internal ID', ODPT.DeposType AS 'Payment Type', ODPT.DeposDate AS 'Payment Date', ODPT.DeposCurr AS 'Currency for Payments', ODPT.BanckAcct AS 'SAP Business One Acct Code f.', ODPT.Memo AS 'Details', ODPT.LocTotal AS 'Total (LC)', ODPT.FcTotal AS 'Total (FC)', ODPT.SysTotal AS 'Total (SC)', ODPT.TransAbs AS 'Journal Entry Key', ODPT.Ref1 AS 'Reference 1', ODPT.Ref2 AS 'Reference 2', ODPT.DocRate AS 'Payment Rate', ODPT.Splited AS 'Split', ODPT.VatAct AS 'Tax Account', ODPT.ComissAct AS 'Commissions Account', ODPT.VatTotal AS 'Total Tax', ODPT.Comission AS 'Commission', ODPT.ComissDate AS 'Commission Date', ODPT.TaxDate AS 'Document Date', ODPT.DataSource AS 'Data Source', ODPT.ObjType AS 'Object Type', ODPT.FinncPriod AS 'Posting Period', ODPT.VatTotlSys AS 'Total Tax on Input (SC)', ODPT.ComissnSys AS 'Total Commission (SC)', ODPT.UserSign AS 'User Signature', ODPT.CommisVat AS 'Commission VAT Group', ODPT.Project AS 'Project Code', ODPT.OcrCode AS 'Distribution Rule', ODPT.OcrCode2 AS 'Distribution Rule 2', ODPT.OcrCode3 AS 'Distribution Rule 3', ODPT.OcrCode4 AS 'Distribution Rule 4', ODPT.OcrCode5 AS 'Distribution Rule 5', ODPT.ComisFC AS 'Total Commission (FC)', ODPT.VatTotlFC AS 'Total Tax on Input (FC)', ODPT.ComisCurr AS 'Commission Currency' FROM ODPT AS ODPT

Related information


ODPT 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates