Entity DMBRecurring

Description of Entity DMBRecurring

This entity is for the Philippines Payroll.


List of all Dependencies of the Entity DMBRecurring

Name

Code

Class Name

Relationship_748

Relationship_748

Reference

Relationship_749

Relationship_749

Reference

Relationship_750

Relationship_750

Reference


List of Attributes of the Entity DMBRecurring

Name

Code

EmployeeSysId

EmployeeSysId

DMBRecurSysId

DMBRecurSysId

DMB Start Year

DMBStartYear

DMB StartPeriod

DMBStartPeriod

DMB End Period

DMBEndPeriod

DMB Annual Amount

DMBAnnualAmount

DMB No Of Payment

DMBNoOfPayment

DMB Payment Per Sub Period

DMBPaymentPerSubPeriod

DMB Previous Payment

DMBPreviousPayment

Remarks

Remarks


Entity Attribute EmployeeSysId of the Entity DMBRecurring

Card of Attribute EmployeeSysId of the Entity DMBRecurring

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

No


Description of Attribute EmployeeSysId of the Entity DMBRecurring

System generated identifier. It is blind to the user. It also holds the primary key for the Employee table.


Entity Attribute DMBRecurSysId of the Entity DMBRecurring

Card of Attribute DMBRecurSysId of the Entity DMBRecurring

Name

DMBRecurSysId

Code

DMBRecurSysId

Data Type

integer

Mandatory

Yes


Description of Attribute DMBRecurSysId of the Entity DMBRecurring

A system generated identity. It is blind to the user. This is also the primary key for the DMBRecurring table.


Entity Attribute DMB Start Year of the Entity DMBRecurring

Card of Attribute DMB Start Year of the Entity DMBRecurring

Name

DMB Start Year

Code

DMBStartYear

Data Type

double

Mandatory

No


Description of Attribute DMB Start Year of the Entity DMBRecurring

Shows the start year range.


Entity Attribute DMB StartPeriod of the Entity DMBRecurring

Card of Attribute DMB StartPeriod of the Entity DMBRecurring

Name

DMB StartPeriod

Code

DMBStartPeriod

Data Type

double

Mandatory

No


Description of Attribute DMB StartPeriod of the Entity DMBRecurring

Shows the start period range.


Entity Attribute DMB End Period of the Entity DMBRecurring

Card of Attribute DMB End Period of the Entity DMBRecurring

Name

DMB End Period

Code

DMBEndPeriod

Data Type

double

Mandatory

No


Description of Attribute DMB End Period of the Entity DMBRecurring

Shows the end period range.


Entity Attribute DMB Annual Amount of the Entity DMBRecurring

Card of Attribute DMB Annual Amount of the Entity DMBRecurring

Name

DMB Annual Amount

Code

DMBAnnualAmount

Data Type

double

Mandatory

No


Description of Attribute DMB Annual Amount of the Entity DMBRecurring

Stores the annual amount.


Entity Attribute DMB No Of Payment of the Entity DMBRecurring

Card of Attribute DMB No Of Payment of the Entity DMBRecurring

Name

DMB No Of Payment

Code

DMBNoOfPayment

Data Type

double

Mandatory

No


Description of Attribute DMB No Of Payment of the Entity DMBRecurring

Shows the number of payment.


Entity Attribute DMB Payment Per Sub Period of the Entity DMBRecurring

Card of Attribute DMB Payment Per Sub Period of the Entity DMBRecurring

Name

DMB Payment Per Sub Period

Code

DMBPaymentPerSubPeriod

Data Type

double

Mandatory

No


Description of Attribute DMB Payment Per Sub Period of the Entity DMBRecurring

Shows the payment per sub period.


Entity Attribute DMB Previous Payment of the Entity DMBRecurring

Card of Attribute DMB Previous Payment of the Entity DMBRecurring

Name

DMB Previous Payment

Code

DMBPreviousPayment

Data Type

double

Mandatory

No


Description of Attribute DMB Previous Payment of the Entity DMBRecurring

Shows the previous payment amount.


Entity Attribute Remarks of the Entity DMBRecurring

Card of Attribute Remarks of the Entity DMBRecurring

Name

Remarks

Code

Remarks

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks of the Entity DMBRecurring

Store remarks.