Table 11000000 "Proposal Line" (NL)

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

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

Properties

Property	Value
Caption	Proposal 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	Line No.	Integer	—
2	Account Type	Option	—	OptionCaption: Customer,Vendor,Employee
3	Account No.	Code[20]	—	TableRelation if (“Account Type” = const(Customer)) Customer.“No.” else if (“Account Type” = const(Vendor)) Vendor.“No.” else if (“Account Type” = const(Employee)) Employee.“No.”; NotBlank
4	Transaction Date	Date	—	NotBlank
5	Amount	Decimal	—	NotBlank
7	Bank	Code[20]	—	TableRelation if (“Account Type” = const(Customer)) “Customer Bank Account”.Code where(“Customer No.” = field(“Account No.”)) else if (“Account Type” = const(Vendor)) “Vendor Bank Account”.Code where(“Vendor No.” = field(“Account No.”)) else if (“Account Type” = const(Employee)) Employee.“No.” where(“Employee No….
8	Our Bank No.	Code[20]	—	TableRelation “Bank Account”.“No.”; not editable
9	Order	Option	—	OptionCaption: ,Debit,Credit; not editable
11	Description 1	Text[32]	—
12	Description 2	Text[32]	—
13	Description 3	Text[32]	—
14	Description 4	Text[32]	—
15	Identification	Code[20]	—
16	Bank Account No.	Text[30]	—	NotBlank
17	Our Bank Account No.	Text[30]	—	FlowField: lookup(“Bank Account”.“Bank Account No.” where(“No.” = field(“Our Bank No.”))); not editable
18	Transaction Mode	Code[20]	—	TableRelation “Transaction Mode”.Code where(“Account Type” = field(“Account Type”)); NotBlank
19	Number of Detail Lines	Integer	—	FlowField: count(“Detail Line” where(“Our Bank” = field(“Our Bank No.”), “Connect Lines” = field(“Line No.”))); not editable
20	Error Message	Text[125]	—
22	Currency Code	Code[10]	—	TableRelation Currency.Code; not editable
23	Amount (LCY)	Decimal	—	not editable
24	Process	Boolean	—
25	Warning	Text[125]	—
26	Identification No. Series	Code[20]	—
27	Docket	Boolean	—
100	Account Holder Name	Text[100]	—
101	Account Holder Address	Text[100]	—
102	Account Holder Post Code	Code[20]	—
103	Account Holder City	Text[30]	—
104	Acc. Hold. Country/Region Code	Code[10]	—	TableRelation “Country/Region”.Code
105	National Bank Code	Code[10]	—
106	SWIFT Code	Code[20]	—
110	Nature of the Payment	Option	—	OptionCaption: ,Goods,Transito Trade,Invisible- and Capital Transactions,Transfer to Own Account,Other Registrated BFI
111	Registration No. DNB	Text[8]	—
112	Description Payment	Text[30]	—
113	Item No.	Text[2]	—
114	Traders No.	Text[4]	—
115	Urgent	Boolean	—
120	Bank Name	Text[100]	—
121	Bank Address	Text[100]	—
122	Bank City	Text[30]	—
123	Bank Country/Region Code	Code[10]	—	TableRelation “Country/Region”.Code
130	Transfer Cost Domestic	Option	—	OptionCaption: Principal,Balancing Account Holder
131	Transfer Cost Foreign	Option	—	OptionCaption: Principal,Balancing Account Holder
132	Abbrev. National Bank Code	Code[3]	—
133	IBAN	Code[50]	—
134	Direct Debit Mandate ID	Code[35]	—	TableRelation “SEPA Direct Debit Mandate”.ID where(“Customer No.” = field(“Account No.”), “Customer Bank Account Code” = field(Bank))
135	Salespers./Purch. Code	Code[20]	—	TableRelation Salesperson/Purchaser
200	Account Name	Text[100]	—
480	Dimension Set ID	Integer	—	TableRelation Dimension Set Entry; not editable
481	Header Dimension Set ID	Integer	—	TableRelation Dimension Set Entry; not editable
11400	Foreign Currency	Code[10]	—	TableRelation Currency
11401	Foreign Amount	Decimal	—
11402	Shortcut Dimension 1 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1))
11403	Shortcut Dimension 2 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2))

Keys

Key1: Our Bank No., Line No. (clustered)
Key2: Our Bank No., Process, Account Type, Account No., Bank, Transaction Mode, Currency Code, Transaction Date
Key3: Our Bank No., Identification
Key4: Our Bank No., Account Type, Account Name
Key5: Account No.

Events published

OnBeforeValidateShortcutDimCode(var ProposalLine: Record "Proposal Line"; var xProposalLine: Record "Proposal Line"; FieldNo: Integer; var ShortcutDimCode: Code[20]) (integration): Integration event raised before validating a shortcut dimension code for proposal line. Enables custom dimension validation logic or preprocessing before standard validation.
OnInitRecordOnBeforeFindProposalLine(var ProposalLine: Record "Proposal Line"; ProposalLineRec: Record "Proposal Line") (integration): Integration event raised in InitRecord before searching for an existing proposal line to copy the header dimension set. Enables custom filtering on the proposal line lookup before the FindFirst call.

Procedures

GetSourceName(): Text
TestDetailAvailable(Field: Text[250])
AmountLV(): Decimal
DetailFilter(var Detail line: Record "Detail Line"; ProposalFilterRecord: Record "Proposal Line")
InitRecord()
IdentificationAssistEdit(OldProp: Record "Proposal Line"): Boolean
CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]; HeaderDimSetID: Boolean)
ValidateShortcutDimCode(FieldNo: Integer; var ShortcutDimCode: Code[20])
LookupShortcutDimCode(FieldNo: Integer; var ShortcutDimCode: Code[20])
ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])
SelectAll()
DeselectAll()
ShowDimensions()
ShowHeaderDimensions()

Plus 3 local procedures.

Triggers

OnDelete, OnInsert, OnRename

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

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