Customer Detail

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

Back to List

Customer Workspace

ACE MAIL DROP SDN BHD

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No 660780-A

Contacts 3

Managed Cards 27

Record Status 1

ACE MAIL DROP SDN BHD

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 294913 00019	WGP 3995		Active	2015-05-31	Edit
700618 294913 00027	WKL 1005		Active	2015-05-31	Edit
700618 294913 00035	WFC 8562		Active	2015-05-31	Edit
700618 294913 00043	ABP 4317		Active	2015-05-31	Edit
700618 294913 00050	WEG 6579		Active	2015-05-31	Edit
700618 294913 00068	WJY 6533		Active	2015-05-31	Edit
789713 3001761 0017	WEG 6579		Active	2015-05-31	Edit
789713 3001761 0025	WJY 6533		Active	2015-05-31	Edit
789713 3001761 0033	WGP 3995		Active	2015-05-31	Edit
789713 3001761 0041	WKL 1005		Active	2015-05-31	Edit
789713 3001761 0058	WFC 8562		Active	2015-05-31	Edit
789713 3001761 0066	ABP 4317		Active	2015-05-31	Edit
789713 3001761 0074	ABP 4317		Active	2015-05-31	Edit
789713 3001761 0082	WFC 8562		Inactive	2015-05-31	Edit
789713 3001761 0090	WEG 6579	ALL DRIVERS	Inactive	2015-05-31	Edit
789713 3001761 0108	WJY 6533	ALL DRIVERS	Inactive	2015-05-31	Edit
789713 3001761 0116	WKL 1005	ALL DRIVERS	Inactive	2015-05-31	Edit
789713 3001761 0124	ABP 4317	ALL DRIVERS	Inactive	2015-05-31	Edit
789713 3001761 0132	WFC 8562	ALL DRIVERS	Inactive	2015-05-31	Edit
789713 3001761 0140	WRJ 3995	ALL DRIVERS	Inactive	2015-05-31	Edit
789713 3001761 0157	WRJ 3995	ALL DRIVERS	Inactive	2015-05-31	Edit
789713 3001761 0165	WGP 5902	ALL DRIVERS	Inactive	2015-05-31	Edit
789713 3001761 0173	WSH 5539	ALL DRIVERS	Inactive	2015-05-31	Edit
789713 3001761 0181	WSH 5539	ALL DRIVERS	Active	2015-05-31	Edit
789713 3001761 0199	WEG 6579	ALL DRIVERS	Active	2015-05-31	Edit
789713 3001761 0207	WSX 4003	ALL DRIVERS	Inactive	2015-05-31	Edit
789713 3001761 0215	WFC 8562	ALL DRIVERS	Active	2015-05-31	Edit