DETAIL_DEPTCODE_ADDRESS : VIEW

#Column NameMax SizeData Type
1RCPT_NUMBER12CHAR
2REGNUM3VARCHAR
3USER_ID10CHAR
4ACCOUNTING_DATEDATETIME
5RCPT_DATE_TIMEDATETIME
6CHANGE_DUEMONEY
7RCPT_STATUSSMALLINT
8PAYER_NAME40VARCHAR
9TRAN_SOURCE20VARCHAR
10SEQUENCE_NUMBERSMALLINT
11TRAN_CODE30VARCHAR
12DR_ACCOUNT100VARCHAR
13CR_ACCOUNT100VARCHAR
14DISCOUNTMONEY
15UNIT_FEEMONEY
16DISCOUNT_RATEREAL
17DESCRIPTION50VARCHAR
18COMMENT50VARCHAR
19REFERENCE_NUMBER50VARCHAR
20EXTENDED_FEE_AMOUNTMONEY
21BANKCODESMALLINT
22QUANTITYREAL
23USER_ENTERED_QTYFLOAT
24TRAN_DESCRIPTION40VARCHAR
25SHORT_DESCRIPTION50VARCHAR
26SYSTEM_CODE5VARCHAR
27SUMMARY_FLAG1VARCHAR
28USER_DATA_130VARCHAR
29USER_DATA_230VARCHAR
30USER_DATA_330VARCHAR
31USER_DATA_430VARCHAR
32USER_DATA_530VARCHAR
33USER_DATA_630VARCHAR
34USER_DATA_730VARCHAR
35USER_DATA_830VARCHAR
36USER_DATA_930VARCHAR
37DEPT_CODE15VARCHAR
38LOCATION_CODE3CHAR
39F0150VARCHAR
40F0250VARCHAR
41F0350VARCHAR
42F0450VARCHAR
43F0550VARCHAR
44F0650VARCHAR
45F0750VARCHAR
46F0850VARCHAR
47F0950VARCHAR
48F1050VARCHAR
49F1150VARCHAR
50F1250VARCHAR
51F1350VARCHAR
52F1450VARCHAR
53F1550VARCHAR
54F1650VARCHAR
55F1750VARCHAR
56F1850VARCHAR
57F1950VARCHAR
58F2050VARCHAR
59F2150VARCHAR
60F2250VARCHAR
61F2350VARCHAR
62F2450VARCHAR
63F2550VARCHAR
64F2650VARCHAR
65F2750VARCHAR
66F2850VARCHAR
67F2950VARCHAR
68F3050VARCHAR
69CUST_NAME50VARCHAR



RASWIN Table/View Index




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