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) |