Work Request Locations
Field Name |
Caption |
Mask |
Description |
Field Type |
QL_ADR_APT |
|
25x |
Apartment/Suite |
Text |
QL_ADR_B2 |
|
8x |
Street Post Building No |
Text |
QL_ADR_B22 |
|
8x |
Street Post Building No 2 |
Text |
QL_ADR_BDG |
|
|
Address : Building Number |
Long Integer |
QL_ADR_DIR |
|
2x |
Street Direction |
Text |
QL_ADR_PT |
|
5x |
Street Prefix Type |
Text |
QL_ADR_SFX |
|
5x |
Street Suffix |
Text |
QL_ADR_STR |
|
50x |
Street Name |
Text |
QL_ADR_TY |
|
4x |
Street Type |
Text |
QL_ADR2_PT |
|
5x |
Street 2 Prefix Type |
Text |
QL_ADRBDG2 |
|
|
Address - Building Number |
Long Integer |
QL_ADRDIR2 |
|
2x |
Street Direction 2 |
Text |
QL_ADRSFX2 |
|
5x |
Street Suffix 2 |
Text |
QL_ADRSTR2 |
|
50x |
Street Name 2 |
Text |
QL_ADRTY2 |
|
4x |
Street Type 2 |
Text |
QL_BLDG_CD |
|
|
Building Type |
Integer |
QL_BLDG_TY |
|
25x |
Building Type Text |
Text |
QL_CITY |
|
25x |
City |
Text |
QL_COUNTRY |
|
15x |
Req Country |
Text |
QL_CRT_BY |
|
25x |
Created By |
Text |
QL_CRT_DTTM |
|
|
Creation Date Time |
Date/Time |
QL_DOC_FLG |
|
|
Doc Available |
Boolean |
QL_GENLOC |
|
200x |
General Location |
Text |
QL_ID |
|
|
Auto Number |
Long Integer |
QL_LOCNO |
|
|
Location No |
Integer |
QL_MOD_BY |
|
25x |
Modified By |
Text |
QL_MOD_DT |
|
|
Date Modified |
Date/Time |
QL_MOD_TM |
|
|
Modified Time |
Date/Time |
QL_PARCEL |
|
40x |
Parcel |
Text |
QL_POSTAL |
|
15x |
Zip Code |
Text |
QL_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
QL_RQ_ID |
|
|
Long Integer |
|
QL_STATE |
|
25x |
State |
Text |
QL_TBCOOR |
|
30x |
TB Coordinates |
Text |
QL_TBPAGE |
|
30x |
TB Page |
Text |
QL_TBYEAR |
|
30x |
TB Year |
Text |
QL_X_COORD |
|
|
X Coordinate |
Double |
QL_Y_COORD |
|
|
Y Coordinate |
Double |