Table 12178 "Issued Customer Bill Line" (IT)

IT country layer · Microsoft.Bank.Payment · BC29-30 · source at ea08af5e · facts from BC29

An object of the IT localization, not part of W1.

Properties

Property	Value
Caption	Issued Customer Bill Line
DataClassification	CustomerContent

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	Customer Bill No.	Code[20]	—
2	Line No.	Integer	—
10	Customer No.	Code[20]	—	TableRelation Customer
11	Customer Name	Text[100]	—	FlowField: lookup(Customer.Name where(“No.” = field(“Customer No.”))); not editable
12	Customer Bank Acc. No.	Code[20]	—	TableRelation “Customer Bank Account”.Code where(“Customer No.” = field(“Customer No.”))
15	Temporary Cust. Bill No.	Code[20]	—
16	Final Cust. Bill No.	Code[20]	—
20	Document Type	Enum “Gen. Journal Document Type”	—	enum Enum 6 “Gen. Journal Document Type”
21	Document No.	Code[20]	—	TableRelation if (“Document Type” = const(Invoice)) “Sales Invoice Header” else if (“Document Type” = const(“Credit Memo”)) “Sales Cr.Memo Header” else if (“Document Type” = const(“Finance Charge Memo”)) “Finance Charge Memo Header” else if (“Document Type” = const(Reminder)) “Reminder Header”
22	Document Occurrence	Integer	—
23	Document Date	Date	—
28	Amount	Decimal	—
30	Due Date	Date	—
35	Cumulative Bank Receipts	Boolean	—
40	Recalled by	Code[50]	—	DataClassification EndUserIdentifiableInformation
41	Recall Date	Date	—
45	Customer Entry No.	Integer	—	TableRelation Cust. Ledger Entry
12000	Direct Debit Mandate ID	Code[35]	—	TableRelation “SEPA Direct Debit Mandate” where(“Customer No.” = field(“Customer No.”))

Keys

Key1: Customer Bill No., Line No. (clustered)
Key2: Customer Entry No.
Key3: Customer No., Due Date, Customer Bank Acc. No., Cumulative Bank Receipts
Key4: Customer Bill No., Final Cust. Bill No.

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: "Issued Customer Bill Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A IT country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.