Navigation:  Exchequer Data Information > Exchequer Tables >

 

EDL Product Supporthome

Locations

Previous pageReturn to chapter overviewNext page

The Locations table contains the Locations which have been setup within Exchequer.

Relational Links

The Locations are linked relationally to Transaction Line and Stock-Location records using the idxLocCode field which is in all three tables.

 

Field Name

Description

Type

Length

mlIdxRecSub

 

String

2

mlSubType_C

C

String

1

mlCode

Location Code

Lstring

4

IdxLocCode

Location Code

String

3

mlIdxLocCode

Location Code

String

30

mlName

Location Name

Lstring

46

mlIdxName

Location Name

String

45

mlIdxSupp

 

String

31

mlAddr1

Location Address 1

Lstring

31

mlAddr2

Location Address 2

Lstring

31

mlAddr3

Location Address 3

Lstring

31

mlAddr4

Location Address 4

Lstring

31

mlAddr5

Location Address 5

Lstring

31

mlTel

Location Telephone

Lstring

26

mlFax

Location Fax Number

Lstring

26

mlEmail

Location E-Mail Address

Lstring

101

mlModem

Location Modem Number

Lstring

26

mlContact

Location Contact

Lstring

31

mlCurrency

Location Currency

Integer

1

mlArea

Location Area

Lstring

6

mlRep

Location Rep

Lstring

6

mlTag

Tagged?

Logical

1

mlSalesGL

Sales GL Code

Integer

4

mlCOSGL

Cost Of Sales GL Code

Integer

4

mlP&LGL

Write Offs/Closing Stock GL Code

Integer

4

mlBalSheetGL

Stock Value (B/S) GL Code

Integer

4

mlWIPGL

Work In Progress GL Code

Integer

4

mlDepartment

Location Department

Lstring

4

mlCostCentre

Location Cost Centre

Lstring

4

mlUsePrice

Override Prices Y/N

Logical

1

mlUseGL

Override GL Codes Y/N

Logical

1

mlUseCCDep

Override CC/Dept Y/N

Logical

1

mlUseSupp

Override Supplier Y/N

Logical

1

mlUseBinLoc

 

Logical

1

mlNoteLineCount

 

Integer

4

mlOverrideCostPrice

Override Cost Price Y/N

Logical

1

mlOverrideROPrice

Override Reorder Price Y/N

Logical

1

mlWOPWIPGL

WOP - WIP GL Code

Integer

4

mlPurchaseReturnGL

Purchase Returns GL Code

Integer

4

mlSalesReturnGL

Sales Returns GL Code

Integer

4

mlSpare

Future Use

String

207

mlSpare2

Future Use

String

255

mlSpare3

Future Use

String

255

mlSpare4

Future Use

String

24