PMTran

PX.Objects.PM

98 of 98 fields

	Field Name	Type	Display Name	Foreign Key
	`TranID`	`bigint`	PM Tran.	-
Description:The unique identifier of the project transaction.
	`AccountGroupID`Default Navigation	`int`	Account Group	PMAccountGroup
Description:The identifier of the Account Group associated with the transaction. The value of this field corresponds to the value of the PMAccountGroup.GroupID field.
	`AccountID`Default Navigation	`int`	Debit Account	Account
Description:No description available
	`Allocated`	`bit`	Allocated	-
Description:Specifies (if set to ) that the transaction
	`AllocationID`	`nvarchar(15)`	AllocationID	-
Description:The identifier of the allocation rule associated with the transaction.
	`Amount`	`decimal(19, 4)`		-
Description:The amount of the transaction in the base currency of the tenant.
	`ARRefNbr`Default Navigation	`nvarchar(15)`	AR Reference Nbr.	ARInvoice
Description:The reference number of the accounts receivable document associated with the transaction. The value of this field corresponds to the value of the ARInvoice.RefNbr field.
	`ARTranType`	`char(3)`		-
Description:The type of the accounts receivable document associated with the transaction. The field can have one of the following values: ""INV"": Invoice, ""DRM"": Debit Memo, ""CRM"": Credit Memo, ""FCH"": Overdue Charge, ""SMC"": Credit WO
	`BAccountID`Default Navigation	`int`	Customer/Vendor	BAccount
Description:No description available
	`BaseCuryInfoID`	`bigint`		-
Description:The identifier of the CurrencyInfo record that stores exchange rate from the transaction currency to the base currency. The value of this field corresponds to the value of the CurrencyInfo.CuryInfoID field.
	`BaseCuryRate`Nonexistent in DB	`decimal`	Base Currency Rate	-
Description:The exchange rate from the transaction currency to the base currency.
	`BaseType`Nonexistent in DB	`unspecified`		-
Description:No description available
	`BatchNbr`Default Navigation	`nvarchar(15)`	GL Batch Nbr.	Batch
Description:The reference number of the GL Batch associated with the transaction. The value of this field corresponds to the value of the Batch.BatchNbr field.
	`Billable`	`bit`	Billable	-
Description:Specifies (if set to ) that the transaction is used in calculating the amount charged to the customer.
	`BillableQty`	`decimal(19, 6)`	Billable Quantity	-
Description:The quantity that is used for billing the customer.
	`Billed`	`bit`	Billed	-
Description:Specifies (if set to ) that the transaction has been billed.
	`BilledDate`	`datetime2`	Billed Date	-
Description:The date on which the transaction was billed.
	`BillingID`	`nvarchar(15)`		-
Description:The identifier of the billing rule associated with the transaction.
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:The identifier of the Branch to which the transaction belongs. The value of this field corresponds to the value of the Branch.BranchID field.
	`CaseCD`Default Navigation	`nvarchar(15)`	Case ID	CRCase
Description:The identifier of the case whose billing resulted in this transaction. The value of this field corresponds to the value of the CRCase.CaseCD field.
	`CostCodeID`Default Navigation	`int`	Cost Code	PMCostCode
Description:The identifier of the Cost Code associated with the transaction. The value of this field corresponds to the value of the PMCostCode.costCodeID field.
	`CreatedByCurrentAllocation`Nonexistent in DB	`bit`		-
