CREDIT CARD MASTER Table
View exposing credit card master data including cardholder, status, limits, validity dates, SAP username, contact information, and related administrative attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BUILDING_ROOM |
Building room as provided by the source. |
VARCHAR2 |
10 |
CARDHOLDER_ID |
Business identifier for the cardholder. |
VARCHAR2 |
9 |
CARDHOLDER_NAME |
Cardholder name as provided by the source. |
VARCHAR2 |
35 |
COMPANY_TO_BANK_ID |
Business identifier for the company to bank. |
VARCHAR2 |
10 |
CREDIT_CARD_ID |
Business identifier for the credit card. |
VARCHAR2 |
6 |
CREDIT_CARD_SAP_USERNAME |
Credit card sap username as provided by the source. |
VARCHAR2 |
8 |
CREDIT_CARD_STATUS |
Credit card status as provided by the source. |
VARCHAR2 |
10 |
CREDIT_CARD_TYPE |
Credit card type as provided by the source. |
VARCHAR2 |
1 |
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
50 |
MERCHANT_BLOCKING_FLAG |
Merchant blocking flag as provided by the source. |
VARCHAR2 |
1 |
MONTHLY_STATEMENT_FLAG |
Monthly statement flag as provided by the source. |
VARCHAR2 |
1 |
ORGANIZATION_NUMBER |
Organization number as provided by the source. |
VARCHAR2 |
7 |
PHONE_NUMBER |
Phone number associated with the record. |
VARCHAR2 |
8 |
POST_NOT_PARK_FLAG |
Post not park flag as provided by the source. |
VARCHAR2 |
1 |
SEND_EMAIL_FLAG |
Email address associated with the record. |
VARCHAR2 |
1 |
SINGLE_TRANSACTION_LIMIT |
Single transaction limit as provided by the source. |
NUMBER |
11,2 |
SPENDING_LIMIT |
Spending limit as provided by the source. |
NUMBER |
11,2 |
THIRD_LINE_INFO |
Third line info as provided by the source. |
VARCHAR2 |
20 |
VALID_FROM_DATE |
Date associated with valid from. |
DATE |
|
VALID_TO_DATE |
Date associated with valid to. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date associated with warehouse load. |
DATE |