Diagrams


Table

Certificate of Supply

DynamicsDocs.comCertificate of Supply«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 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 5990»Service Shipment HeaderCustomer 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 Date [NN]Posting DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency CodeCurrency FactorCustomer Price Group...«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...<Document No.><Document No.><Document No.>

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

Fields

# Name Type
1 Document Type Option
2 Document No. Code20
3 Status Option
4 No. Code20
5 Receipt Date Date
6 Printed Boolean
7 Customer/Vendor Name Text50 Editable: No
8 Shipment Method Code Code10 Editable: No
9 Shipment/Posting Date Date Editable: No
10 Ship-to Country/Region Code Code10 Editable: No
11 Customer/Vendor No. Code20
12 Vehicle Registration No. Text20

Keys

# Fields
0 Document Type,Document No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Document No. Return Shipment Header No. 1..n
Document No. Sales Shipment Header No. 1..n
Document No. Service Shipment Header No. 1..n

Table Relations From Other Tables

From Table From Field