Diagrams


Table

Sales Line Archive

DynamicsDocs.comSales Line Archive«Table 5108»Sales Line ArchiveDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupQuantity Disc. CodeShipment DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Quantity Disc. %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item Entry...«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 5107»Sales Header ArchiveDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...«Table 7»Standard TextCode [PK,NN]Description«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeIncome/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc.Business Unit Filter...«Table 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«Table 156»ResourceNo. [PK]Type; [Person,Machine]NameSearch NameName 2AddressAddress 2CitySocial Security No.Job TitleEducationContract ClassEmployment DateResource Group No.Global Dimension 1 CodeGlobal Dimension 2 CodeBase Unit of MeasureDirect Unit CostIndirect Cost %Unit CostProfit %Price/Profit Calculation; [Profit=Pric...Unit PriceVendor No.Last Date ModifiedCommentBlockedDate FilterUnit of Measure FilterCapacityQty. on Order [Job]...«Table 5600»Fixed AssetNo. [PK]DescriptionSearch DescriptionDescription 2FA Class CodeFA Subclass CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeFA Location CodeVendor No.Main Asset/Component; [,Main Asset,Com...Component of Main AssetBudgeted AssetWarranty DateResponsible EmployeeSerial No.Last Date ModifiedInsuredCommentBlockedPictureMaintenance Vendor No.Under MaintenanceNext Service DateInactiveFA Posting Date FilterNo. SeriesFA Posting Group«Table 5800»Item ChargeNo. [PK,NN]DescriptionGen. Prod. Posting GroupTax Group CodeVAT Prod. Posting GroupSearch DescriptionGlobal Dimension 1 CodeGlobal Dimension 2 Code«Table 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 94»Inventory Posting GroupCode [PK,NN]Description«Table 5606»FA Posting GroupCode [PK,NN]Acquisition Cost AccountAccum. Depreciation AccountWrite-Down AccountAppreciation AccountCustom 1 AccountCustom 2 AccountAcq. Cost Acc. on DisposalAccum. Depr. Acc. on DisposalWrite-Down Acc. on DisposalAppreciation Acc. on DisposalCustom 1 Account on DisposalCustom 2 Account on DisposalGains Acc. on DisposalLosses Acc. on DisposalBook Val. Acc. on Disp. [Gain]Sales Acc. on Disp. [Gain]Write-Down Bal. Acc. on Disp.Apprec. Bal. Acc. on Disp.Custom 1 Bal. Acc. on DisposalCustom 2 Bal. Acc. on DisposalMaintenance Expense AccountMaintenance Bal. Acc.Acquisition Cost Bal. Acc.Depreciation Expense Acc.Write-Down Expense Acc.Appreciation Bal. AccountCustom 1 Expense Acc.Custom 2 Expense Acc.Sales Bal. Acc.Allocated Acquisition Cost %...«Table 6»Customer Price GroupCode [PK,NN]Price Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]DescriptionAllow Line Disc.«Table 167»JobNo. [PK]Search DescriptionDescriptionDescription 2Bill-to Customer No.Creation DateStarting DateEnding DateStatus; [Planning,Quote,Order,Complete...Person ResponsibleGlobal Dimension 1 CodeGlobal Dimension 2 CodeJob Posting GroupBlocked; [,Posting,All]Last Date ModifiedCommentCustomer Disc. GroupCustomer Price GroupLanguage CodeScheduled Res. Qty.Resource FilterPosting Date FilterResource Gr. FilterScheduled Res. Gr. Qty.PictureBill-to NameBill-to AddressBill-to Address 2Bill-to CityBill-to CountyBill-to Post Code...«Table 200»Work TypeCode [PK,NN]DescriptionUnit of Measure Code«Table 38»Purchase HeaderDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting Group...«Table 39»Purchase LineDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ReceiveDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 Code...«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 258»Transaction TypeCode [PK,NN]Description«Table 259»Transport MethodCode [PK,NN]Description«Table 282»Entry/Exit PointCode [PK,NN]Description«Table 285»Transaction SpecificationCode [PK,NN]Text«Table 318»Tax AreaCode [PK,NN]Description«Table 321»Tax GroupCode [PK,NN]Description«Table 323»VAT Business Posting GroupCode [PK,NN]Description«Table 324»VAT Product Posting GroupCode [PK,NN]Description«Table 36»Sales HeaderDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...«Table 37»Sales LineDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 Code...«Table 413»IC PartnerCode [PK,NN]NameCurrency CodeInbox Type; [File Location,Database,E-...Inbox DetailsReceivables AccountPayables AccountBlockedCommentCustomer No.Vendor No.Outbound Sales Item No. Type; [Interna...Outbound Purch. Item No. Type; [Intern...Cost Distribution in LCY«Table 1700»Deferral TemplateDeferral Code [PK,NN]DescriptionDeferral Account [NN]Deferral %Calc. Method; [Straight-Line,Equal per...Start Date; [Posting Date,Beginning of...No. of PeriodsPeriod Description«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 7354»BinLocation Code [PK,NN]Code [PK,NN]DescriptionZone CodeAdjustment BinBin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Special Equipment CodeBin RankingMaximum CubageMaximum WeightEmptyItem FilterVariant FilterDefaultCross-Dock BinDedicated«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard Code«Table 5611»Depreciation BookCode [PK,NN]DescriptionG/L Integration - Acq. CostG/L Integration - DepreciationG/L Integration - Write-DownG/L Integration - AppreciationG/L Integration - Custom 1G/L Integration - Custom 2G/L Integration - DisposalG/L Integration - MaintenanceDisposal Calculation Method; [Net,Gros...Use Custom 1 DepreciationAllow Depr. below ZeroUse FA Exch. Rate in Duplic.Part of Duplication ListLast Date ModifiedAllow IndexationUse Same FA+G/L Posting DatesDefault Exchange RateUse FA Ledger CheckUse Rounding in Periodic Depr.New Fiscal Year Starting DateNo. of Days in Fiscal YearAllow Changes in Depr. FieldsDefault Final Rounding AmountDefault Ending Book ValuePeriodic Depr. Date Calc.; [Last Entry...Mark Errors as CorrectionsAdd-Curr Exch Rate - Acq. CostAdd.-Curr. Exch. Rate - Depr.Add-Curr Exch Rate -Write-Down...«Table 5714»Responsibility CenterCode [PK,NN]NameAddressAddress 2CityPost CodeCountry/Region CodePhone No.Fax No.Name 2ContactGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeCountyE-MailHome PageDate FilterContract Gain/Loss Amount«Table 5722»Item CategoryCode [PK,NN]DescriptionDef. Gen. Prod. Posting GroupDef. Inventory Posting GroupDef. Tax Group CodeDef. Costing Method; [FIFO,LIFO,Specif...Def. VAT Prod. Posting Group«Table 5721»PurchasingCode [PK,NN]DescriptionDrop ShipmentSpecial Order«Table 5723»Product GroupItem Category Code [PK]Code [PK]DescriptionWarehouse Class Code«Table 291»Shipping AgentCode [PK,NN]NameInternet AddressAccount No.«Table 5790»Shipping Agent ServicesShipping Agent Code [PK,NN]Code [PK,NN]DescriptionShipping TimeBase Calendar Code«Table 5965»Service Contract HeaderContract No. [PK]Contract Type; [Quote,Contract] [PK]DescriptionDescription 2Status; [,Signed,Canceled]Change Status; [Open,Locked]Customer No. [NN]NameAddressAddress 2Post CodeCityContact NameYour ReferenceSalesperson CodeBill-to Customer No.Bill-to NameBill-to AddressBill-to Address 2Bill-to Post CodeBill-to CityShip-to CodeShip-to NameShip-to AddressShip-to Address 2Ship-to Post CodeShip-to CityServ. Contract Acc. Gr. CodeInvoice Period; [Month,Two Months,Quar...Last Invoice DateNext Invoice Date...«Table 5940»Service ItemNo. [PK]Serial No.Service Item Group CodeDescriptionDescription 2Status; [,Own Service Item,Installed,T...Priority; [Low,Medium,High]Customer No.Ship-to CodeItem No.Unit of Measure CodeLocation of Service ItemSales Unit PriceSales Unit CostWarranty Starting Date [Labor]Warranty Ending Date [Labor]Warranty Starting Date [Parts]Warranty Ending Date [Parts]Warranty % [Parts]Warranty % [Labor]Response Time [Hours]Installation DateSales DateLast Service DateDefault Contract ValueDefault Contract Discount %No. of Active ContractsVendor No.Vendor Item No.No. SeriesItem Description...«Table 6082»Service Price Adjustment GroupCode [PK,NN]Description«Table 6635»Return ReasonCode [PK,NN]DescriptionDefault Location CodeInventory Value Zero«Table 340»Customer Discount GroupCode [PK,NN]Description<Sell-to Customer No.><Bill-to Customer No.><Document No.><No.><No.><No.><Originally Ordered No.><BOM Item No.><No.><No.><No.><Location Code><Posting Group><Posting Group><Price Group Code><Job No.><Work Type Code><Purchase Order No.><Special Order Purchase No.><Purch. Order Line No.><Special Order Purch. Line No.><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Exit Point><Transaction Specification><Tax Area Code><Prepayment Tax Area Code><Tax Group Code><Prepayment Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Blanket Order No.><Blanket Order Line No.><IC Partner Code><Deferral Code><Variant Code><Originally Ordered Var. Code><Bin Code><Unit of Measure Code><Unit of Measure (Cross Ref.)><Unit of Measure Code><Depreciation Book Code><Duplicate in Depreciation Book><Responsibility Center><Item Category Code><Purchasing Code><Product Group Code><Shipping Agent Code><Shipping Agent Service Code><Service Contract No.><Service Item No.><Serv. Price Adjmt. Gr. Code><Return Reason Code><Customer Disc. Group><Customer Price Group><Shipping Agent Code><Customer Disc. Group><Bill-to Customer No.><Location Code><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><IC Partner Code><Customer No.><Responsibility Center><Shipping Agent Service Code><Bill-to Customer No.><Sell-to Customer No.><Bill-to Customer No.><Sell-to Customer No.><Bill-to Customer No.><Sell-to Customer No.><Sell-to Customer No.><Bill-to Customer No.><Customer No.><Customer No.><Bill-to Customer No.><Location Code><Location Filter><Price Group Code><Cust./Item Disc. Gr.><Bal. Account No.><Gen. Bus. Posting Group><Transaction Type><Transport Method><Exit Point><Transaction Specification><Shipping Agent Code><Tax Area Code><VAT Bus. Posting Group><Sell-to IC Partner Code><Bill-to IC Partner Code><Responsibility Center><Shipping Agent Service Code><No.><No.><Price Inv. Increase Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Default Deferral Template Code><Deferral Account><Bal. Account No.><No.><Bal. Account No.><No.><Receivables Account><Payables Account><Acquisition Cost Account><Accum. Depreciation Account><Write-Down Account><Appreciation Account><Custom 1 Account><Custom 2 Account><Acq. Cost Acc. on Disposal><Accum. Depr. Acc. on Disposal><Write-Down Acc. on Disposal><Appreciation Acc. on Disposal><Custom 1 Account on Disposal><Custom 2 Account on Disposal><Gains Acc. on Disposal><Losses Acc. on Disposal><Book Val. Acc. on Disp. (Gain)><Sales Acc. on Disp. (Gain)><Write-Down Bal. Acc. on Disp.><Apprec. Bal. Acc. on Disp.><Custom 1 Bal. Acc. on Disposal><Custom 2 Bal. Acc. on Disposal><Maintenance Expense Account><Maintenance Bal. Acc.><Acquisition Cost Bal. Acc.><Depreciation Expense Acc.><Write-Down Expense Acc.><Appreciation Bal. Account><Custom 1 Expense Acc.><Custom 2 Expense Acc.><Sales Bal. Acc.><Sales Acc. on Disp. (Loss)><Book Val. Acc. on Disp. (Loss)><Inventory Posting Group><Alternative Item No.><Location Filter><VAT Bus. Posting Gr. (Price)><Gen. Prod. Posting Group><Tax Group Code><VAT Prod. Posting Group><Default Deferral Template Code><Bin Filter><Item Filter><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item Category Code><Product Group Code><No.><Originally Ordered No.><BOM Item No.><No.><Item No.><Item Filter><Base Unit of Measure><Unit of Measure Filter><Gen. Prod. Posting Group><Tax Group Code><VAT Prod. Posting Group><Default Deferral Template Code><Person Responsible><Resource Filter><No.><Preferred Resource><Location Code><Component of Main Asset><FA Posting Group><No.><No.><Budgeted FA No.><Gen. Prod. Posting Group><Tax Group Code><VAT Prod. Posting Group><No.><No.><Default Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Adjustment Bin Code><Receipt Bin Code><Shipment Bin Code><Cross-Dock Bin Code><To-Assembly Bin Code><From-Assembly Bin Code><Asm.-to-Order Shpt. Bin Code><Location Code><Location Code><Location Filter><Location Code><Location Code><Location Filter><Location Code><Location Code><Default Location Code><Posting Group><Posting Group><Def. Inventory Posting Group><Posting Group><Posting Group><VAT Bus. Posting Gr. (Price)><Customer Price Group><Customer Price Group><Customer Price Group><Customer Disc. Group><Job No.><Job No.><Unit of Measure Code><Work Type Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Entry Point><Transaction Specification><Tax Area Code><VAT Bus. Posting Group><Buy-from IC Partner Code><Pay-to IC Partner Code><Responsibility Center><Purchase Order No.><Special Order Purchase No.><Document No.><Blanket Order No.><Sales Order No.><Special Order Sales No.><Sales Order Line No.><Special Order Sales Line No.><Purch. Order Line No.><Special Order Purch. Line No.><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Blanket Order Line No.><Entry Point><Transaction Specification><Tax Area Code><Prepayment Tax Area Code><Tax Group Code><Prepayment Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><IC Partner Code><Deferral Code><Variant Code><Bin Code><Unit of Measure Code><Unit of Measure (Cross Ref.)><Unit of Measure Code><Depreciation Book Code><Duplicate in Depreciation Book><Responsibility Center><Item Category Code><Purchasing Code><Product Group Code><Return Reason Code><Def. VAT Bus. Posting Group><Gen. Bus. Posting Group><Gen. Bus. Posting Group><Def. VAT Prod. Posting Group><Gen. Prod. Posting Group><Def. Gen. Prod. Posting Group><Transaction Type><Transaction Type><Transport Method><Transport Method><Exit Point><Exit Point><Transaction Specification><Transaction Specification><Tax Area Code><Tax Area Code><Prepayment Tax Area Code><Tax Group Code><Prepayment Tax Group Code><Def. Tax Group Code><VAT Bus. Posting Group><VAT Bus. Posting Group><VAT Prod. Posting Group><Def. VAT Prod. Posting Group><Customer Disc. Group><Shipping Agent Code><Sell-to IC Partner Code><Bill-to IC Partner Code><Responsibility Center><Shipping Agent Service Code><Document No.><Blanket Order No.><Attached to Line No.><Blanket Order Line No.><IC Partner Code><Deferral Code><Variant Code><Originally Ordered Var. Code><Bin Code><Unit of Measure Code><Unit of Measure (Cross Ref.)><Unit of Measure Code><Depreciation Book Code><Duplicate in Depreciation Book><Responsibility Center><Item Category Code><Purchasing Code><Product Group Code><Shipping Agent Code><Shipping Agent Service Code><Return Reason Code><Customer Disc. Group><Variant Code><Code><Unit of Measure Code><Unit of Measure Code><Responsibility Center><Item Category Code><Shipping Agent Code><Contract Filter>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Document Type (Document Type) Option
2 Sell-to Customer No. (Sell-to Customer No.) Code20
3 Document No. (Document No.) Code20
4 Line No. (Line No.) Integer
5 Type (Type) Option
6 No. (No.) Code20
7 Location Code (Location Code) Code10
8 Posting Group (Posting Group) Code10
9 Quantity Disc. Code (Quantity Disc. Code) Code20
10 Shipment Date (Shipment Date) Date
11 Description (Description) Text50
12 Description 2 (Description 2) Text50
13 Unit of Measure (Unit of Measure) Text10
15 Quantity (Quantity) Decimal (0:5)
16 Outstanding Quantity (Outstanding Quantity) Decimal (0:5)
17 Qty. to Invoice (Qty. to Invoice) Decimal (0:5)
18 Qty. to Ship (Qty. to Ship) Decimal (0:5)
22 Unit Price (Unit Price) Decimal
23 Unit Cost (LCY) (Unit Cost (LCY)) Decimal
25 VAT % (VAT %) Decimal (0:5)
26 Quantity Disc. % (Quantity Disc. %) Decimal (0:5)
27 Line Discount % (Line Discount %) Decimal (0:5)
28 Line Discount Amount (Line Discount Amount) Decimal
29 Amount (Amount) Decimal
30 Amount Including VAT (Amount Including VAT) Decimal
32 Allow Invoice Disc. (Allow Invoice Disc.) Boolean
34 Gross Weight (Gross Weight) Decimal (0:5)
35 Net Weight (Net Weight) Decimal (0:5)
36 Units per Parcel (Units per Parcel) Decimal (0:5)
37 Unit Volume (Unit Volume) Decimal (0:5)
38 Appl.-to Item Entry (Appl.-to Item Entry) Integer
40 Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) Code20
41 Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Code20
42 Price Group Code (Price Group Code) Code10
43 Allow Quantity Disc. (Allow Quantity Disc.) Boolean
45 Job No. (Job No.) Code20
52 Work Type Code (Work Type Code) Code10
55 Cust./Item Disc. % (Cust./Item Disc. %) Decimal (0:5)
57 Outstanding Amount (Outstanding Amount) Decimal Editable: No
58 Qty. Shipped Not Invoiced (Qty. Shipped Not Invoiced) Decimal (0:5)
59 Shipped Not Invoiced (Shipped Not Invoiced) Decimal
60 Quantity Shipped (Quantity Shipped) Decimal (0:5)
61 Quantity Invoiced (Quantity Invoiced) Decimal (0:5)
63 Shipment No. (Shipment No.) Code20
64 Shipment Line No. (Shipment Line No.) Integer
67 Profit % (Profit %) Decimal (0:5)
68 Bill-to Customer No. (Bill-to Customer No.) Code20
69 Inv. Discount Amount (Inv. Discount Amount) Decimal
71 Purchase Order No. (Purchase Order No.) Code20
72 Purch. Order Line No. (Purch. Order Line No.) Integer
73 Drop Shipment (Drop Shipment) Boolean
74 Gen. Bus. Posting Group (Gen. Bus. Posting Group) Code10
75 Gen. Prod. Posting Group (Gen. Prod. Posting Group) Code10
77 VAT Calculation Type (VAT Calculation Type) Option
78 Transaction Type (Transaction Type) Code10
79 Transport Method (Transport Method) Code10
80 Attached to Line No. (Attached to Line No.) Integer
81 Exit Point (Exit Point) Code10
82 Area (Area) Code10
83 Transaction Specification (Transaction Specification) Code10
85 Tax Area Code (Tax Area Code) Code20
86 Tax Liable (Tax Liable) Boolean
87 Tax Group Code (Tax Group Code) Code10
89 VAT Bus. Posting Group (VAT Bus. Posting Group) Code10
90 VAT Prod. Posting Group (VAT Prod. Posting Group) Code10
91 Currency Code (Currency Code) Code10
92 Outstanding Amount (LCY) (Outstanding Amount (LCY)) Decimal
93 Shipped Not Invoiced (LCY) (Shipped Not Invoiced (LCY)) Decimal
96 Reserve (Reserve) Option
97 Blanket Order No. (Blanket Order No.) Code20
98 Blanket Order Line No. (Blanket Order Line No.) Integer
99 VAT Base Amount (VAT Base Amount) Decimal
100 Unit Cost (Unit Cost) Decimal
101 System-Created Entry (System-Created Entry) Boolean
103 Line Amount (Line Amount) Decimal
104 VAT Difference (VAT Difference) Decimal
105 Inv. Disc. Amount to Invoice (Inv. Disc. Amount to Invoice) Decimal
106 VAT Identifier (VAT Identifier) Code10
107 IC Partner Ref. Type (IC Partner Ref. Type) Option
108 IC Partner Reference (IC Partner Reference) Code20
109 Prepayment % (Prepayment %) Decimal (0:5)
110 Prepmt. Line Amount (Prepmt. Line Amount) Decimal
111 Prepmt. Amt. Inv. (Prepmt. Amt. Inv.) Decimal Editable: No
112 Prepmt. Amt. Incl. VAT (Prepmt. Amt. Incl. VAT) Decimal Editable: No
113 Prepayment Amount (Prepayment Amount) Decimal Editable: No
114 Prepmt. VAT Base Amt. (Prepmt. VAT Base Amt.) Decimal Editable: No
115 Prepayment VAT % (Prepayment VAT %) Decimal (0:5) Editable: No
116 Prepmt. VAT Calc. Type (Prepmt. VAT Calc. Type) Option Editable: No
117 Prepayment VAT Identifier (Prepayment VAT Identifier) Code10 Editable: No
118 Prepayment Tax Area Code (Prepayment Tax Area Code) Code20
119 Prepayment Tax Liable (Prepayment Tax Liable) Boolean
120 Prepayment Tax Group Code (Prepayment Tax Group Code) Code10
121 Prepmt Amt to Deduct (Prepmt Amt to Deduct) Decimal
122 Prepmt Amt Deducted (Prepmt Amt Deducted) Decimal Editable: No
123 Prepayment Line (Prepayment Line) Boolean Editable: No
124 Prepmt. Amount Inv. Incl. VAT (Prepmt. Amount Inv. Incl. VAT) Decimal Editable: No
130 IC Partner Code (IC Partner Code) Code20
480 Dimension Set ID (Dimension Set ID) Integer Editable: No
1700 Deferral Code (Deferral Code) Code10
1702 Returns Deferral Start Date (Returns Deferral Start Date) Date
5047 Version No. (Version No.) Integer
5048 Doc. No. Occurrence (Doc. No. Occurrence) Integer
5402 Variant Code (Variant Code) Code10
5403 Bin Code (Bin Code) Code20
5404 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5)
5405 Planned (Planned) Boolean
5407 Unit of Measure Code (Unit of Measure Code) Code10
5415 Quantity (Base) (Quantity (Base)) Decimal (0:5)
5416 Outstanding Qty. (Base) (Outstanding Qty. (Base)) Decimal (0:5)
5417 Qty. to Invoice (Base) (Qty. to Invoice (Base)) Decimal (0:5)
5418 Qty. to Ship (Base) (Qty. to Ship (Base)) Decimal (0:5)
5458 Qty. Shipped Not Invd. (Base) (Qty. Shipped Not Invd. (Base)) Decimal (0:5)
5460 Qty. Shipped (Base) (Qty. Shipped (Base)) Decimal (0:5)
5461 Qty. Invoiced (Base) (Qty. Invoiced (Base)) Decimal (0:5)
5600 FA Posting Date (FA Posting Date) Date
5602 Depreciation Book Code (Depreciation Book Code) Code10
5605 Depr. until FA Posting Date (Depr. until FA Posting Date) Boolean
5612 Duplicate in Depreciation Book (Duplicate in Depreciation Book) Code10
5613 Use Duplication List (Use Duplication List) Boolean
5700 Responsibility Center (Responsibility Center) Code10
5701 Out-of-Stock Substitution (Out-of-Stock Substitution) Boolean
5702 Substitution Available (Substitution Available) Boolean Editable: No
FlowField
5703 Originally Ordered No. (Originally Ordered No.) Code20
5704 Originally Ordered Var. Code (Originally Ordered Var. Code) Code10
5705 Cross-Reference No. (Cross-Reference No.) Code20
5706 Unit of Measure (Cross Ref.) (Unit of Measure (Cross Ref.)) Code10
5707 Cross-Reference Type (Cross-Reference Type) Option
5708 Cross-Reference Type No. (Cross-Reference Type No.) Code30
5709 Item Category Code (Item Category Code) Code10
5710 Nonstock (Nonstock) Boolean
5711 Purchasing Code (Purchasing Code) Code10
5712 Product Group Code (Product Group Code) Code10
5713 Special Order (Special Order) Boolean
5714 Special Order Purchase No. (Special Order Purchase No.) Code20
5715 Special Order Purch. Line No. (Special Order Purch. Line No.) Integer
5752 Completely Shipped (Completely Shipped) Boolean
5790 Requested Delivery Date (Requested Delivery Date) Date
5791 Promised Delivery Date (Promised Delivery Date) Date
5792 Shipping Time (Shipping Time) DateFormula
5793 Outbound Whse. Handling Time (Outbound Whse. Handling Time) DateFormula
5794 Planned Delivery Date (Planned Delivery Date) Date
5795 Planned Shipment Date (Planned Shipment Date) Date
5796 Shipping Agent Code (Shipping Agent Code) Code10
5797 Shipping Agent Service Code (Shipping Agent Service Code) Code10
5800 Allow Item Charge Assignment (Allow Item Charge Assignment) Boolean
5803 Return Qty. to Receive (Return Qty. to Receive) Decimal (0:5)
5804 Return Qty. to Receive (Base) (Return Qty. to Receive (Base)) Decimal (0:5)
5805 Return Qty. Rcd. Not Invd. (Return Qty. Rcd. Not Invd.) Decimal (0:5)
5806 Ret. Qty. Rcd. Not Invd.(Base) (Ret. Qty. Rcd. Not Invd.(Base)) Decimal (0:5)
5807 Return Amt. Rcd. Not Invd. (Return Amt. Rcd. Not Invd.) Decimal
5808 Ret. Amt. Rcd. Not Invd. (LCY) (Ret. Amt. Rcd. Not Invd. (LCY)) Decimal
5809 Return Qty. Received (Return Qty. Received) Decimal (0:5)
5810 Return Qty. Received (Base) (Return Qty. Received (Base)) Decimal (0:5)
5811 Appl.-from Item Entry (Appl.-from Item Entry) Integer
5900 Service Contract No. (Service Contract No.) Code20
5901 Service Order No. (Service Order No.) Code20
5902 Service Item No. (Service Item No.) Code20
5903 Appl.-to Service Entry (Appl.-to Service Entry) Integer
5904 Service Item Line No. (Service Item Line No.) Integer
5907 Serv. Price Adjmt. Gr. Code (Serv. Price Adjmt. Gr. Code) Code10
5909 BOM Item No. (BOM Item No.) Code20
6600 Return Receipt No. (Return Receipt No.) Code20
6601 Return Receipt Line No. (Return Receipt Line No.) Integer
6608 Return Reason Code (Return Reason Code) Code10
7001 Allow Line Disc. (Allow Line Disc.) Boolean
7002 Customer Disc. Group (Customer Disc. Group) Code20

Keys

# Fields
0 Document Type,Document No.,Doc. No. Occurrence,Version No.,Line No. (Document Type,Document No.,Doc. No. Occurrence,Version No.,Line No.) Clustered: Yes
1 Document Type,Document No.,Line No.,Doc. No. Occurrence,Version No. (Document Type,Document No.,Line No.,Doc. No. Occurrence,Version No.)
2 Sell-to Customer No. (Sell-to Customer No.)
3 Bill-to Customer No. (Bill-to Customer No.)
4 Type,No. (Type,No.)

Table Relations To Other Tables

Field Related Table Related Field
Area (Area) Area Code (Code) 1..n
Bin Code (Bin Code) Bin Code (Code) 1..n
Currency Code (Currency Code) Currency Code (Code) 1..n
Bill-to Customer No. (Bill-to Customer No.) Customer No. (No.) 1..n
Customer Disc. Group (Customer Disc. Group) Customer Discount Group Code (Code) 1..n
Price Group Code (Price Group Code) Customer Price Group Code (Code) 1..n
Deferral Code (Deferral Code) Deferral Template Deferral Code (Deferral Code) 1..n
Duplicate in Depreciation Book (Duplicate in Depreciation Book) Depreciation Book Code (Code) 1..n
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Dimension Value Code (Code) 1..n
Exit Point (Exit Point) Entry/Exit Point Code (Code) 1..n
Posting Group (Posting Group) FA Posting Group Code (Code) 1..n
No. (No.) Fixed Asset No. (No.) 1..n
No. (No.) G/L Account No. (No.) 1..n
Gen. Bus. Posting Group (Gen. Bus. Posting Group) Gen. Business Posting Group Code (Code) 1..n
Gen. Prod. Posting Group (Gen. Prod. Posting Group) Gen. Product Posting Group Code (Code) 1..n
IC Partner Code (IC Partner Code) IC Partner Code (Code) 1..n
Posting Group (Posting Group) Inventory Posting Group Code (Code) 1..n
BOM Item No. (BOM Item No.) Item No. (No.) 1..n
Item Category Code (Item Category Code) Item Category Code (Code) 1..n
No. (No.) Item Charge No. (No.) 1..n
Unit of Measure (Cross Ref.) (Unit of Measure (Cross Ref.)) Item Unit of Measure Code (Code) 1..n
Originally Ordered Var. Code (Originally Ordered Var. Code) Item Variant Code (Code) 1..n
Job No. (Job No.) Job No. (No.) 1..n
Location Code (Location Code) Location () 1..n
Product Group Code (Product Group Code) Product Group Code (Code) 1..n
Special Order Purchase No. (Special Order Purchase No.) Purchase Header No. (No.) 1..n
Special Order Purch. Line No. (Special Order Purch. Line No.) Purchase Line Line No. (Line No.) 1..n
Purchasing Code (Purchasing Code) Purchasing Code (Code) 1..n
No. (No.) Resource No. (No.) 1..n
Responsibility Center (Responsibility Center) Responsibility Center Code (Code) 1..n
Return Reason Code (Return Reason Code) Return Reason Code (Code) 1..n
Blanket Order No. (Blanket Order No.) Sales Header No. (No.) 1..n
Document No. (Document No.) Sales Header Archive No. (No.) 1..n
Blanket Order Line No. (Blanket Order Line No.) Sales Line Line No. (Line No.) 1..n
Attached to Line No. (Attached to Line No.) Sales Line Archive Line No. (Line No.) 1..n
Service Contract No. (Service Contract No.) Service Contract Header Contract No. (Contract No.) 1..n
Service Item No. (Service Item No.) Service Item No. (No.) 1..n
Serv. Price Adjmt. Gr. Code (Serv. Price Adjmt. Gr. Code) Service Price Adjustment Group Code (Code) 1..n
Shipping Agent Code (Shipping Agent Code) Shipping Agent Code (Code) 1..n
Shipping Agent Service Code (Shipping Agent Service Code) Shipping Agent Services Code (Code) 1..n
No. (No.) Standard Text Code (Code) 1..n
Prepayment Tax Area Code (Prepayment Tax Area Code) Tax Area Code (Code) 1..n
Prepayment Tax Group Code (Prepayment Tax Group Code) Tax Group Code (Code) 1..n
Transaction Specification (Transaction Specification) Transaction Specification Code (Code) 1..n
Transaction Type (Transaction Type) Transaction Type Code (Code) 1..n
Transport Method (Transport Method) Transport Method Code (Code) 1..n
Unit of Measure Code (Unit of Measure Code) Unit of Measure Code (Code) 1..n
VAT Bus. Posting Group (VAT Bus. Posting Group) VAT Business Posting Group Code (Code) 1..n
VAT Prod. Posting Group (VAT Prod. Posting Group) VAT Product Posting Group Code (Code) 1..n
Work Type Code (Work Type Code) Work Type Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Sales Line Archive Attached to Line No. (Attached to Line No.) 1..n