Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              CUSTEP FILE

UPDATED BY

AC551     AR08.1    AR10.1    AR10.5    AR210     AR219
AR48.1    AR48.3    AR501     AR550     BR10.1    BR11.1
BR120     BR121     BR210     BR211     BR220     BR420
BR450     BRIP.1    CB06.2    IC02.1    IC531     MX223
PBIP.1    PR197     TX140     TX40.1    WH110     WH120
WH130     WH132     WH190     WH20.2    WH20.7    WH21.2
WH224     WH30.1    WH30.2    WH30.3    WH30.4    WH31.1
WH31.2    WH31.3    WH31.4    WH32.1    WH32.2    WH32.3
WH32.4    WH33.5    WH34.1    WH34.2    WH34.3    WH34.4
WH40.1    WH40.2    WH520     WH830

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CEP-COMPANY          Numeric 4                                   AC551   AR08.1
Company              The company number represents an            AR10.1  AR10.5
                     established company and is entered on       AR210   AR219
                     all function codes.                         AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BR10.1  BR11.1
                                                                 BR120   BR121
                                                                 BR210   BR211
                                                                 BR220   BR420
                                                                 BR450   BRIP.1
                                                                 CB06.2  IC02.1
                                                                 IC531   MX223
                                                                 PBIP.1  PR197
                                                                 TX140   TX40.1
                                                                 WH110   WH120
                                                                 WH130   WH132
                                                                 WH190   WH20.2
                                                                 WH20.7  WH21.2
                                                                 WH224   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.5
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

CEP-CUSTOMER         Alpha 9  (Right Justified)                  AC551   AR08.1
Customer Number      This field contains the number that         AR10.1  AR10.5
                     represents a customer.                      AR210   AR219
                                                                 AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BR10.1  BR11.1
                                                                 BR120   BR121
                                                                 BR210   BR211
                                                                 BR220   BR420
                                                                 BR450   BRIP.1
                                                                 CB06.2  IC02.1
                                                                 IC531   MX223
                                                                 PBIP.1  PR197
                                                                 TX140   TX40.1
                                                                 WH110   WH120
                                                                 WH130   WH132
                                                                 WH190   WH20.2
                                                                 WH20.7  WH21.2
                                                                 WH224   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.5
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

CEP-EP-TYPE          Alpha 5                                     AC551   AR08.1
Ep Type                                                          AR10.1  AR10.5
                                                                 AR210   AR219
                                                                 AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BR10.1  BR11.1
                                                                 BR120   BR121
                                                                 BR210   BR211
                                                                 BR220   BR420
                                                                 BR450   BRIP.1
                                                                 CB06.2  IC02.1
                                                                 IC531   MX223
                                                                 PBIP.1  PR197
                                                                 TX140   TX40.1
                                                                 WH110   WH120
                                                                 WH130   WH132
                                                                 WH190   WH20.2
                                                                 WH20.7  WH21.2
                                                                 WH224   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.5
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

CEP-EP-ACCOUNT       Alpha 32                                    AC551   AR08.1
Ep Account                                                       AR10.1  AR10.5
                                                                 AR210   AR219
                                                                 AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BR10.1  BR11.1
                                                                 BR120   BR121
                                                                 BR210   BR211
                                                                 BR220   BR420
                                                                 BR450   BRIP.1
                                                                 CB06.2  IC02.1
                                                                 IC531   MX223
                                                                 PBIP.1  PR197
                                                                 TX140   TX40.1
                                                                 WH110   WH120
                                                                 WH130   WH132
                                                                 WH190   WH20.2
                                                                 WH20.7  WH21.2
                                                                 WH224   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.5
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

CEP-EP-EXP-DATE      Numeric 8  (yyyymmdd)                       AC551   AR08.1
Ep Exp Date                                                      AR10.1  AR10.5
                                                                 AR210   AR219
                                                                 AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BR10.1  BR11.1
                                                                 BR120   BR121
                                                                 BR210   BR211
                                                                 BR220   BR420
                                                                 BR450   BRIP.1
                                                                 CB06.2  IC02.1
                                                                 IC531   MX223
                                                                 PBIP.1  PR197
                                                                 TX140   TX40.1
                                                                 WH110   WH120
                                                                 WH130   WH132
                                                                 WH190   WH20.2
                                                                 WH20.7  WH21.2
                                                                 WH224   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.5
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

CEP-EP-STATUS        Alpha 1                                     AC551   AR08.1
Ep Status            A = Active                                  AR10.1  AR10.5
                     I = Inactive                                AR210   AR219
                                                                 AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BR10.1  BR11.1
                                                                 BR120   BR121
                                                                 BR210   BR211
                                                                 BR220   BR420
                                                                 BR450   BRIP.1
                                                                 CB06.2  IC02.1
                                                                 IC531   MX223
                                                                 PBIP.1  PR197
                                                                 TX140   TX40.1
                                                                 WH110   WH120
                                                                 WH130   WH132
                                                                 WH190   WH20.2
                                                                 WH20.7  WH21.2
                                                                 WH224   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.5
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

CEP-DEFAULT-PMT      Alpha 1                                     AC551   AR08.1
Default Pmt                                                      AR10.1  AR10.5
                                                                 AR210   AR219
                                                                 AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BR10.1  BR11.1
                                                                 BR120   BR121
                                                                 BR210   BR211
                                                                 BR220   BR420
                                                                 BR450   BRIP.1
                                                                 CB06.2  IC02.1
                                                                 IC531   MX223
                                                                 PBIP.1  PR197
                                                                 TX140   TX40.1
                                                                 WH110   WH120
                                                                 WH130   WH132
                                                                 WH190   WH20.2
                                                                 WH20.7  WH21.2
                                                                 WH224   WH30.1
                                                                 WH30.2  WH30.3
                                                                 WH30.4  WH31.1
                                                                 WH31.2  WH31.3
                                                                 WH31.4  WH32.1
                                                                 WH32.2  WH32.3
                                                                 WH32.4  WH33.5
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4
                                                                 WH40.1  WH40.2
                                                                 WH520   WH830

                         CUSTEP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CEPSET1   COMPANY                                                AC551   AR08.1
          CUSTOMER                                               AR10.1  AR10.5
          EP-TYPE                                                AR210   AR219
          EP-ACCOUNT                                             AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BR10.1  BR11.1
                                                                 BR120   BR121
                                                                 BR210   BR211
                                                                 BR220   BR420
                                                                 BR450   BRIP.1
                                                                 CB06.2  IC02.1
                                                                 IC531   MX223
                                                                 PBIP.1  PR197
                                                                 TX140   TX40.1
                                                                 WH110   WH120
                                                                 ...