Diagrams

Table

Sales Header

DynamicsDocs.comSales Header«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 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 2115»O365 Coupon ClaimClaim ID [PK]Graph Contact ID [PK]Usage; [oneTime,multiUse]OfferTermsCodeExpirationDiscount ValueDiscount Type; [Custom,%,Amount]Created DateTimeIs ValidStatus TextAmount TextIs appliedDocument Type Filter; [Quote,Order,Inv...Document No. FilterOffer BlobTerms BlobLast Modified DateTimeCustomer Id«Table 2116»O365 Coupon Claim Doc. LinkClaim ID [PK]Document Type; [Quote,Order,Invoice,Cr...Document No. [PK]Graph Contact ID [PK]«Table 246»Requisition LineWorksheet Template Name [PK]Journal Batch Name [PK]Line No. [PK]Type; [,G/L Account,Item]No.DescriptionDescription 2QuantityVendor No.Direct Unit CostDue DateRequester IDConfirmedShortcut Dimension 1 CodeShortcut Dimension 2 CodeLocation CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring FrequencyOrder DateVendor Item No.Sales Order No.Sales Order Line No.Sell-to Customer No.Ship-to CodeOrder Address CodeCurrency CodeCurrency FactorReserved QuantityDimension Set IDProd. Order 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 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 5092»OpportunityNo. [PK]DescriptionSalesperson CodeCampaign No.Contact No.Contact Company No.Sales Cycle CodeSales Document No.Creation DateStatus; [Not Started,In Progress,Won,L...Priority; [Low,Normal,High]ClosedDate ClosedNo. SeriesCommentCurrent Sales Cycle StageEstimated Value [LCY]Probability %Calcd. Current Value [LCY]Chances of Success %Completed %Contact NameContact Company NameSalesperson NameCampaign DescriptionSegment No.Estimated Closing DateSales Document Type; [,Quote,Order,Pos...No. of InteractionsWizard Step; [,1,2,3,4,5,6]Activate First Stage...«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 5405»Production OrderStatus; [Simulated,Planned,Firm Planne...No. [PK]DescriptionSearch DescriptionDescription 2Creation DateLast Date ModifiedSource Type; [Item,Family,Sales Header...Source No.Routing No.Inventory Posting GroupGen. Prod. Posting GroupGen. Bus. Posting GroupCommentStarting TimeStarting DateEnding TimeEnding DateDue DateFinished DateBlockedShortcut Dimension 1 CodeShortcut Dimension 2 CodeLocation CodeBin CodeReplan Ref. No.Replan Ref. Status; [Simulated,Planned...Low-Level CodeQuantityUnit CostCost Amount...«Table 5765»Warehouse RequestSource Type [PK]Source Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No. [PK]Source Document; [,Sales Order,,,Sales...Document Status; [Open,Released]Location Code [PK]Shipment Method CodeShipping Agent CodeShipping Advice; [Partial,Complete]Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Expected Receipt DateShipment DateType; [Inbound,Outbound] [PK]Put-away / Pick No.Completely Handled«Table 5766»Warehouse Activity HeaderType; [,Put-away,Pick,Movement,Invt. P...No. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeSorting Method; [,Item,Document,Shelf...No. SeriesCommentNo. PrintedNo. of LinesSource Type FilterSource Subtype Filter; [0,1,2,3,4,5,6,...Source No. FilterLocation FilterPosting DateRegistering No.Last Registering No.Registering No. SeriesDate of Last PrintingTime of Last PrintingBreakbulk FilterSource No.Source Document; [,Sales Order,,,Sales...Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Expected Receipt DateShipment Date...«Table 5767»Warehouse Activity LineActivity Type; [,Put-away,Pick,Movemen...No. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Sorting Sequence No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDescriptionDescription 2QuantityQty. [Base]Qty. OutstandingQty. Outstanding [Base]Qty. to HandleQty. to Handle [Base]Qty. HandledQty. Handled [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Shipping Agent Code...«Table 5773»Registered Whse. Activity LineActivity Type; [,Put-away,Pick,Movemen...No. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Sorting Sequence No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDescriptionDescription 2QuantityQty. [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Whse. Activity No.Shipping Agent CodeShipping Agent Service CodeShipment Method CodeStarting DateSerial No.Lot No....«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 7340»Posted Invt. Put-away HeaderNo. [PK]Location Code [NN]Assigned User IDAssignment DateAssignment TimeRegistering DateNo. SeriesCommentInvt. Put-away No.No. PrintedPosting DateSource No.Source Document; [,Sales Order,,,Sales...Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Expected Receipt DateExternal Document No.2«Table 7341»Posted Invt. Put-away LineNo. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Sorting Sequence No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDescriptionDescription 2QuantityQty. [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Whse. Activity No.Shipping Agent CodeShipping Agent Service CodeShipment Method CodeSerial No.Lot No.Warranty DateExpiration Date...«Table 7342»Posted Invt. Pick HeaderNo. [PK]Location Code [NN]Assigned User IDAssignment DateAssignment TimeRegistering DateNo. SeriesCommentInvt Pick No.No. PrintedPosting DateSource No.Source Document; [,Sales Order,,,Sales...Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Shipment DateExternal Document No.2«Table 7343»Posted Invt. Pick LineNo. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Sorting Sequence No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDescriptionDescription 2QuantityQty. [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Whse. Activity No.Shipping Agent CodeShipping Agent Service CodeShipment Method CodeSerial No.Lot No.Warranty DateExpiration Date...«Table 7344»Registered Invt. Movement Hdr.No. [PK]Location Code [NN]Assigned User IDAssignment DateAssignment TimeRegistering DateNo. SeriesCommentInvt. Movement No.No. PrintedPosting DateSource No.Source Document; [,Sales Order,,,Sales...Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Shipment DateExternal Document No.2«Table 7345»Registered Invt. Movement LineNo. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Sorting Sequence No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDescriptionDescription 2QuantityQty. [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Whse. Activity No.Shipping Agent CodeShipping Agent Service CodeShipment Method CodeSerial No.Lot No.Warranty DateExpiration Date...«Table 9510»Email ParameterDocument No [PK]Document Type; [Quote,Order,Invoice,Cr...Parameter Type; [,Subject,Address] [PK...Parameter Value«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 222»Ship-to AddressCustomer No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Shipment Method CodeShipping Agent CodePlace of ExportCountry/Region CodeLast Date ModifiedLocation CodeFax No.Telex Answer BackPost CodeCountyE-MailHome PageTax Area CodeTax LiableShipping Agent Service CodeService Zone Code«Table 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. MemosLast Modified Date TimeId«Table 10»Shipment MethodCode [PK,NN]DescriptionLast Modified Date TimeId«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 92»Customer Posting GroupCode [PK,NN]Receivables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding AccountAdditional Fee AccountInterest AccountDebit Curr. Appln. Rndg. Acc.Credit Curr. Appln. Rndg. Acc.Debit Rounding AccountCredit Rounding AccountPayment Disc. Credit Acc.Payment Tolerance Debit Acc.Payment Tolerance Credit Acc.Add. Fee per Line AccountDescriptionUsed in CustomersUsed in Ledger Entries«Table 6»Customer Price GroupCode [PK,NN]Price Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]DescriptionAllow Line Disc.«Table 340»Customer Discount GroupCode [PK,NN]Description«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Modified Date TimeLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc....«Table 270»Bank AccountNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Bank Account No.Transit No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameMin. BalanceBank Acc. Posting GroupCurrency CodeLanguage CodeStatistics GroupOur Contact CodeCountry/Region CodeAmountCommentBlockedLast Statement No.Last Payment Statement No.Last Date ModifiedDate FilterGlobal Dimension 1 Filter...«Table 110»Sales Shipment HeaderSell-to Customer No. [NN]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 GroupCurrency Code...«Table 112»Sales Invoice HeaderSell-to Customer No. [NN]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 GroupCurrency Code...«Table 114»Sales Cr.Memo HeaderSell-to Customer No. [NN]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 ContactPosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency CodeCurrency Factor...«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. 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 289»Payment MethodCode [PK,NN]DescriptionBal. Account Type; [G/L Account,Bank A...Bal. Account No.Direct DebitDirect Debit Pmt. Terms CodePmt. Export Line DefinitionBank Data Conversion Pmt. TypeUse for InvoicingLast Modified Date TimeId«Table 291»Shipping AgentCode [PK,NN]NameInternet AddressAccount No.«Table 323»VAT Business Posting GroupCode [PK,NN]DescriptionLast Modified Date TimeId«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 130»Incoming DocumentEntry No. [PK]DescriptionCreated Date-TimeCreated By User IDCreated By User NameReleasedReleased Date-TimeReleased By User IDReleased By User NameLast Date-Time ModifiedLast Modified By User IDLast Modified By User NamePostedPosted Date-TimeDocument Type; [Journal,Sales Invoice,...Document No.Posting DateStatus; [New,Released,Rejected,Posted,...URL1URL2URL3URL4Vendor NameVendor VAT Registration No.Vendor IBANDocument DateVendor Bank Branch No.Vendor Bank Account No.Vendor No.Data Exchange TypeOCR Data Corrected...«Table 1230»SEPA Direct Debit MandateID [PK]Customer No. [NN]Customer Bank Account Code [NN]Valid FromValid ToDate of Signature [NN]Type of Payment; [OneOff,Recurrent]BlockedExpected Number of DebitsDebit CounterNo. SeriesClosed«Table 5071»CampaignNo. [PK]DescriptionStarting DateEnding DateSalesperson CodeCommentLast Date ModifiedNo. SeriesGlobal Dimension 1 CodeGlobal Dimension 2 CodeStatus CodeTarget Contacts ContactedContacts RespondedDuration [Min.]Cost [LCY]No. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterContact FilterContact Company FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTask Status Filter; [Not Started,In Pr...Task Closed Filter...«Table 5105»Customer TemplateCode [PK,NN]DescriptionTerritory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeCustomer Posting GroupCurrency CodeCustomer Price GroupPayment Terms CodeShipment Method CodeInvoice Disc. CodeCustomer Disc. GroupCountry/Region CodePayment Method CodePrices Including VATGen. Bus. Posting GroupVAT Bus. Posting GroupContact Type; [Company,Person]Allow Line Disc.«Table 5050»ContactNo. [PK]NameSearch NameName 2AddressAddress 2CityPhone No.Telex No.Territory CodeCurrency CodeLanguage CodeSalesperson CodeCountry/Region CodeCommentLast Date ModifiedFax No.Telex Answer BackVAT Registration No.PicturePost CodeCountyE-MailHome PageNo. SeriesImageType; [Company,Person]Company No.Company NameLookup Contact No.First Name...«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 5790»Shipping Agent ServicesShipping Agent Code [PK,NN]Code [PK,NN]DescriptionShipping TimeBase Calendar Code«Table 6660»Return Receipt HeaderSell-to Customer No. [NN]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 GroupCurrency Code...«Table 91»User SetupUser ID [PK,NN]Allow Posting FromAllow Posting ToRegister TimeSalespers./Purch. CodeApprover IDSales Amount Approval LimitPurchase Amount Approval LimitUnlimited Sales ApprovalUnlimited Purchase ApprovalSubstituteE-MailRequest Amount Approval LimitUnlimited Request ApprovalApproval AdministratorLicense Type; [Full User,Limited User,...Time Sheet Admin.Allow FA Posting FromAllow FA Posting ToSales Resp. Ctr. FilterPurchase Resp. Ctr. FilterService Resp. Ctr. Filter<Sell-to Customer No.><Bill-to Customer No.><Ship-to Code><Payment Terms Code><Prepmt. Payment Terms Code><Shipment Method Code><Location Code><Location Filter><Customer Posting Group><Customer Price Group><Customer Disc. Group><Bal. Account No.><Bal. Account No.><Last Shipping No.><Last Posting No.><Last Prepayment No.><Last Prepmt. Cr. Memo No.><Reason Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Exit Point><Transaction Specification><Payment Method Code><Shipping Agent Code><VAT Bus. Posting Group><Sell-to IC Partner Code><Bill-to IC Partner Code><Incoming Document Entry No.><Direct Debit Mandate ID><Campaign No.><Sell-to Customer Template Code><Bill-to Customer Template Code><Sell-to Contact No.><Bill-to Contact No.><Opportunity No.><Sales Document No.><Responsibility Center><Shipping Agent Service Code><Last Return Receipt No.><Assigned User ID><Blanket Order No.><Blanket Order No.><Blanket Order No.><Document Type Filter><Document No. Filter><Document Type><Document No.><Sales Order No.><Document No.><Blanket Order No.><Sales Order No.><Special Order Sales No.><Blanket Order No.><Sales Order No.><Special Order Sales No.><Source No.><Source No.><Destination No.><Destination No.><Destination No.><Destination No.><Document No.><Applies-to Doc. No.><Blanket Order No.><Blanket Order No.><Destination No.><Destination No.><Destination No.><Destination No.><Destination No.><Destination No.><Document Type><Sales Order No.><Sell-to Customer No.><Bill-to Customer No.><Document No.><No.><Location Code><Customer Price Group><Gen. Bus. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Exit Point><Transaction Specification><VAT Bus. Posting Group><Blanket Order Line No.><Responsibility Center><Customer Disc. Group><Applies-to Doc. Line No.><Sell-to Customer No.><Bill-to Customer No.><Document No.><No.><Location Code><Customer Price Group><Gen. Bus. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Exit Point><Transaction Specification><VAT Bus. Posting Group><Blanket Order Line No.><IC Partner Code><Responsibility Center><Customer Disc. Group><Sell-to Customer No.><Bill-to Customer No.><Document No.><No.><Location Code><Customer Price Group><Gen. Bus. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Exit Point><Transaction Specification><VAT Bus. Posting Group><Blanket Order Line No.><IC Partner Code><Responsibility Center><Customer Disc. Group><Claim ID><No.><Location Code><Supply From><Transfer-from Code><Sell-to Customer No.><Ship-to Code><Gen. Business Posting Group><Sell-to Customer No.><Bill-to Customer No.><Location Code><Customer Price Group><Purch. Order Line No.><Special Order Purch. Line No.><Sales Order Line No.><Special Order Sales Line No.><Gen. Bus. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Blanket Order Line No.><Exit Point><Transaction Specification><VAT Bus. Posting Group><IC Partner Code><Responsibility Center><Shipping Agent Code><Shipping Agent Service Code><Customer Disc. Group><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.><Sales Order Line No.><Location Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Blanket Order Line No.><Entry Point><Transaction Specification><VAT Bus. Posting Group><IC Partner Code><Responsibility Center><Purch. Order Line No.><Special Order Purch. Line No.><Blanket Order Line No.><Campaign No.><Contact No.><Contact Company No.><Sales Document No.><Opportunity No.><Opportunity No.><Opportunity No.><Opportunity No.><Sell-to Customer No.><Bill-to Customer No.><No.><Location Code><Price Group Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Exit Point><Transaction Specification><VAT Bus. Posting Group><IC Partner Code><Responsibility Center><Shipping Agent Code><Shipping Agent Service Code><Customer Disc. Group><No.><Location Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Entry Point><Transaction Specification><VAT Bus. Posting Group><IC Partner Code><Responsibility Center><Gen. Bus. Posting Group><Location Code><Assigned User ID><Source No.><Whse. Document No.><Whse. Document No.><Source No.><Source No.><Source No.><Location Code><Destination No.><Shipment Method Code><Shipping Agent Code><Destination No.><Location Code><Destination No.><Destination No.><Location Code><Destination No.><Destination No.><Shipping Agent Code><Shipping Agent Service Code><Shipment Method Code><Location Code><Destination No.><Destination No.><Shipping Agent Code><Shipping Agent Service Code><Shipment Method Code><Applies-to Doc. No.><Applies-to Doc. No.><Applies-to Doc. Line No.><No.><Location Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Entry Point><Transaction Specification><VAT Bus. Posting Group><Responsibility Center><Sell-to Customer No.><Bill-to Customer No.><Document No.><No.><Location Code><Customer Price Group><Gen. Bus. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Exit Point><Transaction Specification><VAT Bus. Posting Group><Responsibility Center><Customer Disc. Group><Location Code><Destination No.><Source No.><Source No.><Destination No.><Location Code><Destination No.><Destination No.><Shipping Agent Code><Shipping Agent Service Code><Shipment Method Code><Location Code><Destination No.><Source No.><Source No.><Destination No.><Location Code><Destination No.><Destination No.><Shipping Agent Code><Shipping Agent Service Code><Shipment Method Code><Location Code><Destination No.><Source No.><Source No.><Destination No.><Location Code><Destination No.><Destination No.><Shipping Agent Code><Shipping Agent Service Code><Shipment Method Code><Customer Posting Group><Customer Price Group><Payment Terms Code><Cash Flow Payment Terms Code><Payment Terms Id><Shipment Method Code><Shipment Method Id><Shipping Agent Code><Customer Disc. Group><Bill-to Customer No.><Payment Method Code><Payment Method Id><Location Code><Gen. Bus. Posting Group><VAT Bus. Posting Group><IC Partner Code><Customer No.><Primary Contact No.><Responsibility Center><Shipping Agent Service Code><Ship-to Filter><Customer No.><Sell-to Customer No.><Bill-to Customer No.><Sell-to Customer No.><Bill-to Customer No.><Sell-to Customer No.><Bill-to Customer No.><Customer No.><Sell-to Customer No.><Bill-to Customer No.><Shipment Method Code><Shipping Agent Code><Location Code><Shipping Agent Service Code><Ship-to Code><Ship-to Code><Ship-to Code><Ship-to Code><Payment Terms Code><Payment Terms Code><Payment Terms Code><Direct Debit Pmt. Terms Code><Payment Terms Code><Payment Terms Code><Shipment Method Code><Shipment Method Code><Shipment Method Code><Shipment Method Code><Shipment Method Code><Location Code><Location Code><Location Code><Location Code><Location Code><Receivables Account><Service Charge Acc.><Payment Disc. Debit Acc.><Invoice Rounding Account><Additional Fee Account><Interest Account><Debit Curr. Appln. Rndg. Acc.><Credit Curr. Appln. Rndg. Acc.><Debit Rounding Account><Credit Rounding Account><Payment Disc. Credit Acc.><Payment Tolerance Debit Acc.><Payment Tolerance Credit Acc.><Add. Fee per Line Account><Customer Posting Group><Customer Posting Group><Customer Posting Group><Customer Posting Group><Customer Posting Group><VAT Bus. Posting Gr. (Price)><Customer Price Group><Customer Price Group><Customer Price Group><Customer Price Group><Customer Price Group><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Gen. Bus. Posting Group><VAT Bus. Posting Group><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Receivables Account><Payables Account><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Reason Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Exit Point><Transaction Specification><Payment Method Code><Shipping Agent Code><VAT Bus. Posting Group><Campaign No.><Sell-to Contact No.><Bill-to Contact No.><Responsibility Center><Shipping Agent Service Code><Reason Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Exit Point><Transaction Specification><Payment Method Code><Shipping Agent Code><VAT Bus. Posting Group><Direct Debit Mandate ID><Campaign No.><Sell-to Contact No.><Bill-to Contact No.><Responsibility Center><Reason Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Exit Point><Transaction Specification><Payment Method Code><VAT Bus. Posting Group><Campaign No.><Sell-to Contact No.><Bill-to Contact No.><Responsibility Center><Reason Code><Def. VAT Bus. Posting Group><Gen. Bus. Posting Group><Gen. Bus. Posting Group><Transaction Type><Transport Method><Exit Point><Transaction Specification><Payment Method Code><Payment Method Code><Shipping Agent Code><Shipping Agent Code><VAT Bus. Posting Group><VAT Bus. Posting Group><Contact Filter><Contact Company Filter><Campaign Filter><Campaign No.><Company No.><Lookup Contact No.><Sell-to Contact No.><Bill-to Contact No.><Responsibility Center><Sales Resp. Ctr. Filter><Purchase Resp. Ctr. Filter><Service Resp. Ctr. Filter><Approver ID><Substitute>

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 No. (No.) Code20
4 Bill-to Customer No. (Bill-to Customer No.) Code20 NotBlank: Yes
5 Bill-to Name (Bill-to Name) Text50
6 Bill-to Name 2 (Bill-to Name 2) Text50
7 Bill-to Address (Bill-to Address) Text50
8 Bill-to Address 2 (Bill-to Address 2) Text50
9 Bill-to City (Bill-to City) Text30
10 Bill-to Contact (Bill-to Contact) Text50
11 Your Reference (Your Reference) Text35
12 Ship-to Code (Ship-to Code) Code10
13 Ship-to Name (Ship-to Name) Text50
14 Ship-to Name 2 (Ship-to Name 2) Text50
15 Ship-to Address (Ship-to Address) Text50
16 Ship-to Address 2 (Ship-to Address 2) Text50
17 Ship-to City (Ship-to City) Text30
18 Ship-to Contact (Ship-to Contact) Text50
19 Order Date (Order Date) Date
20 Posting Date (Posting Date) Date
21 Shipment Date (Shipment Date) Date
22 Posting Description (Posting Description) Text50
23 Payment Terms Code (Payment Terms Code) Code10
24 Due Date (Due Date) Date
25 Payment Discount % (Payment Discount %) Decimal (0:5)
26 Pmt. Discount Date (Pmt. Discount Date) Date
27 Shipment Method Code (Shipment Method Code) Code10