Sage EasyPay Data Model

Entity ProductDefineRecord

Description of Entity ProductDefineRecord

This entity is in relation to the LicenseRecord entity. Stores the product name, string and number key to allows access into the modules.

List of all Dependencies of the Entity ProductDefineRecord

Reference

Reference

List of Attributes of the Entity ProductDefineRecord

Sub Product Name

Entity Attribute Product Name of the Entity ProductDefineRecord

Card of Attribute Product Name of the Entity ProductDefineRecord

Name	Product Name
Code	ProductName
Data Type	char(100)
Mandatory	Yes

Description of Attribute Product Name of the Entity ProductDefineRecord

Stores the product name for the record. It is also the primary key for the ProductDefineRecord table.
Example: Sage EasyPay Enterprise

Entity Attribute Sub Product Name of the Entity ProductDefineRecord

Card of Attribute Sub Product Name of the Entity ProductDefineRecord

Name	Sub Product Name
Code	SubProductName
Data Type	char(100)
Mandatory	Yes

Description of Attribute Sub Product Name of the Entity ProductDefineRecord

Shows the sub product name for the record. This also acts as a primary key for the ProductDefineRecord table.

Entity Attribute PFunction1 of the Entity ProductDefineRecord

Card of Attribute PFunction1 of the Entity ProductDefineRecord

Name	PFunction1
Code	PFunction1
Data Type	char(50)
Mandatory	No

Description of Attribute PFunction1 of the Entity ProductDefineRecord

A parameter function for the product record.

Entity Attribute PFunction2 of the Entity ProductDefineRecord

Card of Attribute PFunction2 of the Entity ProductDefineRecord

Name	PFunction2
Code	PFunction2
Data Type	char(50)
Mandatory	No

Description of Attribute PFunction2 of the Entity ProductDefineRecord

A parameter function for the product record.

Entity Attribute PStrKey1 of the Entity ProductDefineRecord

Card of Attribute PStrKey1 of the Entity ProductDefineRecord

Name	PStrKey1
Code	PStrKey1
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey1 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PStrKey2 of the Entity ProductDefineRecord

Card of Attribute PStrKey2 of the Entity ProductDefineRecord

Name	PStrKey2
Code	PStrKey2
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey2 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PStrKey3 of the Entity ProductDefineRecord

Card of Attribute PStrKey3 of the Entity ProductDefineRecord

Name	PStrKey3
Code	PStrKey3
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey3 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PStrKey4 of the Entity ProductDefineRecord

Card of Attribute PStrKey4 of the Entity ProductDefineRecord

Name	PStrKey4
Code	PStrKey4
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey4 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PStrKey5 of the Entity ProductDefineRecord

Card of Attribute PStrKey5 of the Entity ProductDefineRecord

Name	PStrKey5
Code	PStrKey5
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey5 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PStrKey6 of the Entity ProductDefineRecord

Card of Attribute PStrKey6 of the Entity ProductDefineRecord

Name	PStrKey6
Code	PStrKey6
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey6 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PStrKey7 of the Entity ProductDefineRecord

Card of Attribute PStrKey7 of the Entity ProductDefineRecord

Name	PStrKey7
Code	PStrKey7
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey7 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PStrKey8 of the Entity ProductDefineRecord

Card of Attribute PStrKey8 of the Entity ProductDefineRecord

Name	PStrKey8
Code	PStrKey8
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey8 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PStrKey9 of the Entity ProductDefineRecord

Card of Attribute PStrKey9 of the Entity ProductDefineRecord

Name	PStrKey9
Code	PStrKey9
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey9 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PStrKey10 of the Entity ProductDefineRecord

Card of Attribute PStrKey10 of the Entity ProductDefineRecord

Name	PStrKey10
Code	PStrKey10
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey10 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PStrKey11 of the Entity ProductDefineRecord

Card of Attribute PStrKey11 of the Entity ProductDefineRecord

Name	PStrKey11
Code	PStrKey11
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey11 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PStrKey12 of the Entity ProductDefineRecord

Card of Attribute PStrKey12 of the Entity ProductDefineRecord

Name	PStrKey12
Code	PStrKey12
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey12 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PStrKey13 of the Entity ProductDefineRecord

