The Job CIS Voucher table contains details of the CIS Vouchers defined within Exchequer.
Relational Links
The Job CIS Vouchers can be relationally linked to Employees through the cvEmployee field, to Suppliers through the cvSupplier field.
Field Name |
Description |
Type |
Length |
cvRecType |
T |
String |
1 |
cvIdxRecSub |
TS |
String |
2 |
cvSubType |
S |
String |
1 |
cvSpareEDLB |
Future Use |
Integer |
1 |
cvEmployee |
CIS Voucher Employee Code |
String |
6 |
cvIdxEmplDate |
|
String |
21 |
cvSpare1 |
Future Use |
String |
3 |
cvSpareDETLB |
Future Use |
Integer |
1 |
cvDate |
CIS Voucher Date |
Date |
8 |
cvIdxDateEmplType |
|
String |
20 |
cvSpareVNLB |
Future Use |
Integer |
1 |
cvIdxNumber |
CIS Voucher Number |
String |
26 |
cvTransaction |
CIS Voucher Our Reference |
Lstring |
11 |
cvSpareDSTLB |
Future Use |
Integer |
1 |
cvIdxDateSuppType |
|
String |
21 |
cvSpareFNLB |
Future Use |
Integer |
1 |
cvIdxFolioNINo |
|
String |
22 |
cvFolio |
CIS Voucher Folio |
Integer |
4 |
cvNISerialNo |
CIS Voucher NI Number |
Lstring |
12 |
cvSpareSDLB |
Future Use |
Integer |
1 |
cvSupplier |
CIS Voucher Supplier Code |
String |
6 |
cvIdxSuppDate |
|
String |
19 |
cvSpareCNLB |
Future Use |
Integer |
1 |
cvIdxCertificateNo |
CIS Voucher Employee Cert No |
String |
14 |
cvIdxSpare |
Future Use |
String |
3 |
cvSpare2 |
Future Use |
String |
5 |
cvGrossTotal |
CIS Voucher Gross |
Float |
8 |
cvManualTax |
CIS Voucher Manual Tax |
Logical |
1 |
cvAutoTotalTax |
CIS Voucher Auto Tax Total |
Float |
8 |
cvTaxableTotal |
CIS Voucher Taxable Amount |
Float |
8 |
cvType |
CIS Voucher Type |
Integer |
1 |
cvCurrency |
CIS Voucher Currency |
Integer |
1 |
cvSpare3 |
Future Use |
String |
2 |
cvNoteLineCount |
|
Integer |
4 |
cvAddress1 |
CIS Voucher Address Line 1 |
Lstring |
31 |
cvAddress2 |
CIS Voucher Address Line 2 |
Lstring |
31 |
cvAddress3 |
CIS Voucher Address Line 3 |
Lstring |
31 |
cvAddress4 |
CIS Voucher Address Line 4 |
Lstring |
31 |
cvAddress5 |
CIS Voucher Address Line 5 |
Lstring |
31 |
cvBehalf |
CIS Voucher On Behalf Of |
Lstring |
81 |
cvCorrection |
CIS Voucher Correction |
Logical |
1 |
cvTaxDue |
CIS Voucher Tax Due |
Date |
8 |
cvSpare4 |
Future Use |
String |
33 |
cvSpare5 |
Future Use |
String |
255 |
cvSpare6 |
Future Use |
String |
98 |