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 BL123 BL217 BL320 BL80.1 BL81.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OSB-COMPANY Numeric 4 AR21.6 BL123
Company The company number represents an BL217 BL320
established company and is entered on BL80.1 BL81.1
all function codes.
OSB-INVC-PREFIX Alpha 2 AR21.6 BL123
Invoice Prefix This field contains the invoice prefix BL217 BL320
that is assigned from either the company BL80.1 BL81.1
or process level, depending on the
invoice-level option chosen.
OSB-INVC-NUMBER Numeric 8 AR21.6 BL123
Invc Number This field contains the invoice number BL217 BL320
assigned by the system. Invoice numbers BL80.1 BL81.1
are assigned at the company or process
level, depending on an invoice-level
option on the company file.
OSB-LINE-NBR Numeric 6 AR21.6 BL123
Line Number This field contains the line number. BL217 BL320
BL80.1 BL81.1
OSB-SEQ Numeric 3 AR21.6 BL123
Sequence Number This field contains the record sequence BL217 BL320
number. BL80.1 BL81.1
OSB-SEGMENT-BLOCK Alpha 103 AR21.6 BL123
User Analysis This field identifies the user analysis BL217 BL320
values included in the transaction. BL80.1 BL81.1
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.
OEINVSGBLK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OSBSET1 COMPANY This index is used to access AR21.6 BL123
INVC-PREFIX invoice-line user analysis records for a BL217 BL320
INVC-NUMBER specific company, invoice prefix, BL80.1 BL81.1
LINE-NBR invoice number, line number, sequence,
SEQ and segment block.
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
|
