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. |
|
CalculateDiscByPercent |
bit |
Indicates if the global discount should calculated by percentage
or 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. |
|
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. |
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. |