Sage EasyPay Data Model

Entity ImportFieldName

Description of Entity ImportFieldName

This entity shows the field names for the Import Designer.

List of all Dependencies of the Entity ImportFieldName

Reference

List of Attributes of the Entity ImportFieldName

FieldNamePhysical

FieldNamePhysical

FieldNameUserDefined

FieldNameUserDefined

Entity Attribute FieldNamePhysical of the Entity ImportFieldName

Card of Attribute FieldNamePhysical of the Entity ImportFieldName

Name	FieldNamePhysical
Code	FieldNamePhysical
Data Type	char(50)
Mandatory	Yes

Description of Attribute FieldNamePhysical of the Entity ImportFieldName

Shows the physical name for the import field. This holds the primary key for the ImportFieldName table.
Example: AllowanceDeclaredDate / HireDate etc

Entity Attribute FieldNameUserDefined of the Entity ImportFieldName

Card of Attribute FieldNameUserDefined of the Entity ImportFieldName

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

Description of Attribute FieldNameUserDefined of the Entity ImportFieldName

A user defined name for the import field.
Example: Declared Date / Hire Date etc

Entity Attribute Field Type of the Entity ImportFieldName

Card of Attribute Field Type of the Entity ImportFieldName

Name	Field Type
Code	FieldType
Data Type	char(20)
Mandatory	No

Description of Attribute Field Type of the Entity ImportFieldName

Displays the field type.
Example: Date / Sting / Numeric etc

Entity Attribute Is Key of the Entity ImportFieldName

Card of Attribute Is Key of the Entity ImportFieldName

Name	Is Key
Code	IsKey
Data Type	smallint
Mandatory	No

Description of Attribute Is Key of the Entity ImportFieldName

Indicates if the attribute is a key or not, in a form of a checkbox.