Table: dbo.AR_Transaction_Item_N_AR_Item
This table stores the connection between an AR Transaction Item and an AR Item. This connect is maintained so that the system knows where specific AR Items are being used. This is in a seperate table to allow either side to be deleted without changing the other side.
Columns
Name | Type | Constraints | Description
ar_transaction_item_KEY | int (4) | NOT NULL | Primary key for this table and FK to the AR Transaction Item table
ar_item_KEY | int (4) | NOT NULL | FK to the AR Item table

Primary key
Name | Columns | Description
PK_AR_Transaction_Item_N_AR_Item$ar_transaction_item_KEY | ar_transaction_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_AR_Transaction_Item_N_AR_Item__AR_Item__ar_item_KEY | ar_item_KEY | AR_Item (ar_item_KEY) |
FK_AR_Transaction_Item_N_AR_Item__AR_Transaction_Item__ar_transaction_item_KEY | ar_transaction_item_KEY | AR_Transaction_Item (ar_transaction_item_KEY) |