PM
ProjectBalanceValidationProcess.PMTranReversal
PX.Objects.PM98 of 98 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
TranID | bigint | PM Tran. | - | |
Description:No description available | ||||
AccountGroupID | int | Account Group | PMAccountGroup | |
Description:No description available | ||||
AccountID | int | Debit Account | Account | |
Description:No description available | ||||
Allocated | bit | Allocated | - | |
Description:No description available | ||||
AllocationID | nvarchar(15) | AllocationID | - | |
Description:No description available | ||||
Amount | decimal | - | ||
Description:No description available | ||||
ARRefNbr | nvarchar(15) | AR Reference Nbr. | ARInvoice | |
Description:No description available | ||||
ARTranType | char(3) | - | ||
Description:No description available | ||||
BAccountID | int | Customer/Vendor | BAccount | |
Description:No description available | ||||
BaseCuryInfoID | bigint | - | ||
Description:No description available | ||||
BaseCuryRateNonexistent in DB | decimal | Base Currency Rate | - | |
Description:No description available | ||||
BaseTypeNonexistent in DB | unspecified | - | ||
Description:No description available | ||||
BatchNbr | nvarchar(15) | GL Batch Nbr. | Batch | |
Description:No description available | ||||
Billable | bit | Billable | - | |
Description:No description available | ||||
BillableQty | decimal | Billable Quantity | - | |
Description:No description available | ||||
Billed | bit | Billed | - | |
Description:No description available | ||||
BilledDate | datetime2 | Billed Date | - | |
Description:No description available | ||||
BillingID | nvarchar(15) | - | ||
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CaseCD | nvarchar(15) | Case ID | CRCase | |
Description:No description available | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:No description available | ||||
CreatedByCurrentAllocationNonexistent in DB | bit | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
Date | datetime2 | Date | - | |
Description:No description available | ||||
Description | nvarchar(256) | Description | - | |
Description:No description available | ||||
DuplicateOfTranIDObsolete | bigint | - | ||
Description:No description available | ||||
EarningType | nvarchar(15) | Earning Type | EPEarningType | |
Description:No description available | ||||
EndDate | datetime2 | End Date | - | |
Description:No description available | ||||
ExcludedFromAllocation | bit | Excluded from Allocation | - | |
Description:No description available | ||||
ExcludedFromBalance | bit | Excluded from Balance | - | |
Description:No description available | ||||
ExcludedFromBilling | bit | Excluded from Billing | - | |
Description:No description available | ||||
ExcludedFromBillingReason | nvarchar(50) | Excluded from Billing Reason | - | |
Description:No description available | ||||
ExtRefNbr | nvarchar(30) | External Ref. Nbr. | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Fin. Period | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InvoicedAmount | decimal | - | ||
Description:No description available | ||||
InvoicedDescriptionNonexistent in DB | nvarchar(255) | - | ||
Description:No description available | ||||
InvoicedQty | decimal | Billed Quantity | - | |
Description:No description available | ||||
IsFreeNonexistent in DBObsolete | bit | - | ||
Description:No description available | ||||
IsNonGL | bit | - | ||
Description:No description available | ||||
IsQtyOnly | bit | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LocationID | int | Location | Location | |
Description:No description available | ||||
MigrationOffsetAccountGroupID | int | PMAccountGroup | ||
Description:No description available | ||||
NonProjectNonexistent in DB | unspecified | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OffsetAccountGroupID | int | Credit Account Group | PMAccountGroup | |
Description:No description available | ||||
OffsetAccountID | int | Credit Account | Account | |
Description:No description available | ||||
OffsetSubID | int | Credit Subaccount | Sub | |
Description:No description available | ||||
OrigAccountGroupID | int | - | ||
Description:No description available | ||||
OrigLineNbr | int | OrigLineNbr | - | |
Description:No description available | ||||
OrigModule | char(2) | OrigModule | - | |
Description:No description available | ||||
OrigProjectID | int | - | ||
Description:No description available | ||||
OrigRefID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigRefNbr | nvarchar(15) | OrigRefNbr | - | |
Description:No description available | ||||
OrigTaskID | int | - | ||
Description:No description available | ||||
OrigTranID | bigint | - | ||
Description:No description available | ||||
OrigTranType | char(3) | OrigTranType | - | |
Description:No description available | ||||
OvertimeMultiplier | decimal | Multiplier | - | |
Description:No description available | ||||
PrefixNonexistent in DBObsolete | nvarchar(255) | - | ||
Description:No description available | ||||
ProformaLineNbr | int | - | ||
Description:No description available | ||||
ProformaRefNbr | nvarchar(15) | Pro Forma Ref. Nbr. | - | |
Description:No description available | ||||
ProjectCuryAmount | decimal | Project Currency Amount | - | |
Description:No description available | ||||
ProjectCuryIDNonexistent in DB | nvarchar(5) | Project Currency | - | |
Description:No description available | ||||
ProjectCuryInfoID | bigint | - | ||
Description:No description available | ||||
ProjectCuryInvoicedAmount | decimal | Billed Amount | - | |
Description:No description available | ||||
ProjectCuryRateNonexistent in DB | decimal | Project Currency Rate | - | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
ProportionNonexistent in DBObsolete | decimal | - | ||
Description:No description available | ||||
Qty | decimal | Quantity | - | |
Description:No description available | ||||
RefLineNbr | int | - | ||
Description:No description available | ||||
RefNbr | nvarchar(15) | Ref. Number | PMRegister | |
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
RemainderOfTranID | bigint | - | ||
Description:No description available | ||||
ResourceID | int | Employee | EPEmployee | |
Description:No description available | ||||
Reverse | varchar(1) | Reverse | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SkipNonexistent in DBObsolete | bit | Skip | - | |
Description:No description available | ||||
StartDate | datetime2 | Start Date | - | |
Description:No description available | ||||
SubID | int | Debit Subaccount | Sub | |
Description:No description available | ||||
TaskID | int | Project Task | PMTask | |
Description:No description available | ||||
TranCuryAmount | decimal | Amount | - | |
Description:No description available | ||||
TranCuryAmountCopyNonexistent in DB | decimal | - | ||
Description:No description available | ||||
TranCuryID | nvarchar(5) | Currency | CurrencyList | |
Description:No description available | ||||
TranCuryUnitRate | decimal | Unit Rate | - | |
Description:No description available | ||||
TranDate | datetime2 | - | ||
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
TranType | char(2) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnionID | nvarchar(15) | Union Local | PMUnion | |
Description:No description available | ||||
UnitRate | decimal | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UseBillableQty | bit | Use Billable Quantity in Amount Formula | - | |
Description:No description available | ||||
WorkCodeID | nvarchar(15) | WCC Code | PMWorkCode | |
Description:No description available | ||||