is a foreign key column in Vouchers table. The data type and properties of this column should be the same as that of code column of Accounts table, except that its Indexed property need be set to Yes Duplicates OK). The relationship between the code column of accounts table and debit column of Vouchers table must also be defined so as to maintain referential integrity. Amount : This column is meant to store the amount of transaction and is common to the accounts being debited and credited.
Its data type can be Number with field size set to double; format set to standard; decimal places set to and default value set to . . Alternatively, its data type can be chosen as currency type, in that case its format can be either accepted as currency or set to standard with decimal places set to . Vdate : This column of the table stores the date of transaction.
Its data type is set to Date/Time with format set to Medium Date (dd-MMM- yy); Default value set to = Now() to imply current date in Real Time Clock (RTC) of computer system and caption property set to Date. Credit : This column is meant to store the code corresponding to the account being credited in recording a transaction. Like Debit column, this column too shares the same properties as code column of Accounts table and must also be dealt with in the same manner as Debit column described above. Narration : This column is meant to store the narration.
Its data type can be set to text type with field size set to characters; Required to No; Allow Zero Length to Yes and Indexed to No . If the narrations are very large beyond characters, its data type can be set to Memo so as to accommodate the narrations up to , characters, almost equal to pages. PrepBy : This column is meant to store the identity of an employee who has prepared the voucher. EmpId as defined and described in schema of Employees table identifies the employee.