Views [dbo].[GPWarehouseCustomer_Legacy]
BUILD09 > MoversSuite2 > Views > dbo.GPWarehouseCustomer_Legacy
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created9:18:39 AM Wednesday, October 15, 2025
Last Modified9:18:39 AM Wednesday, October 15, 2025
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
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_XLedger if that is active.
*/
create view [dbo].[GPWarehouseCustomer_Legacy]
/*(
    -- Use this view instead of using GPWarehouse so that you can
    -- Join to CustomerInformation_Synonym.CustomerJoinField
    CustomerJoinField
)*/
as
select
    CustomerJoinField = GPWarehouse.CustomerNumber,
    GPWarehouse.*
from GPWarehouse
GO
GRANT SELECT ON  [dbo].[GPWarehouseCustomer_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[GPWarehouseCustomer_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[GPWarehouseCustomer_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[GPWarehouseCustomer_Legacy] TO [MssExec]
GO
Uses
Used By
Created 15 October 2025 11:23
Copyright  2025 - All Rights Reserved