Search TipsKey Customer Info
|
Field No. |
Column Heading |
Unique? |
Type |
Length |
Details |
|---|---|---|---|---|---|
|
1 |
Customer Level |
Y |
Alphanumeric |
1 |
Level at which the info is stored G = Group, C = Corporate, A = Account, S = Subscription, M = Agreement |
|
2 |
Reference |
Y |
Alphanumeric |
8 |
Reference for the Info - Group/Corporate Code, Account/Subscription Number |
|
3 |
Key Customer Reference |
Y |
Numeric |
8,0 |
Unique reference automatically generated by CMP |
|
4 |
Key Customer Sequence |
Y |
Numeric |
3,0 |
Sequence in which the data is displayed |
|
5 |
Line No |
Y |
Numeric |
8,0 |
|
|
6 |
Key Customer Sequence Description |
|
Alphanumeric |
40 |
Description of Key Info |
|
7 |
Key Customer Text |
|
Alphanumeric |
40 |
Free text field relating to the Description |
|
8 |
Date Created |
|
Numeric |
7,0 |
Date record created in CMP. YYYY-MM-DD HH:MM:SS format . |
|
9 |
Created By |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
10 |
Date Changed |
|
Numeric |
7,0 |
Date record changed in CMP. YYYY-MM-DD HH:MM:SS format . |
|
11 |
Changed By |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
12 |
Data Extract Date |
|
Numeric |
7,0 |
Date that the data above was extracted from CMP. YYYY-MM-DD HH:MM:SS format . |