| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| CheckKey |
Check Key |
Int |
11 |
- |
|
|
|
| CheckNum |
Check No. |
Int |
11 |
- |
|
|
|
| BankNum |
Bank Code |
nVarChar |
30 |
- |
|
|
|
| Branch |
Branch |
nVarChar |
50 |
- |
|
|
|
| BankName |
Bank Name |
nVarChar |
250 |
- |
|
|
|
| CheckDate |
Check Date |
Date |
8 |
- |
|
|
|
| DpstAcct |
Bank Account No. |
nVarChar |
50 |
- |
|
|
|
| DpstBranch |
Branch for Payments |
Int |
6 |
- |
|
|
|
| AcctNum |
Account No. |
nVarChar |
50 |
- |
|
|
|
| Details |
Details |
nVarChar |
254 |
- |
|
|
|
| TransRef |
Journal Entry Reference |
nVarChar |
11 |
- |
|
|
|
| PmntDate |
Payment Date |
Date |
8 |
- |
|
|
|
| PmntNum |
Payment No. |
Int |
11 |
OVPM |
0 |
|
|
| CheckSum |
Check Amount |
Num |
19.6 |
- |
|
|
|
| Trnsfrable |
Negotiable |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| VendorCode |
Vendor Code |
nVarChar |
15 |
- |
|
|
|
| Currency |
Check Currency |
nVarChar |
3 |
- |
|
|
|
| Canceled |
Canceled |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| CardOrAcct |
Business Partner or Account |
VarChar |
1 |
- |
C |
C |
BP |
| |
|
|
|
|
|
A |
Account |
| Printed |
Printed |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| VendorName |
Vendor Name |
nVarChar |
200 |
- |
|
|
|
| TotalWords |
Total in Words |
nVarChar |
254 |
- |
|
|
|
| Signature |
Signature |
nVarChar |
30 |
- |
|
|
|
| CheckAcct |
Customer Account Code |
nVarChar |
15 |
- |
|
|
|
| TransNum |
Transaction Number |
Int |
11 |
OJDT |
0 |
|
|
| LinesSum |
Row Totals |
Num |
19.6 |
- |
|
|
|
| Deduction |
Deduction Amount |
Num |
19.6 |
- |
|
|
|
| DdctPrcnt |
Withholding Tax Deduction % |
Num |
19.6 |
- |
|
|
|
| Address |
Address |
nVarChar |
254 |
- |
|
|
|
| CreateJdt |
Create Journal Entry |
VarChar |
1 |
- |
Y |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| VatTotal |
Total Tax |
Num |
19.6 |
- |
|
|
|
| VatCalcult |
Calculate Tax |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| 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 |
| SumRfndCln |
Deduction Refund Amount |
Num |
19.6 |
- |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| PrintedBy |
Printed By |
Int |
6 |
- |
|
|
|
| Transfered |
Transferred to next year |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Instance |
Instance |
Int |
6 |
- |
0 |
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| ObjType |
Object Type |
nVarChar |
20 |
ADP1 |
57 |
|
|
| CountryCod |
Country/Region Code |
nVarChar |
3 |
OCRY |
|
|
|
| AddrName |
Address Name |
nVarChar |
50 |
- |
|
|
|
| PrnConfrm |
Confirm Printing |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| BnkActKey |
Bank Account Internal ID |
Int |
11 |
DSC1 |
|
|
|
| CancelDate |
Cancelation Date |
Date |
8 |
- |
|
|
|
| ManualChk |
Manual Check |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| BPLId |
Branch |
Int |
11 |
OBPL |
|
|
|
| BPLName |
Branch Name |
nVarChar |
200 |
- |
|
|
|
| VATRegNum |
Branch Reg. No. |
nVarChar |
32 |
- |
|
|
|
| Endorse |
Endorse |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| EndorsChNo |
Endorsable Check No. |
Int |
11 |
OCHH |
|
|
|
| UserSign2 |
Updating User - History |
Int |
6 |
OUSR |
|
|
|
| DPPStatus |
Data Protection Status |
VarChar |
1 |
- |
N |
N |
None |
| |
|
|
|
|
|
D |
Erased |
| AtcEntry |
Attachment Entry |
Int |
11 |
OATC |
|
|
|
| Attachment |
Attachment |
Text |
16 |
- |
|
|
|
| ECheck |
E-Check |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| VersionNum |
Version Number |
nVarChar |
13 |
- |
|
|
|
| EnAcctNum |
Encryption of Account Number |
Text |
16 |
- |
|
|
|
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|