Create Database for Salary Slips System

[kapiladinirukshana]

SLIPS INPUT FORMAT

Data Record Layout

Position Length Type Description

01-04 04 N Filler ('0000')
05-08 04 N Destination Bank No.
09-11 03 N Destination Branch NO;
12-23 12 N Destination A/C No;
24-43 20 A Destination A/C Name
44-45 02 N Transaction Code (‘23’)
46-47 02 N Return Code (’00’)
48-48 01 N Filler ('0')
49-54 06 N Filler ('000000')
55-66 12 N Amount
67-69 03 A Filler ('SLR')
70-73 04 N Originating Bank No. ('7010')
74-76 03 N Originating Branch No.
77-88 12 N Originating A/C No.
89-108 20 A Originating A/C Name
109-123 15 A Particulars
124-138 15 A Reference
139-144 06 N Value Date (YYMMDD)
145-150 06 N Filler ('000000')

Font Size – 11
Font Style – Times New Roman

Numeric Field

All numeric fields (Type -N) should be filled with leading zeros.

Amount Field

Last two digits of the amount field is taken as decimals

File Format

File should be in text format.

File Name

File name should not exceed eight characters.


Please help me to create above database

 

[thinking_guy]

Meka salary bank eakata yanawna format eka neda? Emp name, Emp Acc no, Amount wage filed walata Access Db ekak gahapan. Anith filed godwak ewa fixed nisaa query ekak liyanna puluwan. Query eka run karala ena table eke thiyena data Access walin text file ekakata export karanna puluwa.