tablePurchasing & Payablesofficial - Microsoftderived - from the source, no model text

Table 125 "Purch. Cr. Memo Line"

Base Application · Microsoft.Purchases.History

Across versions

  1. BC23present
  2. BC2414 fields changed
  3. BC25unchanged
  4. BC265 fields removed, 4 procedures added
  5. BC272 fields changed, 1 fields removed
  6. BC2868 fields changed
  7. BC29unchanged
  8. BC301 procedures added

Neighbourhood 60 connected objects and pages

Table 23 "Vendor" (relates to, 3 links)VendorTable 349 "Dimension Value" (relates to, 2 links)Dimension ValueTable 5404 "Item Unit of Measure" (relates to, 2 links)Table 5600 "Fixed Asset" (relates to, 2 links)Table 5611 "Depreciation Book" (relates to, 2 links)Depreciation BookTable 1001 "Job Task" (relates to)Job TaskTable 124 "Purch. Cr. Memo Hdr." (relates to)Table 14 "Location" (relates to)LocationTable 15 "G/L Account" (relates to)Table 156 "Resource" (relates to)ResourceTable 167 "Job" (relates to)Table 1700 "Deferral Template" (relates to)Deferral TemplateTable 204 "Unit of Measure" (relates to)Unit of MeasureTable 250 "Gen. Business Posting Group" (relates to)Table 251 "Gen. Product Posting Group" (relates to)Gen. Product Posting GroupTable 258 "Transaction Type" (relates to)Table 259 "Transport Method" (relates to)Transport MethodTable 27 "Item" (relates to)Table 282 "Entry/Exit Point" (relates to)Table 284 "Area" (relates to)Table 285 "Transaction Specification" (relates to)Table 318 "Tax Area" (relates to)Table 321 "Tax Group" (relates to)Table 323 "VAT Business Posting Group" (relates to)Table 324 "VAT Product Posting Group" (relates to)Page 530 "Posted Purchase Cr. Memo Lines" (pages and codeunits on it, 3 links)Posted Purchase Cr. Memo LinesPage 141 "Posted Purch. Cr. Memo Subform" (pages and codeunits on it)Page 5859 "Get Post.Doc-P.Cr.MemoLn Sbfrm" (pages and codeunits on it)Table extension 20515 "Subc. Purch. CrMemo Line" (extended by)Table extension 4857 "AutoAcc Purch. Cr. Memo Line" (extended by)Codeunit 1173 "Document Attachment Mgmt" (event subscribers)Codeunit 8059 "Sub. Contracts General Mgt." (event subscribers)Codeunit 8066 "Purchase Documents" (event subscribers)Codeunit 408 "DimensionManagement" (calls, 2 links)DimensionManagementCodeunit 6503 "Item Tracking Doc. Management" (calls, 2 links)Item Tracking Doc. ManagementCodeunit 1720 "Deferral Utilities" (calls)Codeunit 5700 "User Setup Management" (calls)Codeunit 6500 "Item Tracking Management" (calls)Table 124 "Purch. Cr. Memo Hdr." (referenced by, 3 links)Purch. Cr. Memo Hdr.Table extension 6218 "Sust. Purch. Cr. Memo Header" (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.

Base Application · Microsoft.Purchases.History · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property Value
Caption Purch. Cr. Memo Line
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
2 Buy-from Vendor No. Δ BC28 Code[20] Specifies the name of the vendor who delivered the items. TableRelation Table 23 “Vendor”; not editable
3 Document No. Δ BC28 Code[20] Specifies the document number. TableRelation Table 124 “Purch. Cr. Memo Hdr.” (Purch. Cr. Memo Hdr.)
4 Line No. Integer —
5 Type Δ BC28 Enum “Purchase Line Type” Specifies the line type. enum Enum 39 “Purchase Line Type”
6 No. Δ BC28 Code[20] Specifies the number of the involved entry or record, according to the specified number series. TableRelation Table 15 “G/L Account”, Table 156 “Resource”, Table 27 “Item” (if (Type = const(“G/L Account”)) “G/L Account” else if (Type = const(Item)) Item else if (Type = const(“Fixed Asset”)) “Fixed Asset” else if (Type = const(“Charge (Item)”)) “Item Charge” else if (Type = const(Resource)) Resource)
7 Location Code Δ BC28 Code[10] Specifies the code for the location where the credit memo line is registered. TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
8 Posting Group Code[20] — TableRelation Table 5606 “FA Posting Group”, Table 94 “Inventory Posting Group” (if (Type = const(Item)) “Inventory Posting Group” else if (Type = const(“Fixed Asset”)) “FA Posting Group”); not editable
10 Expected Receipt Date Δ BC28 Date Specifies the date the items were received.
11 Description Δ BC28 Text[100] Specifies either the name of, or a description of, the item or general ledger account.
12 Description 2 Δ BC28 Text[50] Specifies information in addition to the description.
13 Unit of Measure Δ BC28 Text[50] Specifies the name of the item or resource’s unit of measure, such as piece or hour.
15 Quantity Δ BC28 Decimal Specifies the number of units of the item specified on the credit memo line.
22 Direct Unit Cost Δ BC28 Decimal Specifies the cost of one unit of the selected item or resource.
23 Unit Cost (LCY) Δ BC28 Decimal Specifies the cost, in LCY, of one unit of the item or resource on the line. via Page 530 “Posted Purchase Cr. Memo Lines”
25 VAT % Δ BC28 Decimal — not editable
27 Line Discount % Δ BC28 Decimal Specifies the discount percentage that is granted for the item on the line.
28 Line Discount Amount Δ BC28 Decimal Specifies the discount amount that is granted for the item on the line.
29 Amount Δ BC28 Decimal Specifies the line’s net amount.
30 Amount Including VAT Δ BC28 Decimal Specifies the net amount, including VAT, for this line.
31 Unit Price (LCY) Δ BC28 Decimal Specifies the price, in LCY, of one unit of the item or resource. You can enter a price manually or have it entered according to the Price/Profit Calculation field on the related card. via Page 530 “Posted Purchase Cr. Memo Lines”
32 Allow Invoice Disc. Δ BC28 Boolean Specifies if the invoice line is included when the invoice discount is calculated.
34 Gross Weight Δ BC28 Decimal Specifies the gross weight of one unit of the item. In the purchase statistics window, the gross weight on the line is included in the total gross weight of all the lines for the particular purchase document.
35 Net Weight Δ BC28 Decimal Specifies the net weight of one unit of the item. In the purchase statistics window, the net weight on the line is included in the total net weight of all the lines for the particular purchase document.
36 Units per Parcel Δ BC28 Decimal Specifies the number of units per parcel of the item. In the purchase statistics window, the number of units per parcel on the line helps to determine the total number of units for all the lines for the particular purchase document.
37 Unit Volume Δ BC28 Decimal Specifies the volume of one unit of the item. In the purchase statistics window, the volume of one unit of the item on the line is included in the total volume of all the lines for the particular purchase document.
38 Appl.-to Item Entry Δ BC28 Integer Specifies the number of the item ledger entry that the document or journal line is applied to.
40 Shortcut Dimension 1 Code Δ BC28 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)))
41 Shortcut Dimension 2 Code Δ BC28 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)))
45 Job No. Δ BC24 Δ BC28 Code[20] Specifies the number of the related project. TableRelation Table 167 “Job”
54 Indirect Cost % Δ BC28 Decimal Specifies the percentage of the item’s last purchase cost that includes indirect costs, such as freight that is associated with the purchase of the item.
65 Order No. Δ BC28 Code[20] Specifies the order number this line is associated with.
66 Order Line No. Integer —
68 Pay-to Vendor No. Code[20] — TableRelation Table 23 “Vendor”; not editable
69 Inv. Discount Amount Δ BC28 Decimal Specifies the total calculated invoice discount amount for the line.
70 Vendor Item No. Text[50] —
74 Gen. Bus. Posting Group Δ BC28 Code[20] Specifies the vendor’s or customer’s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup. TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group)
75 Gen. Prod. Posting Group Δ BC28 Code[20] Specifies the item’s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup. TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group)
77 VAT Calculation Type Enum “Tax Calculation Type” — enum Enum 254 “Tax Calculation Type”
78 Transaction Type Code[10] — TableRelation Table 258 “Transaction Type” (Transaction Type)
79 Transport Method Code[10] — TableRelation Table 259 “Transport Method” (Transport Method)
80 Attached to Line No. Integer — TableRelation Table 125 “Purch. Cr. Memo Line” (“Purch. Cr. Memo Line”.“Line No.” where(“Document No.” = field(“Document No.”)))
81 Entry Point Code[10] — TableRelation Table 282 “Entry/Exit Point” (Entry/Exit Point)
82 Area Code[10] — TableRelation Table 284 “Area”
83 Transaction Specification Code[10] — TableRelation Table 285 “Transaction Specification” (Transaction Specification)
85 Tax Area Code Code[20] — TableRelation Table 318 “Tax Area” (Tax Area)
86 Tax Liable Boolean —
87 Tax Group Code Code[20] — TableRelation Table 321 “Tax Group” (Tax Group)
88 Use Tax Boolean —
89 VAT Bus. Posting Group Δ BC28 Code[20] Specifies the VAT specification of the involved customer or vendor to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
90 VAT Prod. Posting Group Δ BC28 Code[20] Specifies the VAT specification of the involved item or resource to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group)
97 Blanket Order No. Δ BC28 Code[20] Specifies the number of the blanket order that the record originates from. TableRelation Table 38 “Purchase Header” (“Purchase Header”.“No.” where(“Document Type” = const(“Blanket Order”)))
98 Blanket Order Line No. Δ BC28 Integer Specifies the number of the blanket order line that the record originates from. TableRelation Table 39 “Purchase Line” (“Purchase Line”.“Line No.” where(“Document Type” = const(“Blanket Order”), “Document No.” = field(“Blanket Order No.”)))
99 VAT Base Amount Decimal — not editable
100 Unit Cost Decimal — not editable
101 System-Created Entry Boolean — not editable
103 Line Amount Δ BC28 Decimal Specifies the net amount, excluding any invoice discount amount, that must be paid for products on the line.
104 VAT Difference Decimal —
106 VAT Identifier Code[20] — not editable
107 IC Partner Ref. Type Enum “IC Partner Reference Type” — enum Enum 107 “IC Partner Reference Type”
108 IC Partner Reference Code[20] —
123 Prepayment Line Boolean — not editable
130 IC Partner Code Δ BC28 Code[20] Specifies the code of the intercompany partner that the transaction is related to if the entry was created from an intercompany transaction. TableRelation Table 413 “IC Partner” (IC Partner)
131 Posting Date Date —
138 IC Item Reference No. Code[50] —
145 Pmt. Discount Amount Decimal —
480 Dimension Set ID Integer — TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable
1001 Job Task No. Δ BC24 Δ BC28 Code[20] Specifies the number of the related project task. TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”)))
1002 Job Line Type Δ BC24 Enum “Job Line Type” Project Line Type caption enum Enum 1002 “Job Line Type”
1003 Job Unit Price Δ BC24 Δ BC28 Decimal Project Unit Price caption
1004 Job Total Price Δ BC24 Δ BC28 Decimal Project Total Price caption
1005 Job Line Amount Δ BC24 Decimal Project Line Amount caption
1006 Job Line Discount Amount Δ BC24 Decimal Project Line Discount Amount caption
1007 Job Line Discount % Δ BC24 Δ BC28 Decimal Project Line Discount % caption
1008 Job Unit Price (LCY) Δ BC24 Δ BC27 Δ BC28 Decimal Project Unit Price (LCY) caption
1009 Job Total Price (LCY) Δ BC24 Δ BC27 Δ BC28 Decimal Project Total Price (LCY) caption
1010 Job Line Amount (LCY) Δ BC24 Δ BC28 Decimal Project Line Amount (LCY) caption
1011 Job Line Disc. Amount (LCY) Δ BC24 Δ BC28 Decimal Project Line Disc. Amount (LCY) caption
1012 Job Currency Factor Δ BC24 Δ BC28 Decimal Project Currency Factor caption
1013 Job Currency Code Δ BC24 Code[20] Project Currency Code caption
1019 Job Planning Line No. + BC26 Integer Project Planning Line No. caption
1700 Deferral Code Δ BC28 Code[10] Specifies the deferral template that governs how expenses paid with this purchase document are deferred to the different accounting periods when the expenses were incurred. TableRelation Table 1700 “Deferral Template” (“Deferral Template”.“Deferral Code”)
5402 Variant Code Δ BC28 Code[10] Specifies the variant of the item on the line. TableRelation Table 5401 “Item Variant” (if (Type = const(Item)) “Item Variant”.Code where(“Item No.” = field(“No.”)))
5403 Bin Code Δ BC28 Code[20] Specifies the bin where the items are picked or put away. TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”), “Item Filter” = field(“No.”), “Variant Filter” = field(“Variant Code”)))
5404 Qty. per Unit of Measure Δ BC28 Decimal — not editable
5407 Unit of Measure Code Δ BC28 Code[10] Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted. TableRelation Table 204 “Unit of Measure”, Table 5404 “Item Unit of Measure” (if (Type = const(Item)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”)) else “Unit of Measure”)
5415 Quantity (Base) Δ BC28 Decimal —
5600 FA Posting Date Date —
5601 FA Posting Type Δ BC28 Enum “Purchase FA Posting Type” Specifies the posting type, if Account Type field contains Fixed Asset. enum Enum 5607 “Purchase FA Posting Type”
5602 Depreciation Book Code Δ BC28 Code[10] Specifies the code for the depreciation book to which the line will be posted if you have selected Fixed Asset in the Type field for this line. TableRelation Table 5611 “Depreciation Book” (Depreciation Book)
5603 Salvage Value Δ BC28 Decimal —
5605 Depr. until FA Posting Date Δ BC28 Boolean Specifies if depreciation was calculated until the FA posting date of the line.
5606 Depr. Acquisition Cost Δ BC28 Boolean Specifies if, when this line was posted, the additional acquisition cost posted on the line was depreciated in proportion to the amount by which the fixed asset had already been depreciated.
5609 Maintenance Code Code[10] — TableRelation Table 5626 “Maintenance”
5610 Insurance No. Δ BC28 Code[20] Specifies the insurance number on the purchase credit memo line. TableRelation Table 5628 “Insurance”
5611 Budgeted FA No. Δ BC28 Code[20] Specifies the number of a fixed asset with the Budgeted Asset check box selected. When you post the journal or document line, an additional entry is created for the budgeted fixed asset where the amount has the opposite sign. TableRelation Table 5600 “Fixed Asset” (Fixed Asset)
5612 Duplicate in Depreciation Book Code[10] — TableRelation Table 5611 “Depreciation Book” (Depreciation Book)
5613 Use Duplication List Boolean —
5700 Responsibility Center Code[10] — TableRelation Table 5714 “Responsibility Center” (Responsibility Center)
5709 Item Category Code Code[20] — TableRelation Table 5722 “Item Category” (if (Type = const(Item)) “Item Category”)
5710 Nonstock Δ BC28 Boolean Specifies that this item is a catalog item.
5711 Purchasing Code Code[10] — TableRelation Table 5721 “Purchasing”
5725 Item Reference No. Δ BC28 Code[50] Specifies the referenced item number.
5726 Item Reference Unit of Measure Code[10] Unit of Measure (Item Ref.) caption TableRelation Table 5404 “Item Unit of Measure” (if (Type = const(Item)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”)))
5727 Item Reference Type Enum “Item Reference Type” — enum Enum 5726 “Item Reference Type”
5728 Item Reference Type No. Code[30] —
6200 Non-Deductible VAT % Δ BC28 Decimal —
6201 Non-Deductible VAT Base Δ BC28 Decimal —
6202 Non-Deductible VAT Amount Δ BC28 Decimal —
6203 Non-Deductible VAT Diff. Δ BC28 Decimal Non-Deductible VAT Difference caption not editable
6600 Return Shipment No. Code[20] — not editable
6601 Return Shipment Line No. Integer — not editable
6608 Return Reason Code Δ BC28 Code[10] Specifies the code explaining why the item was returned. TableRelation Table 6635 “Return Reason” (Return Reason)
7000 Price Calculation Method Enum “Price Calculation Method” — enum Enum 7000 “Price Calculation Method”
8512 Buy-from Vendor Name + BC26 Δ BC28 Text[100] Specifies the name of the vendor who delivered the items. FlowField: lookup(Vendor.Name where(“No.” = field(“Buy-from Vendor No.”))); not editable

