Lawson Software

Lawson Insight Technical Documentation
Generated by:
Documentation generated by Decision Analytics
ERDs Tables Elements Libraries App Forms 


                            PRPROVINCE FILE

This file contains province codes and descriptions.

REFERENCED BY

AC541     AC542     BN150     HPPV.1    HR06.4    HR11.1
HR11.2    HR211     HR511     HR650     HS50.3    HS50.4
PA02.1    PA100     PA102     PA502     PA52.1    PA52.3
PA52.4    PA52.5    PA594     PR03.1    PR05.4    PR05.5
PR08.1    PR110     PR113     PR120     PR125     PR128
PR13.1    PR13.5    PR13.6    PR13.8    PR130     PR131
PR132     PR134     PR136     PR18.2    PR189     PR206
PR288     PR29.1    PR32.2    PR33.2    PR33.3    PR35.1
PR35.2    PR35.3    PR35.4    PR35.5    PR35.6    PR35.8
PR36.1    PR418     PR45.1    PR529     PR530     PR560
PR80.1    PR82.1    UK102     TA146     TA147     TA198
UK120

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PPV-PROVINCE         Alpha 2
Province             Contains the two letter province code.

PPV-DESCRIPTION      Alpha 30  (Lower Case)
Description          This field displays the description.

                         PRPROVINCE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PPVSET1   PROVINCE                                               AC541   AC542
                                                                 BN150   HPPV.1
                                                                 HR06.4  HR11.1
                                                                 HR11.2  HR211
                                                                 HR511   HR650
                                                                 HS50.3  HS50.4
                                                                 PA02.1  PA100
                                                                 PA102   PA502
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA594   PR03.1
                                                                 PR05.4  PR05.5
                                                                 PR08.1  PR110
                                                                 PR113   PR120
                                                                 PR125   PR128
                                                                 ...