A list of all customers active for the Client as at the end of day yesterday
Field Name | Data Type | Field Description | Format/ Possible Field Values |
|---|---|---|---|
RunDate | date | Date of data extraction | YYYY-MM-DD |
DebitsuccessID | varchar(15) | Debitsuccess customer ID | |
CustomerFirstName | varchar(40) | Customer's first name | |
CustomerLastName | varchar(40) | Customer's last name | |
FinishDate | datetime | ||
Term | varchar(66) | ||
PaymentMethod | char(2) | ||
Frequency | char(2) | ||
Instalment | numeric(8, 2) | ||
ContractPrefix | char(6) | Contract Prefix associated to the business account | |
SetToTerm | bit | ||
StartDate | datetime | ||
LoadDate | datetime | ||
EstFeeStatus | int | ||
EstFeeValue | numeric(7, 2) | ||
FirstInstalmentDate | datetime | ||
ProjectedFinishDate | datetime |