SNBUDGET – Smart Notification Budget

System
Smart Notification (SN)
Prefix
S01
Primary key
BUD-OBJ-ID
Fields
55
Updated by
6 programs
Referenced by
30 programs

SNBUDGET is the Smart Notification Budget table in Lawson Smart Notification (prefix S01). It is indexed by BUD-OBJ-ID (S01SET1); alternate indexes: S01SET2. It is updated by SN40.1, SN80.2, SN80.3, SN85.1, SN85.2 and SNFL.1 and referenced by SN120, SN130, SN200, SN50.1, SN60.1, SN60.2, SN60.3, SN60.4 and 22 more. The table has 55 fields, 2 indexes and 0 documented relations.

About SNBUDGET

No description in the Lawson data dictionary.

Fields (55)

Column = COBOL field name without the S01- 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
#S01-BUD-OBJ-ID PK
BUD_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.SNFL.1
#S01-BUDGET-NAME SET2
BUDGET_NAME		Alpha 12Name of the budget. This is the unique identifier of a budget.SNFL.1
#S01-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.SNFL.1
#S01-NBR-OF-PERIODS
NBR_OF_PERIODS		Numeric 3——
#S01-SERVER-NAME
SERVER_NAME		Alpha 40 (Lower Case)The Server Name field contains the IP address of the server to which you are connecting. You can also specify a name that has been associated with the server (DNS name).SNFL.1
#S01-SC-IMP-PATH
SC_IMP_PATH		Alpha 100 (Lower Case)This is the directory on the Lawson Server where the Budget Architect will create all ASCII files to be imported into Pillar.SNFL.1
#S01-SC-EXP-PATH
SC_EXP_PATH		Alpha 100 (Lower Case)This is the directory on the Lawson Server where the Budget Architect will search for ASCII files exported from Pillar.SNFL.1
#S01-BO-IMPORT-PATH
BO_IMPORT_PATH		Alpha 100 (Lower Case)This is the directory on the Lawson Server where the Budget Architect will create all ASCII files to be imported into Pillar.SNFL.1
#S01-BO-EXPORT-PATH
BO_EXPORT_PATH		Alpha 100 (Lower Case)This is the directory on the Lawson Server where the Budget Architect will search for ASCII files exported from Pillar.SNFL.1
#S01-CURR-YEAR
CURR_YEAR		Numeric 4—SNFL.1
#S01-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1The status of the account. If Inactive, no posting can be done to the account.—
#S01-FB-BUDGET-NBR
FB_BUDGET_NBR		Numeric 3—SNFL.1
#S01-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).SNFL.1
#S01-SC-CORP-CODE
SC_CORP_CODE		Alpha 50 (Lower Case)—SNFL.1
#S01-SC-RELEASE
SC_RELEASE		Alpha 6 (Lower Case)—SNFL.1
#S01-DEFAULT-CHART
DEFAULT_CHART		Alpha 12This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system.SNFL.1
#S01-OPEX-LN-ATTR
OPEX_LN_ATTR		Alpha 12Attribute name assigned to an object (like accounting unit) to track additional information. Attribute values may then be used in selection and sorting for report and analysis.—
#S01-DEFAULT-OPEX
DEFAULT_OPEX		Alpha 32The attribute value.—
#S01-HEAD-CAT-OPT
HEAD_CAT_OPT		Alpha 1—SN80.2, SNFL.1
#S01-HEAD-CT-COMP
HEAD_CT_COMP		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.SN80.2, SNFL.1
#S01-HEAD-CT-CO-GRP
HEAD_CT_CO_GRP		Alpha 12You can type or select a company group. A company group represents one or more companies. If you select a company group, leave the Company field blank.SN80.2, SNFL.1
#S01-HEAD-CT-EMP-GP
HEAD_CT_EMP_GP		Alpha 10—SN80.2, SNFL.1
#S01-HEAD-TYPE-OPT
HEAD_TYPE_OPT		Alpha 1—SN80.3, SNFL.1
#S01-HEAD-TY-COMP
HEAD_TY_COMP		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.SN80.3, SNFL.1
#S01-HEAD-TY-CO-GRP
HEAD_TY_CO_GRP		Alpha 12You can type or select a company group. A company group represents one or more companies. If you select a company group, leave the Company field blank.SN80.3, SNFL.1
#S01-HEAD-TY-EMP-GP
HEAD_TY_EMP_GP		Alpha 10—SN80.3, SNFL.1
#S01-HC-ACT-COMP
HC_ACT_COMP		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.SN85.2
#S01-HC-ACT-CO-GRP
HC_ACT_CO_GRP		Alpha 12You can type or select a company group. A company group represents one or more companies. If you select a company group, leave the Company field blank.SN85.2
#S01-HC-ACT-EMP-GP
HC_ACT_EMP_GP		Alpha 10—SN85.2
#S01-HC-ACT-HEADS
HC_ACT_HEADS		Alpha 1—SN85.2
#S01-HC-ACT-COUNTS
HC_ACT_COUNTS		Alpha 1—
  • 1 Primary Position
  • 2 All Positions
SN85.2
#S01-HC-PLN-COMP
HC_PLN_COMP		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.SN85.1
#S01-HC-PLN-CO-GRP
HC_PLN_CO_GRP		Alpha 12You can type or select a company group. A company group represents one or more companies. If you select a company group, leave the Company field blank.SN85.1
#S01-HC-PLN-EMP-GP
HC_PLN_EMP_GP		Alpha 10—SN85.1
#S01-HC-PLN-SUM-OPT
HC_PLN_SUM_OPT		Alpha 1—SN85.1
#S01-HC-PLN-CONCAT
HC_PLN_CONCAT		Alpha 1—SN85.1
#S01-HC-PLN-ACCESS
HC_PLN_ACCESS		Alpha 1—SN85.1
#S01-HC-PLN-REQ-PRE
HC_PLN_REQ_PRE		Alpha 5 (Lower Case)The Member Prefix field contains a unique prefix to differentiate the dimension name from other like-named dimensions. This user-defined name can contain up to five characters of any kind.SN85.1
#S01-HC-PLN-HEADS
HC_PLN_HEADS		Alpha 1—SN85.1
#S01-HC-PLN-COUNTS
HC_PLN_COUNTS		Alpha 1—SN85.1
#S01-DEFAULT-CAT
DEFAULT_CAT		Alpha 50 (Lower Case)—SNFL.1
#S01-DEFAULT-TYPE
DEFAULT_TYPE		Alpha 50 (Lower Case)—SNFL.1
#S01-DEFAULT-HR-AU
DEFAULT_HR_AU		Alpha 50 (Lower Case)—SNFL.1
#S01-OTHER-CO
OTHER_CO		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.SNFL.1
#S01-OTHER-AU
OTHER_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.SNFL.1
#S01-OTHER-LIST
OTHER_LIST		Alpha 12Attribute categories are selection parameters used to build a list of objects (accounting units). Attribute categories and values are the basis of the selection and sorting. A attribute list can then be used for reporting on and processing objects.SNFL.1
#S01-OTHER-SUM-ACT
OTHER_SUM_ACT		Alpha 12—SNFL.1
#S01-OTHER-ACT-LIST
OTHER_ACT_LIST		Alpha 12Attribute categories are selection parameters used to build a list of objects (accounting units). Attribute categories and values are the basis of the selection and sorting. A attribute list can then be used for reporting on and processing objects.SNFL.1
#S01-TAXES-CO
TAXES_CO		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.SNFL.1
#S01-TAXES-AU
TAXES_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.SNFL.1
#S01-TAXES-LIST
TAXES_LIST		Alpha 12Attribute categories are selection parameters used to build a list of objects (accounting units). Attribute categories and values are the basis of the selection and sorting. A attribute list can then be used for reporting on and processing objects.SNFL.1
#S01-TAXES-SUM-ACT
TAXES_SUM_ACT		Alpha 12—SNFL.1
#S01-TAXES-ACT-LIST
TAXES_ACT_LIST		Alpha 12Attribute categories are selection parameters used to build a list of objects (accounting units). Attribute categories and values are the basis of the selection and sorting. A attribute list can then be used for reporting on and processing objects.SNFL.1
#S01-CURRENCY-TABLE
CURRENCY_TABLE		Alpha 12—SN40.1
#S01-TRANSL-CODE
TRANSL_CODE		Alpha 2—SN40.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
S01SET1
  1. BUD-OBJ-ID
PrimarySNEM.1, SNFL.1, SNHC.1, SNOD.1
S01SET2
  1. BUDGET-NAME
SN120, SN130, SN200, SN40.1, SN50.1, SN60.1, SN60.2, SN60.3 +22 more (list truncated in source)

Programs

Updated by (6)

Referenced by (30)