Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            OECREDCARD FILE

                        Order Entry Credit Card

The Order Entry Credit Card file carries any credit card records set up in
the Lawson Order Entry and Billing systems.  If a customer will be paying
their account via credit card, the credit card must first be added to this
file and then placed on the customer master record.  The system will then
automatically assume the customer is paying via credit card when an order or
invoice is added to their account.  Invoices produced for these customers will
interface into the Lawson Accounts Receivable system as closed or historical
invoices.

REFERENCED BY

AR08.1    AR10.1    AR501     AR550     BL120     BL122
BL123     BL130     BL20.1    BL20.3    BL21.2    BL21.5
BL213     BL29.1    BL29.2    BL520     BL80.1    BL820
BL940     OE112     OE294     OE30.1    OE30.2    OE30.3
OE30.4    OE30.5    OE30.6    OE30.7    OE30.9    OE830
OE950

UPDATED BY

BL13.1    BL92.1    OE10.1    OE10.2    OE10.3    OE10.4
OE10.5    OE10.6    OE10.7    OE10.8    OE11.1    OE11.4
OE11.8    OE11.9    OE110     OE113     OE114     OE129
OE14.4    OE15.1    OE15.2    OE15.3    OE15.4    OE15.5
OE15.7    OE510     OE810     OE920     WH20.7

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

OCR-COMPANY          Numeric 4                                   BL13.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

OCR-CC-TYPE          Alpha 2                                     BL13.1
Credit Card Type     This user-defined field identifies the
                     credit card type.

OCR-CC-DESC          Alpha 30                                    BL122   BL13.1
Credit Card Type     The description of the credit card.         OE112   OE114
Description                                                      OE294

OCR-AR-CODE          Alpha 4                                     BL13.1
Accounts Receivable  Enter the accounts receivable code that
Code                 should be debited when an order or
                     invoice is processed for this customer.

OCR-CC-USED-FL       Alpha 1                                     BL13.1  BL92.1
Credit Card Type     Indicates whether or not the credit         OE10.1  OE10.2
Used Flag            card has been used.                         OE10.3  OE10.4
                     Y = Yes                                     OE10.5  OE10.6
                     N = No                                      OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE113
                                                                 OE114   OE129
                                                                 OE14.4  OE15.1
                                                                 OE15.2  OE15.3
                                                                 OE15.4  OE15.5
                                                                 OE15.7  OE510
                                                                 OE810   OE920
                                                                 WH20.7

OCR-CC-ACT-FL        Alpha 1                                     BL13.1
Credit Card Type     Indicates if the credit card is active
Active Flag          or inactive.
                     A = Active
                     I = Inactive

                         OECREDCARD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OCRSET1   COMPANY                                                AR08.1  AR10.1
          CC-TYPE                                                AR501   AR550
                                                                 BL120   BL122
                                                                 BL123   BL13.1
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL213
                                                                 BL29.1  BL29.2
                                                                 BL520   BL80.1
                                                                 BL820   BL92.1
                                                                 BL940   OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 ...

                         OECREDCARD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcode         ARCODE       Required
                            When OCR-AR-CODE != Spaces

                            OCR-COMPANY    -> RCD-COMPANY
                            OCR-AR-CODE    -> RCD-AR-CODE

Oecompany      OECOMPANY    Required

                            OCR-COMPANY    -> OEC-COMPANY