CREDIT CARD DETAIL Table
Stores credit card transaction detail records, including financial amounts, posting information, merchant details, card holder identifiers, and accounting attributes for financial reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTUAL_AMOUNT |
Transaction amount associated with the credit card charge. |
NUMBER |
13,2 |
CARD_HOLDER_USERNAME |
Username of the individual who holds the credit card. |
VARCHAR2 |
24 |
COST_COLLECTOR_KEY |
Key identifier for the cost collector associated with the transaction. |
VARCHAR2 |
12 |
CREDIT_CARD_ID |
Identifier for the credit card used for the transaction. |
VARCHAR2 |
6 |
DEBIT_CREDIT_INDICATOR |
Indicator identifying whether the transaction is a debit or credit. |
VARCHAR2 |
1 |
DOCUMENT_DATE |
Date the financial document was created. |
DATE |
|
DOCUMENT_ENTRY_DATE |
Date the document was entered into the system. |
DATE |
|
DOCUMENT_LAST_CHANGE_DATE |
Date the document was last modified. |
DATE |
|
DOCUMENT_LINE_ITEM |
Line item number within the financial document. |
NUMBER |
|
DOCUMENT_NUMBER |
Unique identifier for the financial document. |
VARCHAR2 |
10 |
FUND_CENTER_KEY |
Key identifier for the fund center associated with the transaction. |
VARCHAR2 |
16 |
FUND_KEY |
Key identifier for the fund associated with the transaction. |
VARCHAR2 |
10 |
GL_ACCOUNT_KEY |
Key identifier for the general ledger account associated with the transaction. |
VARCHAR2 |
10 |
MERCHANT_CATEGORY |
Category describing the type of merchant. |
VARCHAR2 |
60 |
MERCHANT_CATEGORY_KEY |
Key identifier for the merchant category associated with the transaction. |
VARCHAR2 |
4 |
MERCHANT_NAME |
Name of the merchant where the transaction occurred. |
VARCHAR2 |
100 |
POSTING_DATE |
Date the transaction was posted to the general ledger. |
DATE |
|
POSTING_KEY |
Posting key associated with the transaction. |
VARCHAR2 |
3 |
POSTING_KEY_CODE |
Code identifying the posting key. |
VARCHAR2 |
2 |
TIME_MONTH_KEY |
Key representing the fiscal month associated with the transaction. |
VARCHAR2 |
6 |
TRANSACTION_CODE |
Code identifying the transaction type or process. |
VARCHAR2 |
20 |
TRANSACTION_COUNTER |
Counter indicating transaction sequencing or versioning. |
NUMBER |
|
VERIFIER_USER_NAME |
User identifier for the individual who verified the transaction. |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the warehouse. |
DATE |