home Java Script MS Access Perl HTML Delphi C ++ Visual Basic Java CGIPerl MS Excel Front Page 98 Windows 98 Ms Word Builder PHP Assembler Link to us Links |
This appendix provides a complete listing of all of the tables included in the Time and Billing application. Each table includes the following:
Field Name |
Type |
Size (Bytes) |
ClientID |
Number (Long) |
4 |
CompanyName |
Text |
50 |
Address |
Text |
255 |
City |
Text |
30 |
StateProvince |
Text |
20 |
PostalCode |
Text |
20 |
Country |
Text |
20 |
ContactFirstName |
Text |
30 |
ContactLastName |
Text |
50 |
ContactTitle |
Text |
50 |
OfficePhone |
Text |
30 |
Fax |
Text |
30 |
Cellular |
Text |
30 |
Home |
Text |
30 |
EMailAddress |
Text |
30 |
ReferredBy |
Text |
30 |
AssociatedWith |
Text |
30 |
IntroDate |
Date/Time |
8 |
DefaultRate |
Currency |
8 |
Notes |
Memo |
(Varies) |
Property |
Value |
ClientID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size, Auto-Increment |
Caption: |
Client ID |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Ordinal Position: |
0 |
Required: |
False |
Source Field: |
ClientID |
Source Table: |
tblClients |
CompanyName |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Company Name |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
1 |
Required: |
True |
Source Field: |
CompanyName |
Source Table: |
tblClients |
Address |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
2 |
Required: |
False |
Source Field: |
Address |
Source Table: |
tblClients |
City |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
3 |
Required: |
False |
Source Field: |
City |
Source Table: |
tblClients |
StateProvince |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
State/Province |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Default Value: |
"CA" |
Display Control: |
Text Box |
Ordinal Position: |
4 |
Required: |
False |
Source Field: |
StateProvince |
Source Table: |
tblClients |
PostalCode |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Postal Code |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
5 |
Required: |
False |
Source Field: |
PostalCode |
Source Table: |
tblClients |
Country |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
6 |
Required: |
False |
Source Field: |
Country |
Source Table: |
tblClients |
ContactFirstName |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Contact First Name |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
7 |
Required: |
False |
Source Field: |
ContactFirstName |
Source Table: |
tblClients |
ContactLastName |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Contact Last Name |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
8 |
Required: |
False |
Source Field: |
ContactLastName |
Source Table: |
tblClients |
ContactTitle |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Contact Title |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
9 |
Required: |
False |
Source Field: |
ContactTitle |
Source Table: |
tblClients |
OfficePhone |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Office Phone |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Input Mask: |
!\(999\)000\-0000 |
Ordinal Position: |
10 |
Required: |
False |
Source Field: |
OfficePhone |
Source Table: |
tblClients |
Fax |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Input Mask: |
!\(999\)000\-0000 |
Ordinal Position: |
11 |
Required: |
False |
Source Field: |
Fax |
Source Table: |
tblClients |
Cellular |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Input Mask: |
!\(999\)000\-0000 |
Ordinal Position: |
12 |
Required: |
False |
Source Field: |
Cellular |
Source Table: |
tblClients |
Home |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Input Mask: |
!\(999\)000\-0000 |
Ordinal Position: |
13 |
Required: |
False |
Source Field: |
Home |
Source Table: |
tblClients |
EMailAddress |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
E-Mail Address |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
14 |
Required: |
False |
Source Field: |
EMailAddress |
Source Table: |
tblClients |
ReferredBy |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Referred By |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
15 |
Required: |
False |
Source Field: |
ReferredBy |
Source Table: |
tblClients |
AssociatedWith |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Associated With |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
16 |
Required: |
False |
Source Field: |
AssociatedWith |
Source Table: |
tblClients |
IntroDate |
Date/Time |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
Intro Date |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Default Value: |
=Date() |
Ordinal Position: |
17 |
Required: |
True |
Source Field: |
IntroDate |
Source Table: |
tblClients |
Validation Rule: |
<=Date() |
Validation Text: |
Date Entered Must Be On Or Before Today |
DefaultRate |
Currency |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
Default Rate |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Decimal Places: |
255 |
Default Value: |
125 |
Format: |
Currency |
Ordinal Position: |
18 |
Required: |
False |
Source Field: |
DefaultRate |
Source Table: |
tblClients |
Validation Rule: |
Between 75 And 150 |
Validation Text: |
Rate Must Be Between 75 and 150 |
Notes |
Memo |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Ordinal Position: |
19 |
Required: |
False |
Source Field: |
Notes |
Source Table: |
tblClients |
Field Name |
Type |
Size (Bytes) |
SetupID |
Number (Long) |
4 |
CompanyName |
Text |
50 |
Address |
Text |
255 |
City |
Text |
50 |
StateProvince |
Text |
20 |
PostalCode |
Text |
20 |
Country |
Text |
50 |
PhoneNumber |
Text |
30 |
FaxNumber |
Text |
30 |
DefaultPaymentTerms |
Text |
255 |
DefaultInvoiceDescription |
Memo |
(varies) |
Property |
Value |
SetupID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size, Auto-Increment |
Caption: |
SetupID |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Ordinal Position: |
0 |
Required: |
False |
Source Field: |
SetupID |
Source Table: |
tblCompanyInfo |
CompanyName |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Company Name |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
1 |
Required: |
False |
Source Field: |
CompanyName |
Source Table: |
tblCompanyInfo |
Address |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
2 |
Required: |
False |
Source Field: |
Address |
Source Table: |
tblCompanyInfo |
City |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
3 |
Required: |
False |
Source Field: |
City |
Source Table: |
tblCompanyInfo |
StateProvince |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
State/Province |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
4 |
Required: |
False |
Source Field: |
StateProvince |
Source Table: |
tblCompanyInfo |
PostalCode |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Postal Code |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Input Mask: |
00000\-9999 |
Ordinal Position: |
5 |
Required: |
False |
Source Field: |
PostalCode |
Source Table: |
tblCompanyInfo |
Country |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
6 |
Required: |
False |
Source Field: |
Country |
Source Table: |
tblCompanyInfo |
PhoneNumber |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Phone Number |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Input Mask: |
!\(999") "000\-0000 |
Ordinal Position: |
7 |
Required: |
False |
Source Field: |
PhoneNumber |
Source Table: |
tblCompanyInfo |
FaxNumber |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Fax Number |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Input Mask: |
!\(999") "000\-0000 |
Ordinal Position: |
8 |
Required: |
False |
Source Field: |
FaxNumber |
Source Table: |
tblCompanyInfo |
DefaultPaymentTerms |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Default Payment Terms |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
9 |
Required: |
False |
Source Field: |
DefaultPaymentTerms |
Source Table: |
tblCompanyInfo |
DefaultInvoiceDescription |
Memo |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Default Invoice Description |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Ordinal Position: |
10 |
Required: |
False |
Source Field: |
DefaultInvoiceDescription |
Source Table: |
tblCompanyInfo |
Field Name |
Type |
Size (Bytes) |
EmployeeID |
Number (Long) |
4 |
FirstName |
Text |
50 |
LastName |
Text |
50 |
Title |
Text |
50 |
EmailName |
Text |
50 |
Extension |
Text |
30 |
Address |
Text |
255 |
City |
Text |
50 |
StateOrProvince |
Text |
20 |
PostalCode |
Text |
20 |
Country |
Text |
50 |
HomePhone |
Text |
30 |
WorkPhone |
Text |
30 |
BillingRate |
Currency |
8 |
Property |
Value |
EmployeeID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size, Auto-Increment |
Caption: |
Employee ID |
Collating Order: |
General |
Ordinal Position: |
0 |
Required: |
False |
Source Field: |
EmployeeID |
Source Table: |
tblEmployees |
FirstName |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
First Name |
Collating Order: |
General |
Ordinal Position: |
1 |
Required: |
False |
Source Field: |
FirstName |
Source Table: |
tblEmployees |
LastName |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Last Name |
Collating Order: |
General |
Ordinal Position: |
2 |
Required: |
False |
Source Field: |
LastName |
Source Table: |
tblEmployees |
Title |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Collating Order: |
General |
Ordinal Position: |
3 |
Required: |
False |
Source Field: |
Title |
Source Table: |
tblEmployees |
EmailName |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Email Name |
Collating Order: |
General |
Ordinal Position: |
4 |
Required: |
False |
Source Field: |
EmailName |
Source Table: |
tblEmployees |
Extension |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Collating Order: |
General |
Ordinal Position: |
5 |
Required: |
False |
Source Field: |
Extension |
Source Table: |
tblEmployees |
Address |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Collating Order: |
General |
Ordinal Position: |
6 |
Required: |
False |
Source Field: |
Address |
Source Table: |
tblEmployees |
City |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Collating Order: |
General |
Ordinal Position: |
7 |
Required: |
False |
Source Field: |
City |
Source Table: |
tblEmployees |
StateOrProvince |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
State/Province |
Collating Order: |
General |
Ordinal Position: |
8 |
Required: |
False |
Source Field: |
StateOrProvince |
Source Table: |
tblEmployees |
PostalCode |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Postal Code |
Collating Order: |
General |
Input Mask: |
00000-9999 |
Ordinal Position: |
9 |
Required: |
False |
Source Field: |
PostalCode |
Source Table: |
tblEmployees |
Country |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Collating Order: |
General |
Ordinal Position: |
10 |
Required: |
False |
Source Field: |
Country |
Source Table: |
tblEmployees |
HomePhone |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Home Phone |
Collating Order: |
General |
Input Mask: |
!(999) 000-0000 |
Ordinal Position: |
11 |
Required: |
False |
Source Field: |
HomePhone |
Source Table: |
tblEmployees |
WorkPhone |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Work Phone |
Collating Order: |
General |
Input Mask: |
!(999) 000-0000 |
Ordinal Position: |
12 |
Required: |
False |
Source Field: |
WorkPhone |
Source Table: |
tblEmployees |
BillingRate |
Currency |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
Billing Rate |
Collating Order: |
General |
Decimal Places: |
2 |
Format: |
Currency |
Ordinal Position: |
13 |
Required: |
False |
Source Field: |
BillingRate |
Source Table: |
tblEmployees |
Field Name |
Type |
Size (Bytes) |
ErrorSeq |
Number (Long) |
4 |
ErrorDate |
Date/Time |
8 |
ErrorTime |
Date/Time |
8 |
UserName |
Text |
30 |
ErrorNum |
Number (Integer) |
2 |
ErrorString |
Text |
30 |
Module |
Text |
50 |
Routine |
Text |
50 |
Property |
Value |
ErrorSeq |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size, Auto-Increment |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Description: |
Unique Identifier for the Error |
Ordinal Position: |
0 |
Required: |
False |
Source Field: |
ErrorSeq |
Source Table: |
tblErrorLog |
ErrorDate |
Date/Time |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Description: |
Date that the Error Occurred |
Format: |
Medium Date |
Ordinal Position: |
1 |
Required: |
False |
Source Field: |
ErrorDate |
Source Table: |
tblErrorLog |
ErrorTime |
Date/Time |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Description: |
Time that the Error Occurred |
Format: |
Long Time |
Ordinal Position: |
2 |
Required: |
False |
Source Field: |
ErrorTime |
Source Table: |
tblErrorLog |
UserName |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Description: |
Name of the User |
Display Control: |
Text Box |
Ordinal Position: |
3 |
Required: |
False |
Source Field: |
UserName |
Source Table: |
tblErrorLog |
ErrorNum |
Number (Integer) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Decimal Places: |
255 |
Default Value: |
0 |
Description: |
VBA Error Code |
Display Control: |
Text Box |
Ordinal Position: |
4 |
Required: |
False |
Source Field: |
ErrorNum |
Source Table: |
tblErrorLog |
ErrorString |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Description: |
VBA Error Description |
Display Control: |
Text Box |
Ordinal Position: |
5 |
Required: |
False |
Source Field: |
ErrorString |
Source Table: |
tblErrorLog |
Module |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Description: |
Module in Which the Error Occurred |
Display Control: |
Text Box |
Ordinal Position: |
6 |
Required: |
False |
Source Field: |
Module |
Source Table: |
tblErrorLog |
Routine |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Description: |
Routine in Which the Error Occurred |
Display Control: |
Text Box |
Ordinal Position: |
7 |
Required: |
False |
Source Field: |
Routine |
Source Table: |
tblErrorLog |
Field Name |
Type |
Size (Bytes) |
ErrorNum |
Number (Long) |
4 |
Response |
Number (Long) |
4 |
Property |
Value |
ErrorNum |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Decimal Places: |
255 |
Default Value: |
0 |
Description: |
Number of the Error |
Display Control: |
Text Box |
Ordinal Position: |
0 |
Required: |
False |
Source Field: |
ErrorNum |
Source Table: |
tblErrors |
Response |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Decimal Places: |
255 |
Default Value: |
0 |
Description: |
Action to Take |
Display Control: |
Text Box |
Ordinal Position: |
1 |
Required: |
False |
Source Field: |
Response |
Source Table: |
tblErrors |
Field Name |
Type |
Size (Bytes) |
ExpenseCodeID |
Number (Long) |
4 |
ExpenseCode |
Text |
30 |
Property |
Value |
ExpenseCodeID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size, Auto-Increment |
Caption: |
Expense Code ID |
Collating Order: |
General |
Ordinal Position: |
0 |
Required: |
False |
Source Field: |
ExpenseCodeID |
Source Table: |
tblExpenseCodes |
ExpenseCode |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Expense Code |
Collating Order: |
General |
Ordinal Position: |
1 |
Required: |
False |
Source Field: |
ExpenseCode |
Source Table: |
tblExpenseCodes |
Field Name |
Type |
Size (Bytes) |
PaymentMethodID |
Number (Long) |
4 |
PaymentMethod |
Text |
50 |
CreditCard |
Yes/No |
1 |
Property |
Value |
PaymentMethodID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size, Auto-Increment |
Caption: |
Payment Method ID |
Collating Order: |
General |
Ordinal Position: |
0 |
Required: |
False |
Source Field: |
PaymentMethodID |
Source Table: |
tblPaymentMethods |
PaymentMethod |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Payment Method |
Collating Order: |
General |
Ordinal Position: |
1 |
Required: |
False |
Source Field: |
PaymentMethod |
Source Table: |
tblPaymentMethods |
CreditCard |
Yes/No |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
Credit Card? |
Collating Order: |
General |
Format: |
Yes/No |
Ordinal Position: |
2 |
Required: |
False |
Source Field: |
CreditCard |
Source Table: |
tblPaymentMethods |
Field Name |
Type |
Size (Bytes) |
PaymentID |
Number (Long) |
4 |
ProjectID |
Number (Long) |
4 |
PaymentAmount |
Currency |
8 |
PaymentDate |
Date/Time |
8 |
CreditCardNumber |
Text |
30 |
CardholdersName |
Text |
50 |
CreditCardExpDate |
Date/Time |
8 |
PaymentMethodID |
Number (Long) |
4 |
Property |
Value |
PaymentID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size, Auto-Increment |
Caption: |
Payment ID |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Ordinal Position: |
0 |
Required: |
False |
Source Field: |
PaymentID |
Source Table: |
tblPayments |
ProjectID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
Project ID |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Decimal Places: |
255 |
Display Control: |
Text Box |
Ordinal Position: |
1 |
Required: |
False |
Source Field: |
ProjectID |
Source Table: |
tblPayments |
PaymentAmount |
Currency |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
Payment Amount |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Decimal Places: |
2 |
Format: |
Currency |
Ordinal Position: |
2 |
Required: |
False |
Source Field: |
PaymentAmount |
Source Table: |
tblPayments |
PaymentDate |
Date/Time |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
Payment Date |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Format: |
Short Date |
Input Mask: |
99/99/00 |
Ordinal Position: |
3 |
Required: |
False |
Source Field: |
PaymentDate |
Source Table: |
tblPayments |
CreditCardNumber |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Credit Card # |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
4 |
Required: |
False |
Source Field: |
CreditCardNumber |
Source Table: |
tblPayments |
CardholdersName |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Cardholder Name |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
5 |
Required: |
False |
Source Field: |
CardholdersName |
Source Table: |
tblPayments |
CreditCardExpDate |
Date/Time |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
Card Exp. Date |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Format: |
Short Date |
Input Mask: |
99/99/00 |
Ordinal Position: |
6 |
Required: |
False |
Source Field: |
CreditCardExpDate |
Source Table: |
tblPayments |
PaymentMethodID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Bound Column: |
1 |
Caption: |
Payment Method ID |
Collating Order: |
General |
Column Count: |
3 |
Column Heads: |
False |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Column Widths: |
0;1440;0 |
Decimal Places: |
255 |
Display Control: |
Combo Box |
Limit To List: |
True |
List Rows: |
8 |
List Width: |
1 |
Ordinal Position: |
7 |
Required: |
False |
Row Source Type: |
Table/Query |
Row Source: |
SELECT DISTINCTROW tblPaymentMethods.* FROM tblPaymentMethods ORDER BY tblPaymentMethods.PaymentMethod; |
Source Field: |
PaymentMethodID |
Source Table: |
tblPayments |
Field Name |
Type |
Size (Bytes) |
ProjectID |
Number (Long) |
4 |
ProjectName |
Text |
50 |
ProjectDescription |
Memo |
- |
ClientID |
Number (Long) |
4 |
PurchaseOrderNumber |
Text |
50 |
ProjectTotalEstimate |
Currency |
8 |
EmployeeID |
Number (Long) |
4 |
ProjectBeginDate |
Date/Time |
8 |
ProjectEndDate |
Date/Time |
8 |
Property |
Value |
ProjectID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size, Auto-Increment |
Caption: |
Project ID |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Ordinal Position: |
0 |
Required: |
False |
Source Field: |
ProjectID |
Source Table: |
tblProjects |
ProjectName |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Project Name |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
1 |
Required: |
True |
Source Field: |
ProjectName |
Source Table: |
tblProjects |
ProjectDescription |
Memo |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Project Description |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Ordinal Position: |
2 |
Required: |
False |
Source Field: |
ProjectDescription |
Source Table: |
tblProjects |
ClientID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Bound Column: |
1 |
Caption: |
Client ID |
Collating Order: |
General |
Column Count: |
2 |
Column Heads: |
False |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Column Widths: |
;14400 |
Decimal Places: |
255 |
Default Value: |
0 |
Display Control: |
Combo Box |
Limit To List: |
True |
List Rows: |
8 |
List Width: |
1 |
Ordinal Position: |
3 |
Required: |
True |
Row Source Type: |
Table/Query |
Row Source: |
SELECT DISTINCTROW [tblClients].[ClientID], [tblClients].[CompanyName] FROM [tblClients]; |
Source Field: |
ClientID |
Source Table: |
tblProjects |
PurchaseOrderNumber |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Purchase Order Number |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
4 |
Required: |
False |
Source Field: |
PurchaseOrderNumber |
Source Table: |
tblProjects |
ProjectTotalEstimate |
Currency |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
ProjectTotalEstime |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Decimal Places: |
255 |
Default Value: |
0 |
Format: |
Currency |
Ordinal Position: |
5 |
Required: |
False |
Source Field: |
ProjectTotalEstimate |
Source Table: |
tblProjects |
EmployeeID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
Employee ID |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Decimal Places: |
255 |
Default Value: |
0 |
Display Control: |
Text Box |
Ordinal Position: |
6 |
Required: |
False |
Source Field: |
EmployeeID |
Source Table: |
tblProjects |
ProjectBeginDate |
Date/Time |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
Project Begin Date |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Ordinal Position: |
7 |
Required: |
False |
Source Field: |
ProjectBeginDate |
Source Table: |
tblProjects |
ProjectEndDate |
Date/Time |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
Project End Date |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Ordinal Position: |
8 |
Required: |
False |
Source Field: |
ProjectEndDate |
Source Table: |
tblProjects |
Field Name |
Type |
Size (Bytes) |
TimeCardExpenseID |
Number (Long) |
4 |
TimeCardID |
Number (Long) |
4 |
ExpenseDate |
Date/Time |
8 |
ProjectID |
Number (Long) |
4 |
ExpenseDescription |
Text |
255 |
ExpenseAmount |
Currency |
8 |
ExpenseCodeID |
Number (Long) |
4 |
Property |
Value |
TimeCardExpenseID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size, Auto-Increment |
Caption: |
Time Card Expense ID |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Ordinal Position: |
0 |
Required: |
False |
Source Field: |
TimeCardExpenseID |
Source Table: |
tblTimeCardExpenses |
TimeCardID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
Time Card ID |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Decimal Places: |
255 |
Display Control: |
Text Box |
Ordinal Position: |
1 |
Required: |
False |
Source Field: |
TimeCardID |
Source Table: |
tblTimeCardExpenses |
ExpenseDate |
Date/Time |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
Expense Date |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Format: |
Short Date |
Input Mask: |
99/99/00 |
Ordinal Position: |
2 |
Required: |
False |
Source Field: |
ExpenseDate |
Source Table: |
tblTimeCardExpenses |
ProjectID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Bound Column: |
1 |
Caption: |
Project ID |
Collating Order: |
General |
Column Count: |
3 |
Column Heads: |
False |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Column Widths: |
0;1020;3156 |
Decimal Places: |
255 |
Display Control: |
Combo Box |
Limit To List: |
True |
List Rows: |
8 |
List Width: |
3 |
Ordinal Position: |
3 |
Required: |
False |
Row Source Type: |
Table/Query |
Row Source: |
SELECT DISTINCTROW tblProjects.* FROM tblProjects ORDER BY tblProjects.ProjectName; |
Source Field: |
ProjectID |
Source Table: |
tblTimeCardExpenses |
ExpenseDescription |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Expense Description |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
4 |
Required: |
False |
Source Field: |
ExpenseDescription |
Source Table: |
tblTimeCardExpenses |
ExpenseAmount |
Currency |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
Expense Amount |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Decimal Places: |
2 |
Format: |
Currency |
Ordinal Position: |
5 |
Required: |
False |
Source Field: |
ExpenseAmount |
Source Table: |
tblTimeCardExpenses |
ExpenseCodeID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Bound Column: |
1 |
Caption: |
Expense Code ID |
Collating Order: |
General |
Column Count: |
2 |
Column Heads: |
False |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Column Widths: |
0;2880 |
Decimal Places: |
255 |
Display Control: |
Combo Box |
Limit To List: |
True |
List Rows: |
8 |
List Width: |
2 |
Ordinal Position: |
6 |
Required: |
False |
Row Source Type: |
Table/Query |
Row Source: |
SELECT DISTINCTROW tblExpenseCodes.* FROM tblExpenseCodes ORDER BY tblExpenseCodes.Exp enseCode; |
Source Field: |
ExpenseCodeID |
Source Table: |
tblTimeCardExpenses |
Field Name |
Type |
Size (Bytes) |
TimeCardDetailID |
Number (Long) |
4 |
TimeCardID |
Number (Long) |
4 |
DateWorked |
Date/Time |
8 |
ProjectID |
Number (Long) |
4 |
WorkDescription |
Text |
255 |
BillableHours |
Number (Double) |
8 |
BillingRate |
Currency |
8 |
WorkCodeID |
Number (Long) |
4 |
Property |
Value |
TimeCardDetailID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size, Auto-Increment |
Caption: |
Time Card Detail ID |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Ordinal Position: |
0 |
Required: |
False |
Source Field: |
TimeCardDetailID |
Source Table: |
tblTimeCardHours |
TimeCardID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
Time Card ID |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Decimal Places: |
255 |
Display Control: |
Text Box |
Ordinal Position: |
1 |
Required: |
False |
Source Field: |
TimeCardID |
Source Table: |
tblTimeCardHours |
DateWorked |
Date/Time |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
Date Worked |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Format: |
Short Date |
Input Mask: |
99/99/00 |
Ordinal Position: |
2 |
Required: |
False |
Source Field: |
DateWorked |
Source Table: |
tblTimeCardHours |
ProjectID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Bound Column: |
1 |
Caption: |
Project ID |
Collating Order: |
General |
Column Count: |
3 |
Column Heads: |
False |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Column Widths: |
0;1020;3156 |
Decimal Places: |
255 |
Display Control: |
Combo Box |
Limit To List: |
True |
List Rows: |
8 |
List Width: |
3 |
Ordinal Position: |
3 |
Required: |
False |
Row Source Type: |
Table/Query |
Row Source: |
SELECT DISTINCTROW tblProjects.* FROM tblProjects ORDER BY tblProjects.ProjectName; |
Source Field: |
ProjectID |
Source Table: |
tblTimeCardHours |
WorkDescription |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Work Description |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Display Control: |
Text Box |
Ordinal Position: |
4 |
Required: |
False |
Source Field: |
WorkDescription |
Source Table: |
tblTimeCardHours |
BillableHours |
Number (Double) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
Billable Hours |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Decimal Places: |
255 |
Display Control: |
Text Box |
Ordinal Position: |
5 |
Required: |
False |
Source Field: |
BillableHours |
Source Table: |
tblTimeCardHours |
BillingRate |
Currency |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
Billing Rate |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Decimal Places: |
2 |
Format: |
Currency |
Ordinal Position: |
6 |
Required: |
False |
Source Field: |
BillingRate |
Source Table: |
tblTimeCardHours |
WorkCodeID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Bound Column: |
1 |
Caption: |
Work Code ID |
Collating Order: |
General |
Column Count: |
2 |
Column Heads: |
False |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Column Widths: |
0;2880 |
Decimal Places: |
255 |
Display Control: |
Combo Box |
Limit To List: |
True |
List Rows: |
8 |
List Width: |
2 |
Ordinal Position: |
7 |
Required: |
False |
Row Source Type: |
Table/Query |
Row Source: |
SELECT DISTINCTROW tblWorkCodes.* FROM tblWorkCodes ORDER BY tblWorkCodes.WorkCode; |
Source Field: |
WorkCodeID |
Source Table: |
tblTimeCardHours |
Field Name |
Type |
Size (Bytes) |
TimeCardID |
Number (Long) |
4 |
EmployeeID |
Number (Long) |
4 |
DateEntered |
Date/Time |
8 |
Property |
Value |
TimeCardID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size, Auto-Increment |
Caption: |
Time Card ID |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Ordinal Position: |
0 |
Required: |
False |
Source Field: |
TimeCardID |
Source Table: |
tblTimeCards |
EmployeeID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Bound Column: |
1 |
Caption: |
Employee ID |
Collating Order: |
General |
Column Count: |
3 |
Column Heads: |
False |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Column Widths: |
0;2000;700 |
Decimal Places: |
255 |
Display Control: |
Combo Box |
Limit To List: |
True |
List Rows: |
8 |
List Width: |
2 |
Ordinal Position: |
1 |
Required: |
False |
Row Source Type: |
Table/Query |
Row Source: |
SELECT tblEmployees.EmployeeID, [LastName] & ", " & [FirstName] AS EmployeeName, tblEmployees.BillingRate FROM tblEmployees ORDER BY [LastName] & ", " & [FirstName]; |
Source Field: |
EmployeeID |
Source Table: |
tblTimeCards |
DateEntered |
Date/Time |
Allow Zero Length: |
False |
Attributes: |
Fixed Size |
Caption: |
Date Entered |
Collating Order: |
General |
Column Hidden: |
False |
Column Order: |
Default |
Column Width: |
Default |
Format: |
Short Date |
Input Mask: |
99/99/00 |
Ordinal Position: |
2 |
Required: |
False |
Source Field: |
DateEntered |
Source Table: |
tblTimeCards |
Field Name |
Type |
Size (Bytes) |
WorkCodeID |
Number (Long) |
4 |
WorkCode |
Text |
30 |
Property |
Value |
WorkCodeID |
Number (Long) |
Allow Zero Length: |
False |
Attributes: |
Fixed Size, Auto-Increment |
Caption: |
Work Code ID |
Collating Order: |
General |
Ordinal Position: |
0 |
Required: |
False |
Source Field: |
WorkCodeID |
Source Table: |
tblWorkCodes |
WorkCode |
Text |
Allow Zero Length: |
False |
Attributes: |
Variable Length |
Caption: |
Work Code |
Collating Order: |
General |
Ordinal Position: |
1 |
Required: |
False |
Source Field: |
WorkCode |
Source Table: |
tblWorkCodes |