Views [dbo].[PlasticDealCustomer_XLedger]
BUILD09 > MoversSuite2 > Views > dbo.PlasticDealCustomer_XLedger
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
DealID
InstrumentFID
DealType
Description
TransactionCode
ApprovalCode
ProcessorCode
BillingCycle
OriginalAmount
ApprovedAmount
OriginFID
StatementDetailFID
TransactionDate
ResponseCode
ResponseMessage
CscResponseCode
TransactionStatus
SysUserFID
ActivityDate
StorageInvoiceFID
BatchStatusFID
BatchErrorCodeFID
WasReprocessed
WebDealFID
WebTransactionCode
TransactionID
PurchaseOrderNo
HppSessionID
MssTransactionID
CurrencyCode
AuthorizationDate
AuthorizationByFID
AuthorizationAmount
AuthorizationTransId
AuthorizationMssTransID
OrderFID
CustomerNumber
BranchFID
FinalizedDate
FinalizedByFID
AccountingCustomerFid
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
/**
* Don't use this view directly but instead use PlasticDealCustomer_Synonym.
* PlasticDealCustomer_Synonym will either point to this view or to
* PlasticDealCustomer_Legacy if that is active.
*/
create view [dbo].[PlasticDealCustomer_XLedger]
/*(
    -- Join to CustomerInformation_Synonym.CustomerJoinField
    CustomerJoinField
)*/
as
select
    CustomerJoinField = PlasticDeal.AccountingCustomerFid,
    PlasticDeal.*
from PlasticDeal
GO
GRANT SELECT ON  [dbo].[PlasticDealCustomer_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[PlasticDealCustomer_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[PlasticDealCustomer_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[PlasticDealCustomer_XLedger] TO [MssExec]
GO
Uses
Created 12 September 2025 07:19
Copyright  2025 - All Rights Reserved