OEINVSGBLK – No description in the Lawson data dictionary

System
Billing (BL)
Prefix
OSB
Primary key
COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR, SEQ
Fields
6
Updated by
1 program
Referenced by
0 programs

OEINVSGBLK is a Lawson Billing table (prefix OSB); no description in the lawson data dictionary. It is indexed by COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR, SEQ (OSBSET1). It is related 1:1 to OEINVCLINE, OEINVCMISC and OEINVOICE. It is updated by WH20.7. The table has 6 fields, 1 index and 3 documented relations.

About OEINVSGBLK

No description in the Lawson data dictionary.

Fields (6)

Column = COBOL field name without the OSB- 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
#OSB-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.WH20.7
#OSB-INVC-PREFIX PK
INVC_PREFIX		Alpha 2This field contains the invoice prefix that is assigned from either the company or process level, depending on the invoice-level option chosen.WH20.7
#OSB-INVC-NUMBER PK
INVC_NUMBER		Numeric 8This field contains the invoice number assigned by the system. Invoice numbers are assigned at the company or process level, depending on an invoice-level option on the company file.WH20.7
#OSB-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.WH20.7
#OSB-SEQ PK
SEQ		Numeric 3This field contains the record sequence number.WH20.7
#OSB-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.WH20.7

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
OSBSET1
  1. COMPANY
  2. INVC-PREFIX
  3. INVC-NUMBER
  4. LINE-NBR
  5. SEQ
PrimaryWH20.7

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
OeinvclineOEINVCLINENot Required
OSB-COMPANY→OIL-COMPANY
OSB-INVC-PREFIX→OIL-INVC-PREFIX
OSB-INVC-NUMBER→OIL-INVC-NUMBER
OSB-LINE-NBR→OIL-LINE-NBR
OeinvcmiscOEINVCMISCNot Required
OSB-COMPANY→OIM-COMPANY
OSB-INVC-PREFIX→OIM-INVC-PREFIX
OSB-INVC-NUMBER→OIM-INVC-NUMBER
OSB-LINE-NBR→OIM-LINE-NBR
OSB-SEQ→OIM-SEQ
OeinvoiceOEINVOICENot Required
OSB-COMPANY→OEI-COMPANY
OSB-INVC-PREFIX→OEI-INVC-PREFIX
OSB-INVC-NUMBER→OEI-INVC-NUMBER

Programs

Updated by (1)