Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CUSTEP


                              CUSTEP FILE

UPDATED BY

AC56.1    AC560     AR08.1    AR09.1    AR10.1    AR10.5
AR120     AR210     AR219     AR301     AR48.1    AR48.3
AR501     AR550     BL02.1    BL04.1    BL10.1    BL120
BL121     BL122     BL123     BL125     BL130     BL20.1
BL20.3    BL20.6    BL202     BL204     BL21.2    BL21.5
BL217     BL219     BL220     BL231     BL246     BL29.1
BL29.2    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    BL520     BL530     BL546
BL80.1    BL80.3    BL802     BL81.1    BL82.1    BL820
BL85.1    BL85.2    BL90.1    BL92.1    BR00.1    BR00.2
BR02.3    BR10.1    BR10.9    BR11.1    BR120     BR121
BR122     BR123     BR140     BR151     BR152     BR155
BR156     BR16.1    BR16.2    BR17.1    BR180     BR19.1
BR20.1    BR20.2    BR20.3    BR20.4    BR20.5    BR20.7
BR21.2    BR210     BR211     BR216     BR217     BR220
BR251     BR252     BR253     BR400     BR420     BR45.1
BR450     BR46.1    BR46.2    BR46.4    BR51.1    BR51.2
BR52.1    BR52.2    BR521     BR53.1    BR55.2    BR70.1
BR70.2    BR91.1    BRIP.1    CB06.2    IC02.1    PW110
PW550     TX140     TX40.1    WH110     WH120     WH130
WH132     WH190     WH20.1    WH20.2    WH20.7    WH21.2
WH224     WH226     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                                 AC56.1  AC560
Element: Company       Identifies the AP company if the          AR08.1  AR09.1
                       resource type = V.  Identifies the HR     AR10.1  AR10.5
                       company if the resource type = E.  It is  AR120   AR210
                       blank for type A, P or Q resources.       AR219   AR301
                                                                 AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BL02.1  BL04.1
                                                                 BL10.1  BL120
                                                                 BL121   BL122
                                                                 BL123   BL125
                                                                 BL130   BL20.1
                                                                 BL20.3  BL20.6
                                                                 BL202   BL204
                                                                 BL21.2  BL21.5
                                                                 BL217   BL219
                                                                 BL220   BL231
                                                                 BL246   BL29.1
                                                                 BL29.2  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  BL520
                                                                 BL530   BL546
                                                                 BL80.1  BL80.3
                                                                 BL802   BL81.1
                                                                 BL82.1  BL820
                                                                 ...

CEP-CUSTOMER           Alpha 9  (Right Justified)                AC56.1  AC560
Element: Customer      This field contains the number that       AR08.1  AR09.1
                       represents a customer.                    AR10.1  AR10.5
                                                                 AR120   AR210
                                                                 AR219   AR301
                                                                 AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BL02.1  BL04.1
                                                                 BL10.1  BL120
                                                                 BL121   BL122
                                                                 BL123   BL125
                                                                 BL130   BL20.1
                                                                 BL20.3  BL20.6
                                                                 BL202   BL204
                                                                 BL21.2  BL21.5
                                                                 BL217   BL219
                                                                 BL220   BL231
                                                                 BL246   BL29.1
                                                                 BL29.2  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  BL520
                                                                 BL530   BL546
                                                                 BL80.1  BL80.3
                                                                 BL802   BL81.1
                                                                 BL82.1  BL820
                                                                 ...

CEP-EP-TYPE            Alpha 5                                   AC56.1  AC560
Element: Ep Type                                                 AR08.1  AR09.1
                                                                 AR10.1  AR10.5
                                                                 AR120   AR210
                                                                 AR219   AR301
                                                                 AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BL02.1  BL04.1
                                                                 BL10.1  BL120
                                                                 BL121   BL122
                                                                 BL123   BL125
                                                                 BL130   BL20.1
                                                                 BL20.3  BL20.6
                                                                 BL202   BL204
                                                                 BL21.2  BL21.5
                                                                 BL217   BL219
                                                                 BL220   BL231
                                                                 BL246   BL29.1
                                                                 BL29.2  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  BL520
                                                                 BL530   BL546
                                                                 BL80.1  BL80.3
                                                                 BL802   BL81.1
                                                                 BL82.1  BL820
                                                                 ...

