Architect/Engineer Setup
Field Name |
Caption |
Mask |
Description |
Field Type |
AE_ACT_FLG |
Active Arch/Eng |
|
Active Contractor |
Boolean |
AE_ADDRES1 |
Address |
50x |
Address |
Text |
AE_ADDRES2 |
Address 2 |
50x |
Address 2 |
Text |
AE_CITY |
City |
100x |
City |
Text |
AE_COMMENT1 |
Long Note |
|
Long Note |
Memo |
AE_CONT_CD |
Arch/Eng |
10x |
Contractor |
Text |
AE_CONT_TY |
Arch/Eng Name |
40x |
Contractor Name |
Text |
AE_CONTACT |
Contact |
30x |
Contact |
Text |
AE_CRT_BY |
Created By |
25x |
Created By |
Text |
AE_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
AE_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
AE_EMAIL |
Email Address |
150x |
Email Address |
Text |
AE_FAX_PHN |
Fax Phone |
25x |
Fax Phone |
Text |
AE_HM_PHN |
Home Phone |
25x |
Home Phone |
Text |
AE_ID |
Arch/Engineer Rec # |
nnnnnnnn |
AutoID Number |
Long Integer |
AE_LICENSENO |
License Number |
25x |
License Number |
Text |
AE_MOB_PHN |
Mobile Phone |
25x |
Mobile Phone |
Text |
AE_MOD_BY |
Last Modified By |
25x |
Modified By |
Text |
AE_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
AE_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
AE_PAGER |
Pager |
25x |
Pager |
Text |
AE_PLC_FLG |
PLC Flag |
|
Permit Licensing Code Enforcement Flag |
Boolean |
AE_POSTAL |
Zip Code |
15x |
Zip Code |
Text |
AE_PROJECT |
Project |
40x |
Project |
Text |
AE_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
AE_STAT_CD |
Arch/Eng Status |
nnn |
Contractor Status |
Integer |
AE_STAT_TY |
Arch/Eng Status Text |
25x |
Contractor Status Txt |
Text |
AE_STATE |
State |
25x |
State |
Text |
AE_UNIT_C |
Unit Cost |
nnnnn.nnn |
Unit Cost |
Double |
AE_UOM_CD |
Unit of Measure |
5x |
Unit of Measure |
Text |
AE_UOM_TY |
Unit of Measure Text |
25x |
Unit of Measure Text |
Text |
AE_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
AE_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
AE_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
AE_USER13 |
User 13 |
|
User 13 |
Boolean |
AE_USER14 |
User 14 |
|
User 14 |
Boolean |
AE_USER15 |
User 15 |
|
User 15 |
Boolean |
AE_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
AE_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
AE_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
AE_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
AE_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
AE_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
AE_USER4 |
User 4 |
30x |
User 4 |
Text |
AE_USER5 |
User 5 |
30x |
User 5 |
Text |
AE_USER6 |
User 6 |
30x |
User 6 |
Text |
AE_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
AE_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
AE_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |
AE_WEB |
Web Site |
30x |
Web Site |
Text |
AE_WK_PHN |
Work Phone |
25x |
Work Phone |
Text |