|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Postdated Deposit
Table Name: ODPT
Table Description: Postdated 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 |
| Â | Â | Â | Â | Â | Â | V | Credit Deposit |
| DeposDate | Payment Date | Date | 8 | - | Â | Â | Â |
| DeposCurr | Currency for Payments | nVarChar | 3 | - | Â | Â | Â |
| BanckAcct | SAP Business One Acct Code f. | nVarChar | 15 | - | Â | Â | Â |
| 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 | - | Â | Â | Â |
| DocRate | Payment Rate | Num | 19.6 | - | Â | Â | Â |
| Splited | Split | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| 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 | - | Â | Â | Â |
| 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 | Â | Â | Â |
| CommisVat | Commission VAT Group | nVarChar | 8 | OVTG | Â | Â | Â |
| Project | Project Code | nVarChar | 20 | OPRJ | Â | Â | Â |
| 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 | - | Â | Â | Â |
| VersionNum | Version Number | nVarChar | 13 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DeposId |