OEB_RA_CUST_TRX_TYPES_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_TRX_TYPE_ID BIGINT 8
2 LAST_UPDATE_DATE TIMESTAMP 8
3 LAST_UPDATED_BY BIGINT 8
4 CREATION_DATE TIMESTAMP 8
5 CREATED_BY BIGINT 8
6 LAST_UPDATE_LOGIN BIGINT 8
7 POST_TO_GL CHARACTER VARYING(1) 1
8 ACCOUNTING_AFFECT_FLAG CHARACTER VARYING(1) 1
9 CREDIT_MEMO_TYPE_ID BIGINT 8
10 STATUS CHARACTER VARYING(30) 30
11 NAME CHARACTER VARYING(20) 20
12 DESCRIPTION CHARACTER VARYING(80) 80
13 TYPE CHARACTER VARYING(20) 20
14 DEFAULT_TERM BIGINT 8
15 DEFAULT_PRINTING_OPTION CHARACTER VARYING(20) 20
16 DEFAULT_STATUS CHARACTER VARYING(30) 30
17 GL_ID_REV BIGINT 8
18 GL_ID_FREIGHT BIGINT 8
19 GL_ID_REC BIGINT 8
20 SUBSEQUENT_TRX_TYPE_ID BIGINT 8
21 SET_OF_BOOKS_ID BIGINT 8
22 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
23 ATTRIBUTE1 CHARACTER VARYING(150) 150
24 ATTRIBUTE2 CHARACTER VARYING(150) 150
25 ATTRIBUTE3 CHARACTER VARYING(150) 150
26 ATTRIBUTE4 CHARACTER VARYING(150) 150
27 ATTRIBUTE5 CHARACTER VARYING(150) 150
28 ATTRIBUTE6 CHARACTER VARYING(150) 150
29 ATTRIBUTE7 CHARACTER VARYING(150) 150
30 ATTRIBUTE8 CHARACTER VARYING(150) 150
31 ATTRIBUTE9 CHARACTER VARYING(150) 150
32 ATTRIBUTE10 CHARACTER VARYING(150) 150
33 ALLOW_FREIGHT_FLAG CHARACTER VARYING(1) 1
34 ALLOW_OVERAPPLICATION_FLAG CHARACTER VARYING(1) 1
35 CREATION_SIGN CHARACTER VARYING(30) 30
36 END_DATE TIMESTAMP 8
37 GL_ID_CLEARING BIGINT 8
38 GL_ID_TAX BIGINT 8
39 GL_ID_UNBILLED BIGINT 8
40 GL_ID_UNEARNED BIGINT 8
41 START_DATE TIMESTAMP 8
42 TAX_CALCULATION_FLAG CHARACTER VARYING(1) 1
43 ATTRIBUTE11 CHARACTER VARYING(150) 150
44 ATTRIBUTE12 CHARACTER VARYING(150) 150
45 ATTRIBUTE13 CHARACTER VARYING(150) 150
46 ATTRIBUTE14 CHARACTER VARYING(150) 150
47 ATTRIBUTE15 CHARACTER VARYING(150) 150
48 NATURAL_APPLICATION_ONLY_FLAG CHARACTER VARYING(1) 1
49 ORG_ID BIGINT 8
50 GLOBAL_ATTRIBUTE1 CHARACTER VARYING(150) 150
51 GLOBAL_ATTRIBUTE2 CHARACTER VARYING(150) 150
52 GLOBAL_ATTRIBUTE3 CHARACTER VARYING(150) 150
53 GLOBAL_ATTRIBUTE4 CHARACTER VARYING(150) 150
54 GLOBAL_ATTRIBUTE5 CHARACTER VARYING(150) 150
55 GLOBAL_ATTRIBUTE6 CHARACTER VARYING(150) 150
56 GLOBAL_ATTRIBUTE7 CHARACTER VARYING(150) 150
57 GLOBAL_ATTRIBUTE8 CHARACTER VARYING(150) 150
58 GLOBAL_ATTRIBUTE9 CHARACTER VARYING(150) 150
59 GLOBAL_ATTRIBUTE10 CHARACTER VARYING(150) 150
60 GLOBAL_ATTRIBUTE11 CHARACTER VARYING(150) 150
61 GLOBAL_ATTRIBUTE12 CHARACTER VARYING(150) 150
62 GLOBAL_ATTRIBUTE13 CHARACTER VARYING(150) 150
63 GLOBAL_ATTRIBUTE14 CHARACTER VARYING(150) 150
64 GLOBAL_ATTRIBUTE15 CHARACTER VARYING(150) 150
65 GLOBAL_ATTRIBUTE16 CHARACTER VARYING(150) 150
66 GLOBAL_ATTRIBUTE17 CHARACTER VARYING(150) 150
67 GLOBAL_ATTRIBUTE18 CHARACTER VARYING(150) 150
68 GLOBAL_ATTRIBUTE19 CHARACTER VARYING(150) 150
69 GLOBAL_ATTRIBUTE20 CHARACTER VARYING(150) 150
70 GLOBAL_ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
71 RULE_SET_ID BIGINT 8
72 SIGNED_FLAG CHARACTER VARYING(1) 1
73 DRAWEE_ISSUED_FLAG CHARACTER VARYING(1) 1
74 MAGNETIC_FORMAT_CODE CHARACTER VARYING(30) 30
75 FORMAT_PROGRAM_ID BIGINT 8
76 GL_ID_UNPAID_REC BIGINT 8
77 GL_ID_REMITTANCE BIGINT 8
78 GL_ID_FACTOR BIGINT 8
79 ALLOCATE_TAX_FREIGHT CHARACTER VARYING(1) 1
80 LEGAL_ENTITY_ID BIGINT 8
81 EXCLUDE_FROM_LATE_CHARGES CHARACTER VARYING(30) 30
82 ADJ_POST_TO_GL CHARACTER VARYING(1) 1
83 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
84 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
85 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
86 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8