Customer Detail

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

Back to List

Customer Workspace

AEROGAZ EQUIPMENT SDN BHD

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No 524668-H

Contacts 3

Managed Cards 44

Record Status 1

AEROGAZ EQUIPMENT 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 257722 00019		ERIC TAN	Active	2014-09-30	Edit
700618 257722 00027	CARD 1	KENNY TAN	Active	2014-09-30	Edit
700618 257722 00035	BFY 9993		Active	2014-09-30	Edit
700618 257722 00043	BFT 1920		Active	2014-09-30	Edit
700618 257722 00050	TS 3786		Active	2014-09-30	Edit
700618 257722 00068	CARD 2	TANG WAI KEONG	Active	2014-09-30	Edit
700618 257722 00076	BGK 3256	BRANDON LIM	Active	2014-09-30	Edit
700618 257722 00084	WFY 9531	DAVID NG	Active	2014-09-30	Edit
700618 257722 00092	AER 6849	JOE EWE	Active	2014-09-30	Edit
700618 257722 00100	CAG 7268	MICHAEL FOO	Active	2014-09-30	Edit
700618 257722 00118	WKR 7666		Active	2014-09-30	Edit
700618 257722 00126	AER 6849	JOE EWE	Active	2014-09-30	Edit
700618 257722 00134		ERIC TAN	Active	2014-09-30	Edit
700618 257722 00142	WJG 9933	ERIC TAN	Active	2014-09-30	Edit
700618 257722 00159	BBY 6185	TAN CHYE	Active	2014-09-30	Edit
700618 257722 00167	BFE 5715	RICKY TAN	Active	2014-09-30	Edit
700618 257722 00175	TS 3786		Active	2014-09-30	Edit
700618 257722 00183	BHG 8369	ERIC TAN	Active	2014-09-30	Edit
700618 257722 00191	TS 3786		Active	2014-09-30	Edit
700618 257722 00209	BBY 6185	TAN CHYE	Active	2014-09-30	Edit
700618 257722 00217	BFE 5715	RICKY TAN	Active	2014-09-30	Edit
700618 257722 00225	CAG 7268	MICHAEL FOO	Active	2014-09-30	Edit
700618 257722 00233	AER 6849	JOE EWE	Active	2014-09-30	Edit
700618 257722 00241	AER 6849	JOE EWE	Active	2014-09-30	Edit
700618 257722 00258	CARD 1	KENNY TAN	Inactive	2014-09-30	Edit
789713 3000364 0010	WKR 7666		Active	2014-09-30	Edit
789713 3000364 0028	WJG 9933	ERIC TAN	Active	2014-09-30	Edit
789713 3000364 0036	TS 3786		Active	2014-09-30	Edit
789713 3000364 0044	BHG 8369	ERIC TAN	Active	2014-09-30	Edit
789713 3000364 0051	TS 3786		Active	2014-09-30	Edit
789713 3000364 0069	BBY 6185	TAN CHYE	Active	2014-09-30	Edit
789713 3000364 0077	BFE 5715	RICKY TAN	Active	2014-09-30	Edit
789713 3000364 0085	CAG 7268	MICHAEL FOO	Active	2014-09-30	Edit
789713 3000364 0093	AER 6849	JOE EWE	Active	2014-09-30	Edit
789713 3000364 0101	BFY 9993		Active	2014-09-30	Edit
789713 3000364 0119	BFT 1920		Active	2014-09-30	Edit
789713 3000364 0127	CARD 2	TANG WAI KEONG	Active	2014-09-30	Edit
789713 3000364 0135	CARD 1	KENNY TAN	Active	2014-09-30	Edit
789713 3000364 0143	CARD 1	KENNY TAN	Active	2014-09-30	Edit
789713 3000364 0150	TS 3786	ALL DRIVERS	Inactive	2014-09-30	Edit
789713 3000364 0168	TS 3786	ALL DRIVERS	Inactive	2014-09-30	Edit
789713 3000364 0176	AER 6849	JOE EWE	Active	2014-09-30	Edit
789713 3000364 0184	CARD 2	TANG WAI KEONG	Active	2014-09-30	Edit
789713 3000364 0192	CAG 7268	MICHAEL FOO	Inactive	2014-09-30	Edit