| CREDIT_CARD_ID |
Integer |
11 |
PK |
| PROCESSOR_NAME |
Varchar |
21 |
Identifies which company the card is issued thru |
| PAYMENT_TYPE_ID |
Integer |
10 |
BobID of payment type associated with card, Example: 'company paid' payment
type.. |
| USER_ID |
Integer |
11 |
Identifies which user is the card holder. |
| ACCOUNT_NUMBER |
Varchar |
70 |
Credit or charge card account number |
| NAME_LINE_1 |
Varchar |
16 |
The first name line from the card |
| NAME_LINE_2 |
Varchar |
16 |
The second name line from the card |
| ADDRESS_LINE_1 |
Varchar |
16 |
The first address line on the card |
| ADDRESS_LINE_2 |
Varchar |
16 |
The second address line on the card |
| IS_PAID_BY_COMPANY |
Integer |
1 |
Value 0 = traveler pays credit card company (IBIP) Value 1 = company pays
credit card bill. (IBCP) |
| SPENDING_LIMIT_AMOUNT_CURRENCY |
Varchar |
3 |
Currency of the spending limit amount |
| SPENDING_LIMIT_AMOUNT |
Float |
9 |
The spending limit amount. |
| CARD_ISSUER |
Varchar |
36 |
The name of the card, from the user's point of view |
| IS_CARD_ACTIVE |
Integer |
1 |
Indicates whether the card is active or has been deactivated. |
| DEACTIVATION_DATE |
DateTime |
|
The date the card was deactivated. |
| IS_PR_CARD |
Integer |
1 |
If this value is 1, it indicates this card is a personal card which can be
used by user to import personal cc transactions (OFX). If it is 0 or null, it is not
a personal card and user cant use it to import personal cc transactions (OFX).
|
| CARD_TYPE |
Varchar |
21 |
code representing type of credit card. possible values are
AMEX,VISA,MC,Discover,JCB |
| COST_CENTER_ID |
Integer |
1 |
UID of default cost center for this card |
| PROJECT_NUMBER_ID |
Integer |
1 |
UID of default project number for this card |
| GLCODE |
|
|
|
| CHANGE_TIMESTAMP |
DateTime |
|
|