Purchases

Field No.	Field Name	Unique?	Type	Length	Details
1	Purchase Identifier	Y	Big Integer		The ID of the purchase
2	Account Number	Y	Numeric	8,0	CMP Account Number
3	Purchase Timestamp		Numeric		The date and time of the purchase. DD-MM-YYYY HHMMSS format.
4	Purchase Status		Char	1	The code for the status of the purchase and the description of the status: Complete In Progress Error
5	Purchase Type		Alphanumeric		The code for the purchase type and the description, for example: prepaid postpaid
6	Salesperson Number		Numeric	8,0	Numeric ID of the salesperson and their name
7	Sales Channel Code		Char	6,0	The code of the sales channel and the description of the channel.
8	Reason Code		Char	4,0	The code for the reason for the purchase
9	Event Number		Numeric	9,0	The number of the workflow event for the purchase
10	Receipt Requested		Alphanumeric	1	Whether a receipt was requested. Either 1=Yes or 0=No.
11	Customer Level		Alphanumeric	1	Tyhe code for level at which the info is stored and the level description: G = Group, C = Corporate, A = Account, S = Subscription, M = Agreement
12	Customer Reference		Alphanumeric	60,0	Unique reference for the customer. This is tied to the Customer Level, e.g. if the customer level is Account, the reference is the CMP Account Number; if the level is Subscription, the reference is the Subscription Number, etc.
13	Product Type		Char	1	Whether the product is a bolt-on or top-up package. Currently only the "Package" product type is supported.
14	Product Code		Char	6	The product code and the description of the product. Currently only the "Package Description" is supported.
15	Date Created		Numeric	7,0	Date record created in CMP. YYYY-MM-DD format
16	Audit Process		varchar	50	Process that created the record
17	Audit Timestamp		Timestamp		Date/yime the record changed in CMP.
18	Audit User		varchar	50	ID of user who changed the record
19	Data Extract Date		Numeric	7,0	Date that the data above was extracted from CMP. YYYY-MM-DD format.

1

Purchase Identifier

Y

Big Integer

The ID of the purchase

2

Account Number

Y

Numeric

8,0

CMP Account Number

3

Purchase Timestamp

Numeric

The date and time of the purchase. DD-MM-YYYY HHMMSS format.

4

Purchase Status

Char

1

The code for the status of the purchase and the description of the status:

Complete
In Progress
Error

5

Purchase Type

Alphanumeric

The code for the purchase type and the description, for example:

prepaid
postpaid

6

Salesperson Number

Numeric

8,0

Numeric ID of the salesperson and their name

7

Sales Channel Code

Char

6,0

The code of the sales channel and the description of the channel.

8

Reason Code

Char

4,0

The code for the reason for the purchase

9

Event Number

Numeric

9,0

The number of the workflow event for the purchase

10

Receipt Requested

Alphanumeric

1

Whether a receipt was requested. Either 1=Yes or 0=No.

11

Customer Level

Alphanumeric

1

Tyhe code for level at which the info is stored and the level description:

G = Group, C = Corporate, A = Account, S = Subscription, M = Agreement

12

Customer Reference

Alphanumeric

60,0

Unique reference for the customer. This is tied to the Customer Level, e.g. if the customer level is Account, the reference is the CMP Account Number; if the level is Subscription, the reference is the Subscription Number, etc.

13

Product Type

Char

1

Whether the product is a bolt-on or top-up package. Currently only the "Package" product type is supported.

14

Product Code

Char

6

The product code and the description of the product. Currently only the "Package Description" is supported.

15

Date Created

Numeric

7,0

Date record created in CMP. YYYY-MM-DD format

16

Audit Process

varchar

50

Process that created the record

17

Audit Timestamp

Timestamp

Date/yime the record changed in CMP.

18

Audit User

varchar

50

ID of user who changed the record

19

Data Extract Date

Numeric

7,0

Date that the data above was extracted from CMP. YYYY-MM-DD format.