Views [dbo].[GPWarehouseCustomer_XLedger]
BUILD09 > MoversSuite2 > Views > dbo.GPWarehouseCustomer_XLedger
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created7:47:33 PM Saturday, February 7, 2026
Last Modified7:48:55 PM Saturday, February 7, 2026
Columns
Name
CustomerJoinField
CustomerNumber
OrderID
Authority
OrderNumber
Salesperson
Shipper
OrderOriginAddress
OrderDestinationAddress
BranchID
InvoiceNumber
InvoiceDate
InvoiceAmount
InvoiceAge
InvoiceCreatedDate
InvoiceCreatedBy
InvoicedHeaderID
DocumentNumber
DocumentDescription
DocumentDate
DueDate
PostDate
JournalDate
DocumentType
OriginalTransactionAmount
CurrentTransactionAmount
DocumentAge
ItemCode
BranchFID
PONumber
GBLNumber
IsFactored
AccountingCustomerFid
AcctTransactionFid
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
/**
* Don't use this view directly but instead use GPWarehouseCustomer_Synonym.
* GPWarehouseCustomer_Synonym will either point to this view or to
* GPWarehouseCustomer_Legacy if that is active.
*/
create view [dbo].[GPWarehouseCustomer_XLedger]
/*(
    -- Use this view instead of using GPWarehouse so that you can
    -- Join to CustomerInformation_Synonym.CustomerJoinField
    CustomerJoinField
)*/
as
select
    CustomerJoinField = GPWarehouse.AccountingCustomerFid,
    GPWarehouse.*
from GPWarehouse
GO
GRANT SELECT ON  [dbo].[GPWarehouseCustomer_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[GPWarehouseCustomer_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[GPWarehouseCustomer_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[GPWarehouseCustomer_XLedger] TO [MssExec]
GO
Uses
Created 09 February 2026 07:28
Copyright  2026 - All Rights Reserved