tableSustainabilityofficial - Microsoftderived - from the source, no model text

Table 6241 "Sust. Excise Taxes Trans. Log"

Sustainability · Microsoft.Sustainability.ExciseTax

Across versions

  1. BC23-28not present
  2. BC29-30present

Neighbourhood 20 connected objects and pages

Table 480 "Dimension Set Entry" (relates to, 7 links)Dimension Set EntryTable 204 "Unit of Measure" (relates to, 3 links)Unit of MeasureTable 349 "Dimension Value" (relates to, 2 links)Dimension ValueTable 15 "G/L Account" (relates to)G/L AccountTable 18 "Customer" (relates to)Table 23 "Vendor" (relates to)VendorTable 27 "Item" (relates to)ItemTable 32 "Item Ledger Entry" (relates to)Item Ledger EntryTable 5600 "Fixed Asset" (relates to)Fixed AssetTable 5714 "Responsibility Center" (relates to)Table 6210 "Sustainability Account" (relates to)Sustainability AccountTable 6211 "Sustain. Account Category" (relates to)Sustain. Account CategoryTable 6212 "Sustain. Account Subcategory" (relates to)Sustain. Account SubcategoryTable 6238 "Sust. Excise Journal Template" (relates to)Sust. Excise Journal TemplateTable 6239 "Sust. Excise Journal Batch" (relates to)Sust. Excise Journal BatchTable 9 "Country/Region" (relates to)Page 6288 "Sust. Excise Taxes Trans. Logs" (pages and codeunits on it, 2 links)Sust. Excise Taxes Trans. LogsTable extension 7414 "Excise Taxes Trans. Log Ext" (extended by)Codeunit 7413 "Excise Tax Trans Subscriber" (event subscribers)Codeunit 408 "DimensionManagement" (calls)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

