Views [dbo].[StatementDetailDistCustomer_XLedger]
BUILD09 > MoversSuite2 > Views > dbo.StatementDetailDistCustomer_XLedger
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created7:47:18 PM Saturday, February 7, 2026
Last Modified7:48:55 PM Saturday, February 7, 2026
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_Legacy if that is active.
*/
create view [dbo].[StatementDetailDistCustomer_XLedger]
/*(
    -- Join to CustomerInformation_Synonym.CustomerJoinField
    CustomerJoinField
)*/
as
select
    CustomerJoinField = StatementDetailDist.AccountingCustomerFid,
    StatementDetailDist.*
from StatementDetailDist
GO
GRANT SELECT ON  [dbo].[StatementDetailDistCustomer_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[StatementDetailDistCustomer_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[StatementDetailDistCustomer_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[StatementDetailDistCustomer_XLedger] TO [MssExec]
GO
Uses
Created 09 February 2026 07:28
Copyright  2026 - All Rights Reserved