[dbo].[BATProcessVendor

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	7:47:19 PM Saturday, February 7, 2026
Last Modified	7:48:54 PM Saturday, February 7, 2026

Property

Value

ANSI Nulls On

Quoted Identifier On

Created

7:47:19 PM Saturday, February 7, 2026

Last Modified

7:48:54 PM Saturday, February 7, 2026

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
RequestGroupIdentifier
AccountingBankAccountFid

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

RequestGroupIdentifier

AccountingBankAccountFid

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

Type

Action

Owning Principal

Grant

Delete

MssExec

Grant

Insert

MssExec

Grant

Select

MssExec

Grant

Update

MssExec

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