Navigation:  Exchequer Data Information > Exchequer Tables >

 

EDL Product Supporthome

Job Actuals
Previous pageReturn to chapter overviewNext page

The Job Actuals table contains details of the transactions which have occurred for a job.

Relational Links

The actuals can be relationally linked to the Analysis Codes through the IdxAnalCode field, to the Transaction Detail Line which caused the Actual with the IdxFolio and IdxLineNo fields in both tables, to the Job with the IdxJobCode field, to the Stock with the IdxStockCode field, and to the Customer Account with the IdxAcCode field. Where relevant it can be linked to Employees through the jeEmployee field.

 

Field Name

Description

Type

Length

jaRecType

J

String

1

jaIdxRecSub

JE

String

2

jaSubType

E

String

1

jaIdxLedger

 

String

21

jaIdxAnal

Analysis Code

String

20

jaIdxStock

Stock Code

String

26

IdxAnalCode

Analysis Code

String

10

jaIdxEmp

Employee Code for Timesheets

String

21

jaIdxRun

 

String

22

jaIdxLook

 

String

19

jaIdxHed

 

String

14

jaIdxCrYrPr

 

String

3

jaCurrency

Currency

Integer

1

jaYear

Line Year

Integer

1

jaPeriod

Line Period

Integer

1

jaPosted

Posted (Y/N)?

Logical

1

IdxFolio

Folio Number

Integer

4

IdxLineNo

Line Number

Integer

4

jaLineORef

Out Invoice Reference

String

10

IdxJobCode

Job Actual Code

String

10

IdxStockCode

Stock Code

String

16

jaDate

Entry Date

Lstring

9

jaQty

Quantity

Float

8

jaCost

Cost Amount

Float

8

jaChargeOut

Charge Amount

Float

8

jaInvoiced

Invoiced (Y/N)?

Logical

1

jaInvRef

Invoice Our Reference

String

10

jaEmployee

Employee Code for Timesheets

String

6

jaAnalType

Analysis Line Type

Integer

1

jaPostedRun

 

Integer

4

jaReverse

Reverse WIP (Y/N)

Logical

1

jaReconTS

 

Logical

1

jaReversed

Reversed (Y/N)

Logical

1

joDocType

Document Type

Integer

1

jaChargeCur

Charge Currency

Integer

1

IdxAcCode

Account Code

String

6

jaHold

 

Integer

1

jaPosted2Stk

 

Logical

1

jaCompanyRate_1

Company Rate 1

Integer

2

jaCompanyRate_2

Company Rate 2

Integer

4

jaDailyRate_1

Daily Rate 1

Integer

2

jaDailyRate_2

Daily Rate 2

Integer

4

jaGLCode

General Ledger Code

Integer

4

jaTagged

 

Logical

1

jaUseORate

Use Own Rate

Integer

1

jaTriRate

 

Float

8

jaTriEuro

 

Integer

1

jaTriInvert

 

Logical

1

jaTriFloat

 

Logical

1

jaTriSpare

 

String

10

jaPriceMultiplier

 

Float

8

jaUpliftTotal

Total Uplift

Float

8

jaUpliftGL

Uplift General Ledger Code

Integer

4

jaSpare

Future Use

String

126

jaSpare2

Future Use

String

255

jaSpare3

Future Use

String

98