CREDIT CARD ACCT ASSIGNMENT Table
View exposing credit card account-assignment rules including cost collector, general ledger account, assignment position, distribution percentage, validity dates, and audit attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_ASSIGNMENT_POSITION |
Account assignment position as provided by the source. |
VARCHAR2 |
3 |
ACCOUNT_ASSIGNMENT_RULE |
Account assignment rule as provided by the source. |
VARCHAR2 |
6 |
CHANGE_DATE |
Date associated with change. |
DATE |
|
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
CREDIT_CARD_ID |
Business identifier for the credit card. |
VARCHAR2 |
6 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
LAST_CHANGED_BY |
Last changed by as provided by the source. |
VARCHAR2 |
8 |
PERCENTAGE_TO_DISTRIBUTE |
Percentage to distribute as provided by the source. |
NUMBER |
11,2 |
SHORT_TEXT |
Short text as provided by the source. |
VARCHAR2 |
30 |
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 |