Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

ClientComplete list of client's contract prefix for each business account. This full list is repeated each run.

Field Name

Data Type

Field Description

Format/ Possible Field Values

RunDate

date

Date of data extraction

YYYY-MM-DD

BusinessName

varchar(50)

Trading name of the business

BusinessAccount

varchar(50)

Business account name

ContractPrefix

char(6)

Contract Prefix associated with the business account

...