DETAIL_VIEW_WITH_PAYMENT_INFO : VIEW

#Column NameMax SizeData Type
1RCPT_NUMBER12CHAR
2REGNUM3VARCHAR
3ACCOUNTING_DATEDATETIME
4RCPT_DATE_TIMEDATETIME
5TOTAL_DUEMONEY
6TOTAL_TENDEREDMONEY
7CHANGE_DUEMONEY
8RCPT_STATUSSMALLINT
9HDR_PAYER_NAME40VARCHAR
10DTL_SEQNUMSMALLINT
11TRAN_CODE30VARCHAR
12DR_ACCOUNT100VARCHAR
13CR_ACCOUNT100VARCHAR
14COMMENT50VARCHAR
15DTL_REFNUM50VARCHAR
16QUANTITYREAL
17UNIT_FEEMONEY
18DISCOUNT_RATEREAL
19DISCOUNTMONEY
20EXTENDED_FEE_AMOUNTMONEY
21BANKCODESMALLINT
22PMT_METHOD10VARCHAR
23PMT_PAYER_NAME40VARCHAR
24PMT_AMOUNTMONEY
25PMT_SEQNUMSMALLINT
26PMT_REF_NUM100VARCHAR



RASWIN Table/View Index




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