JOP-AL

Objects/Tables/Table 113 Sales Invoice Line

Table 113 Sales Invoice Line in 24

, Base Application 24.5.23489.36097, checked

App
Base Application
Namespace
Microsoft.Sales.History

Fields, 103Keys, 10Procedures, 25Events, 7

Versions171819202122232425262728latest

Source29

Fields, 103

IdNameTypeObsolete
2Sell-to Customer No.Code[20]-
3Document No.Code[20]-
4Line No.Integer-
5TypeEnum Sales Line Type-
6No.Code[20]-
7Location CodeCode[10]-
8Posting GroupCode[20]-
10Shipment DateDate-
11DescriptionText[100]-
12Description 2Text[50]-
13Unit of MeasureText[50]-
15QuantityDecimal-
22Unit PriceDecimal-
23Unit Cost (LCY)Decimal-
25VAT %Decimal-
27Line Discount %Decimal-
28Line Discount AmountDecimal-
29AmountDecimal-
30Amount Including VATDecimal-
32Allow Invoice Disc.Boolean-
34Gross WeightDecimal-
35Net WeightDecimal-
36Units per ParcelDecimal-
37Unit VolumeDecimal-
38Appl.-to Item EntryInteger-
40Shortcut Dimension 1 CodeCode[20]-
41Shortcut Dimension 2 CodeCode[20]-
42Customer Price GroupCode[10]-
45Job No.Code[20]-
52Work Type CodeCode[10]-
63Shipment No.Code[20]-
64Shipment Line No.Integer-
65Order No.Code[20]-
66Order Line No.Integer-
68Bill-to Customer No.Code[20]-
69Inv. Discount AmountDecimal-
73Drop ShipmentBoolean-
74Gen. Bus. Posting GroupCode[20]-
75Gen. Prod. Posting GroupCode[20]-
77VAT Calculation TypeEnum Tax Calculation Type-
78Transaction TypeCode[10]-
79Transport MethodCode[10]-
80Attached to Line No.Integer-
81Exit PointCode[10]-
82AreaCode[10]-
83Transaction SpecificationCode[10]-
84Tax CategoryCode[10]-
85Tax Area CodeCode[20]-
86Tax LiableBoolean-
87Tax Group CodeCode[20]-
88VAT Clause CodeCode[20]-
89VAT Bus. Posting GroupCode[20]-
90VAT Prod. Posting GroupCode[20]-
97Blanket Order No.Code[20]-
98Blanket Order Line No.Integer-
99VAT Base AmountDecimal-
100Unit CostDecimal-
101System-Created EntryBoolean-
103Line AmountDecimal-
104VAT DifferenceDecimal-
106VAT IdentifierCode[20]-
107IC Partner Ref. TypeEnum IC Partner Reference Type-
108IC Partner ReferenceCode[20]-
123Prepayment LineBoolean-
130IC Partner CodeCode[20]-
131Posting DateDate-
138IC Item Reference No.Code[50]-
145Pmt. Discount AmountDecimal-
180Line Discount CalculationOption-
480Dimension Set IDInteger-
1001Job Task No.Code[20]-
1002Job Contract Entry No.Integer-
1700Deferral CodeCode[10]-
2678Allocation Account No.Code[20]-
5402Variant CodeCode[10]-
5403Bin CodeCode[20]-
5404Qty. per Unit of MeasureDecimal-
5407Unit of Measure CodeCode[10]-
5415Quantity (Base)Decimal-
5600FA Posting DateDate-
5602Depreciation Book CodeCode[10]-
5605Depr. until FA Posting DateBoolean-
5612Duplicate in Depreciation BookCode[10]-
5613Use Duplication ListBoolean-
5700Responsibility CenterCode[10]-
5705Cross-Reference No.Code[20]Removed 22.0
Cross-Reference replaced by Item Reference feature.
5706Unit of Measure (Cross Ref.)Code[10]Removed 22.0
Cross-Reference replaced by Item Reference feature.
5707Cross-Reference TypeOptionRemoved 22.0
Cross-Reference replaced by Item Reference feature.
5708Cross-Reference Type No.Code[30]Removed 22.0
Cross-Reference replaced by Item Reference feature.
5709Item Category CodeCode[20]-
5710NonstockBoolean-
5711Purchasing CodeCode[10]-
5712Product Group CodeCode[10]Removed 15.0
Product Groups became first level children of Item Categories.
5725Item Reference No.Code[50]-
5726Item Reference Unit of MeasureCode[10]-
5727Item Reference TypeEnum Item Reference Type-
5728Item Reference Type No.Code[30]-
5811Appl.-from Item EntryInteger-
6608Return Reason CodeCode[10]-
7000Price Calculation MethodEnum Price Calculation Method-
7001Allow Line Disc.Boolean-
7002Customer Disc. GroupCode[20]-
7004Price descriptionText[80]-

Keys, 10

NameFieldsObsolete
Key1, clusteredDocument No., Line No.-
Key2Blanket Order No., Blanket Order Line No.-
Key3Sell-to Customer No.-
Key5Shipment No., Shipment Line No.-
Key6Job Contract Entry No.-
Key7Bill-to Customer No.-
Key8Order No., Order Line No., Posting Date-
Key9Document No., Location Code-
Key10Type, No.-
Key11Job No., Job Task No.-

Procedures, 25

NameParametersReturnsAccessObsolete
GetCurrencyCode()Code[10]public-
ShowDimensions()public-
ShowItemTrackingLines()public-
CalcVATAmountLines(Record Sales Invoice Header, var Record VAT Amount Line)public-
GetLineAmountExclVAT()Decimalpublic-
GetLineAmountInclVAT()Decimalpublic-
GetCaptionClass(Integer)Text[80]public-
RowID1()Text[250]public-
GetSalesShptLines(var Record Sales Shipment Line)public-
CalcShippedSaleNotReturned(var Decimal, var Decimal, Boolean)public-
GetItemLedgEntries(var Record Item Ledger Entry, Boolean)public-
FilterPstdDocLineValueEntries(var Record Value Entry)public-
ShowItemShipmentLines()public-
ShowLineComments()public-
ShowShortcutDimCode(var Code[20])public-
InitFromSalesLine(Record Sales Invoice Header, Record Sales Line)public-
ShowDeferrals()public-
UpdatePriceDescription()public-
FormatType()Textpublic-
GetDocumentType()Integerpublic-
HasTypeToFillMandatoryFields()Booleanpublic-
IsCancellationSupported()Booleanpublic-
SetSecurityFilterOnRespCenter()public-
GetInvoiceHeader()Record Sales Invoice Headerpublic-
GetDateForCalculations()Datepublic-

Events, 7

KindNameParametersObsolete
Integration eventOnAfterInitFromSalesLine(var Record Sales Invoice Line, Record Sales Invoice Header, Record Sales Line)-
Integration eventOnBeforeGetItemLedgEntries(var Record Sales Invoice Line, var Record Item Ledger Entry, Boolean, var Boolean)-
Integration eventOnBeforeCalcVATAmountLines(Record Sales Invoice Line, Record Sales Invoice Header, var Record VAT Amount Line, var Boolean)-
Integration eventOnGetItemLedgEntriesOnBeforeTempItemLedgEntryInsert(var Record Item Ledger Entry, Record Value Entry, Boolean)-
Integration eventOnAfterCalcQty(var Record Sales Invoice Line, Decimal, var Decimal)-
Integration eventOnBeforeShowDeferrals(Record Sales Invoice Line, var Boolean)-
Integration eventOnBeforeSetSecurityFilterOnRespCenter(var Record Sales Invoice Line, var Boolean)-