Newly loaded customer accounts from yesterday
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 to the business account | |
CustomerFirstName | varchar(40) | Customer's first name | |
CustomerLastName | varchar(40) | Customer's last name | |
DebitsuccessID | varchar(15) | Debitsuccess customer ID | |
Term | Length of term | ||
Payments | Number of payments | ||
Instalment | Amount that will be collected at a frequency provided by the business | ||
Frequency | Payment frequency of an installment | 'WK' - Weekly 'FW'- Four Weekly 'MN' - Monthly 'BM' - Bi Monthly 'OF' - One Off | |
StartDate | The date from which the account will be active. | ||
LoadDate | The date when the account was loaded |