schema.sql
7.46 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
CREATE TABLE IF NOT EXISTS batch_tbcr_inner_delng
(
sys_se character varying(10) NOT NULL,
accnut_ym character varying(6) NOT NULL,
sn bigint NOT NULL DEFAULT 0,
dta_ty character varying(3),
cpr_code character varying(10),
partn_cpr character varying(10),
cpr_acnt_code character varying(20),
cnnc_acnt_code character varying(20),
cnnc_acnt_nm character varying(100),
delng_de character varying(8),
elcty_de character varying(8),
chit_no character varying(100),
cmpnsp_ky character varying(100),
ext_key1 character varying(100),
ext_key2 character varying(100),
ext_key3 character varying(100),
ext_key4 character varying(100),
ext_key5 character varying(100),
delng_crncy character varying(3),
delng_amt numeric(19,2) DEFAULT 0,
acntbk_amt numeric(19,2) DEFAULT 0,
group_amt numeric(19,2) DEFAULT 0,
suply_amount numeric(19,2) DEFAULT 0,
sumry character varying(500),
org_mtch_ty character varying(10),
org_mtch_ky numeric(10,0),
new_mtch_ty character varying(10),
new_mtch_ky numeric(10,0),
compare_ky character varying(100),
mtch_sys character varying(10),
mtch_ty character varying(10),
mtch_ty_nm character varying(100),
mtch_ky bigint DEFAULT 0,
CONSTRAINT batch_tbcr_inner_delng_pkey PRIMARY KEY (sys_se, accnut_ym, sn)
);
COMMENT ON TABLE batch_tbcr_inner_delng
IS '내부거래대사자료';
COMMENT ON COLUMN batch_tbcr_inner_delng.sys_se
IS '시스템구분';
COMMENT ON COLUMN batch_tbcr_inner_delng.accnut_ym
IS '회계연월';
COMMENT ON COLUMN batch_tbcr_inner_delng.sn
IS '순번';
COMMENT ON COLUMN batch_tbcr_inner_delng.dta_ty
IS '거래유형';
COMMENT ON COLUMN batch_tbcr_inner_delng.cpr_code
IS '자기법인';
COMMENT ON COLUMN batch_tbcr_inner_delng.partn_cpr
IS '상대법인';
COMMENT ON COLUMN batch_tbcr_inner_delng.cpr_acnt_code
IS '법인계정코드';
COMMENT ON COLUMN batch_tbcr_inner_delng.cnnc_acnt_code
IS '연결계정코드';
COMMENT ON COLUMN batch_tbcr_inner_delng.cnnc_acnt_nm
IS '연결계정명';
COMMENT ON COLUMN batch_tbcr_inner_delng.delng_de
IS '거래일자';
COMMENT ON COLUMN batch_tbcr_inner_delng.elcty_de
IS '전기일자';
COMMENT ON COLUMN batch_tbcr_inner_delng.chit_no
IS '법인전표번호';
COMMENT ON COLUMN batch_tbcr_inner_delng.cmpnsp_ky
IS '대사 Key';
COMMENT ON COLUMN batch_tbcr_inner_delng.ext_key1
IS '합산Key';
COMMENT ON COLUMN batch_tbcr_inner_delng.ext_key2
IS 'INVOICE번호';
COMMENT ON COLUMN batch_tbcr_inner_delng.ext_key3
IS 'LC번호';
COMMENT ON COLUMN batch_tbcr_inner_delng.ext_key4
IS 'BL번호';
COMMENT ON COLUMN batch_tbcr_inner_delng.ext_key5
IS '기타Key5';
COMMENT ON COLUMN batch_tbcr_inner_delng.delng_crncy
IS '거래통화';
COMMENT ON COLUMN batch_tbcr_inner_delng.delng_amt
IS '거래통화금액';
COMMENT ON COLUMN batch_tbcr_inner_delng.acntbk_amt
IS '장부통화금액';
COMMENT ON COLUMN batch_tbcr_inner_delng.group_amt
IS '그룹통화금액';
COMMENT ON COLUMN batch_tbcr_inner_delng.suply_amount
IS '공급가액';
COMMENT ON COLUMN batch_tbcr_inner_delng.sumry
IS '적요';
COMMENT ON COLUMN batch_tbcr_inner_delng.org_mtch_ty
IS 'Org.일치유형';
COMMENT ON COLUMN batch_tbcr_inner_delng.org_mtch_ky
IS 'Org.일치KEY';
COMMENT ON COLUMN batch_tbcr_inner_delng.new_mtch_ty
IS 'New.일치유형';
COMMENT ON COLUMN batch_tbcr_inner_delng.new_mtch_ky
IS 'New.일치KEY';
COMMENT ON COLUMN batch_tbcr_inner_delng.compare_ky
IS '비교키(시스템)';
COMMENT ON COLUMN batch_tbcr_inner_delng.mtch_sys
IS '일치시스템';
COMMENT ON COLUMN batch_tbcr_inner_delng.mtch_ty
IS '일치유형';
COMMENT ON COLUMN batch_tbcr_inner_delng.mtch_ty_nm
IS '일치유형명칭';
COMMENT ON COLUMN batch_tbcr_inner_delng.mtch_ky
IS '일치KEY';
CREATE INDEX IF NOT EXISTS batch_tbcr_inner_delng_idx1
ON batch_tbcr_inner_delng USING btree
(sys_se ASC NULLS LAST, accnut_ym ASC NULLS LAST, cpr_code ASC NULLS LAST, dta_ty ASC NULLS LAST, partn_cpr ASC NULLS LAST);
CREATE INDEX IF NOT EXISTS batch_tbcr_inner_delng_idx2
ON batch_tbcr_inner_delng USING btree
(sys_se ASC NULLS LAST, accnut_ym ASC NULLS LAST, cpr_code ASC NULLS LAST, partn_cpr ASC NULLS LAST, compare_ky ASC NULLS LAST);
CREATE TABLE IF NOT EXISTS tbcr_transaction_history
(
session_id character varying(5) NOT NULL,
cons_group character varying(10) NOT NULL,
ledger character varying(3) NOT NULL,
account_period character varying(6) NOT NULL,
seq numeric NOT NULL,
tran_type character varying(3),
own_comp character varying(10),
tran_comp character varying(10),
comp_acct_code character varying(20),
comp_prod_code character varying(20),
recon_key character varying(100),
tran_date character varying(8),
tran_currency character varying(3),
tran_amt numeric(17,2) DEFAULT 0,
book_amt numeric(17,2) DEFAULT 0,
group_amt numeric(17,2) DEFAULT 0,
book_cost numeric(17,2) DEFAULT 0,
document_no character varying(50),
remark character varying(500),
cons_acct_code character varying(10),
cons_acct_name character varying(100),
prod_code character varying(10),
adjust_type character varying(3),
adjust_remark character varying(255),
if_account_period character varying(6),
if_comp_code character varying(10),
if_file_id character varying(3),
if_source character varying(3),
equal_check character varying(3),
cons_own_comp character varying(10),
cons_tran_comp character varying(10),
invoice_no character varying(80),
lc_no character varying(80),
bl_no character varying(80),
own_biz_no character varying(20),
partner_biz_no character varying(20),
acct_date character varying(8),
matching_cause character varying(10),
match_key numeric(10,0),
CONSTRAINT tbcr_transaction_history_ky PRIMARY KEY (session_id, cons_group, ledger, account_period, seq)
);
CREATE TABLE IF NOT EXISTS batch_tbcr_inner_delng_ai
(
sys_se character varying(10) NOT NULL,
accnut_ym character varying(6) NOT NULL,
sn bigint NOT NULL DEFAULT 0,
ai_key1 character varying(100) ,
ai_key2 character varying(100) ,
ai_key3 character varying(100) ,
ai_key4 character varying(100) ,
ai_key5 character varying(100) ,
ai_key6 character varying(100) ,
ai_key7 character varying(100) ,
ai_key8 character varying(100) ,
ai_key9 character varying(100) ,
ai_key10 character varying(100) ,
CONSTRAINT batch_tbcr_inner_delng_aikey PRIMARY KEY (sys_se, accnut_ym, sn)
);
CREATE TABLE IF NOT EXISTS batch_user_job_status
(
user_job_id character varying(128) COLLATE pg_catalog."default" NOT NULL,
user_job_name character varying(200) COLLATE pg_catalog."default",
start_time timestamp with time zone,
end_time timestamp with time zone,
status character varying(50) COLLATE pg_catalog."default",
exit_code character varying(10) COLLATE pg_catalog."default",
exit_message character varying(2000) COLLATE pg_catalog."default",
CONSTRAINT batch_user_job_status_pkey PRIMARY KEY (user_job_id)
USING INDEX TABLESPACE account
);
COMMENT ON TABLE batch_user_job_status
IS 'User Job Status';