Table 8060 "Billing Template"

Subscription Billing · Microsoft.SubscriptionBilling · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Billing Template
DataClassification	CustomerContent
LookupPageId	Billing Templates
DrillDownPageId	Billing Templates

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Code	Code[20]	Specifies the unique code of the billing template. via Page 8066 “Billing Templates”	NotBlank
2	Description	Text[80]	Specifies the name of the template. via Page 8066 “Billing Templates”
3	Partner	Enum “Service Partner”	Specifies whether the template applies to customer or Vendor Subscription Contracts. via Page 8066 “Billing Templates”	enum Enum 8053 “Service Partner”
5	Billing Date Formula	DateFormula	Specifies the formula for the date filter, which is used to filter billable Subscription Lines (“Next Billing Date”). via Page 8066 “Billing Templates”
6	Billing to Date Formula	DateFormula	Specifies the optional formula for the date filter, for the maximum date up to which the Subscription Lines are to be billed. via Page 8066 “Billing Templates”
7	My Suggestions Only	Boolean	Specifies whether the Subscription Lines which are to be billed are filtered only for myself. via Page 8066 “Billing Templates”
9	Group by	Enum “Contract Billing Grouping”	Specifies the option for grouping contract billing lines. via Page 8066 “Billing Templates”	enum Enum 8059 “Contract Billing Grouping”
10	Filter	Blob	—
11	Posting Date Formula	DateFormula	Specifies the date formula used to calculate the Posting Date. If the field is left empty, the Posting Date is prefilled with workdate, or with today when the process runs automatically.
12	Document Date Formula	DateFormula	Specifies the date formula used to calculate the Document Date. If the field is left empty, the Document Date is prefilled with workdate, or with today when the process runs automatically.
13	Customer Document per	Enum “Customer Rec. Billing Grouping”	Specifies how the Billing lines for customers are grouped in sales documents.	enum Enum 8057 “Customer Rec. Billing Grouping”
15	Automation	Enum “Sub. Billing Automation”	Specifies if the billing process is automated.	enum Enum 8022 “Sub. Billing Automation”
17	Minutes between runs	Integer	Specifies the frequency, in minutes, for running the automation.	DataClassification SystemMetadata
18	Batch Recurrent Job Id	Guid	Specifies the ID of the job queue entry that runs the billing process in the background.	not editable; DataClassification SystemMetadata
19	Batch Rec. Job Description	Text[250]	Specifies the description of the job queue entry that runs the billing process in the background.	FlowField: lookup(“Job Queue Entry”.Description where(“ID” = field(“Batch Recurrent Job Id”))); not editable

Keys

PK: Code (clustered)

Procedures

EditFilter(FieldNumber: Integer): Boolean (internal)
ReadFilter(FieldNumber: Integer): Text (internal)
WriteFilter(FieldNumber: Integer; FilterText: Text) (internal)
IsPartnerCustomer(): Boolean (internal)
BillContractsAutomatically() (internal)
CalculateBillingDates(var BillingDate: Date; var BillingToDate: Date; BackgroundProcess: Boolean) (internal)
CalculateDocumentDates(var PostingDate: Date; var DocumentDate: Date; BackgroundProcess: Boolean) (internal)
LookupJobEntryQueue() (internal)
ClearAutomationFields() (internal)

Plus 1 local procedures.

Triggers

OnModify, OnDelete

Relations

drill-down page Page 8066 “Billing Templates”
lookup page Page 8066 “Billing Templates”
Batch Rec. Job Description: CalcFormula Table 472 “Job Queue Entry”

Referenced by

3 fields in 3 objects relate to this table (TableRelation or CalcFormula).

Table 8022 “Contract Billing Err. Log”: Billing Template Code
Table 8061 “Billing Line”: Billing Template Code
Table 8064 “Billing Line Archive”: Billing Template Code

Pages and codeunits on this table

Page 8066 “Billing Templates” (source table)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Billing Template"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.