FCT_COMM_VALUATION_DETAIL

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

INSNZP02_BANK..FCT_COMM_VALUATION_DETAIL_INSIGHT

Columns
# Name Data Type Length
1 COST_CENTRE_CODE CHARACTER VARYING(25) 25
2 ACCOUNT_CODE CHARACTER VARYING(25) 25
3 CATEGORY_ID BIGINT 8
4 CLOSED_DATE_PERIOD TIMESTAMP 8
5 SUBMIT_DATE_PERIOD DATE 4
6 CREATION_DATE_PERIOD TIMESTAMP 8
7 PO_NUMBER CHARACTER VARYING(31) 31
8 PO_AGREEMENT_NUMBER CHARACTER VARYING(20) 20
9 INVOICE_ID BIGINT 8
10 INVOICE_PAYMENT_ID BIGINT 8
11 ACCOUNTING_MONTH TIMESTAMP 8
12 FIN_YEAR SMALLINT 2
13 FIN_QUARTER_CODE CHARACTER VARYING(10) 10
14 FIN_MONTH BIGINT 8
15 FIN_YEAR_MONTH CHARACTER VARYING(11) 11
16 SPEND_AMOUNT NUMERIC(38,2) 19
17 PAYMENT_AMOUNT NUMERIC(38,2) 19
18 SUPPLIER_NUMBER CHARACTER VARYING(30) 30
19 SUPPLIER_NAME CHARACTER VARYING(246) 246
20 VENDOR_LABEL CHARACTER VARYING(273) 273
21 SUPPLIER_PARENT NATIONAL CHARACTER VARYING(250) 250
22 SUPPLIER_UNIQUE NATIONAL CHARACTER VARYING(285) 285
23 LEVEL_01_CODE CHARACTER VARYING(150) 150
24 LEVEL_01_NAME CHARACTER VARYING(240) 240
25 LEVEL_02_CODE CHARACTER VARYING(150) 150
26 LEVEL_02_NAME CHARACTER VARYING(391) 391
27 LEVEL_03_CODE CHARACTER VARYING(150) 150
28 LEVEL_03_NAME CHARACTER VARYING(391) 391
29 LEVEL_04_CODE CHARACTER VARYING(150) 150
30 LEVEL_04_NAME CHARACTER VARYING(391) 391
31 LEVEL_05_CODE CHARACTER VARYING(150) 150
32 LEVEL_05_NAME CHARACTER VARYING(391) 391
33 LEVEL_06_CODE CHARACTER VARYING(150) 150
34 LEVEL_06_NAME CHARACTER VARYING(391) 391
35 LEVEL_07_CODE CHARACTER VARYING(150) 150
36 LEVEL_07_NAME CHARACTER VARYING(391) 391
37 LEVEL_08_CODE CHARACTER VARYING(150) 150
38 LEVEL_08_NAME CHARACTER VARYING(391) 391
39 LEVEL_09_CODE CHARACTER VARYING(150) 150
40 LEVEL_09_NAME CHARACTER VARYING(391) 391
41 LEVEL_10_CODE CHARACTER VARYING(150) 150
42 LEVEL_10_NAME CHARACTER VARYING(391) 391
43 ITEM_TYPE CHARACTER VARYING(14) 14
44 CATEGORY_LEVEL1 CHARACTER VARYING(240) 240
45 CATEGORY_LEVEL2 CHARACTER VARYING(240) 240
46 CATEGORY_LEVEL3 CHARACTER VARYING(240) 240
47 INVOICE_NUM CHARACTER VARYING(50) 50
48 INVOICE_DESCRIPTION CHARACTER VARYING(240) 240
49 INVOICE_DATE TIMESTAMP 8
50 INVOICE_AMOUNT NUMERIC(38,6) 19
51 DIST_DESCRIPTION CHARACTER VARYING(240) 240
52 PAID_DATE DATE 4
53 JE_HEADER_ID_PO BIGINT 8
54 LEDGER_ID_PO BIGINT 8
55 NAME_PO CHARACTER VARYING(100) 100
56 STATUS_PO CHARACTER VARYING(1) 1
57 JE_SOURCE_PO CHARACTER VARYING(25) 25
58 JE_CATEGORY_PO CHARACTER VARYING(25) 25
59 GL_ENTITY_PO CHARACTER VARYING(25) 25
60 GL_COST_CENTRE_PO CHARACTER VARYING(25) 25
61 GL_ACCOUNT_PO CHARACTER VARYING(25) 25
62 CURRENCY_CODE_PO CHARACTER VARYING(15) 15
63 ACCOUNTED_DR_PO NUMERIC(18,2) 19
64 ACCOUNTED_CR_PO NUMERIC(18,2) 19
65 ENTERED_DR_PO NUMERIC(18,2) 19
66 ENTERED_CR_PO NUMERIC(18,2) 19
67 PERIOD_NAME_PO CHARACTER VARYING(15) 15
68 DESCRIPTION_HEADER_PO CHARACTER VARYING(240) 240
69 DESCRIPTION_LINES_PO CHARACTER VARYING(240) 240
70 CLMS_BORROWER_NO_PROC CHARACTER VARYING(9) 9
71 JE_HEADER_ID BIGINT 8
72 LEDGER_ID BIGINT 8
73 NAME CHARACTER VARYING(100) 100
74 STATUS CHARACTER VARYING(1) 1
75 JE_SOURCE CHARACTER VARYING(25) 25
76 JE_CATEGORY CHARACTER VARYING(25) 25
77 GL_ENTITY CHARACTER VARYING(25) 25
78 GL_COST_CENTRE CHARACTER VARYING(25) 25
79 GL_ACCOUNT CHARACTER VARYING(25) 25
80 CURRENCY_CODE CHARACTER VARYING(15) 15
81 ACCOUNTED_DR NUMERIC(18,2) 19
82 ACCOUNTED_CR NUMERIC(18,2) 19
83 ENTERED_DR NUMERIC(18,2) 19
84 ENTERED_CR NUMERIC(18,2) 19
85 PERIOD_NAME CHARACTER VARYING(15) 15
86 DESCRIPTION_HEADER CHARACTER VARYING(240) 240
87 DESCRIPTION_LINES CHARACTER VARYING(240) 240
88 CLMS_BORROWER_NO CHARACTER VARYING(9) 9