Diagrams

Table

Cancelled Document

DynamicsDocs.comCancelled Document«Table 1900»Cancelled DocumentSource ID [PK]Cancelled Doc. No. [PK]Cancelled By Doc. No.«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 122»Purch. Inv. 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 ContactOrder DatePosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor 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 124»Purch. Cr. Memo Hdr.Buy-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...<Cancelled Doc. No.><Cancelled By Doc. No.><Cancelled Doc. No.><Cancelled By Doc. No.><Cancelled Doc. No.><Cancelled By Doc. No.><Cancelled Doc. No.><Cancelled By Doc. No.>

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

Fields

# Name Type
1 Source ID (Source ID) Integer
2 Cancelled Doc. No. (Cancelled Doc. No.) Code20
3 Cancelled By Doc. No. (Cancelled By Doc. No.) Code20

Keys

# Fields
0 Source ID,Cancelled Doc. No. (Source ID,Cancelled Doc. No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Cancelled By Doc. No. (Cancelled By Doc. No.) Purch. Cr. Memo Hdr. No. (No.) 1..n
Cancelled By Doc. No. (Cancelled By Doc. No.) Purch. Inv. Header No. (No.) 1..n
Cancelled By Doc. No. (Cancelled By Doc. No.) Sales Cr.Memo Header No. (No.) 1..n
Cancelled By Doc. No. (Cancelled By Doc. No.) Sales Invoice Header No. (No.) 1..n

Table Relations From Other Tables

From Table From Field