Table: dbo.GL_Transaction_N_Payable_Transaction
Table for linking the gl transaction table to payable transaction table.
Columns
NameTypeConstraintsDescription
gl_transaction_KEYint (4)NOT NULLFK to gl transaction table and primary key.
payable_transaction_KEYint (4)NOT NULLFK to payable transaction table.
Primary key
NameColumnsDescription
PK_GL_Transaction_N_Payable_Transaction$gl_transaction_KEYgl_transaction_KEY
Unique constraints
NameColumnsDescription
UK_GL_Transaction_N_Payable_Transaction$payable_transaction_KEYpayable_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Transaction_N_Payable_Transaction__GL_Transaction__gl_transaction_KEYgl_transaction_KEYGL_Transaction (gl_transaction_KEY)
FK_GL_Transaction_N_Payable_Transaction__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Transaction (payable_transaction_KEY)

Schema diagram