PR
PRValidatePaycheckTotals.PREarningDetailExt
PX.Objects.PR52 of 52 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
RecordID | int | - | ||
Description:No description available | ||||
AccountID | int | Account | Account | |
Description:No description available | ||||
AllowCopyNonexistent in DB | bit | AllowCopy | - | |
Description:No description available | ||||
Amount | decimal | Amount | - | |
Description:No description available | ||||
BaseOvertimeRecordID | int | Base RecordID | - | |
Description:No description available | ||||
BasePTORecordID | int | - | ||
Description:No description available | ||||
BatchNbr | nvarchar(15) | Batch Number | PRBatch | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CertifiedJob | bit | Certified Job | - | |
Description:No description available | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
Date | datetime2 | Date | - | |
Description:No description available | ||||
EmployeeAcctCD | nvarchar(MAX) | - | ||
Description:No description available | ||||
EmployeeID | int | Vendor | ||
Description:No description available | ||||
ExcelRecordIDNonexistent in DB | nvarchar(MAX) | Record ID | - | |
Description:No description available | ||||
Hours | decimal | Hours | - | |
Description:No description available | ||||
IsAmountBasedNonexistent in DB | bit | Amount-Based | - | |
Description:No description available | ||||
IsFringeRateEarning | bit | IsFringeRateEarning | - | |
Description:No description available | ||||
IsOvertimeNonexistent in DB | bit | Overtime | - | |
Description:No description available | ||||
IsPayingSettlement | bit | IsPayingSettlement | - | |
Description:No description available | ||||
IsPieceworkNonexistent in DB | bit | Piecework | - | |
Description:No description available | ||||
IsRegularRate | bit | IsRegularRate | - | |
Description:No description available | ||||
IsTimeActivityBillable | bit | - | ||
Description:No description available | ||||
LabourItemID | int | Labor Item | InventoryItem | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LocationID | int | Location | PRLocation | |
Description:No description available | ||||
ManualRate | bit | Manual Rate | - | |
Description:No description available | ||||
PaymentDocType | char(3) | Payment Doc. Type | - | |
Description:No description available | ||||
PaymentRefNbr | nvarchar(15) | Payment Ref. Number | PRPayment | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
ProjectTaskID | int | Project Task | PMTask | |
Description:No description available | ||||
PTODisbursementWithAverageRateNonexistent in DB | bit | - | ||
Description:No description available | ||||
PTODisbursementWithFinancialTransactionNonexistent in DB | bit | - | ||
Description:No description available | ||||
Rate | decimal | Rate | - | |
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
ShiftID | int | Shift Code | EPShiftCode | |
Description:No description available | ||||
SortingRecordIDNonexistent in DB | int | Sorting RecordID | - | |
Description:No description available | ||||
SourceCommnPeriod | nvarchar(6) | Source Commn Period | - | |
Description:No description available | ||||
SourceNoteID | uniqueidentifier | Time Activity | PMTimeActivity | |
Description:No description available | ||||
SourceType | char(3) | Data Source Type | - | |
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
TimeCardMinutes | int | - | ||
Description:No description available | ||||
TStamp | timestamp | - | ||
Description:No description available | ||||
TypeCD | nvarchar(15) | Code | EPEarningType | |
Description:No description available | ||||
UnionID | nvarchar(15) | Union Local | PMUnion | |
Description:No description available | ||||
Units | decimal | Units | - | |
Description:No description available | ||||
UnitType | char(3) | Unit Type | - | |
Description:No description available | ||||
WorkCodeID | nvarchar(15) | WCC Code | PMWorkCode | |
Description:No description available | ||||