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

Table 1572 "Approval Entry Buffer"

Base Application · System.Automation

Across versions

  1. BC23-27not present
  2. BC28added
  3. BC29-30unchanged

Neighbourhood 8 connected objects and pages

Table 454 "Approval Entry" (relates to, 3 links)Approval EntryTable 13 "Salesperson/Purchaser" (relates to)Salesperson/PurchaserTable 1525 "Workflow - Record Change" (relates to)Workflow - Record ChangeTable 4 "Currency" (relates to)CurrencyPage 30443 "Approval Entry Overview" (pages and codeunits on it)Approval Entry OverviewCodeunit 1535 "Approvals Mgmt." (calls)Approvals Mgmt.Codeunit 700 "Page Management" (calls)Page ManagementPage 661 "Posted Approval Comments" (calls)Posted Approval Comments

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

Properties

Property Value
Caption Approval Entry Buffer
TableType Temporary
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 Table ID Integer Specifies the ID of the table where the record that is subject to approval is stored. via Page 30443 “Approval Entry Overview”
2 Document Type Enum “Approval Document Type” Specifies the type of document that an approval entry has been created for. Approval entries can be created for six different types of sales or purchase documents: via Page 30443 “Approval Entry Overview” enum Enum 454 “Approval Document Type”
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 30443 “Approval Entry Overview”
4 Sequence No. Integer Specifies the order of approvers when an approval workflow involves more than one approver. via Page 30443 “Approval Entry Overview”
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 30443 “Approval Entry Overview” 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 30443 “Approval Entry Overview”
8 Approver ID Code[50] Specifies the ID of the user who must approve the document. via Page 30443 “Approval Entry Overview” TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
9 Status Enum “Approval Status” Specifies the approval status for the entry: via Page 30443 “Approval Entry Overview” 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 30443 “Approval Entry Overview”
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 30443 “Approval Entry Overview”
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 30443 “Approval Entry Overview” 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 30443 “Approval Entry Overview” not editable
14 Due Date Date Specifies the date when the document is due for approval by the approver. via Page 30443 “Approval Entry Overview”
15 Amount Decimal —
16 Amount (LCY) Decimal Specifies the total amount (excl. VAT) on the document waiting for approval. The amount is stated in the local currency. via Page 30443 “Approval Entry Overview”
17 Currency Code Code[10] Specifies the code of the currency of the amounts on the sales or purchase lines. via Page 30443 “Approval Entry Overview” TableRelation Table 4 “Currency”
18 Approval Type Enum “Workflow Approval Type” Specifies which approvers apply to this approval template: via Page 30443 “Approval Entry Overview” enum Enum 458 “Workflow Approval Type”
19 Limit Type Enum “Workflow Approval Limit Type” Specifies the type of limit that applies to the approval template: via Page 30443 “Approval Entry Overview” enum Enum 457 “Workflow Approval Limit Type”
20 Available Credit Limit (LCY) Decimal Specifies the remaining credit (in LCY) that exists for the customer. via Page 30443 “Approval Entry Overview”
21 Pending Approvals Integer — FlowField: count(“Approval Entry” where(“Record ID to Approve” = field(“Record ID”), Status = filter(Created | Open), “Workflow Step Instance ID” = field(“Workflow Step Instance ID”)))
22 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 30443 “Approval Entry Overview”
26 Number of Approved Requests Integer — FlowField: count(“Approval Entry” where(“Record ID to Approve” = field(“Record ID”), Status = filter(Approved), “Workflow Step Instance ID” = field(“Workflow Step Instance ID”)))
27 Number of Rejected Requests Integer — FlowField: count(“Approval Entry” where(“Record ID to Approve” = field(“Record ID”), Status = filter(Rejected), “Workflow Step Instance ID” = field(“Workflow Step Instance ID”)))
28 Iteration No. Integer Specifies the number of handling iterations that this approval request has reached. via Page 30443 “Approval Entry Overview”
29 Entry No. Integer — AutoIncrement
30 Workflow Step Instance ID Guid —
31 Related to Change Boolean — FlowField: exist(“Workflow - Record Change” where(“Workflow Step Instance ID” = field(“Workflow Step Instance ID”), “Record ID” = field(“Record ID”)))
32 Approver Full Name Text[80] Specifies the full name of the user who must approve the document. via Page 30443 “Approval Entry Overview” FlowField: lookup(User.“Full Name” where(“User Name” = field(“Approver ID”))); not editable
33 Sender Full Name Text[80] Specifies the full name of the user who sent the approval request for the document to be approved. via Page 30443 “Approval Entry Overview” FlowField: lookup(User.“Full Name” where(“User Name” = field(“Sender ID”))); not editable
34 Salespers./Purch. Name Text[80] Specifies the name 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 30443 “Approval Entry Overview” FlowField: lookup(“Salesperson/Purchaser”.Name where(“Code” = field(“Salespers./Purch. Code”))); not editable
35 Posted Boolean — not editable

Keys

  • Key1: Entry No., Posted (clustered)
  • Key2: Last Date-Time Modified

Procedures

  • ShowRecord()
  • ShowComments()
  • CopyFiltersAndFillBuffer()
  • FillBuffer(var ApprovalEntry: Record "Approval Entry")
  • FillBuffer(var PostedApprovalEntry: Record "Posted Approval Entry")

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

Evidence 1 sources