Table 8022 "Contract Billing Err. Log"

Subscription Billing · Microsoft.SubscriptionBilling · captioned “Contract Billing Error Log” · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Contract Billing Error Log
DataClassification	CustomerContent
LookupPageId	Contract Billing Err. Log
DrillDownPageId	Contract Billing Err. Log
Permissions	tabledata “Contract Billing Err. Log” = rmid, tabledata “Billing Line” = rm

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	Entry No.	Integer	Specifies the unique entry number for the error log record.	AutoIncrement
3	Billing Template Code	Code[20]	Specifies the billing template code that was being processed when the error occurred.	TableRelation Table 8060 “Billing Template” (“Billing Template”.Code)
4	Error Text	Text[250]	Specifies the error message that occurred during the auto contract billing process.
5	Subscription	Code[20]	Specifies the subscription number that was being processed when the error occurred.	TableRelation Table 8057 “Subscription Header” (“Subscription Header”.“No.”)
6	Subscription Entry No.	Integer	Specifies the subscription line entry number that was being processed when the error occurred.	TableRelation Table 8059 “Subscription Line” (“Subscription Line”.“Entry No.”)
7	Subscription Contract No.	Code[20]	Specifies the subscription contract number that was being processed when the error occurred.	TableRelation Table 8052 “Customer Subscription Contract” (“Customer Subscription Contract”.“No.”)
8	Contract Line No.	Integer	Specifies the contract line number that was being processed when the error occurred.	TableRelation Table 8062 “Cust. Sub. Contract Line” (“Cust. Sub. Contract Line”.“Line No.” where(“Subscription Contract No.” = field(“Subscription Contract No.”)))
9	Contract Type	Code[20]	Specifies the contract type that was being processed when the error occurred.	TableRelation Table 8053 “Subscription Contract Type” (“Subscription Contract Type”.Code)
10	Assigned User ID	Code[50]	Specifies the user ID assigned to handle this error.	TableRelation Table 91 “User Setup” (“User Setup”.“User ID”); DataClassification EndUserIdentifiableInformation
11	Salesperson Code	Code[20]	Specifies the salesperson code associated with the contract that had an error.	TableRelation Table 13 “Salesperson/Purchaser” (Salesperson/Purchaser)

Keys

PK: Entry No. (clustered)

Procedures

InsertUnspecificLog(ErrorText: Text[250]) (internal)
InsertLogFromBillingTemplate(BillingTemplateCode: Code[20]; ErrorText: Text[250]) (internal)
InsertLogFromSubscriptionLine(BillingTemplateCode: Code[20]; SubscriptionLine: Record "Subscription Line"; ErrorText: Text[250]) (internal)
DeleteEntries(DaysOld: Integer)

Plus 1 local procedures.

Relations

drill-down page Page 8113 “Contract Billing Err. Log”
lookup page Page 8113 “Contract Billing Err. Log”
Salesperson Code: TableRelation Table 13 “Salesperson/Purchaser”
Subscription Contract No.: TableRelation Table 8052 “Customer Subscription Contract”
Contract Type: TableRelation Table 8053 “Subscription Contract Type”
Subscription: TableRelation Table 8057 “Subscription Header”
Subscription Entry No.: TableRelation Table 8059 “Subscription Line”
Billing Template Code: TableRelation Table 8060 “Billing Template”
Contract Line No.: TableRelation Table 8062 “Cust. Sub. Contract Line”
Assigned User ID: TableRelation Table 91 “User Setup”

Referenced by

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

Table 8070 “Subscription Billing Cue”: Errors Automated Billing

Pages and codeunits on this table

Page 8113 “Contract Billing Err. Log” (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: "Contract Billing Err. Log"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.