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.

Field / column	Type	Description & values	Updated by
`SAT-ACTIVITY-GRP` PK ACTIVITY_GRP	Alpha 15	The activity group is the overall project.	SNAC.1
`SAT-ACTIVITY` PK ACTIVITY	Alpha 15	Activities 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 5	Account 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 thru	SNAC.1
`SAT-ACCT-CATEGORY` PK ACCT_CATEGORY	Alpha 5	Account 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 thru	SNAC.1
`SAT-COMPANY` PK COMPANY	Numeric 4	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-ACCT-UNIT` PK ACCT_UNIT	Alpha 15	The 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 4	Resource 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 10	The code identifying the resource assigned to the activity or activity group.	—
`SAT-RESOURCE-TYPE` PK RESOURCE_TYPE	Alpha 1	The 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 12	The code that identifies a role that a resource has in relation to activities.	—
`SAT-AU-DEPTH` AU_DEPTH	Numeric 1	The number of variable levels pertaining to this record.	—
`SAT-ACTIVITY-DEPTH` ACTIVITY_DEPTH	Numeric 1	The 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 1	This Field is used to set up the default category type for the Distribution File. (EEDISTRIB)	SNAC.1
`SAT-PARENT-ACTVY` PARENT_ACTVY	Alpha 15	Activities 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`SATSET1`	`ACTIVITY-GRP`, `ACTIVITY`, `SUMM-ACCT-CAT`, `ACCT-CATEGORY`, `ACCT-CAT-TYP`, `COMPANY`, `ACCT-UNIT`, `RESOURCE-COMP`, `RESOURCE-CODE`, `RESOURCE-TYPE`	Primary		SNAC.1
`SATSET2`	`ACTIVITY-GRP`, `ACTIVITY`, `SUMM-ACCT-CAT`, `ACCT-CATEGORY`, `COMPANY`, `ACCT-UNIT`, `RESOURCE-COMP`, `RESOURCE-CODE`, `RESOURCE-TYPE`	Subset	Where ACCT-CATEGORY = Spaces And ((ACCT-CAT-TYP = "R") Or (ACCT-CAT-TYP = "C"))	—

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Cost	SNACAMOUNT	Not 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`
Revenue	SNACAMOUNT	Not 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)

SNAC.1 Activity Management Notification Update