9
* 1 * * 1 * 1 1 * 1 * 1 * 1 1 1 1 1 * 1 * * 1 1 * 1 * * 1 * expireDate verifyHash emailAddress* EmailAddressVerification 1 * 1 * 1 1 * 1 * * 1 1 * * 1 attrValue attrName* contactMechId* ContactMechAttribute contactMechIdTo* contactMechIdFrom* ContactMechLink PartyContactMechPurpose ContactMechTypePurpose description contactMechPurposeTypeId* ContactMechPurposeType attrName* contactMechTypeId* ContactMechTypeAttr contactMechPurposeTypeId* contactMechTypeId* ContactMechTypePurpose thruDate fromDate* contactMechPurposeTypeId* contactMechId* partyId* PartyContactMechPurpose contactMechTypeId* roleTypeId* ValidContactMechRole CommEventContentAssoc description commContentAssocTypeId* CommContentAssocType communicationEventId* productId * CommunicationEventProduct description communicationEventId* communicationEventPrpTypId* CommunicationEventPurpose roleTypeId * partyId * communicationEventId* CommunicationEventRole PostalAddress PartyContactMechPurpose PartyContactMech ToContactMechLink FromContactMechLink ContactMechAttribute infoString contactMechTypeId contactMechId* TelecomNumber ContactMech PartyContactMech askForName contactNumber areaCode countryCode contactMechId* PartyContactMechPurpose TelecomNumber ry PartyContactMechPurpose PartyContactMech postalCodeGeoId countyGeoId stateProvinceGeoId countryGeoId postalCodeExt postalCode city directions address2 address1 attnName toName contactMechId* PostalAddressBoundary PostalAddress yearsWithContactMech comments verified extension allowSolicitation roleTypeId thruDate fromDate* contactMechId* partyId* monthsWithContactMech PartyContactMech messageId bccString ccString toString fromString headerString contactListId reasonEnumId note content contentMimeTypeId subject datetimeEnded datetimeStarted entryDate partyIdTo partyIdFrom roleTypeIdTo roleTypeIdFrom contactMechIdTo contactMechIdFrom contactMechTypeId statusId parentCommEventId origCommEventId communicationEventTypeId communicationEventId* CommunicationEventPurpose CommunicationEventProduct CommEventContentAssoc CommunicationEventRole CommunicationEvent ChildCommunicationEventType CommunicationEvent description parentTypeId communicationEventTypeId* hasTable CommunicationEventType sequenceNum thruDate fromDate* communicationEventId* contentId * commContentAssocTypeId CommEventContentAssoc CommunicationEventPurpose ChildCommunicationEventPrpTyp description parentTypeId communicationEventPrpTypId* hasTable CommunicationEventPrpTyp DOMAIN_NAME Internet Domain Name ELECTRONIC_ADDRESS Electronic Address EMAIL_ADDRESS Email Address IP_ADDRESS Internet IP Address POSTAL_ADDRESS Postal Address TELECOM_NUMBER Phone Number WEB_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 Email COMMENT_NOTE Comment/Note EMAIL_COMMUNICATION Email FACE_TO_FACE_COMMUNI Face-To-Face FAX_COMMUNICATION Fax LETTER_CORRESPONDENC Letter PHONE_COMMUNICATION Phone WEB_SITE_COMMUNICATI Web Site ACTIVITY_REQUEST Activity Reuest CONFERENCE Conference CUSTOMER_SERVICE_CAL Customer Service Call INQUIRY Inquiry MEETING Meeting SALES_FOLLOW_UP Sales Follow Up SEMINAR Seminar SUPPORT_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 ChildContactMechType ContactMech description hasTable parentTypeId contactMechTypeId* ValidContactMechRole ContactMechType ContactMechTypeAttr geoId * contactMechId* PostalAddressBoundary Detail Party: Contact Entities Detail Party: Communication Entities * * * 1 * 1 * 1 1 * * 1 1 UserLoginSecurityGroup SecurityGroupPermission description groupId* SecurityGroup permissionId* groupId* SecurityGroupPermission SecurityGroupPermission description permissionId* SecurityPermission contactMechId * UserLoginSecurityGroup UserLoginPasswordHistory UserLoginHistory partyId successiveFailedLogins disabledDateTime lastTimeZone lastLocale lastCurrencyUom requirePasswordChange hasLoggedOut enabled isSystem passwordHint currentPassword userLoginId* UserLoginSession UserLogin successfulLogin passwordUsed thruDate fromDate* visitId userLoginId* partyId UserLoginHistory currentPassword thruDate fromDate* userLoginId* UserLoginPasswordHistory thruDate fromDate* groupId* userLoginId* UserLoginSecurityGroup sessionData savedDate userLoginId* UserLoginSession 1 Detail Party: User Login, Security, and Permissions Entities Page 9

Detail Party: Communication Entities Detail Party: Contact ...oya-erp.net/wp-content/uploads/2012/07/OFBiz_DatamodelBook.pdf · Detail Product Entities * 1 * 1 * 1 1 * 1 * 1 * 1 1

  • Upload
    others

  • View
    7

  • Download
    0

Embed Size (px)

Citation preview

Page 1: Detail Party: Communication Entities Detail Party: Contact ...oya-erp.net/wp-content/uploads/2012/07/OFBiz_DatamodelBook.pdf · Detail Product Entities * 1 * 1 * 1 1 * 1 * 1 * 1 1

*

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

Page 2: Detail Party: Communication Entities Detail Party: Contact ...oya-erp.net/wp-content/uploads/2012/07/OFBiz_DatamodelBook.pdf · Detail Product Entities * 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

*

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

Page 3: Detail Party: Communication Entities Detail Party: Contact ...oya-erp.net/wp-content/uploads/2012/07/OFBiz_DatamodelBook.pdf · Detail Product Entities * 1 * 1 * 1 1 * 1 * 1 * 1 1

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

Page 4: Detail Party: Communication Entities Detail Party: Contact ...oya-erp.net/wp-content/uploads/2012/07/OFBiz_DatamodelBook.pdf · Detail Product Entities * 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

*

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

Page 5: Detail Party: Communication Entities Detail Party: Contact ...oya-erp.net/wp-content/uploads/2012/07/OFBiz_DatamodelBook.pdf · Detail Product Entities * 1 * 1 * 1 1 * 1 * 1 * 1 1

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

Page 6: Detail Party: Communication Entities Detail Party: Contact ...oya-erp.net/wp-content/uploads/2012/07/OFBiz_DatamodelBook.pdf · Detail Product Entities * 1 * 1 * 1 1 * 1 * 1 * 1 1

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

Page 7: Detail Party: Communication Entities Detail Party: Contact ...oya-erp.net/wp-content/uploads/2012/07/OFBiz_DatamodelBook.pdf · Detail Product Entities * 1 * 1 * 1 1 * 1 * 1 * 1 1

*

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

Page 8: Detail Party: Communication Entities Detail Party: Contact ...oya-erp.net/wp-content/uploads/2012/07/OFBiz_DatamodelBook.pdf · Detail Product Entities * 1 * 1 * 1 1 * 1 * 1 * 1 1

*

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

Page 9: Detail Party: Communication Entities Detail Party: Contact ...oya-erp.net/wp-content/uploads/2012/07/OFBiz_DatamodelBook.pdf · Detail Product Entities * 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

*

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