Import - Customer Reserve Customers
- Alan Gilchrist
Use
Needs to be linked to the main customer account but this is the reserve account underneath the main customer, this code is used against each rotation to specify who is the underlying owner.
Limitations
Needs an existing customer account, the reference should exist and the HasReserveCustomers flag of the Customer record (tblCustomer. HasReserveCustomers) must be true.
Notes
This import originated from an older system so some of the fields are not relevant but remain as part of the standard import tables.              Â
Â
Fields
Â
Â
Â
Field Name | Field Type | Nulls | Notes |
CustomerRef | nvarchar(50) | NULL | Â |
ReserveCustomer | nvarchar(50) | NULL | Â |
ReserveName | nvarchar(50) | NULL | Â |
ReserveCustomerTelephone | nvarchar(50) | NULL | Â |
ReserveCustomerEmail | nvarchar(50) | NULL | Â |
RemovalNotification | nvarchar(50) | NULL | true / false (case sensitive!) |
RemovalAuthorisation | nvarchar(50) | NULL | true / false (case sensitive!) |
ImportDate | datetime | NOT NULL | Â |
FailedDate | datetime | NULL | Â |
FailedReason | nvarchar(max) | NULL | Â |
IsProcessed | bit | NOT NULL | Â |
IsValid | bit | NOT NULL | Â |
SiteCode | nvarchar(50) | NOT NULL | Must be one of the pre-agreed site codes |
Â
Â
Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.