PMAllocationDetail

PX.Objects.PM

69 of 69 fields

	Field Name	Type	Display Name	Foreign Key
	`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.
	`StepID`	`int`	Step ID	-
Description:The unique identifier of the allocation rule.
	`AccountGroupFrom`Default Navigation	`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`Default Navigation	`int`	Account Group	PMAccountGroup
Description:No description available
	`AccountGroupOrigin`	`char(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`Default Navigation	`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`Default Navigation	`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`	`char(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 ) 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 ) 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 ) that the system will create the allocation transaction even if it has a quantity of zero.
	`Allocation`Nonexistent in DB	`int`	Allocation	-
Description:The step ID of the allocation rule.
	`AllocationText`Nonexistent in DB	`nvarchar(10)`		-
Description:The allocation text of the allocation rule.
	`AmountFormula`	`nvarchar(MAX)`	Amount Formula	-
Description:The formula for calculating the amount of allocation transactions.
	`BillableQtyFormula`	`nvarchar(MAX)`	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 ) that the notes can be copied.
	`CostCodeID`Default Navigation	`int`	Cost Code	PMCostCode
Description:No description available
	`CostCodeOrigin`	`char(1)`	Cost Code	-
Description:No description available
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created On	-
Description:No description available
	`DateSource`	`char(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(MAX)`	Description Formula	-
Description:The formula to be used to generate the descriptions for allocation transactions.
	`FullDetail`Nonexistent in DB	`bit`		-
Description:A Boolean value that indicates (if set to ) 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 ) that the underlying transactions should be groupped by dates.
	`GroupByEmployee`	`bit`	By Employee	-
Description:A Boolean value that indicates (if set to ) that the underlying transactions should be groupped by employees.
	`GroupByItem`	`bit`	By Item	-
Description:A Boolean value that indicates (if set to ) that the underlying transactions should be groupped by inventory items.
	`GroupByVendor`	`bit`	By Vendor	-
Description:A Boolean value that indicates (if set to ) that the underlying transactions should be groupped by vendors or customers.
	`LastModifiedByID`Default Navigation	`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 ) that the transactions allocated by this allocation rule could be used in subsequent allocations.
	`Method`	`char(1)`	Allocation Method	-
Description:The method of the allocation. The field can have one of the values described in PMMethod.ListAttribute.
	`NoRateOption`	`char(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`Default Navigation	`int`	Account Group	PMAccountGroup
Description:No description available
	`OffsetAccountGroupOrigin`	`char(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`Default Navigation	`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`	`char(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`	`char(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`Default Navigation	`int`	Cost Code	PMCostCode
Description:No description available
	`OffsetCostCodeOrigin`	`char(1)`	Cost Code	-
Description:No description available
	`OffsetProjectID`Default Navigation	`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`	`char(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`Default Navigation	`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`	`varchar(30)`	Subaccount Mask	-
Description:The subaccount for the allocation's credit transactions.
	`OffsetTaskCD`	`nvarchar(30)`	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`Default Navigation	`int`	Project Task	PMTask
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`	`char(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 ) that the system creates the allocation transactions.
	`ProjectID`Default Navigation	`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`	`char(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(MAX)`	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`Default Navigation	`nvarchar(15)`	Rate Type	PMRateType
Description:The rate type used in the allocation rule step.
	`Reverse`	`char(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`	`char(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`Default Navigation	`int`	Branch	Branch
Description:The branch of project transactions to be allocated. The value of this field corresponds to the value of the Branch.branchID field.
	`SubID`Default Navigation	`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`	`varchar(30)`	Subaccount Mask	-
Description:The subaccount associated with the allocation's credit transactions.
	`TargetBranchID`Default Navigation	`int`	Replace Branch With	Branch
Description:The identifier of the branch to be used in project allocation transactions.
	`TaskCD`	`nvarchar(30)`	TaskCD	-
Description:The project task identifier displayed on the form.
	`TaskID`Default Navigation	`int`	Project Task	PMTask
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`	`char(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.
	`tstamp`	`timestamp`		-
Description:No description available
	`UpdateGL`	`bit`	Post Transaction to GL	-
Description:A Boolean value that indicates (if set to ) 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 ) that the system will specify the date and the financial period of the allocation transaction being reversed.