Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CUSTEP


                              CUSTEP FILE

UPDATED BY

AR08.1    AR09.1    AR10.1    AR10.5    AR210     AR219
AR301     AR48.1    AR48.3    AR501     AR550     BL02.1
BL04.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    BR11.1    BR120
BR121     BR122     BR140     BR16.1    BR17.1    BR19.1
BR20.1    BR20.2    BR20.3    BR20.4    BR20.5    BR20.7
BR21.2    BR210     BR211     BR216     BR217     BR220
BR400     BR420     BR45.1    BR450     BR46.1    BR46.2
BR46.4    BR521     BRIP.1    CB06.2    IC02.1    IC531
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     OE111     OE112     OE113     OE114     OE116
OE129     OE13.2    OE13.3    OE13.5    OE13.6    OE130
OE14.3    OE14.4    OE16.1    OE230     OE254     OE260
OE270     OE271     OE272     OE284     OE285     OE286
OE290     OE291     OE292     OE293     OE294     OE30.1
OE30.2    OE30.3    OE30.4    OE30.5    OE30.6    OE30.7
OE30.9    OE330     OE510     OE53.1    OE530     OE54.1
OE60.1    OE80.1    OE80.2    OE81.1    OE81.2    OE810
OE830     OE85.1    OE85.3    OE86.1    OE90.1    OE90.2
PBIP.1    PR197     SA03.1    SA100     SA252     SA254
SA256     SA261     SA271     SA281     SA291     SA300
SA80.2    SA90.2    TX140     TX40.1    WH110     WH120
WH130     WH132     WH190     WH20.1    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     WO30.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CEP-COMPANY            Numeric 4                                 AR08.1  AR09.1
Element: Company       Identifies the AP company if the          AR10.1  AR10.5
                       resource type = V.  Identifies the HR     AR210   AR219
                       company if the resource type = E.  It is  AR301   AR48.1
                       blank for type A, P or Q resources.       AR48.3  AR501
                                                                 AR550   BL02.1
                                                                 BL04.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
                                                                 ...

CEP-CUSTOMER           Alpha 9  (Right Justified)                AR08.1  AR09.1
Element: Customer NumbeThis field contains the number that       AR10.1  AR10.5
                       represents a customer.                    AR210   AR219
                                                                 AR301   AR48.1
                                                                 AR48.3  AR501
                                                                 AR550   BL02.1
                                                                 BL04.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
                                                                 ...

CEP-EP-TYPE            Alpha 5                                   AR08.1  AR09.1
Element: Ep Type                                                 AR10.1  AR10.5
                                                                 AR210   AR219
                                                                 AR301   AR48.1
                                                                 AR48.3  AR501
                                                                 AR550   BL02.1
                                                                 BL04.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
                                                                 ...

CEP-EP-ACCOUNT         Alpha 32                                  AR08.1  AR09.1
Element: Ep Account                                              AR10.1  AR10.5
                                                                 AR210   AR219
                                                                 AR301   AR48.1
                                                                 AR48.3  AR501
                                                                 AR550   BL02.1
                                                                 BL04.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
                                                                 ...

CEP-EP-EXP-DATE        Numeric 8  (yyyymmdd)                     AR08.1  AR09.1
Element: Ep Exp Date                                             AR10.1  AR10.5
                                                                 AR210   AR219
                                                                 AR301   AR48.1
                                                                 AR48.3  AR501
                                                                 AR550   BL02.1
                                                                 BL04.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
                                                                 ...

CEP-EP-STATUS          Alpha 1                                   AR08.1  AR09.1
Element: Ep Status     A = Active                                AR10.1  AR10.5
                       I = Inactive                              AR210   AR219
                                                                 AR301   AR48.1
                                                                 AR48.3  AR501
                                                                 AR550   BL02.1
                                                                 BL04.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
                                                                 ...

CEP-DEFAULT-PMT        Alpha 1                                   AR08.1  AR09.1
Element: Default Pmt                                             AR10.1  AR10.5
                                                                 AR210   AR219
                                                                 AR301   AR48.1
                                                                 AR48.3  AR501
                                                                 AR550   BL02.1
                                                                 BL04.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
                                                                 ...

                         CUSTEP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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