Lawson Insight Technical Documentation |
|
OEINVSGBLK
OEINVSGBLK FILE
This file relates to user analysis values from the Billing system Invoice
file and its related files. User analysis data is added to this file as
invoice options, line options, or add-on charge additional information in the
Billing system.
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
OE114 OE129 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE310 OE330
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE310 OE330
OE530 OE830
OSB-INVC-PREFIX Alpha 2 AR21.6 BL120
Element: Invoice PrefixThis 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE310 OE330
OE530 OE830
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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE310 OE330
OE530 OE830
OSB-LINE-NBR Numeric 6 AR21.6 BL120
Element: Line Number 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE310 OE330
OE530 OE830
OSB-SEQ Numeric 3 AR21.6 BL120
Element: Sequence NumbeThis 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
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE310 OE330
OE530 OE830
OSB-SEGMENT-BLOCK Alpha 103 AR21.6 BL120
Element: User Analysis 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 OE114 OE129
separate them. For example: OE30.1 OE30.2
value1,value2,value3,value4 OE30.3 OE30.4
OE30.5 OE30.6
There are three conditions that affect OE30.7 OE30.9
how you can select user analysis values. OE310 OE330
See the User Analysis Entry form help or OE530 OE830
the Strategic Ledger procedures manual
for additional information.
OEINVSGBLK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OSBSET1 COMPANY This index is used to access AR21.6 BL120
INVC-PREFIX invoice-line user analysis records for a BL122 BL123
INVC-NUMBER specific company, invoice prefix, BL130 BL20.1
LINE-NBR invoice number, line number, sequence, BL20.3 BL21.2
SEQ and segment block. BL21.5 BL217
BL29.1 BL29.2
BL320 BL520
BL80.1 BL81.1
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE310 OE330
...
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
|