SNGLAMOUNT – No description in the Lawson data dictionary

System
Smart Notification (SN)
Prefix
SNA
Primary key
COMPANY, ACCT-UNIT, SUMMARY-ACCT, ACCOUNT, SUB-ACCOUNT
Fields
28
Updated by
1 program
Referenced by
0 programs

SNGLAMOUNT is a Lawson Smart Notification table (prefix SNA); no description in the lawson data dictionary. It is indexed by COMPANY, ACCT-UNIT, SUMMARY-ACCT, ACCOUNT, SUB-ACCOUNT (SNASET1); alternate indexes: SNASET2 and SNASET3. It is related 1:1 to SNGLAMOUNT. It is updated by SNGL.1. The table has 28 fields, 3 indexes and 2 documented relations.

About SNGLAMOUNT

No description in the Lawson data dictionary.

Fields (28)

Column = COBOL field name without the SNA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
SNA-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.SNGL.1
SNA-ACCT-UNIT PK
ACCT_UNIT		Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.SNGL.1
SNA-SUMMARY-ACCT PK
SUMMARY_ACCT		Alpha 12—SNGL.1
SNA-ACCOUNT PK
ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.SNGL.1
SNA-SUB-ACCOUNT PK
SUB_ACCOUNT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.SNGL.1
SNA-CUR-PRD-AMT
CUR_PRD_AMT		Signed 18.2—SNGL.1
SNA-CUR-QTR-AMT
CUR_QTR_AMT		Signed 18.2—SNGL.1
SNA-CUR-TOT-AMT
CUR_TOT_AMT		Signed 18.2—SNGL.1
SNA-PRV-PRD-AMT
PRV_PRD_AMT		Signed 18.2—SNGL.1
SNA-PRV-QTD-AMT
PRV_QTD_AMT		Signed 18.2—SNGL.1
SNA-PRV-QTR-AMT
PRV_QTR_AMT		Signed 18.2—SNGL.1
SNA-LYR-PRD-AMT
LYR_PRD_AMT		Signed 18.2—SNGL.1
SNA-LYR-QTD-AMT
LYR_QTD_AMT		Signed 18.2—SNGL.1
SNA-LYR-QTR-AMT
LYR_QTR_AMT		Signed 18.2—SNGL.1
SNA-LYR-YTD-AMT
LYR_YTD_AMT		Signed 18.2—SNGL.1
SNA-LYR-TOT-AMT
LYR_TOT_AMT		Signed 18.2—SNGL.1
SNA-CUR-PRD-BUD
CUR_PRD_BUD		Signed 18.2—SNGL.1
SNA-CUR-QTD-BUD
CUR_QTD_BUD		Signed 18.2—SNGL.1
SNA-CUR-QTR-BUD
CUR_QTR_BUD		Signed 18.2—SNGL.1
SNA-CUR-YTD-BUD
CUR_YTD_BUD		Signed 18.2—SNGL.1
SNA-CUR-TOT-BUD
CUR_TOT_BUD		Signed 18.2—SNGL.1
SNA-AU-DESC
AU_DESC		Alpha 30 (Lower Case)This field displays the description.SNGL.1
SNA-ACCOUNT-DESC
ACCOUNT_DESC		Alpha 60 (Lower Case)The account description.SNGL.1
SNA-AU-DEPTH
AU_DEPTH		Numeric 1The number of variable levels pertaining to this record.SNGL.1
SNA-ACCT-DEPTH
ACCT_DEPTH		Numeric 2The level depth of the summary account category.SNGL.1
SNA-ACCT-STYLE
ACCT_STYLE		Numeric 1—
  • 1 Summary
  • 2 Detail
SNGL.1
SNA-CHART-TYPE
CHART_TYPE		Numeric 1—
  • 1 Asset
  • 2 Liability
  • 3 Equity
  • 4 Revenue
  • 5 Expense
  • 6 Net Income
SNGL.1
SNA-PARENT-AU
PARENT_AU		Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.SNGL.1

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
SNASET1COMPANY, ACCT-UNIT, SUMMARY-ACCT, ACCOUNT, SUB-ACCOUNTPrimarySNGL.1
SNASET2COMPANY, ACCT-UNITSubsetWhere ACCT-STYLE = 1 And CHART-TYPE = 4—
SNASET3COMPANY, ACCT-UNITSubsetWhere ACCT-STYLE = 1 And CHART-TYPE = 5—

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
ExpenseSNGLAMOUNTNot RequiredSNA-COMPANY → SNA-COMPANY (SNASET3), SNA-ACCT-UNIT → SNA-ACCT-UNIT
RevenueSNGLAMOUNTNot RequiredSNA-COMPANY → SNA-COMPANY, SNA-ACCT-UNIT → SNA-ACCT-UNIT

Programs

Updated by (1)