/*
Table: efsnetRequest

Columns:
	date int
	cashierNo int
	laneNo int
	transNo int
	transID int
	datetime datetime
	refNum varchar
	live tinyint
	mode varchar
	amount double
	PAN varchar
	issuer varchar
	name varchar
	manual tinyint
	sentPAN tinyint
	sentExp tinyint
	sentTr1 tinyint
	sentTr2 tinyint	
    efsnetRequestID int

Depends on:
	none

Use:
This table logs information that is
sent to a credit-card payment gateway.
All current paycard modules use this table
structure. Future ones don't necessarily have
to, but doing so may enable more code re-use.

Some column usage may vary depending on a
given gateway's requirements and/or formatting,
but in general:

cashierNo, laneNo, transNo, and transID are
equivalent to emp_no, register_no, trans_no, and
trans_id in dtransactions (respectively).

mode indicates the type of transaction, such as
refund or sale. Exact value can vary from gateway
to gateway.

PAN is the cardnumber - for the love of $deity
only save the last 4 digits here - issuer is
Visa, MC, etc, and name is the cardholder's name
(if available).

The sent* columns indicate which information was
sent. Most gateways will accept PAN + expiration
date, or either track. Sending both tracks is
usually fine; I've never seen a system where
you send all 4 pieces of card info.

efsnetRequestID is an incrementing ID columns. This
is unique at a lane level but not an overall system
level since different lanes will increment through
the same ID values. The combination of laneNo and
efsnetRequestID should be unique though.
*/