OEB_AP_INVOICE_PAYMENTS_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNTING_DATE TIMESTAMP 8
2 ACCRUAL_POSTED_FLAG CHARACTER VARYING(1) 1
3 AMOUNT NUMERIC(18,2) 19
4 CASH_POSTED_FLAG CHARACTER VARYING(1) 1
5 CHECK_ID BIGINT 8
6 INVOICE_ID BIGINT 8
7 INVOICE_PAYMENT_ID BIGINT 8
8 LAST_UPDATED_BY BIGINT 8
9 LAST_UPDATE_DATE TIMESTAMP 8
10 PAYMENT_NUM BIGINT 8
11 PERIOD_NAME CHARACTER VARYING(15) 15
12 POSTED_FLAG CHARACTER VARYING(1) 1
13 SET_OF_BOOKS_ID BIGINT 8
14 ACCTS_PAY_CODE_COMBINATION_ID BIGINT 8
15 ASSET_CODE_COMBINATION_ID BIGINT 8
16 CREATED_BY BIGINT 8
17 CREATION_DATE TIMESTAMP 8
18 LAST_UPDATE_LOGIN BIGINT 8
19 BANK_ACCOUNT_NUM CHARACTER VARYING(30) 30
20 BANK_ACCOUNT_TYPE CHARACTER VARYING(25) 25
21 BANK_NUM CHARACTER VARYING(25) 25
22 DISCOUNT_LOST NUMERIC(18,2) 19
23 DISCOUNT_TAKEN NUMERIC(18,2) 19
24 EXCHANGE_DATE TIMESTAMP 8
25 EXCHANGE_RATE NUMERIC(18,2) 19
26 EXCHANGE_RATE_TYPE CHARACTER VARYING(30) 30
27 GAIN_CODE_COMBINATION_ID BIGINT 8
28 INVOICE_BASE_AMOUNT NUMERIC(18,2) 19
29 LOSS_CODE_COMBINATION_ID BIGINT 8
30 PAYMENT_BASE_AMOUNT NUMERIC(18,2) 19
31 ATTRIBUTE1 CHARACTER VARYING(150) 150
32 ATTRIBUTE10 CHARACTER VARYING(150) 150
33 ATTRIBUTE11 CHARACTER VARYING(150) 150
34 ATTRIBUTE12 CHARACTER VARYING(150) 150
35 ATTRIBUTE13 CHARACTER VARYING(150) 150
36 ATTRIBUTE14 CHARACTER VARYING(150) 150
37 ATTRIBUTE15 CHARACTER VARYING(150) 150
38 ATTRIBUTE2 CHARACTER VARYING(150) 150
39 ATTRIBUTE3 CHARACTER VARYING(150) 150
40 ATTRIBUTE4 CHARACTER VARYING(150) 150
41 ATTRIBUTE5 CHARACTER VARYING(150) 150
42 ATTRIBUTE6 CHARACTER VARYING(150) 150
43 ATTRIBUTE7 CHARACTER VARYING(150) 150
44 ATTRIBUTE8 CHARACTER VARYING(150) 150
45 ATTRIBUTE9 CHARACTER VARYING(150) 150
46 ATTRIBUTE_CATEGORY CHARACTER VARYING(150) 150
47 CASH_JE_BATCH_ID BIGINT 8
48 FUTURE_PAY_CODE_COMBINATION_ID BIGINT 8
49 FUTURE_PAY_POSTED_FLAG CHARACTER VARYING(1) 1
50 JE_BATCH_ID BIGINT 8
51 ELECTRONIC_TRANSFER_ID BIGINT 8
52 ASSETS_ADDITION_FLAG CHARACTER VARYING(1) 1
53 INVOICE_PAYMENT_TYPE CHARACTER VARYING(25) 25
54 OTHER_INVOICE_ID BIGINT 8
55 ORG_ID BIGINT 8
56 GLOBAL_ATTRIBUTE_CATEGORY CHARACTER VARYING(150) 150
57 GLOBAL_ATTRIBUTE1 CHARACTER VARYING(150) 150
58 GLOBAL_ATTRIBUTE2 CHARACTER VARYING(150) 150
59 GLOBAL_ATTRIBUTE3 CHARACTER VARYING(150) 150
60 GLOBAL_ATTRIBUTE4 CHARACTER VARYING(150) 150
61 GLOBAL_ATTRIBUTE5 CHARACTER VARYING(150) 150
62 GLOBAL_ATTRIBUTE6 CHARACTER VARYING(150) 150
63 GLOBAL_ATTRIBUTE7 CHARACTER VARYING(150) 150
64 GLOBAL_ATTRIBUTE8 CHARACTER VARYING(150) 150
65 GLOBAL_ATTRIBUTE9 CHARACTER VARYING(150) 150
66 GLOBAL_ATTRIBUTE10 CHARACTER VARYING(150) 150
67 GLOBAL_ATTRIBUTE11 CHARACTER VARYING(150) 150
68 GLOBAL_ATTRIBUTE12 CHARACTER VARYING(150) 150
69 GLOBAL_ATTRIBUTE13 CHARACTER VARYING(150) 150
70 GLOBAL_ATTRIBUTE14 CHARACTER VARYING(150) 150
71 GLOBAL_ATTRIBUTE15 CHARACTER VARYING(150) 150
72 GLOBAL_ATTRIBUTE16 CHARACTER VARYING(150) 150
73 GLOBAL_ATTRIBUTE17 CHARACTER VARYING(150) 150
74 GLOBAL_ATTRIBUTE18 CHARACTER VARYING(150) 150
75 GLOBAL_ATTRIBUTE19 CHARACTER VARYING(150) 150
76 GLOBAL_ATTRIBUTE20 CHARACTER VARYING(150) 150
77 EXTERNAL_BANK_ACCOUNT_ID BIGINT 8
78 MRC_ACCRUAL_POSTED_FLAG CHARACTER VARYING(2000) 2000
79 MRC_CASH_POSTED_FLAG CHARACTER VARYING(2000) 2000
80 MRC_POSTED_FLAG CHARACTER VARYING(2000) 2000
81 MRC_EXCHANGE_DATE CHARACTER VARYING(2000) 2000
82 MRC_EXCHANGE_RATE CHARACTER VARYING(2000) 2000
83 MRC_EXCHANGE_RATE_TYPE CHARACTER VARYING(2000) 2000
84 MRC_GAIN_CODE_COMBINATION_ID CHARACTER VARYING(2000) 2000
85 MRC_INVOICE_BASE_AMOUNT CHARACTER VARYING(2000) 2000
86 MRC_LOSS_CODE_COMBINATION_ID CHARACTER VARYING(2000) 2000
87 MRC_PAYMENT_BASE_AMOUNT CHARACTER VARYING(2000) 2000
88 MRC_CASH_JE_BATCH_ID CHARACTER VARYING(2000) 2000
89 MRC_FUTURE_PAY_POSTED_FLAG CHARACTER VARYING(2000) 2000
90 MRC_JE_BATCH_ID CHARACTER VARYING(2000) 2000
91 ACCOUNTING_EVENT_ID BIGINT 8
92 REVERSAL_FLAG CHARACTER VARYING(1) 1
93 REVERSAL_INV_PMT_ID BIGINT 8
94 IBAN_NUMBER CHARACTER VARYING(40) 40
95 INVOICING_PARTY_ID BIGINT 8
96 INVOICING_PARTY_SITE_ID BIGINT 8
97 INVOICING_VENDOR_SITE_ID BIGINT 8
98 REMIT_TO_SUPPLIER_NAME CHARACTER VARYING(240) 240
99 REMIT_TO_SUPPLIER_ID BIGINT 8
100 REMIT_TO_SUPPLIER_SITE CHARACTER VARYING(240) 240
101 REMIT_TO_SUPPLIER_SITE_ID BIGINT 8
102 CDC_SOURCE_SYSTEM_CODE CHARACTER(4) 4
103 CDC_RECORD_TYPE CHARACTER(16) 16
104 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
105 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8