Table: dbo.Enter_AR_Deposit_Option
This table contains options used on the Enter AR Deposit screen.
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLThe client to whom the options pertain. This is also the primary key for this table and a foreign key to the client table.
separate_deposit_detailsbit (1)NOT NULLThis will be set on the Enter AR Deposits screen. If this is true then we want to show the details of an AR deposit in Enter Transactions and Bank Reconciliation, and possibly other areas of the system. If this is false then the deposit amount will be shown in those places in summary form, without extra detail. Showing detail means showing a row for each AR Payment that is linked to the deposit, not showing detail means that the amounts of all AR Payments linked to an AR Deposit are shown together in one row.
Primary key
NameColumnsDescription
PK_Enter_AR_Deposit_Option$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Enter_AR_Deposit_Option__Client__client_KEYclient_KEYClient (client_KEY)

Schema diagram