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