Common - Parcel:Address Linking Table
Field Name |
Default Caption |
Mask |
Description |
Field Type |
PA_AD_ID |
|
nnnnnnn |
Long Integer |
|
PA_CP_ID |
|
nnnnnnn |
Long Integer |
|
PA_CRT_BY |
Created By |
25x |
Created By |
Text |
PA_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
PA_ID |
|
nnnnnnnn |
Auto ID |
Long Integer |
PA_MOD_BY |
|
25x |
Last Modified By: |
Text |
PA_MOD_DT |
|
mm/dd/yyyy |
Last Modified Date: |
Date/Time |
PA_MOD_TM |
|
hh:mm am |
Modified Time |
Date/Time |
PA_ROWVER |
|
mm/dd/yyyy hh:mm am |
Rowversion for optimistic locking |
TimeStamp |
Related Tables
Tables this table links to
Target Table |
Target Field |
Linking Field |
Purpose |
AD_ID |
PA_AD_ID |
The record uses these two fields to specify the address and parcel record that are being linked together. This is a many to many relationship. |
|
CP_ID |
PA_CP_ID |