FCT_COMM_VALUATION_SUMM
Description
Target Objects (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | INVOICE_DATE | TIMESTAMP | 8 |
| 2 | GL_ENTITY | CHARACTER VARYING(25) | 25 |
| 3 | GL_COST_CENTRE | CHARACTER VARYING(25) | 25 |
| 4 | LEVEL_10_NAME | CHARACTER VARYING(391) | 391 |
| 5 | EXPENSE_ACCOUNT | CHARACTER VARYING(25) | 25 |
| 6 | EXPENSE_AMOUNT | NUMERIC(38,2) | 19 |
| 7 | INCOME_ACCOUNT | CHARACTER VARYING(25) | 25 |
| 8 | INCOME_AMOUNT | NUMERIC(38,2) | 19 |
| 9 | DESCRIPTION_HEADER_PO | CHARACTER VARYING(240) | 240 |
| 10 | DESCRIPTION_LINES_PO | CHARACTER VARYING(240) | 240 |
| 11 | CLMS_BORROWER_NO | CHARACTER VARYING(9) | 9 |
| 12 | SUPPLIER_NUMBER | CHARACTER VARYING(30) | 30 |
| 13 | SUPPLIER_NAME | CHARACTER VARYING(246) | 246 |