Diagrams

Table

Return Shipment Header

DynamicsDocs.comReturn Shipment Header«Table 6650»Return Shipment HeaderBuy-from Vendor No. [NN]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 ContactPosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting GroupCurrency CodeCurrency Factor...«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 5109»Purchase Header ArchiveDocument 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 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 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 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 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 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 780»Certificate of SupplyDocument Type; [Sales Shipment,Service...Document No. [PK]Status; [Not Applicable,Required,Recei...No.Receipt DatePrintedCustomer/Vendor NameShipment Method CodeShipment/Posting DateShip-to Country/Region CodeCustomer/Vendor No.Vehicle Registration No.«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 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. Memos«Table 10»Shipment MethodCode [PK,NN]Description«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 93»Vendor Posting GroupCode [PK,NN]Payables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding 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.«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 Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc....«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 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 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 224»Order AddressVendor No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Country/Region CodeLast Date ModifiedFax No.Telex Answer BackPost CodeCountyE-MailHome Page«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. Type«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«Table 318»Tax AreaCode [PK,NN]Description«Table 323»VAT Business Posting GroupCode [PK,NN]Description«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 % FilterTo-do Status Filter; [Not Started,In P...To-do Closed Filter...«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<Buy-from Vendor No.><Pay-to Vendor No.><Ship-to Code><Payment Terms Code><Shipment Method Code><Location Code><Vendor Posting Group><Bal. Account No.><Bal. Account No.><Sell-to Customer No.><Reason Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Order Address Code><Entry Point><Transaction Specification><Payment Method Code><User ID><Tax Area Code><VAT Bus. Posting Group><Campaign No.><Buy-from Contact No.><Pay-to Contact No.><Responsibility Center><Last Return Shipment No.><Last Return Shipment No.><Applies-to Doc. No.><Document No.><Source No.><Source No.><Source No.><Document No.><Buy-from Vendor No.><Pay-to Vendor No.><Ship-to Code><Payment Terms Code><Prepmt. Payment Terms Code><Shipment Method Code><Location Code><Location Filter><Vendor Posting Group><Bal. Account No.><Bal. Account No.><Sell-to Customer No.><Reason Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Order Address Code><Entry Point><Transaction Specification><Payment Method Code><Tax Area Code><VAT Bus. Posting Group><Campaign No.><Buy-from Contact No.><Pay-to Contact No.><Responsibility Center><Document No.><Applies-to Doc. No.><Buy-from Vendor No.><Pay-to Vendor No.><Payment Terms Code><Prepmt. Payment Terms Code><Shipment Method Code><Location Code><Location Filter><Vendor Posting Group><Bal. Account No.><Bal. Account No.><Sell-to Customer No.><Reason Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Order Address Code><Entry Point><Transaction Specification><Payment Method Code><Tax Area Code><VAT Bus. Posting Group><Archived By><Campaign No.><Buy-from Contact No.><Pay-to Contact No.><Responsibility Center><Applies-to Doc. Line No.><Buy-from Vendor No.><Pay-to Vendor No.><No.><Location Code><Gen. Bus. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Entry Point><Transaction Specification><Tax Area Code><VAT Bus. Posting Group><Responsibility Center><Location Code><Destination No.><Destination No.><Destination No.><Location Code><Destination No.><Destination No.><Destination No.><Location Code><Destination No.><Destination No.><Destination No.><Vendor Posting Group><Payment Terms Code><Cash Flow Payment Terms Code><Shipment Method Code><Pay-to Vendor No.><Payment Method Code><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><Primary Contact No.><Responsibility Center><Location Code><Vendor No.><Customer No.><Ship-to Filter><Shipment Method Code><Location Code><Tax Area Code><Payment Terms Code><Cash Flow Payment Terms Code><Direct Debit Pmt. Terms Code><Shipment Method Code><Location Code><Location Code><Payables Account><Service Charge Acc.><Payment Disc. Debit Acc.><Invoice Rounding 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.><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><Bal. Account No.><Bal. Account No.><Bill-to Customer No.><Payment Method Code><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><Primary Contact No.><Responsibility Center><Def. VAT Bus. Posting Group><Contact Filter><Contact Company Filter><Campaign Filter><Company No.><Lookup Contact No.>

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

Fields

# Name Type
2 Buy-from Vendor No. Code20 NotBlank: Yes
3 No. Code20
4 Pay-to Vendor No. Code20 NotBlank: Yes
5 Pay-to Name Text50
6 Pay-to Name 2 Text50
7 Pay-to Address Text50
8 Pay-to Address 2 Text50
9 Pay-to City Text30
10 Pay-to Contact Text50
11 Your Reference Text35
12 Ship-to Code Code10
13 Ship-to Name Text50
14 Ship-to Name 2 Text50
15 Ship-to Address Text50
16 Ship-to Address 2 Text50
17 Ship-to City Text30
18 Ship-to Contact Text50
20 Posting Date Date
21 Expected Receipt Date Date
22 Posting Description Text50
23 Payment Terms Code Code10
24 Due Date Date
25 Payment Discount % Decimal (0:5)
26 Pmt. Discount Date Date
27 Shipment Method Code Code10
28 Location Code Code10
29 Shortcut Dimension 1 Code Code20
30 Shortcut Dimension 2 Code Code20
31 Vendor Posting Group Code10 Editable: No
32 Currency Code Code10 Editable: No
33 Currency Factor Decimal (0:15)
37 Invoice Disc. Code Code20
41 Language Code Code10
43 Purchaser Code Code10
46 Comment Boolean Editable: No
FlowField
47 No. Printed Integer Editable: No
51 On Hold Code3
52 Applies-to Doc. Type Option
53 Applies-to Doc. No. Code20
55 Bal. Account No. Code20
70 VAT Registration No. Text20
72 Sell-to Customer No. Code20
73 Reason Code Code10
74 Gen. Bus. Posting Group Code10
76 Transaction Type Code10
77 Transport Method Code10
78 VAT Country/Region Code Code10
79 Buy-from Vendor Name Text50
80 Buy-from Vendor Name 2 Text50
81 Buy-from Address Text50
82 Buy-from Address 2 Text50
83 Buy-from City Text30
84 Buy-from Contact Text50
85 Pay-to Post Code Code20
86 Pay-to County Text30
87 Pay-to Country/Region Code Code10
88 Buy-from Post Code Code20
89 Buy-from County Text30
90 Buy-from Country/Region Code Code10
91 Ship-to Post Code Code20
92 Ship-to County Text30
93 Ship-to Country/Region Code Code10
94 Bal. Account Type Option
95 Order Address Code Code10
97 Entry Point Code10
98 Correction Boolean
99 Document Date Date
101 Area Code10
102 Transaction Specification Code10
104 Payment Method Code Code10
108 No. Series Code10 Editable: No
112 User ID Code50
113 Source Code Code10
114 Tax Area Code Code20
115 Tax Liable Boolean
116 VAT Bus. Posting Group Code10
119 VAT Base Discount % Decimal (0:5)
480 Dimension Set ID Integer Editable: No
5050 Campaign No. Code20
5052 Buy-from Contact No. Code20
5053 Pay-to Contact No. Code20
5700 Responsibility Center Code10
5800 Vendor Authorization No. Code35
6601 Return Order No. Code20
6602 Return Order No. Series Code10

Keys

# Fields
0 No. Clustered: Yes
1 Return Order No.
2 Buy-from Vendor No.
3 Pay-to Vendor No.

Table Relations To Other Tables

Field Related Table Related Field
Area Area Code 1..n
Bal. Account No. Bank Account No. 1..n
Campaign No. Campaign No. 1..n
Pay-to Contact No. Contact No. 1..n
Ship-to Country/Region Code Country/Region Code 1..n
Currency Code Currency Code 1..n
Sell-to Customer No. Customer No. 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n
Entry Point Entry/Exit Point Code 1..n
Bal. Account No. G/L Account No. 1..n
Gen. Bus. Posting Group Gen. Business Posting Group Code 1..n
Language Code Language Code 1..n
Location Code Location 1..n
Return Order No. Series No. Series Code 1..n
Order Address Code Order Address Code 1..n
Payment Method Code Payment Method Code 1..n
Payment Terms Code Payment Terms Code 1..n
Reason Code Reason Code Code 1..n
Responsibility Center Responsibility Center Code 1..n
Purchaser Code Salesperson/Purchaser Code 1..n
Ship-to Code Ship-to Address Code 1..n
Shipment Method Code Shipment Method Code 1..n
Source Code Source Code Code 1..n
Tax Area Code Tax Area Code 1..n
Transaction Specification Transaction Specification Code 1..n
Transaction Type Transaction Type Code 1..n
Transport Method Transport Method Code 1..n
User ID User User Name 1..n
VAT Bus. Posting Group VAT Business Posting Group Code 1..n
Pay-to Vendor No. Vendor No. 1..n
Vendor Posting Group Vendor Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field
Certificate of Supply Document No. 1..n
Item Charge Assignment (Purch) Applies-to Doc. No. 1..n
Posted Invt. Pick Header Source No. 1..n
Posted Invt. Put-away Header Source No. 1..n
Purchase Header Last Return Shipment No. 1..n
Purchase Header Archive Last Return Shipment No. 1..n
Registered Invt. Movement Hdr. Source No. 1..n
Return Shipment Line Document No. 1..n