PM
PMTran
Represents a project transaction. The transactions are grouped in batches and edited through the Project Transactions (PM304000) form (which corresponds to the RegisterEntry graph).
View API Entity: ProjectTransactionDetail
/entity/Default/25.200.001/ProjectTransactionDetail| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ARRefNbr | 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 | ||||
AccountGroupID API | 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 API | int | Debit Account | Account | |
Description:The identifier of the debit Account associated with the transaction. The value of this field corresponds to the value of the Account.AccountID field. | ||||
Allocated API | bit | Allocated | - | |
Description:Specifies (if set to true) that the transaction | ||||
AllocationID | nvarchar(15) | AllocationID | - | |
Description:The identifier of the allocation rule associated with the transaction. | ||||
Amount | decimal | - | ||
Description:The amount of the transaction in the base currency of the tenant. | ||||
BAccountID API | int | Customer/Vendor | BAccountR | |
Description:The identifier of the vendor or customer associated with the transaction. The value of this field corresponds to the value of the BAccount.bAccountID field. | ||||
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. | ||||
BaseCuryRateNonexistent in DB | decimal? | Base Currency Rate | - | |
Description:The exchange rate from the transaction currency to the base currency. | ||||
BaseTypeNonexistent in DB | string | - | ||
Description:No description available | ||||
BatchNbr API | 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 API | bit | Billable | - | |
Description:Specifies (if set to true) that the transaction is used in calculating the amount charged to the customer. | ||||
BillableQty API | decimal | Billable Quantity | - | |
Description:The quantity that is used for billing the customer. | ||||
Billed API | bit | Billed | - | |
Description:Specifies (if set to true) that the transaction has been billed. | ||||
BilledDate | datetime | 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 API | int | 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 | 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 API | 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. | ||||
CreatedByCurrentAllocationNonexistent in DB | bool? | - | ||
Description:Specifies (if set to true) that the transaction was created during the current allocation process. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
Date API | datetime | Date | - | |
Description:The date of the transaction, which is specified by the user. Defaults to the current business date. | ||||
Description API | nvarchar(256) | Description | - | |
Description:The description provided for the transaction. | ||||
DuplicateOfTranIDObsolete | 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 API | 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 API | datetime | End Date | - | |
Description:The transaction end date. | ||||
ExcludedFromAllocation | bit | Excluded from Allocation | - | |
Description:Specifies (if set to true) that the transaction is excluded from the allocation. | ||||
ExcludedFromBalance | bit | Excluded from Balance | - | |
Description:Specifies (if set to true) that the transaction is excluded from the balance. | ||||
ExcludedFromBilling | bit | Excluded from Billing | - | |
Description:Specifies (if set to true) that the transaction is excluded from the billing. | ||||
ExcludedFromBillingReason | nvarchar(50) | Excluded from Billing Reason | - | |
Description:The reason of exclusion from the billing. | ||||
ExtRefNbr API | nvarchar(30) | External Ref. Nbr. | - | |
Description:The reference number of the external document. | ||||
FinPeriodID API | string | Fin. Period | FinPeriod | |
Description:An identifier of the company-specific financial period to which the transaction belongs. Defaults to the period to which the PMTran.Date belongs. The value can be overriden by the user. | ||||
InventoryID API | 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 | - | ||
Description:The amount to bill the customer (in the base currency of the tenant). The amount is provided by the billing rule. | ||||
InvoicedDescriptionNonexistent in DB | string | - | ||
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 | Billed Quantity | - | |
Description:The quantity to bill the customer. The quanity is provided by the billing rule. | ||||
IsCreditPairNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsFreeNonexistent in DBObsolete | bool? | - | ||
Description:No description available | ||||
IsInvertedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsNonGL | bit | - | ||
Description:No description available | ||||
IsQtyOnly | bit | - | ||
Description:Specifies (if set to true) 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 | 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 API | int | 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. | ||||
NonProjectNonexistent in DB | bool? | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OffsetAccountGroupID | int | Credit Account Group | PMAccountGroup | |
Description:No description available | ||||
OffsetAccountID API | int | Credit Account | Account | |
Description:No description available | ||||
OffsetSubID API | 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 API | decimal | 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. | ||||
PayrollWorkLocationID | int | PRLocation | ||
Description:No description available | ||||
PrefixNonexistent in DBObsolete | string | - | ||
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 | Project Currency Amount | - | |
Description:The amount of the transaction in the project currency. | ||||
ProjectCuryIDNonexistent in DB | string | 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 | Billed Amount | - | |
Description:The amount to bill the customer in the project currency. The amount is provided by the billing rule. | ||||
ProjectCuryRateNonexistent in DB | decimal? | Project Currency Rate | - | |
Description:The exchange rate from the transaction currency to the project currency. | ||||
ProjectID API | 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. | ||||
ProportionNonexistent in DBObsolete | decimal? | - | ||
Description:No description available | ||||
Qty API | decimal | 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 API | bit | Released | - | |
Description:Specifies (if set to true) 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 API | int | Employee | BAccount | |
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 | nvarchar(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 | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
ShiftID | int | Shift Code | EPShiftCode | |
Description:No description available | ||||
SkipNonexistent in DBObsolete | bool? | - | ||
Description:No description available | ||||
StartDate API | datetime | Start Date | - | |
Description:The transaction start date. | ||||
SubID API | 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 API | 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 API | decimal | Amount | - | |
Description:The amount of the transaction in the transaction currency. | ||||
TranCuryAmountCopyNonexistent 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 | nvarchar(5) | Currency | CurrencyList | |
Description:The identifier of the transaction currency. The value of this field corresponds to the value of the CurrencyList.CuryID field. | ||||
TranCuryUnitRate API | decimal | 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 | datetime | - | ||
Description:The date of the transaction. Defaults to the current business date. | ||||
TranID API | bigint | PM Tran. | - | |
Description:The unique identifier of the project transaction. | ||||
TranPeriodID | string | - | ||
Description:The financial period in the master calendar. | ||||
TranType | char(2) | PMRegister | ||
Description:The identifier of the functional area to which the transaction belongs. Defaults to the module of the parent batch. | ||||
UOM API | 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. | ||||
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 | - | ||
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. | ||||
UseBillableQty API | bit | Use Billable Quantity in Amount Formula | - | |
Description:Specifies (if set to true) 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. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||