Table "Purch. Cr. Memo Line"

ID 125

Namespace: Microsoft.Purchases.History

Properties

Name	Value
Caption	Purch. Cr. Memo Line
DrillDownPageID	Page Microsoft.Purchases.History."Posted Purchase Cr. Memo Lines"
LookupPageID	Page Microsoft.Purchases.History."Posted Purchase Cr. Memo Lines"
DataClassification	CustomerContent

Fields

Name	Type	Description
"Buy-from Vendor No."	Code[20]	Specifies the name of the vendor who delivered the items.
"Document No."	Code[20]	Specifies the document number.
"Line No."	Integer
Type	Enum Microsoft.Purchases.Document."Purchase Line Type"	Specifies the line type.
"No."	Code[20]	Specifies the number of the involved entry or record, according to the specified number series.
"Location Code"	Code[10]	Specifies the code for the location where the credit memo line is registered.
"Posting Group"	Code[20]
"Expected Receipt Date"	Date	Specifies the date the items were received.
Description	Text[100]	Specifies either the name of, or a description of, the item or general ledger account.
"Description 2"	Text[50]	Specifies information in addition to the description.
"Unit of Measure"	Text[50]	Specifies the name of the item or resource's unit of measure, such as piece or hour.
Quantity	Decimal	Specifies the number of units of the item specified on the credit memo line.
"Direct Unit Cost"	Decimal	Specifies the cost of one unit of the selected item or resource.
"Unit Cost (LCY)"	Decimal
"VAT %"	Decimal
"Line Discount %"	Decimal	Specifies the discount percentage that is granted for the item on the line.
"Line Discount Amount"	Decimal	Specifies the discount amount that is granted for the item on the line.
Amount	Decimal	Specifies the line's net amount.
"Amount Including VAT"	Decimal	Specifies the net amount, including VAT, for this line.
"Unit Price (LCY)"	Decimal
"Allow Invoice Disc."	Boolean	Specifies if the invoice line is included when the invoice discount is calculated.
"Gross Weight"	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.
"Net Weight"	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.
"Units per Parcel"	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.
"Unit Volume"	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.
"Appl.-to Item Entry"	Integer	Specifies the number of the item ledger entry that the document or journal line is applied to.
"Shortcut Dimension 1 Code"	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.
"Shortcut Dimension 2 Code"	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.
"Job No."	Code[20]	Specifies the number of the related project.
"Indirect Cost %"	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.
"Order No."	Code[20]	Specifies the order number this line is associated with.
"Order Line No."	Integer
"Pay-to Vendor No."	Code[20]
"Inv. Discount Amount"	Decimal	Specifies the total calculated invoice discount amount for the line.
"Vendor Item No."	Text[50]
"Gen. Bus. Posting Group"	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.
"Gen. Prod. Posting Group"	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.
"VAT Calculation Type"	Enum Microsoft.Foundation.Enums."Tax Calculation Type"
"Transaction Type"	Code[10]
"Transport Method"	Code[10]
"Attached to Line No."	Integer
"Entry Point"	Code[10]
"Area"	Code[10]
"Transaction Specification"	Code[10]
"Tax Area Code"	Code[20]
"Tax Liable"	Boolean
"Tax Group Code"	Code[20]
"Use Tax"	Boolean
"VAT Bus. Posting Group"	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.
"VAT Prod. Posting Group"	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.
"Blanket Order No."	Code[20]	Specifies the number of the blanket order that the record originates from.
"Blanket Order Line No."	Integer	Specifies the number of the blanket order line that the record originates from.
"VAT Base Amount"	Decimal
"Unit Cost"	Decimal
"System-Created Entry"	Boolean
"Line Amount"	Decimal	Specifies the net amount, excluding any invoice discount amount, that must be paid for products on the line.
"VAT Difference"	Decimal
"VAT Identifier"	Code[20]
"IC Partner Ref. Type"	Enum Microsoft.Intercompany.Partner."IC Partner Reference Type"
"IC Partner Reference"	Code[20]
"Prepayment Line"	Boolean
"IC Partner Code"	Code[20]	Specifies the code of the intercompany partner that the transaction is related to if the entry was created from an intercompany transaction.
"Posting Date"	Date
"IC Item Reference No."	Code[50]
"Pmt. Discount Amount"	Decimal
"Dimension Set ID"	Integer
"Job Task No."	Code[20]	Specifies the number of the related project task.
"Job Line Type"	Enum Microsoft.Projects.Project.Job."Job Line Type"
"Job Unit Price"	Decimal
"Job Total Price"	Decimal
"Job Line Amount"	Decimal
"Job Line Discount Amount"	Decimal
"Job Line Discount %"	Decimal
"Job Unit Price (LCY)"	Decimal
"Job Total Price (LCY)"	Decimal
"Job Line Amount (LCY)"	Decimal
"Job Line Disc. Amount (LCY)"	Decimal
"Job Currency Factor"	Decimal
"Job Currency Code"	Code[20]
"Job Planning Line No."	Integer
"Deferral Code"	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.
"Variant Code"	Code[10]	Specifies the variant of the item on the line.
"Bin Code"	Code[20]	Specifies the bin where the items are picked or put away.
"Qty. per Unit of Measure"	Decimal
"Unit of Measure Code"	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.
"Quantity (Base)"	Decimal
"FA Posting Date"	Date
"FA Posting Type"	Enum Microsoft.FixedAssets.Posting."Purchase FA Posting Type"	Specifies the posting type, if Account Type field contains Fixed Asset.
"Depreciation Book Code"	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.
"Salvage Value"	Decimal
"Depr. until FA Posting Date"	Boolean	Specifies if depreciation was calculated until the FA posting date of the line.
"Depr. Acquisition Cost"	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.
"Maintenance Code"	Code[10]
"Insurance No."	Code[20]	Specifies the insurance number on the purchase credit memo line.
"Budgeted FA No."	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.
"Duplicate in Depreciation Book"	Code[10]
"Use Duplication List"	Boolean
"Responsibility Center"	Code[10]
"Item Category Code"	Code[20]
Nonstock	Boolean	Specifies that this item is a catalog item.
"Purchasing Code"	Code[10]
"Item Reference No."	Code[50]	Specifies the referenced item number.
"Item Reference Unit of Measure"	Code[10]
"Item Reference Type"	Enum Microsoft.Inventory.Item.Catalog."Item Reference Type"
"Item Reference Type No."	Code[30]
"Non-Deductible VAT %"	Decimal
"Non-Deductible VAT Base"	Decimal
"Non-Deductible VAT Amount"	Decimal
"Non-Deductible VAT Diff."	Decimal
"Return Shipment No."	Code[20]
"Return Shipment Line No."	Integer
"Return Reason Code"	Code[10]	Specifies the code explaining why the item was returned.
"Price Calculation Method"	Enum Microsoft.Pricing.Calculation."Price Calculation Method"
"Buy-from Vendor Name"	Text[100]	Specifies the name of the vendor who delivered the items.
SystemId	Guid
SystemCreatedAt	DateTime
SystemCreatedBy	Guid
SystemModifiedAt	DateTime
SystemModifiedBy	Guid
SystemCreatedByUserName	Text[50]
SystemCreatedByFullName	Text[80]
SystemModifiedByUserName	Text[50]
SystemModifiedByFullName	Text[80]
SystemRowVersion	BigInteger

