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. |