Lawson Insight Technical Documentation |
|
OEINVCDTL
OEINVCDTL FILE
Invoice Lot/Serial/Bin Dtls
This file stores lot, serial, and bin information for invoice lines. Only
items that require that information will have records here. A company or
process level option (depending on what level invoicing is processed)
determines whether these actually print on the invoice.
REFERENCED BY
BL121 BL290 BL80.1
UPDATED BY
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL320 BL520 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
OID-COMPANY Numeric 4 BL820 OE114
Element: Company Identifies the AP company if the OE129 OE30.1
resource type = V. Identifies the HR OE30.2 OE30.3
company if the resource type = E. It is OE30.4 OE30.5
blank for type A, P or Q resources. OE30.6 OE30.7
OE30.9 OE530
OE830
OID-INVC-PREFIX Alpha 2 BL820 OE114
Element: Invoice PrefixInvoice prefix is assigned from either OE129 OE30.1
the company or process level depending OE30.2 OE30.3
on the invoice level option chosen. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE530
OE830
OID-INVC-NUMBER Numeric 8 BL820 OE114
Element: Invc Number Invoice number assigned by the system. OE129 OE30.1
Invoice numbers are assigned at the OE30.2 OE30.3
company or process level, depending on OE30.4 OE30.5
an invoice level option on the company OE30.6 OE30.7
file. OE30.9 OE530
OE830
OID-LINE-NBR Numeric 6 BL820 OE114
Element: Line Number Indicates the line number on the OE129 OE30.1
invoice to which this detail record OE30.2 OE30.3
belongs. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE530
OE830
OID-UOM Alpha 4 BL820 OE114
Element: Unit of MeasurThis is the selling unit of measure for OE129 OE30.1
the invoice line this detail is attached OE30.2 OE30.3
to. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE530
OE830
OID-LOT Alpha 10 BL820 OE114
Element: Lot Number Identifier for a homogeneous quantity OE129 OE30.1
of material. Only necessary if the item OE30.2 OE30.3
is defined as lot tracking. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE530
OE830
OID-SUBLOT Alpha 6 BL820 OE114
Element: Sublot Number Identifier for a detail breakdown of a OE129 OE30.1
lot number. Only necessary if the item OE30.2 OE30.3
on this line is defined as lot tracking. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE530
OE830
OID-BIN Alpha 7 BL820 OE114
Element: Bin A storage area for an item or any OE129 OE30.1
number of items. Only necessary if the OE30.2 OE30.3
item on this line is bin tracked. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE530
OE830
OID-SERIAL Alpha 16 BL820 OE114
Element: Serial Number Serial number of this particular line OE129 OE30.1
on the invoice. Only necessary if the OE30.2 OE30.3
item is serial tracked. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE530
OE830
OID-QUANTITY Signed 13.4 BL820 OE114
Element: Quantity This is the requested quantity for the OE129 OE30.1
line item. OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE530
OE830
OID-INVC-CW-QTY Signed 13.4 BL820 OE114
Element: Quantity Invoice catch weight quantity. This OE129 OE30.1
field is valid only for catch weight OE30.2 OE30.3
items. This is used in extended price OE30.4 OE30.5
calculation, but quantity is used for OE30.6 OE30.7
pricing. OE30.9 OE530
OE830
OID-UOM-MULT Signed 13.7 BL820 OE114
Unit of Measure This field contains the multiplier for OE129 OE30.1
Multiplier converting this unit of measure to stock OE30.2 OE30.3
unit of measure. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE530
OE830
OID-LOT-STRING Derived
Element: Lot String If the item is lot tracked, this field
identifies the format for the lot
information to print on the invoice.
OID-BIN-STRING Derived
Element: Bin String If the item is bin tracked, this field
identifies the format in which the bin
number should print on the invoice.
OID-SERIAL-STRING Derived
Element: Serial String If the item is serial tracked, this
field identifies the format in which the
serial number should print on the
invoice.
OID-UOM-STRING Derived
Element: Uom String This field identifies the format of the
unit of measure that should print on the
invoice.
OID-PRINT-STRING Derived
Element: Print String This field determines the format of the
detail for the line to print on the
invoice.
OEINVCDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OIDSET1 COMPANY BL120 BL121
INVC-PREFIX BL122 BL130
INVC-NUMBER BL20.1 BL20.3
LINE-NBR BL21.2 BL21.5
UOM BL29.1 BL29.2
LOT BL290 BL320
SUBLOT BL520 BL80.1
BIN BL820 BL92.1
SERIAL OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE310 OE330
OE530 OE830
OEINVCDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Coline COLINE Required
OID-COMPANY -> COL-COMPANY
OIL-ORDER-NBR -> COL-ORDER-NBR
OIL-LINE-NBR -> COL-LINE-NBR
Iccompany ICCOMPANY Required
OID-COMPANY -> ICC-COMPANY
Itemloc ITEMLOC Required
OID-COMPANY -> ITL-COMPANY
OIL-LOCATION -> ITL-LOCATION
OIL-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
OIL-ITEM -> ITE-ITEM
Oeinvcline OEINVCLINE Required
OID-COMPANY -> OIL-COMPANY
OID-INVC-PREFIX -> OIL-INVC-PREFIX
OID-INVC-NUMBER -> OIL-INVC-NUMBER
OID-LINE-NBR -> OIL-LINE-NBR
|