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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
OSGSET1COMPANY, ORDER-NBR, LINE-NBR, SEQPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

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

Programs

Updated by (220)