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

PRPROVINCE


                            PRPROVINCE FILE

This file contains province codes and descriptions.

REFERENCED BY

AC541     AC542     BN150     BN47.1    BN547     BN70.1
HPPV.1    HR06.4    HR11.1    HR11.2    HR13.1    HR211
HR511     HR513     HR650     HS50.3    HS50.4    PA02.1
PA100     PA102     PA13.1    PA13.2    PA218     PA31.1
PA502     PA513     PA52.1    PA52.3    PA52.4    PA52.5
PA531     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     UK560     TA146     TA147     TA198
UK120

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

                         PRPROVINCE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PPVSET1   PROVINCE                                               AC541   AC542
                                                                 BN150   BN47.1
                                                                 BN547   BN70.1
                                                                 HPPV.1  HR06.4
                                                                 HR11.1  HR11.2
                                                                 HR13.1  HR211
                                                                 HR511   HR513
                                                                 HR650   HS50.3
                                                                 HS50.4  PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA218   PA31.1
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 ...