Diagrams

Table

Purchase Line

DynamicsDocs.comPurchase Line«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 121»Purch. Rcpt. LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 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 Rcpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Qty. Rcd. Not InvoicedQuantity InvoicedOrder No....«Table 123»Purch. Inv. LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityDirect 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 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Receipt No....«Table 125»Purch. Cr. Memo LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityDirect 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 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Pay-to Vendor No....«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 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 5805»Item Charge Assignment (Purch)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 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method 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 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 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 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 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 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 LCY«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 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 5626»MaintenanceCode [PK,NN]Description«Table 5628»InsuranceNo. [PK]Effective DateExpiration DatePolicy No.Annual PremiumPolicy CoverageTotal Value InsuredCommentInsurance TypeLast Date ModifiedInsurance Vendor No.FA Class CodeFA Subclass CodeFA Location CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeBlockedDescriptionSearch DescriptionDate FilterNo. Series«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 GroupAcquiredImage...«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]Parent CategoryDescriptionIndentationPresentation OrderHas Children«Table 5721»PurchasingCode [PK,NN]DescriptionDrop ShipmentSpecial Order«Table 6635»Return ReasonCode [PK,NN]DescriptionDefault Location CodeInventory Value Zero«Table 99000763»Routing HeaderNo. [PK]DescriptionDescription 2Search DescriptionLast Date ModifiedCommentStatus; [New,Certified,Under Developme...Type; [Serial,Parallel]Version Nos.No. Series«Table 5409»Prod. Order Routing LineRouting No. [PK]Routing Reference No. [PK]Operation No. [PK,NN]Next Operation No.Previous Operation No.Type; [Work Center,Machine Center]No.Work Center No.Work Center Group CodeDescriptionSetup TimeRun TimeWait TimeMove TimeFixed Scrap QuantityLot SizeScrap Factor %Setup Time Unit of Meas. CodeRun Time Unit of Meas. CodeWait Time Unit of Meas. CodeMove Time Unit of Meas. CodeMinimum Process TimeMaximum Process TimeConcurrent CapacitiesSend-Ahead QuantityRouting Link CodeStandard Task CodeUnit Cost perRecalculateSequence No. [Forward]Sequence No. [Backward]...«Table 99000754»Work CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeAlternate Work CenterWork Center Group CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeSubcontractor No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentUnit of Measure CodeCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyCalendar Rounding Precision [NN]Simulation Type; [Moves,Moves When Nec...Shop Calendar CodeBlockedDate FilterWork Shift Filter...«Table 5406»Prod. Order LineStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK]Line No. [PK]Item No.Variant CodeDescriptionDescription 2Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodeQuantityFinished QuantityRemaining QuantityScrap %Due DateStarting DateStarting TimeEnding DateEnding TimePlanning Level CodePriorityProduction BOM No.Routing No.Inventory Posting GroupRouting Reference No.Unit CostCost AmountReserved QuantityCapacity Type Filter; [Work Center,Mac...Capacity No. Filter...<Buy-from Vendor No.><Pay-to Vendor No.><Document No.><Blanket Order No.><Location Code><Posting Group><Posting Group><Job 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><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><Maintenance Code><Insurance No.><Budgeted FA No.><Responsibility Center><Item Category Code><Purchasing Code><Return Reason Code><Routing No.><Operation No.><Work Center No.><Prod. Order Line No.><Blanket Order Line No.><Blanket Order Line No.><Blanket Order Line No.><Purch. Order Line No.><Special Order Purch. Line No.><Blanket Order Line No.><Document Line No.><Applies-to Doc. Line No.><Buy-from Vendor No.><Pay-to Vendor No.><No.><Budgeted FA 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><Maintenance Code><Insurance No.><Responsibility Center><Item Category Code><Purchasing Code><Return Reason Code><Routing No.><Operation No.><Work Center No.><Prod. Order Line No.><Applies-to Doc. Line No.><Buy-from Vendor No.><Pay-to Vendor No.><No.><Budgeted FA 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.><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><Maintenance Code><Insurance No.><Responsibility Center><Item Category Code><Purchasing Code><Return Reason Code><Routing No.><Operation No.><Work Center No.><Prod. Order Line No.><Buy-from Vendor No.><Pay-to Vendor No.><No.><Budgeted FA 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.><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><Maintenance Code><Insurance No.><Responsibility Center><Item Category Code><Purchasing Code><Return Reason Code><Document No.><Blanket Order No.><Location Code><Posting Group><Posting Group><Job No.><Purchase Order No.><Special Order Purchase 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><VAT Bus. Posting Group><VAT Prod. Posting Group><Prepayment Tax Group Code><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><Depreciation Book Code><Duplicate in Depreciation Book><Responsibility Center><Item Category Code><Purchasing Code><Return Reason Code><Blanket Order Line No.><Sales Order Line No.><Special Order Sales Line No.><No.><Location Code><Posting Group><Posting Group><Job No.><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><Return Reason Code><Buy-from Vendor No.><Pay-to Vendor No.><No.><Budgeted FA 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><Maintenance Code><Insurance No.><Responsibility Center><Item Category Code><Purchasing Code><Return Reason Code><Routing No.><Operation No.><Work Center No.><Prod. Order Line No.><Document No.><Applies-to Doc. No.><Pay-to Vendor No.><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><IC Partner Code><Vendor No.><Responsibility Center><Location Code><Buy-from Vendor No.><Pay-to Vendor No.><Vendor No.><Maintenance Vendor No.><Insurance Vendor No.><Subcontractor No.><Location Code><Location Filter><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><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 Code><Location Code><Default Location Code><Location Code><Location Code><Inventory Posting Group><FA Posting Group><Job No.><Gen. Bus. Posting Group><Transaction Type><Transport Method><Exit Point><Transaction Specification><VAT Bus. Posting Group><Sell-to IC Partner Code><Bill-to IC Partner Code><Responsibility Center><Def. VAT Bus. Posting Group><Def. VAT Prod. Posting Group><Gen. Prod. Posting Group><Variant Code><Variant Code><Bin Code><Unit of Measure Code><Unit of Measure Filter><Bin Code><Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Code><Unit of Measure Code><Component of Main Asset><Parent Category><Routing No.><Routing No.><No.><Work Center No.><Alternate Work Center><Capacity No. 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 Buy-from Vendor No. (Buy-from Vendor No.) Code20 Editable: No
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 Editable: No
10 Expected Receipt Date (Expected Receipt 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) Editable: No
17 Qty. to Invoice (Qty. to Invoice) Decimal (0:5)
18 Qty. to Receive (Qty. to Receive) Decimal (0:5)
22 Direct Unit Cost (Direct Unit Cost) Decimal
23 Unit Cost (LCY) (Unit Cost (LCY)) Decimal
25 VAT % (VAT %) Decimal (0:5) Editable: No
27 Line Discount % (Line Discount %) Decimal (0:5)
28 Line Discount Amount (Line Discount Amount) Decimal
29 Amount (Amount) Decimal Editable: No
30 Amount Including VAT (Amount Including VAT) Decimal Editable: No
31 Unit Price (LCY) (Unit Price (LCY)) 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
45 Job No. (Job No.) Code20
54 Indirect Cost % (Indirect Cost %) Decimal (0:5)
56 Recalculate Invoice Disc. (Recalculate Invoice Disc.) Boolean Editable: No
57 Outstanding Amount (Outstanding Amount) Decimal Editable: No
58 Qty. Rcd. Not Invoiced (Qty. Rcd. Not Invoiced) Decimal (0:5) Editable: No
59 Amt. Rcd. Not Invoiced (Amt. Rcd. Not Invoiced) Decimal Editable: No
60 Quantity Received (Quantity Received) Decimal (0:5) Editable: No
61 Quantity Invoiced (Quantity Invoiced) Decimal (0:5) Editable: No
63 Receipt No. (Receipt No.) Code20 Editable: No
64 Receipt Line No. (Receipt Line No.) Integer Editable: No
67 Profit % (Profit %) Decimal (0:5) Editable: No
68 Pay-to Vendor No. (Pay-to Vendor No.) Code20 Editable: No
69 Inv. Discount Amount (Inv. Discount Amount) Decimal Editable: No
70 Vendor Item No. (Vendor Item No.) Text20
71 Sales Order No. (Sales Order No.) Code20 Editable: No
72 Sales Order Line No. (Sales Order Line No.) Integer Editable: No
73 Drop Shipment (Drop Shipment) Boolean Editable: No
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 Editable: No
78 Transaction Type (Transaction Type) Code10
79 Transport Method (Transport Method) Code10
80 Attached to Line No. (Attached to Line No.) Integer Editable: No
81 Entry Point (Entry 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
88 Use Tax (Use Tax) Boolean
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 Editable: No
92 Outstanding Amount (LCY) (Outstanding Amount (LCY)) Decimal Editable: No
93 Amt. Rcd. Not Invoiced (LCY) (Amt. Rcd. Not Invoiced (LCY)) Decimal Editable: No
95 Reserved Quantity (Reserved Quantity) Decimal (0:5) Editable: No
FlowField
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 Editable: No
100 Unit Cost (Unit Cost) Decimal Editable: No
101 System-Created Entry (System-Created Entry) Boolean Editable: No
103 Line Amount (Line Amount) Decimal
104 VAT Difference (VAT Difference) Decimal Editable: No
105 Inv. Disc. Amount to Invoice (Inv. Disc. Amount to Invoice) Decimal Editable: No
106 VAT Identifier (VAT Identifier) Code10 Editable: No
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
129 Prepmt. Amount Inv. (LCY) (Prepmt. Amount Inv. (LCY)) Decimal Editable: No
130 IC Partner Code (IC Partner Code) Code20
132 Prepmt. VAT Amount Inv. (LCY) (Prepmt. VAT Amount Inv. (LCY)) Decimal Editable: No
135 Prepayment VAT Difference (Prepayment VAT Difference) Decimal Editable: No
136 Prepmt VAT Diff. to Deduct (Prepmt VAT Diff. to Deduct) Decimal Editable: No
137 Prepmt VAT Diff. Deducted (Prepmt VAT Diff. Deducted) Decimal Editable: No
140 Outstanding Amt. Ex. VAT (LCY) (Outstanding Amt. Ex. VAT (LCY)) Decimal
141 A. Rcd. Not Inv. Ex. VAT (LCY) (A. Rcd. Not Inv. Ex. VAT (LCY)) Decimal
480 Dimension Set ID (Dimension Set ID) Integer Editable: No
1001 Job Task No. (Job Task No.) Code20
1002 Job Line Type (Job Line Type) Option
1003 Job Unit Price (Job Unit Price) Decimal BlankZero: Yes
1004 Job Total Price (Job Total Price) Decimal BlankZero: Yes
Editable: No
1005 Job Line Amount (Job Line Amount) Decimal BlankZero: Yes
1006 Job Line Discount Amount (Job Line Discount Amount) Decimal BlankZero: Yes
1007 Job Line Discount % (Job Line Discount %) Decimal (0:5) BlankZero: Yes
1008 Job Unit Price (LCY) (Job Unit Price (LCY)) Decimal BlankZero: Yes
Editable: No
1009 Job Total Price (LCY) (Job Total Price (LCY)) Decimal BlankZero: Yes
Editable: No
1010 Job Line Amount (LCY) (Job Line Amount (LCY)) Decimal BlankZero: Yes
Editable: No
1011 Job Line Disc. Amount (LCY) (Job Line Disc. Amount (LCY)) Decimal BlankZero: Yes
Editable: No
1012 Job Currency Factor (Job Currency Factor) Decimal BlankZero: Yes
1013 Job Currency Code (Job Currency Code) Code20
1019 Job Planning Line No. (Job Planning Line No.) Integer BlankZero: Yes
1030 Job Remaining Qty. (Job Remaining Qty.) Decimal (0:5)
1031 Job Remaining Qty. (Base) (Job Remaining Qty. (Base)) Decimal
1700 Deferral Code (Deferral Code) Code10
1702 Returns Deferral Start Date (Returns Deferral Start Date) Date
5401 Prod. Order No. (Prod. Order No.) Code20 Editable: No
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) Editable: No
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) Editable: No
5417 Qty. to Invoice (Base) (Qty. to Invoice (Base)) Decimal (0:5)
5418 Qty. to Receive (Base) (Qty. to Receive (Base)) Decimal (0:5)
5458 Qty. Rcd. Not Invoiced (Base) (Qty. Rcd. Not Invoiced (Base)) Decimal (0:5) Editable: No
5460 Qty. Received (Base) (Qty. Received (Base)) Decimal (0:5) Editable: No
5461 Qty. Invoiced (Base) (Qty. Invoiced (Base)) Decimal (0:5) Editable: No
5495 Reserved Qty. (Base) (Reserved Qty. (Base)) Decimal (0:5) Editable: No
FlowField
5600 FA Posting Date (FA Posting Date) Date
5601 FA Posting Type (FA Posting Type) Option
5602 Depreciation Book Code (Depreciation Book Code) Code10
5603 Salvage Value (Salvage Value) Decimal
5605 Depr. until FA Posting Date (Depr. until FA Posting Date) Boolean
5606 Depr. Acquisition Cost (Depr. Acquisition Cost) Boolean
5609 Maintenance Code (Maintenance Code) Code10
5610 Insurance No. (Insurance No.) Code20
5611 Budgeted FA No. (Budgeted FA No.) Code20
5612 Duplicate in Depreciation Book (Duplicate in Depreciation Book) Code10
5613 Use Duplication List (Use Duplication List) Boolean
5700 Responsibility Center (Responsibility Center) Code10 Editable: No
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) Code20
5710 Nonstock (Nonstock) Boolean
5711 Purchasing Code (Purchasing Code) Code10 Editable: No
5712 Product Group Code (Product Group Code) Code10
5713 Special Order (Special Order) Boolean
5714 Special Order Sales No. (Special Order Sales No.) Code20
5715 Special Order Sales Line No. (Special Order Sales Line No.) Integer
5750 Whse. Outstanding Qty. (Base) (Whse. Outstanding Qty. (Base)) Decimal (0:5) BlankZero: Yes
Editable: No
FlowField
5752 Completely Received (Completely Received) Boolean Editable: No
5790 Requested Receipt Date (Requested Receipt Date) Date
5791 Promised Receipt Date (Promised Receipt Date) Date
5792 Lead Time Calculation (Lead Time Calculation) DateFormula
5793 Inbound Whse. Handling Time (Inbound Whse. Handling Time) DateFormula
5794 Planned Receipt Date (Planned Receipt Date) Date
5795 Order Date (Order Date) Date
5800 Allow Item Charge Assignment (Allow Item Charge Assignment) Boolean
5801 Qty. to Assign (Qty. to Assign) Decimal (0:5) Editable: No
FlowField
5802 Qty. Assigned (Qty. Assigned) Decimal (0:5) Editable: No
FlowField
5803 Return Qty. to Ship (Return Qty. to Ship) Decimal (0:5)
5804 Return Qty. to Ship (Base) (Return Qty. to Ship (Base)) Decimal (0:5)
5805 Return Qty. Shipped Not Invd. (Return Qty. Shipped Not Invd.) Decimal (0:5) Editable: No
5806 Ret. Qty. Shpd Not Invd.(Base) (Ret. Qty. Shpd Not Invd.(Base)) Decimal (0:5) Editable: No
5807 Return Shpd. Not Invd. (Return Shpd. Not Invd.) Decimal Editable: No
5808 Return Shpd. Not Invd. (LCY) (Return Shpd. Not Invd. (LCY)) Decimal Editable: No
5809 Return Qty. Shipped (Return Qty. Shipped) Decimal (0:5) Editable: No
5810 Return Qty. Shipped (Base) (Return Qty. Shipped (Base)) Decimal (0:5) Editable: No
6600 Return Shipment No. (Return Shipment No.) Code20 Editable: No
6601 Return Shipment Line No. (Return Shipment Line No.) Integer Editable: No
6608 Return Reason Code (Return Reason Code) Code10
99000750 Routing No. (Routing No.) Code20
99000751 Operation No. (Operation No.) Code10 Editable: No
99000752 Work Center No. (Work Center No.) Code20 Editable: No
99000753 Finished (Finished) Boolean
99000754 Prod. Order Line No. (Prod. Order Line No.) Integer Editable: No
99000755 Overhead Rate (Overhead Rate) Decimal (0:5)
99000756 MPS Order (MPS Order) Boolean
99000757 Planning Flexibility (Planning Flexibility) Option
99000758 Safety Lead Time (Safety Lead Time) DateFormula
99000759 Routing Reference No. (Routing Reference No.) Integer

