Views [dbo].[StatementDetailDistCustomer_Legacy]
BUILD09 > MoversSuite2 > Views > dbo.StatementDetailDistCustomer_Legacy
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created6:57:26 AM Friday, September 12, 2025
Last Modified6:57:26 AM Friday, September 12, 2025
Columns
Name
CustomerJoinField
SDDPriKey
SDPriKey
ANPriKey
OrderControl
Description
Amount
Split
BranchPriKey
OrdPriKey
UnappliedCash
UnappliedAmount
PaymentCodePriKey
Balance
ApplyAmount
AmountRemaining
Adjustment
ApplyCheck
ContestCharge
CustomerNumber
DivisionFID
ClaimFID
UnappliedBranchFID
UnappliedDivisionFID
AccountingCustomerFid
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
/**
* Don't use this view directly but instead use StatementDetailDistCustomer_Synonym.
* StatementDetailDistCustomer_Synonym will either point to this view or to
* StatementDetailDistCustomer_XLedger if that is active.
*/
create view [dbo].[StatementDetailDistCustomer_Legacy]
/*(
    -- Join to CustomerInformation_Synonym.CustomerJoinField
    CustomerJoinField
)*/
as
select
    CustomerJoinField = StatementDetailDist.CustomerNumber,
    StatementDetailDist.*
from StatementDetailDist
GO
GRANT SELECT ON  [dbo].[StatementDetailDistCustomer_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[StatementDetailDistCustomer_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[StatementDetailDistCustomer_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[StatementDetailDistCustomer_Legacy] TO [MssExec]
GO
Uses
Used By
Created 12 September 2025 07:19
Copyright  2025 - All Rights Reserved