Keys

  • Key1: Document No., Line No. (clustered)
  • Key2: Blanket Order No., Blanket Order Line No.
  • Key3: Buy-from Vendor No.
  • Key4: Order No., Order Line No., Posting Date
  • Key5: Document No., Location Code

Events published

  • OnAfterInitFromPurchLine(PurchCrMemoHdr: Record "Purch. Cr. Memo Hdr."; PurchLine: Record "Purchase Line"; var PurchCrMemoLine: Record "Purch. Cr. Memo Line") (integration)
  • OnBeforeShowDeferrals(var PurchCrMemoLine: Record "Purch. Cr. Memo Line"; var IsHandled: Boolean) (integration)
  • OnGetItemLedgEntriesOnBeforeTempItemLedgEntryInsert(var TempItemLedgerEntry: Record "Item Ledger Entry" temporary; ValueEntry: Record "Value Entry"; SetQuantity: Boolean) (integration)
  • OnBeforeSetSecurityFilterOnRespCenter(var PurchCrMemoLine: Record "Purch. Cr. Memo Line"; var IsHandled: Boolean) (integration)
  • OnAfterGetVATPct(var PurchCrMemoLine: Record "Purch. Cr. Memo Line"; var VATPct: Decimal) + BC26 (integration)

Trigger event subscribers

