Customer Detail

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

Back to List

Customer Workspace

AIKBEE TIMBERS (SABAH) SDN BHD

Compact enterprise workspace for customer_master, applicant_contact, and card_master.

Company Reg No 205559-H

Contacts 3

Managed Cards 24

Record Status 1

AIKBEE TIMBERS (SABAH) 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 265263 00014	AIKBEE 1	MALAYSIA	Active	2007-04-30	Edit
700618 265263 00022	AIKBEE 2	MALAYSIA	Active	2007-04-30	Edit
700618 265263 00030	AIKBEE 3	MALAYSIA	Active	2007-04-30	Edit
700618 265263 00048	AIKBEE 4	MALAYSIA	Active	2007-04-30	Edit
700618 265263 00055	AIKBEE 5	MALAYSIA	Active	2007-04-30	Edit
700618 265263 00063	AIKBEE 6	MALAYSIA	Active	2007-04-30	Edit
700618 265263 00071	AIKBEE 7	MALAYSIA	Active	2007-04-30	Edit
700618 265263 00089	AIKBEE 8	MALAYSIA	Active	2007-04-30	Edit
700618 265263 00097	AIKBEE 9	MALAYSIA	Active	2007-04-30	Edit
700618 265263 00105	AIKBEE 10	MALAYSIA	Active	2007-04-30	Edit
700618 265263 00113	AIKBEE 11	MALAYSIA	Active	2007-04-30	Edit
700618 265263 00121	AIKBEE 12	MALAYSIA	Active	2007-04-30	Edit
700618 265263 00139		AIKBEE 13	Active	2007-04-30	Edit
700618 265263 00147		AIKBEE 14	Active	2007-04-30	Edit
700618 265263 00154		AIKBEE 15	Active	2007-04-30	Edit
700618 265263 00162	AIKBEE 12		Active	2007-04-30	Edit
700618 265263 00170	AIKBEE 6		Active	2007-04-30	Edit
700618 265263 00188	AIKBEE 12		Active	2007-04-30	Edit
700618 265263 00196	AIKBEE 10		Active	2007-04-30	Edit
700618 265263 00204	AIKBEE 14	MALAYSIA	Active	2007-04-30	Edit
700618 265263 00212	AIKBEE 16	MALAYSIA	Active	2007-04-30	Edit
700618 265263 00220	AIKBEE 17	MALAYSIA	Active	2007-04-30	Edit
700618 265263 00238	AIKBEE 9	MALAYSIA	Active	2007-04-30	Edit
700618 265263 00246	MALAYSIA	AIKBEE 18	Active	2007-04-30	Edit