Card of Attribute PStrKey13 of the Entity ProductDefineRecord

Name	PStrKey13
Code	PStrKey13
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey13 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PStrKey14 of the Entity ProductDefineRecord

Card of Attribute PStrKey14 of the Entity ProductDefineRecord

Name	PStrKey14
Code	PStrKey14
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey14 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PStrKey15 of the Entity ProductDefineRecord

Card of Attribute PStrKey15 of the Entity ProductDefineRecord

Name	PStrKey15
Code	PStrKey15
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey15 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PStrKey16 of the Entity ProductDefineRecord

Card of Attribute PStrKey16 of the Entity ProductDefineRecord

Name	PStrKey16
Code	PStrKey16
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey16 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PStrKey17 of the Entity ProductDefineRecord

Card of Attribute PStrKey17 of the Entity ProductDefineRecord

Name	PStrKey17
Code	PStrKey17
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey17 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PStrKey18 of the Entity ProductDefineRecord

Card of Attribute PStrKey18 of the Entity ProductDefineRecord

Name	PStrKey18
Code	PStrKey18
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey18 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PStrKey19 of the Entity ProductDefineRecord

Card of Attribute PStrKey19 of the Entity ProductDefineRecord

Name	PStrKey19
Code	PStrKey19
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey19 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PStrKey20 of the Entity ProductDefineRecord

Card of Attribute PStrKey20 of the Entity ProductDefineRecord

Name	PStrKey20
Code	PStrKey20
Data Type	char(50)
Mandatory	No

Description of Attribute PStrKey20 of the Entity ProductDefineRecord

A parameter string key for the product record.

Entity Attribute PNumKey1 of the Entity ProductDefineRecord

Card of Attribute PNumKey1 of the Entity ProductDefineRecord

Name	PNumKey1
Code	PNumKey1
Data Type	char(50)
Mandatory	No

Description of Attribute PNumKey1 of the Entity ProductDefineRecord

A parameter number key for the product record.

Entity Attribute PNumKey2 of the Entity ProductDefineRecord

Card of Attribute PNumKey2 of the Entity ProductDefineRecord

Name	PNumKey2
Code	PNumKey2
Data Type	char(50)
Mandatory	No

Description of Attribute PNumKey2 of the Entity ProductDefineRecord

A parameter number key for the product record.

Entity Attribute PNumKey3 of the Entity ProductDefineRecord

Card of Attribute PNumKey3 of the Entity ProductDefineRecord

Name	PNumKey3
Code	PNumKey3
Data Type	char(50)
Mandatory	No

Description of Attribute PNumKey3 of the Entity ProductDefineRecord

A parameter number key for the product record.

Entity Attribute PNumKey4 of the Entity ProductDefineRecord

Card of Attribute PNumKey4 of the Entity ProductDefineRecord

Name	PNumKey4
Code	PNumKey4
Data Type	char(50)
Mandatory	No

Description of Attribute PNumKey4 of the Entity ProductDefineRecord

A parameter number key for the product record.

Entity Attribute PNumKey5 of the Entity ProductDefineRecord

Card of Attribute PNumKey5 of the Entity ProductDefineRecord

Name	PNumKey5
Code	PNumKey5
Data Type	char(50)
Mandatory	No

Description of Attribute PNumKey5 of the Entity ProductDefineRecord

A parameter number key for the product record.

Entity Attribute PNumKey6 of the Entity ProductDefineRecord

Card of Attribute PNumKey6 of the Entity ProductDefineRecord

Name	PNumKey6
Code	PNumKey6
Data Type	char(50)
Mandatory	No

Description of Attribute PNumKey6 of the Entity ProductDefineRecord

A parameter number key for the product record.

Entity Attribute PNumKey7 of the Entity ProductDefineRecord

Card of Attribute PNumKey7 of the Entity ProductDefineRecord

Name	PNumKey7
Code	PNumKey7
Data Type	char(50)
Mandatory	No

Description of Attribute PNumKey7 of the Entity ProductDefineRecord

A parameter number key for the product record.

Entity Attribute PNumKey8 of the Entity ProductDefineRecord

Card of Attribute PNumKey8 of the Entity ProductDefineRecord

