Friends, Now, Provident Fund Department demands data in dbf format and supply the following format of data file. We have tried to resolve the creation of Data in specified format in software mode.
Structure for database: EPF.DBF
Date of last update : 21/04/2011
Field Field Name Type Width Dec Index
1 EST_CODE Numeric 6 N
2 EST_EXTN Character 1 N
3 EMP_NO Numeric 6 N
4 JANEE Numeric 5 N
5 FEBEE Numeric 5 N
6 MAREE Numeric 5 N
7 APREE Numeric 5 N
8 MAYEE Numeric 5 N
9 JUNEE Numeric 5 N
10 JULEE Numeric 5 N
11 AUGEE Numeric 5 N
12 SEPEE Numeric 5 N
13 OCTEE Numeric 5 N
14 NOVEE Numeric 5 N
15 DECEE Numeric 5 N
16 OTHEE Numeric 5 N
17 JANER Numeric 5 N
18 FEBER Numeric 5 N
19 MARER Numeric 5 N
20 APRER Numeric 5 N
21 MAYER Numeric 5 N
22 JUNER Numeric 5 N
23 JULER Numeric 5 N
24 AUGER Numeric 5 N
25 SEPER Numeric 5 N
26 OCTER Numeric 5 N
27 NOVER Numeric 5 N
28 DECER Numeric 5 N
29 OTHER Numeric 5 N
30 WAGE1 Numeric 8 2 N
31 WAGE2 Numeric 8 2 N
32 WAGE3 Numeric 8 2 N
33 WAGE4 Numeric 8 2 N
34 WAGE5 Numeric 8 2 N
35 WAGE6 Numeric 8 2 N
36 WAGE7 Numeric 8 2 N
37 WAGE8 Numeric 8 2 N
38 WAGE9 Numeric 8 2 N
39 WAGE10 Numeric 8 2 N
40 WAGE11 Numeric 8 2 N
41 WAGE12 Numeric 8 2 N
42 WAGE13 Numeric 8 2 N
43 PF1 Numeric 4 N
44 PF2 Numeric 4 N
45 PF3 Numeric 4 N
46 PF4 Numeric 4 N
47 PF5 Numeric 4 N
48 PF6 Numeric 4 N
49 PF7 Numeric 4 N
50 PF8 Numeric 4 N
51 PF9 Numeric 4 N
52 PF10 Numeric 4 N
53 PF11 Numeric 4 N
54 PF12 Numeric 4 N
55 PF13 Numeric 4 N
56 TOTWAGES Numeric 8 N
57 TOTEE Numeric 6 N
58 TOTER Numeric 6 N
59 PFT Numeric 6 N
60 EMP_NAME Character 40 N
** Total ** 366
Installation and use
- Download zip file (1.13 mb) and unzip the folder
- Place in C drive as c:\epf
- Click on epf.exe file
- Enter Data
- Auto Calculated Field, Don't enter Data in Below fields
1) PF1 to PF13
2) TOTWAGES
3) TOTEE
4) TOTER
5) PFT
(Amount will be shown after saving in above fileds) - Shortcut Keys in use
- Ctrl+Enter = Enlarge the screen
Ctrl+W = Save Data
Ctrl+W = Save and Next Screen - After saving entered data can be viewed in disp.txt file available in \epf\disp.prt
Download the Software (Click Here)
No comments:
Post a Comment