Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | ProductId | GUID | ExternalName: productid ExternalType: Uniqueidentifier ExternalAccess: Insert
|
|
2 | DefaultUoMScheduleId | GUID | ExternalName: defaultuomscheduleid ExternalType: Lookup
|
|
3 | OrganizationId | GUID | ExternalName: organizationid ExternalType: Lookup ExternalAccess: Read
|
|
4 | Name | Text100 | ExternalName: name ExternalType: String
|
|
5 | DefaultUoMId | GUID | ExternalName: defaultuomid ExternalType: Lookup
|
|
6 | PriceLevelId | GUID | ExternalName: pricelevelid ExternalType: Lookup ExternalAccess: Modify
|
|
7 | Description | BLOB [Memo] | ExternalName: description ExternalType: Memo
|
|
8 | ProductTypeCode | Option | [SalesInventory,MiscellaneousCharges,Services,FlatFees] OptionOrdinalValues: [1;2;3;4] InitValue: SalesInventory ExternalName: producttypecode ExternalType: Picklist
|
|
9 | ProductUrl | Text250 [URL] | ExternalName: producturl ExternalType: String
|
|
10 | Price | Decimal | ExternalName: price ExternalType: Money
|
|
11 | IsKit | Boolean | ExternalName: iskit ExternalType: Boolean
|
|
12 | ProductNumber | Text100 | ExternalName: productnumber ExternalType: String
|
|
13 | Size | Text200 | ExternalName: size ExternalType: String
|
|
14 | CurrentCost | Decimal | ExternalName: currentcost ExternalType: Money
|
|
15 | StockVolume | Decimal | ExternalName: stockvolume ExternalType: Decimal
|
|
16 | StandardCost | Decimal | ExternalName: standardcost ExternalType: Money
|
|
17 | StockWeight | Decimal | ExternalName: stockweight ExternalType: Decimal
|
|
18 | QuantityDecimal | Integer | MaxValue: 5 ExternalName: quantitydecimal ExternalType: Integer
|
|
19 | QuantityOnHand | Decimal | ExternalName: quantityonhand ExternalType: Decimal
|
|
20 | IsStockItem | Boolean | ExternalName: isstockitem ExternalType: Boolean
|
|
21 | SupplierName | Text100 | ExternalName: suppliername ExternalType: String
|
|
22 | VendorName | Text100 | ExternalName: vendorname ExternalType: String
|
|
23 | VendorPartNumber | Text100 | ExternalName: vendorpartnumber ExternalType: String
|
|
24 | CreatedOn | DateTime | ExternalName: createdon ExternalType: DateTime ExternalAccess: Read
|
|
25 | ModifiedOn | DateTime | ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read
|
|
26 | CreatedBy | GUID | ExternalName: createdby ExternalType: Lookup ExternalAccess: Read
|
|
27 | StateCode | Option | [Active,Retired,Draft,UnderRevision] OptionOrdinalValues: [0;1;2;3] InitValue: Draft ExternalName: statecode ExternalType: State ExternalAccess: Modify
|
|
28 | ModifiedBy | GUID | ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read
|
|
29 | StatusCode | Option | [ ,Active,Retired,Draft,UnderRevision] OptionOrdinalValues: [-1;1;2;0;3] InitValue: [ ] ExternalName: statuscode ExternalType: Status
|
|
30 | VersionNumber | BigInteger | ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read
|
|
31 | DefaultUoMIdName | Text100 | ExternalName: defaultuomidname ExternalType: String ExternalAccess: Read
|
FlowField |
32 | DefaultUoMScheduleIdName | Text200 | ExternalName: defaultuomscheduleidname ExternalType: String ExternalAccess: Read
|
FlowField |
33 | PriceLevelIdName | Text100 | ExternalName: pricelevelidname ExternalType: String ExternalAccess: Read
|
FlowField |
34 | CreatedByName | Text200 | ExternalName: createdbyname ExternalType: String ExternalAccess: Read
|
FlowField |
35 | ModifiedByName | Text200 | ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read
|
FlowField |
36 | OrganizationIdName | Text160 | ExternalName: organizationidname ExternalType: String ExternalAccess: Read
|
FlowField |
37 | OverriddenCreatedOn | Date | ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert
|
|
38 | TransactionCurrencyId | GUID | ExternalName: transactioncurrencyid ExternalType: Lookup
|
|
39 | ExchangeRate | Decimal | ExternalName: exchangerate ExternalType: Decimal ExternalAccess: Read
|
|
40 | UTCConversionTimeZoneCode | Integer | MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer
|
|
41 | ImportSequenceNumber | Integer | ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert
|
|
42 | TimeZoneRuleVersionNumber | Integer | MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer
|
|
43 | TransactionCurrencyIdName | Text100 | ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read
|
FlowField |
44 | CurrentCost_Base | Decimal | ExternalName: currentcost_base ExternalType: Money ExternalAccess: Read
|
|
45 | Price_Base | Decimal | ExternalName: price_base ExternalType: Money ExternalAccess: Read
|
|
46 | StandardCost_Base | Decimal | ExternalName: standardcost_base ExternalType: Money ExternalAccess: Read
|
|
47 | CreatedOnBehalfBy | GUID | ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read
|
|
48 | CreatedOnBehalfByName | Text200 | ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read
|
FlowField |
49 | ModifiedOnBehalfBy | GUID | ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read
|
|
50 | ModifiedOnBehalfByName | Text200 | ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read
|
FlowField |
51 | EntityImageId | GUID | ExternalName: entityimageid ExternalType: Uniqueidentifier ExternalAccess: Read
|
|
52 | ProcessId | GUID | ExternalName: processid ExternalType: Uniqueidentifier
|
|
53 | StageId | GUID | ExternalName: stageid ExternalType: Uniqueidentifier
|
|
54 | ParentProductId | GUID | ExternalName: parentproductid ExternalType: Lookup ExternalAccess: Insert
|
|
55 | ParentProductIdName | Text100 | ExternalName: parentproductidname ExternalType: String ExternalAccess: Read
|
FlowField |
56 | ProductStructure | Option | [Product,ProductFamily,ProductBundle] OptionOrdinalValues: [1;2;3] InitValue: Product ExternalName: productstructure ExternalType: Picklist ExternalAccess: Insert
|
|
57 | VendorID | Text100 | ExternalName: vendorid ExternalType: String
|
|
58 | TraversedPath | Text250 | ExternalName: traversedpath ExternalType: String
|
|
59 | ValidFromDate | Date | ExternalName: validfromdate ExternalType: DateTime
|
|
60 | ValidToDate | Date | ExternalName: validtodate ExternalType: DateTime
|
|
61 | HierarchyPath | Text250 | ExternalName: hierarchypath ExternalType: String ExternalAccess: Read
|
Keys
# | Fields | ||
---|---|---|---|
0 | ProductId | Clustered: Yes | |
1 | Name |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
OrganizationId | CRM Organization | OrganizationId |
|
1..n |
PriceLevelId | CRM Pricelevel | PriceLevelId |
|
1..n |
ParentProductId | CRM Product | ProductId |
|
1..n |
ModifiedOnBehalfBy | CRM Systemuser | SystemUserId |
|
1..n |
TransactionCurrencyId | CRM Transactioncurrency | TransactionCurrencyId |
|
1..n |
DefaultUoMId | CRM Uom | UoMId |
|
1..n |
DefaultUoMScheduleId | CRM Uomschedule | UoMScheduleId |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
CRM Incident | ProductId |
|
1..n |
CRM Invoicedetail | ProductId |
|
1..n |
CRM Post | RegardingObjectId |
|
1..n |
CRM Product | ParentProductId |
|
1..n |
CRM Productpricelevel | ProductId |
|
1..n |
CRM Quotedetail | ProductId |
|
1..n |
CRM Salesorderdetail | ProductId |
|
1..n |