| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| DeposId |
Payment Internal ID |
Int |
11 |
- |
0 |
|
|
| DeposType |
Payment Type |
VarChar |
1 |
- |
K |
K |
Check Deposit |
| |
|
|
|
|
|
C |
Cash Payment |
| |
|
|
|
|
|
V |
Credit Deposit |
| |
|
|
|
|
|
B |
Bill of Exchange |
| DeposNum |
Payment No. |
Int |
11 |
- |
|
|
|
| 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 |
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 |
- |
|
|
|
| DocTime |
Pay-In Time |
Int |
6 |
- |
|
|
|
| AllocAcct |
Cash |
nVarChar |
15 |
- |
|
|
|
| ChkType |
Check Deposit Type |
VarChar |
1 |
- |
C |
C |
Cash Checks |
| |
|
|
|
|
|
S |
Postdated Checks |
| DpsBank |
Bank Name for Payments |
nVarChar |
30 |
- |
|
|
|
| DpostorNam |
Name of Depositor |
nVarChar |
30 |
- |
|
|
|
| Printed |
Original/Copy |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DocRate |
Payment Rate |
Num |
19.6 |
- |
|
|
|
| CrdBankAct |
Voucher Account |
nVarChar |
15 |
- |
|
|
|
| IsCard |
Business Partner or Account |
VarChar |
1 |
- |
A |
A |
G/L Account |
| |
|
|
|
|
|
C |
BP |
| Transfered |
Year Transfer |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| Splited |
Split |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| 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 |
- |
|
|
|
| Series |
Series |
Int |
11 |
- |
|
|
|
| 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 |
|
|
|
| DepostNorm |
Deposit Norm |
nVarChar |
8 |
- |
|
|
|
| PostType |
Transaction Type |
VarChar |
1 |
- |
C |
C |
Collection |
| |
|
|
|
|
|
D |
Discounted |
| BankCountr |
Bank Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| Canceled |
Canceled |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CnclDps |
Cancel Deposit |
Int |
11 |
- |
-1 |
|
|
| CommisVat |
Commission VAT Group |
nVarChar |
8 |
OVTG |
|
|
|
| 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 |
|
|
|
| ReconAfter |
Reconcile Amounts After Dpst |
VarChar |
1 |
- |
Y |
|
|
| 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 |
- |
|
|
|
| SupplCode |
Supplementary Code |
nVarChar |
254 |
- |
|
|
|
| BPLId |
Branch |
Int |
11 |
OBPL |
|
|
|
| SysRate |
System Currency Rate |
Num |
19.6 |
- |
|
|
|
| AtcEntry |
Attachment Entry |
Int |
11 |
OATC |
|
|
|
| Attachment |
Attachment |
Text |
16 |
- |
|
|
|
| IncomeAct |
Withholding Income Tax Account |
nVarChar |
15 |
- |
|
|
|
| IncomeLC |
Withholding Income Tax LC |
Num |
19.6 |
- |
|
|
|
| IncomeFC |
Withholding Income Tax FC |
Num |
19.6 |
- |
|
|
|
| IncomeSC |
Withholding Income Tax SC |
Num |
19.6 |
- |
|
|
|
| UpdateTS |
Update Full Time |
Int |
11 |
- |
|
|
|
| VersionNum |
Version Number |
nVarChar |
13 |
- |
|
|
|
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|
| EnDeposAcc |
Encryption of Bank Account No. |
Text |
16 |
- |
|
|
|