Diagrams

Table

O365 Coupon Claim Doc. Link

DynamicsDocs.comO365 Coupon Claim Doc. Link«Table 2116»O365 Coupon Claim Doc. LinkClaim ID [PK]Document Type; [Quote,Order,Invoice,Cr...Document No. [PK]Graph Contact ID [PK]«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 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...<Claim ID><Document Type><Document No.><Document Type Filter><Document No. Filter>

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

Fields

# Name Type
1 Claim ID (Claim ID) Text150
2 Document Type (Document Type) Option
3 Document No. (Document No.) Code20
4 Graph Contact ID (Graph Contact ID) Text250

Keys

# Fields
0 Claim ID,Graph Contact ID,Document Type,Document No. (Claim ID,Graph Contact ID,Document Type,Document No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Claim ID (Claim ID) O365 Coupon Claim Claim ID (Claim ID) 1..n
Document No. (Document No.) Sales Header No. (No.) 1..n

Table Relations From Other Tables

From Table From Field