Keys

# Fields
0 Document Type,Document No.,Line No. (Document Type,Document No.,Line No.) Clustered: Yes
MaintainSIFTIndex: No
1 Document No.,Line No.,Document Type (Document No.,Line No.,Document Type)
2 Document Type,Type,No.,Variant Code,Drop Shipment,Location Code,Expected Receipt Date (Document Type,Type,No.,Variant Code,Drop Shipment,Location Code,Expected Receipt Date) MaintainSIFTIndex: No
3 Document Type,Pay-to Vendor No.,Currency Code (Document Type,Pay-to Vendor No.,Currency Code) MaintainSIFTIndex: No
4 Document Type,Type,No.,Variant Code,Drop Shipment,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Location Code,Expected Receipt Date (Document Type,Type,No.,Variant Code,Drop Shipment,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Location Code,Expected Receipt Date) MaintainSQLIndex: No
MaintainSIFTIndex: No
5 Document Type,Pay-to Vendor No.,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Currency Code (Document Type,Pay-to Vendor No.,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Currency Code) MaintainSQLIndex: No
MaintainSIFTIndex: No
6 Document Type,Blanket Order No.,Blanket Order Line No. (Document Type,Blanket Order No.,Blanket Order Line No.)
7 Document Type,Type,Prod. Order No.,Prod. Order Line No.,Routing No.,Operation No. (Document Type,Type,Prod. Order No.,Prod. Order Line No.,Routing No.,Operation No.)
8 Document Type,Document No.,Location Code (Document Type,Document No.,Location Code)
9 Document Type,Receipt No.,Receipt Line No. (Document Type,Receipt No.,Receipt Line No.)
10 Type,No.,Variant Code,Drop Shipment,Location Code,Document Type,Expected Receipt Date (Type,No.,Variant Code,Drop Shipment,Location Code,Document Type,Expected Receipt Date) MaintainSQLIndex: No
11 Document Type,Buy-from Vendor No. (Document Type,Buy-from Vendor No.)
12 Document Type,Job No.,Job Task No. (Document Type,Job No.,Job Task No.)
13 Document Type,Document No.,Type,No. (Document Type,Document No.,Type,No.)
14 Document Type,Type,No. (Document Type,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
Bin Code (Bin Code) Bin Content Bin Code (Bin Code) 1..n
Currency Code (Currency Code) Currency 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
Entry Point (Entry Point) Entry/Exit Point Code (Code) 1..n
Posting Group (Posting Group) FA Posting Group Code (Code) 1..n
Budgeted FA No. (Budgeted FA No.) Fixed Asset 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
Insurance No. (Insurance No.) Insurance No. (No.) 1..n
Posting Group (Posting Group) Inventory Posting Group Code (Code) 1..n
Item Category Code (Item Category Code) Item Category Code (Code) 1..n
Unit of Measure (Cross Ref.) (Unit of Measure (Cross Ref.)) Item Unit of Measure Code (Code) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
Job No. (Job No.) Job No. (No.) 1..n
Job Task No. (Job Task No.) Job Task Job Task No. (Job Task No.) 1..n
Location Code (Location Code) Location () 1..n
Maintenance Code (Maintenance Code) Maintenance Code (Code) 1..n
Prod. Order Line No. (Prod. Order Line No.) Prod. Order Line Line No. (Line No.) 1..n
Operation No. (Operation No.) Prod. Order Routing Line Operation No. (Operation No.) 1..n
Blanket Order No. (Blanket Order No.) Purchase Header No. (No.) 1..n
Blanket Order Line No. (Blanket Order Line No.) Purchase Line Line No. (Line No.) 1..n
Purchasing Code (Purchasing Code) Purchasing Code (Code) 1..n
Responsibility Center (Responsibility Center) Responsibility Center Code (Code) 1..n
Return Reason Code (Return Reason Code) Return Reason Code (Code) 1..n
Routing No. (Routing No.) Routing Header No. (No.) 1..n
Special Order Sales No. (Special Order Sales No.) Sales Header No. (No.) 1..n
Special Order Sales Line No. (Special Order Sales Line No.) Sales Line Line No. (Line No.) 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
Pay-to Vendor No. (Pay-to Vendor No.) Vendor No. (No.) 1..n
Work Center No. (Work Center No.) Work Center No. (No.) 1..n

Table Relations From Other Tables

From Table From Field
Item Charge Assignment (Purch) Applies-to Doc. Line No. (Applies-to Doc. Line No.) 1..n
Purch. Cr. Memo Line Blanket Order Line No. (Blanket Order Line No.) 1..n
Purch. Inv. Line Blanket Order Line No. (Blanket Order Line No.) 1..n
Purch. Rcpt. Line Blanket Order Line No. (Blanket Order Line No.) 1..n
Purchase Line Blanket Order Line No. (Blanket Order Line No.) 1..n
Purchase Line Archive Blanket Order Line No. (Blanket Order Line No.) 1..n
Sales Line Special Order Purch. Line No. (Special Order Purch. Line No.) 1..n
Sales Line Archive Special Order Purch. Line No. (Special Order Purch. Line No.) 1..n