Table 15000004 "Waiting Journal" (NO)

NO country layer · Microsoft.Purchases.Payables · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property	Value
Caption	Waiting Journal
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	Journal Template Name	Code[10]	—	TableRelation Gen. Journal Template
2	Line No.	Integer	—
3	Account Type	enum “Gen. Journal Account Type”	—	enum Enum 81 “Gen. Journal Account Type”
4	Account No.	Code[20]	—	TableRelation if (“Account Type” = const(“G/L Account”)) “G/L Account” else if (“Account Type” = const(Customer)) Customer else if (“Account Type” = const(Vendor)) Vendor else if (“Account Type” = const(“Bank Account”)) “Bank Account” else if (“Account Type” = const(“Fixed Asset”)) “Fixed Asset”
5	Posting Date	Date	—
6	Document Type	Option	—	OptionCaption: ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder
7	Document No.	Code[20]	—
8	Description	Text[50]	—
10	VAT %	Decimal	—	not editable
11	Bal. Account No.	Code[20]	—	TableRelation if (“Bal. Account Type” = const(“G/L Account”)) “G/L Account” else if (“Bal. Account Type” = const(Customer)) Customer else if (“Bal. Account Type” = const(Vendor)) Vendor else if (“Bal. Account Type” = const(“Bank Account”)) “Bank Account” else if (“Bal. Account Type” = const(“Fixed Asset”)) “Fixed…
12	Currency Code	Code[10]	—	TableRelation Currency
13	Amount	Decimal	—
14	Debit Amount	Decimal	—
15	Credit Amount	Decimal	—
16	Amount (LCY)	Decimal	—
17	Balance (LCY)	Decimal	—	not editable
18	Currency Factor	Decimal	—	not editable
19	Sales/Purch. (LCY)	Decimal	—
20	Profit (LCY)	Decimal	—
21	Inv. Discount (LCY)	Decimal	—
22	Sell-to/Buy-from No.	Code[20]	—	TableRelation if (“Account Type” = const(Customer)) Customer else if (“Bal. Account Type” = const(Customer)) Customer else if (“Account Type” = const(Vendor)) Vendor else if (“Bal. Account Type” = const(Vendor)) Vendor
23	Posting Group	Code[20]	—	TableRelation if (“Account Type” = const(Customer)) “Customer Posting Group” else if (“Account Type” = const(Vendor)) “Vendor Posting Group” else if (“Account Type” = const(“Fixed Asset”)) “FA Posting Group”; not editable
24	Shortcut Dimension 1 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1))
25	Shortcut Dimension 2 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2))
26	Salespers./Purch. Code	Code[20]	—	TableRelation Salesperson/Purchaser
29	Source Code	Code[10]	—	TableRelation Source Code; not editable
30	System-Created Entry	Boolean	—	not editable
34	On Hold	Code[3]	—
35	Applies-to Doc. Type	Option	—	OptionCaption: ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder
36	Applies-to Doc. No.	Code[20]	—
38	Due Date	Date	—
39	Pmt. Discount Date	Date	—
40	Payment Discount %	Decimal	—
42	Job No.	Code[20]	—	TableRelation Job; not editable
43	Quantity	Decimal	—
44	VAT Amount	Decimal	—
45	VAT Posting	Option	—	OptionCaption: Automatic VAT Entry,Manual VAT Entry; not editable
47	Payment Terms Code	Code[10]	—	TableRelation Payment Terms
48	Applies-to ID	Code[50]	—
50	Business Unit Code	Code[20]	—	TableRelation Business Unit
51	Journal Batch Name	Code[10]	—	TableRelation “Gen. Journal Batch”.Name where(“Journal Template Name” = field(“Journal Template Name”))
52	Reason Code	Code[10]	—	TableRelation Reason Code
53	Recurring Method	Option	—	OptionCaption: ,F Fixed,V Variable,B Balance,RF Reversing Fixed,RV Reversing Variable,RB Reversing Balance
54	Expiration Date	Date	—
55	Recurring Frequency	DateFormula	—
56	Allocated Amt. (LCY)	Decimal	—	FlowField: sum(“Gen. Jnl. Allocation”.Amount where(“Journal Template Name” = field(“Journal Template Name”), “Journal Batch Name” = field(“Journal Batch Name”), “Journal Line No.” = field(“Line No.”))); not editable
57	Gen. Posting Type	Option	—	OptionCaption: ,Purchase,Sale,Settlement
58	Gen. Bus. Posting Group	Code[20]	—	TableRelation Gen. Business Posting Group
59	Gen. Prod. Posting Group	Code[20]	—	TableRelation Gen. Product Posting Group
60	VAT Calculation Type	Enum “Tax Calculation Type”	—	enum Enum 254 “Tax Calculation Type”; not editable
61	EU 3-Party Trade	Boolean	—	not editable
62	Allow Application	Boolean	—
63	Bal. Account Type	enum “Gen. Journal Account Type”	—	enum Enum 81 “Gen. Journal Account Type”
64	Bal. Gen. Posting Type	Option	—	OptionCaption: ,Purchase,Sale,Settlement
65	Bal. Gen. Bus. Posting Group	Code[20]	—	TableRelation Gen. Business Posting Group
66	Bal. Gen. Prod. Posting Group	Code[20]	—	TableRelation Gen. Product Posting Group
67	Bal. VAT Calculation Type	Enum “Tax Calculation Type”	—	enum Enum 254 “Tax Calculation Type”; not editable
68	Bal. VAT %	Decimal	—	not editable
69	Bal. VAT Amount	Decimal	—
70	Bank Payment Type	Option	—	OptionCaption: ,Computer Check,Manual Check
71	VAT Base Amount	Decimal	—
72	Bal. VAT Base Amount	Decimal	—
73	Correction	Boolean	—
75	Check Printed	Boolean	—	not editable
76	Document Date	Date	—
77	External Document No.	Code[35]	—
78	Source Type	Option	—	OptionCaption: ,Customer,Vendor,Bank Account,Fixed Asset
79	Source No.	Code[20]	—	TableRelation if (“Source Type” = const(Customer)) Customer else if (“Source Type” = const(Vendor)) Vendor else if (“Source Type” = const(“Bank Account”)) “Bank Account” else if (“Source Type” = const(“Fixed Asset”)) “Fixed Asset”
80	Posting No. Series	Code[20]	—	TableRelation No. Series
82	Tax Area Code	Code[20]	—	TableRelation Tax Area
83	Tax Liable	Boolean	—
84	Tax Group Code	Code[20]	—	TableRelation Tax Group
85	Use Tax	Boolean	—
86	Bal. Tax Area Code	Code[20]	—	TableRelation Tax Area
87	Bal. Tax Liable	Boolean	—
88	Bal. Tax Group Code	Code[20]	—	TableRelation Tax Group
89	Bal. Use Tax	Boolean	—
90	VAT Bus. Posting Group	Code[20]	—	TableRelation VAT Business Posting Group
91	VAT Prod. Posting Group	Code[20]	—	TableRelation VAT Product Posting Group
92	Bal. VAT Bus. Posting Group	Code[20]	—	TableRelation VAT Business Posting Group
93	Bal. VAT Prod. Posting Group	Code[20]	—	TableRelation VAT Product Posting Group
95	Additional-Currency Posting	Option	—	OptionCaption: None,Amount Only,Additional-Currency Amount Only; not editable
98	FA Add.-Currency Factor	Decimal	—
99	Source Currency Code	Code[10]	—	TableRelation Currency; not editable
100	Source Currency Amount	Decimal	—	not editable
101	Source Curr. VAT Base Amount	Decimal	—	not editable
102	Source Curr. VAT Amount	Decimal	—	not editable
103	VAT Base Discount %	Decimal	—	not editable
104	VAT Amount (LCY)	Decimal	—	not editable
105	VAT Base Amount (LCY)	Decimal	—	not editable
106	Bal. VAT Amount (LCY)	Decimal	—	not editable
107	Bal. VAT Base Amount (LCY)	Decimal	—	not editable
108	Reversing Entry	Boolean	—	not editable
109	Allow Zero-Amount Posting	Boolean	—	not editable
110	Ship-to/Order Address Code	Code[10]	—	TableRelation if (“Account Type” = const(Customer)) “Ship-to Address”.Code where(“Customer No.” = field(“Sell-to/Buy-from No.”)) else if (“Account Type” = const(Vendor)) “Order Address”.Code where(“Vendor No.” = field(“Sell-to/Buy-from No.”)) else if (“Bal. Account Type” = const(Customer)) “Ship-to Address”.Code …
111	VAT Difference	Decimal	—	not editable
112	Bal. VAT Difference	Decimal	—	not editable
480	Dimension Set ID	Integer	—	TableRelation Dimension Set Entry; not editable
5050	Campaign No.	Code[20]	—	TableRelation Campaign
5400	Prod. Order No.	Code[20]	—	not editable
5600	FA Posting Date	Date	—
5601	FA Posting Type	Option	—	OptionCaption: ,Acquisition Cost,Depreciation,Write-Down,Appreciation,Custom 1,Custom 2,Disposal,Maintenance
5602	Depreciation Book Code	Code[10]	—	TableRelation Depreciation Book
5603	Salvage Value	Decimal	—
5604	No. of Depreciation Days	Integer	—
5605	Depr. until FA Posting Date	Boolean	—
5606	Depr. Acquisition Cost	Boolean	—
5609	Maintenance Code	Code[10]	—	TableRelation Maintenance
5610	Insurance No.	Code[20]	—	TableRelation Insurance
5611	Budgeted FA No.	Code[20]	—	TableRelation Fixed Asset
5612	Duplicate in Depreciation Book	Code[10]	—	TableRelation Depreciation Book
5613	Use Duplication List	Boolean	—
5614	FA Reclassification Entry	Boolean	—
5615	FA Error Entry No.	Integer	—	TableRelation FA Ledger Entry
5616	Index Entry	Boolean	—
10000	Description 2	Text[50]	Description caption
10604	VAT Code	Code[10]	—	obsolete Removed 26.0; #if not CLEANSCHEMA26; TableRelation “VAT Code”.Code
10605	Bal. VAT Code	Code[10]	—	obsolete Removed 26.0; #if not CLEANSCHEMA26; TableRelation “VAT Code”.Code
10608	VAT Base Amount Type	Option	—	OptionCaption: Automatic,With VAT,Without VAT
10610	VAT Number	Code[20]	—	TableRelation “VAT Reporting Code”.Code
10611	Bal. VAT Number	Code[20]	—	TableRelation “VAT Reporting Code”.Code
15000000	Remittance Account Code	Code[10]	—	TableRelation “Remittance Account”.Code
15000001	BOLS Text Code	Option	—	OptionCaption: Transfer without advice,KID transfer,Transfer with advice,Money order,Salary,Seaman’s pay,Agricultural settlement,Pension/ Social security,Advice sent from institution other than BBS,Tax,Free text mass payment,Free text,Self-produced money order
15000002	Payment Type Code Domestic	Code[2]	—
15000003	KID	Code[30]	—
15000004	Recipient Ref. 1	Code[40]	—
15000005	Recipient Ref. 2	Code[40]	—
15000006	Recipient Ref. 3	Code[40]	—
15000007	Urgent	Boolean	—
15000008	Agreed Exch. Rate	Decimal	—
15000009	Agreed With	Code[6]	—
15000010	Futures Contract No.	Code[6]	—
15000011	Futures Contract Exch. Rate	Decimal	—
15000012	Check	Option	—	OptionCaption: No,Debit employer,Debit recipient
15000013	Recipient Ref. Foreign	Code[35]	—
15000014	Payment Type Code Foreign	Code[6]	—
15000015	Specification (Norges Bank)	Code[60]	—
15000016	Remittance Type	Option	—	OptionCaption: Domestic,Foreign; not editable
15000017	Payment Due Date	Date	—	not editable
15000018	Remittance Agreement Code	Code[10]	—	TableRelation “Remittance Agreement”.Code
15000019	Warning	Boolean	—
15000020	Warning Text	Text[100]	—
15000021	Payment Order ID - Settled	Integer	—	TableRelation “Remittance Payment Order”.ID
15000022	Payment Order ID - Approved	Integer	—	TableRelation “Remittance Payment Order”.ID
15000023	Payment Order ID - Sent	Integer	—	TableRelation “Remittance Payment Order”.ID
15000024	Remittance Status	Option	—	OptionCaption: ,Sent,Approved,Rejected,Settled,Error,Reseted
15000025	Reference	Integer	—
15000026	Return Code	Text[2]	—
15000027	Handling Ref.	Text[6]	—
15000028	Journal, Settlement Template	Code[10]	—
15000029	Journal - Settlement	Code[10]	—
15000030	Payment Order ID - Rejected	Integer	—	TableRelation “Remittance Payment Order”.ID
15000031	BBS Referance	Integer	—
15000032	BBS Shipment No.	Integer	—
15000033	BBS Payment Order No.	Integer	—
15000034	BBS Transaction No.	Integer	—
15000035	Cancellation Cause	Option	—	OptionCaption: ,Cancelled by the bank,Cancelled due to lack of funds,Expired unclaimed money order,Payee’s account closed or non-existent,Cancelled online by customer,Electronic cancellation sent in file by customer
15000036	Price Info	Option	—	OptionCaption: ,Debited account separately,Accumulated and debited/invoiced at intervals,Fees deducted from transferred amount
15000037	Execution Ref. 2	Text[12]	—
15000050	SEPA Msg. ID	Code[20]	—
15000051	SEPA Instr. ID	Code[20]	—
15000052	SEPA End To End ID	Code[20]	—
15000053	SEPA Payment Inf ID	Code[20]	—

