ACRS Tables Setup (ACRSTBL)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ACRSTBL

Product: Fixed Assets (309)
Series: System

Display Name: ACRS Tables Setup
Physical Name: ACRSTBL
Technical Name: FA_ACRS_SETP

Group Display Name: Fixed Assets ACRS Tables
Group Technical Name: Fixed Assets ACRS Tables

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ACRSTABLES SearchACRS TablesDDL_ACRS_TablesInteger20
2ACRSYEAR SearchACRS YearINT4_RB_U0Integer24
3ACRSPCT SearchACRS PercentINT4_RB_U1Integer24
4ACRSPCT_1 SearchACRS Percent[1]INT4_RB_U1Integer24
5ACRSPCT_2 SearchACRS Percent[2]INT4_RB_U1Integer24
6ACRSPCT_3 SearchACRS Percent[3]INT4_RB_U1Integer24
7ACRSPCT_4 SearchACRS Percent[4]INT4_RB_U1Integer24
8ACRSPCT_5 SearchACRS Percent[5]INT4_RB_U1Integer24
9ACRSPCT_6 SearchACRS Percent[6]INT4_RB_U1Integer24
10ACRSPCT_7 SearchACRS Percent[7]INT4_RB_U1Integer24
11ACRSPCT_8 SearchACRS Percent[8]INT4_RB_U1Integer24
12ACRSPCT_9 SearchACRS Percent[9]INT4_RB_U1Integer24
13ACRSPCT_10 SearchACRS Percent[10]INT4_RB_U1Integer24
14ACRSPCT_11 SearchACRS Percent[11]INT4_RB_U1Integer24
15ACRSPCT_12 SearchACRS Percent[12]INT4_RB_U1Integer24
16DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *