Customer Detail

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

Back to List

Customer Workspace

SYARIKAT KENDERAAN SATRIA SDN BHD

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No 39226-K

Contacts 4

Managed Cards 112

Record Status 1

SYARIKAT KENDERAAN SATRIA 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 200003 00012	WAJ 8817		Active	2015-11-30	Edit
700618 200003 00020	WAM 3647		Active	2015-11-30	Edit
700618 200003 00038	WBA 9332		Active	2015-11-30	Edit
700618 200003 00046	WBF 1755		Active	2015-11-30	Edit
700618 200003 00053	WBF 1685		Active	2015-11-30	Edit
700618 200003 00061	WBM 5427		Active	2015-11-30	Edit
700618 200003 00079	WBP 8288		Active	2015-11-30	Edit
700618 200003 00087	WBQ 4653		Active	2015-11-30	Edit
700618 200003 00095	WBU 7618		Active	2015-11-30	Edit
700618 200003 00103	WBV 5352		Active	2015-11-30	Edit
700618 200003 00111	WCE 2218 H		Active	2015-11-30	Edit
700618 200003 00129	WAJ 8817		Active	2015-11-30	Edit
700618 200003 00137	WAJ 8817		Active	2015-11-30	Edit
700618 200003 00145	WAM 3647		Active	2015-11-30	Edit
700618 200003 00152	WAM 3647		Active	2015-11-30	Edit
700618 200003 00160	WBA 9332		Active	2015-11-30	Edit
700618 200003 00178	WBA 9332		Active	2015-11-30	Edit
700618 200003 00186	WBF 1685		Active	2015-11-30	Edit
700618 200003 00194	WBF 1685		Active	2015-11-30	Edit
700618 200003 00202	WCE 2218		Active	2015-11-30	Edit
700618 200003 00210	WCE 2218		Active	2015-11-30	Edit
700618 200003 00228	WCE 2218		Active	2015-11-30	Edit
700618 200003 00236	WBF 1755		Active	2015-11-30	Edit
700618 200003 00244	WBF 1755		Active	2015-11-30	Edit
700618 200003 00251	WBM 5427		Active	2015-11-30	Edit
700618 200003 00269	WBM 5427		Active	2015-11-30	Edit
700618 200003 00277	WBP 8288		Active	2015-11-30	Edit
700618 200003 00285	WBP 8288		Active	2015-11-30	Edit
700618 200003 00293	WBQ 4653		Active	2015-11-30	Edit
700618 200003 00301	WBQ 4653		Active	2015-11-30	Edit
700618 200003 00319	WBU 7618		Active	2015-11-30	Edit
700618 200003 00327	WBU 7618		Active	2015-11-30	Edit
700618 200003 00335	WBV 5352		Active	2015-11-30	Edit
700618 200003 00343	WBV 5352		Active	2015-11-30	Edit
700618 200003 00350	WCQ 7368		Active	2015-11-30	Edit
700618 200003 00368	WCQ 7368		Active	2015-11-30	Edit
700618 200003 00376	WCQ 7368		Active	2015-11-30	Edit
700618 200003 00384	WBA 9332		Active	2015-11-30	Edit
700618 200003 00392	WAM 3647		Active	2015-11-30	Edit
700618 200003 00400	WBQ 4653		Active	2015-11-30	Edit
700618 200003 00418	WAM 3647		Active	2015-11-30	Edit
700618 200003 00426	WAM 3647		Active	2015-11-30	Edit
700618 200003 00434	WCX 1028		Active	2015-11-30	Edit
700618 200003 00442	WCX 1028		Active	2015-11-30	Edit
700618 200003 00459	WCX 1028		Active	2015-11-30	Edit
700618 200003 00467	WCX 1048		Active	2015-11-30	Edit
700618 200003 00475	WCX 1048		Active	2015-11-30	Edit
700618 200003 00483	WCX 1048		Active	2015-11-30	Edit
700618 200003 00491	WCQ 7368		Active	2015-11-30	Edit
700618 200003 00509	WDU 4285	LEE EE MOOI	Active	2015-11-30	Edit
700618 200003 00517	WDU 4285	ANUAR BIN JAMARI	Active	2015-11-30	Edit
700618 200003 00525	WDU 2185	SAEMAN BIN SAWIN	Active	2015-11-30	Edit
700618 200003 00533	WDU 2185	MD SALLEH ABDULLAH	Active	2015-11-30	Edit
700618 200003 00541	WFX 1374	MALAYSIA	Active	2015-11-30	Edit
700618 200003 00558	WGG 7173		Active	2015-11-30	Edit
700618 200003 00566	WGY 479		Active	2015-11-30	Edit
700618 200003 00574	WGY 651		Active	2015-11-30	Edit
700618 200003 00582	WJS 4862		Active	2015-11-30	Edit
700618 200003 00590	WJP 2317		Active	2015-11-30	Edit
700618 200003 00608	WJP 2309		Active	2015-11-30	Edit
700618 200003 00616	WJU 7620		Active	2015-11-30	Edit
700618 200003 00624	WKN 1976		Active	2015-11-30	Edit
700618 200003 00632	WKN 1984		Active	2015-11-30	Edit
700618 200003 00640	WDU 4285	ANUAR BIN JAMAR	Active	2015-11-30	Edit
700618 200003 00657	WGG 7173		Active	2015-11-30	Edit
700618 200003 00665	WGY 479		Active	2015-11-30	Edit
700618 200003 00673	WGY 651		Active	2015-11-30	Edit
700618 200003 00681	WJP 2317		Active	2015-11-30	Edit
700618 200003 00699	WJP 2309		Active	2015-11-30	Edit
700618 200003 00707	WJU 7620		Active	2015-11-30	Edit
700618 200003 00715	WKN 1976		Active	2015-11-30	Edit
700618 200003 00723	WKN 1984		Active	2015-11-30	Edit
700618 200003 00731	WJS 4862		Active	2015-11-30	Edit
700618 200003 00749	WFX 1374	MALAYSIA	Active	2015-11-30	Edit
700618 200003 00756	WJS 4862		Active	2015-11-30	Edit
700618 200003 00764	WLJ 5438		Active	2015-11-30	Edit
700618 200003 00772	WLS 614		Active	2015-11-30	Edit
700618 200003 00780	WLY 3084		Active	2015-11-30	Edit
700618 200003 00798	WJS 4862		Active	2015-11-30	Edit
700618 200003 00806	WJS 4862		Active	2015-11-30	Edit
700618 200003 00814	WJU 7620		Active	2015-11-30	Edit
700618 200003 00822	WKN 1976		Active	2015-11-30	Edit
700618 200003 00830	WKN 1984		Active	2015-11-30	Edit
700618 200003 00848	WJS 4862		Active	2015-11-30	Edit
700618 200003 00855	WJS 4862		Active	2015-11-30	Edit
789713 3001169 0015	WDU 2185	MD SALLEH ABDULLAH	Active	2015-11-30	Edit
789713 3001169 0023	WDU 4285	ANUAR BIN JAMAR	Active	2015-11-30	Edit
789713 3001169 0031	WGG 7173		Active	2015-11-30	Edit
789713 3001169 0049	WGY 479		Active	2015-11-30	Edit
789713 3001169 0056	WGY 651		Active	2015-11-30	Edit
789713 3001169 0064	WJP 2317		Active	2015-11-30	Edit
789713 3001169 0072	WJP 2309		Active	2015-11-30	Edit
789713 3001169 0080	WFX 1374	MALAYSIA	Active	2015-11-30	Edit
789713 3001169 0098	WLJ 5438		Active	2015-11-30	Edit
789713 3001169 0106	WLS 614		Active	2015-11-30	Edit
789713 3001169 0114	WLY 3084		Active	2015-11-30	Edit
789713 3001169 0122	WKN 1976		Active	2015-11-30	Edit
789713 3001169 0130	WKN 1984		Active	2015-11-30	Edit
789713 3001169 0148	WJS 4862		Active	2015-11-30	Edit
789713 3001169 0155	WJU 7620		Active	2015-11-30	Edit
789713 3001169 0163	WKN 1976		Active	2015-11-30	Edit
789713 3001169 0171	WSA 7731	ALL DRIVERS	Inactive	2015-11-30	Edit
789713 3001169 0189	WSA 7839	ALL DRIVERS	Inactive	2015-11-30	Edit
789713 3001169 0197	WSA 7734	ALL DRIVERS	Inactive	2015-11-30	Edit
789713 3001169 0205	WSA 7732	ALL DRIVERS	Inactive	2015-11-30	Edit
789713 3001169 0213	WSA 7735	ALL DRIVERS	Inactive	2015-11-30	Edit
789713 3001169 0221	WSA 7837	ALL DRIVERS	Inactive	2015-11-30	Edit
789713 3001169 0239	WSF 5267		Inactive	2015-11-30	Edit
789713 3001169 0247	WTM 2636		Inactive	2015-11-30	Edit
789713 3001169 0254	WTM 2630		Inactive	2015-11-30	Edit
789713 3001169 0262	WRD 1035	JESSIE CHUA	Inactive	2015-11-30	Edit
789713 3001169 0270	WUP 1025	GARY LOK	Inactive	2015-11-30	Edit