*
1
**
1 *
11
*
1
*
1
*
1
111
1
*
1
*
*
1
1
*
1
*
*
1
*
expireDateverifyHashemailAddress*
EmailAddressVerification
1
*
*
1
*
1
1*
1
*
*
1
1 *
*
1attrValueattrName*contactMechId*
ContactMechAttribute contactMechIdTo*contactMechIdFrom*ContactMechLink
PartyContactMechPurposeContactMechTypePurposedescriptioncontactMechPurposeTypeId*
ContactMechPurposeType
attrName*contactMechTypeId*
ContactMechTypeAttr
contactMechPurposeTypeId*contactMechTypeId*
ContactMechTypePurpose
thruDatefromDate*contactMechPurposeTypeId*contactMechId*partyId*PartyContactMechPurpose
contactMechTypeId*roleTypeId*
ValidContactMechRole
CommEventContentAssocdescriptioncommContentAssocTypeId*
CommContentAssocType
communicationEventId*productId *
CommunicationEventProduct
descriptioncommunicationEventId*communicationEventPrpTypId*
CommunicationEventPurpose
roleTypeId *partyId *communicationEventId*CommunicationEventRole
PostalAddress
PartyContactMechPurposePartyContactMech
ToContactMechLinkFromContactMechLinkContactMechAttributeinfoStringcontactMechTypeIdcontactMechId*
TelecomNumber
ContactMech
PartyContactMechaskForNamecontactNumberareaCodecountryCodecontactMechId*
PartyContactMechPurpose
TelecomNumber
PostalAddressBoundary
PartyContactMechPurposePartyContactMechpostalCodeGeoIdcountyGeoIdstateProvinceGeoIdcountryGeoIdpostalCodeExtpostalCodecitydirectionsaddress2address1attnNametoNamecontactMechId*
PostalAddressBoundary
PostalAddress
yearsWithContactMechcommentsverifiedextensionallowSolicitationroleTypeIdthruDatefromDate*contactMechId*partyId*
monthsWithContactMech
PartyContactMech
messageIdbccStringccStringtoStringfromStringheaderStringcontactListIdreasonEnumIdnotecontentcontentMimeTypeIdsubjectdatetimeEndeddatetimeStartedentryDatepartyIdTopartyIdFromroleTypeIdToroleTypeIdFromcontactMechIdTocontactMechIdFromcontactMechTypeIdstatusIdparentCommEventIdorigCommEventIdcommunicationEventTypeIdcommunicationEventId*
CommunicationEventPurposeCommunicationEventProductCommEventContentAssoc
CommunicationEventRole
CommunicationEvent
ChildCommunicationEventTypeCommunicationEventdescription
parentTypeIdcommunicationEventTypeId*
hasTable
CommunicationEventType
sequenceNumthruDatefromDate*
communicationEventId*contentId *
commContentAssocTypeId
CommEventContentAssoc
CommunicationEventPurposeChildCommunicationEventPrpTypdescription
parentTypeIdcommunicationEventPrpTypId*
hasTable
CommunicationEventPrpTyp
DOMAIN_NAME Internet Domain NameELECTRONIC_ADDRESS Electronic AddressEMAIL_ADDRESS Email AddressIP_ADDRESS Internet IP AddressPOSTAL_ADDRESS Postal AddressTELECOM_NUMBER Phone NumberWEB_ADDRESS Web URL/Address
BILLING_EMAIL Billing (AP) Email BILLING_LOCATION Billing (AP) Address FAX_NUMBER Main Fax Number FAX_NUMBER_SEC Secondary Fax Number GENERAL_LOCATION General Correspondence Address ORDER_EMAIL Order Notification Email Address OTHER_EMAIL Other Email Address PAYMENT_EMAIL Payment (AR) Email PAYMENT_LOCATION Payment (AR) Address PHONE_ASSISTANT Assistant's Phone Number PHONE_BILLING Billing (AP) Phone Number PHONE_DID Direct Inward Dialing Phone Number PHONE_HOME Main Home Phone Number PHONE_MOBILE Main Mobile Phone Number PHONE_PAYMENT Payment (AR) Phone Number PHONE_QUICK Quick Calls Phone Number PHONE_SHIP_ORIG Shipping Origin Phone Number PHONE_SHIPPING Shipping Destination Phone Number PHONE_WORK Main Work Phone Number PHONE_WORK_SEC Secondary Work Phone Number PREVIOUS_LOCATION Previous Address PRIMARY_EMAIL Primary Email Address PRIMARY_LOCATION Primary Address PRIMARY_PHONE Primary Phone Number PRIMARY_WEB_URL Primary Website URL PUR_RET_LOCATION Purchase Return Address SHIP_ORIG_LOCATION Shipping Origin Address SHIPPING_LOCATION Shipping Destination Address
AUTO_EMAIL_COMM Auto EmailCOMMENT_NOTE Comment/NoteEMAIL_COMMUNICATION EmailFACE_TO_FACE_COMMUNI Face-To-FaceFAX_COMMUNICATION FaxLETTER_CORRESPONDENC LetterPHONE_COMMUNICATION PhoneWEB_SITE_COMMUNICATI Web Site
ACTIVITY_REQUEST Activity ReuestCONFERENCE ConferenceCUSTOMER_SERVICE_CAL Customer Service CallINQUIRY InquiryMEETING MeetingSALES_FOLLOW_UP Sales Follow UpSEMINAR SeminarSUPPORT_CALL Support Call
COM_EVENT_STATUS COM_CANCELLED Cancelled COM_COMPLETE Complete COM_ENTERED Entered COM_IN_PROGRESS In-Progress COM_PENDING Pending COM_READ Read COM_REFERRED Referred COM_RESOLVED Resolved COM_UNKNOWN_PARTY Unknown Party
ContactMechTypePurpose
ChildContactMechTypeContactMechdescriptionhasTableparentTypeIdcontactMechTypeId*
ValidContactMechRole
ContactMechType
ContactMechTypeAttr
geoId *contactMechId*PostalAddressBoundary
Detail Party: Contact Entities
Detail Party: Communication Entities
*
*
*
1
*1
*
1
1
*
*
1
1
UserLoginSecurityGroupSecurityGroupPermissiondescriptiongroupId*
SecurityGrouppermissionId*groupId*
SecurityGroupPermission
SecurityGroupPermissiondescriptionpermissionId*
SecurityPermission
contactMechId *
UserLoginSecurityGroupUserLoginPasswordHistoryUserLoginHistorypartyIdsuccessiveFailedLoginsdisabledDateTimelastTimeZonelastLocalelastCurrencyUomrequirePasswordChangehasLoggedOutenabledisSystempasswordHintcurrentPassworduserLoginId*
UserLoginSession
UserLogin
successfulLoginpasswordUsedthruDatefromDate*visitIduserLoginId*
partyId
UserLoginHistory
currentPasswordthruDatefromDate*userLoginId*
UserLoginPasswordHistory
thruDatefromDate*groupId*userLoginId*
UserLoginSecurityGroup
sessionDatasavedDateuserLoginId*
UserLoginSession
1
Detail Party: User Login, Security, and Permissions Entities
Page 9
*
1
*
1
*
1
1
*
1
*
1
*
1
*
*
1
*
1
1 *
1
*
1
*
1
*
1
*
1
*
*
1
1
*
*
1
1
*
*
1
1
*
1
*
*
1
1
*
partyId*agreementItemSeqId*agreementId*
attrValueattrName*agreementId*
AgreementAttribute
geoId *agreementItemSeqId*agreementId*
AgreementGeographicalApplic
attrValueattrName*agreementItemSeqId*agreementId*
AgreementItemAttribute
attrName*agreementItemTypeId*
AgreementItemTypeAttr
AgreementPartyApplic
priceproductId *agreementItemSeqId*agreementId*
AgreementProductAppl
roleTypeId *partyId *agreementId*
AgreementRole
attrValueattrName*agreementTermId*
AgreementTermAttribute
attrName*agreementTypeId*
AgreementTypeAttr
workEffortId *agreementItemSeqId*agreementId*
AgreementWorkEffortAppl
PartyNeeddescriptionneedTypeId*
NeedType
attrName*termTypeId*TermTypeAttrChildAgreementType
AgreementdescriptionhasTableparentTypeIdagreementTypeId*
AgreementTypeAttr
AgreementType
AgreementTermAgreementRole
AgreementItem
AgreementAttributeAddendum
textDatadescriptionthruDatefromDateagreementDateagreementTypeIdroleTypeIdToroleTypeIdFrompartyIdTopartyIdFromproductIdagreementId*
Agreement
datetimeRecordedvisitIdproductCategoryIdproductIdcommunicationEventIdneedTypeIdpartyTypeIdroleTypeId*partyId*partyNeedId*
description
PartyNeed
sequenceNumthruDatefromDate*
agreementItemSeqId*agreementId*
productPromoId*
AgreementPromoAppl
ChildAgreementItemTypeAgreementItemdescriptionhasTableparentTypeIdagreementItemTypeId*
AgreementItemTypeAttr
AgreementItemType
AgreementTermAgreementPromoApplAgreementProductApplAgreementPartyApplicAgreementItemAttributeAgreementGeographicalApplicAddendumagreementImageagreementTextcurrencyUomIdagreementItemTypeIdagreementItemSeqId*agreementId*
AgreementWorkEffortAppl
AgreementItem
ChildTermTypeAgreementTermdescriptionhasTableparentTypeIdtermTypeId*
TermTypeAttr
TermType
descriptionmaxQuantityminQuantitytextValuetermDaystermValuethruDatefromDateinvoiceItemTypeId
agreementItemSeqIdagreementId
termTypeId
agreementTermId*
AgreementTermAttribute
AgreementTerm
addendumTextaddendumEffectiveDateaddendumCreationDate
agreementIdaddendumId*
agreementItemSeqId
Addendum
COMMISSION_AGREEMENT CommissionEMPLOYMENT_AGREEMENT EmploymentEULA End User License AgreementOTHER_AGREEMENT OtherPRODUCT_AGREEMENT ProductPURCHASE_AGREEMENT PurchaseSALES_AGREEMENT Sales
AGREEMENT_COMMISSION Commision RateAGREEMENT_EXHIBIT ExhibitAGREEMENT_PRICING_PR PricingAGREEMENT_SECTION SectionSUBAGREEMENT Sub-Agreement
Detail Party: Agreement Entities
AGREEMENT_TERMINATIO Agreement Termination CFR Incoterm Cost and Freight CIF Incoterm Cost, Insurance and Freight CIP Incoterm Carriage and Insurance Paid to CLAUSE_FOR_RENEWAL Clause For Renewal COMMISSION_TERM Commission CPT Incoterm Carriage Paid To DAF Incoterm Delivered At Frontier DDP Incoterm Delivered Duty Paid DDU Incoterm Delivered Duty Unpaid DEQ Incoterm Delivered Ex Quay DES Incoterm Delivered Ex Ship EXCLUSIVE_RELATIONSH Exclusive Relationship EXW Incoterm Ex Works FAS Incoterm Free Alongside Ship FCA Incoterm Free Carrier FIN_COLLECT_TERM Penalty For Collection Agency FIN_COMM_FIXED Commission Term Fixed Per Unit FIN_COMM_MAX Commission Term Maximum Per Unit FIN_COMM_MIN Commission Term Minimum Per Unit FIN_COMM_VARIABLE Commission Term Variable FIN_LATE_FEE_TERM Late Fee (percent) FIN_NORTN_ITEM_TERM Non-Returnable Sales Item FIN_PAY_NETDAYS_1 Payment net days, part 1FIN_PAY_NETDAYS_2 Payment net days, part 2FIN_PAY_NETDAYS_3 Payment net days, part 3FIN_PAYMENT_DISC Payment (discounted if paid within specified days) FIN_PAYMENT_FIXDAY Payment (due on specified day of month) FIN_PAYMENT_TERM Payment (net days) FINANCIAL_TERM Financial FOB Incoterm Free On Board INCENTIVE Incentive INCO_TERM Incoterm INDEMNIFICATION Indemnification LEGAL_TERM Legal NON_COMPETE Non-Compete OTHER_TERM Other PURCH_FREIGHT Preferred Freight PURCH_VENDOR_ID Vendor Customer ID PURCHASING Purchasing THRESHOLD Threshold
Page 10
Detail Product Entities
*
1
*
1
*
11
*
1
*
1*
1
1
1
*
1
*
1
*
1
*
1
*
1
*
1
*
1
*
1
*
*
1
*
1
*
1
*
1
*
1
*
1
*
1
1
*ChildProductTypeProductdescriptionhasTableisDigitalisPhysicalparentTypeIdproductTypeId
ProductTypeAttr
ProductType
attrNameproductTypeId
ProductTypeAttr
ChildProductMaintTypeProductMaintparentTypeIddescriptionproductMaintTypeId
ProductMaintType
intervalMeterTypeIdintervalUomIdintervalQuantitymaintTemplateWorkEffortIdmaintNameproductMaintTypeIdproductMaintSeqIdproductId
repeatCount
ProductMaint
ProductMeterIntervalProductMaintdefaultUomIddescriptionproductMeterTypeId
ProductMeterType
IntervalProductMaintmeterNamemeterUomIdproductMeterTypeIdproductId
ProductMeter
ProductRoleProductReviewProductMeterProductMaintProductKeywordProductGlAccountProductGeoProductCalculatedInfoProductContentProductAttributeAssocProductAssocMainProductAssocGoodIdentificationinShippingBoxlastModifiedByUserLoginlastModifiedDatecreatedByUserLogincreatedDateconfigIdreservNthPPPercreserv2ndPPPercreservMaxPersonsbillOfMaterialLevelrequirementMethodEnumIdoriginGeoIdisVariantisVirtualincludeInPromotionsautoCreateKeywordschargeShippingtaxDutyCodetaxVatCodetaxCategorytaxablereturnableratingTypeEnumproductRatingshippingDepthproductDepthdepthUomIdshippingWidthproductWidthwidthUomIdshippingHeightproductHeightheightUomIdweightweightUomIdamountUomTypeIdfixedAmountrequireAmountpiecesIncludedquantityIncludedquantityUomIdrequireInventoryinventoryMessagedetailScreendetailImageUrllargeImageUrlmediumImageUrlsmallImageUrlpriceDetailTextlongDescriptiondescriptionproductNamecommentsbrandNameinternalNamesalesDiscWhenNotAvailsalesDiscontinuationDatesupportDiscontinuationDateintroductionDatefacilityIdmanufacturerPartyIdprimaryProductCategoryIdproductTypeIdproductId
VendorProduct
Product
*
1
*
1
*
1
*
1
idValueproductIdgoodIdentificationTypeId
GoodIdentification
ChildGoodIdentificationTypeGoodIdentificationdescription
parentTypeIdgoodIdentificationTypeId
hasTable
GoodIdentificationType
ChildProductContentTypeProductContentdescription
parentTypeIdproductContentTypeId
hasTable
ProductContentType
productRatingpostedDateTimepostedAnonymousstatusIduserLoginIdproductIdproductStoreIdproductReviewId
productReview
ProductReview
commentsthruDatefromDate
partyIdproductId
roleTypeId
ProductRole
lowValueremoveStemsanySuffixanyPrefixisAndincludeSubCategoriesinfoStringconstraintNameconstraintSeqIdproductSearchResultId
highValue
ProductSearchConstraint
searchDatesecondsTotalnumResultsisAscendingorderByNamevisitIdproductSearchResultId
ProductSearchConstraint
ProductSearchResult
productStoreGroupIdvendorPartyIdproductId
VendorProduct
relevancyWeightkeywordproductId
ProductKeyword
estimateCalcMethodroutingWorkEffortIdinstructionscrapFactorquantityreasonsequenceNumthruDatefromDateproductAssocTypeIdproductIdToproductId
recurrenceInfoId
ProductAssoc
ChildProductAssocTypeProductAssocdescription
parentTypeIdproductAssocTypeId
hasTable
ProductAssocType
useTimeUomIduseTimeuseCountLimitpurchaseThruDatepurchaseFromDatethruDatefromDateproductContentTypeId
contentIdproductId
useRoleTypeId
ProductContent
glAccountIdglAccountTypeIdorganizationPartyIdproductId
ProductGlAccount
descriptionproductGeoEnumIdgeoIdproductId
ProductGeoaverageCustomerRatingtotalTimesViewedtotalQuantityOrderedproductId
ProductCalculatedInfo
attrTypeattrValueattrNameproductId
ProductAttribute
AGGREGATED Configurable GoodAGGREGATED_CONF Configurable Good ConfigurationASSET_USAGE Fixed Asset UsageDIGITAL_GOOD Digital GoodFINDIG_GOOD Finished/Digital GoodFINISHED_GOOD Finished GoodGOOD GoodMARKETING _PKG_PICK Marketing Package: Pick AssemblyMARKETING_PKG_AUTO Marketing Package: Auto ManufacturedRAW_MATERIAL Raw MaterialSERVICE ServiceSUBASSEMBLY SubassemblyWIP Work in Progress
OIL_CHANGE Oil Change REFUEL Re-Fuel REPLACE_BATTERY Replace Battery SERP_BELT Serpentine Belt Replacement VEHICLE_MAINT Vehicle MaintenanceWASH Wash
COPY_COUNT Copy Count Meter DISTANCE Distance Meter MOTOR_TIME Motor Time Meter SPEEDOMETER Speedometer TACHOMETER Tachometer USE_COUNT Use Count Meter
ISBN ISBN GOOGLE_ID Google IdMANUFACTURER_ID_NO Manufacturer (Model) Number MODEL_YEAR Model Year OTHER_ID Other SKU SKU UPCA UPCA UPCE UPCE
ALSO_BOUGHT Also Bought ENGINEER_COMPONENT Engineering Bill of Materials MANUF_COMPONENT Manufacturing Bill of Materials PRODUCT_ACCESSORY Accessory PRODUCT_AUTORO Auto Reorder (needs recurrenctInfoId)PRODUCT_COMPLEMENT Complementary or Cross-Sell PRODUCT_COMPONENT Actual Product Component PRODUCT_INCOMPATABLE Incompatable PRODUCT_MANUFACTURED Product Manufactured As PRODUCT_OBSOLESCENCE New Version, Replacement PRODUCT_REFURB Refurbished EquivalentPRODUCT_REPAIR_SRV Repair ServicePRODUCT_REVISION Revision PRODUCT_SUBSTITUTE Equivalent or Substitute PRODUCT_UPGRADE Upgrade or Up-Sell PRODUCT_VARIANT Product Variant UNIQUE_ITEM Unique Item
PROD_RATING_TYPE PRDR_FLAT Rating Override PRDR_MAX Max Rating PRDR_MIN Min Rating
PROD_GEO PG_PURCH_EXCLUDE Purchase Exclude Geo PG_PURCH_INCLUDE Purchase Include Geo PG_SHIP_EXCLUDE Shipment Exclude Geo PG_SHIP_INCLUDE Shipment Include Geo
ONLINE_ACCESS Online Access ADDTOCART_IMAGE Add To Cart Image ADDTOCART_LABEL Add To Cart Label DELIVERY_INFO Delivery Info DESCRIPTION Description DETAIL_IMAGE_ALT Image Alt Text - Detail DETAIL_IMAGE_URL Image - Detail DIGITAL_DOWNLOAD Digital Download DIRECTIONS Directions FULFILLMENT_EMAIL Fulfillment Email FULFILLMENT_EXTASYNC Fulfillment External (Async) FULFILLMENT_EXTSYNC Fulfillment External (Sync) INGREDIENTS Ingredients LARGE_IMAGE_ALT Image Alt Text - Large LARGE_IMAGE_URL Image - Large LONG_DESCRIPTION Description - Long MEDIUM_IMAGE_ALT Image Alt Text - Medium MEDIUM_IMAGE_URL Image - Medium PRICE_DETAIL_TEXT Price Detail Text PRODUCT_NAME Product Name SHORT_SALES_PITCH Short Sales Pitch SMALL_IMAGE_ALT Image Alt Text - Small SMALL_IMAGE_URL Image - Small SPECIALINSTRUCTIONS Special Instructions TERMS_AND_CONDS Terms and Conditions UNIQUE_INGREDIENTS Unique Ingredients WARNINGS Warnings
PROD_REQ_METHOD
PRODRQM_ATP Requirement for order when ATP Reaches Minimum Stock for Product-Facility
PRODRQM_AUTO Automatic For Every Sales Order PRODRQM_DS Drop-ship only PRODRQM_DSATP Auto drop-ship on low quantity PRODRQM_NONE No Requirement Created PRODRQM_STOCK When QOH Reaches Minimum Stock for Product-Facility PRODRQM_STOCK_ATP When ATP Reaches Minimum Stock for Product-Facility
PRODUCT_REVIEW_STTS PRR_APPROVED Approved PRR_DELETED Deleted PRR_PENDING Pending
Page 11
* 1
1 *
*
1
1
*
*
1
*
1
*
1
1
*
*
1
* 1
1
*
1
*
1
*
*
1**1
*
1
*
1
*
* 1
**
*
1
1
*
1
*
costUomIdcostthruDatefromDatecostComponentCalcIdworkEffortIdgeoIdpartyIdproductFeatureIdproductIdcostComponentTypeIdcostComponentId*
CostComponentAttribute
CostComponent
attrValueattrName*costComponentId*
CostComponentAttribute
ChildCostComponentTypeCostComponentdescriptionhasTableparentTypeIdcostComponentTypeId*
CostComponentTypeAttr
CostComponentType
attrName*costComponentTypeId*
CostComponentTypeAttr
sequenceNumthruDatefromDate*
paymentMethodTypeId *productId*
productPricePurposeId*
ProductPaymentMethodType
lastModifiedByUserLoginlastModifiedDatecreatedByUserLogincreatedDatecustomPriceCalcServicetermUomIdpricethruDatefromDate*productStoreGroupId *currencyUomId *productPricePurposeId*productPriceTypeId*productId *
ProductPriceChange
ProductPrice
rateCodeamountproductPriceActionTypeIdproductPriceActionSeqId*productPriceRuleId*
ProductPriceAction
ProductPriceActiondescriptionproductPriceActionTypeId*
ProductPriceActionTypethruDatefromDaterunDatefacilityIdproductPriceNoticeId*
ProductPriceAutoNotice
changedDateoldPricepricethruDatefromDateproductStoreGroupIdcurrencyUomId
productPricePurposeIdproductPriceTypeId
productIdproductPriceChangeId*
changedByUserLogin
ProductPriceChange
condValueoperatorEnumIdinputParamEnumIdproductPriceCondSeqId*productPriceRuleId*
ProductPriceCond
ProductPriceProductPaymentMethodTypedescriptionproductPricePurposeId*
ProductPricePurpose
ProductPriceCondProductPriceAction
thruDatefromDateisSaledescriptionruleNameproductPriceRuleId*
ProductPriceRule
ProductPricedescriptionproductPriceTypeId*
ProductPriceType
ProductPromoRuleProductPromoCodelastModifiedByUserLoginlastModifiedDatecreatedByUserLogincreatedDateoverrideOrgPartyIdbillbackFactoruseLimitPerPromotionuseLimitPerCustomeruseLimitPerOrderrequireCodeshowToCustomeruserEnteredpromoTextpromoNameproductPromoId*
ProductPromoUse
ProductPromo
productIdamountquantityorderAdjustmentTypeIdproductPromoActionEnumId
productPromoActionSeqId*productPromoRuleId*
productPromoId*
partyId
ProductPromoAction
productPromoApplEnumIdandGroupId*productCategoryId *
productPromoCondSeqId*productPromoActionSeqId*
productPromoRuleId*productPromoId*
includeSubCategories
ProductPromoCategory
ProductPromoUse
ProductPromoCodePartyProductPromoCodeEmail
lastModifiedByUserLoginlastModifiedDatecreatedByUserLogincreatedDatethruDatefromDateuseLimitPerCustomeruseLimitPerCoderequireEmailOrPartyuserEnteredproductPromoIdproductPromoCodeId*
ProductPromoCode
emailAddress*productPromoCodeId*
ProductPromoCodeEmail
partyId *productPromoCodeId*
ProductPromoCodeParty
condValueoperatorEnumIdinputParamEnumIdproductPromoCondSeqId*productPromoRuleId*productPromoId*
otherValue
ProductPromoCond
productPromoApplEnumIdproductId*
productPromoCondSeqId*productPromoRuleId*productPromoId*
productPromoActionSeqId*
ProductPromoProduct
ProductPromoCondProductPromoAction
ruleNameproductPromoRuleId*productPromoId*
ProductPromoRule
totalDiscountAmountpartyIdproductPromoCodeIdproductPromoIdpromoSequenceId*orderId *
quantityLeftInActions
ProductPromoUse
thruQuantityfromQuantityquantityBreakTypeIdquantityBreakId*
QuantityBreak
QuantityBreakdescriptionquantityBreakTypeId*
QuantityBreakType
descriptionsaleTypeId*
SaleType
PROD_PRICE_IN_PARAM PRIP_CURRENCY_UOMID Currency UomId PRIP_LIST_PRICE List Price PRIP_PARTY_CLASS Party Classification PRIP_PARTY_GRP_MEM Party Group Member PRIP_PARTY_ID Party PRIP_PROD_CAT_ID Product Category PRIP_PROD_CLG_ID Product Catalog PRIP_PROD_FEAT_ID Product Feature PRIP_PROD_SGRP_ID Product Store Group PRIP_PRODUCT_ID Product PRIP_QUANTITY Quantity PRIP_ROLE_TYPE Role Type PRIP_WEBSITE_ID Website
PROD_PRICE_COND PRC_EQ Is PRC_GT Is Greater Than PRC_GTE Is Greater Than or Equal To PRC_LT Is Less Than PRC_LTE Is Less Than or Equal To PRC_NEQ Is Not
PROD_PROMO_ACTION PROMO_GWP Gift With Purchase PROMO_ORDER_AMOUNT Order Amount Flat PROMO_ORDER_PERCENT Order Percent Discount PROMO_PROD_AMDISC X Product for Y Discount PROMO_PROD_DISC X Product for Y% Discount PROMO_PROD_PRICE X Product for Y Price PROMO_PROD_SPPRC Product for [Special Promo] Price
PROD_PROMO_IN_PARAM PPIP_NEW_ACCT Account Days Since Created PPIP_ORDER_TOTAL Cart Sub-total PPIP_ORST_HIST Order sub-total X in last Y Months PPIP_PARTY_CLASS Party Classification PPIP_PARTY_GRP_MEM Party Group Member PPIP_PARTY_ID Party PPIP_PRODUCT_AMOUNT X Amount of Product PPIP_PRODUCT_QUANT X Quantity of Product PPIP_PRODUCT_TOTAL Total Amount of Product PPIP_ROLE_TYPE Role Type
PROD_PROMO_COND PPC_EQ Is PPC_GT Is Greater Than PPC_GTE Is Greater Than or Equal To PPC_LT Is Less Than PPC_LTE Is Less Than or Equal To PPC_NEQ Is Not
PROD_PROMO_PCAPPL PPPA_ALWAYS Always Include PPPA_EXCLUDE Exclude PPPA_INCLUDE Include
PRICE_FOL Flat Amount Modify PRICE_FLAT Flat Amount Override PRICE_POAC Percent Of Average Cost PRICE_POD Percent Of Default Price PRICE_POL Percent Of List Price PRICE_POM Percent Of Margin PRICE_PFLAT Promo Amount Override PRICE_WFLAT Wholesale Amount Override
AVERAGE_COST Average Cost COMPETITIVE_PRICE Competitive Price DEFAULT_PRICE Default Price LIST_PRICE List Price MAXIMUM_PRICE Maximum Price MINIMUM_PRICE Minimum Price PROMO_PRICE Promotional Price SPECIAL_PROMO_PRICE Special Promo Price WHOLESALE_PRICE Wholesale Price
ACTUAL_LABOR_COST Actual Labor Cost ACTUAL_MAT_COST Actual Materials Cost ACTUAL_OTHER_COST Actual Other Cost ACTUAL_ROUTE_COST Actual Route (fixed asset usage) Cost EST_STD_LABOR_COST Estimated Standard Labor Cost EST_STD_MAT_COST Estimated Standard Materials Cost EST_STD_OTHER_COST Estimated Standard Other Cost EST_STD_ROUTE_COST Estimated Standard Route (fixed asset usage) Cost LABOR_COST Labor Cost MAT_COST Materials Cost OTHER_COST Other Cost ROUTE_COST Route (fixed asset usage) Cost
ORDER_VALUE Price Component Order Value Break QUANTITY Price Component Quantity Break SHIP_PRICE Shipping Price Break SHIP_QUANTITY Shipping Quantity Break SHIP_WEIGHT Shipping Weight Break
*
1
Detail Product: Price, Promo, Cost Entities
Page 12
productIdproductFeatureIactnTypeIdproductFeatureIdTo*productFeatureId*
ProductFeatureIactn
1
*
*
1
*
1
1
*
1
***
1
*
*
1
1
*
*
1
*
1
1
*
*
1
ProductFeatureApplAssocProductAssocMainProductAssocinShippingBoxconfigIdbillOfMaterialLevelrequirementMethodEnumIdoriginGeoIdisVariantisVirtualincludeInPromotionsautoCreateKeywordschargeShippingreturnableratingTypeEnumproductRatingshippingDepthproductDepthdepthUomIdshippingWidthproductWidthwidthUomIdshippingHeightproductHeightheightUomIdweightweightUomIdamountUomTypeIdfixedAmountrequireAmountpiecesIncludedquantityIncludedquantityUomIdrequireInventoryinventoryMessagedetailScreendetailImageUrllargeImageUrlmediumImageUrlsmallImageUrlpriceDetailTextlongDescriptiondescriptionproductNamecommentsbrandNameinternalNamesalesDiscWhenNotAvailsalesDiscontinuationDatesupportDiscontinuationDateintroductionDatefacilityIdmanufacturerPartyIdprimaryProductCategoryIdproductTypeIdproductId*
Product
ProductFeatureCategoryApplChildProductFeatureCategoryProductFeature
parentCategoryIdproductFeatureCategoryId*
description
ProductFeatureCategory
thruDatefromDate*productFeatureCategoryId*productCategoryId*
ProductFeatureCategoryAppl
recurringAmountamountsequenceNumthruDatefromDate*productFeatureApplTypeIdproductFeatureId*productId*
ProductFeatureApplAttr
ProductFeatureAppl
ChildProductFeatureApplTypeProductFeatureAppldescription
parentTypeIdproductFeatureApplTypeId*
hasTable
ProductFeatureApplType
attrValueattrName*fromDate*productFeatureId*productId*
ProductFeatureApplAttr
1
MainProductFeatureIactnProductFeatureGroupApplProductFeatureDataResourceProductFeatureApplidCodeabbrevdefaultSequenceNumdefaultAmountnumberSpecifieduomIddescriptionproductFeatureCategoryIdproductFeatureTypeIdproductFeatureId*
AssocProductFeatureIactn
ProductFeature
ChildProductFeatureTypeProductFeaturedescription
parentTypeIdproductFeatureTypeId*
hasTable
ProductFeatureType
productFeatureId*dataResourceId*
ProductFeatureDataResource
thruDatefromDate*productFeatureGroupId*productCategoryId*
ProductFeatureCatGrpAppl
1
*ProductFeatureGroupApplProductFeatureCatGrpAppldescriptionproductFeatureGroupId*
ProductFeatureGroup
sequenceNumthruDatefromDate*productFeatureId*productFeatureGroupId*
ProductFeatureGroupAppl
ACCESSORY AccessoryAMOUNT AmountARTIST ArtistBILLING_FEATURE Billing FeatureBRAND BrandCARE CareCOLOR ColorDIMENSION DimensionEQUIP_CLASS Equipment ClassFABRIC FabricGENRE GenreGIFT_WRAP Gift WrapHARDWARE_FEATURE Hardware Feature HAZMAT Hazmat LICENSE License MODEL_YEAR Model Year NET_WEIGHT Net WeightORIGIN Origin OTHER_FEATURE Other Feature PRODUCT_QUALITY Product Quality SIZE Size SOFTWARE_FEATURE Software Feature STYLE Style SYMPTOM Symptom TOPIC Topic TYPE Type WARRANTY Warranty YEAR_MADE Year Made
FEATURE_IACTN_DEPEND Dependencies FEATURE_IACTN_INCOMP Incompatibility
*
1
ChildProductFeatureIactnTypeProductFeatureIactndescription
parentTypeIdproductFeatureIactnTypeId*
hasTable
ProductFeatureIactnType
DISTINGUISHING_FEAT DistinguishingOPTIONAL_FEATURE OptionalREQUIRED_FEATURE RequiredSELECTABLE_FEATURE SelectableSTANDARD_FEATURE Standard
Detail Product: Feature Entities
Page 13
Detail Product: Catalog, Category Entities1
*
1
*
1
*
*
1
*
1
*
1
1
*
*
1
1*
1
*
1
*
1
*1
*
1
*
1
*
1
*
*
1
*
1
1
*ChildProductCategoryTypeProductCategorydescriptionhasTableparentTypeIdproductCategoryTypeId*
ProductCategoryTypeAttr
ProdCatalogInvFacilityProdCatalogCategorypurchaseAllowPermReqdviewAllowPermReqdtemplatePathPrefixcontentPathPrefixheaderLogostyleSheetuseQuickAddcatalogNameprodCatalogId*
ProdCatalogRole
ProdCatalog
sequenceNumthruDatefromDate*
productCategoryId*prodCatalogId*
prodCatalogCategoryTypeId*
ProdCatalogCategory
ProdCatalogCategorydescriptionprodCatalogCategoryTypeId*
ProdCatalogCategoryType
sequenceNumthruDatefromDate*facilityId*prodCatalogId*
ProdCatalogInvFacility
sequenceNumthruDatefromDate*
roleTypeId *partyId *
prodCatalogId*
ProdCatalogRole
configIdbillOfMaterialLevelrequirementMethodEnumIdoriginGeoIdisVariantisVirtualratingTypeEnumproductRatingamountUomTypeIdfixedAmountrequireAmountpiecesIncludedquantityIncludedquantityUomIdrequireInventorydescriptionproductNamecommentsinternalNamesalesDiscWhenNotAvailsalesDiscontinuationDatesupportDiscontinuationDateintroductionDatefacilityIdmanufacturerPartyIdprimaryProductCategoryIdproductTypeIdproductId*
ProductCategoryMember
Product
CurrentProductCategoryRollup
ProductCategoryRoleProductCategoryMemberProductCategoryLink
ProductCategoryGlAccountProductCategoryContentProductCategoryAttributePrimaryProductProdCatalogCategoryshowInSelectdetailScreenlinkTwoImageUrllinkOneImageUrlcategoryImageUrllongDescriptiondescriptioncategoryNameprimaryParentCategoryIdproductCategoryTypeIdproductCategoryId*
ParentProductCategoryRollup
ProductCategory
attrValueattrName*productCategoryId*
ProductCategoryAttribute
useCountLimitpurchaseThruDatepurchaseFromDatethruDatefromDate*prodCatContentTypeId*contentId*productCategoryId*
useDaysLimit
ProductCategoryContentChildProductCategoryContentTypeProductCategoryContentdescription
parentTypeIdprodCatContentTypeId*
hasTable
ProductCategoryContentType
glAccountIdglAccountTypeId *organizationPartyId *productCategoryId*
ProductCategoryGlAccount
linkInfolinkTypeEnumIdimageTwoUrlimageUrldetailTexttitleTextsequenceNumcommentsthruDatefromDate*linkSeqId*productCategoryId*
detailSubScreen
ProductCategoryLink
sequenceNumcommentsthruDatefromDate*productId*productCategoryId*
quantity
ProductCategoryMember
commentsthruDatefromDate*
partyId*productCategoryId*
roleTypeId *
ProductCategoryRole
sequenceNumthruDatefromDate*parentProductCategoryId*productCategoryId*
ProductCategoryRollup
ProductCategoryType
attrName*productCategoryTypeId*
ProductCategoryTypeAttr
CATALOG_CATEGORY Catalog CROSS_SELL_CATEGORY Cross Sell INDUSTRY_CATEGORY Industry INTERNAL_CATEGORY Internal MATERIALS_CATEGORY Materials MIXMATCH_CATEGORY Mix and Match QUICKADD_CATEGORY Quick Add SEARCH_CATEGORY Search TAX_CATEGORY Tax USAGE_CATEGORY Usage
CATEGORY_IMAGE_ALT Category Image Alt TextCATEGORY_IMAGE_URL Category Image URLCATEGORY_NAME Category NameDESCRIPTION DescriptionFOOTER FooterLINK1_ALT_TEXT Link 1 Alt TextLINK2_ALT_TEXT Link 2 Alt TextLONG_DESCRIPTION Description - Long
PCCT_ADMIN_ALLW Admin Allow (One) PCCT_BROWSE_ROOT Browse Root (One) PCCT_MOST_POPULAR Most Popular (One) PCCT_OTHER_SEARCH Other Search (Many) PCCT_PROMOTIONS Promotions (One) PCCT_PURCH_ALLW Purchase Allow (One) PCCT_QUICK_ADD Quick Add (Many) PCCT_SEARCH Default Search (One) PCCT_VIEW_ALLW View Allow (One) PCCT_WHATS_NEW What's New (One)
1
*
*
1
1
*
1
*
1
*
* 1
*
1
*
1
1
*
1
*1 *
1
*
*
1
*
1
1
*
*
1
ShoppingListItemProductSubscriptionResource
OrderItem
configIdoriginGeoIdisVariantisVirtualchargeShippingreturnableamountUomTypeIdfixedAmountrequireAmountpiecesIncludedquantityIncludedquantityUomIdproductNamecommentsinternalNamesalesDiscWhenNotAvailsalesDiscontinuationDatesupportDiscontinuationDateintroductionDatemanufacturerPartyIdprimaryProductCategoryIdproductTypeIdproductId
Subscription
Product
useTimeUomIduseTimeuseCountLimitavailableTimeUomIdavailableTimemaxLifeTimeUomIdmaxLifeTimepurchaseThruDatepurchaseFromDatethruDatefromDatesubscriptionResourceIdproductId
useRoleTypeId
ProductSubscriptionResource
SubscriptionCommEventSubscriptionAttributeuseTimeUomIduseTimeuseCountLimitavailableTimeUomIdavailableTimemaxLifeTimeUomIdmaxLifeTimepurchaseThruDatepurchaseFromDatethruDatefromDateexternalSubscriptionIdsubscriptionTypeIdinventoryItemIdproductCategoryIdproductIdorderItemSeqIdorderIdneedTypeIdpartyNeedIdroleTypeIdpartyIdoriginatedFromRoleTypeIdoriginatedFromPartyIdcontactMechIdcommunicationEventIdsubscriptionResourceIddescriptionsubscriptionId
SubscriptionFulfillmentPiece
Subscription
SubscriptionFulfillmentPiecedateSentcommentssubscriptionActivityId
SubscriptionActivity
attrValueattrNamesubscriptionIdSubscriptionAttribute
communicationEventIdsubscriptionIdSubscriptionCommEvent
subscriptionIdsubscriptionActivityIdSubscriptionFulfillmentPiece
ChildSubscriptionResourceSubscription
ProductSubscriptionResourcewebSiteIdcontentIddescriptionparentResourceIdsubscriptionResourceId
SubscriptionResource
ChildSubscriptionTypeSubscriptiondescriptionhasTableparentTypeIdsubscriptionTypeId
SubscriptionTypeAttr
SubscriptionType
attrNamesubscriptionTypeIdSubscriptionTypeAttr
salesOpportunityIdstatusIdrecurringFreqUomIdisModifiedPriceunitRecurringPriceunitAverageCostunitListPriceunitPriceselectedAmountquantitydeploymentIdsubscriptionIdshoppingListItemSeqIdshoppingListIdproductCategoryIdprodCatalogIdproductFeatureIdproductIdorderItemGroupSeqIdorderItemTypeIdorderItemSeqIdorderId
Subscription
OrderItem
quantityPurchasedreservPersonsreservLengthreservStartquantityproductIdshoppingListItemSeqIdshoppingListId
configIdOrderItem
ShoppingListItem
NEWSGROUP_SUBSCR Newsgroup OTHER_SUBSCR Other PRODUCT_INFO_SUBSCR Product Info PRODUCT_SUBSCR Product
Detail Product: Subscription Entities
Page 14
*
11
**
*
1
*
1
*
1
*
1
*
1
*
1
*
1
*
1
*
1
*
1
*
1
1
*
*1
1
*
1
*
1
*
configPropsserviceNameexcludeGeoIdincludeGeoIdexcludeFeatureGroupincludeFeatureGroupincludeNoChargeItemsrequireCompanyAddrallowCompanyAddrrequireUspsAddrallowUspsAddrmaxTotalminTotalmaxSizeminSizemaxWeightminWeightcompanyPartyIdroleTypeIdpartyIdshipmentMethodTypeIdproductStoreIdproductStoreShipMethId*
sequenceNumber
ProductStoreShipmentMeth
ProductStoreGroupdescriptionproductStoreGroupTypeId*
ProductStoreGroupType
roleTypeId*partyId *productStoreGroupId*
ProductStoreGroupRole
sequenceNumthruDatefromDate*parentGroupId*productStoreGroupId*
ProductStoreGroupRollup
applyToAllProductspaymentPropertiesPathpaymentService
paymentMethodTypeId *productStoreId*
paymentServiceTypeEnumId *
ProductStorePaymentSetting
resultTemplatesurveyTemplatethruDatefromDateproductCategoryIdproductIdsurveyIdgroupNamesurveyApplTypeIdproductStoreIdproductStoreSurveyId*
sequenceNum
ProductStoreSurveyAppl
creditCardEnumId *paymentMethodTypeId*vendorPartyId *productStoreId*
ProductStoreVendorPayment
carrierPartyId*shipmentMethodTypeId*vendorPartyId*productStoreId*
ProductStoreVendorShipment
replenishThresholdminBalanceallowAuthToNegativepurchSurveyCopyMepurchSurveySendTopurchaseSurveyIdauthValidDaysaccountValidDayspinCodeLengthaccountCodeLengthvalidateGCFinAcctrequirePinCodefinAccountTypeId*productStoreId*
replenishMethodEnumId
ProductStoreFinActSetting
sequenceNumthruDatefromDate*productStoreGroupId*productStoreId*
ProductStoreGroupMember
CurrentProductStoreGroupRollupProductStoreGroupRoleProductStoreGroupMemberPrimaryProductStoredescriptionproductStoreGroupNameprimaryParentGroupIdproductStoreGroupTypeIdproductStoreGroupId*
ParentProductStoreGroupRollup
ProductStoreGroup
ProductStoreVendorPaymentProductStoreSurveyApplProductStoreRoleProductStorePromoApplProductStorePaymentSettingProductStoreKeywordOvrdProductStoreGroupMemberProductStoreFinActSettingProductStoreFacilityProductStoreEmailSettingProductStoreCatalogsplitPayPrefPerShpGrpaddToCartReplaceUpselladdToCartRemoveIncompatreqReturnInventoryReceivesetOwnerUponIssuanceshipIfCaptureFailsautoApproveOrderautoApproveInvoicestoreCreditValidDaysautoOrderCcTryLaterMaxautoOrderCcTryLaterNsfautoOrderCcTryOtherCardsautoOrderCcTryExpdigProdUploadCategoryIdprodSearchExcludeVariantsenableDigProdUploadenableAutoSuggestionListvatTaxAuthPartyIdvatTaxAuthGeoIdshowTaxIsExemptshowPricesWithVatTaxselectPaymentTypePerItemshowCheckoutGiftOptionsreqShipAddrForDigItemsautoInvoiceDigitalItemsrequireCustomerRoleusePrimaryEmailUsernameheaderRightBackgroundheaderMiddleBackgroundheaderLogostyleSheetauthErrorMessageauthFraudMessageauthDeclinedMessageitemCancelStatusheaderCancelStatusitemDeclinedStatusheaderDeclinedStatusdigitalItemApprovedStatusitemApprovedStatusheaderApprovedStatusretryFailedAuthscheckGcBalanceexplodeOrderItemsdefaultPasswordallowPassworddefaultSalesChannelEnumIddefaultCurrencyUomIddefaultLocaleStringorderNumberPrefixrequirementMethodEnumIdrequireInventoryreserveOrderEnumIdreserveInventorycheckInventoryoneInventoryFacilityinventoryFacilityIdisImmediatelyFulfilledisDemoStoreautoApproveReviewsautoSaveCartviewCartOnAddprorateTaxesprorateShippingmanualAuthIsCapturedaysToCancelNonPaypayToPartyIdsubtitletitlecompanyNamestoreNameprimaryStoreGroupIdproductStoreId*
ProductStoreVendorShipmentProductStoreShipmentMeth
ProductStore
1
1
sequenceNumthruDatefromDate*
roleTypeId *partyId *
productStoreId*
ProductStoreRole
manualOnlysequenceNumthruDate
productPromoId*productStoreId*
fromDate*
ProductStorePromoAppl
targetTypeEnumIdtargetthruDate
keyword*productStoreId*
fromDate*
ProductStoreKeywordOvrd
sequenceNumthruDatefromDate*facilityId *productStoreId*
ProductStoreFacility
subjectbccAddressccAddressfromAddressxslfoAttachScreenLocationbodyScreenLocationemailType*productStoreId*
contentType
ProductStoreEmailSetting
sequenceNumthruDatefromDate*prodCatalogId*productStoreId*
ProductStoreCatalog
PARTY_EMAIL PARTY_REGIS_CONFIRM Party Registration Confirmation Mail PRDS_CUST_REGISTER Registration PRDS_EMAIL_VERIFY Party Email Address Verification PRDS_GC_PURCHASE Gift-Card Purchase PRDS_GC_RELOAD Gift-Card Reload PRDS_ODR_BACKORDER Back-Order PRDS_ODR_CHANGE Order Change PRDS_ODR_COMPLETE Complete PRDS_ODR_CONFIRM Confirmation PRDS_ODR_PAYRETRY Payment Retry PRDS_ODR_SHIP_COMPLT Shipment Complete PRDS_PARTYINV_EMAIL Party Invitation Email PRDS_PWD_RETRIEVE Retrieve Password PRDS_QUO_CONFIRM Quote Confirmation PRDS_QUO_CREATED Quote Created PRDS_RTN_ACCEPT Return Accepted PRDS_RTN_CANCEL Return Cancelled PRDS_RTN_COMPLETE Return Completed PRDS_TELL_FRIEND Tell-A-Friend UPD_PRSNL_INF_CNFRM Update Personal Info Confirmation
FARP_METHOD FARP_REPLENISH_LEVEL Replenish-level FARP_TOP_OFF Top-off
KWOVRD_TRGT_TYPE KOTT_AURL Absolute URL KOTT_OFBURL OFBiz URL KOTT_PRODCAT Product Category KOTT_PRODUCT Product
Detail Product: Store Entities
Page 15
*
1
*
1
*
1*
1
*
1
1
*
1
*
1
*
1 *1 *
*
1
*
1
1
*
1
*
*
1
TechDataCalendarExcWeekTechDataCalendarExcDaycalendarWeekIddescriptioncalendarId*
TechDataCalendar
descriptionusedCapacityexceptionCapacityexceptionDateStartTime*calendarId*
TechDataCalendarExcDay
descriptioncalendarWeekIdexceptionDateStart*calendarId*
TechDataCalendarExcWeek
TechDataCalendarWeek
fridayStartTimethursdayCapacitythursdayStartTimewednesdayCapacitywednesdayStartTimetuesdayCapacitytuesdayStartTimemondayCapacitymondayStartTimedescriptioncalendarWeekId*
TechDataCalendarsundayCapacitysundayStartTimesaturdayCapacitysaturdayStartTimefridayCapacity
TechDataCalendarExcWeek
eventNamequantityfacilityIdmrpEventTypeId*eventDate*productId *mrpId*
isLate MrpEventdescriptionmrpEventTypeId*
MrpEventType
revisionNumberaccommodationSpotIdaccommodationMapIdquantityRejectedquantityProducedquantityToProduceserviceLoaderNamenoteIdruntimeDataIdrecurrenceInfoIdinfoUrlfacilityIdfixedAssetIdsourceReferenceIduniversalIdtimeTransparencyspecialTermsmoneyUomIdtotalMoneyAllowedtotalMilliSecondsAllowedactualSetupMillisactualMilliSecondsestimateCalcMethodestimatedSetupMillisestimatedMilliSecondsactualCompletionDateactualStartDateestimatedCompletionDateestimatedStartDatelocationDescdescriptionsendNotificationEmailshowAsEnumIdworkEffortNamepercentCompletepriorityscopeEnumIdworkflowActivityIdworkflowProcessVersionworkflowProcessIdworkflowPackageVersionworkflowPackageIdworkEffortParentIdworkEffortPurposeTypeIdlastStatusUpdatecurrentStatusIdworkEffortTypeIdworkEffortId*
WorkEffort MrpEvent
thruDatefromDate*confItemContentTypeId*contentId *configItemId*
ProdConfItemContent
ChildProdConfItemContentTypeProdConfItemContentdescription
parentTypeIdconfItemContentTypeId*
hasTable
ProdConfItemContentType
thruDatedefaultConfigOptionIdconfigTypeIdlongDescriptiondescriptionfromDate*sequenceNum*configItemId*productId*
isMandatory
ProductConfig
descriptionconfigOptionId*sequenceNum*configItemId*configId*
ProductConfigConfig
ConfigItemToProductConfigOptionIactnConfigItemProductConfigOptionIactnConfigItemProductConfigOptionConfigItemProductConfigConfigConfigItemProductConfigProdConfItemContentimageUrllongDescriptiondescriptionconfigItemNameconfigItemTypeIdconfigItemId*
ConfigItemProductConfigProduct
ProductConfigItem
ConfigOptionToProductConfigOptionIactnConfigOptionProductConfigOptionIactnConfigOptionProductConfigConfigsequenceNumdescriptionconfigOptionNameconfigOptionId*configItemId*
ConfigOptionProductConfigProduct
ProductConfigOption
configIactnTypeIdsequenceNum*configOptionIdTo*
configItemIdTo*configOptionId*
configItemId*
description
ProductConfigOptionIactn
sequenceNumquantityproductId*configOptionId*configItemId*
ProductConfigProduct
configTypeIdnumOfConfsproductId*configId*
ProductConfigStats
descriptionquantityruleOperatorproductFeatureproductIdInSubstfromDateruleSeqIdproductIdInproductIdForproductIdruleId*
thruDate
ProductManufacturingRuleDESCRIPTION Description IMAGE_URL Image INSTRUCTIONS Instructions LONG_DESCRIPTION Description - Long
*
1
Manufacturing Entities
*
1
*
1
*
1
*1
1
*1 *
1
*
1
*
1 *
1
*
*
*
*
11
1
*
1
*
1
*
1
*
1*
*
1
1
*
descriptionfacilityIdcontainerTypeIdcontainerId*
Container
ContainerdescriptioncontainerTypeId*
ContainerType
ProductFacilityFacilityRoleFacilityLocation
FacilityGroupMember
FacilityContactMechPurposeFacilityContactMechFacilityCarrierShipmentFacilityAttributeContainer
defaultWeightUomIddescriptionclosedDateopenedDatedefaultDaysToShipproductStoreIdsquareFootageprimaryFacilityGroupIdfacilityNamedefaultInventoryItemTypeIdownerPartyIdfacilityTypeIdfacilityId*
Facility
attrValueattrName*facilityId*
FacilityAttribute
shipmentMethodTypeId*roleTypeId*partyId*facilityId*
FacilityCarrierShipment
commentsextensionthruDate
contactMechId*facilityId*
fromDate*
FacilityContactMech
thruDatefromDate*contactMechPurposeTypeId*contactMechId*facilityId*
FacilityContactMechPurpose
CurrentFacilityGroupRollupFacilityGroupRoleFacilityGroupMemberFacilitydescriptionfacilityGroupNameprimaryParentGroupIdfacilityGroupTypeIdfacilityGroupId*
ParentFacilityGroupRollup
FacilityGroup
sequenceNumthruDatefromDate*facilityGroupId*facilityId*
FacilityGroupMember
roleTypeId*partyId*facilityGroupId*
FacilityGroupRole
sequenceNumthruDatefromDate*parentFacilityGroupId*facilityGroupId*
FacilityGroupRollup
FacilityGroupdescriptionfacilityGroupTypeId*
FacilityGroupType
positionIdlevelIdsectionIdaisleIdareaIdlocationTypeEnumIdlocationSeqId*facilityId*
ProductFacilityLocation
FacilityLocation
roleTypeId*partyId*facilityId*FacilityRole
ChildFacilityTypeFacilitydescriptionhasTableparentTypeIdfacilityTypeId*
FacilityTypeAttr
FacilityType
attrName*facilityTypeId*
FacilityTypeAttr
daysToShipreorderQuantityminimumStockfacilityId*productId*
ProductFacility
moveQuantityminimumStocklocationSeqId*facilityId*productId*
ProductFacilityLocation
BUILDING Building CALL_CENTER Call Center FLOOR Floor OFFICE Office PLANT Plant RETAIL_STORE Retail Store ROOM Room WAREHOUSE Warehouse
MGMT_STRUCTURE Management Structure PRICING_GROUP Pricing Group
Detail Product: Configuration Entities
Detail Facility: General Entities
ERROR Error INITIAL_QOH Initial QOH MANUF_ORDER_RECP Manufacturing Order receipt MANUF_ORDER_REQ Manufacturing Order requirement MRP_REQUIREMENT Mrp requirement PROD_REQ_RECP Product Requirement Receipt PROP_MANUF_O_RECP Proposed Manufacturing Order receipt PROP_PUR_O_RECP Proposed Purchase Order receipt PUR_ORDER_RECP Purchase Order receipt SALES_ORDER_SHIP Sales order shipment
Page 16
* 1
1*
1
*
1
*
1
*
1
*
1
*
1
*1*1*
*1
*1
* 1
1
*
1
*
1
*
1
*
1
*
1*
*
1
*
1
1
*
*
1
*
1
*
1
*
1
1
*
*
1
1
*
1
*
1
*
*
1
ReorderGuideline
reorderQuantitythruDatefromDategeoIdfacilityIdroleTypeIdpartyIdproductIdreorderGuidelineId*
reorderLevel
thruDatefromDate*partyClassificationGroupId*productCategoryId*
MarketInterest
InventoryTransferInventoryItempositionIdlevelIdsectionIdaisleIdareaIdlocationTypeEnumIdlocationSeqId*facilityId*
ToInventoryTransfer
FacilityLocation
InventoryItemVarianceInventoryItemStatus
InventoryItemLabelAppl
InventoryItemDetailInventoryItemAttributecurrencyUomIdunitCostactivationValidThruactivationNumbersoftIdentifierserialNumberoldAvailableToPromiseoldQuantityOnHandavailableToPromiseTotalquantityOnHandTotalcommentslocationSeqIdbinNumberuomIdlotIdcontainerIdfacilityIdexpireDatedatetimeManufactureddatetimeReceivedstatusIdownerPartyIdpartyId
productIdinventoryItemTypeId
inventoryItemId*
InventoryTransfer
InventoryItem
attrValueattrName*inventoryItemId*
InventoryItemAttribute
InventoryItemLabelAppldescriptioninventoryItemLabelTypeIdinventoryItemLabelId*
InventoryItemLabel
sequenceNuminventoryItemLabelIdinventoryItemLabelTypeId*inventoryItemId*
InventoryItemLabelAppl
productIdownerPartyIdstatusEndDatetime
statusId *inventoryItemId*
statusDatetime*
InventoryItemStatus
reservedDatequantityproductStoreId*productId*visitId*
InventoryItemTempRes
attrName*inventoryItemTypeId*
InventoryItemTypeAttrInventoryItemexpirationDatequantitycreationDatelotId*
Lot
InventoryItemVariancedescriptionvarianceReasonId*
VarianceReason
Product
InventoryTransferToInventoryTransfer
InventoryItemFacilityLocation
defaultWeightUomIddescriptionclosedDateopenedDatedefaultDaysToShipproductStoreIdsquareFootageprimaryFacilityGroupIdfacilityNamedefaultInventoryItemTypeIdownerPartyIdfacilityTypeIdfacilityId*
ReorderGuideline
Facility
inventoryItemId
receiveDatesendDateitemIssuanceId
containerIdTo
locationSeqIdTo
facilityIdTo
containerId
locationSeqId
facilityIdstatusIdinventoryTransferId*
comments
InventoryTransfer
InventoryItemLabelApplInventoryItemLabel
descriptionhasTableparentTypeIdinventoryItemLabelTypeId*
ChildInventoryItemLabelType
InventoryItemLabelTypereasonEnumIdphysicalInventoryIdreceiptIditemIssuanceIdmaintHistSeqIdfixedAssetIdworkEffortIdreturnItemSeqIdreturnIdshipmentItemSeqIdshipmentIdshipGroupSeqIdorderItemSeqIdorderIdunitCostavailableToPromiseDiffquantityOnHandDiffeffectiveDateinventoryItemDetailSeqId*inventoryItemId*
description
InventoryItemDetail
commentsquantityOnHandVaravailableToPromiseVarvarianceReasonIdphysicalInventoryId*inventoryItemId*
InventoryItemDetail
InventoryItemVariance
InventoryItemVarianceInventoryItemDetailgeneralComments
physicalInventoryDatephysicalInventoryId*
partyId
PhysicalInventory
ChildInventoryItemTypeDefaultFacilitydescriptionhasTableparentTypeIdinventoryItemTypeId*
InventoryItemTypeAttr
InventoryItemType
SupplierProductdescriptionsupplierPrefOrderId*
SupplierPrefOrder
supplierCommissionPerccanDropShipsupplierProductIdsupplierProductNamecurrencyUomIdlastPriceagreementItemSeqIdagreementIdquantityUomIdunitsIncludedorderQtyIncrementsminimumOrderQuantitystandardLeadTimeDayssupplierRatingTypeIdsupplierPrefOrderIdavailableThruDateavailableFromDate*partyId*productId*
comments
SupplierProduct
SupplierProductdescriptionsupplierRatingTypeId*
SupplierRatingType
idCodeuomIddescriptionproductFeatureId*partyId*
SupplierProductFeature
ReorderGuidelineInventoryItemTempResinShippingBoxbillOfMaterialLevelrequirementMethodEnumIdoriginGeoIdisVariantisVirtualchargeShippingshippingDepthproductDepthdepthUomIdshippingWidthproductWidthwidthUomIdshippingHeightproductHeightheightUomIdweightweightUomIdamountUomTypeIdfixedAmountrequireAmountpiecesIncluded
quantityUomIdrequireInventoryinventoryMessageproductNamesalesDiscWhenNotAvailsalesDiscontinuationDatesupportDiscontinuationDateintroductionDatefacilityIdmanufacturerPartyIdprimaryProductCategoryIdproductTypeIdproductId*
SupplierProduct
Product
quantityIncluded
NON_SERIAL_INV_ITEM Non-Serialized SERIALIZED_INV_ITEM Serialized
INV_SERIALIZED_STTS INV_ACTIVATED Activated INV_AVAILABLE Available INV_BEING_TRANS_PRM Being Transfered (Promised) INV_BEING_TRANSFERED Being Transfered INV_DEACTIVATED Deactivated INV_DEFECTIVE Defective INV_DELIVERED Delivered INV_ON_HOLD On Hold INV_ON_ORDER On Order INV_PROMISED Promised INV_RETURNED Returned
INVENTORY_XFER_STTS IXF_CANCELLED Cancelled IXF_COMPLETE Complete IXF_EN_ROUTE En-Route IXF_REQUESTED Requested IXF_SCHEDULED Scheduled
FACLOC_TYPE FLT_BULK Bulk FLT_PICKLOC Pick/Primary
IID_REASON VAR_DAMAGED Damaged VAR_FOUND Found VAR_LOST Lost VAR_SAMPLE Sample (Giveaway) VAR_STOLEN Stolen
Detail Facility/Product: Inventory and Product Supplier Entities
Page 17