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

PHI3.1

UPDATED BY

WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OIN-COMPANY            Numeric 4
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

OIN-INVC-TYPE          Alpha 4
Element: Invoice 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)
Element: Description   The invoice type description.

OIN-INVC-CRED-FL       Alpha 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
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                                   WH20.7
Element: All Flag      Indicates whether this invoice type has
                       ever been used.
                       N = No
                       Y = Yes

OIN-INVC-ACT-FL        Alpha 1
Element: Status        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: Standard CommeLine 1 of summary at top of page.

OIN-SUMM-TOP-COMM2     Alpha 4
Element: Standard CommeLine 2 of summary at top of page.

OIN-SUMM-TOP-COMM3     Alpha 4
Element: Standard CommeLine 3 of summary at top of page.

OIN-SUMM-TRL-COMM1     Alpha 4
Element: Standard CommeLine 1 of summary at bottom of page.

OIN-SUMM-TRL-COMM2     Alpha 4
Element: Standard CommeLine 2 of summary at bottom of page.

OIN-SUMM-TRL-COMM3     Alpha 4
Element: Standard CommeLine 3 of summary at bottom of page.

                         OEINVCTYPE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OINSET1   COMPANY                                                PHI3.1  WH20.2
          INVC-TYPE                                              WH20.7

                         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