Sustainability · Microsoft.Sustainability.ExciseTax · captioned “Excise Taxes Transaction Log” · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property Value
Caption Excise Taxes Transaction Log
DataClassification CustomerContent
LookupPageId Sust. Excise Taxes Trans. Logs

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 entry number of the Excise Taxes Transaction Logs. via Page 6288 “Sust. Excise Taxes Trans. Logs” AutoIncrement
2 Journal Template Name Code[10] Specifies the name of the journal template. via Page 6288 “Sust. Excise Taxes Trans. Logs” TableRelation Table 6238 “Sust. Excise Journal Template” (Sust. Excise Journal Template)
3 Journal Batch Name Code[10] Specifies the name of the journal batch. via Page 6288 “Sust. Excise Taxes Trans. Logs” TableRelation Table 6239 “Sust. Excise Journal Batch” (“Sust. Excise Journal Batch”.Name where(“Journal Template Name” = field(“Journal Template Name”)))
5 Log Type Enum “Sust. Excise Jnl. Tax Type” Specifies the value of the Log Type field. via Page 6288 “Sust. Excise Taxes Trans. Logs” enum Enum 6226 “Sust. Excise Jnl. Tax Type”
10 Entry Type Enum “Sust. Excise Jnl. Entry Type” Specifies the value of the Entry Type field. via Page 6288 “Sust. Excise Taxes Trans. Logs” enum Enum 6228 “Sust. Excise Jnl. Entry Type”
11 Posting Date Date Specifies the date when the transaction is posted. via Page 6288 “Sust. Excise Taxes Trans. Logs” NotBlank
12 Document Type Enum “Sust. Excise Document Type” Specifies the type of the document. via Page 6288 “Sust. Excise Taxes Trans. Logs” enum Enum 6229 “Sust. Excise Document Type”
15 Document No. Code[20] Specifies the document number. via Page 6288 “Sust. Excise Taxes Trans. Logs” NotBlank
16 Account No. Code[20] Specifies the sustainability account number. via Page 6288 “Sust. Excise Taxes Trans. Logs” obsolete Pending 28.0; #if not CLEANSCHEMA29; TableRelation Table 6210 “Sustainability Account” (“Sustainability Account” where(“Account Type” = const(Posting), Blocked = const(false)))
17 Account Name Text[100] Specifies the sustainability account name. via Page 6288 “Sust. Excise Taxes Trans. Logs” obsolete Pending 28.0; #if not CLEANSCHEMA29
18 Account Category Code[20] Specifies the sustainability account category. via Page 6288 “Sust. Excise Taxes Trans. Logs” obsolete Pending 28.0; #if not CLEANSCHEMA29; TableRelation Table 6211 “Sustain. Account Category” (Sustain. Account Category); not editable
19 Account Subcategory Code[20] Specifies the sustainability account subcategory. via Page 6288 “Sust. Excise Taxes Trans. Logs” obsolete Pending 28.0; #if not CLEANSCHEMA29; TableRelation Table 6212 “Sustain. Account Subcategory” (“Sustain. Account Subcategory”.Code where(“Category Code” = field(“Account Category”)))
20 Description Text[100] Specifies the description of the journal line. via Page 6288 “Sust. Excise Taxes Trans. Logs”
21 Partner Type Enum “Sust. Excise Jnl. Partner Type” Specifies the value of the Partner Type field. via Page 6288 “Sust. Excise Taxes Trans. Logs” enum Enum 6231 “Sust. Excise Jnl. Partner Type”
22 Partner No. Code[20] Specifies the value of the Partner No. field. via Page 6288 “Sust. Excise Taxes Trans. Logs” TableRelation Table 18 “Customer”, Table 23 “Vendor” (if (“Partner Type” = const(Vendor)) Vendor else if (“Partner Type” = const(Customer)) Customer)
25 Source Type Enum “Sust. Excise Jnl. Source Type” Specifies the value of the Source Type field. via Page 6288 “Sust. Excise Taxes Trans. Logs” enum Enum 6230 “Sust. Excise Jnl. Source Type”
26 Source No. Code[20] Specifies the value of the Source No. field. via Page 6288 “Sust. Excise Taxes Trans. Logs” TableRelation Table 15 “G/L Account”, Table 27 “Item”, Table 5600 “Fixed Asset” (if (“Source Type” = const(Item)) Item else if (“Source Type” = const(“G/L Account”)) “G/L Account” where(“Direct Posting” = const(true), “Account Type” = const(Posting), Blocked = const(false)) else if (“Source Type” = const(“Fixed Asset”)) “Fixed Asset” else if (“Source Type” = const(“Charge (Item)…)
27 Source Description Text[100] Specifies the value of the Source Description field. via Page 6288 “Sust. Excise Taxes Trans. Logs”
28 Source Unit of Measure Code Code[10] Specifies the value of the Source Unit of Measure field. via Page 6288 “Sust. Excise Taxes Trans. Logs” TableRelation Table 204 “Unit of Measure” (Unit of Measure)
29 Source Qty. Decimal Specifies the value of the Source Qty. field. via Page 6288 “Sust. Excise Taxes Trans. Logs”
40 Material Breakdown No. Code[20] Specifies the value of the Material Breakdown No. field. via Page 6288 “Sust. Excise Taxes Trans. Logs”
41 Material Breakdown Description Text[100] Specifies the value of the Material Breakdown Description field. via Page 6288 “Sust. Excise Taxes Trans. Logs”
42 Material Breakdown Weight Decimal Specifies the value of the Material Breakdown Weight field. via Page 6288 “Sust. Excise Taxes Trans. Logs”
43 Material Breakdown UOM Code[10] Specifies the value of the Material Breakdown Unit of Measure field. via Page 6288 “Sust. Excise Taxes Trans. Logs” TableRelation Table 204 “Unit of Measure” (Unit of Measure)
50 Total Embedded CO2e Emission Decimal Specifies the value of the Total Embedded CO2e Emission field. via Page 6288 “Sust. Excise Taxes Trans. Logs”
51 CO2e Unit of Measure Code[10] Specifies the value of the CO2e Unit of Measure field. via Page 6288 “Sust. Excise Taxes Trans. Logs” TableRelation Table 204 “Unit of Measure” (Unit of Measure)
60 CBAM Certificates Required Boolean Specifies the value of the CBAM Certificates Required field. via Page 6288 “Sust. Excise Taxes Trans. Logs”
61 Total Emission Cost Decimal Specifies the value of the Total Emission Cost field. via Page 6288 “Sust. Excise Taxes Trans. Logs”
65 Carbon Pricing Paid Boolean Specifies the value of the Carbon Pricing Paid field. via Page 6288 “Sust. Excise Taxes Trans. Logs”
70 Already Paid Emission Decimal Specifies the value of the Already Paid Emission field. via Page 6288 “Sust. Excise Taxes Trans. Logs”
80 Adjusted CBAM Cost Decimal Specifies the value of the Adjusted CBAM Cost field. via Page 6288 “Sust. Excise Taxes Trans. Logs”
90 Certificate Amount Decimal Specifies the value of the Certificate Amount field. via Page 6288 “Sust. Excise Taxes Trans. Logs”
100 Qty. per Unit of Measure Decimal — not editable
110 Country/Region Code Code[10] Specifies the country/region code of the entry. via Page 6288 “Sust. Excise Taxes Trans. Logs” TableRelation Table 9 “Country/Region” (Country/Region)
120 Source Document No. Code[20] —
121 Source Document Line No. Integer — not editable
130 Responsibility Center Code[10] Specifies the responsibility center of the entry. via Page 6288 “Sust. Excise Taxes Trans. Logs” TableRelation Table 5714 “Responsibility Center” (Responsibility Center)
140 Global Dimension 1 Code Code[20] Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. via Page 6288 “Sust. Excise Taxes Trans. Logs” TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1)))
150 Global Dimension 2 Code Code[20] Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. via Page 6288 “Sust. Excise Taxes Trans. Logs” TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2)))
200 Source Code Code[10] — TableRelation Source Code
201 Reason Code Code[10] — TableRelation Reason Code
480 Dimension Set ID Integer — TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry)
500 Item Ledger Entry No. Integer Specifies the related item ledger entry number. via Page extension 7416 “Excise Tax Trans Log Ext” TableRelation Table 32 “Item Ledger Entry” (Item Ledger Entry)
5156 Shortcut Dimension 3 Code Code[20] Specifies the code for Shortcut Dimension 3, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 6288 “Sust. Excise Taxes Trans. Logs” FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(3)))
5157 Shortcut Dimension 4 Code Code[20] Specifies the code for Shortcut Dimension 4, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 6288 “Sust. Excise Taxes Trans. Logs” FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(4)))
5158 Shortcut Dimension 5 Code Code[20] Specifies the code for Shortcut Dimension 5, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 6288 “Sust. Excise Taxes Trans. Logs” FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(5)))
5159 Shortcut Dimension 6 Code Code[20] Specifies the code for Shortcut Dimension 6, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 6288 “Sust. Excise Taxes Trans. Logs” FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(6)))
5160 Shortcut Dimension 7 Code Code[20] Specifies the code for Shortcut Dimension 7, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 6288 “Sust. Excise Taxes Trans. Logs” FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(7)))
5161 Shortcut Dimension 8 Code Code[20] Specifies the code for Shortcut Dimension 8, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 6288 “Sust. Excise Taxes Trans. Logs” FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(8)))
5170 Calculated Date Date —
5171 Calculated By Code[50] — TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation

Keys

  • PK: Entry No. (clustered)

Events published

  • OnAfterCopyFromSustainabilityExciseJnlLine(var SustExciseTaxesTransactionLog: Record "Sust. Excise Taxes Trans. Log"; SustainabilityExciseJnlLine: Record "Sust. Excise Jnl. Line") (integration)

Procedures

  • CopyFromSustainabilityExciseJnlLine(SustainabilityExciseJnlLine: Record "Sust. Excise Jnl. Line")

Plus 1 local procedures.

Relations

Pages and codeunits on this table

Extended by

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Recent changes

Deprecations

  • field Account Category: Pending 28.0 (#if not CLEANSCHEMA29), “This field is no longer required and will be removed in a future release.”
  • field Account Name: Pending 28.0 (#if not CLEANSCHEMA29), “This field is no longer required and will be removed in a future release.”
  • field Account No.: Pending 28.0 (#if not CLEANSCHEMA29), “This field is no longer required and will be removed in a future release.”
  • field Account Subcategory: Pending 28.0 (#if not CLEANSCHEMA29), “This field is no longer required and will be removed in a future release.”

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). The call sections above are our own, per object, from the BC29 call graph. 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: "Sust. Excise Taxes Trans. Log"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources