Customer Detail

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

Back to List

Customer Workspace

A M-OFFICE SYSTEM SDN BHD

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No 3662286K

Contacts 3

Managed Cards 38

Record Status 1

A M-OFFICE SYSTEM 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 211515 00012	WER 3512		Active	2007-06-30	Edit
700618 211515 00020	WFB 9591		Active	2007-06-30	Edit
700618 211515 00038	WEK 8373		Active	2007-06-30	Edit
700618 211515 00046	WEB 9366		Active	2007-06-30	Edit
700618 211515 00053	BDQ 1980		Active	2007-06-30	Edit
700618 211515 00061	WES 4338		Active	2007-06-30	Edit
700618 211515 00079	WER 3512		Active	2007-06-30	Edit
700618 211515 00087	WHB 8750	MALAYSIA	Active	2007-06-30	Edit
700618 211515 00095	WHM 5809		Active	2007-06-30	Edit
700618 211515 00103	WEJ 6023	MALAYSIA	Active	2007-06-30	Edit
700618 211515 00111	WEN 8876	AM-OFFICE SYSTEM S/B	Active	2007-06-30	Edit
700618 211515 00129	WDJ 9574	MALAYSIA	Active	2007-06-30	Edit
700618 211515 00137	WDV 2586	MALAYSIA	Active	2007-06-30	Edit
700618 211515 00145	WEM 6823	MALAYSIA	Active	2007-06-30	Edit
700618 211515 00152	BFC 9899	MALAYSIA	Active	2007-06-30	Edit
700618 211515 00160	WEJ 6023	MALAYSIA	Active	2007-06-30	Edit
700618 211515 00178	WHB 8750		Active	2007-06-30	Edit
700618 211515 00186	WHM 5809		Active	2007-06-30	Edit
700618 211515 00194	WFB 9591		Active	2007-06-30	Edit
700618 211515 00202	WJK 7388	MALAYSIA	Active	2007-06-30	Edit
700618 211515 00210	WKE 500		Active	2007-06-30	Edit
700618 211515 00228	BFD 49		Active	2007-06-30	Edit
700618 211515 00236	WER 1557		Active	2007-06-30	Edit
700618 211515 00244	BEU 958		Active	2007-06-30	Edit
700618 211515 00251	WKK 500		Active	2007-06-30	Edit
700618 211515 00269	WKM 32		Active	2007-06-30	Edit
700618 211515 00277	WKU 246		Active	2007-06-30	Edit
700618 211515 00285	BGV 1125		Active	2007-06-30	Edit
700618 211515 00293	WLA 8401	AM OFFICE SYSTEM SDN BHD	Active	2007-06-30	Edit
700618 211515 00301	WLD 500		Active	2007-06-30	Edit
700618 211515 00319	WKE 500		Active	2007-06-30	Edit
700618 211515 00327	WLD 500		Active	2007-06-30	Edit
700618 211515 00335	WFB 3538		Active	2007-06-30	Edit
700618 211515 00343	WLD 13		Active	2007-06-30	Edit
700618 211515 00350	WLP 4270		Active	2007-06-30	Edit
700618 211515 00368	WLU 3312		Active	2007-06-30	Edit
700618 211515 00376	WLU 3213		Active	2007-06-30	Edit
700618 211515 00384	WMA 3321	MALAYSIA	Active	2007-06-30	Edit