| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | DeposId | Payment Internal ID | int | 11 | 0 | | 0 | | Allow NULL? |
| 2 | DeposType | Payment Type | char | 1 | 0 | | K | B=Bill of Exchange, C=Cash Payment, K=Check Deposit, V=Credit Deposit | Allow NULL? |
| 3 | DeposNum | Payment No. | int | 11 | 0 | | | | Allow NULL? |
| 4 | DeposDate | Payment Date | date | 8 | 0 | | | | |
| 5 | DeposCurr | Currency for Payments | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | BanckAcct | Deposit Account | nvarchar | 15 | 0 | | | | Allow NULL? |
| 7 | DeposAcct | Bank Account Number | nvarchar | 50 | 0 | | | | Allow NULL? |
| 8 | DeposBrnch | Branch for Payments | nvarchar | 50 | 0 | | | | Allow NULL? |
| 9 | Memo | Details | nvarchar | 250 | 0 | | | | Allow NULL? |
| 10 | LocTotal | Total (LC) | num | 19 | 6 | | | | Allow NULL? |
| 11 | FcTotal | Total (FC) | num | 19 | 6 | | | | Allow NULL? |
| 12 | SysTotal | Total (SC) | num | 19 | 6 | | | | Allow NULL? |
| 13 | TransAbs | Journal Entry Key | int | 11 | 0 | OJDT | | | Allow NULL? |
| 14 | Ref1 | Reference 1 | nvarchar | 11 | 0 | | | | Allow NULL? |
| 15 | Ref2 | Reference 2 | nvarchar | 11 | 0 | | | | Allow NULL? |
| 16 | DocTime | Pay-In Time | int | 6 | 0 | | | | Allow NULL? |
| 17 | AllocAcct | Cash | nvarchar | 15 | 0 | | | | Allow NULL? |
| 18 | ChkType | Check Deposit Type | char | 1 | 0 | | C | C=Cash Checks, S=Postdated Checks | Allow NULL? |
| 19 | DpsBank | Bank Name for Payments | nvarchar | 30 | 0 | | | | Allow NULL? |
| 20 | DpostorNam | Name of Depositor | nvarchar | 30 | 0 | | | | Allow NULL? |
| 21 | Printed | Original/Copy | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 22 | DocRate | Payment Rate | num | 19 | 6 | | | | Allow NULL? |
| 23 | CrdBankAct | Voucher Account | nvarchar | 15 | 0 | | | | Allow NULL? |
| 24 | IsCard | Business Partner or Account | char | 1 | 0 | | A | A=G/L Account, C=BP | Allow NULL? |
| 25 | Transfered | Year Transfer | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 26 | UpdateDate | Date of Update | date | 8 | 0 | | | | |
| 27 | Splited | Split | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 28 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 29 | VatAct | Tax Account | nvarchar | 15 | 0 | | | | Allow NULL? |
| 30 | ComissAct | Commissions Account | nvarchar | 15 | 0 | | | | Allow NULL? |
| 31 | VatTotal | Total Tax | num | 19 | 6 | | | | Allow NULL? |
| 32 | Comission | Commission | num | 19 | 6 | | | | Allow NULL? |
| 33 | ComissDate | Commission Date | date | 8 | 0 | | | | |
| 34 | TaxDate | Document Date | date | 8 | 0 | | | | |
| 35 | Series | Series | int | 11 | 0 | | | | Allow NULL? |
| 36 | DataSource | Data Source | char | 1 | 0 | | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update | Allow NULL? |
| 37 | ObjType | Object Type | nvarchar | 20 | 0 | ADP1 | | | Allow NULL? |
| 38 | FinncPriod | Posting Period | int | 11 | 0 | OFPR | | | Allow NULL? |
| 39 | VatTotlSys | Total Tax on Input (SC) | num | 19 | 6 | | | | Allow NULL? |
| 40 | ComissnSys | Total Commission (SC) | num | 19 | 6 | | | | Allow NULL? |
| 41 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 42 | DepostNorm | Deposit Norm | nvarchar | 8 | 0 | | | | Allow NULL? |
| 43 | PostType | Transaction Type | char | 1 | 0 | | C | C=Collection, D=Discounted | Allow NULL? |
| 44 | BankCountr | Bank Country | nvarchar | 3 | 0 | OCRY | | | Allow NULL? |
| 45 | Canceled | Canceled | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 46 | CnclDps | Cancel Deposit | int | 11 | 0 | | -1 | | Allow NULL? |
| 47 | CommisVat | Commission VAT Group | nvarchar | 8 | 0 | OVTG | | | Allow NULL? |
| 48 | SeqCode | Sequence Code | int | 6 | 0 | | | | Allow NULL? |
| 49 | Serial | Serial Number | int | 11 | 0 | | | | Allow NULL? |
| 50 | SeriesStr | Series String | nvarchar | 3 | 0 | | | | Allow NULL? |
| 51 | SubStr | Subseries String | nvarchar | 3 | 0 | | | | Allow NULL? |
| 52 | Project | Project Code | nvarchar | 20 | 0 | OPRJ | | | Allow NULL? |
| 53 | ReconAfter | Reconcile Amounts After Dpst | char | 1 | 0 | | Y | | Allow NULL? |
| 54 | OcrCode | Distribution Rule | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 55 | OcrCode2 | Distribution Rule 2 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 56 | OcrCode3 | Distribution Rule 3 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 57 | OcrCode4 | Distribution Rule 4 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 58 | OcrCode5 | Distribution Rule 5 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 59 | ComisFC | Total Commission (FC) | num | 19 | 6 | | | | Allow NULL? |
| 60 | VatTotlFC | Total Tax on Input (FC) | num | 19 | 6 | | | | Allow NULL? |
| 61 | ComisCurr | Commission Currency | nvarchar | 3 | 0 | | | | Allow NULL? |
| 62 | SupplCode | Supplementary Code | nvarchar | 254 | 0 | | | | Allow NULL? |
| 63 | BPLId | Branch | int | 11 | 0 | OBPL | | | Allow NULL? |
| 64 | SysRate | System Currency Rate | num | 19 | 6 | | | | Allow NULL? |
