rsa Table: Sales Tax on Assessment
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rsa Table: Sales Tax on Assessment

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4
rsa_idx0 por_s assmt_tax_cls_s st_s rsa_code_s

  
Columns
Name DescriptionDatatype ¿? Allow Null
por_s
Portfolio
CHAR(2) no
st_s
State code (RST.ST_S code)
CHAR(2) no
rsa_code_s
Assessment code
  For assessments and recurring charges, this will be the
  rpar.chrg_cd_s charge code, with the following exceptions:
  There are no entries in rsa_code_s corresponding to the
  rpar charge codes of CAPR, DREC, PROR, SECD, STAX, PRN,
  and INT. The rpar charge codes of RCR1, RCR2, and RCR3
  are represented in rsa_code_s as RC01, RC02, and RC03.
CHAR(4) no
stamp_l
Record modification stamp
NUMBER(10) no
stax_asm_c
State requires tax (Y/N)
CHAR(1) yes
assmt_tax_cls_s
Assessment tax class (ASM.TAXCLS code)
CHAR(4) no