OEINVSGBLK FILE
Invoice Segment Block
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
BL120 BL123 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL320 BL520 BL80.1
BL81.1 BL820 BL92.1 BL940 OE114 OE129
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE310 OE330 OE830 OE950
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OSB-COMPANY Numeric 4 BL120 BL123
Company The company number represents an BL130 BL20.1
established company and is entered on BL20.3 BL21.2
all function codes. BL21.5 BL29.1
BL29.2 BL320
BL520 BL80.1
BL81.1 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE310 OE330
OE830 OE950
OSB-INVC-PREFIX Alpha 2 BL120 BL123
Invoice Prefix This field contains the invoice prefix BL130 BL20.1
that is assigned from either the company BL20.3 BL21.2
or process level, depending on the BL21.5 BL29.1
invoice-level option chosen. BL29.2 BL320
BL520 BL80.1
BL81.1 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE310 OE330
OE830 OE950
OSB-INVC-NUMBER Numeric 8 BL120 BL123
Invc Number This field contains the invoice number BL130 BL20.1
assigned by the system. Invoice numbers BL20.3 BL21.2
are assigned at the company or process BL21.5 BL29.1
level, depending on an invoice-level BL29.2 BL320
option on the company file. BL520 BL80.1
BL81.1 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE310 OE330
OE830 OE950
OSB-LINE-NBR Numeric 6 BL120 BL123
Line Number This field contains the line number. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL320
BL520 BL80.1
BL81.1 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE310 OE330
OE830 OE950
OSB-SEQ Numeric 3 BL120 BL123
Sequence Number This field contains the record sequence BL130 BL20.1
number. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL320
BL520 BL80.1
BL81.1 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE310 OE330
OE830 OE950
OSB-SEGMENT-BLOCK Alpha 103 BL120 BL123
User Analysis This field identifies the user analysis BL130 BL20.1
values included in the transaction. BL20.3 BL21.2
BL21.5 BL29.1
You can either type up to four values BL29.2 BL320
or use Define (F6) to open the User BL520 BL80.1
Analysis Entry subform. Use this subform BL81.1 BL820
to select the user analysis values you BL92.1 BL940
want to include in the transaction. If OE114 OE129
you choose to type values, use commas to OE30.1 OE30.2
separate them. For example: OE30.3 OE30.4
value1,value2,value3,value4 OE30.5 OE30.6
OE30.7 OE30.9
There are three conditions that affect OE310 OE330
how you can select user analysis values. OE830 OE950
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 This index is used to access BL120 BL123
INVC-PREFIX invoice-line user analysis records for a BL130 BL20.1
INVC-NUMBER specific company, invoice prefix, BL20.3 BL21.2
LINE-NBR invoice number, line number, sequence, BL21.5 BL29.1
SEQ and segment block. BL29.2 BL320
BL520 BL80.1
BL81.1 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE310 OE330
OE830 OE950
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
|