FCT_OEB_INDIRECT_LEGAL_PAYMENTS_INSIGHT

Database

INSNZP01_R12

Schema

R12PADM

Type

TABLE

Description

 

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 CATEGORY_LEVEL1 CHARACTER VARYING(240) 240
5 CATEGORY_LEVEL2 CHARACTER VARYING(240) 240
6 CATEGORY_LEVEL3 CHARACTER VARYING(240) 240
7 TAXONOMY_VERSION CHARACTER VARYING(9) 9
8 INVOICE_ID BIGINT 8
9 GROSS_AMOUNT NUMERIC(38,2) 19
10 NET_AMOUNT NUMERIC(38,2) 19
11 GST_AMOUNT NUMERIC(38,2) 19
12 INVOICE_LINE_ID CHARACTER VARYING(72) 72
13 INVOICE_LINE_NUMBER NUMERIC(18,2) 19
14 DIST_DESCRIPTION CHARACTER VARYING(263) 263
15 INVOICE_PAYMENT_ID BIGINT 8
16 VENDOR_ID BIGINT 8
17 VENDOR_SITE_ID BIGINT 8
18 ITEM_CODE BIGINT 8
19 ITEM_DESCRIPTION CHARACTER VARYING(240) 240
20 DATE_OF_TRANSACTION_POSTING_AGAINST_LEDGER TIMESTAMP 8
21 PO_TYPE CHARACTER VARYING(18) 18
22 PO_AGREEMENT_TYPE CHARACTER VARYING(27) 27
23 PO_NUMBER CHARACTER VARYING(31) 31
24 PO_AGREEMENT_NUMBER CHARACTER VARYING(20) 20
25 PO_CONTRACT_NUMBER CHARACTER VARYING(150) 150
26 PO_CONTRACT CHARACTER VARYING(14) 14
27 VENDOR_NAME CHARACTER VARYING(273) 273
28 SMID CHARACTER VARYING(150) 150
29 INVOICE_NUM CHARACTER VARYING(50) 50
30 INVOICE_DESCRIPTION CHARACTER VARYING(240) 240
31 PAYMENT_METHOD_CODE CHARACTER VARYING(30) 30
32 INVOICE_DATE TIMESTAMP 8
33 CANCELLED_DATE TIMESTAMP 8
34 CREATED_BY_ID CHARACTER VARYING(100) 100
35 APPROVER_ID CHARACTER VARYING(150) 150
36 INVOICE_SOURCE_RAW CHARACTER VARYING(25) 25
37 CLOSED_DATE_PERIOD TIMESTAMP 8
38 CREATION_DATE_PERIOD TIMESTAMP 8
39 SUBMIT_DATE_PERIOD TIMESTAMP 8
40 APPROVED_FLAG CHARACTER VARYING(1) 1
41 APPROVED_DATE TIMESTAMP 8
42 BRAND CHARACTER VARYING(150) 150
43 PAYMENT_NUMBER BIGINT 8
44 ACC_LEVEL_01_CODE CHARACTER VARYING(150) 150
45 ACC_LEVEL_01_NAME CHARACTER VARYING(240) 240
46 ACC_LEVEL_02_CODE CHARACTER VARYING(150) 150
47 ACC_LEVEL_02_NAME CHARACTER VARYING(391) 391
48 ACC_LEVEL_03_CODE CHARACTER VARYING(150) 150
49 ACC_LEVEL_03_NAME CHARACTER VARYING(391) 391
50 ACC_LEVEL_04_CODE CHARACTER VARYING(150) 150
51 ACC_LEVEL_04_NAME CHARACTER VARYING(391) 391
52 ACC_LEVEL_05_CODE CHARACTER VARYING(150) 150
53 ACC_LEVEL_05_NAME CHARACTER VARYING(391) 391
54 ACC_LEVEL_06_CODE CHARACTER VARYING(150) 150
55 ACC_LEVEL_06_NAME CHARACTER VARYING(391) 391
56 ACC_LEVEL_07_CODE CHARACTER VARYING(150) 150
57 ACC_LEVEL_07_NAME CHARACTER VARYING(391) 391
58 ACC_LEVEL_08_CODE CHARACTER VARYING(150) 150
59 ACC_LEVEL_08_NAME CHARACTER VARYING(391) 391
60 ACC_LEVEL_09_CODE CHARACTER VARYING(150) 150
61 ACC_LEVEL_09_NAME CHARACTER VARYING(391) 391
62 ACC_LEVEL_10_CODE CHARACTER VARYING(150) 150
63 ACC_LEVEL_10_NAME CHARACTER VARYING(391) 391
64 LEVEL_01_CODE CHARACTER VARYING(150) 150
65 LEVEL_01_NAME CHARACTER VARYING(240) 240
66 LEVEL_02_CODE CHARACTER VARYING(150) 150
67 LEVEL_02_NAME CHARACTER VARYING(391) 391
68 LEVEL_03_CODE CHARACTER VARYING(150) 150
69 LEVEL_03_NAME CHARACTER VARYING(391) 391
70 LEVEL_04_CODE CHARACTER VARYING(150) 150
71 LEVEL_04_NAME CHARACTER VARYING(391) 391
72 LEVEL_05_CODE CHARACTER VARYING(150) 150
73 LEVEL_05_NAME CHARACTER VARYING(391) 391
74 LEVEL_06_CODE CHARACTER VARYING(150) 150
75 LEVEL_06_NAME CHARACTER VARYING(391) 391
76 LEVEL_07_CODE CHARACTER VARYING(150) 150
77 LEVEL_07_NAME CHARACTER VARYING(391) 391
78 LEVEL_08_CODE CHARACTER VARYING(150) 150
79 LEVEL_08_NAME CHARACTER VARYING(391) 391
80 LEVEL_09_CODE CHARACTER VARYING(150) 150
81 LEVEL_09_NAME CHARACTER VARYING(391) 391
82 LEVEL_10_CODE CHARACTER VARYING(150) 150
83 LEVEL_10_NAME CHARACTER VARYING(391) 391
84 LOB CHARACTER VARYING(19) 19