tableIntegration & APIsofficial - Microsoftderived - from the source, no model text

Table 6101 "E-Document Purchase Line"

EDocument · Microsoft.eServices.EDocument.Processing.Import.Purchase

Across versions

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

Neighbourhood 21 connected objects and pages

Table 349 "Dimension Value" (relates to, 2 links)Dimension ValueTable 15 "G/L Account" (relates to)G/L AccountTable 1700 "Deferral Template" (relates to)Deferral TemplateTable 204 "Unit of Measure" (relates to)Unit of MeasureTable 324 "VAT Product Posting Group" (relates to)VAT Product Posting GroupTable 480 "Dimension Set Entry" (relates to)Dimension Set EntryTable 5401 "Item Variant" (relates to)Item VariantTable 5600 "Fixed Asset" (relates to)Fixed AssetTable 5777 "Item Reference" (relates to)Item ReferenceTable 6121 "E-Document" (relates to)E-DocumentTable 6140 "E-Doc. Purchase Line History" (relates to)E-Doc. Purchase Line HistoryTable 7 "Standard Text" (relates to)Standard TextCodeunit 6105 "E-Doc. Similar Descriptions" (pages and codeunits on it)E-Doc. Similar DescriptionsCodeunit 6126 "E-Doc. GL Account Matching" (pages and codeunits on it)E-Doc. GL Account MatchingCodeunit 6129 "E-Doc. Deferral Matching" (pages and codeunits on it)Codeunit 6177 "E-Doc. Historical Matching" (pages and codeunits on it)Page 6102 "E-Doc Line Values." (pages and codeunits on it)Page 6183 "E-Doc. Purchase Draft Subform" (pages and codeunits on it)Page 6184 "E-Doc. Read. Purch. Lines" (pages and codeunits on it)Table 6114 "E-Doc. Purchase Line PO Match" (referenced by)Table 6117 "E-Doc. Finalized PO Match" (referenced by)

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.

EDocument · Microsoft.eServices.EDocument.Processing.Import.Purchase · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property Value
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 E-Document Entry No. Integer — TableRelation Table 6121 “E-Document” (“E-Document”.“Entry No”); not editable; DataClassification SystemMetadata
2 Line No. Integer — not editable; DataClassification SystemMetadata
3 Date Date Specifies the date of this line. via Page 6184 “E-Doc. Read. Purch. Lines” not editable
4 Product Code Text[100] Specifies the product code of this line. via Page 6184 “E-Doc. Read. Purch. Lines” not editable
5 Description Text[100] Specifies the description. not editable
6 Quantity Decimal Specifies the quantity. not editable
7 Unit of Measure Text[50] Specifies the unit of measure of this line. via Page 6184 “E-Doc. Read. Purch. Lines” not editable
8 Unit Price Decimal Specifies the direct unit cost. not editable
9 Sub Total Decimal Specifies the line subtotal.
10 Total Discount Decimal Specifies the line discount.
11 VAT Rate Decimal Specifies the VAT rate of this line. via Page 6184 “E-Doc. Read. Purch. Lines” not editable
12 Currency Code Code[10] Specifies the currency code of this line. via Page 6184 “E-Doc. Read. Purch. Lines” not editable
101 [BC] Purchase Line Type Enum “Purchase Line Type” Specifies the type of entity that will be posted for this purchase line, such as Item, Resource, or G/L Account. enum Enum 39 “Purchase Line Type”
102 [BC] Purchase Type No. Code[20] Specifies what you’re selling. The options vary, depending on what you choose in the Type field. TableRelation Table 15 “G/L Account”, Table 5600 “Fixed Asset”, Table 7 “Standard Text” (if (“[BC] Purchase Line Type” = const(” “)) “Standard Text” else if (“[BC] Purchase Line Type” = const(“G/L Account”)) “G/L Account” where(“Direct Posting” = const(true)) else if (“[BC] Purchase Line Type” = const(“Fixed Asset”)) “Fixed Asset” else if (“[BC] Purchase Line Type” = const(“Charge (Item…)
103 [BC] Unit of Measure Code[20] Specifies the unit of measure code. TableRelation Table 204 “Unit of Measure” (Unit of Measure)
104 [BC] Deferral Code Code[10] Specifies the deferral code. TableRelation Table 1700 “Deferral Template” (Deferral Template)
105 [BC] Shortcut Dimension 1 Code Code[20] Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window. TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false)))
106 [BC] Shortcut Dimension 2 Code Code[20] Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window. TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false)))
107 [BC] Item Reference No. Code[50] Specifies the item reference number. TableRelation Table 5777 “Item Reference” (“Item Reference”.“Reference No.” where(“Unit of Measure” = field(“[BC] Unit of Measure”), “Variant Code” = field(“[BC] Variant Code”)))
108 [BC] Variant Code Code[10] Specifies the variant code. TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“[BC] Purchase Type No.”)))
109 [BC] Dimension Set ID Integer Dimension Set ID caption TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable
110 [BC] VAT Prod. Posting Group Code[20] Specifies the VAT product posting group resolved from the extracted VAT rate. TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group)
201 E-Doc. Purch. Line History Id Integer Specifies the ID of the e-document purchase line history. TableRelation Table 6140 “E-Doc. Purchase Line History” (“E-Doc. Purchase Line History”.“Entry No.”); DataClassification SystemMetadata

Keys

  • PK: E-Document Entry No., Line No. (clustered)
  • Key1: [BC] Purchase Type No.

Events published

  • OnAfterGetMatchedEntityName(EDocumentPurchaseLine: Record "E-Document Purchase Line"; var EntityName: Text[100]) (integration)

Procedures

  • GetMatchedEntityName(): Text[100] (internal): Returns the name of the entity (Item, G/L Account, Resource, etc.) that this line is matched to, resolved from the “[BC] Purchase Line Type” and “[BC] Purchase Type No.” fields
  • GetNextLineNo(EDocumentEntryNo: Integer): Integer
  • AdditionalColumnsDisplayText(): Text (internal): Returns any additional columns defined for this line in a human-readable format.
  • LookupDimensions(): Boolean (internal)
  • GetFromLinkedPurchaseLine(PurchaseLine: Record "Purchase Line"): Boolean (internal)
  • GetLinkedPurchaseLine(): Record "Purchase Line" (internal)
  • GetEDocumentPurchaseHeader(): Record "E-Document Purchase Header"
  • GetBCVendor(): Record Vendor
  • LogVATRateMismatch(VendVATBusPostingGroupCode: Code[20]; VATRate: Decimal) (internal)
  • LogVATRateResolved(VendVATBusPostingGroupCode: Code[20]; VATRate: Decimal) (internal)

Plus 2 local procedures.

Triggers

OnDelete

Relations

Referenced by

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

Pages and codeunits on this table

Recent changes

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

Evidence 1 sources