|
|
DTW Banking / Bill of Exchange / Bill of Exchange Transactions / Deposit
API Deposits Service / Deposit
ODPS - Deposit Table
Deposit Deposit Object· Table: ODPS
Parent: Deposits Service DepositsService Service· Table: ODPS
Bill Of Exchange Trans Deposits BillOfExchangeTrans_Deposits Object· Table: ODPS Parent: Bill Of Exchange Transaction BillOfExchangeTransaction Object· Table: OBOT
Deposits Service DepositsService Service· Table: ODPS
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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DeposId KEY UNIQUE | Payment Internal ID | Int | 11 | 0 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| DeposType | Payment Type | VarChar | K) Check Deposit C) Cash Payment V) Credit Deposit B) Bill of Exchange | 1 | K | |||
| DeposNum KEY | Payment No. | Int | 11 | VIS_NUM | No | |||
| 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 | 127 | |||||
| LocTotal | Total (LC) | Num | 20 | |||||
| FcTotal | Total (FC) | Num | 20 | |||||
| SysTotal | Total (SC) | Num | 20 | |||||
| TransAbs | Journal Entry Key | Int | 11 | OJDT Journal Entry | ||||
| 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 | C) Cash Checks S) Postdated Checks | 1 | C | |||
| DpsBank | Bank Name for Payments | nVarChar | 30 | |||||
| DpostorNam | Name of Depositor | nVarChar | 30 | |||||
| Printed | Original/Copy | VarChar | Y) Yes N) No | 1 | N | |||
| DocRate | Payment Rate | Num | 20 | |||||
| CrdBankAct | Voucher Account | nVarChar | 15 | |||||
| IsCard | Business Partner or Account | VarChar | A) G/L Account C) BP | 1 | A | |||
| Transfered | Year Transfer | VarChar | Y) Yes N) No | 1 | N | |||
| UpdateDate | Date of Update | Date | 8 | |||||
| Splited | Split | VarChar | Y) Yes N) No | 1 | N | |||
| CreateDate | Creation Date | Date | 8 | |||||
| VatAct | Tax Account | nVarChar | 15 | |||||
| ComissAct | Commissions Account | nVarChar | 15 | |||||
| VatTotal | Total Tax | Num | 20 | |||||
| Comission | Commission | Num | 20 | |||||
| ComissDate | Commission Date | Date | 8 | |||||
| TaxDate | Document Date | Date | 8 | |||||
| Series KEY | Series | Int | 6 | SERIES | No | |||
| DataSource | Data Source | VarChar | 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 | |||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | ||||
| FinncPriod | Posting Period | Int | 11 | OFPR Posting Period | ||||
| VatTotlSys | Total Tax on Input (SC) | Num | 20 | |||||
| ComissnSys | Total Commission (SC) | Num | 20 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| DepostNorm | Deposit Norm | nVarChar | 8 | |||||
| PostType | Transaction Type | VarChar | C) Collection D) Discounted | 1 | C | |||
| BankCountr | Bank Country | nVarChar | 3 | OCRY Countries | ||||
| Canceled | Canceled | VarChar | Y) Yes N) No | 1 | N | |||
| CnclDps | Cancel Deposit | Int | 11 | -1 | ||||
| CommisVat | Commission VAT Group | nVarChar | 8 | OVTG Tax Definition | ||||
| 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 Project Codes | ||||
| ReconAfter | Reconcile Amounts After Dpst | VarChar | 1 | Y | ||||
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode2 | Distribution Rule 2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode3 | Distribution Rule 3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode4 | Distribution Rule 4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode5 | Distribution Rule 5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| ComisFC | Total Commission (FC) | Num | 20 | |||||
| VatTotlFC | Total Tax on Input (FC) | Num | 20 | |||||
| ComisCurr | Commission Currency | nVarChar | 3 | |||||
| SupplCode | Supplementary Code | nVarChar | 127 | |||||
| BPLId | Branch | Int | 11 | OBPL Business Place | ||||
| SysRate | System Currency Rate | Num | 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 vouchers
For 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
DepositsService
Object
Deposit
Collection
Enumeration
Method
Property
AbsEntry
DB
Bank
DB
BankBranch
DB
Commission
DB
DepositDate
DB
DepositType
DB
DocRate
DB
Series
DB
TaxAccount
DB
TaxAmount
DB
TaxCode
DB
TotalFC
DB
TotalLC
DB
TotalSC
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
