Lawson Insight Technical Documentation |
|
OEINVSGBLK
OEINVSGBLK FILE
UPDATED BY
AR21.6 BL120 BL122 BL123 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL217 BL29.1 BL29.2
BL320 BL520 BL80.1 BL81.1 BL820 BL92.1
WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OSB-COMPANY Numeric 4 AR21.6 BL120
Element: Company Identifies the AP company if the BL122 BL123
resource type = V. Identifies the HR BL130 BL20.1
company if the resource type = E. It is BL20.3 BL21.2
blank for type A, P or Q resources. BL21.5 BL217
BL29.1 BL29.2
BL320 BL520
BL80.1 BL81.1
BL820 BL92.1
WH20.7
OSB-INVC-PREFIX Alpha 2 AR21.6 BL120
Element: Invc Prefix This field contains the invoice prefix BL122 BL123
that is assigned from either the company BL130 BL20.1
or process level, depending on the BL20.3 BL21.2
invoice-level option chosen. BL21.5 BL217
BL29.1 BL29.2
BL320 BL520
BL80.1 BL81.1
BL820 BL92.1
WH20.7
OSB-INVC-NUMBER Numeric 8 AR21.6 BL120
Element: Invc Number This field contains the invoice number BL122 BL123
assigned by the system. Invoice numbers BL130 BL20.1
are assigned at the company or process BL20.3 BL21.2
level, depending on an invoice-level BL21.5 BL217
option on the company file. BL29.1 BL29.2
BL320 BL520
BL80.1 BL81.1
BL820 BL92.1
WH20.7
OSB-LINE-NBR Numeric 6 AR21.6 BL120
Element: Line Nbr This field contains the line number. BL122 BL123
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL217
BL29.1 BL29.2
BL320 BL520
BL80.1 BL81.1
BL820 BL92.1
WH20.7
OSB-SEQ Numeric 3 AR21.6 BL120
Element: Seq This field contains the record sequence BL122 BL123
number. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL217
BL29.1 BL29.2
BL320 BL520
BL80.1 BL81.1
BL820 BL92.1
WH20.7
OSB-SEGMENT-BLOCK Alpha 103 AR21.6 BL120
Element: Segment Block This field identifies the user analysis BL122 BL123
values included in the transaction. BL130 BL20.1
BL20.3 BL21.2
You can either type up to four values BL21.5 BL217
or use Define (F6) to open the User BL29.1 BL29.2
Analysis Entry subform. Use this subform BL320 BL520
to select the user analysis values you BL80.1 BL81.1
want to include in the transaction. If BL820 BL92.1
you choose to type values, use commas to WH20.7
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.
OEINVSGBLK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OSBSET1 COMPANY AR21.6 BL120
INVC-PREFIX BL122 BL123
INVC-NUMBER BL130 BL20.1
LINE-NBR BL20.3 BL21.2
SEQ BL21.5 BL217
BL29.1 BL29.2
BL320 BL520
BL80.1 BL81.1
BL820 BL92.1
WH20.7
OEINVSGBLK FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oeinvcline OEINVCLINE Not Required
OSB-COMPANY -> OIL-COMPANY
OSB-INVC-PREFIX -> OIL-INVC-PREFIX
OSB-INVC-NUMBER -> OIL-INVC-NUMBER
OSB-LINE-NBR -> OIL-LINE-NBR
Oeinvcmisc OEINVCMISC Not 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
Oeinvoice OEINVOICE Not Required
OSB-COMPANY -> OEI-COMPANY
OSB-INVC-PREFIX -> OEI-INVC-PREFIX
OSB-INVC-NUMBER -> OEI-INVC-NUMBER
|