Views [dbo].[StatementDetailDistCustomer_XLedger]
BUILD09 > MoversSuite2 > Views > dbo.StatementDetailDistCustomer_XLedger
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created3:09:12 PM Tuesday, June 24, 2025
Last Modified3:09:12 PM Tuesday, June 24, 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_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 24 June 2025 15:32
Copyright  2025 - All Rights Reserved