Methods

GetCurrencyCode

procedure GetCurrencyCode(): Code[10]

Returns

Type	Description
Code[10]

ShowDimensions

procedure ShowDimensions()

ShowItemTrackingLines

procedure ShowItemTrackingLines()

CalcVATAmountLines

procedure CalcVATAmountLines(PurchCrMemoHdr: Record "Purch. Cr. Memo Hdr."; var TempVATAmountLine: Record "VAT Amount Line" temporary)

Parameters

Name	Type	Description
PurchCrMemoHdr	Table Microsoft.Purchases.History."Purch. Cr. Memo Hdr."
TempVATAmountLine	Table Microsoft.Finance.VAT.Calculation."VAT Amount Line"

GetCaptionClass

procedure GetCaptionClass(FieldNumber: Integer): Text[80]

Parameters

Name	Type	Description
FieldNumber	Integer

Returns

Type	Description
Text[80]

RowID1

procedure RowID1(): Text[250]

Returns

Type	Description
Text[250]

GetReturnShptLines

procedure GetReturnShptLines(var TempReturnShipmentLine: Record "Return Shipment Line" temporary)

Parameters

Name	Type	Description
TempReturnShipmentLine	Table Microsoft.Purchases.History."Return Shipment Line"

GetItemLedgEntries

