T_CSTMR
|
Name |
Data Type |
Allows Null |
Description |
|
|---|---|---|---|---|
|
|
CSTMRId |
int |
No |
Auto-generated unique ID, created on adding a customer |
|
|
CSTMRCRMId |
nvarchar (255) |
Yes |
CRM ID. Used to connect to an external CRM. |
|
|
CSTMRName |
nvarchar (255) |
No |
Customer name (Unique) |
|
|
Descr |
nvarchar (510) |
Yes |
Customer description |
|
|
isEnabled |
bit |
No |
Identifies if a Customer is active. |
|
|
RefId |
nvarchar (250) |
Yes |
Reference ID. An identifier from another system like CRM/ERP. |
|
|
PartnerId |
int |
No |
Not in use |
|
|
CustomerType |
int |
No |
Type of Customer. 1 - Company, 2 - Individual. |
|
|
Phone |
nvarchar (150) |
Yes |
Phone number of Customer |
|
|
Fax |
nvarchar (150) |
Yes |
Fax of Customer |
|
|
IsBillingSameShipping |
bit |
No |
Identifies if billing address is same as shipping address. |
|
|
BillAddr |
nvarchar (510) |
Yes |
Billing address of Customer |
|
|
ShipAddr |
nvarchar (510) |
Yes |
Shipping address of Customer |
|
|
BillAddrCity |
nvarchar (510) |
Yes |
Billing city of Customer |
|
|
ShipAddrCity |
nvarchar (510) |
Yes |
Shipping city of Customer |
|
|
ShipAddrState |
nvarchar (510) |
Yes |
Shipping state of Customer |
|
|
BillAddrState |
nvarchar (510) |
Yes |
Billing state of Customer |
|
|
BillAddrCountry |
nvarchar (510) |
Yes |
Billing country of Customer |
|
|
ShipAddrCountry |
nvarchar (510) |
Yes |
Shipping country of Customer |
|
|
BillAddrZip |
nvarchar (40) |
Yes |
Billing zip of Customer |
|
|
ShipAddrZip |
nvarchar (40) |
Yes |
Shipping zip of Customer |
|
|
VendorId |
int |
Yes |
Vendor ID with which Customer is associated |
|
|
AccountType |
int |
No |
Defines if this is a Customer or a Channel partner. 1 - Customer, 2 - Channel partner. |
|
|
DateCreated |
datetime |
No |
Date and time when Customer was created |
|
|
CreatedBy |
nvarchar (50) |
Yes |
Name of the user who created the Customer |
| CustomerRefId | nvarchar (510) | Yes | Auto-generated unique ID, created on adding a customer. |
