PM
PMWipAdjustment
Contains the main properties of a project WIP adjustment transaction. The records of this type are created and edited on the WIP Adjustment (PM305600) form. (which corresponds to the ProjectWipAdjustmentEntry graph).
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
Approved | bit | - | ||
Description:A Boolean value that indicates (if set to true) that the transaction is approved. | ||||
BatchNbr | nvarchar(15) | GL Batch | Batch | |
Description:The number of the Batch that is created when the transaction is released. Corresponds to the Batch.BatchNbr field. | ||||
BranchID | int | Branch | - | |
Description:The identifier of the branch to which the transaction belongs. Corresponds to the Branch.BranchID field. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | CurrencyList | |
Description:The code of the Currency of the transaction. It is set to the base currency of the company by default. Corresponds to the Currency.CuryID field. | ||||
CuryInfoID | bigint | - | ||
Description:The identifier of the CurrencyInfo record associated with the transaction. | ||||
CuryOverbillingAdjustmentAmount | decimal | Overbilling Adjustment | - | |
Description:The sum of the PMWipAdjustmentLine.CuryOverbillingAdjustmentAmount. | ||||
CuryOverbillingAmount | decimal | Overbilling Amount | - | |
Description:The sum of the PMWipAdjustmentLine.CuryOverbillingAmount. | ||||
CuryTotalAdjustmentAmountNonexistent in DB | decimal? | Total Adjustment | - | |
Description:The difference between the PMWipAdjustmentLine.CuryOverbillingAdjustmentAmount and PMWipAdjustmentLine.CuryUnderbillingAdjustmentAmount. | ||||
CuryTotalAmountNonexistent in DB | decimal? | Total Amount | - | |
Description:The difference between the PMWipAdjustmentLine.CuryOverbillingAmount and PMWipAdjustmentLine.CuryUnderbillingAmount. | ||||
CuryUnderbillingAdjustmentAmount | decimal | Underbilling Adjustment | - | |
Description:The sum of the PMWipAdjustmentLine.CuryUnderbillingAdjustmentAmount. | ||||
CuryUnderbillingAmount | decimal | Underbilling Amount | - | |
Description:The sum of the PMWipAdjustmentLine.CuryUnderbillingAmount. | ||||
Date | datetime | Date | - | |
Description:The date when the transaction was created. | ||||
Description | nvarchar(256) | Description | - | |
Description:The description of the transaction. | ||||
FinPeriodID | string | Financial Period | FinPeriod | |
Description:The Financial Period of the transaction. By default, it is set to the period to which the PMWipAdjustment.ProjectionDate belongs but can be overridden by the user. | ||||
Hold | bit | - | ||
Description:A Boolean value that indicates (if set to true) that the transaction is on hold. | ||||
IncludePendingChangeOrders | bit | Include Pending CO in Calculations | - | |
Description:A Boolean value that indicates (if set to true) that change orders with the Pending Approval status are included in calculations. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LineCntr | int | - | ||
Description:The counter of the transaction lines. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OverbillingAccountID | int | Overbilling Account | Account | |
Description:The default overbilling account. | ||||
OverbillingAdjustmentAmount | decimal | - | ||
Description:The sum of the PMWipAdjustmentLine.OverbillingAdjustmentAmount. | ||||
OverbillingAmount | decimal | - | ||
Description:The sum of the PMWipAdjustmentLine.OverbillingAmount. | ||||
OverbillingSubID | int | Overbilling Subaccount | Sub | |
Description:The default overbilling subaccount. | ||||
OverbillingUnderbillingOption | char(2) | Overbilling/Underbilling Posting Level | - | |
Description:The posting option of the Overbilling/Underbilling amounts. The field can have one of the values described in PostingOptions.OverbillingUnderbillingOptionsListAttribute. | ||||
OwnerID | int | Owner | Contact | |
Description:The employee responsible for the transaction. The value of this field corresponds to the BAccount.BAccountID field. | ||||
ProjectStatus | nvarchar(10) | Project Status | - | |
Description:The status of projects for which the transaction has been generated. The field can have one of the values described in ProjectStatus.ListAttribute. | ||||
ProjectionDate | datetime | Projection Date | - | |
Description:The date that the transaction was projected to. | ||||
RateTypeID | nvarchar(6) | Currency Rate Type | CurrencyRateType | |
Description:The default rate type for the currency rate that is used for the transaction. The value of this field corresponds to the value of the CurrencyRateType.CuryRateTypeID field. | ||||
RefNbr | nvarchar(30) | Reference Nbr. | - | |
Description:The transaction identifier. | ||||
Rejected | bit | - | ||
Description:A Boolean value that indicates (if set to true) that the transaction is rejected. | ||||
Released | bit | - | ||
Description:A Boolean value that indicates (if set to true) that the transaction is released. | ||||
RevenueAccountID | int | Revenue Account | Account | |
Description:The default revenue subaccount. | ||||
RevenueOption | char(2) | Revenue Posting Level | - | |
Description:The posting option of the Revenue amounts. The field can have one of the values described in PostingOptions.RevenueOptionsListAttribute. | ||||
RevenueSubID | int | Revenue Subaccount | Sub | |
Description:The revenue default subaccount. | ||||
Status | char(1) | Status | - | |
Description:The status of the transaction. The field can have one of the values described in ProjectWipAdjustmentStatus.ListAttribute. | ||||
TotalAdjustmentAmountNonexistent in DB | decimal? | - | ||
Description:The difference between the PMWipAdjustmentLine.OverbillingAdjustmentAmount and PMWipAdjustmentLine.UnderbillingAdjustmentAmount. | ||||
TotalAmountNonexistent in DB | decimal? | - | ||
Description:The difference between the PMWipAdjustmentLine.OverbillingAmount and PMWipAdjustmentLine.UnderbillingAmount. | ||||
TranPeriodID | string | - | ||
Description:The Financial Period of the transaction. Determined by the projection date of the transaction. Unlike PMWipAdjustment.FinPeriodID, the value of this field can't be overridden by the user. | ||||
UnderbillingAccountID | int | Underbilling Account | Account | |
Description:The default underbilling account. | ||||
UnderbillingAdjustmentAmount | decimal | - | ||
Description:The sum of the PMWipAdjustmentLine.UnderbillingAdjustmentAmount. | ||||
UnderbillingAmount | decimal | - | ||
Description:The sum of the PMWipAdjustmentLine.UnderbillingAmount. | ||||
UnderbillingSubID | int | Underbilling Subaccount | Sub | |
Description:The default underbilling subaccount. | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:The workgroup that is responsible for the transaction. The value of this field corresponds to the EPCompanyTree.WorkGroupID field. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||