Difference between revisions of "Vital Signs Internal Tables"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
(Created page with "== Overview == The definitions of the Tables and Fields available in Vital Signs == Tables == '''MBR''' '''SH''' '''LN''' '''LNADDM''' '''LNAPP''' '''LNTERMS''' '''DLRINFO''...")
 
>Jeremyb
(→‎DLRINFO Fields)
Line 26: Line 26:
  
 
== DLRINFO Fields ==
 
== DLRINFO Fields ==
 +
 +
'''DLR_ADDR1'''
 +
    The dealer's address lines 1
 +
 +
'''DLR_ADDR2'''
 +
    The dealer's address lines 2
 +
 +
'''DLR_ADDR3'''
 +
    The dealer's address lines 3
 +
 +
'''DLR_CHECK_MIN'''
 +
 +
'''DLR_CITY'''
 +
    The city the dealer is located in
 +
 +
'''DLR_COUNTRY_CODE'''
 +
    The dealer's 2 digit country code
 +
 +
'''DLR_DEALER_GRADE'''
 +
  The grade associated with the dealer
 +
 +
'''DLR_FEE_CODE'''
 +
 +
'''DLR_FEE_FIXED'''
 +
 +
'''DLR_FEE_FLAG'''
 +
 +
'''DLR_FEE_MAXIMUM'''
 +
 +
'''DLR_NAME'''
 +
    The name of the dealer
 +
 +
'''DLR_PHONE'''
 +
    The phone number for the dealer
 +
 +
'''DLR_PTD_COUNT'''
 +
 +
'''DLR_PTD_FEE_AMOUNT'''
 +
 +
'''DLR_PTD_LOAN_AMOUNT'''
 +
 +
'''DLR_PY_COUNT'''
 +
 +
'''DLR_PY_FEE_AMOUNT'''
 +
 +
'''DLR_PY_LOAN_AMOUNT'''
 +
 +
'''DLR_RESERVE_AMT'''
 +
 +
'''DLR_STATE'''
 +
    The state the dealership is located in
 +
 +
'''DLR_TTD_COUNT'''
 +
 +
'''DLR_TTD_FEE_AMOUNT'''
 +
 +
'''DLR_TTD_LOAN_AMOUNT'''
 +
 +
'''DLR_YTD_COUNT'''
 +
 +
'''DLR_YTD_FEE_AMOUNT'''
 +
 +
'''DLR_YTD_LOAN_AMOUNT'''
 +
 +
'''DLR_ZIP'''
  
 
== VEHCINFO Fields ==
 
== VEHCINFO Fields ==

Revision as of 20:11, 4 September 2012

Overview

The definitions of the Tables and Fields available in Vital Signs

Tables

MBR SH LN LNADDM LNAPP LNTERMS DLRINFO VEHCINFO

MBR Fields

SH Fields

LN Fields

LNADDM Fields

LNAPP Fields

LNTERMS Fields

DLRINFO Fields

DLR_ADDR1 

   The dealer's address lines 1

DLR_ADDR2 

   The dealer's address lines 2

DLR_ADDR3 

   The dealer's address lines 3

DLR_CHECK_MIN

DLR_CITY 

   The city the dealer is located in

DLR_COUNTRY_CODE 

   The dealer's 2 digit country code

DLR_DEALER_GRADE 

  The grade associated with the dealer

DLR_FEE_CODE

DLR_FEE_FIXED

DLR_FEE_FLAG

DLR_FEE_MAXIMUM

DLR_NAME 

   The name of the dealer

DLR_PHONE 

   The phone number for the dealer

DLR_PTD_COUNT

DLR_PTD_FEE_AMOUNT

DLR_PTD_LOAN_AMOUNT

DLR_PY_COUNT

DLR_PY_FEE_AMOUNT

DLR_PY_LOAN_AMOUNT

DLR_RESERVE_AMT

DLR_STATE 

   The state the dealership is located in

DLR_TTD_COUNT

DLR_TTD_FEE_AMOUNT

DLR_TTD_LOAN_AMOUNT

DLR_YTD_COUNT

DLR_YTD_FEE_AMOUNT

DLR_YTD_LOAN_AMOUNT

DLR_ZIP

VEHCINFO Fields

Retrieved from "https://wiki.vital-soft.com/index.php?title=Vital_Signs_Internal_Tables&oldid=642"