Diagrams


Table

O365 Coupon Claim

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
11 Is Valid (Is Valid) Boolean
12 Status Text (Status Text) Text50
13 Amount Text (Amount Text) Text30
14 Is applied (Is applied) Boolean FlowField
15 Document Type Filter (Document Type Filter) Option FlowFilter
16 Document No. Filter (Document No. Filter) Code20 FlowFilter
17 Offer Blob (Offer Blob) BLOB
18 Terms Blob (Terms Blob) BLOB
8001 Last Modified DateTime (Last Modified DateTime) DateTime
8002 Customer Id (Customer Id) GUID

Keys

# Fields
0 Claim ID,Graph Contact ID (Claim ID,Graph Contact ID) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Document No. Filter (Document No. Filter) Sales Header No. (No.) 1..n

Table Relations From Other Tables

From Table From Field
O365 Coupon Claim Doc. Link Claim ID (Claim ID) 1..n