OEB_AP_CARDS_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 EMPLOYEE_ID BIGINT 8
2 CARD_ID BIGINT 8
3 LIMIT_OVERRIDE_AMOUNT NUMERIC(18,6) 19
4 TRX_LIMIT_OVERRIDE_AMOUNT NUMERIC(18,6) 19
5 PROFILE_ID BIGINT 8
6 CARDMEMBER_NAME CHARACTER VARYING(80) 80
7 DEPARTMENT_NAME CHARACTER VARYING(80) 80
8 PHYSICAL_CARD_FLAG CHARACTER VARYING(1) 1
9 PAPER_STATEMENT_REQ_FLAG CHARACTER VARYING(1) 1
10 LOCATION_ID BIGINT 8
11 MOTHERS_MAIDEN_NAME CHARACTER VARYING(80) 80
12 DESCRIPTION CHARACTER VARYING(240) 240
13 ORG_ID BIGINT 8
14 INACTIVE_DATE TIMESTAMP 8
15 LAST_UPDATE_DATE TIMESTAMP 8
16 LAST_UPDATED_BY BIGINT 8
17 LAST_UPDATE_LOGIN BIGINT 8
18 CREATION_DATE TIMESTAMP 8
19 CREATED_BY BIGINT 8
20 ATTRIBUTE_CATEGORY CHARACTER VARYING(150) 150
21 ATTRIBUTE1 CHARACTER VARYING(150) 150
22 ATTRIBUTE2 CHARACTER VARYING(150) 150
23 ATTRIBUTE3 CHARACTER VARYING(150) 150
24 ATTRIBUTE4 CHARACTER VARYING(150) 150
25 ATTRIBUTE5 CHARACTER VARYING(150) 150
26 ATTRIBUTE6 CHARACTER VARYING(150) 150
27 ATTRIBUTE7 CHARACTER VARYING(150) 150
28 ATTRIBUTE8 CHARACTER VARYING(150) 150
29 ATTRIBUTE9 CHARACTER VARYING(150) 150
30 ATTRIBUTE10 CHARACTER VARYING(150) 150
31 ATTRIBUTE11 CHARACTER VARYING(150) 150
32 ATTRIBUTE12 CHARACTER VARYING(150) 150
33 ATTRIBUTE13 CHARACTER VARYING(150) 150
34 ATTRIBUTE14 CHARACTER VARYING(150) 150
35 ATTRIBUTE15 CHARACTER VARYING(150) 150
36 ATTRIBUTE16 CHARACTER VARYING(150) 150
37 ATTRIBUTE17 CHARACTER VARYING(150) 150
38 ATTRIBUTE18 CHARACTER VARYING(150) 150
39 ATTRIBUTE19 CHARACTER VARYING(150) 150
40 ATTRIBUTE20 CHARACTER VARYING(150) 150
41 ATTRIBUTE21 CHARACTER VARYING(150) 150
42 ATTRIBUTE22 CHARACTER VARYING(150) 150
43 ATTRIBUTE23 CHARACTER VARYING(150) 150
44 ATTRIBUTE24 CHARACTER VARYING(150) 150
45 ATTRIBUTE25 CHARACTER VARYING(150) 150
46 ATTRIBUTE26 CHARACTER VARYING(150) 150
47 ATTRIBUTE27 CHARACTER VARYING(150) 150
48 ATTRIBUTE28 CHARACTER VARYING(150) 150
49 ATTRIBUTE29 CHARACTER VARYING(150) 150
50 ATTRIBUTE30 CHARACTER VARYING(150) 150
51 CARD_EXPIRATION_DATE TIMESTAMP 8
52 CARD_PROGRAM_ID BIGINT 8
53 REQUEST_ID BIGINT 8
54 CARD_REFERENCE_ID BIGINT 8
55 PAYCARD_REFERENCE_ID BIGINT 8
56 GL_SUB_ACCOUNT CHARACTER VARYING(100) 100
57 COST_CENTER CHARACTER VARYING(100) 100
58 FLEET_SERVICE_FLAG CHARACTER VARYING(1) 1
59 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
60 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
61 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
62 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8