tableAL Developmentofficial - Microsoftderived - from the source, no model text

Table 456 "Posted Approval Entry"

Base Application · System.Automation

Across versions

  1. BC23present
  2. BC24declaration changed
  3. BC25-26unchanged
  4. BC271 fields changed
  5. BC283 fields added, 2 fields changed
  6. BC29-30unchanged

Neighbourhood 8 connected objects and pages

Table 13 "Salesperson/Purchaser" (relates to)Salesperson/PurchaserTable 4 "Currency" (relates to)CurrencyTable 457 "Posted Approval Comment Line" (relates to)Posted Approval Comment LinePage 659 "Posted Approval Entries" (pages and codeunits on it, 3 links)Posted Approval EntriesPage 30093 "APIV2 - Pstd. Approval Entries" (pages and codeunits on it)APIV2 - Pstd. Approval EntriesCodeunit 700 "Page Management" (calls)Page ManagementGet Posted Approval Entries with the Business Central API (Learn pages)Get Posted Approval Entries …postedApprovalEntry Resource Type (Learn pages)postedApprovalEntry Resource…

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.

Base Application · System.Automation · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 30093 “APIV2 - Pstd. Approval Entries” (2 Learn pages).

Properties

Property Value
Caption Posted Approval Entry
DataClassification CustomerContent
LookupPageId Posted Approval Entries
DrillDownPageId Posted Approval Entries

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 Table ID Integer Specifies the ID of the table where the record that is subject to approval is stored. via Page 659 “Posted Approval Entries”
3 Document No. Code[20] Specifies the document number copied from the relevant sales or purchase document, such as a purchase order or a sales quote. via Page 659 “Posted Approval Entries”
4 Sequence No. Integer Specifies the order of approvers when an approval workflow involves more than one approver. via Page 659 “Posted Approval Entries”
5 Approval Code Code[20] —
6 Sender ID Code[50] Specifies the ID of the user who sent the approval request for the document to be approved. via Page 659 “Posted Approval Entries” TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
7 Salespers./Purch. Code Code[20] Specifies the code for the salesperson or purchaser that was in the document to be approved. It is not a mandatory field, but is useful if a salesperson or a purchaser responsible for the customer/vendor needs to approve the document before it is sent. via Page 659 “Posted Approval Entries”
8 Approver ID Code[50] Specifies the ID of the user who must approve the document. via Page 659 “Posted Approval Entries” TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
9 Status Enum “Approval Status” Specifies the approval status for the entry: via Page 659 “Posted Approval Entries” enum Enum 455 “Approval Status”
10 Date-Time Sent for Approval DateTime Specifies the date and the time that the document was sent for approval. via Page 659 “Posted Approval Entries”
11 Last Date-Time Modified DateTime Specifies the date when the approval entry was last modified. If, for example, the document approval is canceled, this field will be updated accordingly. via Page 659 “Posted Approval Entries”
12 Last Modified By ID Code[50] Specifies the ID of the person who last modified the approval entry. If, for example, the document approval is canceled, this field will be updated accordingly. via Page 659 “Posted Approval Entries” TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
13 Comment Boolean Specifies whether there are comments related to the approval of the document. If you want to read the comments, click the field to open the Comment Sheet window. via Page 659 “Posted Approval Entries” FlowField: exist(“Posted Approval Comment Line” where(“Table ID” = field(“Table ID”), “Document No.” = field(“Document No.”), “Posted Record ID” = field(“Posted Record ID”))); not editable
14 Due Date Date Specifies the date when the document is due for approval by the approver. via Page 659 “Posted Approval Entries”
15 Amount Decimal —
16 Amount (LCY) Δ BC28 Decimal Specifies the total amount (excl. VAT) on the document waiting for approval. The amount is stated in the local currency. via Page 659 “Posted Approval Entries”
17 Currency Code Code[10] Specifies the code of the currency of the amounts on the sales or purchase lines. via Page 659 “Posted Approval Entries” TableRelation Table 4 “Currency”
18 Approval Type Enum “Workflow Approval Type” — enum Enum 458 “Workflow Approval Type”
19 Limit Type Enum “Workflow Approval Limit Type” — enum Enum 457 “Workflow Approval Limit Type”
20 Available Credit Limit (LCY) Δ BC27 Δ BC28 Decimal —
22 Posted Record ID RecordID —
23 Delegation Date Formula DateFormula Specifies for the posted approval entry when an overdue approval request was automatically delegated to the relevant substitute. The field is filled with the value in the Delegate After field in the Workflow Responses window, translated to a date formula. The date of automatic delegation is then cal… via Page 659 “Posted Approval Entries”
26 Number of Approved Requests Integer —
27 Number of Rejected Requests Integer —
28 Iteration No. Integer Specifies the number of handling iterations that this approval request has reached. via Page 659 “Posted Approval Entries”
29 Entry No. Integer — AutoIncrement
32 Approver Full Name + BC28 Text[80] — FlowField: lookup(User.“Full Name” where(“User Name” = field(“Approver ID”)))
33 Sender Full Name + BC28 Text[80] — FlowField: lookup(User.“Full Name” where(“User Name” = field(“Sender ID”)))
34 Salespers./Purch. Name + BC28 Text[80] Salespers./Purch. Full Name caption FlowField: lookup(“Salesperson/Purchaser”.Name where(“Code” = field(“Salespers./Purch. Code”)))

Keys

  • Key1: Entry No. (clustered)
  • Key2: Posted Record ID

Procedures

  • ShowRecord()

Triggers

OnDelete

Relations

Pages and codeunits on this table

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.

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

Evidence 1 sources