FCT_OEB_PROCUREMENT_INSIGHT

Database

INSNZP01_R12

Schema

R12PADM

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..BNKNIC_FCT_OEB_PROCUREMENT_INSIGHT

SDSNZP02_BANK..BNKNIC_R12_FCT_OEB_PROCUREMENT_INSIGHT

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 COST_CENTRE_CODE CHARACTER VARYING(25) 25
3 ACCOUNT_CODE CHARACTER VARYING(25) 25
4 CATEGORY_ID BIGINT 8
5 CLOSED_DATE_PERIOD TIMESTAMP 8
6 SUBMIT_DATE_PERIOD DATE 4
7 CREATION_DATE_PERIOD TIMESTAMP 8
8 PO_TYPE CHARACTER VARYING(18) 18
9 BUYING_CHANNEL_TYPE CHARACTER VARYING(27) 27
10 PO_NUMBER CHARACTER VARYING(31) 31
11 PO_AGREEMENT_NUMBER CHARACTER VARYING(20) 20
12 PO_CONTRACT_NUMBER CHARACTER VARYING(150) 150
13 PO_CONTRACT CHARACTER VARYING(11) 11
14 INVOICE_ID BIGINT 8
15 INVOICE_PAYMENT_ID BIGINT 8
16 VENDOR_ID BIGINT 8
17 VENDOR_ID_COUNTER INTEGER 4
18 VENDOR_SITE_ID BIGINT 8
19 ACCOUNTING_MONTH TIMESTAMP 8
20 FIN_YEAR SMALLINT 2
21 FIN_QUARTER_CODE CHARACTER VARYING(10) 10
22 FIN_MONTH BIGINT 8
23 FIN_YEAR_MONTH CHARACTER VARYING(11) 11
24 SPEND_AMOUNT NUMERIC(38,2) 19
25 GST_AMOUNT NUMERIC(38,2) 19
26 SPEND_INC_GST NUMERIC(38,2) 19
27 PAYMENT_AMOUNT NUMERIC(38,2) 19
28 PO_SPEND_TYPE CHARACTER VARYING(6) 6
29 SUPPLIER_PREFERENCE CHARACTER VARYING(13) 13
30 AGREED_PAYMENT_TERMS CHARACTER VARYING(240) 240
31 AGREED_PAYMENT_TERMS_SORTING INTEGER 4
32 PAYMENT_GROUP CHARACTER VARYING(10) 10
33 ACTUAL_PAYMENT_DAYS INTEGER 4
34 PAYMENT_GROUP_SORTING INTEGER 4
35 EXTRA_LEVEL CHARACTER VARYING(4) 4
36 SUPPLIER_NUMBER CHARACTER VARYING(30) 30
37 SUPPLIER_NAME CHARACTER VARYING(246) 246
38 CARD_OWNER CHARACTER VARYING(271) 271
39 VENDOR_LABEL CHARACTER VARYING(273) 273
40 SUPPLIER_PARENT NATIONAL CHARACTER VARYING(250) 250
41 SUPPLIER_UNIQUE NATIONAL CHARACTER VARYING(285) 285
42 LOB_COUNTER INTEGER 4
43 LEVEL_01_CODE CHARACTER VARYING(150) 150
44 LEVEL_01_NAME CHARACTER VARYING(240) 240
45 LEVEL_02_CODE CHARACTER VARYING(150) 150
46 LEVEL_02_NAME CHARACTER VARYING(391) 391
47 LEVEL_03_CODE CHARACTER VARYING(150) 150
48 LEVEL_03_NAME CHARACTER VARYING(391) 391
49 LEVEL_04_CODE CHARACTER VARYING(150) 150
50 LEVEL_04_NAME CHARACTER VARYING(391) 391
51 LEVEL_05_CODE CHARACTER VARYING(150) 150
52 LEVEL_05_NAME CHARACTER VARYING(391) 391
53 LEVEL_06_CODE CHARACTER VARYING(150) 150
54 LEVEL_06_NAME CHARACTER VARYING(391) 391
55 LEVEL_07_CODE CHARACTER VARYING(150) 150
56 LEVEL_07_NAME CHARACTER VARYING(391) 391
57 LEVEL_08_CODE CHARACTER VARYING(150) 150
58 LEVEL_08_NAME CHARACTER VARYING(391) 391
59 LEVEL_09_CODE CHARACTER VARYING(150) 150
60 LEVEL_09_NAME CHARACTER VARYING(391) 391
61 LEVEL_10_CODE CHARACTER VARYING(150) 150
62 LEVEL_10_NAME CHARACTER VARYING(391) 391
63 ITEM_TYPE CHARACTER VARYING(14) 14
64 ITEM_ID BIGINT 8
65 AC_LEVEL_01_CODE CHARACTER VARYING(150) 150
66 AC_LEVEL_01_NAME CHARACTER VARYING(240) 240
67 AC_LEVEL_02_CODE CHARACTER VARYING(150) 150
68 AC_LEVEL_02_NAME CHARACTER VARYING(391) 391
69 AC_LEVEL_03_CODE CHARACTER VARYING(150) 150
70 AC_LEVEL_03_NAME CHARACTER VARYING(391) 391
71 AC_LEVEL_04_CODE CHARACTER VARYING(150) 150
72 AC_LEVEL_04_NAME CHARACTER VARYING(391) 391
73 AC_LEVEL_05_CODE CHARACTER VARYING(150) 150
74 AC_LEVEL_05_NAME CHARACTER VARYING(391) 391
75 AC_LEVEL_06_CODE CHARACTER VARYING(150) 150
76 AC_LEVEL_06_NAME CHARACTER VARYING(391) 391
77 AC_LEVEL_07_CODE CHARACTER VARYING(150) 150
78 AC_LEVEL_07_NAME CHARACTER VARYING(391) 391
79 AC_LEVEL_08_CODE CHARACTER VARYING(150) 150
80 AC_LEVEL_08_NAME CHARACTER VARYING(391) 391
81 AC_LEVEL_09_CODE CHARACTER VARYING(150) 150
82 AC_LEVEL_09_NAME CHARACTER VARYING(391) 391
83 AC_LEVEL_10_CODE CHARACTER VARYING(150) 150
84 AC_LEVEL_10_NAME CHARACTER VARYING(391) 391
85 AC1_LEVEL_01_CODE CHARACTER VARYING(150) 150
86 AC1_LEVEL_01_NAME CHARACTER VARYING(240) 240
87 AC1_LEVEL_02_CODE CHARACTER VARYING(150) 150
88 AC1_LEVEL_02_NAME CHARACTER VARYING(391) 391
89 AC1_LEVEL_03_CODE CHARACTER VARYING(150) 150
90 AC1_LEVEL_03_NAME CHARACTER VARYING(391) 391
91 AC1_LEVEL_04_CODE CHARACTER VARYING(150) 150
92 AC1_LEVEL_04_NAME CHARACTER VARYING(391) 391
93 AC1_LEVEL_05_CODE CHARACTER VARYING(150) 150
94 AC1_LEVEL_05_NAME CHARACTER VARYING(391) 391
95 AC1_LEVEL_06_CODE CHARACTER VARYING(150) 150
96 AC1_LEVEL_06_NAME CHARACTER VARYING(391) 391
97 AC1_LEVEL_07_CODE CHARACTER VARYING(150) 150
98 AC1_LEVEL_07_NAME CHARACTER VARYING(391) 391
99 AC1_LEVEL_08_CODE CHARACTER VARYING(150) 150
100 AC1_LEVEL_08_NAME CHARACTER VARYING(391) 391
101 AC1_LEVEL_09_CODE CHARACTER VARYING(150) 150
102 AC1_LEVEL_09_NAME CHARACTER VARYING(391) 391
103 AC1_LEVEL_10_CODE CHARACTER VARYING(150) 150
104 AC1_LEVEL_10_NAME CHARACTER VARYING(391) 391
105 CATEGORY_LEVEL1 CHARACTER VARYING(40) 40
106 CATEGORY_LEVEL2 CHARACTER VARYING(240) 240
107 CATEGORY_LEVEL3 CHARACTER VARYING(240) 240
108 CATEGORY_LEVEL4 CHARACTER VARYING(240) 240
109 INVOICE_NUM CHARACTER VARYING(50) 50
110 INVOICE_DESCRIPTION CHARACTER VARYING(240) 240
111 INVOICE_DATE TIMESTAMP 8
112 INVOICE_AMOUNT NUMERIC(38,6) 19
113 DIST_DESCRIPTION CHARACTER VARYING(240) 240
114 SPEND_TYPE CHARACTER VARYING(15) 15
115 PAID_DATE DATE 4
116 SUPPLIER_TYPE CHARACTER VARYING(230) 230
117 COMMENTS CHARACTER VARYING(240) 240
118 TOTAL_BUYING_CHANNEL_COMMITMENT NUMERIC(18,2) 19
119 PAYMENT_METHOD CHARACTER VARYING(30) 30
120 SOURCE_SYSTEM CHARACTER VARYING(3) 3
121 COUNTRY CHARACTER VARYING(9) 9
122 SETTLEMENT_TYPE CHARACTER VARYING(7) 7
123 TRANSACTION_TYPE CHARACTER VARYING(7) 7
124 TRANSACTION_TYPE_ID SMALLINT 2
125 INVOICE_RECEIVED_DATE TIMESTAMP 8
126 PAYMENT_LAST_UPDATE_DATE TIMESTAMP 8
127 TAXONOMY_VERSION CHARACTER VARYING(9) 9