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

Table 6121 "E-Document"

EDocument · Microsoft.eServices.EDocument

Across versions

  1. BC23-28not present
  2. BC29present
  3. BC30changed

Neighbourhood 39 connected objects and pages

Table 6125 "E-Doc. Data Storage" (relates to, 2 links)E-Doc. Data StorageTable 1222 "Data Exch. Def" (relates to)Data Exch. DefTable 1501 "Workflow" (relates to)Table 4 "Currency" (relates to)CurrencyTable 472 "Job Queue Entry" (relates to)Table 60 "Document Sending Profile" (relates to)Document Sending ProfileTable 6103 "E-Document Service" (relates to)Table 6138 "E-Document Service Status" (relates to)Page 6122 "E-Documents" (pages and codeunits on it, 3 links)E-DocumentsPage 6105 "Inbound E-Documents" (pages and codeunits on it)Inbound E-DocumentsPage 6106 "Outbound E-Documents" (pages and codeunits on it)Outbound E-DocumentsPage 6112 "E-Documents API" (pages and codeunits on it)E-Documents APIPage 6115 "New E-Documents API" (pages and codeunits on it)New E-Documents APIPage 6121 "E-Document" (pages and codeunits on it)Page 6166 "E-Doc. PO Copilot Prop" (pages and codeunits on it)E-Doc. PO Copilot PropPage 6167 "E-Doc. Order Line Matching" (pages and codeunits on it)E-Doc. Order Line MatchingPage 6181 "E-Document Purchase Draft" (pages and codeunits on it)E-Document Purchase DraftTable 6110 "E-Document Line - Field" (referenced by, 2 links)E-Document Line - FieldTable 6100 "E-Document Purchase Header" (referenced by)E-Document Purchase HeaderTable 6101 "E-Document Purchase Line" (referenced by)Table 6102 "E-Document Header Mapping" (referenced by)Table 6105 "E-Document Line Mapping" (referenced by)Table 6111 "EDoc Line Match Buffer" (referenced by)Table 6123 "E-Doc. Mapping Log" (referenced by)Table 6124 "E-Document Log" (referenced by)Table 6127 "E-Document Integration Log" (referenced by)Table 6130 "E-Doc. File Content API Buffer" (referenced by)Table 6138 "E-Document Service Status" (referenced by)Table 6153 "E-Document Sales Header" (referenced by)Table 6154 "E-Document Sales Line" (referenced by)Table 6163 "E-Doc. PO Match Prop. Buffer" (referenced by)Table 6164 "E-Doc. Order Match" (referenced by)Table 6165 "E-Doc. Imported Line" (referenced by)Table 6432 "E-Document Message" (referenced by)Table 6433 "E-Doc. Payment Occurrence" (referenced by)Table 6434 "E-Doc. External Reference" (referenced by)Table extension 6160 "E-Doc. Attachment" (referenced by)Use e-documents in sales (Learn pages)Use E-Documents in the purchase process (Learn pages)

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 · BC29-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 6121 “E-Document” (2 Learn pages), Page 6167 “E-Doc. Order Line Matching” (1).

Properties

