Home > Technical > Table Definitions > CUSTCARDS

CUSTCARDS

Details about the customer cards that have been assigned to a customer.

Column Type Description

LINTCUSTOMERNUM

INTEGER

The customer to which this card belongs.

CUSTOMER.lintCustomerNum

DBLCARDNUM

FLOAT

The card number associated with this customer. Superceded by strCardNum.

INTSTATUS

INTEGER

A number which indicates the status of the card.

DTMVALIDFROM

DATETIME

The date the card is valid from.

DTMVALIDTO

DATETIME

The date the card is valid to.

STRCARDNUM

VARCHAR(38)

The card number associated with this customer. This supercedes dblCardNum. A trigger will automatically update dblCardNum from strCardNum. If strCardNum contains alphabetic characters, then dblCardNum will be set to the lintCustomerNum * -1.

STRCARDNUMTO

VARCHAR(38)

 

INTCARDNUMLENGTH

INT

 

STRREPLTRADECODE

VARCHAR(10)

 

INTNEWFLAG

INT

 

INTCHANGEFLAG

INT

 

 

Primary Key: LINTCUSTOMERNUM+DBLCARDNUM + STRCARDNUMTO

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)