Diagrams

Table

Sales Line

DynamicsDocs.comSales Line«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 111»Sales Shipment LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeQty. Shipped Not InvoicedQuantity InvoicedOrder No....«Table 113»Sales Invoice LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit 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 CodeCustomer Price GroupJob No.Work Type CodeShipment No....«Table 115»Sales Cr.Memo LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit 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 CodeCustomer Price GroupJob No.Work Type CodeBill-to Customer No....«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 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 5110»Purchase Line ArchiveDocument 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 %Quantity Disc. %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item Entry...«Table 5809»Item Charge Assignment (Sales)Document Type; [Quote,Order,Invoice,Cr...Document No. [PK]Document Line No. [PK]Line No. [PK]Item Charge No. [NN]Item No.DescriptionQty. to AssignQty. AssignedUnit CostAmount to AssignApplies-to Doc. Type; [Quote,Order,Inv...Applies-to Doc. No.Applies-to Doc. Line No.Applies-to Doc. Line Amount«Table 6651»Return Shipment LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Unit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Quantity InvoicedPay-to Vendor No.Vendor Item No.Gen. Bus. Posting Group...«Table 6661»Return Receipt LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Rcpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeQuantity InvoicedBill-to Customer No.Gen. Bus. Posting Group...«Table 904»Assemble-to-Order LinkAssembly Document Type; [Quote,Order,I...Assembly Document No. [PK]Type; [,Sale]Document Type; [Quote,Order,Invoice,Cr...Document No.Document Line No.Assembled Quantity«Table 99000800»Sales Planning LineSales Order No. [PK]Sales Order Line No. [PK]Item No.DescriptionShipment DateAvailableNext Planning DateExpected Delivery DatePlanning Status; [None,Simulated,Plann...Needs ReplanningVariant CodePlanned QuantityLow-Level Code«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 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 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]DescriptionUsed in ItemsUsed in Value Entries«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,Open,Completed...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 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]DescriptionLast Modified Date TimeId«Table 321»Tax GroupCode [PK,NN]DescriptionIdLast Modified DateTime«Table 560»VAT ClauseCode [PK,NN]DescriptionDescription 2Last Modified DateTimeId«Table 323»VAT Business Posting GroupCode [PK,NN]DescriptionLast Modified Date TimeId«Table 324»VAT Product Posting GroupCode [PK,NN]DescriptionIdLast Modified DateTime«Table 413»IC PartnerCode [PK,NN]NameCurrency CodeInbox Type; [File Location,Database,Em...Inbox DetailsReceivables AccountPayables AccountBlockedCommentCustomer No.Vendor No.Outbound Sales Item No. Type; [Interna...Outbound Purch. Item No. Type; [Intern...Cost Distribution in LCYAuto. Accept Transactions«Table 1001»Job TaskJob No. [PK,NN]Job Task No. [PK,NN]DescriptionJob Task Type; [Posting,Heading,Total,...WIP-Total; [,Total,Excluded]Job Posting GroupWIP MethodSchedule [Total Cost]Schedule [Total Price]Usage [Total Cost]Usage [Total Price]Contract [Total Cost]Contract [Total Price]Contract [Invoiced Price]Contract [Invoiced Cost]Posting Date FilterPlanning Date FilterTotalingNew PageNo. of Blank LinesIndentationRecognized Sales AmountRecognized Costs AmountRecognized Sales G/L AmountRecognized Costs G/L AmountGlobal Dimension 1 CodeGlobal Dimension 2 CodeOutstanding OrdersAmt. Rcd. Not InvoicedRemaining [Total Cost]Remaining [Total Price]...«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 7302»Bin ContentLocation Code [PK,NN]Zone Code [NN]Bin Code [PK,NN]Item No. [PK,NN]Bin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Min. Qty.Max. Qty.Bin RankingQuantityPick Qty.Neg. Adjmt. Qty.Put-away Qty.Pos. Adjmt. Qty.FixedCross-Dock BinDefaultQuantity [Base]Pick Quantity [Base]Negative Adjmt. Qty. [Base]Put-away Quantity [Base]Positive Adjmt. Qty. [Base]ATO Components Pick Qty.ATO Components Pick Qty [Base]Variant Code [PK]Qty. per Unit of MeasureUnit of Measure Code [PK,NN]Lot No. FilterSerial No. FilterDedicated...«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 205»Resource Unit of MeasureResource No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureRelated to Base Unit of Meas.«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard CodeSymbolLast Modified Date TimeId«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 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 5722»Item CategoryCode [PK,NN]Parent CategoryDescriptionIndentationPresentation OrderHas ChildrenLast Modified Date TimeId«Table 5721»PurchasingCode [PK,NN]DescriptionDrop ShipmentSpecial Order«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 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.><Blanket Order No.><Location Code><Posting Group><Posting Group><Customer Price Group><Job No.><Work Type Code><Purchase Order No.><Special Order Purchase No.><Purch. Order Line No.><Special Order Purch. Line No.><Sales Order Line No.><Special Order Sales Line No.><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Blanket Order Line No.><Exit Point><Transaction Specification><Tax Area Code><Prepayment Tax Area Code><Tax Group Code><Prepayment Tax Group Code><VAT Clause Code><VAT Bus. Posting Group><VAT Prod. Posting Group><IC Partner Code><Job Task No.><Deferral Code><Variant Code><Originally Ordered Var. Code><Bin Code><Bin Code><Unit of Measure Code><Unit of Measure (Cross Ref.)><Unit of Measure Code><Unit of Measure Code><Depreciation Book Code><Duplicate in Depreciation Book><Responsibility Center><Originally Ordered No.><BOM Item No.><Item Category Code><Purchasing Code><Shipping Agent Code><Shipping Agent Service Code><Return Reason Code><Customer Disc. Group><Blanket Order Line No.><Blanket Order Line No.><Blanket Order Line No.><Blanket Order Line No.><Sales Order Line No.><Special Order Sales Line No.><Document Line No.><Applies-to Doc. Line No.><Blanket Order Line No.><Blanket Order Line No.><Document No.><Sales Order Line No.><Sell-to Customer No.><Bill-to Customer No.><No.><Location Code><Posting Group><Posting Group><Customer Price Group><Job No.><Work Type Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Exit Point><Transaction Specification><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Blanket Order No.><Job Task No.><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><Return Reason Code><Customer Disc. Group><Applies-to Doc. Line No.><Sell-to Customer No.><Bill-to Customer No.><No.><Location Code><Posting Group><Posting Group><Customer Price Group><Job No.><Work Type Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Exit Point><Transaction Specification><Tax Area Code><Tax Group Code><VAT Clause Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Blanket Order No.><IC Partner Code><Job Task No.><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><Return Reason Code><Customer Disc. Group><Sell-to Customer No.><Bill-to Customer No.><No.><Location Code><Posting Group><Posting Group><Customer Price Group><Job No.><Work Type Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Exit Point><Transaction Specification><Tax Area Code><Tax Group Code><VAT Clause Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Blanket Order No.><IC Partner Code><Job Task No.><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><Return Reason Code><Customer Disc. Group><Document No.><Blanket Order No.><Location Code><Posting Group><Posting Group><Job No.><Sales Order No.><Special Order Sales 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><Job Task No.><Deferral Code><Variant Code><Bin 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><Return Reason Code><Purch. Order Line No.><Special Order Purch. Line No.><Blanket Order Line No.><Sell-to Customer No.><Bill-to Customer No.><No.><Originally Ordered No.><BOM Item No.><Location Code><Posting Group><Posting Group><Price Group Code><Job No.><Work Type Code><Purchase Order No.><Special Order Purchase 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.><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><Shipping Agent Code><Shipping Agent Service Code><Return Reason Code><Customer Disc. Group><No.><Location Code><Posting Group><Posting Group><Job No.><Sales Order No.><Special Order Sales No.><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Transaction Type><Transport Method><Attached to 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><Blanket Order No.><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><Return Reason Code><Document No.><Applies-to Doc. No.><Item No.><Applies-to Doc. Line No.><No.><Location Code><Posting Group><Posting Group><Job No.><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Entry Point><Transaction Specification><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Blanket Order No.><Job Task No.><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><Return Reason Code><Sell-to Customer No.><Bill-to Customer No.><No.><Location Code><Posting Group><Posting Group><Customer Price Group><Job No.><Work Type Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Exit Point><Transaction Specification><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Blanket Order No.><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><Return Reason Code><Customer Disc. Group><Sales Order No.><Item No.><Variant Code><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.><Location Code><Location Filter><Customer Price Group><Customer Disc. Group><Gen. Bus. Posting Group><Transaction Type><Transport Method><Exit Point><Transaction Specification><Shipping Agent Code><VAT Bus. Posting Group><Sell-to IC Partner Code><Bill-to IC Partner Code><Responsibility Center><Shipping Agent Service Code><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 Filter><Location Code><Location Filter><Location Code><Default Location Code><Location Code><Inventory Posting Group><VAT Bus. Posting Gr. (Price)><Customer Price Group><Customer Disc. Group><Job No.><Unit of Measure 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><Def. VAT Bus. Posting Group><Def. VAT Prod. Posting Group><Gen. Prod. Posting Group><Tax Group Code><Tax Group Id><VAT Bus. Posting Gr. (Price)><VAT Prod. Posting Group><Default Deferral Template Code><Item No.><Variant Filter><Variant Code><Bin Code><Item No.><Unit of Measure Code><Unit of Measure Filter><Item Filter><Bin Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Code><Code><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Unit of Measure Id><Alternative Item No.><Item Category Code><Parent Category><Shipping Agent Code>

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

Fields

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

Keys

# Fields
0 Document Type,Document No.,Line No. Clustered: Yes
1 Document No.,Line No.,Document Type
2 Document Type,Type,No.,Variant Code,Drop Shipment,Location Code,Shipment Date
3 Document Type,Bill-to Customer No.,Currency Code
4 Document Type,Type,No.,Variant Code,Drop Shipment,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Location Code,Shipment Date
5 Document Type,Bill-to Customer No.,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Currency Code
6 Document Type,Blanket Order No.,Blanket Order Line No.
7 Document Type,Document No.,Location Code
8 Document Type,Shipment No.,Shipment Line No.
9 Type,No.,Variant Code,Drop Shipment,Location Code,Document Type,Shipment Date MaintainSQLIndex: No
10 Document Type,Sell-to Customer No.,Shipment No.
11 Job Contract Entry No.
12 Document Type,Document No.,Qty. Shipped Not Invoiced
13 Document Type,Document No.,Type,No.

Table Relations To Other Tables

Field Related Table Related Field
Area Area Code 1..n
Bin Code Bin Code