Table A.20. The Properties of Each Field Included in the tblCompanyInfo Table
|
| SetupID | Number (Long) |
| AllowZeroLength | False |
| Attributes | Fixed size, auto-increment |
| Caption | SetupID |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| OrdinalPosition | 0 |
| Required | False |
| SourceField | SetupID |
| SourceTable | tblCompanyInfo |
| CompanyName | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| Caption | Company Name |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DisplayControl | Text Box |
| OrdinalPosition | 1 |
| Required | False |
| SourceField | CompanyName |
| SourceTable | tblCompanyInfo |
| Address | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DisplayControl | Text Box |
| OrdinalPosition | 2 |
| Required | False |
| SourceField | Address |
| SourceTable | tblCompanyInfo |
| City | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| CollatingOrder | General |
| Column Hidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DisplayControl | Text Box |
| OrdinalPosition | 3 |
| Required | False |
| SourceField | City |
| SourceTable | tblCompanyInfo |
| StateProvince | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| Caption | State/Province |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DisplayControl | Text Box |
| OrdinalPosition | 4 |
| Required | False |
| SourceField | StateProvince |
| SourceTable | tblCompanyInfo |
| PostalCode | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| Caption | Postal Code |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DisplayControl | Text Box |
| InputMask | 00000\-9999 |
| OrdinalPosition | 5 |
| Required | False |
| SourceField | PostalCode |
| SourceTable | tblCompanyInfo |
| Country | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DisplayControl | Text Box |
| OrdinalPosition | 6 |
| Required | False |
| SourceField | Country |
| SourceTable | tblCompanyInfo |
| PhoneNumber | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| Caption | Phone Number |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DisplayControl | Text Box |
| InputMask | !\(999") "000\-0000 |
| OrdinalPosition | 7 |
| Required | False |
| SourceField | PhoneNumber |
| SourceTable | tblCompanyInfo |
| FaxNumber | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| Caption | Fax Number |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DisplayControl | Text Box |
| InputMask | !\(999") "000\-0000 |
| OrdinalPosition | 8 |
| Required | False |
| SourceField | FaxNumber |
| SourceTable | tblCompanyInfo |
| DefaultPaymentTerms | Text |
| AllowZeroLength | False |
| Attributes | Variable length |
| Caption | Default Payment Terms |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| DisplayControl | Text Box |
| OrdinalPosition | 9 |
| Required | False |
| SourceField | DefaultPaymentTerms |
| SourceTable | tblCompanyInfo |
| DefaultInvoiceDescription | Memo |
| AllowZeroLength | False |
| Attributes | Variable length |
| Caption | Default Invoice Description |
| CollatingOrder | General |
| ColumnHidden | False |
| ColumnOrder | Default |
| ColumnWidth | Default |
| OrdinalPosition | 10 |
| Required | False |
| SourceField | DefaultInvoiceDescription |
| SourceTable | tblCompanyInfo |
لطفا منتظر باشید ...
