SURCHARGE POSTINGS Table
Surcharge postings
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_ELEMENT_ID |
XXX |
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 |
SURCHARGE_BASE_PATTERN_KEY |
Key used to join the GL_ACCOUNT table with SURCHARGE_PERCENTAGES and SURCHARGE_POSTINGS tables. |
NUMBER |
22 |
SURCHARGE_CALC_PATTERN_KEY |
Key used to join the COST_COLLECTORS_ACCESSIBLE table to the SURCHARGE_PERCENTAGES and SURCHARGE_POSTINGS tables. |
NUMBER |
22 |
SURCHARGE_PERCENT |
XXX |
NUMBER |
22 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |