• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part: VI Appendixes > The tblPayments Table

The tblPayments Table

This table stores client payment information, such as the amount and date of payment for particular projects.

Table A.31. The tblPayments Table
Field NameTypeSize (Bytes)
PaymentIDNumber (Long)4
ProjectIDNumber (Long)4
PaymentAmountCurrency8
PaymentDateDate/Time8
CreditCardNumberText30
CardholdersNameText50
CreditCardExpDateDate/Time8
PaymentMethodIDNumber (Long)4



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint