Tree Plantings
Field Name |
Caption |
Mask |
Description |
Field Type |
TP_COMMON |
Common Name |
75x |
Common Name |
Text |
TP_COST |
Cost |
nnnnnn.nn |
Cost |
Double |
TP_CRT_BY |
Created By |
25x |
Created By |
Text |
TP_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
TP_DESC |
Description |
50x |
Description |
Text |
TP_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
TP_ID |
Plant Rec # |
|
|
Long Integer |
TP_IMG_FLG |
|
|
Image Available |
Boolean |
TP_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
TP_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
TP_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
TP_MOV_FLG |
|
|
Movie Available |
Boolean |
TP_PLANTNO |
Planting # |
nnn |
Plant No |
Integer |
TP_QUANT |
Quantity |
nnnn |
Quantity |
Integer |
TP_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
TP_TR_ID |
Tree Rec # |
|
Long Integer |
|
TP_TZ_ID |
Tree Code Rec # |
|
Long Integer |