Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEINVCTYPE


                            OEINVCTYPE FILE

                              Invoice Type

This file stores the different invoice types set up by users.  Every order or
invoice processed in the system require an invoice type.  These can be placed
onto the order types as a default.

REFERENCED BY

BL206     BL80.1

UPDATED BY

BL00.1    BL01.1    BL06.1    BL120     BL121     BL122
BL123     BL130     BL20.1    BL20.3    BL200     BL201
BL21.2    BL21.5    BL29.1    BL29.2    BL30.1    BL30.2
BL30.3    BL30.5    BL31.1    BL31.2    BL31.3    BL31.5
BL31.7    BL32.1    BL32.2    BL32.3    BL32.4    BL520
BL820     BL92.1    BL98.1    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OIN-COMPANY            Numeric 4                                 BL06.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

OIN-INVC-TYPE          Alpha 4                                   BL06.1
Element: Invc Type     A user-defined code identifying a
                       specific type of invoice that users want
                       to define. For instance, CRED may define
                       a credit memo invoice when used in the
                       system.

OIN-INVC-DESC          Alpha 30  (Lower Case)                    BL06.1
Element: Description   The invoice type description.

OIN-INVC-CRED-FL       Alpha 1                                   BL06.1
Element: All Flag      Flag indicating whether or not this
                       invoice type is a credit invoice.
                       Y = Yes
                       N = No

OIN-INVC-RTRN-FL       Alpha 1                                   BL06.1
Element: All Flag      Flag indicating whether this invoice
                       type will allow returns to stock. Used
                       with credit type invoices.
                       N = No
                       Y = Yes

OIN-INVC-USED-FL       Alpha 1                                   BL00.1  BL01.1
Element: All Flag      Indicates whether this invoice type has   BL06.1  BL120
                       ever been used.                           BL121   BL122
                       N = No                                    BL123   BL130
                       Y = Yes                                   BL20.1  BL20.3
                                                                 BL200   BL201
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL30.1  BL30.2
                                                                 BL30.3  BL30.5
                                                                 BL31.1  BL31.2
                                                                 BL31.3  BL31.5
                                                                 BL31.7  BL32.1
                                                                 BL32.2  BL32.3
                                                                 BL32.4  BL520
                                                                 BL820   BL92.1
                                                                 BL98.1  WH20.7

OIN-INVC-ACT-FL        Alpha 1                                   BL06.1
Element: Active Flag   Indicates whether this invoice type
                       code is active.
                       A = Active
                       I = Inactive

OIN-FORMAT-FL          Alpha 1
Element: All Flag      Select Yes to use alternate invoice
                       format.
                       Y = Yes
                       N = No

OIN-SUMMARY-FL         Alpha 1
Element: All Flag      Select Yes to print summary page.
                       Y = Yes
                       N = No

OIN-SUMM-TOP-COMM1     Alpha 4
Element: Std Comm      Line 1 of summary at top of page.

OIN-SUMM-TOP-COMM2     Alpha 4
Element: Std Comm      Line 2 of summary at top of page.

OIN-SUMM-TOP-COMM3     Alpha 4
Element: Std Comm      Line 3 of summary at top of page.

OIN-SUMM-TRL-COMM1     Alpha 4
Element: Std Comm      Line 1 of summary at bottom of page.

OIN-SUMM-TRL-COMM2     Alpha 4
Element: Std Comm      Line 2 of summary at bottom of page.

OIN-SUMM-TRL-COMM3     Alpha 4
Element: Std Comm      Line 3 of summary at bottom of page.

                         OEINVCTYPE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OINSET1   COMPANY                                                BL00.1  BL01.1
          INVC-TYPE                                              BL06.1  BL120
                                                                 BL121   BL122
                                                                 BL123   BL130
                                                                 BL20.1  BL20.3
                                                                 BL20.5  BL20.6
                                                                 BL200   BL201
                                                                 BL206   BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL30.1
                                                                 BL30.2  BL30.3
                                                                 BL30.5  BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.1  BL32.2
                                                                 ...

                         OEINVCTYPE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecompany      OECOMPANY    Required

                            OIN-COMPANY           -> OEC-COMPANY

Top Comm 1     OECOMMHDR    Not Required

                            OIN-COMPANY           -> OCH-COMPANY
                            OIN-SUMM-TOP-COMM1    -> OCH-STD-COMM

Top Comm 2     OECOMMHDR    Not Required

                            OIN-COMPANY           -> OCH-COMPANY
                            OIN-SUMM-TOP-COMM2    -> OCH-STD-COMM

Top Comm 3     OECOMMHDR    Not Required

                            OIN-COMPANY           -> OCH-COMPANY
                            OIN-SUMM-TOP-COMM3    -> OCH-STD-COMM

Trl Comm 1     OECOMMHDR    Not Required

                            OIN-COMPANY           -> OCH-COMPANY
                            OIN-SUMM-TRL-COMM1    -> OCH-STD-COMM

Trl Comm 2     OECOMMHDR    Not Required

                            OIN-COMPANY           -> OCH-COMPANY
                            OIN-SUMM-TRL-COMM2    -> OCH-STD-COMM

Trl Comm 3     OECOMMHDR    Not Required

                            OIN-COMPANY           -> OCH-COMPANY
                            OIN-SUMM-TRL-COMM3    -> OCH-STD-COMM