Common - Link Table for Addresses and Contacts
Field Name |
Caption |
Mask |
Description |
Field Type |
AC_ADDID |
Address Rec # |
nnnnnnnn |
Long Integer |
|
AC_CONTID |
Contact Rec # |
nnnnnnnn |
Long Integer |
|
AC_CRT_BY |
Created By |
25x |
Created By |
Text |
AC_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
AC_ID |
Auto Number |
nnnnnnnn |
AutoID |
Long Integer |
AC_MOD_BY |
Last Modified By |
25x |
Last Modified By: |
Text |
AC_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date: |
Date/Time |
AC_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
AC_ROWVER |
|
mm/dd/yyyy hh:mm am |
Rowversion for optimistic locking |
Date/Time |
Related Tables
Parent tables this table links to
Target Table |
Target Field |
Linking Field |
Purpose |
AD_ID |
AC_ADDID |
The record uses these two fields to specify the address and customer record that are being linked together. This is a many to many relationship. |
|
CT_ID |
AC_CONTID |