Skip to content
Snippets Groups Projects
Select Git revision
  • develop default
  • master protected
  • 0.9
  • 0.8
  • 0.6
  • 0.5
  • 0.4
  • 0.3
  • 0.2
  • 0.1
10 results
Blame Permalink
validations.rst 1.78 KiB

CSV Upload Validation Rules

The following table describes the validation rules applied when uploading a CSV file.

Type Field Logic Comments
Structural (All Fields) Ensure that all required field names are present.
Update ...NominalAccountNumber (*n) If value starts with xx-, map NominalCostCentre using dbo.meoCostCentres and retrieve NominalAccountNumber from dbo.vw_xx-data. Ensure the correct nominal code is assigned.
Checks AccountNumber Validate against dbo.meoValidSuppliers. Ensure the account exists in the valid suppliers list.
Checks Source Should always be 80. Reject rows where Source != 80.
Checks SYSTraderTranType Should always be 4. Reject rows where SYSTraderTranType != 4.
Update TransactionDate Set to today’s date (dd/mm/yyyy). Ensure all rows have a consistent transaction date.
Checks ...NominalAccountNumber (*n) Validate against [Nom] in dbo.meoNominal. Ensure all nominal account numbers exist.
Checks ...NominalCostCentre (*n) Validate against dbo.meoCostCentres. Ensure cost centres exist.
Checks Combination of ...NominalAccountNumber, ...NominalCostCentre, and ...NominalDepartment Validate against dbo.meoValidSageAccounts. The combination of the three fields must be valid.
Checks ...TaxRate Validate against [Tax code] in dbo.meoValidVAT. Ensure valid tax rates.