Dry Cleaner Database File
Structure for database: C:\CLEANER\CUST.DBF
Number of data records: 1651
Date of last update : 08/31/94
Field Field Name Type Width Dec
1 MOCKNUM Numeric 10
2 TITLE Character 4
3 LAST_NAME Character 15
4 FIRST_NAME Character 15
5 ADDRESS Character 25
6 CITY Character 15
7 STATE Character 5
8 ZIP Character 10
9 ZIP_PLUS Character 4
10 PHONE_HOME Character 14
11 PHONE_WORK Character 14
12 PURCHASES Numeric 9 2
13 BAL_DUE Numeric 8 2
14 TAX_EXEMPT Character 10
15 CHECK_ALLO Character 1
16 TX_EXEMPT2 Character 10
Press any key to continue...
17 TAX_RATE Numeric 7 5
18 TAX_RATE2 Numeric 7 5
19 CARD_NO Character 19
20 CCDATE Date 8
21 DISCOUNT Numeric 7 5
22 LAST_ACTIV Date 8
23 NOTES Character 23
24 GROUP Character 8
** Total ** 257
Structure for database: C:\CLEANER\ADDON.DBF
Number of data records: 5
Date of last update : 08/31/94
Field Field Name Type Width Dec
1 SERVNUM Character 16
2 MEM_VAR Character 8
3 PROMPT Character 10
4 MULTIPLIER Numeric 8 2
5 VALUE Numeric 8 2
** Total ** 51
Structure for database: C:\CLEANER\BPI.DBF
Number of data records: 0
Date of last update : 01/09/94
Field Field Name Type Width Dec
1 PERIOD Character 2
2 DATE Character 8
3 SOURCE Character 8
4 FOLIO Character 2
5 SUBLEDGER Character 8
6 SUBNAME Character 20
7 AUTOREV Character 1
8 REMARK Character 40
9 REFERENCE Character 10
10 GLACCT1 Character 14
11 AMT1 Character 18
12 GLACCT2 Character 14
13 AMT2 Character 18
** Total ** 164
Structure for database: C:\CLEANER\CASH_TRA.DBF
Number of data records: 4118
Date of last update : 08/31/94
Field Field Name Type Width Dec
1 DATE Date 8
2 TIME Character 5
3 AMOUNT Numeric 9 2
4 CLERK Character 10
5 HOW_PAID Character 1
6 INVOICE Character 6
7 AMOUNT1 Numeric 9 2
8 HOW_PAID1 Character 1
9 TOTL Numeric 9 2
10 CUST_NUM Character 6
11 LIST Numeric 9 2
12 AUTH1 Character 8
13 AUTH Character 8
14 CHANGE Numeric 8 2
** Total ** 98
Structure for database: C:\CLEANER\CCDAILY.DBF
Number of data records: 0
Date of last update : 01/09/94
Field Field Name Type Width Dec
1 CUST_NUM Character 6
2 SENT Character 80
3 REC Character 80
4 DATE Date 8
5 TIME Character 8
6 CLERK Character 3
7 AMOUNT Numeric 9 2
8 ACCOUNT Character 24
9 AUTH Character 6
10 TYPE Character 2
11 BATCH_REC Character 80
12 LRC Numeric 3
** Total ** 310
Structure for database: C:\CLEANER\CCHIST.DBF
Number of data records: 11
Date of last update : 01/09/94
Field Field Name Type Width Dec
1 CUST_NUM Character 6
2 SENT Character 80
3 REC Character 80
4 DATE Date 8
5 TIME Character 8
6 CLERK Character 3
7 AMOUNT Numeric 9 2
8 ACCOUNT Character 24
9 AUTH Character 6
10 TYPE Character 2
** Total ** 227
Structure for database: C:\CLEANER\SERVICE.DBF
Number of data records: 126
Date of last update : 09/01/94
Field Field Name Type Width Dec
1 SERVNUM Character 16
2 DESCRIPT Character 30
3 CATEGORY Character 3
4 DEPT Character 10
5 PRICE Numeric 7 2
6 COST Numeric 7 2
7 MTD Numeric 4
8 FIRST Numeric 4
9 SECON Numeric 4
10 THIRD Numeric 4
11 FOURT Numeric 4
12 FIFTH Numeric 4
13 SIXTH Numeric 4
14 SEVEN Numeric 5
15 EIGHT Numeric 5
16 NINTH Numeric 5
Press any key to continue...
17 TENTH Numeric 5
18 ELEVE Numeric 5
19 TWELV Numeric 5
20 YTD Numeric 5
21 PRIORY Numeric 5
22 TAXABLE1 Character 1
23 TAXABLE2 Character 1
24 PRICE2 Numeric 7 2
25 PRICE3 Numeric 7 2
26 PRICE4 Numeric 7 2
27 PRICE5 Numeric 7 2
28 TYPE Character 1
29 DISCLAIM Character 1
30 QTY Numeric 8 2
31 STK_LEVEL Numeric 8 2
32 REORDER_LV Numeric 8 2
33 LAST_COST Numeric 7 2
34 LAST_PURCH Date 8
35 PR_PRICE1 Numeric 7 2
36 PR_PRICE2 Numeric 7 2
37 PR_QTY1 Numeric 3
Press any key to continue...
38 PR_QTY2 Numeric 3
39 PROMOSTART Date 8
40 PROMOEND Date 8
41 QTY_CASE Numeric 4
42 QTY_BRK Numeric 9 2
43 PRICE_QB Numeric 9 2
** Total ** 271
Structure for database: C:\CLEANER\DAILY.DBF
Number of data records: 0
Date of last update : 08/26/94
Field Field Name Type Width Dec
1 DATE Date 8
2 RECEIVE Date 8
3 TIME Character 5
4 SERVNUM Character 16
5 ITEM Character 16
6 DEPT Character 10
7 TYPE Character 1
8 SERVICE Character 40
9 PRICE Numeric 7 2
10 COST Numeric 7 2
11 TAX Numeric 13 6
12 QTY Numeric 8 3
13 INV_NO Character 6
14 CLERK Character 10
15 CUSTOMER Numeric 6
16 TAX2 Numeric 13 6
Press any key to continue...
17 CLAIM_DATE Date 8
18 CLAIM_TIME Character 5
19 WIP_NUMBER Character 6
** Total ** 194
Structure for database: C:\CLEANER\DISCOUNT.DBF
Number of data records: 8
Date of last update : 08/31/94
Field Field Name Type Width Dec
1 DESC Character 30
2 PERC Numeric 9 6
3 FLAT Numeric 8 2
4 COUNTER Numeric 7
** Total ** 55
Structure for database: C:\CLEANER\EASY.DBF
Number of data records: 0
Date of last update : 01/09/94
Field Field Name Type Width Dec
1 E_LINE Character 80
** Total ** 81
Structure for database: C:\CLEANER\EMP_TIME.DBF
Number of data records: 16
Date of last update : 01/09/94
Field Field Name Type Width Dec
1 ID_NO Character 6
2 IN_OUT Character 1
3 TIME Character 5
4 DATE Date 8
** Total ** 21
Structure for database: C:\CLEANER\EOD.DBF
Number of data records: 102
Date of last update : 09/01/94
Field Field Name Type Width Dec
1 DATE Date 8
2 TIME Character 8
3 SALES Numeric 10 2
4 TAXES Numeric 10 2
5 TAXES2 Numeric 10 2
6 CASH Numeric 10 2
7 CHECKS Numeric 10 2
8 MC_VISA Numeric 10 2
9 AM_EXP Numeric 10 2
10 DISCOVER Numeric 10 2
11 CHG_ACCT Numeric 10 2
12 PAY_ACCT Numeric 10 2
13 EXPENSE Numeric 10 2
14 INHOUSE Numeric 10 2
15 COGS Numeric 10 2
16 SERV_INCOM Numeric 10 2
Press any key to continue...
17 PROD_INCOM Numeric 10 2
18 NUM_INV Numeric 3
19 NOTES Character 40
20 INIT Character 20
21 CLOSING_DR Numeric 10 2
** Total ** 240
Structure for database: C:\CLEANER\HELP.DBF
Number of data records: 474
Date of last update : 01/09/94
Field Field Name Type Width Dec
1 PRG Character 8
2 MESSAGE Character 40
** Total ** 49
Structure for database: C:\CLEANER\IIP.DBF
Number of data records: 663
Date of last update : 08/31/94
Field Field Name Type Width Dec
1 INV_NO Character 6
2 SERVNUM Character 16
3 ITEM Character 16
4 SERVICE Character 40
5 TYPE Character 1
6 DEPT Character 10
7 PRICE Numeric 8 2
8 COST Numeric 8 2
9 TAX Numeric 13 6
10 TAX2 Numeric 13 6
11 QTY Numeric 8 3
12 CUSTOMER Numeric 6
13 DATE Date 8
14 PICKUP Date 8
15 RACKNUM Character 6
16 PAID Character 1
Press any key to continue...
** Total ** 169
Structure for database: C:\CLEANER\INVNUM.DBF
Number of data records: 2
Date of last update : 09/02/94
Field Field Name Type Width Dec
1 MOCKNUM Numeric 6
2 PDONE Date 8
3 POUNTER Character 6
4 CUSREG1 Character 60
5 CUSREG2 Character 60
6 CUSREG3 Character 60
7 CUSREG4 Character 60
8 CUSREG5 Character 60
9 INVBATCH Numeric 3
10 INVRNO Numeric 4
11 CUSIIP Numeric 6
12 CUSPO_NO Numeric 6
13 CUSCODE Character 60
** Total ** 400
Structure for database: C:\CLEANER\NOTES.DBF
Number of data records: 1
Date of last update : 01/09/94
Field Field Name Type Width Dec
1 CUST_NUM Numeric 10
2 DATE Date 8
3 NOTE Character 40
** Total ** 59
Structure for database: C:\CLEANER\POSTINGS.DBF
Number of data records: 16
Date of last update : 01/09/94
Field Field Name Type Width Dec
1 VARIABLE Character 12
2 DESCRIP Character 30
3 DR_ACCT_NO Character 10
4 DR_ACCT_NA Character 20
5 CR_ACCT_NO Character 10
6 CR_ACCT_NA Character 20
** Total ** 103
Structure for database: C:\CLEANER\PRINTERS.DBF
Number of data records: 23
Date of last update : 01/09/94
Field Field Name Type Width Dec
1 PRINTNAME Character 30
2 CONDENS Character 30
3 UNCONDENS Character 30
4 EMPHASIZ Character 30
5 UNEMPHASIZ Character 30
** Total ** 151
Structure for database: C:\CLEANER\PSWD.DBF
Number of data records: 3
Date of last update : 08/31/94
Field Field Name Type Width Dec
1 EMPLOYEE Character 10
2 PASSWORD Character 8
3 LEVEL Numeric 2
4 TRIES Numeric 2
** Total ** 23
Structure for database: C:\CLEANER\PURCH_OR.DBF
Number of data records: 0
Date of last update : 08/31/94
Field Field Name Type Width Dec
1 SKU Character 16
2 QTY Numeric 8 2
3 COST Numeric 8 2
4 PO_NUM Character 6
5 QTY_CASE Numeric 7 2
6 DESC Character 30
7 VEND_ID Character 16
8 SITE Character 2
9 PRICE Numeric 8 2
10 BACK Numeric 8 2
** Total ** 110
Structure for database: C:\CLEANER\EMPLOYEE.DBF
Number of data records: 12
Date of last update : 08/31/94
Field Field Name Type Width Dec
1 FIRST_NAME Character 15
2 MIDDLE_INI Character 1
3 LAST_NAME Character 15
4 ID_NO Character 10
5 ADDRESS Character 20
6 CITY Character 15
7 STATE Character 5
8 ZIP Character 10
9 ZIP_PLUS Character 4
10 PHONE_HOME Character 14
11 SOC_SEC_NO Character 11
12 BIRTHDAY Date 8
13 POSITION Character 6
14 US_CITIZEN Character 1
15 DATE_EMPLD Date 8
16 DATE_TERMD Date 8
Press any key to continue...
17 BASE_PAY Numeric 7 2
18 DATA1 Character 40
19 DATA2 Character 40
** Total ** 239
Structure for database: C:\CLEANER\TAX1.DBF
Number of data records: 3
Date of last update : 09/02/94
Field Field Name Type Width Dec
1 AMT Numeric 9 2
2 FLAT Numeric 9 3
3 PERC Numeric 9 6
** Total ** 28
Structure for database: C:\CLEANER\TAX2.DBF
Number of data records: 1
Date of last update : 09/02/94
Field Field Name Type Width Dec
1 AMT Numeric 9 2
2 FLAT Numeric 9 3
3 PERC Numeric 9 6
** Total ** 28
Structure for database: C:\CLEANER\WORK.DBF
Number of data records: 6703
Date of last update : 08/31/94
Field Field Name Type Width Dec
1 DATE Date 8
2 RECEIVE Date 8
3 TIME Character 5
4 SERVNUM Character 16
5 ITEM Character 16
6 TYPE Character 1
7 DEPT Character 10
8 SERVICE Character 40
9 PRICE Numeric 7 2
10 COST Numeric 7 2
11 TAX Numeric 13 6
12 QTY Numeric 8 3
13 INV_NO Character 6
14 CLERK Character 10
15 TITLE Character 4
16 FIRST_NAME Character 15
Press any key to continue...
17 LAST_NAME Character 15
18 ADDRESS Character 25
19 CITY Character 15
20 STATE Character 2
21 ZIP Character 5
22 ZIP_PLUS Character 4
23 CUSTOMER Numeric 6
24 TAX2 Numeric 13 6
25 CLAIM_DATE Date 8
26 CLAIM_TIME Character 5
27 WIP_NUMBER Character 6
** Total ** 279
Structure for database: C:\CLEANER\CASH_TEM.DBF
Number of data records: 0
Date of last update : 08/26/94
Field Field Name Type Width Dec
1 DATE Date 8
2 TIME Character 5
3 AMOUNT Numeric 9 2
4 HOW_PAID Character 1
5 INVOICE Character 6
6 AMOUNT1 Numeric 9 2
7 HOW_PAID1 Character 1
8 TOTL Numeric 9 2
9 CUST_NUM Character 6
10 LIST Numeric 9 2
11 CHANGE Numeric 9 2
12 TAXCOLLECT Numeric 8 2
13 CLERK Character 10
14 AUTH Character 8
15 AUTH1 Character 8
** Total ** 107
Structure for database: C:\CLEANER\EDIT_ENT.DBF
Number of data records: 0
Date of last update : 12/17/93
Field Field Name Type Width Dec
1 DATE Date 8
2 TIME Character 8
3 SERVNUM Character 16
4 ITEM Character 16
5 TYPE Character 1
6 DEPT Character 10
7 SERVICE Character 40
8 PRICE Numeric 8 2
9 OLD_PRICE Numeric 8 2
10 COST Numeric 8 2
11 TAX Numeric 13 6
12 QTY Numeric 8 3
13 INV_NO Character 6
14 CLERK Character 10
15 PICKUP Date 8
16 CUSTOMER Numeric 6
Press any key to continue...
17 TAX2 Numeric 13 6
18 RACKNUM Character 6
19 DISCOUNT Numeric 8 2
20 PAID Character 1
21 FUNC_KEY Character 2
** Total ** 205
Structure for database: C:\CLEANER\SECURE.DBF
Number of data records: 30
Date of last update : 08/31/94
Field Field Name Type Width Dec
1 LEVEL Numeric 2
2 TITLE Character 20
3 OPTION Character 2
** Total ** 25
Structure for database: C:\CLEANER\INSTLOG.DBF
Number of data records: 26
Date of last update : 08/31/94
Field Field Name Type Width Dec
1 DATE Date 8
2 TIME Character 5
3 MODULE Character 20
4 CHG_DESC Character 40
5 OLD_FCOUNT Numeric 7
6 NEW_FCOUNT Numeric 7
7 OLD_FIELD Character 10
8 NEW_FIELD Character 10
9 OLD_TYPE Character 1
10 NEW_TYPE Character 1
11 OLD_LENGTH Numeric 7
12 NEW_LENGTH Numeric 7
13 OLD_DEC Numeric 7
14 NEW_DEC Numeric 7
** Total ** 138
Structure for database: C:\CLEANER\1\TEMP.DBF
Number of data records: 0
Date of last update : 09/01/94
Field Field Name Type Width Dec
1 DATE Date 8
2 RECEIVE Date 8
3 TIME Character 5
4 SERVNUM Character 16
5 ITEM Character 16
6 TYPE Character 1
7 DEPT Character 10
8 SERVICE Character 40
9 PRICE Numeric 8 2
10 COST Numeric 8 2
11 TAX Numeric 13 6
12 QTY Numeric 8 3
13 INV_NO Character 6
14 CLERK Character 10
15 PICKUP Date 8
16 CUSTOMER Numeric 6
Press any key to continue...
17 TAX2 Numeric 13 6
18 RACKNUM Character 6
19 DISCOUNT Numeric 8 2
20 PAID Character 1
21 WIP_NUMBER Character 6
22 CLAIM_DATE Date 8
23 CLAIM_TIME Character 5
24 START_REC Numeric 10
25 END_REC Numeric 10
** Total ** 239
Structure for database: C:\CLEANER\1\TEMP2.DBF
Number of data records: 0
Date of last update : 09/01/94
Field Field Name Type Width Dec
1 DATE Date 8
2 RECEIVE Date 8
3 TIME Character 5
4 SERVNUM Character 16
5 RACKNUM Character 6
6 ITEM Character 16
7 TYPE Character 1
8 SERVICE Character 40
9 PRICE Numeric 8 2
10 COST Numeric 8 2
11 TAX Numeric 13 6
12 QTY Numeric 8 3
13 INV_NO Character 6
14 CLERK Character 6
15 PICKUP Date 8
16 CUSTOMER Numeric 6
Press any key to continue...
17 TAX2 Numeric 13 6
18 START_REC Numeric 10
19 END_REC Numeric 10
** Total ** 197
Structure for database: C:\CLEANER\1\TEDIT.DBF
Number of data records: 0
Date of last update : 09/01/94
Field Field Name Type Width Dec
1 DATE Date 8
2 TIME Character 8
3 SERVNUM Character 16
4 ITEM Character 16
5 TYPE Character 1
6 DEPT Character 10
7 SERVICE Character 40
8 PRICE Numeric 8 2
9 OLD_PRICE Numeric 8 2
10 COST Numeric 8 2
11 TAX Numeric 13 6
12 QTY Numeric 8 3
13 INV_NO Character 6
14 CLERK Character 10
15 PICKUP Date 8
16 CUSTOMER Numeric 6
Press any key to continue...
17 TAX2 Numeric 13 6
18 RACKNUM Character 6
19 DISCOUNT Numeric 8 2
20 PAID Character 1
21 FUNC_KEY Character 2
** Total ** 205
Have a question about point-of-sale hardware or MicroBiz software? Visit the MicroBiz WebBoard.
Click here to print this page
|
