| Name | Description | Type | Additional information |
|---|---|---|---|
| CustomerId |
This is a four digit unique Customer Id |
integer |
None. |
| CustomerNumber |
This is a four digit unique Customer Number |
integer |
None. |
| CustomerName |
This is Customer Name |
string |
None. |
| SiteId |
This is a Site Id |
integer |
None. |
| SiteUseCode | string |
None. |
|
| CustomerStatus |
Customer Status i.e. Active or Inactive |
string |
None. |
| Address1 |
Customer's First Address |
string |
None. |
| Address2 |
Customer's Alternative Address |
string |
None. |
| Address3 |
Customer's second Alternative Address and can be null |
string |
None. |
| Address4 |
Customer's third Alternative Address and can be null |
string |
None. |
| MobileNo |
Customer's Mobile Number |
string |
None. |
| PostalCode |
Customer's Postal Code |
string |
None. |
| GstNo |
Customer's GST No and each customer will have unique number |
string |
None. |
| PanNo |
Customer's Pan No and each customer will have unique number |
string |
None. |
| ContactPerson |
Customer's Contact Person Name |
string |
None. |
| EmailAddress |
Customer's email Address |
string |
None. |
| Is_Active |
Return Y if customer is active otherwise N |
character |
None. |
| CustomerState |
Customer State |
string |
None. |
| CustomerZone |
Customer Zone |
string |
None. |
| SalesChannelCode |
Sales Channel |
string |
None. |
| CustomerTerritory |
Customer Territory |
string |
None. |
| CustomerCity |
Customer City |
string |
None. |
| PARTY_CTRL_DT | date |
None. |
|
| HCA_CTRL_DT | date |
None. |
|
| HCS_CTRL_DT | date |
None. |
|
| HPS_CTRL_DT | date |
None. |
|
| HCSU_CTRL_DT | date |
None. |
|
| JRDV_CTRL_DT | date |
None. |
|
| RAT_CTRL_DT | date |
None. |
|
| Related_Cust_Id | integer |
None. |
|
| Sales_Rep_Name | string |
None. |
|
| OPERATING_UNIT | string |
None. |