procedure GetItemLedgEntries(var TempItemLedgEntry: Record "Item Ledger Entry" temporary; SetQuantity: Boolean)

Parameters

Name	Type	Description
TempItemLedgEntry	Table Microsoft.Inventory.Ledger."Item Ledger Entry"
SetQuantity	Boolean

FilterPstdDocLineValueEntries

procedure FilterPstdDocLineValueEntries(var ValueEntry: Record "Value Entry")

Parameters

Name	Type	Description
ValueEntry	Table Microsoft.Inventory.Ledger."Value Entry"

ShowItemReturnShptLines

procedure ShowItemReturnShptLines()

ShowLineComments

procedure ShowLineComments()

ShowShortcutDimCode

procedure ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])

Parameters

Name	Type	Description
ShortcutDimCode	array[8] of Code[20]

InitFromPurchLine

procedure InitFromPurchLine(PurchCrMemoHdr: Record "Purch. Cr. Memo Hdr."; PurchLine: Record "Purchase Line")

Parameters

Name	Type	Description
PurchCrMemoHdr	Table Microsoft.Purchases.History."Purch. Cr. Memo Hdr."
PurchLine	Table Microsoft.Purchases.Document."Purchase Line"

ShowDeferrals

procedure ShowDeferrals()

GetDocumentType

procedure GetDocumentType(): Integer

Returns

Type	Description
Integer

HasTypeToFillMandatoryFields

procedure HasTypeToFillMandatoryFields(): Boolean

Returns

Type	Description
Boolean

FormatType

procedure FormatType(): Text

Returns

Type	Description
Text

SetSecurityFilterOnRespCenter

procedure SetSecurityFilterOnRespCenter()

GetLineAmountExclVAT

procedure GetLineAmountExclVAT(): Decimal

Returns

Type	Description
Decimal

GetLineAmountInclVAT

procedure GetLineAmountInclVAT(): Decimal

Returns

Type	Description
Decimal

Events

OnAfterInitFromPurchLine

[IntegrationEvent(False,False)]
local procedure OnAfterInitFromPurchLine(PurchCrMemoHdr: Record "Purch. Cr. Memo Hdr."; PurchLine: Record "Purchase Line"; var PurchCrMemoLine: Record "Purch. Cr. Memo Line")

Parameters

Name	Type	Description
PurchCrMemoHdr	Table Microsoft.Purchases.History."Purch. Cr. Memo Hdr."
PurchLine	Table Microsoft.Purchases.Document."Purchase Line"
PurchCrMemoLine	Table Microsoft.Purchases.History."Purch. Cr. Memo Line"

OnBeforeShowDeferrals

[IntegrationEvent(False,False)]
local procedure OnBeforeShowDeferrals(var PurchCrMemoLine: Record "Purch. Cr. Memo Line"; var IsHandled: Boolean)

Parameters

Name	Type	Description
PurchCrMemoLine	Table Microsoft.Purchases.History."Purch. Cr. Memo Line"
IsHandled	Boolean

OnGetItemLedgEntriesOnBeforeTempItemLedgEntryInsert

[IntegrationEvent(False,False)]
local procedure OnGetItemLedgEntriesOnBeforeTempItemLedgEntryInsert(var TempItemLedgerEntry: Record "Item Ledger Entry" temporary; ValueEntry: Record "Value Entry"; SetQuantity: Boolean)

Parameters

Name	Type	Description
TempItemLedgerEntry	Table Microsoft.Inventory.Ledger."Item Ledger Entry"
ValueEntry	Table Microsoft.Inventory.Ledger."Value Entry"
SetQuantity	Boolean

OnBeforeSetSecurityFilterOnRespCenter

[IntegrationEvent(False,False)]
local procedure OnBeforeSetSecurityFilterOnRespCenter(var PurchCrMemoLine: Record "Purch. Cr. Memo Line"; var IsHandled: Boolean)

Parameters

Name	Type	Description
PurchCrMemoLine	Table Microsoft.Purchases.History."Purch. Cr. Memo Line"
IsHandled	Boolean

OnAfterGetVATPct

[IntegrationEvent(False,False)]
local procedure OnAfterGetVATPct(var PurchCrMemoLine: Record "Purch. Cr. Memo Line"; var VATPct: Decimal)

Parameters

Name	Type	Description
PurchCrMemoLine	Table Microsoft.Purchases.History."Purch. Cr. Memo Line"
VATPct	Decimal

See also

• Table