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    AR210     AR219     AR48.1    AR48.3
AR501     AR550     BL02.1    BL04.1    BL121     BL123
BL125     BL202     BL204     BL217     BL219     BL220
BL231     BL246     BL290     BL291     BL31.1    BL31.2
BL31.3    BL31.5    BL31.7    BL32.3    BL32.4    BL33.1
BL331     BL34.1    BL46.1    BL46.2    BL530     BL80.1
BL80.3    BL802     BL81.1    BL82.1    BL85.1    BL85.2
BL90.1    BR10.1    BR11.1    BR120     BR121     BR210
BR211     BR220     BR420     BR450     BRIP.1    IC02.1
PR197     TX140     TX40.1    WH110     WH120     WH130
WH21.2    WH33.1    WH33.2    WH33.3    WH33.4    WH33.5
WH33.6    WH33.8    WH33.9    WH34.1    WH34.2    WH34.3
WH34.4

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CEP-COMPANY          Numeric 4                                   AC551   AR08.1
Company              The company number represents an            AR210   AR219
                     established company and is entered on       AR48.1  AR48.3
                     all function codes.                         AR501   AR550
                                                                 BL02.1  BL04.1
                                                                 BL121   BL123
                                                                 BL125   BL202
                                                                 BL204   BL217
                                                                 BL219   BL220
                                                                 BL231   BL246
                                                                 BL290   BL291
                                                                 BL31.1  BL31.2
                                                                 BL31.3  BL31.5
                                                                 BL31.7  BL32.3
                                                                 BL32.4  BL33.1
                                                                 BL331   BL34.1
                                                                 BL46.1  BL46.2
                                                                 BL530   BL80.1
                                                                 BL80.3  BL802
                                                                 BL81.1  BL82.1
                                                                 BL85.1  BL85.2
                                                                 BL90.1  BR10.1
                                                                 BR11.1  BR120
                                                                 BR121   BR210
                                                                 BR211   BR220
                                                                 BR420   BR450
                                                                 BRIP.1  IC02.1
                                                                 PR197   TX140
                                                                 TX40.1  WH110
                                                                 WH120   WH130
                                                                 ...

CEP-CUSTOMER         Alpha 9  (Right Justified)                  AC551   AR08.1
Customer Number      This field contains the number that         AR210   AR219
                     represents a customer.                      AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BL02.1  BL04.1
                                                                 BL121   BL123
                                                                 BL125   BL202
                                                                 BL204   BL217
                                                                 BL219   BL220
                                                                 BL231   BL246
                                                                 BL290   BL291
                                                                 BL31.1  BL31.2
                                                                 BL31.3  BL31.5
                                                                 BL31.7  BL32.3
                                                                 BL32.4  BL33.1
                                                                 BL331   BL34.1
                                                                 BL46.1  BL46.2
                                                                 BL530   BL80.1
                                                                 BL80.3  BL802
                                                                 BL81.1  BL82.1
                                                                 BL85.1  BL85.2
                                                                 BL90.1  BR10.1
                                                                 BR11.1  BR120
                                                                 BR121   BR210
                                                                 BR211   BR220
                                                                 BR420   BR450
                                                                 BRIP.1  IC02.1
                                                                 PR197   TX140
                                                                 TX40.1  WH110
                                                                 WH120   WH130
                                                                 ...

CEP-EP-TYPE          Alpha 5                                     AC551   AR08.1
Ep Type                                                          AR210   AR219
                                                                 AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BL02.1  BL04.1
                                                                 BL121   BL123
                                                                 BL125   BL202
                                                                 BL204   BL217
                                                                 BL219   BL220
                                                                 BL231   BL246
                                                                 BL290   BL291
                                                                 BL31.1  BL31.2
                                                                 BL31.3  BL31.5
                                                                 BL31.7  BL32.3
                                                                 BL32.4  BL33.1
                                                                 BL331   BL34.1
                                                                 BL46.1  BL46.2
                                                                 BL530   BL80.1
                                                                 BL80.3  BL802
                                                                 BL81.1  BL82.1
                                                                 BL85.1  BL85.2
                                                                 BL90.1  BR10.1
                                                                 BR11.1  BR120
                                                                 BR121   BR210
                                                                 BR211   BR220
                                                                 BR420   BR450
                                                                 BRIP.1  IC02.1
                                                                 PR197   TX140
                                                                 TX40.1  WH110
                                                                 WH120   WH130
                                                                 ...

