SDW_TSDWM_AR_SHDW

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..ATOCRS_SDW_TSDWM_AR_SHDW

SDSNZP02_BANK..UBAR_SDW_TSDWM_AR_SHDW

SDSNZP05_BANK..CBP_SDW_TSDWM_AR_SHDW

Columns
# Name Data Type Length
1 AR_ID BIGINT 8
2 SHDW_RCRD_TP_ID BIGINT 8
3 SHDW_DT TIMESTAMP 8
4 AR_TP_ID BIGINT 8
5 SRC_STM_ID BIGINT 8
6 SRC_CO_CODE CHARACTER VARYING(6) 6
7 SRC_PD_TP_CODE CHARACTER VARYING(6) 6
8 SRC_AC_NBR_CODE CHARACTER VARYING(20) 20
9 LOAD_ST_F CHARACTER VARYING(1) 1
10 ISRT_RUN_AUDT_ID BIGINT 8
11 UDT_RUN_AUDT_ID BIGINT 8
12 UNQ_ID_SRC_STM CHARACTER VARYING(256) 256
13 PRN_AR_ID BIGINT 8
14 AR_STC_TP_ID BIGINT 8
15 OPN_DT TIMESTAMP 8
16 CLS_DT TIMESTAMP 8
17 SRC_PD_CODE CHARACTER VARYING(6) 6
18 AR_LCS_TP_ID BIGINT 8
19 PRIM_CNTPR_IP_ID BIGINT 8
20 NBR_CST BIGINT 8
21 NBR_SGN BIGINT 8
22 EST_CLS_DT TIMESTAMP 8
23 AR_NM CHARACTER VARYING(32) 32
24 TERM BIGINT 8
25 TERM_UOM_ID BIGINT 8
26 IDY_CL_ID BIGINT 8
27 PD_ID BIGINT 8
28 GL_COSTCNTR_KEY_ID BIGINT 8
29 SALE_OFCR_CODE CHARACTER VARYING(12) 12
30 SOLD_AR_F CHARACTER VARYING(1) 1
31 AR_WRTOF_RSN_TP_ID BIGINT 8
32 AR_CLS_RSN_TP_ID BIGINT 8
33 CRN_BAL_TLRN_AMT NUMERIC(14,2) 19
34 CLRD_BAL_TLRN_AMT NUMERIC(14,2) 19
35 MGN_OU_IP_ID BIGINT 8
36 SALE_OU_IP_ID BIGINT 8
37 ORIG_OU_IP_ID BIGINT 8
38 AR_CSZ_TP_ID BIGINT 8
39 RNEW_CNT BIGINT 8
40 SCDY_OFCR_IP_ID BIGINT 8
41 BKR_IP_ID BIGINT 8
42 ACRTD_BKR_IP_ID BIGINT 8
43 APRV_OFCR_IP_ID BIGINT 8
44 DB_INT_CYC_TP_ID BIGINT 8
45 CR_INT_CYC_TP_ID BIGINT 8
46 AR_ST_TP_ID BIGINT 8
47 AR_BLC_TP_ID BIGINT 8
48 AR_BLC_TP_DT TIMESTAMP 8
49 AR_RCLSS_TP_ID BIGINT 8
50 USG_TP_ID BIGINT 8
51 MKT_CMPN_TP_ID BIGINT 8
52 CRT_DT TIMESTAMP 8
53 BAL_BFR_CLS NUMERIC(14,2) 19
54 ORIG_TERM BIGINT 8
55 ORIG_TERM_UOM_ID BIGINT 8
56 AFFLN_TP_ID BIGINT 8
57 SVC_WV_TP_ID BIGINT 8
58 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
59 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
60 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
61 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8