Summary

The Hayes synchronisation custom type is used to import Cost Centre or Job codes.

Fields

The Hayes custom type deals with the following fields:

iCOLUMNDATATYPE = 0;

iCOLUMNTYPE = 1;

iCOLUMNLOCATION = 2;

iCOLUMNCODE = 3;

iCOLUMNDESC = 4;

If ColumnDataType = J, then the Job table is used.

• JobCode is determined by:

  sJobCode := ClipFn32.Left(lsColumns[iCOLUMNLOCATION], 2) + Transform([xVal(lsColumns[iCOLUMNCODE])], '9999999999') + '1';

• The following fields are used:
  • Jobcode
  • Description
  • CostCentreCode

If ColumnDataType = G, then the CostCentre table is used.

• CostCentreCode is determined by:

  sCostCentreCode := ClipFn32.Left(ClipFn32.Left(lsColumns[iCOLUMNLOCATION], 2) + lsColumns[iCOLUMNCODE], 10);

• The following fields are used:
  • CostCentreCode
  • Description
  • GeneralLedgerCode
  • GeneralLedgerDescription

If ColumnDataType = H, then the CostCentre table is used.

• CostCentreCode is determined by:

  sCostCentreCode := ClipFn32.Left(ClipFn32.Left(lsColumns[iCOLUMNLOCATION], 2) + lsColumns[iCOLUMNCODE], 11);

• The following fields are used:
  • CostCentreCode
  • Description
  • GeneralLedgerCode
  • GeneralLedgerDescription

See also

Synchronisation