PP
MPPaymentBatch
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountCD | nvarchar(20) | - | ||
Description:No description available | ||||
AccountDescription | nvarchar(60) | - | ||
Description:No description available | ||||
AccountID | int | - | ||
Description:No description available | ||||
ApprovedByID | uniqueidentifier | - | ||
Description:No description available | ||||
ApprovedByNameNonexistent in DB | string | Approved By | - | |
Description:No description available | ||||
ApprovedDateTime | datetime | Approved Date | - | |
Description:No description available | ||||
AutoApproved | bit | Auto Approved | - | |
Description:No description available | ||||
BatchID | int | Batch ID | - | |
Description:No description available | ||||
BatchNbr | nvarchar(15) | Reference Nbr | - | |
Description:No description available | ||||
BatchNumber | nvarchar(25) | Batch Number | - | |
Description:No description available | ||||
BatchType | nvarchar(25) | Batch Type | - | |
Description:No description available | ||||
BranchCD | nvarchar(30) | Branch | - | |
Description:No description available | ||||
BranchID | int | Branch | - | |
Description:No description available | ||||
CashAccountCD | nvarchar(10) | Cash Account ID | - | |
Description:No description available | ||||
CashAccountDescriptionNonexistent in DB | string | Cash Account | - | |
Description:No description available | ||||
CashAccountID | int | CashAccount | ||
Description:No description available | ||||
CashAccountNumberNonexistent in DB | string | Cash Account No. | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created by | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created date (UTC) | - | |
Description:No description available | ||||
CurrencyCD | nvarchar(5) | Currency | - | |
Description:No description available | ||||
ExportFileName | nvarchar(60) | Exported File Name | - | |
Description:No description available | ||||
ExportedByID | uniqueidentifier | Exported By | - | |
Description:No description available | ||||
ExportedByNameNonexistent in DB | string | Exported By | - | |
Description:No description available | ||||
ExportedDateTime | datetime | Exported Date | - | |
Description:No description available | ||||
GLBatchNbr | nvarchar(15) | GL Batch | Batch | |
Description:No description available | ||||
IRBatchID | int | IR345 Batch ID | - | |
Description:No description available | ||||
IRBatchNbr | nvarchar(25) | Batch Number | - | |
Description:No description available | ||||
IsAUNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsAutoApprovedNonexistent in DB | string | Auto Approved | - | |
Description:No description available | ||||
IsNZNonexistent in DB | bool? | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last modified by | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last modified date | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
PayPeriodEndDate | datetime | Pay period ends | - | |
Description:No description available | ||||
PayPeriodStartDate | datetime | Pay period starts | - | |
Description:No description available | ||||
PayRunCD | nvarchar(10) | Pay run ID | - | |
Description:No description available | ||||
PayRunCompletedByNameNonexistent in DB | string | Created by | - | |
Description:No description available | ||||
PayRunCompletedDateTime | datetime | Created Date | - | |
Description:No description available | ||||
PayRunID | int | Pay run ID | - | |
Description:No description available | ||||
PaymentBatchID | int | Payment Batch ID | - | |
Description:No description available | ||||
PaymentMethodID | nvarchar(10) | Payment Method | - | |
Description:No description available | ||||
PhysicalPayDate | datetime | Physical pay day | - | |
Description:No description available | ||||
Status | nvarchar(25) | Status | - | |
Description:No description available | ||||
SubAccountCD | nvarchar(30) | - | ||
Description:No description available | ||||
SubAccountDescription | nvarchar(255) | - | ||
Description:No description available | ||||
SubAccountID | int | - | ||
Description:No description available | ||||
SuperfundBatchID | int | Superfund Batch ID | - | |
Description:No description available | ||||
SuperfundBatchNbr | nvarchar(25) | Superfund Batch Number | - | |
Description:No description available | ||||
TStamp | timestamp | - | ||
Description:No description available | ||||
TotalAmount | decimal | Total Amount | - | |
Description:No description available | ||||
TranCount | int | Tran Count | - | |
Description:No description available | ||||
TranDateTime | datetime | Tran Date | - | |
Description:No description available | ||||