Diagrams

Table

Shipping Agent Services

DynamicsDocs.comShipping Agent Services«Table 5790»Shipping Agent ServicesShipping Agent Code [PK,NN]Code [PK,NN]DescriptionShipping TimeBase Calendar Code«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 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 36»Sales HeaderDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...«Table 37»Sales LineDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 Code...«Table 5107»Sales Header ArchiveDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...«Table 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 5740»Transfer HeaderNo. [PK]Transfer-from CodeTransfer-from NameTransfer-from Name 2Transfer-from AddressTransfer-from Address 2Transfer-from Post CodeTransfer-from CityTransfer-from CountyTrsf.-from Country/Region CodeTransfer-to CodeTransfer-to NameTransfer-to Name 2Transfer-to AddressTransfer-to Address 2Transfer-to Post CodeTransfer-to CityTransfer-to CountyTrsf.-to Country/Region CodePosting DateShipment DateReceipt DateStatus; [Open,Released]CommentShortcut Dimension 1 CodeShortcut Dimension 2 CodeIn-Transit CodeNo. SeriesLast Shipment No.Last Receipt No.Transfer-from Contact...«Table 5741»Transfer LineDocument No. [PK]Line No. [PK]Item No.QuantityUnit of MeasureQty. to ShipQty. to ReceiveQuantity ShippedQuantity ReceivedStatus; [Open,Released]Shortcut Dimension 1 CodeShortcut Dimension 2 CodeDescriptionGen. Prod. Posting GroupInventory Posting GroupQuantity [Base]Outstanding Qty. [Base]Qty. to Ship [Base]Qty. Shipped [Base]Qty. to Receive [Base]Qty. Received [Base]Qty. per Unit of MeasureUnit of Measure CodeOutstanding QuantityGross WeightNet WeightUnit VolumeVariant CodeUnits per ParcelDescription 2In-Transit Code...«Table 5742»Transfer RouteTransfer-from Code [PK]Transfer-to Code [PK]In-Transit CodeShipping Agent CodeShipping Agent Service Code«Table 5744»Transfer Shipment HeaderNo. [PK]Transfer-from CodeTransfer-from NameTransfer-from Name 2Transfer-from AddressTransfer-from Address 2Transfer-from Post CodeTransfer-from CityTransfer-from CountyTrsf.-from Country/Region CodeTransfer-to CodeTransfer-to NameTransfer-to Name 2Transfer-to AddressTransfer-to Address 2Transfer-to Post CodeTransfer-to CityTransfer-to CountyTrsf.-to Country/Region CodeTransfer Order DatePosting DateCommentShortcut Dimension 1 CodeShortcut Dimension 2 CodeTransfer Order No.No. SeriesShipment DateReceipt DateIn-Transit CodeTransfer-from ContactTransfer-to Contact...«Table 5745»Transfer Shipment LineDocument No. [PK]Line No. [PK]Item No.QuantityUnit of MeasureDescriptionShortcut Dimension 1 CodeShortcut Dimension 2 CodeGen. Prod. Posting GroupInventory Posting GroupQuantity [Base]Qty. per Unit of MeasureUnit of Measure CodeGross WeightNet WeightUnit VolumeVariant CodeUnits per ParcelDescription 2Transfer Order No.Shipment DateShipping Agent CodeShipping Agent Service CodeIn-Transit CodeTransfer-from CodeTransfer-to CodeItem Shpt. Entry No.Shipping TimeDimension Set IDItem Category CodeProduct Group Code...«Table 5746»Transfer Receipt HeaderNo. [PK]Transfer-from CodeTransfer-from NameTransfer-from Name 2Transfer-from AddressTransfer-from Address 2Transfer-from Post CodeTransfer-from CityTransfer-from CountyTrsf.-from Country/Region CodeTransfer-to CodeTransfer-to NameTransfer-to Name 2Transfer-to AddressTransfer-to Address 2Transfer-to Post CodeTransfer-to CityTransfer-to CountyTrsf.-to Country/Region CodeTransfer Order DatePosting DateCommentShortcut Dimension 1 CodeShortcut Dimension 2 CodeTransfer Order No.No. SeriesShipment DateReceipt DateIn-Transit CodeTransfer-from ContactTransfer-to Contact...«Table 5747»Transfer Receipt LineDocument No. [PK]Line No. [PK]Item No.QuantityUnit of MeasureDescriptionShortcut Dimension 1 CodeShortcut Dimension 2 CodeGen. Prod. Posting GroupInventory Posting GroupQuantity [Base]Qty. per Unit of MeasureUnit of Measure CodeGross WeightNet WeightUnit VolumeVariant CodeUnits per ParcelDescription 2Transfer Order No.Receipt DateShipping Agent CodeShipping Agent Service CodeIn-Transit CodeTransfer-from CodeTransfer-to CodeItem Rcpt. Entry No.Shipping TimeDimension Set IDItem Category CodeProduct Group Code...«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 5900»Service HeaderDocument Type; [Quote,Order,Invoice,Cr...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 Date [NN]Posting DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«Table 5902»Service LineDocument Type; [Quote,Order,Invoice,Cr...Customer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 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 CodeCustomer Price Group...«Table 7320»Warehouse Shipment HeaderNo. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeSorting Method; [,Item,Document,Shelf...No. SeriesCommentBin CodeZone CodeDocument Status; [,Partially Picked,Pa...Posting DateShipping Agent CodeShipping Agent Service CodeShipment Method CodeShipment DateCompletely PickedStatus; [Open,Released]External Document No.Create Posted HeaderShipping No.Last Shipping No.Shipping No. Series«Table 7322»Posted Whse. Shipment HeaderNo. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeNo. SeriesCommentBin CodeZone CodePosting DateShipment DateShipping Agent CodeShipping Agent Service CodeShipment Method CodeWhse. Shipment No.External Document No.«Table 7325»Whse. Pick RequestDocument Type; [Shipment,Internal Pick...Document Subtype; [0,1,2,3,4,5,6,7,8,9...Document No. [PK,NN]Location Code [PK]Zone CodeBin CodeStatus; [Open,Released]Completely PickedShipment Method CodeShipping Agent CodeShipping Agent Service Code«Table 7326»Whse. Worksheet LineWorksheet Template Name [PK,NN]Name [PK,NN]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 Code [PK]Shelf No.From Zone CodeFrom Bin CodeTo Bin CodeTo Zone CodeItem No.QuantityQty. [Base]Qty. OutstandingQty. Outstanding [Base]Qty. to HandleQty. to Handle [Base]Qty. HandledQty. Handled [Base]From Unit of Measure Code [NN]Qty. per From Unit of MeasureUnit of Measure Code [NN]Qty. per Unit of MeasureVariant CodeDescriptionDescription 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 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 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 291»Shipping AgentCode [PK,NN]NameInternet AddressAccount No.«Table 7600»Base CalendarCode [PK,NN]NameCustomized Changes Exist<Shipping Agent Code><Base Calendar Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Shipping Agent Service Code><Sell-to Customer No.><Bill-to Customer No.><Ship-to Code><Shipping Agent Code><Last Shipping No.><Last Shipping No.><Shipping Agent Code><Bill-to Customer No.><Ship-to Filter><Customer No.><Base Calendar Code><Sell-to Customer No.><Bill-to 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.><Destination No.><Destination No.><Customer No.><Bill-to Customer No.><Customer Filter><Customer No.><Bill-to Customer No.><Destination No.><Destination No.><Destination No.><Destination No.><Shipping Agent Code><Ship-to Code><Ship-to Code><Ship-to Code><Ship-to Code><Shipping Agent Code><Document No.><Blanket Order No.><Blanket Order No.><Destination No.><Destination No.><Destination No.><Destination No.><Destination No.><Attached to Line No.><Blanket Order Line No.><Shipping Agent Code><Blanket Order Line No.><Shipping Agent Code><Document No.><Attached to Line No.><Shipping Agent Code><Last Shipment No.><Last Receipt No.><Shipping Agent Code><Derived From Line No.><Shipping Agent Code><Shipping Agent Code><Shipping Agent Code><Shipping Agent Code><Shipping Agent Code><Shipping Agent Code><Shipping Agent Code><Whse. Document No.><Shipping Agent Code><Whse. Document No.><Shipping Agent Code><Document No.><Attached to Line No.><Shipping Agent Code><Shipping Agent Code><Last Shipping No.><Document No.><Whse. Document No.><Shipping Agent Code><Shipping Agent Code><Shipping Agent Code><Shipping Agent Code><Shipping Agent Code><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 Shipping Agent Code (Shipping Agent Code) Code10 NotBlank: Yes
2 Code (Code) Code10 NotBlank: Yes
3 Description (Description) Text50
4 Shipping Time (Shipping Time) DateFormula
7600 Base Calendar Code (Base Calendar Code) Code10

Keys

# Fields
0 Shipping Agent Code,Code (Shipping Agent Code,Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Base Calendar Code (Base Calendar Code) Base Calendar Code (Code) 1..n
Shipping Agent Code (Shipping Agent Code) Shipping Agent Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Customer Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Posted Invt. Pick Line Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Posted Invt. Put-away Line Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Posted Whse. Shipment Header Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Registered Invt. Movement Line Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Registered Whse. Activity Line Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Sales Header Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Sales Header Archive Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Sales Line Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Sales Line Archive Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Sales Shipment Header Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Service Header Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Service Line Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Ship-to Address Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Transfer Header Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Transfer Line Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Transfer Receipt Header Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Transfer Receipt Line Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Transfer Route Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Transfer Shipment Header Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Transfer Shipment Line Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Warehouse Activity Line Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Warehouse Shipment Header Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Whse. Pick Request Shipping Agent Service Code (Shipping Agent Service Code) 1..n
Whse. Worksheet Line Shipping Agent Service Code (Shipping Agent Service Code) 1..n