Views [dbo].[BATProcessCustomer_XLedger]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created6:57:31 AM Friday, September 12, 2025
Last Modified6:57:31 AM Friday, September 12, 2025
Columns
Name
CustomerJoinField
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
/**
* Don't use this view directly but instead use BATProcessCustomer_Synonym.
* BATProcessCustomer_Synonym will either point to this view or to
* BATProcessCustomer_Legacy if that is active.
*/

create view [dbo].[BATProcessCustomer_XLedger]
/*(
    -- Join to CustomerInformation_Synonym.CustomerJoinField
    CustomerJoinField
)*/

as
select
    CustomerJoinField = BATProcess.AccountingCustomerFid,
    BATProcess.*
from BATProcess
GO
GRANT SELECT ON  [dbo].[BATProcessCustomer_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[BATProcessCustomer_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[BATProcessCustomer_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[BATProcessCustomer_XLedger] TO [MssExec]
GO
Uses