Table 1900 "Cancelled Document"
Base Application · Microsoft.Utilities
Across versions
- BC23present
- BC24declaration changed
- BC25-30unchanged
Neighbourhood 12 connected objects and pages
Base Application · Microsoft.Utilities · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Cancelled Document |
| DataClassification | CustomerContent |
| Permissions | TableData “Cancelled Document” = rimd |
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 | Source ID | Integer | — | |
| 2 | Cancelled Doc. No. | Code[20] | — | TableRelation Table 112 “Sales Invoice Header”, Table 114 “Sales Cr.Memo Header”, Table 122 “Purch. Inv. Header” (if (“Source ID” = const(112)) “Sales Invoice Header”.“No.” else if (“Source ID” = const(122)) “Purch. Inv. Header”.“No.” else if (“Source ID” = const(114)) “Sales Cr.Memo Header”.“No.” else if (“Source ID” = const(124)) “Purch. Cr. Memo Hdr.”.“No.”) |
| 3 | Cancelled By Doc. No. | Code[20] | — | TableRelation Table 112 “Sales Invoice Header”, Table 114 “Sales Cr.Memo Header”, Table 122 “Purch. Inv. Header” (if (“Source ID” = const(114)) “Sales Invoice Header”.“No.” else if (“Source ID” = const(124)) “Purch. Inv. Header”.“No.” else if (“Source ID” = const(112)) “Sales Cr.Memo Header”.“No.” else if (“Source ID” = const(122)) “Purch. Cr. Memo Hdr.”.“No.”) |
Keys
- Key1: Source ID, Cancelled Doc. No. (clustered)
- Key2: Cancelled By Doc. No.
Trigger event subscribers
- OnAfterDeleteEvent: Codeunit 5477 “Sales Invoice Aggregator” OnAfterDeleteCancelledDocument, Codeunit 5508 “Graph Mgt - Sal. Cr. Memo Buf.” OnAfterDeleteCancelledDocument, Codeunit 5511 “Graph Mgt - Purch. Cr. Memo” OnAfterDeleteCancelledDocument, Codeunit 5529 “Purch. Inv. Aggregator” OnAfterDeleteCancelledDocument
- OnAfterInsertEvent: Codeunit 5477 “Sales Invoice Aggregator” OnAfterInsertCancelledDocument, Codeunit 5508 “Graph Mgt - Sal. Cr. Memo Buf.” OnAfterInsertCancelledDocument, Codeunit 5511 “Graph Mgt - Purch. Cr. Memo” OnAfterInsertCancelledDocument, Codeunit 5529 “Purch. Inv. Aggregator” OnAfterInsertCancelledDocument
- OnAfterModifyEvent: Codeunit 5477 “Sales Invoice Aggregator” OnAfterModifyCancelledDocument, Codeunit 5508 “Graph Mgt - Sal. Cr. Memo Buf.” OnAfterModifyCancelledDocument, Codeunit 5511 “Graph Mgt - Purch. Cr. Memo” OnAfterModifyCancelledDocument, Codeunit 5529 “Purch. Inv. Aggregator” OnAfterModifyCancelledDocument
- OnAfterRenameEvent: Codeunit 5477 “Sales Invoice Aggregator” OnAfterRenameCancelledDocument, Codeunit 5508 “Graph Mgt - Sal. Cr. Memo Buf.” OnAfterRenameCancelledDocument, Codeunit 5511 “Graph Mgt - Purch. Cr. Memo” OnAfterRenameCancelledDocument, Codeunit 5529 “Purch. Inv. Aggregator” OnAfterRenameCancelledDocument
Procedures
InsertSalesInvToCrMemoCancelledDocument(InvNo: Code[20]; CrMemoNo: Code[20])InsertSalesCrMemoToInvCancelledDocument(CrMemoNo: Code[20]; InvNo: Code[20])InsertPurchInvToCrMemoCancelledDocument(InvNo: Code[20]; CrMemoNo: Code[20])InsertPurchCrMemoToInvCancelledDocument(CrMemoNo: Code[20]; InvNo: Code[20])FindSalesCancelledInvoice(CanceledDocNo: Code[20]): BooleanFindSalesCorrectiveInvoice(CanceledByDocNo: Code[20]): BooleanFindPurchCancelledInvoice(CanceledDocNo: Code[20]): BooleanFindPurchCorrectiveInvoice(CanceledByDocNo: Code[20]): BooleanFindSalesCorrectiveCrMemo(CanceledByDocNo: Code[20]): BooleanFindSalesCancelledCrMemo(CanceledDocNo: Code[20]): BooleanFindPurchCorrectiveCrMemo(CanceledByDocNo: Code[20]): BooleanFindPurchCancelledCrMemo(CanceledDocNo: Code[20]): Boolean
Plus 5 local procedures.
Relations
- Cancelled By Doc. No.: TableRelation Table 112 “Sales Invoice Header” (conditional)
- Cancelled Doc. No.: TableRelation Table 112 “Sales Invoice Header” (conditional)
- Cancelled By Doc. No.: TableRelation Table 114 “Sales Cr.Memo Header” (conditional)
- Cancelled Doc. No.: TableRelation Table 114 “Sales Cr.Memo Header” (conditional)
- Cancelled By Doc. No.: TableRelation Table 122 “Purch. Inv. Header” (conditional)
- Cancelled Doc. No.: TableRelation Table 122 “Purch. Inv. Header” (conditional)
- Cancelled By Doc. No.: TableRelation Table 124 “Purch. Cr. Memo Hdr.” (conditional)
- Cancelled Doc. No.: TableRelation Table 124 “Purch. Cr. Memo Hdr.” (conditional)
Referenced by
8 fields in 4 objects relate to this table (TableRelation or CalcFormula).
- Table 112 “Sales Invoice Header”: Cancelled, Corrective
- Table 114 “Sales Cr.Memo Header”: Cancelled, Corrective
- Table 122 “Purch. Inv. Header”: Cancelled, Corrective
- Table 124 “Purch. Cr. Memo Hdr.”: Cancelled, Corrective
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: "Cancelled Document"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.