Procedures

  • GetCurrencyCode(): Code[10]
  • ShowDimensions()
  • ShowItemTrackingLines()
  • CalcVATAmountLines(PurchCrMemoHdr: Record "Purch. Cr. Memo Hdr."; var TempVATAmountLine: Record "VAT Amount Line" temporary)
  • GetCaptionClass(FieldNumber: Integer): Text[80]
  • RowID1(): Text[250]
  • GetReturnShptLines(var TempReturnShipmentLine: Record "Return Shipment Line" temporary) Δ BC26
  • GetItemLedgEntries(var TempItemLedgEntry: Record "Item Ledger Entry" temporary; SetQuantity: Boolean)
  • FilterPstdDocLineValueEntries(var ValueEntry: Record "Value Entry")
  • ShowItemReturnShptLines()
  • ShowLineComments()
  • ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])
  • InitFromPurchLine(PurchCrMemoHdr: Record "Purch. Cr. Memo Hdr."; PurchLine: Record "Purchase Line")
  • ShowDeferrals()
  • GetDocumentType(): Integer
  • HasTypeToFillMandatoryFields(): Boolean
  • FormatType(): Text
  • SetSecurityFilterOnRespCenter()
  • GetLineAmountExclVAT(): Decimal
  • GetLineAmountInclVAT(): Decimal
  • GetVATPct(): Decimal + BC26 (internal)
  • GetPurchaseInvoiceLine(var PurchInvLine: Record "Purch. Inv. Line") + BC26 (internal)

Plus 4 local procedures.

Triggers

OnDelete

Relations

Referenced by

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

Pages and codeunits on this table

Extended by

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.

Recent changes

Countries that replace it

AU, BE, CA, ES, FI, GB, IT, MX, NO, NZ, RU, SE, US

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). 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: "Purch. Cr. Memo Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources