Navigation:  Exchequer Data Information > Exchequer Tables >

 

EDL Product Supporthome

Analysis Codes (Job Costing)

Previous pageReturn to chapter overviewNext page

The Analysis Codes table contains the analysis Codes defined within the Job Costing module of Exchequer, this table will have no use for systems without Job Costing.

Relational Links

The discounts can be relationally linked using the IdxAnalCode field to other records with the same Analysis Code.

 

Key Field: IdxAnalCode

 

Field Name

Description

Type

Length

anRecType

J

String

1

anIdxRecSub

JA

String

2

anSubType

A

String

1

IdxAnalCode

Analysis Code

String

10

anIdxName

Analysis Description

String

20

adIdxSpare

Future Use

String

10

anName

Analysis Description

Lstring

31

anType

Analysis Type

Integer

2

anWIPGL

Analysis WIP GL Code

Integer

4

anP&LGL

Analysis P&L GL Code

Integer

4

anCategory

Analysis Category

Integer

2

anTagged

 

Logical

1

anLineType

Analysis Line Type

Integer

1

anCISTaxRate

CIS Rate Code

String

1

anUplift

Uplift Percent

Float

8

anUpliftGL

Uplift General Ledger Code

Integer

4

anRevenueType

Revenue Type

Integer

1

anDeductionBase

 

Integer

1

anCalcB4Retention

Calculate before Retention

Logical

1

anDeduction

 

Float

8

anApplyDeduction

 

Integer

1

anRetentionType

Retention Type

Integer

1

anRetentionValue

Retention Value

Float

8

anRetentionExpiryTyp

 

Integer

1

anRetExpiryInterval

Retention Expiry Interval

Integer

1

anPreserveRetention

Retention Preserve

Logical

1

anCalcDeductionAs

Calculate deduction as

Integer

1

anPayrollCode

Pay Code

Lstring

6