CEP-EP-ACCOUNT       Alpha 32                                    AC551   AR08.1
Ep Account                                                       AR210   AR219
                                                                 AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BL02.1  BL04.1
                                                                 BL121   BL123
                                                                 BL125   BL202
                                                                 BL204   BL217
                                                                 BL219   BL220
                                                                 BL231   BL246
                                                                 BL290   BL291
                                                                 BL31.1  BL31.2
                                                                 BL31.3  BL31.5
                                                                 BL31.7  BL32.3
                                                                 BL32.4  BL33.1
                                                                 BL331   BL34.1
                                                                 BL46.1  BL46.2
                                                                 BL530   BL80.1
                                                                 BL80.3  BL802
                                                                 BL81.1  BL82.1
                                                                 BL85.1  BL85.2
                                                                 BL90.1  BR10.1
                                                                 BR11.1  BR120
                                                                 BR121   BR210
                                                                 BR211   BR220
                                                                 BR420   BR450
                                                                 BRIP.1  IC02.1
                                                                 PR197   TX140
                                                                 TX40.1  WH110
                                                                 WH120   WH130
                                                                 ...

CEP-EP-EXP-DATE      Numeric 8  (yyyymmdd)                       AC551   AR08.1
Ep Exp Date                                                      AR210   AR219
                                                                 AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BL02.1  BL04.1
                                                                 BL121   BL123
                                                                 BL125   BL202
                                                                 BL204   BL217
                                                                 BL219   BL220
                                                                 BL231   BL246
                                                                 BL290   BL291
                                                                 BL31.1  BL31.2
                                                                 BL31.3  BL31.5
                                                                 BL31.7  BL32.3
                                                                 BL32.4  BL33.1
                                                                 BL331   BL34.1
                                                                 BL46.1  BL46.2
                                                                 BL530   BL80.1
                                                                 BL80.3  BL802
                                                                 BL81.1  BL82.1
                                                                 BL85.1  BL85.2
                                                                 BL90.1  BR10.1
                                                                 BR11.1  BR120
                                                                 BR121   BR210
                                                                 BR211   BR220
                                                                 BR420   BR450
                                                                 BRIP.1  IC02.1
                                                                 PR197   TX140
                                                                 TX40.1  WH110
                                                                 WH120   WH130
                                                                 ...

CEP-EP-STATUS        Alpha 1                                     AC551   AR08.1
Ep Status            A = Active                                  AR210   AR219
                     I = Inactive                                AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BL02.1  BL04.1
                                                                 BL121   BL123
                                                                 BL125   BL202
                                                                 BL204   BL217
                                                                 BL219   BL220
                                                                 BL231   BL246
                                                                 BL290   BL291
                                                                 BL31.1  BL31.2
                                                                 BL31.3  BL31.5
                                                                 BL31.7  BL32.3
                                                                 BL32.4  BL33.1
                                                                 BL331   BL34.1
                                                                 BL46.1  BL46.2
                                                                 BL530   BL80.1
                                                                 BL80.3  BL802
                                                                 BL81.1  BL82.1
                                                                 BL85.1  BL85.2
                                                                 BL90.1  BR10.1
                                                                 BR11.1  BR120
                                                                 BR121   BR210
                                                                 BR211   BR220
                                                                 BR420   BR450
                                                                 BRIP.1  IC02.1
                                                                 PR197   TX140
                                                                 TX40.1  WH110
                                                                 WH120   WH130
                                                                 ...

                         CUSTEP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CEPSET1   COMPANY                                                AC551   AR08.1
          CUSTOMER                                               AR210   AR219
          EP-TYPE                                                AR48.1  AR48.3
          EP-ACCOUNT                                             AR501   AR550
                                                                 BL02.1  BL04.1
                                                                 BL121   BL123
                                                                 BL125   BL202
                                                                 BL204   BL217
                                                                 BL219   BL220
                                                                 BL231   BL246
                                                                 BL290   BL291
                                                                 BL31.1  BL31.2
                                                                 BL31.3  BL31.5
                                                                 BL31.7  BL32.3
                                                                 BL32.4  BL33.1
                                                                 ...