Customer Detail

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

Back to List

Customer Workspace

ABLE CONSOLIDATION SERVICES SDN BHD

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No 160896-H

Contacts 4

Managed Cards 33

Record Status 1

ABLE CONSOLIDATION SERVICES 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 271792 00014	BDE 8935		Active	2015-06-30	Edit
700618 271792 00022	WFN 7991		Active	2015-06-30	Edit
700618 271792 00030	CAM 5127		Active	2015-06-30	Edit
700618 271792 00048	BFP 2811		Active	2015-06-30	Edit
700618 271792 00055	BGL 7861		Active	2015-06-30	Edit
700618 271792 00063	WDC 2809		Active	2015-06-30	Edit
700618 271792 00071	BGL 7861		Active	2015-06-30	Edit
700618 271792 00089	BFP 2811	PERODUA KEMBARA	Active	2015-06-30	Edit
700618 271792 00097	WDC 2809	MALAYSIA	Active	2015-06-30	Edit
700618 271792 00105	BFP 2811		Active	2015-06-30	Edit
700618 271792 00113	BHM 5441		Active	2015-06-30	Edit
700618 271792 00121	WJW 231	THANALETCHUME AP ADAICKAN	Active	2015-06-30	Edit
789713 3002423 0015	BDE 8935		Active	2015-06-30	Edit
789713 3002423 0023	WFN 7991		Active	2015-06-30	Edit
789713 3002423 0031	WDC 2809	MALAYSIA	Active	2015-06-30	Edit
789713 3002423 0049	BFP 2811		Active	2015-06-30	Edit
789713 3002423 0056	BHM 5441		Active	2015-06-30	Edit
789713 3002423 0064	WJW 231	THANALETCHUME AP ADAICKAN	Active	2015-06-30	Edit
789713 3002423 0072	WFL 9653	MURTHI A/L MUNIYANDY	Inactive	2015-06-30	Edit
789713 3002423 0080	WPV 119	KATHIRAVAN A/L SELLAN	Inactive	2015-06-30	Edit
789713 3002423 0098	BBJ 4177		Active	2015-06-30	Edit
789713 3002423 0106	AP 7733		Active	2015-06-30	Edit
789713 3002423 0114	WRX 7687		Active	2015-06-30	Edit
789713 3002423 0122	WPV 119		Active	2015-06-30	Edit
789713 3002423 0130	WRX 7687		Inactive	2015-06-30	Edit
789713 3002423 0148	WTV 8577		Inactive	2015-06-30	Edit
789713 3002423 0155	WDC 2809		Active	2015-06-30	Edit
789713 3002423 0163	WRD 6962	SHANGAR A/L SUBRAMANIAM	Inactive	2015-06-30	Edit
789713 3002423 0171	WLP 9290	FRANCIS A/L S ERUTHIAM	Inactive	2015-06-30	Edit
789713 3002423 0189	AP 7733		Active	2015-06-30	Edit
789713 3002423 0197	WRD 6962	SHANGAR A/L SUBRAMANIAM	Active	2015-06-30	Edit
789713 3002423 0205	WRX 7687		Active	2015-06-30	Edit
789713 3002423 0213	WPV 119		Active	2015-06-30	Edit