Navigation:  Exchequer Data Information > Exchequer Tables >

 

EDL Product Supporthome

Job Retentions
Previous pageReturn to chapter overviewNext page

The Job Retentions table contains details of the retentions setup within the Exchequer Job Costing module.

Relational Links

The Retentions can be linked to Analysis Codes via the IdxAnalCode field, to Jobs via the IdxJobCode field, to the Transaction that the Retention is held against with the jeRetDoc field, and to the Customer/Supplier via the IdxAcCode field.

 

 

Field Name

Description

Type

Length

jeRecType

J

String

1

jeIdxRecSub

JB

String

2

jeSubType

B

String

1

jeIdxReten

Retention Account Code

String

21

jeIdxInv

Invoice Reference

String

20

jeIdxSpare1

Future Use

String

26

jeIdxSpare4

Future Use

String

19

IdxAnalcode

Analysis Code

String

10

jeIdxSpare5

Future Use

String

14

jeIdxSpare2

Future Use

String

21

jeIdxSpare3

Future Use

String

22

jeIdxCrYrPr

 

String

3

jeCurrency

Currency

Integer

1

jeRetYr

Retention Year

Integer

1

jeRetPr

Retention Period

Integer

1

jePosted

Posted?

Logical

1

jeRetDiscPer

Percentage Retention

Float

8

jeRetCur

Retention Currency

Integer

1

jeRetValue

Retention Amount (in Currency)

Float

8

IdxJobCode

Job Code

String

10

jeAutoCrDoc

Credit Note Reference

String

10

jeRetDate

Retention Expiry Date

Date

8

jeRetDoc

Invoice Reference

String

10

jeInvoiced

Invoiced?

Logical

1

IdxAcCode

Account Code

String

6

jeEntryDate

Entry Date

Date

8

jeDepartment

Department

String

3

jeCostCentre

Cost Centre

String

3

jeAcType

 

String

1

jeDefVATCode

VAT Code

String

1

jeCISTax

CIS Tax Retained

Float

8

jeCISGross

CIS Gross Tax

Float

8

jeCISEmployee

Employee Code

Lstring

11

jeApplicationMode

Application Mode

Integer

1

jeSpare

Future Use

String

197

jeSpare2

Future Use

String

255

jeSpare3

Future Use

String

98