CREDIT CARD ACCT ASSIGNMENT Table
Contains information about default account assignment rules for credit cards.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_ASSIGNMENT_POSITION |
XXX |
VARCHAR2 |
3 |
ACCOUNT_ASSIGNMENT_RULE |
XXX |
VARCHAR2 |
6 |
CHANGE_DATE |
XXX |
DATE |
8 |
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 |
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 |
LAST_CHANGED_BY |
Username of the person who last changed/modified/updated this record. |
VARCHAR2 |
8 |
PERCENTAGE_TO_DISTRIBUTE |
XXX |
NUMBER |
22 |
SHORT_TEXT |
XXX |
VARCHAR2 |
30 |
VALID_FROM_DATE |
XXX |
DATE |
8 |
VALID_TO_DATE |
XXX |
DATE |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |