Views [dbo].[ARCTaskCustomer_XLedger]
BUILD09 > MoversSuite2 > Views > dbo.ARCTaskCustomer_XLedger
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created9:18:42 AM Wednesday, October 15, 2025
Last Modified9:18:42 AM Wednesday, October 15, 2025
Columns
Name
CustomerJoinField
ARCTaskID
DueDate
AssignedToSysuserFID
TaskDescription
CustomerNumber
OrderNumbers
Invoices
Alerts
IsCompleted
CompletedDate
CompletedBySysuserFID
AccountingCustomerFid
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
/**
* Don't use this view directly but instead use ARCTaskCustomer_Synonym.
* ARCTaskCustomer_Synonym will either point to this view or to
* ARCTaskCustomer_Legacy if that is active.
*/
create view [dbo].[ARCTaskCustomer_XLedger]
/*(
    -- Join to CustomerInformation_Synonym.CustomerJoinField
    CustomerJoinField
)*/
as
select
    CustomerJoinField = ARCTask.AccountingCustomerFid,
    ARCTask.*
from ARCTask
GO
GRANT SELECT ON  [dbo].[ARCTaskCustomer_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[ARCTaskCustomer_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[ARCTaskCustomer_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[ARCTaskCustomer_XLedger] TO [MssExec]
GO
Uses
Created 15 October 2025 11:23
Copyright  2025 - All Rights Reserved