DETAIL_VIEW_ADDRESS : VIEW

#Column NameMax SizeData Type
1RCPT_NUMBER12CHAR
2REGNUM3VARCHAR
3SEQUENCE_NUMBERSMALLINT
4USER_ID10CHAR
5ACCOUNTING_DATEDATETIME
6RCPT_DATE_TIMEDATETIME
7RCPT_STATUSSMALLINT
8PAYER_NAME40VARCHAR
9TRAN_SOURCE20VARCHAR
10TRAN_CODE30VARCHAR
11DESCRIPTION50VARCHAR
12EXTENDED_FEE_AMOUNTMONEY
13TRAN_DESCRIPTION40VARCHAR
14SHORT_DESCRIPTION50VARCHAR
15TRAN_TEXT_140VARCHAR
16TRAN_TEXT_240VARCHAR
17TRAN_TEXT_340VARCHAR
18CUST_NAME50VARCHAR
19ADDRESS150VARCHAR
20ADDRESS250VARCHAR
21CITY30VARCHAR
22STATE30VARCHAR
23ZIP30VARCHAR
24PHONE_NUMBER30VARCHAR
25F0150VARCHAR
26F0250VARCHAR
27F0350VARCHAR
28F0450VARCHAR
29F0550VARCHAR
30F0650VARCHAR
31F0750VARCHAR
32F0850VARCHAR
33F0950VARCHAR
34F1050VARCHAR
35F1150VARCHAR
36F1250VARCHAR
37F1350VARCHAR
38F1450VARCHAR
39F1550VARCHAR
40F1650VARCHAR
41F1750VARCHAR
42F1850VARCHAR
43F1950VARCHAR
44F2050VARCHAR
45F2150VARCHAR
46F2250VARCHAR
47F2350VARCHAR
48F2450VARCHAR
49F2550VARCHAR
50F2650VARCHAR
51F2750VARCHAR
52F2850VARCHAR
53F2950VARCHAR
54F3050VARCHAR
55DEPT_CODE15VARCHAR
56LOCATION_NAME50VARCHAR
57LOCATION_CODE3CHAR
58FIELD_TYPES20VARCHAR
59F01_NAME20VARCHAR
60F02_NAME20VARCHAR
61F03_NAME20VARCHAR
62F04_NAME20VARCHAR
63F05_NAME20VARCHAR
64F06_NAME20VARCHAR
65F07_NAME20VARCHAR
66F08_NAME20VARCHAR
67F09_NAME20VARCHAR
68F10_NAME20VARCHAR
69F11_NAME20VARCHAR
70F12_NAME20VARCHAR
71F13_NAME20VARCHAR
72F14_NAME20VARCHAR
73F15_NAME20VARCHAR
74F16_NAME20VARCHAR
75F17_NAME20VARCHAR
76F18_NAME20VARCHAR
77F19_NAME20VARCHAR
78F20_NAME20VARCHAR
79F21_NAME20VARCHAR
80F22_NAME20VARCHAR
81F23_NAME20VARCHAR
82F24_NAME20VARCHAR
83F25_NAME20VARCHAR
84F26_NAME20VARCHAR
85F27_NAME20VARCHAR
86F28_NAME20VARCHAR
87F29_NAME20VARCHAR
88F30_NAME20VARCHAR
89ADDRESS_GROUP_NUMBERSMALLINT



RASWIN Table/View Index




Created:09/22/2020 12:20:24