InvoiceSum

">

    Show / Hide Table of Contents

    Table:

    InvoiceSum

    Summary of an Invoice, which is a roll-up of InvoiceDetail records.

    Name Type Description Remarks
    Associate

    int

    Associate is the user that invoiced the order.
    Associate is a nullable foreign key to the Employee table.

    CalculateDiscByPercent

    bit

    Indicates if the global discount should calculated by percentage or by amount.

    1 = Discount by percentage;
    0 or null = Discount by amount

    CouponNum

    varchar(20)

    The coupon number, if used, on the order.

    The coupon number is defined by the company/office.

    CustInsuranceID

    int

    Obsolete.

    DiscountPercentage

    decimal(5,2)

    Percentage of discount to apply to the invoice.

    DiscountTypeID

    int

    DiscountTypeId is a nullable foreign key to the DiscountType table.

    Type of discount used on the order.

    DoctorID

    int

    The selected doctor on the order.
    DoctorID is a nullable foreign key to Employee table.

    Insurance

    int

    Obsolete.

    LensPkg

    varchar(30)

    Obsolete.

    MultiplePackage

    varchar(20)

    The value, if present, contains a random number separated by a pipe "|" followed by a PackageId. This 'key' indicates which InvoiceSummary records use the MultiplePackage indicated by the PackageId.

    InvoiceSummary records use the same MultiplePackage value to indicate that they use the MultiplePackage; specifically the PackageId on the right side of the pipe. When MultiplePackage has a value, the InvoiceSummary records involved will have the partial packages appear in the Package column.

    Notes

    varchar(30)

    Obsolete.

    OrderNum

    int

    OrderNum is a nullable foreign key to the Orders table.

    Related order.

    Package

    int

    Package indicates what package is used on the order.
    Package is a nullable foreign key to the Package table.

    When MultiplePackage is null, the value in Package points to a lens package record. When MultiplePackage has a value, the value in Package points to a partial package record.

    PkgOption

    varchar(30)

    Obsolete.

    PriceOption

    int

    PriceOption is a nullable foreign key to the PricingOption table.

    RefundTypeID

    int

    Reason for return/refund/adjustment. Related to the GenLookup table.

    TransNum

    int

    TransNum is a nullable foreign key to the PosTransaction table.

    Related transaction.

    Back to top Generated by Eyefinity