Name	PNumKey8
Code	PNumKey8
Data Type	char(50)
Mandatory	No

Description of Attribute PNumKey8 of the Entity ProductDefineRecord

A parameter number key for the product record.

Entity Attribute PNumKey9 of the Entity ProductDefineRecord

Card of Attribute PNumKey9 of the Entity ProductDefineRecord

Name	PNumKey9
Code	PNumKey9
Data Type	char(50)
Mandatory	No

Description of Attribute PNumKey9 of the Entity ProductDefineRecord

A parameter number key for the product record.

Entity Attribute PNumKey10 of the Entity ProductDefineRecord

Card of Attribute PNumKey10 of the Entity ProductDefineRecord

Name	PNumKey10
Code	PNumKey10
Data Type	char(50)
Mandatory	No

Description of Attribute PNumKey10 of the Entity ProductDefineRecord

A parameter number key for the product record.

Entity Attribute PNumKey11 of the Entity ProductDefineRecord

Card of Attribute PNumKey11 of the Entity ProductDefineRecord

Name	PNumKey11
Code	PNumKey11
Data Type	char(50)
Mandatory	No

Description of Attribute PNumKey11 of the Entity ProductDefineRecord

A parameter number key for the product record.

Entity Attribute PNumKey12 of the Entity ProductDefineRecord

Card of Attribute PNumKey12 of the Entity ProductDefineRecord

Name	PNumKey12
Code	PNumKey12
Data Type	char(50)
Mandatory	No

Description of Attribute PNumKey12 of the Entity ProductDefineRecord

A parameter number key for the product record.

Entity Attribute PNumKey13 of the Entity ProductDefineRecord

Card of Attribute PNumKey13 of the Entity ProductDefineRecord

Name	PNumKey13
Code	PNumKey13
Data Type	char(50)
Mandatory	No

Description of Attribute PNumKey13 of the Entity ProductDefineRecord

A parameter number key for the product record.

Entity Attribute PNumKey14 of the Entity ProductDefineRecord

Card of Attribute PNumKey14 of the Entity ProductDefineRecord

Name	PNumKey14
Code	PNumKey14
Data Type	char(50)
Mandatory	No

Description of Attribute PNumKey14 of the Entity ProductDefineRecord

A parameter number key for the product record.

Entity Attribute PNumKey15 of the Entity ProductDefineRecord

Card of Attribute PNumKey15 of the Entity ProductDefineRecord

Name	PNumKey15
Code	PNumKey15
Data Type	char(50)
Mandatory	No

Description of Attribute PNumKey15 of the Entity ProductDefineRecord

A parameter number key for the product record.

Entity Attribute PNumKey16 of the Entity ProductDefineRecord

Card of Attribute PNumKey16 of the Entity ProductDefineRecord

Name	PNumKey16
Code	PNumKey16
Data Type	char(50)
Mandatory	No

Description of Attribute PNumKey16 of the Entity ProductDefineRecord

A parameter number key for the product record.

Entity Attribute PNumKey17 of the Entity ProductDefineRecord

Card of Attribute PNumKey17 of the Entity ProductDefineRecord

Name	PNumKey17
Code	PNumKey17
Data Type	char(50)
Mandatory	No

Description of Attribute PNumKey17 of the Entity ProductDefineRecord

A parameter number key for the product record.

Entity Attribute PNumKey18 of the Entity ProductDefineRecord

Card of Attribute PNumKey18 of the Entity ProductDefineRecord

Name	PNumKey18
Code	PNumKey18
Data Type	char(50)
Mandatory	No

Entity Attribute PNumKey19 of the Entity ProductDefineRecord

Card of Attribute PNumKey19 of the Entity ProductDefineRecord

Name	PNumKey19
Code	PNumKey19
Data Type	char(50)
Mandatory	No

Description of Attribute PNumKey19 of the Entity ProductDefineRecord

A parameter number key for the product record.

Entity Attribute PNumKey20 of the Entity ProductDefineRecord

Card of Attribute PNumKey20 of the Entity ProductDefineRecord

Name	PNumKey20
Code	PNumKey20
Data Type	char(50)
Mandatory	No

Description of Attribute PNumKey20 of the Entity ProductDefineRecord

A parameter number key for the product record.