SNACAMOUNT – No description in the Lawson data dictionary

System
Smart Notification (SN)
Prefix
SAT
Primary key
ACTIVITY-GRP, ACTIVITY, SUMM-ACCT-CAT, ACCT-CATEGORY, ACCT-CAT-TYP, COMPANY, ACCT-UNIT, RESOURCE-COMP, RESOURCE-CODE, RESOURCE-TYPE
Fields
33
Updated by
1 program
Referenced by
0 programs

SNACAMOUNT is a Lawson Smart Notification table (prefix SAT); no description in the lawson data dictionary. It is indexed by ACTIVITY-GRP, ACTIVITY, SUMM-ACCT-CAT, ACCT-CATEGORY, ACCT-CAT-TYP, COMPANY, ACCT-UNIT, RESOURCE-COMP, RESOURCE-CODE, RESOURCE-TYPE (SATSET1); alternate indexes: SATSET2. It is related 1:1 to SNACAMOUNT. It is updated by SNAC.1. The table has 33 fields, 2 indexes and 2 documented relations.

About SNACAMOUNT

No description in the Lawson data dictionary.

Fields (33)

Column = COBOL field name without the SAT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#SAT-ACTIVITY-GRP PK
ACTIVITY_GRP		Alpha 15The activity group is the overall project.SNAC.1
#SAT-ACTIVITY PK
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.SNAC.1
#SAT-SUMM-ACCT-CAT PK
SUMM_ACCT_CAT		Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruSNAC.1
#SAT-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruSNAC.1
#SAT-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.—
#SAT-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.—
#SAT-RESOURCE-COMP PK
RESOURCE_COMP		Numeric 4Resource Company. Identifies 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.—
#SAT-RESOURCE-CODE PK
RESOURCE_CODE		Alpha 10The code identifying the resource assigned to the activity or activity group.—
#SAT-RESOURCE-TYPE PK
RESOURCE_TYPE		Alpha 1The type of resource. Valid values include: P - AC Person Q - Equipment E - Employee V - Vendor A - Asset—
#SAT-CUR-PRD-AMOUNT
CUR_PRD_AMOUNT		Signed 18.2—SNAC.1
#SAT-CUR-PRD-COMMIT
CUR_PRD_COMMIT		Signed 18.2—SNAC.1
#SAT-CUR-AMT-COMMIT
CUR_AMT_COMMIT		Signed 18.2—SNAC.1
#SAT-CUR-PRD-BUDGET
CUR_PRD_BUDGET		Signed 18.2—SNAC.1
#SAT-PRV-PRD-AMOUNT
PRV_PRD_AMOUNT		Signed 18.2——
#SAT-PRV-PRD-COMMIT
PRV_PRD_COMMIT		Signed 18.2——
#SAT-PRV-AMT-COMMIT
PRV_AMT_COMMIT		Signed 18.2——
#SAT-PRV-PRD-BUDGET
PRV_PRD_BUDGET		Signed 18.2——
#SAT-LTD-AMT
LTD_AMT		Signed 18.2—SNAC.1
#SAT-LTD-BUDGET
LTD_BUDGET		Signed 18.2—SNAC.1
#SAT-LTD-COMMIT-AMT
LTD_COMMIT_AMT		Derived——
#SAT-YTD-AMT
YTD_AMT		Signed 18.2—SNAC.1
#SAT-YTD-BUDGET
YTD_BUDGET		Signed 18.2—SNAC.1
#SAT-YTD-COMMIT-AMT
YTD_COMMIT_AMT		Derived——
#SAT-PRD-RNG-AMT
PRD_RNG_AMT		Signed 18.2——
#SAT-PRD-RNG-BUDGET
PRD_RNG_BUDGET		Signed 18.2——
#SAT-RNG-COMMIT-AMT
RNG_COMMIT_AMT		Derived——
#SAT-ROLE
ROLE		Alpha 12The code that identifies a role that a resource has in relation to activities.—
#SAT-AU-DEPTH
AU_DEPTH		Numeric 1The number of variable levels pertaining to this record.—
#SAT-ACTIVITY-DEPTH
ACTIVITY_DEPTH		Numeric 1The number of variable levels pertaining to this record.SNAC.1
#SAT-ACTIVITY-DESCR
ACTIVITY_DESCR		Alpha 30 (Lower Case)This field displays the description.SNAC.1
#SAT-ACCT-CAT-DESC
ACCT_CAT_DESC		Alpha 30 (Lower Case)This field displays the description.SNAC.1
#SAT-ACCT-CAT-TYP PK
ACCT_CAT_TYP		Alpha 1This Field is used to set up the default category type for the Distribution File. (EEDISTRIB)SNAC.1
#SAT-PARENT-ACTVY
PARENT_ACTVY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.SNAC.1

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
SATSET1
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. SUMM-ACCT-CAT
  4. ACCT-CATEGORY
  5. ACCT-CAT-TYP
  6. COMPANY
  7. ACCT-UNIT
  8. RESOURCE-COMP
  9. RESOURCE-CODE
  10. RESOURCE-TYPE
PrimarySNAC.1
SATSET2
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. SUMM-ACCT-CAT
  4. ACCT-CATEGORY
  5. COMPANY
  6. ACCT-UNIT
  7. RESOURCE-COMP
  8. RESOURCE-CODE
  9. RESOURCE-TYPE
SubsetWhere ACCT-CATEGORY = Spaces And ((ACCT-CAT-TYP = "R") Or (ACCT-CAT-TYP = "C"))—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
SNACAMOUNTSNACAMOUNT

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CostSNACAMOUNTNot Required
SAT-ACTIVITY-GRP→SAT-ACTIVITY-GRP (SATSET1)
SAT-ACTIVITY→SAT-ACTIVITY
"COST"→SAT-SUMM-ACCT-CAT
Spaces→SAT-ACCT-CATEGORY
"C"→SAT-ACCT-CAT-TYP
SAT-COMPANY→SAT-COMPANY
SAT-ACCT-UNIT→SAT-ACCT-UNIT
SAT-RESOURCE-COMP→SAT-RESOURCE-COMP
SAT-RESOURCE-CODE→SAT-RESOURCE-CODE
SAT-RESOURCE-TYPE→SAT-RESOURCE-TYPE
RevenueSNACAMOUNTNot Required
SAT-ACTIVITY-GRP→SAT-ACTIVITY-GRP
SAT-ACTIVITY→SAT-ACTIVITY
"REV"→SAT-SUMM-ACCT-CAT
Spaces→SAT-ACCT-CATEGORY
"R"→SAT-ACCT-CAT-TYP
Zeroes→SAT-COMPANY
SAT-ACCT-UNIT→SAT-ACCT-UNIT
SAT-RESOURCE-COMP→SAT-RESOURCE-COMP
SAT-RESOURCE-CODE→SAT-RESOURCE-CODE
SAT-RESOURCE-TYPE→SAT-RESOURCE-TYPE

Programs

Updated by (1)