OEB_AR_CASH_RECEIPTS_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CASH_RECEIPT_ID BIGINT 8
2 LAST_UPDATED_BY BIGINT 8
3 LAST_UPDATE_DATE TIMESTAMP 8
4 LAST_UPDATE_LOGIN BIGINT 8
5 CREATED_BY BIGINT 8
6 CREATION_DATE TIMESTAMP 8
7 AMOUNT NUMERIC(18,2) 19
8 SET_OF_BOOKS_ID BIGINT 8
9 CURRENCY_CODE CHARACTER VARYING(15) 15
10 RECEIVABLES_TRX_ID BIGINT 8
11 PAY_FROM_CUSTOMER BIGINT 8
12 STATUS CHARACTER VARYING(30) 30
13 TYPE CHARACTER VARYING(20) 20
14 RECEIPT_NUMBER CHARACTER VARYING(30) 30
15 RECEIPT_DATE TIMESTAMP 8
16 MISC_PAYMENT_SOURCE CHARACTER VARYING(30) 30
17 COMMENTS CHARACTER VARYING(2000) 2000
18 DISTRIBUTION_SET_ID BIGINT 8
19 REVERSAL_DATE TIMESTAMP 8
20 REVERSAL_CATEGORY CHARACTER VARYING(20) 20
21 REVERSAL_REASON_CODE CHARACTER VARYING(30) 30
22 REVERSAL_COMMENTS CHARACTER VARYING(240) 240
23 EXCHANGE_RATE_TYPE CHARACTER VARYING(30) 30
24 EXCHANGE_RATE NUMERIC(18,2) 19
25 EXCHANGE_DATE TIMESTAMP 8
26 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
27 ATTRIBUTE1 CHARACTER VARYING(150) 150
28 ATTRIBUTE2 CHARACTER VARYING(150) 150
29 ATTRIBUTE3 CHARACTER VARYING(150) 150
30 ATTRIBUTE4 CHARACTER VARYING(150) 150
31 ATTRIBUTE5 CHARACTER VARYING(150) 150
32 ATTRIBUTE6 CHARACTER VARYING(150) 150
33 ATTRIBUTE7 CHARACTER VARYING(150) 150
34 ATTRIBUTE8 CHARACTER VARYING(150) 150
35 ATTRIBUTE9 CHARACTER VARYING(150) 150
36 ATTRIBUTE10 CHARACTER VARYING(150) 150
37 REMITTANCE_BANK_ACCOUNT_ID BIGINT 8
38 ATTRIBUTE11 CHARACTER VARYING(150) 150
39 ATTRIBUTE12 CHARACTER VARYING(150) 150
40 ATTRIBUTE13 CHARACTER VARYING(150) 150
41 ATTRIBUTE14 CHARACTER VARYING(150) 150
42 ATTRIBUTE15 CHARACTER VARYING(150) 150
43 CONFIRMED_FLAG CHARACTER VARYING(1) 1
44 CUSTOMER_BANK_ACCOUNT_ID BIGINT 8
45 CUSTOMER_SITE_USE_ID BIGINT 8
46 DEPOSIT_DATE TIMESTAMP 8
47 PROGRAM_APPLICATION_ID BIGINT 8
48 PROGRAM_ID BIGINT 8
49 PROGRAM_UPDATE_DATE TIMESTAMP 8
50 RECEIPT_METHOD_ID BIGINT 8
51 REQUEST_ID BIGINT 8
52 SELECTED_FOR_FACTORING_FLAG CHARACTER VARYING(1) 1
53 SELECTED_REMITTANCE_BATCH_ID BIGINT 8
54 FACTOR_DISCOUNT_AMOUNT NUMERIC(18,2) 19
55 USSGL_TRANSACTION_CODE CHARACTER VARYING(30) 30
56 USSGL_TRANSACTION_CODE_CONTEXT CHARACTER VARYING(30) 30
57 DOC_SEQUENCE_VALUE BIGINT 8
58 DOC_SEQUENCE_ID BIGINT 8
59 VAT_TAX_ID BIGINT 8
60 REFERENCE_TYPE CHARACTER VARYING(30) 30
61 REFERENCE_ID BIGINT 8
62 CUSTOMER_RECEIPT_REFERENCE CHARACTER VARYING(30) 30
63 OVERRIDE_REMIT_ACCOUNT_FLAG CHARACTER VARYING(1) 1
64 ORG_ID BIGINT 8
65 ANTICIPATED_CLEARING_DATE TIMESTAMP 8
66 GLOBAL_ATTRIBUTE1 CHARACTER VARYING(150) 150
67 GLOBAL_ATTRIBUTE2 CHARACTER VARYING(150) 150
68 GLOBAL_ATTRIBUTE3 CHARACTER VARYING(150) 150
69 GLOBAL_ATTRIBUTE4 CHARACTER VARYING(150) 150
70 GLOBAL_ATTRIBUTE5 CHARACTER VARYING(150) 150
71 GLOBAL_ATTRIBUTE6 CHARACTER VARYING(150) 150
72 GLOBAL_ATTRIBUTE7 CHARACTER VARYING(150) 150
73 GLOBAL_ATTRIBUTE8 CHARACTER VARYING(150) 150
74 GLOBAL_ATTRIBUTE9 CHARACTER VARYING(150) 150
75 GLOBAL_ATTRIBUTE10 CHARACTER VARYING(150) 150
76 GLOBAL_ATTRIBUTE11 CHARACTER VARYING(150) 150
77 GLOBAL_ATTRIBUTE12 CHARACTER VARYING(150) 150
78 GLOBAL_ATTRIBUTE13 CHARACTER VARYING(150) 150
79 GLOBAL_ATTRIBUTE14 CHARACTER VARYING(150) 150
80 GLOBAL_ATTRIBUTE15 CHARACTER VARYING(150) 150
81 GLOBAL_ATTRIBUTE16 CHARACTER VARYING(150) 150
82 GLOBAL_ATTRIBUTE17 CHARACTER VARYING(150) 150
83 GLOBAL_ATTRIBUTE18 CHARACTER VARYING(150) 150
84 GLOBAL_ATTRIBUTE19 CHARACTER VARYING(150) 150
85 GLOBAL_ATTRIBUTE20 CHARACTER VARYING(150) 150
86 GLOBAL_ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
87 ISSUER_NAME CHARACTER VARYING(50) 50
88 ISSUE_DATE TIMESTAMP 8
89 ISSUER_BANK_BRANCH_ID BIGINT 8
90 CUSTOMER_BANK_BRANCH_ID BIGINT 8
91 MRC_EXCHANGE_RATE_TYPE CHARACTER VARYING(2000) 2000
92 MRC_EXCHANGE_RATE CHARACTER VARYING(2000) 2000
93 MRC_EXCHANGE_DATE CHARACTER VARYING(2000) 2000
94 PAYMENT_SERVER_ORDER_NUM CHARACTER VARYING(80) 80
95 APPROVAL_CODE CHARACTER VARYING(80) 80
96 ADDRESS_VERIFICATION_CODE CHARACTER VARYING(80) 80
97 TAX_RATE NUMERIC(18,2) 19
98 ACTUAL_VALUE_DATE TIMESTAMP 8
99 POSTMARK_DATE TIMESTAMP 8
100 APPLICATION_NOTES CHARACTER VARYING(2000) 2000
101 UNIQUE_REFERENCE CHARACTER VARYING(32) 32
102 PROMISE_SOURCE CHARACTER VARYING(30) 30
103 REC_VERSION_NUMBER BIGINT 8
104 CC_ERROR_CODE CHARACTER VARYING(80) 80
105 CC_ERROR_TEXT CHARACTER VARYING(255) 255
106 CC_ERROR_FLAG CHARACTER VARYING(1) 1
107 REMIT_BANK_ACCT_USE_ID BIGINT 8
108 OLD_CUSTOMER_BANK_BRANCH_ID BIGINT 8
109 OLD_ISSUER_BANK_BRANCH_ID BIGINT 8
110 LEGAL_ENTITY_ID BIGINT 8
111 PAYMENT_TRXN_EXTENSION_ID BIGINT 8
112 AX_ACCOUNTED_FLAG CHARACTER VARYING(1) 1
113 OLD_CUSTOMER_BANK_ACCOUNT_ID BIGINT 8
114 CASH_APPLN_OWNER_ID BIGINT 8
115 WORK_ITEM_ASSIGNMENT_DATE TIMESTAMP 8
116 WORK_ITEM_REVIEW_DATE TIMESTAMP 8
117 WORK_ITEM_STATUS_CODE CHARACTER VARYING(30) 30
118 WORK_ITEM_REVIEW_NOTE CHARACTER VARYING(2000) 2000
119 PREV_PAY_FROM_CUSTOMER BIGINT 8
120 PREV_CUSTOMER_SITE_USE_ID BIGINT 8
121 WORK_ITEM_EXCEPTION_REASON CHARACTER VARYING(30) 30
122 AUTOMATCH_SET_ID BIGINT 8
123 AUTOAPPLY_FLAG CHARACTER VARYING(1) 1
124 SEQ_TYPE_LAST CHARACTER VARYING(1) 1
125 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
126 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
127 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
128 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8