Customer Detail

Each customer can manage multiple contacts and cards from the same SQL Express database.

Back to List

Customer Workspace

ADVANCE MANAGEMENT & CLEANING SVS SB

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No 587168-M

Contacts 5

Managed Cards 21

Record Status 1

ADVANCE MANAGEMENT & CLEANING SVS SB

All non-_ID fields from customer_master.

Customer Information

Reference layout based on customer_profile.jpg.

Company Name

Company Reg Num

Date Of Incorporation

Name Appear On Card

Agreement Start Date

Agreement Expiry Date

Customer Account Num

Approved Credit Limit

Aut Credit Limit

Parent Reg Num

Approved Date

Approved By

Date Suspended

Date Delinquency

Date Legal Case

Date Resigned

Date Terminated

Created By

Created Date

Modified By

Modified Date

Bank Account Giro

Record Status

Cancellation Date

Auto Renewal

Cancellation Remark

Diesel Subsidy

Extra Credit

Aging 1

Aging 2

Aging 3

Aging 4

Aging 5

Aging 0

Unbill

Last Month Purchased

Current Month Purchased

Update Ascendent

Write Off

Diesel Xybase Ref Num

Diesel Subsidy Ref Num

Quota Changed

Diesel Subsidy Quota

Max Agreement Expiry Date

Provision

Total Invoice

Total Collected

Aging As Of

Debt Legal

Reminder1

Reminder2

Statement Send

Late Charges Calculation

Old Customer Account Num

Prepaid Reminder

Ref Reg No

Reminder3

Suspension

Auto Ds Renewal

Customer Contacts

Linked by customer_master.customer_id = applicant_contact.applicant_id.

Name	Designation	Email	Telephone	Mobile	Record Status

Cards

Loaded on demand from card_master.

Card No	Vehicle Reg No	Driver Name	Record Status	Renewal Expiry
700618 276157 00015	JGY 2924		Active	2015-10-31	Edit
700618 276157 00023	JGL 5033		Active	2015-10-31	Edit
700618 276157 00031	JEA 9405		Active	2015-10-31	Edit
789713 3000740 0015	JGY 2924		Active	2015-10-31	Edit
789713 3000740 0023	JGL 5033		Active	2015-10-31	Edit
789713 3000740 0031	JEP 7938		Inactive	2015-10-31	Edit
789713 3000740 0049	JEA 9405		Inactive	2015-10-31	Edit
789713 3000740 0056	JGV 2924	ALL DRIVERS	Inactive	2015-10-31	Edit
789713 3000740 0064	JMR 4356	RAJENDRAN	Inactive	2015-10-31	Edit
789713 3000740 0072	JNC 915		Active	2015-10-31	Edit
789713 3000740 0080	JAX 5148	GOH TOOK KIEW	Inactive	2015-10-31	Edit
789713 3000740 0098	WRU 7180	SRI RAM	Inactive	2015-10-31	Edit
789713 3000740 0106	WRU 7180	SRI RAM	Active	2015-10-31	Edit
789713 3000740 0114	JMA 3081	MARIA ANNE	Inactive	2015-10-31	Edit
789713 3000740 0122	BBP 2805	GANEAS	Inactive	2015-10-31	Edit
789713 3000740 0130	JEP 7938	HAIRULNIZAM	Active	2015-10-31	Edit
789713 3000740 0148	JMR 4356	NAVARATNA KUMAR	Active	2015-10-31	Edit
789713 3000740 0155	JNC 915	SRI RAM	Active	2015-10-31	Edit
789713 3000740 0163	JAX 5148	GOH TOOK KIEW	Active	2015-10-31	Edit
789713 3000740 0171	JMR 4356	RAGU	Active	2015-10-31	Edit
789713 3000740 0189	JPW 2940	SELVAM	Inactive	2015-10-31	Edit