CEP-EP-ACCOUNT         Alpha 32                                  AC56.1  AC560
Element: Ep Account                                              AR08.1  AR09.1
                                                                 AR10.1  AR10.5
                                                                 AR120   AR210
                                                                 AR219   AR301
                                                                 AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BL02.1  BL04.1
                                                                 BL10.1  BL120
                                                                 BL121   BL122
                                                                 BL123   BL125
                                                                 BL130   BL20.1
                                                                 BL20.3  BL20.6
                                                                 BL202   BL204
                                                                 BL21.2  BL21.5
                                                                 BL217   BL219
                                                                 BL220   BL231
                                                                 BL246   BL29.1
                                                                 BL29.2  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  BL520
                                                                 BL530   BL546
                                                                 BL80.1  BL80.3
                                                                 BL802   BL81.1
                                                                 BL82.1  BL820
                                                                 ...

CEP-EP-EXP-DATE        Numeric 8  (yyyymmdd)                     AC56.1  AC560
Element: Ep Exp Date                                             AR08.1  AR09.1
                                                                 AR10.1  AR10.5
                                                                 AR120   AR210
                                                                 AR219   AR301
                                                                 AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BL02.1  BL04.1
                                                                 BL10.1  BL120
                                                                 BL121   BL122
                                                                 BL123   BL125
                                                                 BL130   BL20.1
                                                                 BL20.3  BL20.6
                                                                 BL202   BL204
                                                                 BL21.2  BL21.5
                                                                 BL217   BL219
                                                                 BL220   BL231
                                                                 BL246   BL29.1
                                                                 BL29.2  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  BL520
                                                                 BL530   BL546
                                                                 BL80.1  BL80.3
                                                                 BL802   BL81.1
                                                                 BL82.1  BL820
                                                                 ...

CEP-EP-STATUS          Alpha 1                                   AC56.1  AC560
Element: Ep Status     A = Active                                AR08.1  AR09.1
                       I = Inactive                              AR10.1  AR10.5
                                                                 AR120   AR210
                                                                 AR219   AR301
                                                                 AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BL02.1  BL04.1
                                                                 BL10.1  BL120
                                                                 BL121   BL122
                                                                 BL123   BL125
                                                                 BL130   BL20.1
                                                                 BL20.3  BL20.6
                                                                 BL202   BL204
                                                                 BL21.2  BL21.5
                                                                 BL217   BL219
                                                                 BL220   BL231
                                                                 BL246   BL29.1
                                                                 BL29.2  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  BL520
                                                                 BL530   BL546
                                                                 BL80.1  BL80.3
                                                                 BL802   BL81.1
                                                                 BL82.1  BL820
                                                                 ...

CEP-DEFAULT-PMT        Alpha 1                                   AC56.1  AC560
Element: Default Pmt                                             AR08.1  AR09.1
                                                                 AR10.1  AR10.5
                                                                 AR120   AR210
                                                                 AR219   AR301
                                                                 AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BL02.1  BL04.1
                                                                 BL10.1  BL120
                                                                 BL121   BL122
                                                                 BL123   BL125
                                                                 BL130   BL20.1
                                                                 BL20.3  BL20.6
                                                                 BL202   BL204
                                                                 BL21.2  BL21.5
                                                                 BL217   BL219
                                                                 BL220   BL231
                                                                 BL246   BL29.1
                                                                 BL29.2  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  BL520
                                                                 BL530   BL546
                                                                 BL80.1  BL80.3
                                                                 BL802   BL81.1
                                                                 BL82.1  BL820
                                                                 ...

                         CUSTEP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CEPSET1   COMPANY                                                AC56.1  AC560
          CUSTOMER                                               AR08.1  AR09.1
          EP-TYPE                                                AR10.1  AR10.5
          EP-ACCOUNT                                             AR120   AR210
                                                                 AR219   AR301
                                                                 AR48.1  AR48.3
                                                                 AR501   AR550
                                                                 BL02.1  BL04.1
                                                                 BL10.1  BL120
                                                                 BL121   BL122
                                                                 BL123   BL125
                                                                 BL130   BL20.1
                                                                 BL20.3  BL20.6
                                                                 BL202   BL204
                                                                 BL21.2  BL21.5
                                                                 ...