Description:Specifies (if set to ) that the transaction was created during the current allocation process.
	`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
	`Date`	`datetime2`	Date	-
Description:The date of the transaction, which is specified by the user. Defaults to the current business date.
	`Description`	`nvarchar(256)`	Description	-
Description:The description provided for the transaction.
	`DuplicateOfTranID`Obsolete	`bigint`		-
Description:The identifier of the project transaction. When a credit memo is created as the result of project's invoice reversal, a copy of the original billable transaction is created so that it can be billed again.
	`EarningType`Default Navigation	`nvarchar(15)`	Earning Type	EPEarningType
Description:The identifier of the earning type, which is specified for the transaction to calculate the labor cost. The value of this field corresponds to the value of the EPEarningType.typeCD field.
	`EndDate`	`datetime2`	End Date	-
Description:The transaction end date.
	`ExcludedFromAllocation`	`bit`	Excluded from Allocation	-
Description:Specifies (if set to ) that the transaction is excluded from the allocation.
	`ExcludedFromBalance`	`bit`	Excluded from Balance	-
Description:Specifies (if set to ) that the transaction is excluded from the balance.
	`ExcludedFromBilling`	`bit`	Excluded from Billing	-
Description:Specifies (if set to ) that the transaction is excluded from the billing.
	`ExcludedFromBillingReason`	`nvarchar(50)`	Excluded from Billing Reason	-
Description:The reason of exclusion from the billing.
	`ExtRefNbr`	`nvarchar(30)`	External Ref. Nbr.	-
Description:The reference number of the external document.
	`FinPeriodID`Default Navigation	`char(6)`	Fin. Period	-
Description:No description available
	`InventoryID`Default Navigation	`int`	Inventory ID	InventoryItem
Description:The identifier of the stock or non-stock item associated with the transaction. The value of this field corresponds to the value of the InventoryItem.InventoryID field.
	`InvoicedAmount`	`decimal(19, 4)`		-
Description:The amount to bill the customer (in the base currency of the tenant). The amount is provided by the billing rule.
	`InvoicedDescription`Nonexistent in DB	`nvarchar(255)`		-
Description:A description, which is generated during the billing based on the line description formula specified in the billing rule. The value is used to generate the description for the corresponding pro forma invoice line.
	`InvoicedQty`	`decimal(19, 6)`	Billed Quantity	-
Description:The quantity to bill the customer. The quanity is provided by the billing rule.
	`IsFree`Nonexistent in DBObsolete	`bit`		-
Description:No description available
	`IsNonGL`	`bit`		-
Description:No description available
	`IsQtyOnly`	`bit`		-
Description:Specifies (if set to ) that the transaction contains only quantity data and no price and amount data. For example, CRM records contain only usage data without price information. The price is determined later during the billing process.
	`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
	`LocationID`Default Navigation	`int`	Location	Location
Description:The identifier of the location of the customer or vendor associated with the transaction. The value of this field corresponds to the value of the Location.LocationID field.
	`MigrationOffsetAccountGroupID`	`int`		PMAccountGroup
Description:The identifier of the offset account group. Migrated from offset account group for backword compatibility. Eventually will be removed in future when no longer needed.
	`NonProject`Nonexistent in DB	`unspecified`		-
