FCT_OEB_EXPENSE_TRANSACTION_INSIGHT

Database

INSNZP01_R12

Schema

R12PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 COST_CENTRE_LEVEL_01_CODE CHARACTER VARYING(150) 150
2 COST_CENTRE_LEVEL_01_NAME CHARACTER VARYING(240) 240
3 COST_CENTRE_LEVEL_01_TYPE CHARACTER VARYING(240) 240
4 COST_CENTRE_LEVEL_02_CODE CHARACTER VARYING(150) 150
5 COST_CENTRE_LEVEL_02_NAME CHARACTER VARYING(240) 240
6 COST_CENTRE_LEVEL_02_TYPE CHARACTER VARYING(240) 240
7 COST_CENTRE_LEVEL_03_CODE CHARACTER VARYING(150) 150
8 COST_CENTRE_LEVEL_03_NAME CHARACTER VARYING(240) 240
9 COST_CENTRE_LEVEL_03_TYPE CHARACTER VARYING(240) 240
10 COST_CENTRE_LEVEL_04_CODE CHARACTER VARYING(150) 150
11 COST_CENTRE_LEVEL_04_NAME CHARACTER VARYING(240) 240
12 COST_CENTRE_LEVEL_04_TYPE CHARACTER VARYING(240) 240
13 COST_CENTRE_LEVEL_05_CODE CHARACTER VARYING(150) 150
14 COST_CENTRE_LEVEL_05_NAME CHARACTER VARYING(240) 240
15 COST_CENTRE_LEVEL_05_TYPE CHARACTER VARYING(240) 240
16 COST_CENTRE_LEVEL_06_CODE CHARACTER VARYING(150) 150
17 COST_CENTRE_LEVEL_06_NAME CHARACTER VARYING(240) 240
18 COST_CENTRE_LEVEL_06_TYPE CHARACTER VARYING(240) 240
19 COST_CENTRE_LEVEL_07_CODE CHARACTER VARYING(150) 150
20 COST_CENTRE_LEVEL_07_NAME CHARACTER VARYING(240) 240
21 COST_CENTRE_LEVEL_07_TYPE CHARACTER VARYING(240) 240
22 COST_CENTRE_LEVEL_08_CODE CHARACTER VARYING(150) 150
23 COST_CENTRE_LEVEL_08_NAME CHARACTER VARYING(240) 240
24 COST_CENTRE_LEVEL_08_TYPE CHARACTER VARYING(240) 240
25 COST_CENTRE_LEVEL_09_CODE CHARACTER VARYING(150) 150
26 COST_CENTRE_LEVEL_09_NAME CHARACTER VARYING(240) 240
27 COST_CENTRE_LEVEL_09_TYPE CHARACTER VARYING(240) 240
28 COST_CENTRE_LEVEL_10_CODE CHARACTER VARYING(150) 150
29 COST_CENTRE_LEVEL_10_NAME CHARACTER VARYING(240) 240
30 COST_CENTRE_LEVEL_10_TYPE CHARACTER VARYING(240) 240
31 ACCOUNT_LEVEL_01_CODE CHARACTER VARYING(150) 150
32 ACCOUNT_LEVEL_01_NAME CHARACTER VARYING(240) 240
33 ACCOUNT_LEVEL_02_CODE CHARACTER VARYING(150) 150
34 ACCOUNT_LEVEL_02_NAME CHARACTER VARYING(240) 240
35 ACCOUNT_LEVEL_03_CODE CHARACTER VARYING(150) 150
36 ACCOUNT_LEVEL_03_NAME CHARACTER VARYING(240) 240
37 ACCOUNT_LEVEL_04_CODE CHARACTER VARYING(150) 150
38 ACCOUNT_LEVEL_04_NAME CHARACTER VARYING(240) 240
39 ACCOUNT_LEVEL_05_CODE CHARACTER VARYING(150) 150
40 ACCOUNT_LEVEL_05_NAME CHARACTER VARYING(240) 240
41 ACCOUNT_LEVEL_06_CODE CHARACTER VARYING(150) 150
42 ACCOUNT_LEVEL_06_NAME CHARACTER VARYING(240) 240
43 ACCOUNT_LEVEL_07_CODE CHARACTER VARYING(150) 150
44 ACCOUNT_LEVEL_07_NAME CHARACTER VARYING(240) 240
45 ACCOUNT_LEVEL_08_CODE CHARACTER VARYING(150) 150
46 ACCOUNT_LEVEL_08_NAME CHARACTER VARYING(240) 240
47 ACCOUNT_LEVEL_09_CODE CHARACTER VARYING(150) 150
48 ACCOUNT_LEVEL_09_NAME CHARACTER VARYING(240) 240
49 ACCOUNT_LEVEL_10_CODE CHARACTER VARYING(150) 150
50 ACCOUNT_LEVEL_10_NAME CHARACTER VARYING(240) 240
51 LEDGER_ID BIGINT 8
52 CURRENCY_CODE CHARACTER VARYING(15) 15
53 PERIOD_NAME CHARACTER VARYING(15) 15
54 CAL_YEAR BIGINT 8
55 CAL_YEAR_LABEL CHARACTER VARYING(4) 4
56 CAL_MONTH BIGINT 8
57 CAL_YEAR_MONTH BIGINT 8
58 FIN_YEAR BIGINT 8
59 FIN_YEAR_LABEL CHARACTER VARYING(4) 4
60 FIN_MONTH BIGINT 8
61 FIN_YEAR_MONTH BIGINT 8
62 PROJECT_CODE CHARACTER VARYING(25) 25
63 PROJECT_NAME CHARACTER VARYING(240) 240
64 BATCH_NAME CHARACTER VARYING(100) 100
65 BATCH_DESCRIPTION CHARACTER VARYING(240) 240
66 JE_HEADER_ID BIGINT 8
67 JE_LINE_NUM BIGINT 8
68 JOURNAL_ID CHARACTER VARYING(100) 100
69 JOURNAL_DESCRIPTION CHARACTER VARYING(240) 240
70 JOURNAL_LINE_DESCRIPTION CHARACTER VARYING(240) 240
71 JOURNAL_SOURCE CHARACTER VARYING(240) 240
72 ORIGINATOR_USER_ID CHARACTER VARYING(25) 25
73 INVOICE_NUMBER CHARACTER VARYING(50) 50
74 VENDOR_NAME CHARACTER VARYING(240) 240
75 CREATED_BY CHARACTER VARYING(100) 100
76 CREATION_DATE TIMESTAMP 8
77 EFFECTIVE_DATE TIMESTAMP 8
78 POSTING_DATE TIMESTAMP 8
79 ENTITY CHARACTER VARYING(391) 391
80 AMOUNT NUMERIC(19,2) 19