Entity PaymentBankInfo

Description of Entity PaymentBankInfo

This controls when the pay elements are inserted into the employee's pay record. How the payment to the employee would be made, what amount etc


List of all Dependencies of the Entity PaymentBankInfo

Name

Code

Class Name

Relation_42563

Relation_42563

Reference

Relation_75682

Relation_75682

Reference

Relation_347543

Relation_347543

Reference

Relation_1875099

Relation_1875099

Reference


List of Attributes of the Entity PaymentBankInfo

Name

Code

EmployeeSysId

EmployeeSysId

PayBankSGSPGenId

PayBankSGSPGenId

BankAccountNo

BankAccountNo

Payment Value

PaymentValue

Payment Type

PaymentType

Payment Mode

PaymentMode

BankRemarks

BankRemarks

Beneficiary Name

BeneficiaryName


Entity Attribute EmployeeSysId of the Entity PaymentBankInfo

Card of Attribute EmployeeSysId of the Entity PaymentBankInfo

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute EmployeeSysId of the Entity PaymentBankInfo

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


Entity Attribute PayBankSGSPGenId of the Entity PaymentBankInfo

Card of Attribute PayBankSGSPGenId of the Entity PaymentBankInfo

Name

PayBankSGSPGenId

Code

PayBankSGSPGenId

Data Type

char(30)

Mandatory

Yes


Description of Attribute PayBankSGSPGenId of the Entity PaymentBankInfo

Shows the generating identity of the payment bank. This is the primary key for the PaymentBankInfo table.
Example: A2 / A5 / A9


Entity Attribute BankAccountNo of the Entity PaymentBankInfo

Card of Attribute BankAccountNo of the Entity PaymentBankInfo

Name

BankAccountNo

Code

BankAccountNo

Data Type

char(30)

Mandatory

No


Description of Attribute BankAccountNo of the Entity PaymentBankInfo

Shows the bank account number.


Entity Attribute Payment Value of the Entity PaymentBankInfo

Card of Attribute Payment Value of the Entity PaymentBankInfo

Name

Payment Value

Code

PaymentValue

Data Type

double

Mandatory

No


Description of Attribute Payment Value of the Entity PaymentBankInfo

Shows the value of how much is being paid in percentage.
Example: "100" = Full amount / "50" = Half amount


Entity Attribute Payment Type of the Entity PaymentBankInfo

Card of Attribute Payment Type of the Entity PaymentBankInfo

Name

Payment Type

Code

PaymentType

Data Type

char(20)

Mandatory

No


Description of Attribute Payment Type of the Entity PaymentBankInfo

Shows the type of payment made.
Example: Percentage / Balance / Fixed Amount


Entity Attribute Payment Mode of the Entity PaymentBankInfo

Card of Attribute Payment Mode of the Entity PaymentBankInfo

Name

Payment Mode

Code

PaymentMode

Data Type

char(20)

Mandatory

No


Description of Attribute Payment Mode of the Entity PaymentBankInfo

Shows the mode of payment.
Example: Direct Debit / Cheque / Cash


Entity Attribute BankRemarks of the Entity PaymentBankInfo

Card of Attribute BankRemarks of the Entity PaymentBankInfo

Name

BankRemarks

Code

BankRemarks

Data Type

char(100)

Mandatory

No


Description of Attribute BankRemarks of the Entity PaymentBankInfo

Stores any remarks about the bank payment.


Entity Attribute Beneficiary Name of the Entity PaymentBankInfo

Card of Attribute Beneficiary Name of the Entity PaymentBankInfo

Name

Beneficiary Name

Code

BeneficiaryName

Data Type

char(150)

Mandatory

No


Description of Attribute Beneficiary Name of the Entity PaymentBankInfo

The name of the person who will receive the money.