clsImportCustomerServiceObject Properties |
The clsImportCustomerServiceObject type exposes the following members.
Properties| Name | Description | |
|---|---|---|
 | AddrBlock | NVARCHAR (100) AddrBlock |
| AddrBuilding | NTEXT AddrBuilding |
| AddrCity | NVARCHAR (100) AddrCity |
| AddrCountry | NVARCHAR (3) AddrCountry |
| AddrCounty | NVARCHAR (100) AddrCounty |
| AddrGlbLocNum | NVARCHAR (50) AddrGlbLocNum |
| AddrState | NVARCHAR (3) AddrState |
| AddrStreet | NVARCHAR (100) AddrStreet |
| AddrStreetNo | NVARCHAR (100) AddrStreetNo |
| AddrType | NVARCHAR (100) AddrType |
| AddrZipCode | NVARCHAR (20) AddrZipCode |
| CECGroupID | INT Customer Equipment Category |
| CheckList | CheckList |
| cntctPhone | NVARCHAR (20) cntctPhone |
| CollectionLocations |
List of locations (At the client/Project or at in the warehouse)
|
| CollectionParts |
List of spare parts, ware parts, components for the new customer service object
|
| CompanyID | SMALLINT CompanyID |
| contactCod | INT contactCod |
| ContractID | ContractID |
| ContractPosition | ContractPosition |
| custmrName | NVARCHAR (100) custmrName |
| customer | NVARCHAR (20) customer |
| CustomerLocationTreeElementID | INT CustomerLocationTreeElementID |
| internalSN | NVARCHAR (32) internalSN |
| itemCode | NVARCHAR (20) itemCode |
| itemName | NVARCHAR (100) itemName |
| manufDate | Datetime (8) manufDate |
| manufSN | NVARCHAR (32) manufSN |
| Memo | Memo |
| MPinsID | INT MPinsID |
| PhaseID | PhaseID |
| PictureArrayOfBytes |
The picture can be transfered via a byte array instead of a PictureFileName.
|
| PictureFileName | Linking a file name, will load this file into the database. The file content has to be accessable from the import process.
The picture content is stored in: View: MARIPictures : : Table: MPBilder |
| PictureID | PictureID (for the import only existing key in table MPBilder supported. |
| Project | Projectnumber |
| Status | Status |
| warranty | Boolean |
| wrrntyEnd | Datetime (8) wrrntyEnd |
| wrrntyStrt | Datetime (8) wrrntyStrt |
See Also