Keys

Key1: Reference (clustered)
Key2: Futures Contract No., Line No.
Key3: Payment Order ID - Sent
Key4: Payment Order ID - Approved
Key5: Payment Order ID - Settled
Key6: Payment Order ID - Rejected
Key7: BBS Referance

Events published

OnAfterInitDefaultDimensionSources(var WaitingJournal: Record "Waiting Journal"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]) (integration)

Procedures

CopyLineDimensions(GenJnlLine: Record "Gen. Journal Line")
RecreateLineDimensions(var GenJnlLine: Record "Gen. Journal Line")
CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])
ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
LookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])
ShowDimensions()
GetWaitingJournalNotFoundForRemittanceImport(): Text[250]
WriteDescription(NewValue: Text)
ReadDescription(): Text
PerformTransferFieldsFromGenJournalLine(GenJournalLine: Record "Gen. Journal Line")
CreateDimFromDefaultDim(FromFieldNo: Integer)

Plus 1 local procedures.

Triggers

OnDelete

Deprecations

field Bal. VAT Code: Removed 26.0 (#if not CLEANSCHEMA26), “Use the field “Bal. VAT Number” instead”
field VAT Code: Removed 26.0 (#if not CLEANSCHEMA26), “Use the field “VAT Number” instead”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

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

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