Skip to main content
PM

PMBillingRecord

PX.Objects.PM
Field NameTypeDisplay NameForeign Key
BillingTag
nvarchar(30)-
Description:An internal field that is used during the billing to group and segregate transactions between billing rules, tasks, and invoices. The field can have one of the following values: T: [PMTask.TaskID], if [PMTask.BillSeparately] is for the billed task. L: [PMTask.LocationID], if [PMTask.LocationID] is not equal to the location ID from the parent project. P: Otherwise.
ProjectID
intProject ID-
Description:The identifier of the project associated with the record. The value of this field corresponds to the value of the PMProject.ContractID field.
RecordID
intBilling Number-
Description:The sequence of line numbers of the records that belong to one project can include gaps. Note that the sequence of line numbers of the records belonging to a single project may include gaps.
ARDocType
char(3)AR Doc. Type-
Description:The type of the AR document that is created during the billing. The value of this field corresponds to the value of the ARInvoice.DocType field.
ARRefNbrDefault Navigation
nvarchar(15)AR Reference Nbr.ARInvoice
Description:The reference number of the AR document that is created during the billing. The value of this field corresponds to the value of the ARInvoice.RefNbr field.
Date
datetime2Pro Forma Date-
Description:The date when the billing is applied. Defaults to the current business date.
ProformaRefNbrDefault Navigation
nvarchar(15)Pro Forma Reference Nbr.PMProforma
Description:The reference number of the parent pro forma invoice.
RecordNumberNonexistent in DB
intBilling Number-
Description:The sequence number of the invoice that is being assigned to the invoices of the project in order of the creation of the invoices. Retrives the value from the RecordID field.
SortOrderNonexistent in DB
int-
Description:An internal field that is used to order records on the Invoices tab of the Projects (PM301000) form.
tstamp
timestamp-
Description:No description available