GetTransactionHeaderInfoByDate()

iId

Integer

4

Primary Key - Unique Identifier.

iLocationId

Integer

4

Not used.

tLastChg

DateTime

8

Date/time last changed.

cInvoiceNo

String

12

Transaction invoice number. 

(Formatted as YYYYMMDDXXXX - where XXXX is an incrementing ticket number.)

tDateTime

DateTime

8

Transaction date/time.

iClientId

Integer

4

Paying Client Id.  Foreign Key to Client iId.

nDrawerId

Decimal

2,0

Drawer Id.

lNoGST

Boolean

1

Indicates if GST tax applies on this transaction.

lNoPST

Boolean

1

Indicates if PST tax applies on this transaction.

lMailOrder

Boolean

1

Indicates if this transaction is a mail order transaction.

iMailOrderId

Integer

4

Mail Order Id. Foreign Key to Mail Orders iId.

nPSTCollected

Decimal

8

PST tax collected on transaction.

nGSTCollected

Decimal

8

GST tax collected on transaction.

lVoid

Boolean

1

Indicates whether an employee voided the transaction.  

Note:  This method does not return voided transactions.

iLoginId

Integer

4

Login Id of user who created the transaction.  Foreign Key to Logins iId.

iLastChgBy

Integer

4

Login Id of user who last changed the transaction.  Foreign Key to Logins iId.

iTaxId

Integer

4

Tax Id.  Foreign Key to Tax Rates iId.

iSeconds

Integer

4

Length of time (in seconds) transaction took to be completed.

iGId

Integer

4

Transaction Header Global Id.

mNotes

String

Transaction notes.