Diagrams

Table

O365 Posted Coupon Claim

DynamicsDocs.comO365 Posted Coupon Claim«Table 2117»O365 Posted Coupon ClaimClaim ID [PK]Graph Contact IDUsage; [oneTime,multiUse]OfferTermsCodeExpirationDiscount ValueDiscount Type; [None,%,Amount]Created DateTimeAmount TextOffer BlobTerms BlobSales Invoice No. [PK]Customer Id«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...<Sales Invoice No.>

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 Graph Contact ID (Graph Contact ID) Text250
3 Usage (Usage) Option
4 Offer (Offer) Text250
5 Terms (Terms) Text250
6 Code (Code) Text30
7 Expiration (Expiration) Date
8 Discount Value (Discount Value) Decimal
9 Discount Type (Discount Type) Option
10 Created DateTime (Created DateTime) DateTime
13 Amount Text (Amount Text) Text30
17 Offer Blob (Offer Blob) BLOB
18 Terms Blob (Terms Blob) BLOB
19 Sales Invoice No. (Sales Invoice No.) Code20
8002 Customer Id (Customer Id) GUID

Keys

# Fields
0 Claim ID,Sales Invoice No. (Claim ID,Sales Invoice No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Sales Invoice No. (Sales Invoice No.) Sales Invoice Header No. (No.) 1..n

Table Relations From Other Tables

From Table From Field