Table:

PosTransaction

PosTransaction is the table that connects orders and payments with Invoices, tracking the transaction type financial events, such as sales, payments, returns and refunds.

Name Type Description Remarks
Amount

decimal(10,2)

The amount of the transaction.

The amount's sign is related to the type of the transaction. For example, amounts for a sale transaction are positive, while amounts for a payment are negative.
BookDate

Delivery date of items on related order. Used in KPI calculations.
Closed

bit

Indicates that the transaction has been closed, meaning that it has been included in a DayClose record.

True = 1, False = 0
DayCloseID

int

DayCloseId is a nullable foreign key to the DayClose table.

Transaction data is rolled up to the record indicated by the DayCloseId in the DayClose table to summarize the transactional activity for the day.
EmployeeID

int

EmployeeId is a nullable foreign key to the Employee table.
ExcludeFromReconciliation

bit

Indicates if the transaction will/will not appear on reports (except for the Miscellaneous Transaction Report).

Transactions with this set to 1 will not appear on reports (except for the Miscellaneous Transaction Report). Defaults to 0.
InvoiceSummaryID

int

InvoiceSummaryID is a nullable foreign key to the InvoiceSum table and represents the Invoice to which this transaction relates.

Not all transactions are related to an Invoice. The following TransactionTypes are not related to an InvoiceSummary directly except where indicated:

Payment = 2

Refund = 4

Miscellaneous = 11

RefundCustomerCredit = 12

Collections = 13

OutOfStoreReturn = 14 (sometimes related)

OutOfStoreRefund = 15
IsOfficeTransaction

bit

Indicates if the transaction takes place as a result of an action in the office.

The following TransactionTypes result in IsOfficeTransaction = true:

Payment = 2

Refund = 4

OldSystemBalance = 8

Miscellaneous = 11

RefundCustomerCredit = 12

Collections = 13

OutOfStoreReturn = 14

OutOfStoreRefund = 15


True = 1, False = 0

OfficeNum

varchar(8)

Number of the office in which the transaction originated.
OrderID

int

OrderId is a nullable foreign key to the Orders table and represents the Order to which this particular transaction relates.
PatientID

int

PatientID is a nullable foreign key to the Patient table.
PaymentID

int

PaymentId is a nullable foreign key to the PosPayment table.
ReturnProcessed

bit

Indicates if the return of an order has been processed.

True = 1, False = 0
SystemDate

DateTime

Date and time the transaction was recorded on server.
TransactionDate

DateTime

Date and time the transaction took place local time to the office.
TransactionTypeID

int

TransactionTypeID is a nullable foreign key to the PosTransactionType table.

Common types of TransactionTypes are:

Sale = 1

Payment = 2

Return = 3

Refund = 4