PM
PMRegister
PX.Objects.PM25 of 25 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
Module | char(2) | Source | - | |
Description:The identifier of the functional area, to which the batch belongs. The field can have one of the following values: "GL", "AP", "AR", "IN", "PM", "CA", "DR", "PR". | ||||
RefNbr | nvarchar(15) | Ref. Number | - | |
Description:The reference number of the document. The number is generated from the numbering sequence, which is specified on the Project Preferences form. | ||||
AmtTotal | decimal(19, 6) | Total Amount | - | |
Description:The total amount for the project transactions in the base currency. | ||||
BillableQtyTotal | decimal(19, 6) | Total Billable Quantity | - | |
Description:The total billable quantity for the project transactions. | ||||
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 | datetime2 | Transaction Date | - | |
Description:The date of the document. Defaults to the current business date. | ||||
Description | nvarchar(255) | Description | - | |
Description:The description of the document. | ||||
Hold | bit | On Hold | - | |
Description:Specifies (if set to ) that the document is on hold. | ||||
IsAllocation | bit | Allocation Transaction | - | |
Description:Specifies (if set to ) that the batch was created as a result of the allocation process. | ||||
IsBaseCuryNonexistent in DB | bit | - | ||
Description:Specifies (if set to ) that the values in the PMTran.Amount field of project transactions are displayed in the base currency. | ||||
IsMigratedRecord | bit | Migrated | - | |
Description:No description available | ||||
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 | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigDocNbr | nvarchar(30) | Orig. Doc. Nbr. | - | |
Description:The reference number of the original document. | ||||
OrigDocType | char(2) | Orig. Doc. Type | - | |
Description:The type of the original document. The field can have one of the following values: ""AL"": Allocation, ""TC"": Time Card, ""CS"": Case, ""EC"": Expense Claim, ""ET"": Equipment Time Card, ""AR"": Allocation Reversal, ""RV"": Reversal, ""IN"": Invoice, ""CR"": Credit Memo, ""DM"": Debit Memo, ""UR"": Unbilled Remainder, ""RR"": Unbilled Remainder Reversal, ""PB"": Pro Forma Billing, ""BL"": Bill, ""CA"": Credit Adjustment, ""DA"": Debit Adjustment, ""WR"": WIP Reversal, ""AP"": Service Order, ""SO"": Appointment, ""PR"": Regular Paycheck, ""PS"": Special Paycheck, ""PA"": Adjustment Paycheck, ""PV"": Void Paycheck, ""PF"": Final Paycheck | ||||
OrigNoteID | uniqueidentifier | Orig. Doc. Nbr. | - | |
Description:NoteID of the original document. | ||||
QtyTotal | decimal(19, 6) | Total Quantity | - | |
Description:The total quantity of items in the project transactions. | ||||
Released | bit | Released | - | |
Description:Specifies (if set to ) that the document has been released. | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:The read-only status of the document. The field can have one of the following values: ""H"": Hold, ""B"": Balanced, ""R"": Released | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||