Views [dbo].[BATProcessVendor_Legacy]
BUILD09 > MoversSuite2 > Views > dbo.BATProcessVendor_Legacy
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created6:57:27 AM Friday, September 12, 2025
Last Modified6:57:27 AM Friday, September 12, 2025
Columns
Name
VendorJoinField
BATProcessPriKey
BATSessionID
PostingDocNumber
GLNumber
OpposingGLNumber
DocumentNumber
VoucherNumber
ApplyToDocument
TransactionType
TransactionAmount
InvoicePayment
InvoicePaymentAccount
DocumentDate
JournalDate
AcctDBName
ShipperName
ItemDescription
CustomerNumber
VendorNumber
PostingUserName
TransactionDate
AccountingPostDate
CustomerName
VendorName
PONumber
VendorInvoiceNumber
ICPriKey
OrdPriKey
BatchNumber
CustomerNumber2
OrderNo
Authority
NANumber
Driver
SalesPerson
ItemCode
Source
SourceRecord
AcctNote
BranchID
InvoiceNumber
InvoiceDate
1099Flag
OnHoldFlag
TempForeignID
StatementHeaderID
AccountingCustomerFid
AccountingVendorFid
XglFid
NominalAccountingAccountFid
OpposingAccountingAccountFid
NominalBranchFid
OpposingBranchFid
NominalDivisionFid
OpposingDivisionFid
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
/**
* Do not use this view directly. Use BATProcessVendor_Synonym instead.
* That synonym should be used to join the BATProcess table to another table when joining on a Vendor identifier.
* That synonym will point to BATProcessVendor_XLedger if XLedger is being used.
* Otherwise, it will point to this view (BATProcessVendor_Legacy).
*/
create view [dbo].[BATProcessVendor_Legacy]
as
select
    VendorJoinField = BATProcess.VendorNumber,
    BATProcess.*
from BATProcess
GO
GRANT SELECT ON  [dbo].[BATProcessVendor_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[BATProcessVendor_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[BATProcessVendor_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[BATProcessVendor_Legacy] TO [MssExec]
GO
Uses
Used By
Created 12 September 2025 07:19
Copyright  2025 - All Rights Reserved