Description:No description available
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OffsetAccountGroupID`Default Navigation	`int`	Credit Account Group	PMAccountGroup
Description:The identifier of the offset account group.
	`OffsetAccountID`Default Navigation	`int`	Credit Account	Account
Description:The identifier of the credit Account associated with the transaction. The value of this field corresponds to the value of the Account.AccountID field.
	`OffsetSubID`Default Navigation	`int`	Credit Subaccount	Sub
Description:The identifier of the credit subaccount associated with the transaction. The value of this field corresponds to the value of the Sub.SubID field.
	`OrigAccountGroupID`	`int`		-
Description:The original account group ID.
	`OrigLineNbr`	`int`	OrigLineNbr	-
Description:The line number in the original document.
	`OrigModule`	`char(2)`	OrigModule	-
Description:The identifier of the functional area to which the GL batch that spawned the transaction belongs.
	`OrigProjectID`	`int`		-
Description:The original project ID.
	`OrigRefID`	`uniqueidentifier`		-
Description:The Case.NoteID for contracts and CRActivity.NoteID for time cards and time sheets.
	`OrigRefNbr`	`nvarchar(15)`	OrigRefNbr	-
Description:The reference number of the original document.
	`OrigTaskID`	`int`		-
Description:The original task ID.
	`OrigTranID`	`bigint`		-
Description:The reference to the original transaction if a reversal is created.
	`OrigTranType`	`char(3)`	OrigTranType	-
Description:The type of the original document.
	`OvertimeMultiplier`	`decimal(6, 4)`	Multiplier	-
Description:The multiplier by which the unit rate is multiplied when the labor cost is calculated. The multiplier can differ from 1 only for earning types marked as overtime.
	`Prefix`Nonexistent in DBObsolete	`nvarchar(255)`		-
Description:No description available
	`ProformaLineNbr`	`int`		-
Description:The line number in the corresponding pro forma invoice associated with the transaction.
	`ProformaRefNbr`	`nvarchar(15)`	Pro Forma Ref. Nbr.	-
Description:The reference number of the pro forma invoice associated with the transaction.
	`ProjectCuryAmount`	`decimal(19, 4)`	Project Currency Amount	-
Description:The amount of the transaction in the project currency.
	`ProjectCuryID`Nonexistent in DB	`nvarchar(5)`	Project Currency	-
Description:The project currency.
	`ProjectCuryInfoID`	`bigint`		-
Description:The identifier of the CurrencyInfo record that stores exchange rate from the transaction currency to the project currency. The value of this field corresponds to the value of the CurrencyInfo.CuryInfoID field.
	`ProjectCuryInvoicedAmount`	`decimal(19, 4)`	Billed Amount	-
Description:The amount to bill the customer in the project currency. The amount is provided by the billing rule.
	`ProjectCuryRate`Nonexistent in DB	`decimal`	Project Currency Rate	-
Description:The exchange rate from the transaction currency to the project currency.
	`ProjectID`Default Navigation	`int`	Project	PMProject
Description:The identifier of the project associated with the transaction, or the non-project code indicating that the transaction is not related to any particular project. The value of this field corresponds to the value of the PMProject.ContractID field.
	`Proportion`Nonexistent in DBObsolete	`decimal`		-
Description:No description available
	`Qty`	`decimal(19, 6)`	Quantity	-
Description:The quantity of the transaction.
	`RefLineNbr`	`int`		-
Description:The line number in the corresponding accounts receivable document associated with the transaction.
	`RefNbr`	`nvarchar(15)`	Ref. Number	PMRegister
Description:The number of the PMRegister to which the transaction belongs. The value of this field corresponds to the PMRegister.RefNbr field.
	`Released`	`bit`	Released	-
Description:Specifies (if set to ) that the transaction has been released.
	`RemainderOfTranID`	`bigint`		-
Description:A remainder, which holds the reference to the original transaction when the remainder is created.
	`ResourceID`Default Navigation	`int`	Employee	EPEmployee
Description:The identifier of the employee associated with the transaction. The value of this field corresponds to the value of the BAccount.bAccountID field.
	`Reverse`	`char(1)`	Reverse	-
Description:An option that indicates when the allocation transaction should be reversed. The field can have one of the following values: ""I"": On AR Invoice Release, ""B"": On AR Invoice Generation, ""N"": Never
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:No description available
	`Skip`Nonexistent in DBObsolete	`bit`	Skip	-
Description:No description available
	`StartDate`	`datetime2`	Start Date	-
Description:The transaction start date.
	`SubID`Default Navigation	`int`	Debit Subaccount	Sub
Description:The identifier of the debit subaccount associated with the transaction. The value of this field corresponds to the value of the Sub.SubID field.
	`TaskID`Default Navigation	`int`	Project Task	PMTask
Description:The identifier of the task associated with the transaction. The value of this field corresponds to the value of the PMTask.TaskID field.
	`TranCuryAmount`	`decimal(19, 4)`	Amount	-
Description:The amount of the transaction in the transaction currency.
	`TranCuryAmountCopy`Nonexistent in DB	`decimal`		-
Description:The amount of the transaction in the transaction currency. This is a technical field that is a copy of the TranCuryAmount field. Used to automatic conversion of amount from the transaction currency to the project currency.
	`TranCuryID`Default Navigation	`nvarchar(5)`	Currency	CurrencyList
Description:No description available
	`TranCuryUnitRate`	`decimal(19, 6)`	Unit Rate	-
Description:The price of the item or the rate of the service in the transaction currency. For a labor item, the employee's hourly rate is used as the unit rate.
	`TranDate`	`datetime2`		-
Description:The date of the transaction. Defaults to the current business date.
	`TranPeriodID`	`char(6)`		-
Description:The financial period in the master calendar.
	`TranType`	`char(2)`		-
Description:The identifier of the functional area to which the transaction belongs. Defaults to the module of the parent batch.
	`tstamp`	`timestamp`		-
Description:No description available
	`UnionID`	`nvarchar(15)`	Union Local	PMUnion
Description:The identifier of the union local associated with the transaction. The value of this field corresponds to the value of the PMUnion.UnionID field.
	`UnitRate`	`decimal(19, 6)`		-
Description:The price of the item or the rate of the service in the base currency of the tenant. For a labor item, the employee's hourly rate is used as the unit rate.
	`UOM`Default Navigation	`nvarchar(6)`	UOM	INUnit
Description:The unit of measure used to estimate the quantity for the transaction. The value of this field corresponds to the value of the INUnit.fromUnit field.
	`UseBillableQty`	`bit`	Use Billable Quantity in Amount Formula	-
Description:Specifies (if set to ) that the system uses the billable quantity instead of the overall quantity of the transaction when calculating the amount of the transaction.
	`WorkCodeID`	`nvarchar(15)`	WCC Code	PMWorkCode
Description:The identifier of the WCC code associated with the transaction. The value of this field corresponds to the value of the PMWorkCode.WorkCodeID field.