Property Value
DataClassification CustomerContent
LookupPageId E-Documents
DrillDownPageId E-Documents
Permissions tabledata “E-Document” = i, tabledata “E-Document Service Status” = d, tabledata “E-Document Log” = d, tabledata “E-Document Integration Log” = d, tabledata “E-Doc. Mapping Log” = d

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 unique number of the document. via Page 6105 “Inbound E-Documents” AutoIncrement
2 Document Record ID RecordId — DataClassification SystemMetadata
3 Bill-to/Pay-to No. Code[20] Specifies the customer/vendor of the electronic document. via Page 6121 “E-Document”
4 Bill-to/Pay-to Name Text[100] Specifies the customer/vendor name of the electronic document. via Page 6121 “E-Document” not editable
5 Document No. Code[20] Specifies the document number of the electronic document. via Page 6121 “E-Document” not editable
6 Document Type Enum “E-Document Type” Specifies the electronic document type. via Page 6121 “E-Document” enum Enum 6121 “E-Document Type”; not editable
7 Document Date Date Specifies the document date of the electronic document. via Page 6121 “E-Document” not editable
8 Due Date Date Specifies the due date of the electronic document. via Page 6121 “E-Document” not editable
9 Amount Incl. VAT Decimal Specifies the total amount of the electronic document including VAT. via Page 6121 “E-Document” not editable
10 Amount Excl. VAT Decimal Specifies the total amount of the electronic document excluding VAT. via Page 6121 “E-Document” not editable
11 Index In Batch Integer — not editable
12 Order No. Code[20] Specifies the related order number of the electronic document. via Page 6121 “E-Document”
13 Posting Date Date Specifies the electronic document posting date. via Page 6121 “E-Document” not editable
14 Direction Enum “E-Document Direction” Specifies the direction of the electronic document. via Page 6121 “E-Document” enum Enum 6102 “E-Document Direction”; not editable
15 Incoming E-Document No. Text[50] Specifies the electronic document number. via Page 6121 “E-Document” not editable
16 Table ID Integer — not editable; DataClassification SystemMetadata
17 Table Name Text[250] Document Table Name caption FlowField: lookup(AllObjWithCaption.“Object Caption” where(“Object Type” = const(Table), “Object ID” = field(“Table ID”))); not editable
18 Status Enum “E-Document Status” Specifies the status of the electronic document. via Page 6121 “E-Document” enum Enum 6108 “E-Document Status”
19 Document Sending Profile Code[20] — TableRelation Table 60 “Document Sending Profile” (Document Sending Profile)
20 Source Type enum “E-Document Source Type” — enum Enum 6123 “E-Document Source Type”
21 Data Exch. Def. Code Code[20] — TableRelation Table 1222 “Data Exch. Def” (Data Exch. Def)
22 Receiving Company VAT Reg. No. Text[20] Specifies the receiving company VAT number. via Page 6121 “E-Document”
23 Receiving Company GLN Code[13] Specifies the receiving company GLN. via Page 6121 “E-Document”
24 Receiving Company Name Text[150] Specifies the receiving company name. via Page 6121 “E-Document”
25 Receiving Company Address Text[200] Specifies the receiving company address. via Page 6121 “E-Document”
26 Currency Code Code[10] Specifies the electronic document currency code. via Page 6121 “E-Document” TableRelation Table 4 “Currency”; not editable
27 Workflow Code Code[20] Specifies the Workflow used on the electronic document. via Page 6121 “E-Document” TableRelation Table 1501 “Workflow” (Workflow where(Template = const(false), Category = const(‘EDOC’)))
28 Workflow Step Instance ID Guid — DataClassification SystemMetadata
29 Job Queue Entry ID Guid — TableRelation Table 472 “Job Queue Entry” (Job Queue Entry); DataClassification SystemMetadata
30 Journal Line System ID Guid — DataClassification SystemMetadata
31 Receiving Company Id Text[250] Specifies the receiving company id, such as PEPPOL id, or other identifiers used in the electronic document exchange.
32 Unstructured Data Entry No. Integer Specifies the content that is not structured, such as PDF TableRelation Table 6125 “E-Doc. Data Storage” (E-Doc. Data Storage)
33 Structured Data Entry No. Integer Specifies the content that is structured, such as XML TableRelation Table 6125 “E-Doc. Data Storage” (E-Doc. Data Storage)
34 Service Code[20] Specifies the service that is used to process the E-Document. TableRelation Table 6103 “E-Document Service” (E-Document Service); not editable
35 File Name Text[256] Specifies the file name of the E-Document source.
36 File Type Integer Specifies the file type of the E-Document source. obsolete Removed 26.0; #if not CLEANSCHEMA26
37 Structured Data Process Integer Specifies the structured data process to run on the E-Document data. obsolete Removed 26.0; #if not CLEANSCHEMA26
38 Service Integration Enum “Service Integration” Specifies the service integration to use for the E-Document. enum Enum 6151 “Service Integration”; not editable
39 Source Details Text[2048] Specifies details about the the E-Document source.
40 Additional Source Details Text[2048] Specifies additional details about the E-Document source.
41 Import Processing Status Enum “Import E-Doc. Proc. Status” Specifies the E-Document import processing status. FlowField: lookup(“E-Document Service Status”.“Import Processing Status” where(“E-Document Entry No” = field(“Entry No”))); enum Enum 6100 “Import E-Doc. Proc. Status”
42 Structure Data Impl. Enum “Structure Received E-Doc.” Specifies the implementation to use for structuring the E-Document data. enum Enum 6103 “Structure Received E-Doc.”
43 Read into Draft Impl. Enum “E-Doc. Read into Draft” Specifies the implementation to use for reading the E-Document data into a draft. enum Enum 6109 “E-Doc. Read into Draft”
44 Process Draft Impl. Enum “E-Doc. Process Draft” Specifies the implementation to use for processing the draft received. enum Enum 6107 “E-Doc. Process Draft”
45 Receiving Company Reg. No. Text[20] Receiving Company Registration No. caption
60 Clearance Date DateTime Specifies date and time when document was cleared by authority DataClassification SystemMetadata
61 Last Clearance Request Time DateTime Specifies the last time a clearance request was made via Page 6121 “E-Document” DataClassification SystemMetadata

Keys

  • Key1: Entry No (clustered)
  • Key2: Document Record ID
  • Key3: Incoming E-Document No., Bill-to/Pay-to No., Document Date, Entry No
  • Key4: SystemCreatedAt
  • DueDate: Due Date

Procedures

  • Create(EDocumentDirection: Enum "E-Document Direction"; EDocumentType: Enum "E-Document Type"; EDocumentService: Record "E-Document Service") (internal): Inserts a new E-Document record with the specified parameters.
  • IsDuplicate(ShowMessage: Boolean): Boolean (internal)
  • IsEDocumentCreatedForRecord(RecordVariant: Variant): Boolean: Checks if an E-Document is created for the given document record.
  • IsSourceDocumentStructured(): Boolean (internal)
  • GetTotalAmountIncludingVAT(): Decimal (internal)
  • DeleteOrphanedImport() (internal)
  • CleanupDocument()
  • ExportDataStorage() (internal)
  • ViewSourceFile()
  • TryGetExportedFileLog(var EDocumentLog: Record "E-Document Log"): Boolean (internal)
  • OpenEDocument(EDocumentRecordId: RecordId) (internal)
  • ShowRecord() (internal)
  • GetEDocumentServiceStatus(): Record "E-Document Service Status" (internal)
  • GetEDocumentService(): Record "E-Document Service"
  • GetEDocumentImportProcessingStatus(): Enum "Import E-Doc. Proc. Status" (obsolete 27.0: Use flow field “Import Processing Status”)
  • ToString(): Text (internal)

Triggers

OnDelete

Relations

Referenced by

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

Pages and codeunits on this table

Recent changes

Deprecations

  • field File Type: Removed 26.0 (#if not CLEANSCHEMA26), “Use File Format in the “E-Doc. Data Storage” table instead.”
  • field Structured Data Process: Removed 26.0 (#if not CLEANSCHEMA26), “Use “Process Draft Impl.” field instead.”
  • procedure GetEDocumentImportProcessingStatus: Pending 27.0 (#if not CLEAN27), “Use flow field “Import Processing Status””

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

Evidence 1 sources