COSGBLK – No description in the Lawson data dictionary

System
OE (OE)
Prefix
OSG
Primary key
COMPANY, ORDER-NBR, LINE-NBR, SEQ
Fields
5
Updated by
220 programs
Referenced by
0 programs

COSGBLK is a Lawson OE table (prefix OSG); no description in the lawson data dictionary. It is indexed by COMPANY, ORDER-NBR, LINE-NBR, SEQ (OSGSET1). It is related 1:1 to COLINE, COMISC and CUSTORDER. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 212 more. The table has 5 fields, 1 index and 3 documented relations.

About COSGBLK

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the OSG- 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
#OSG-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.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#OSG-ORDER-NBR PK
ORDER_NBR		Numeric 8This field contains the order number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#OSG-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#OSG-SEQ PK
SEQ		Numeric 3This field contains the record sequence number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#OSG-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.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (1)

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
OSGSET1
  1. COMPANY
  2. ORDER-NBR
  3. LINE-NBR
  4. SEQ
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
ColineCOLINENot Required
OSG-COMPANY→COL-COMPANY
OSG-ORDER-NBR→COL-ORDER-NBR
OSG-LINE-NBR→COL-LINE-NBR
ComiscCOMISCNot Required
OSG-COMPANY→CMC-COMPANY
OSG-ORDER-NBR→CMC-ORDER-NBR
OSG-LINE-NBR→CMC-LINE-NBR
OSG-SEQ→CMC-SEQ
CustorderCUSTORDERNot Required
OSG-COMPANY→COR-COMPANY
OSG-ORDER-NBR→COR-ORDER-NBR

Programs

Updated by (220)