Customer Detail

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

Back to List

Customer Workspace

A.M.S MAJU TRANSPORT SDN BHD

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No 563812-H

Contacts 3

Managed Cards 24

Record Status 1

A.M.S MAJU TRANSPORT 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	Record Status	Renewal Expiry
789713 3003908 0017	AFL 4931	Inactive	2012-10-31	Edit
789713 3003908 0025	AFU 2051	Inactive	2012-10-31	Edit
789713 3003908 0033	AFU 4931	Inactive	2012-10-31	Edit
789713 3003908 0041	AFU 9648	Inactive	2012-10-31	Edit
789713 3003908 0058	AGW 4931	Inactive	2012-10-31	Edit
789713 3003908 0066	AGB 9430	Inactive	2012-10-31	Edit
789713 3003908 0074	NAQ 4963	Inactive	2012-10-31	Edit
789713 3003908 0082	NAQ 7389	Inactive	2012-10-31	Edit
789713 3003908 0090	NBC 7333	Inactive	2012-10-31	Edit
789713 3003908 0108	JCE 3554	Inactive	2012-10-31	Edit
789713 3003908 0116	WHE 9502	Inactive	2012-10-31	Edit
789713 3003908 0124	WTF 7858	Inactive	2012-10-31	Edit
789713 3003908 0132	CBH 1169	Inactive	2012-10-31	Edit
789713 3003908 0140	WEP 387	Inactive	2012-10-31	Edit
789713 3003908 0157	WCP 5921	Inactive	2012-10-31	Edit
789713 3003908 0165	WEW 5274	Inactive	2012-10-31	Edit
789713 3003908 0173	WCB 8165	Inactive	2012-10-31	Edit
789713 3003908 0181	WCU 2431	Inactive	2012-10-31	Edit
789713 3003908 0199	BDG 8519	Inactive	2012-10-31	Edit
789713 3003908 0207	BEU 5009	Inactive	2012-10-31	Edit
789713 3003908 0215	BEW 8792	Inactive	2012-10-31	Edit
789713 3003908 0223	BEM 8261	Inactive	2012-10-31	Edit
789713 3003908 0231	BEJ 1633	Inactive	2012-10-31	Edit
789713 3003908 0249	WFX 6835	Inactive	2012-10-31	Edit