SNGLUNIT – No description in the Lawson data dictionary

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

SNGLUNIT is a Lawson Smart Notification table (prefix SNU); no description in the lawson data dictionary. It is indexed by COMPANY, ACCT-UNIT, SUMMARY-ACCT, ACCOUNT, SUB-ACCOUNT (SNUSET1). It is updated by SNGL.1. The table has 28 fields, 1 index and 0 documented relations.

About SNGLUNIT

No description in the Lawson data dictionary.

Fields (28)

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

Field / columnTypeDescription & valuesUpdated by
SNU-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
SNU-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
SNU-SUMMARY-ACCT PK
SUMMARY_ACCT
Alpha 12SNGL.1
SNU-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
SNU-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
SNU-CUR-PRD-UNT
CUR_PRD_UNT
Signed 15.2The total positive detail auto reversing amounts.SNGL.1
SNU-CUR-QTR-UNT
CUR_QTR_UNT
Signed 15.2The total positive detail auto reversing amounts.SNGL.1
SNU-CUR-TOT-UNT
CUR_TOT_UNT
Signed 15.2The total positive detail auto reversing amounts.SNGL.1
SNU-PRV-PRD-UNT
PRV_PRD_UNT
Signed 15.2The total positive detail auto reversing amounts.SNGL.1
SNU-PRV-QTD-UNT
PRV_QTD_UNT
Signed 15.2The total positive detail auto reversing amounts.SNGL.1
SNU-PRV-QTR-UNT
PRV_QTR_UNT
Signed 15.2The total positive detail auto reversing amounts.SNGL.1
SNU-LYR-PRD-UNT
LYR_PRD_UNT
Signed 15.2The total positive detail auto reversing amounts.SNGL.1
SNU-LYR-QTD-UNT
LYR_QTD_UNT
Signed 15.2The total positive detail auto reversing amounts.SNGL.1
SNU-LYR-QTR-UNT
LYR_QTR_UNT
Signed 15.2The total positive detail auto reversing amounts.SNGL.1
SNU-LYR-YTD-UNT
LYR_YTD_UNT
Signed 15.2The total positive detail auto reversing amounts.SNGL.1
SNU-LYR-TOT-UNT
LYR_TOT_UNT
Signed 15.2The total positive detail auto reversing amounts.SNGL.1
SNU-CUR-PRD-BUN
CUR_PRD_BUN
Signed 15.2The total positive detail auto reversing amounts.SNGL.1
SNU-CUR-QTD-BUN
CUR_QTD_BUN
Signed 15.2The total positive detail auto reversing amounts.SNGL.1
SNU-CUR-QTR-BUN
CUR_QTR_BUN
Signed 15.2The total positive detail auto reversing amounts.SNGL.1
SNU-CUR-YTD-BUN
CUR_YTD_BUN
Signed 15.2The total positive detail auto reversing amounts.SNGL.1
SNU-CUR-TOT-BUN
CUR_TOT_BUN
Signed 15.2The total positive detail auto reversing amounts.SNGL.1
SNU-AU-DESC
AU_DESC
Alpha 30 (Lower Case)This field displays the description.SNGL.1
SNU-ACCOUNT-DESC
ACCOUNT_DESC
Alpha 60 (Lower Case)The account description.SNGL.1
SNU-AU-DEPTH
AU_DEPTH
Numeric 1The number of variable levels pertaining to this record.SNGL.1
SNU-ACCT-DEPTH
ACCT_DEPTH
Numeric 2The level depth of the summary account category.SNGL.1
SNU-ACCT-STYLE
ACCT_STYLE
Numeric 1
  • 1 Summary
  • 2 Detail
SNGL.1
SNU-CHART-TYPE
CHART_TYPE
Numeric 1
  • 1 Asset
  • 2 Liability
  • 3 Equity
  • 4 Revenue
  • 5 Expense
  • 6 Net Income
SNGL.1
SNU-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 (1)

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

IndexKeysFlagsConditionUsed in
SNUSET1COMPANY, ACCT-UNIT, SUMMARY-ACCT, ACCOUNT, SUB-ACCOUNTPrimarySNGL.1

Programs

Updated by (1)