<mxfile host="Electron" version="29.6.6" type="device">
  <diagram id="commissions" name="Commission accrual, clawback, and payment">
    <mxGraphModel grid="1" gridSize="10" page="0" pageWidth="1160" pageHeight="1000" background="#FFFFFF">
      <root>
        <mxCell id="0" />
        <mxCell id="1" parent="0" />
        <object id="title" label="Commission accrual, clawback, and payment">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=28;fontStyle=1;" vertex="1" parent="1">
            <mxGeometry x="25" y="15" width="1110" height="70" as="geometry" />
          </mxCell>
        </object>
        <object id="subtitle" label="How does a payment identify its accruals and adjustments?">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=18;fontStyle=0;" vertex="1" parent="1">
            <mxGeometry x="25" y="87" width="1110" height="55" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionRate" label="SalesCommissionRate" tableName="SalesCommissionRate" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="25" y="610" width="330" height="228.0" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionRate__grain" label="One commission rate by revenue&#10;type, segment, and effective&#10;period" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionRate">
            <mxGeometry x="0" y="42.0" width="330" height="66" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionRate__SalesCommissionRateID" label="SalesCommissionRateID (PK)" fieldName="SalesCommissionRateID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionRate">
            <mxGeometry x="0" y="108.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionRate__RevenueType" label="RevenueType" fieldName="RevenueType">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionRate">
            <mxGeometry x="0" y="138.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionRate__CustomerSegment" label="CustomerSegment" fieldName="CustomerSegment">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionRate">
            <mxGeometry x="0" y="168.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionRate__RatePct" label="RatePct" fieldName="RatePct">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionRate">
            <mxGeometry x="0" y="198.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionAccrual" label="SalesCommissionAccrual" tableName="SalesCommissionAccrual" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="410" y="170" width="330" height="244.0" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionAccrual__grain" label="One invoice-line commission&#10;accrual" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionAccrual">
            <mxGeometry x="0" y="42.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionAccrual__SalesCommissionAccrualID" label="SalesCommissionAccrualID (PK)" fieldName="SalesCommissionAccrualID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionAccrual">
            <mxGeometry x="0" y="94.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionAccrual__SalesInvoiceLineID" label="SalesInvoiceLineID (FK)" fieldName="SalesInvoiceLineID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionAccrual">
            <mxGeometry x="0" y="124.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionAccrual__SalesCommissionRateID" label="SalesCommissionRateID (FK)" fieldName="SalesCommissionRateID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionAccrual">
            <mxGeometry x="0" y="154.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionAccrual__SalesRepEmployeeID" label="SalesRepEmployeeID (FK)" fieldName="SalesRepEmployeeID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionAccrual">
            <mxGeometry x="0" y="184.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionAccrual__CommissionBaseAmount" label="CommissionBaseAmount" fieldName="CommissionBaseAmount">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionAccrual">
            <mxGeometry x="0" y="214.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionAdjustment" label="SalesCommissionAdjustment" tableName="SalesCommissionAdjustment" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="795" y="170" width="330" height="234.0" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionAdjustment__grain" label="One credit-related commission&#10;clawback" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionAdjustment">
            <mxGeometry x="0" y="42.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionAdjustment__SalesCommissionAdjustmentID" label="SalesCommissionAdjustmentID (PK)" fieldName="SalesCommissionAdjustmentID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionAdjustment">
            <mxGeometry x="0" y="94.0" width="330" height="50" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionAdjustment__SalesCommissionAccrualID" label="SalesCommissionAccrualID (FK)" fieldName="SalesCommissionAccrualID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionAdjustment">
            <mxGeometry x="0" y="144.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionAdjustment__CreditMemoLineID" label="CreditMemoLineID (FK)" fieldName="CreditMemoLineID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionAdjustment">
            <mxGeometry x="0" y="174.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionAdjustment__CommissionBaseReductionAmount" label="CommissionBaseReductionAmount" fieldName="CommissionBaseReductionAmount">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionAdjustment">
            <mxGeometry x="0" y="204.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionPayment" label="SalesCommissionPayment" tableName="SalesCommissionPayment" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="795" y="610" width="330" height="214.0" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionPayment__grain" label="One sales-rep commission payment" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionPayment">
            <mxGeometry x="0" y="42.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionPayment__SalesCommissionPaymentID" label="SalesCommissionPaymentID (PK)" fieldName="SalesCommissionPaymentID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionPayment">
            <mxGeometry x="0" y="94.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionPayment__PaymentNumber" label="PaymentNumber" fieldName="PaymentNumber">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionPayment">
            <mxGeometry x="0" y="124.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionPayment__PaymentDate" label="PaymentDate" fieldName="PaymentDate">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionPayment">
            <mxGeometry x="0" y="154.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionPayment__SalesRepEmployeeID" label="SalesRepEmployeeID (FK)" fieldName="SalesRepEmployeeID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionPayment">
            <mxGeometry x="0" y="184.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionPaymentLine" label="SalesCommissionPaymentLine" tableName="SalesCommissionPaymentLine" primaryHome="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=42;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#e9f1ed;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="410" y="610" width="330" height="234.0" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionPaymentLine__grain" label="One accrual or adjustment included&#10;in a commission payment" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionPaymentLine">
            <mxGeometry x="0" y="42.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionPaymentLine__SalesCommissionPaymentLineID" label="SalesCommissionPaymentLineID (PK)" fieldName="SalesCommissionPaymentLineID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionPaymentLine">
            <mxGeometry x="0" y="94.0" width="330" height="50" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionPaymentLine__SalesCommissionPaymentID" label="SalesCommissionPaymentID (FK)" fieldName="SalesCommissionPaymentID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionPaymentLine">
            <mxGeometry x="0" y="144.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionPaymentLine__SourceDocumentID" label="SourceDocumentID (source)" fieldName="SourceDocumentID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionPaymentLine">
            <mxGeometry x="0" y="174.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesCommissionPaymentLine__SourceDocumentType" label="SourceDocumentType" fieldName="SourceDocumentType">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesCommissionPaymentLine">
            <mxGeometry x="0" y="204.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesInvoiceLine" label="SalesInvoiceLine&#10;Shared reference" tableName="SalesInvoiceLine" primaryHome="false">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;swimlane;horizontal=1;startSize=65;collapsible=0;align=center;verticalAlign=top;fontSize=20;fontStyle=1;fillColor=#f0f1f3;swimlaneFillColor=#FFFFFF;" vertex="1" parent="1">
            <mxGeometry x="25" y="170" width="330" height="237.0" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesInvoiceLine__grain" label="One billed goods or service line" rowMeaning="true">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesInvoiceLine">
            <mxGeometry x="0" y="65.0" width="330" height="52" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesInvoiceLine__SalesInvoiceLineID" label="SalesInvoiceLineID (PK)" fieldName="SalesInvoiceLineID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesInvoiceLine">
            <mxGeometry x="0" y="117.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesInvoiceLine__SalesInvoiceID" label="SalesInvoiceID (FK)" fieldName="SalesInvoiceID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesInvoiceLine">
            <mxGeometry x="0" y="147.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesInvoiceLine__ShipmentLineID" label="ShipmentLineID (FK)" fieldName="ShipmentLineID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesInvoiceLine">
            <mxGeometry x="0" y="177.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="SalesInvoiceLine__SalesOrderLineID" label="SalesOrderLineID (FK)" fieldName="SalesOrderLineID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=12;spacingRight=8;overflow=hidden;rotatable=0;fontSize=18;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;" vertex="1" parent="SalesInvoiceLine">
            <mxGeometry x="0" y="207.0" width="330" height="30" as="geometry" />
          </mxCell>
        </object>
        <object id="r1" label="r1" relationKind="reference" childTable="SalesCommissionAccrual" childFields="SalesInvoiceLineID" parentTable="SalesInvoiceLine" parentFields="SalesInvoiceLineID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERmandOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="SalesInvoiceLine__SalesInvoiceLineID" target="SalesCommissionAccrual__SalesInvoiceLineID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="379.0" y="302.0" />
                <mxPoint x="379.0" y="309.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="r2" label="r2" relationKind="reference" childTable="SalesCommissionAccrual" childFields="SalesCommissionRateID" parentTable="SalesCommissionRate" parentFields="SalesCommissionRateID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERmandOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="SalesCommissionRate__SalesCommissionRateID" target="SalesCommissionAccrual__SalesCommissionRateID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="379.0" y="733.0" />
                <mxPoint x="379.0" y="339.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="r3" label="r3" relationKind="reference" childTable="SalesCommissionAdjustment" childFields="SalesCommissionAccrualID" parentTable="SalesCommissionAccrual" parentFields="SalesCommissionAccrualID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERmandOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="SalesCommissionAccrual__SalesCommissionAccrualID" target="SalesCommissionAdjustment__SalesCommissionAccrualID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="764.0" y="279.0" />
                <mxPoint x="764.0" y="329.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="r4" label="r4" relationKind="reference" childTable="SalesCommissionPaymentLine" childFields="SalesCommissionPaymentID" parentTable="SalesCommissionPayment" parentFields="SalesCommissionPaymentID" condition="">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=ERmandOne;endArrow=ERzeroToMany;endFill=1;dashed=0;exitX=0;exitY=0.5;entryX=1;entryY=0.5;" edge="1" parent="1" source="SalesCommissionPayment__SalesCommissionPaymentID" target="SalesCommissionPaymentLine__SalesCommissionPaymentID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="771.0" y="719.0" />
                <mxPoint x="771.0" y="769.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="r5" label="r5" relationKind="conditional" childTable="SalesCommissionPaymentLine" childFields="SourceDocumentID" parentTable="SalesCommissionAccrual" parentFields="SalesCommissionAccrualID" condition="SourceDocumentType = 'SalesCommissionAccrual'">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=none;endArrow=open;endFill=1;dashed=1;exitX=0;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="SalesCommissionAccrual__SalesCommissionAccrualID" target="SalesCommissionPaymentLine__SourceDocumentID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="386.0" y="279.0" />
                <mxPoint x="386.0" y="162.0" />
                <mxPoint x="1.0" y="162.0" />
                <mxPoint x="1.0" y="848.0" />
                <mxPoint x="386.0" y="848.0" />
                <mxPoint x="386.0" y="799.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="r6" label="r6" relationKind="conditional" childTable="SalesCommissionPaymentLine" childFields="SourceDocumentID" parentTable="SalesCommissionAdjustment" parentFields="SalesCommissionAdjustmentID" condition="SourceDocumentType = 'SalesCommissionAdjustment'">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=none;endArrow=open;endFill=1;dashed=1;exitX=1;exitY=0.5;entryX=1;entryY=0.5;" edge="1" parent="1" source="SalesCommissionAdjustment__SalesCommissionAdjustmentID" target="SalesCommissionPaymentLine__SourceDocumentID">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="1149.0" y="289.0" />
                <mxPoint x="1149.0" y="848.0" />
                <mxPoint x="764.0" y="848.0" />
                <mxPoint x="764.0" y="799.0" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="footer" label="(PK) = primary key. (FK) = foreign key.&#10;Solid crow’s-foot lines show foreign-key relationships; dashed labeled lines show conditional traces or analytical matches. See r1, r2… in the relationship table.">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=17;fontStyle=0;" vertex="1" parent="1">
            <mxGeometry x="25" y="880.0" width="1110" height="60" as="geometry" />
          </mxCell>
        </object>
      </root>
    </mxGraphModel>
  </diagram>
</mxfile>
