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
NameTypeConstraintsDescription
ar_transaction_item_KEYint (4)NOT NULLPrimary key for this table and FK to the AR Transaction Item table
ar_item_KEYint (4)NOT NULLFK to the AR Item table
Primary key
NameColumnsDescription
PK_AR_Transaction_Item_N_AR_Item$ar_transaction_item_KEYar_transaction_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_AR_Transaction_Item_N_AR_Item__AR_Item__ar_item_KEYar_item_KEYAR_Item (ar_item_KEY)
FK_AR_Transaction_Item_N_AR_Item__AR_Transaction_Item__ar_transaction_item_KEYar_transaction_item_KEYAR_Transaction_Item (ar_transaction_item_KEY)

Schema diagram