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 |