PM
PMAllocationDetail
Represents a step of the allocation rule that defines the calculation rules and allocation settings. The records of this type are created and edited through the Allocation Rules (PM207500) form (which corresponds to the AllocationMaint graph).
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountGroupFrom | int | Account Group From | PMAccountGroup | |
Description:The account group that starts the range of account groups whose transactions are involved in this allocation step. | ||||
AccountGroupID | int | Account Group | PMAccountGroup | |
Description:The identifier of the account group associated with the allocation's debit transactions. The value of this field corresponds to the value of the PMAccountGroup.accountID field. | ||||
AccountGroupOrigin | nvarchar(1) | Account Group | - | |
Description:The source of account group associated with the allocation's debit transactions. The field can have one of the values described in PMOrigin.ListAttribute. | ||||
AccountGroupTo | int | Account Group To | PMAccountGroup | |
Description:The account group that ends the range of account groups whose transactions are involved in this allocation step. | ||||
AccountID | int | Account | Account | |
Description:The identifier of the account associated with the allocation's debit transactions. The value of this field corresponds to the value of the Account.accountID field. | ||||
AccountOrigin | nvarchar(1) | Account Origin | - | |
Description:The account of the allocation. The field can have one of the values described in PMOrigin.DebitAccountListAttribute. | ||||
AllocateNonBillable | bit | Allocate Non-Billable Transactions | - | |
Description:A Boolean value that indicates (if set to true) that the system will create the allocation transaction even if it is non-billable. | ||||
AllocateZeroAmount | bit | Create Transaction with Zero Amount | - | |
Description:A Boolean value that indicates (if set to true) that the system will create the allocation transaction even if it has an amount of zero. | ||||
AllocateZeroQty | bit | Create Transaction with Zero Qty. | - | |
Description:A Boolean value that indicates (if set to true) that the system will create the allocation transaction even if it has a quantity of zero. | ||||
AllocationNonexistent in DB | int? | Allocation | - | |
Description:The step ID of the allocation rule. | ||||
AllocationID | nvarchar(15) | PMAllocation | ||
Description:The identifier of the allocation to which this allocation step belongs. The value of this field corresponds to the value of the PMAllocation.allocationID field. | ||||
AllocationTextNonexistent in DB | string | - | ||
Description:The allocation text of the allocation rule. | ||||
AmountFormula | nvarchar | Amount Formula | - | |
Description:The formula for calculating the amount of allocation transactions. | ||||
BillableQtyFormula | nvarchar | Billable Qty. Formula | - | |
Description:The formula for calculating the billable quantity for allocation transactions. | ||||
CopyNotes | bit | Copy Notes | - | |
Description:A Boolean value that indicates (if set to true) that the notes can be copied. | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:The identifier of the Cost Code associated with the budget line. The value of this field corresponds to the value of the PMCostCode.costCodeID field. | ||||
CostCodeOrigin | nvarchar(1) | Cost Code | - | |
Description:The source of the cost code associated with the allocation's debit transactions. The field can have one of the values described in PMOrigin.ListAttribute. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
DateSource | nvarchar(1) | Date Source | - | |
Description:The date source, which defines how the date for the allocation transactions is defined. The field can have one of the values described in PMDateSource.ListAttribute. | ||||
Description | nvarchar(255) | Description | - | |
Description:The description of the step. | ||||
DescriptionFormula | nvarchar | Description Formula | - | |
Description:The formula to be used to generate the descriptions for allocation transactions. | ||||
FullDetailNonexistent in DB | bool? | - | ||
Description:A Boolean value that indicates (if set to true) that the underlying transactions should be groupped by all of the following: inventory items, employees, dates, and vendors or customers. | ||||
GroupByDate | bit | By Date | - | |
Description:A Boolean value that indicates (if set to true) that the underlying transactions should be groupped by dates. | ||||
GroupByEmployee | bit | By Employee | - | |
Description:A Boolean value that indicates (if set to true) that the underlying transactions should be groupped by employees. | ||||
GroupByItem | bit | By Item | - | |
Description:A Boolean value that indicates (if set to true) that the underlying transactions should be groupped by inventory items. | ||||
GroupByVendor | bit | By Vendor | - | |
Description:A Boolean value that indicates (if set to true) that the underlying transactions should be groupped by vendors or customers. | ||||
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 | ||||
MarkAsNotAllocated | bit | Can Be Used as a Source in Another Allocation | - | |
Description:A Boolean value that indicates (if set to true) that the transactions allocated by this allocation rule could be used in subsequent allocations. | ||||
Method | nvarchar(1) | Allocation Method | - | |
Description:The method of the allocation. The field can have one of the values described in PMMethod.ListAttribute. | ||||
NoRateOption | nvarchar(1) | If @Rate Is Not Defined | - | |
Description:The action that is performed if the value for @Rate has not been defined. The field can have one of the values described in PMNoRateOption.AllocationListAttribute. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OffsetAccountGroupID | int | Account Group | PMAccountGroup | |
Description:The identifier of the account group associated with the allocation's credit transactions. The value of this field corresponds to the value of the PMAccountGroup.accountID field. | ||||
OffsetAccountGroupOrigin | nvarchar(1) | Account Group | - | |
Description:The source of the account group associated with the allocation's credit transactions. The field can have one of the values described in PMOrigin.ListAttribute. | ||||
OffsetAccountID | int | Account | Account | |
Description:The identifier of the account associated with the allocation's credit transactions. The value of this field corresponds to the value of the Account.accountID field. | ||||
OffsetAccountOrigin | nvarchar(1) | Account Origin | - | |
Description:The account for the allocation's debit transactions. The field can have one of the values described in PMOrigin.CreditAccountListAttribute. | ||||
OffsetBranchOrigin | nvarchar(1) | Branch | - | |
Description:The source of the branch associated with the project allocation transactions. The field can have one of the values described in PMOrigin.ListAttribute. | ||||
OffsetCostCodeID | int | Cost Code | PMCostCode | |
Description:The identifier of the Cost Code associated with the budget line. The value of this field corresponds to the value of the PMCostCode.costCodeID field. | ||||
OffsetCostCodeOrigin | nvarchar(1) | Cost Code | - | |
Description:. The source of the cost code associated with the allocation's credit transactions. The field can have one of the values described in PMOrigin.ListAttribute. | ||||
OffsetProjectID | int | Project | PMProject | |
Description:The identifier of the project associated with the allocation's credit transactions. The value of this field corresponds to the value of the PMProject.contractID field. | ||||
OffsetProjectOrigin | nvarchar(1) | Project | - | |
Description:The source of project associated with the allocation's credit transactions. The field can have one of the values described in PMOrigin.ListAttribute. | ||||
OffsetSubID | int | Subaccount | Sub | |
Description:The identifier of the subaccount associated with the allocation's credit transactions. The value of this field corresponds to the value of the Sub.SubID field. | ||||
OffsetSubMask | nvarchar(30) | Subaccount Mask | - | |
Description:The subaccount for the allocation's credit transactions. | ||||
OffsetTaskCD | nvarchar | Project Task | - | |
Description:The identifier of the task associated with the allocation's credit transactions. The value of this field corresponds to the value of the PMTask.taskID field. | ||||
OffsetTaskID | int | Project Task | PMProject | |
Description:The identifier of the origin of the offset task associated with the record. The value of this field corresponds to the value of the PMTask.taskID field. | ||||
OffsetTaskOrigin | nvarchar(1) | Project Task | - | |
Description:. The source of the task associated with the allocation's credit transactions. The field can have one of the values described in PMOrigin.ListAttribute. | ||||
Post | bit | Create Allocation Transaction | - | |
Description:A Boolean value that indicates (if set to true) that the system creates the allocation transactions. | ||||
ProjectID | int | Project | PMProject | |
Description:The identifier of the project associated with the allocation's debit transactions. The value of this field corresponds to the value of the PMProject.contractID field. | ||||
ProjectOrigin | nvarchar(1) | Project | - | |
Description:The source of the project associated with the allocation's debit transactions. The field can have one of the values described in PMOrigin.ListAttribute. | ||||
QtyFormula | nvarchar | Quantity Formula | - | |
Description:The formula to be used for calculating the quantity for allocation transactions. | ||||
RangeEnd | int | Range End | - | |
Description:The last step of the range. | ||||
RangeStart | int | Range Start | - | |
Description:The first step of the range. | ||||
RateTypeID | nvarchar(15) | Rate Type | PMRateType | |
Description:The rate type used in the allocation rule step. | ||||
Reverse | nvarchar(1) | Reverse Allocation | - | |
Description:The reverse allocation for the allocation transaction. The field can have one of the following values: - "I": On AR Invoice Release - "B": On AR Invoice Generation - "N": Never | ||||
SelectOption | nvarchar(1) | Select Transactions | - | |
Description:The way the system should select the transactions for allocation. The field can have one of the values described in PMSelectOption.ListAttribute. | ||||
SourceBranchID | int | Branch | - | |
Description:The branch of project transactions to be allocated. The value of this field corresponds to the value of the Branch.branchID field. | ||||
StepID | int | Step ID | - | |
Description:The unique identifier of the allocation rule. | ||||
SubID | int | Subaccount | Sub | |
Description:The identifier of the subaccount associated with the allocation's debit transactions. The value of this field corresponds to the value of the Sub.subID field. | ||||
SubMask | nvarchar(30) | Subaccount Mask | - | |
Description:The subaccount associated with the allocation's credit transactions. | ||||
TargetBranchID | int | Replace Branch With | - | |
Description:The identifier of the branch to be used in project allocation transactions. | ||||
TaskCD | nvarchar | - | ||
Description:The project task identifier displayed on the form. | ||||
TaskID | int | Project Task | PMProject | |
Description:The identifier of the task associated with the allocation's debit transactions. The value of this field corresponds to the value of the PMTask.taskID field. | ||||
TaskOrigin | nvarchar(1) | Project Task | - | |
Description:The source of the task associated with the allocation's debit transactions. The field can have one of the values described in PMOrigin.ListAttribute. | ||||
UpdateGL | bit | Post Transaction to GL | - | |
Description:A Boolean value that indicates (if set to true) that the allocation transactions should be posted to the general ledger. | ||||
UseReversalDateFromOriginal | bit | Use Reversal Date from Original Transaction | - | |
Description:A Boolean value that indicates (if set to true) that the system will specify the date and the financial period of the allocation transaction being reversed. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||