OEB_AP_CHECKS_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 AMOUNT NUMERIC(18,2) 19
2 BANK_ACCOUNT_ID BIGINT 8
3 BANK_ACCOUNT_NAME CHARACTER VARYING(80) 80
4 CHECK_DATE TIMESTAMP 8
5 CHECK_ID BIGINT 8
6 CHECK_NUMBER BIGINT 8
7 CURRENCY_CODE CHARACTER VARYING(15) 15
8 LAST_UPDATED_BY BIGINT 8
9 LAST_UPDATE_DATE TIMESTAMP 8
10 PAYMENT_METHOD_LOOKUP_CODE CHARACTER VARYING(25) 25
11 PAYMENT_TYPE_FLAG CHARACTER VARYING(25) 25
12 ADDRESS_LINE1 CHARACTER VARYING(240) 240
13 ADDRESS_LINE2 CHARACTER VARYING(240) 240
14 ADDRESS_LINE3 CHARACTER VARYING(240) 240
15 CHECKRUN_NAME CHARACTER VARYING(255) 255
16 CHECK_FORMAT_ID BIGINT 8
17 CHECK_STOCK_ID BIGINT 8
18 CITY CHARACTER VARYING(60) 60
19 COUNTRY CHARACTER VARYING(60) 60
20 CREATED_BY BIGINT 8
21 CREATION_DATE TIMESTAMP 8
22 LAST_UPDATE_LOGIN BIGINT 8
23 STATUS_LOOKUP_CODE CHARACTER VARYING(25) 25
24 VENDOR_NAME CHARACTER VARYING(240) 240
25 VENDOR_SITE_CODE CHARACTER VARYING(15) 15
26 ZIP CHARACTER VARYING(60) 60
27 BANK_ACCOUNT_NUM CHARACTER VARYING(30) 30
28 BANK_ACCOUNT_TYPE CHARACTER VARYING(25) 25
29 BANK_NUM CHARACTER VARYING(30) 30
30 CHECK_VOUCHER_NUM BIGINT 8
31 CLEARED_AMOUNT NUMERIC(18,2) 19
32 CLEARED_DATE TIMESTAMP 8
33 DOC_CATEGORY_CODE CHARACTER VARYING(30) 30
34 DOC_SEQUENCE_ID BIGINT 8
35 DOC_SEQUENCE_VALUE BIGINT 8
36 PROVINCE CHARACTER VARYING(150) 150
37 RELEASED_AT CHARACTER VARYING(18) 18
38 RELEASED_BY BIGINT 8
39 STATE CHARACTER VARYING(150) 150
40 STOPPED_AT CHARACTER VARYING(18) 18
41 STOPPED_BY BIGINT 8
42 VOID_DATE TIMESTAMP 8
43 ATTRIBUTE1 CHARACTER VARYING(150) 150
44 ATTRIBUTE10 CHARACTER VARYING(150) 150
45 ATTRIBUTE11 CHARACTER VARYING(150) 150
46 ATTRIBUTE12 CHARACTER VARYING(150) 150
47 ATTRIBUTE13 CHARACTER VARYING(150) 150
48 ATTRIBUTE14 CHARACTER VARYING(150) 150
49 ATTRIBUTE15 CHARACTER VARYING(150) 150
50 ATTRIBUTE2 CHARACTER VARYING(150) 150
51 ATTRIBUTE3 CHARACTER VARYING(150) 150
52 ATTRIBUTE4 CHARACTER VARYING(150) 150
53 ATTRIBUTE5 CHARACTER VARYING(150) 150
54 ATTRIBUTE6 CHARACTER VARYING(150) 150
55 ATTRIBUTE7 CHARACTER VARYING(150) 150
56 ATTRIBUTE8 CHARACTER VARYING(150) 150
57 ATTRIBUTE9 CHARACTER VARYING(150) 150
58 ATTRIBUTE_CATEGORY CHARACTER VARYING(150) 150
59 FUTURE_PAY_DUE_DATE TIMESTAMP 8
60 TREASURY_PAY_DATE TIMESTAMP 8
61 TREASURY_PAY_NUMBER BIGINT 8
62 USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
63 USSGL_TRX_CODE_CONTEXT CHARACTER VARYING(30) 30
64 WITHHOLDING_STATUS_LOOKUP_CODE CHARACTER VARYING(25) 25
65 RECONCILIATION_BATCH_ID BIGINT 8
66 CLEARED_BASE_AMOUNT NUMERIC(18,2) 19
67 CLEARED_EXCHANGE_RATE NUMERIC(18,2) 19
68 CLEARED_EXCHANGE_DATE TIMESTAMP 8
69 CLEARED_EXCHANGE_RATE_TYPE CHARACTER VARYING(30) 30
70 ADDRESS_LINE4 CHARACTER VARYING(240) 240
71 COUNTY CHARACTER VARYING(150) 150
72 ADDRESS_STYLE CHARACTER VARYING(30) 30
73 ORG_ID BIGINT 8
74 VENDOR_ID BIGINT 8
75 VENDOR_SITE_ID BIGINT 8
76 EXCHANGE_RATE NUMERIC(18,2) 19
77 EXCHANGE_DATE TIMESTAMP 8
78 EXCHANGE_RATE_TYPE CHARACTER VARYING(30) 30
79 BASE_AMOUNT NUMERIC(18,2) 19
80 CHECKRUN_ID BIGINT 8
81 REQUEST_ID BIGINT 8
82 CLEARED_ERROR_AMOUNT NUMERIC(18,2) 19
83 CLEARED_CHARGES_AMOUNT NUMERIC(18,2) 19
84 CLEARED_ERROR_BASE_AMOUNT NUMERIC(18,2) 19
85 CLEARED_CHARGES_BASE_AMOUNT NUMERIC(18,2) 19
86 POSITIVE_PAY_STATUS_CODE CHARACTER VARYING(25) 25
87 GLOBAL_ATTRIBUTE_CATEGORY CHARACTER VARYING(150) 150
88 GLOBAL_ATTRIBUTE1 CHARACTER VARYING(150) 150
89 GLOBAL_ATTRIBUTE2 CHARACTER VARYING(150) 150
90 GLOBAL_ATTRIBUTE3 CHARACTER VARYING(150) 150
91 GLOBAL_ATTRIBUTE4 CHARACTER VARYING(150) 150
92 GLOBAL_ATTRIBUTE5 CHARACTER VARYING(150) 150
93 GLOBAL_ATTRIBUTE6 CHARACTER VARYING(150) 150
94 GLOBAL_ATTRIBUTE7 CHARACTER VARYING(150) 150
95 GLOBAL_ATTRIBUTE8 CHARACTER VARYING(150) 150
96 GLOBAL_ATTRIBUTE9 CHARACTER VARYING(150) 150
97 GLOBAL_ATTRIBUTE10 CHARACTER VARYING(150) 150
98 GLOBAL_ATTRIBUTE11 CHARACTER VARYING(150) 150
99 GLOBAL_ATTRIBUTE12 CHARACTER VARYING(150) 150
100 GLOBAL_ATTRIBUTE13 CHARACTER VARYING(150) 150
101 GLOBAL_ATTRIBUTE14 CHARACTER VARYING(150) 150
102 GLOBAL_ATTRIBUTE15 CHARACTER VARYING(150) 150
103 GLOBAL_ATTRIBUTE16 CHARACTER VARYING(150) 150
104 GLOBAL_ATTRIBUTE17 CHARACTER VARYING(150) 150
105 GLOBAL_ATTRIBUTE18 CHARACTER VARYING(150) 150
106 GLOBAL_ATTRIBUTE19 CHARACTER VARYING(150) 150
107 GLOBAL_ATTRIBUTE20 CHARACTER VARYING(150) 150
108 TRANSFER_PRIORITY CHARACTER VARYING(25) 25
109 EXTERNAL_BANK_ACCOUNT_ID BIGINT 8
110 STAMP_DUTY_AMT NUMERIC(18,2) 19
111 STAMP_DUTY_BASE_AMT NUMERIC(18,2) 19
112 MRC_CLEARED_BASE_AMOUNT CHARACTER VARYING(2000) 2000
113 MRC_CLEARED_EXCHANGE_RATE CHARACTER VARYING(2000) 2000
114 MRC_CLEARED_EXCHANGE_DATE CHARACTER VARYING(2000) 2000
115 MRC_CLEARED_EXCHANGE_RATE_TYPE CHARACTER VARYING(2000) 2000
116 MRC_EXCHANGE_RATE CHARACTER VARYING(2000) 2000
117 MRC_EXCHANGE_DATE CHARACTER VARYING(2000) 2000
118 MRC_EXCHANGE_RATE_TYPE CHARACTER VARYING(2000) 2000
119 MRC_BASE_AMOUNT CHARACTER VARYING(2000) 2000
120 MRC_CLEARED_ERROR_BASE_AMOUNT CHARACTER VARYING(2000) 2000
121 MRC_CLEARED_CHARGES_BASE_AMT CHARACTER VARYING(2000) 2000
122 MRC_STAMP_DUTY_BASE_AMT CHARACTER VARYING(2000) 2000
123 MATURITY_EXCHANGE_DATE TIMESTAMP 8
124 MATURITY_EXCHANGE_RATE_TYPE CHARACTER VARYING(30) 30
125 MATURITY_EXCHANGE_RATE NUMERIC(18,2) 19
126 DESCRIPTION CHARACTER VARYING(240) 240
127 ACTUAL_VALUE_DATE TIMESTAMP 8
128 ANTICIPATED_VALUE_DATE TIMESTAMP 8
129 RELEASED_DATE TIMESTAMP 8
130 STOPPED_DATE TIMESTAMP 8
131 MRC_MATURITY_EXG_DATE CHARACTER VARYING(2000) 2000
132 MRC_MATURITY_EXG_RATE CHARACTER VARYING(2000) 2000
133 MRC_MATURITY_EXG_RATE_TYPE CHARACTER VARYING(2000) 2000
134 IBAN_NUMBER CHARACTER VARYING(40) 40
135 VOID_CHECK_ID BIGINT 8
136 VOID_CHECK_NUMBER BIGINT 8
137 CE_BANK_ACCT_USE_ID BIGINT 8
138 PAYMENT_METHOD_CODE CHARACTER VARYING(30) 30
139 PARTY_ID BIGINT 8
140 PARTY_SITE_ID BIGINT 8
141 PAYMENT_PROFILE_ID BIGINT 8
142 SETTLEMENT_PRIORITY CHARACTER VARYING(30) 30
143 BANK_CHARGE_BEARER CHARACTER VARYING(30) 30
144 LEGAL_ENTITY_ID BIGINT 8
145 PAYMENT_DOCUMENT_ID BIGINT 8
146 COMPLETED_PMTS_GROUP_ID BIGINT 8
147 PAYMENT_ID BIGINT 8
148 PAYMENT_INSTRUCTION_ID BIGINT 8
149 REMIT_TO_SUPPLIER_NAME CHARACTER VARYING(240) 240
150 REMIT_TO_SUPPLIER_ID BIGINT 8
151 REMIT_TO_SUPPLIER_SITE CHARACTER VARYING(240) 240
152 REMIT_TO_SUPPLIER_SITE_ID BIGINT 8
153 RELATIONSHIP_ID BIGINT 8
154 PAYCARD_AUTHORIZATION_NUMBER CHARACTER VARYING(30) 30
155 PAYCARD_REFERENCE_ID BIGINT 8
156 ACKNOWLEDGED_FLAG CHARACTER VARYING(1) 1
157 CDC_SOURCE_SYSTEM_CODE CHARACTER(4) 4
158 CDC_RECORD_TYPE CHARACTER(16) 16
159 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
160 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8