CREDIT CARD DETAIL Table
Credit card Transactions. Taken from table BSEG in SAP.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTUAL_AMOUNT |
The paid dollar amount of the line item. |
NUMBER |
11 |
CARD_HOLDER_USERNAME |
The uppercase Kerberos ID or SAP username of the credit card holder. |
VARCHAR2 |
12 |
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
CREDIT_CARD_ID |
Internal credit card identification number. MIT-assigned number, not to be confused with the actual credit card number. |
VARCHAR2 |
6 |
DEBIT_CREDIT_INDICATOR |
A one-character flag that identifies whether the line item is a debit or credit. Values are D or C. |
VARCHAR2 |
1 |
DOCUMENT_DATE |
The date entered by the user when creating the document. Generally the date the financial transaction occurred, but see also the definition for document line date. |
DATE |
8 |
DOCUMENT_ENTRY_DATE |
The date the document was entered into SAP. |
DATE |
8 |
DOCUMENT_LAST_CHANGE_DATE |
he date the document was last modified in SAP. |
DATE |
8 |
DOCUMENT_LINE_ITEM |
Document Line Item Number. |
NUMBER |
3 |
DOCUMENT_NUMBER |
The number in SAP that uniquely identifies a detailed transaction document. |
VARCHAR2 |
10 |
FUND_CENTER_KEY |
Key used only for joining the FINANCIAL_DETAIL table with other tables, NOT for reporting. |
VARCHAR2 |
16 |
FUND_KEY |
Key is used only for joining the FUND table with the FINANCIAL_DETAIL table, NOT for reporting. |
VARCHAR2 |
10 |
GL_ACCOUNT_KEY |
Key used to join the GL_ACCOUNT to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
10 |
MERCHANT_CATEGORY |
The category of the merchant relevant to this particular credit card transaction. Example: Retail Food, Home Supply, General Retail, etc. |
VARCHAR2 |
25 |
MERCHANT_CATEGORY_KEY |
XXX |
VARCHAR2 |
25 |
MERCHANT_NAME |
The name of the merchant relevant to this particular credit card transaction. |
VARCHAR2 |
30 |
POSTING_DATE |
The date the financial document was posted in SAP. Effective date of posting, not actual date. For example, a costing sheet posting could be generated in early July, but posted to June 30, if so specified by an authorized users. |
DATE |
8 |
POSTING_KEY |
Key required by SAP for each document line item, indicating the type of posting represented in the line item. "Posting Key" is the description for "Posting Key Code". |
VARCHAR2 |
3 |
POSTING_KEY_CODE |
2 digit code identifing the type of posting. Example: 09 - Security Deposit, 08 - Payment Clearing, 09 - Pledge, 09 - Special G/L Debit, 09 - Interest Due, 11 - Credit Memo, 40 - Debit, 50 - Credit, etc. |
VARCHAR2 |
2 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
TRANSACTION_CODE |
The code assigned to each transaction by SAP. It may be more meaningful to use the document type. |
VARCHAR2 |
4 |
TRANSACTION_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
VERIFIER_USER_NAME |
XXX |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |