AMSEGBLOCK – No description in the Lawson data dictionary

System
Asset Management (AM)
Prefix
SGB
Primary key
COMPANY, ACCT-GRP, ASSET-TYPE, SUB-TYPE, ACCT-TYPE, ASSET-EVENT
Fields
7
Updated by
290 programs
Referenced by
1 program

AMSEGBLOCK is a Lawson Asset Management table (prefix SGB); no description in the lawson data dictionary. It is indexed by COMPANY, ACCT-GRP, ASSET-TYPE, SUB-TYPE, ACCT-TYPE, ASSET-EVENT (SGBSET1). It is updated by AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117 and 282 more and referenced by AM275. The table has 7 fields, 1 index and 0 documented relations.

About AMSEGBLOCK

No description in the Lawson data dictionary.

Fields (7)

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

Field / columnTypeDescription & valuesUpdated by
SGB-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.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117 +52 more (list truncated in source)
SGB-ACCT-GRP PK
ACCT_GRP		Alpha 10—AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117 +52 more (list truncated in source)
SGB-ASSET-TYPE PK
ASSET_TYPE		Alpha 10An asset type represents a grouping of like assets. Asset types are used to group assets into reporting classes and to default common asset definition data.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117 +52 more (list truncated in source)
SGB-SUB-TYPE PK
SUB_TYPE		Alpha 10An asset subtype represents a more detailed grouping of assets within an asset type grouping. Asset subtypes are used to group assets into reporting classes and allow common asset definition data to default. Subtypes must be unique within an asset type.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117 +52 more (list truncated in source)
SGB-ACCT-TYPE PK
ACCT_TYPE		Alpha 3—AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117 +52 more (list truncated in source)
SGB-ASSET-EVENT PK
ASSET_EVENT		Alpha 1—
  • 1 Additions
  • 2 Adjustments
  • 3 Transfers
  • 4 Disposals
  • 5 Re-instatements
AC160, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117, AM12.1 +52 more (list truncated in source)
SGB-SEGMENT-BLOCK
SEGMENT_BLOCK		Alpha 103This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117 +52 more (list truncated in source)

Indexes (1)

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

IndexKeysFlagsConditionUsed in
SGBSET1COMPANY, ACCT-GRP, ASSET-TYPE, SUB-TYPE, ACCT-TYPE, ASSET-EVENTPrimaryAC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117 +22 more (list truncated in source)

Programs

Updated by (290)

Referenced by (1)