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

BN150     BN305     BN47.1    BN547     BN70.1    ET530
ETI2.1    HPPV.1    HR04.9    HR06.4    HR11.1    HR11.2
HR13.1    HR211     HR511     HR513     LP130     LP51.1
HS50.3    HS50.4    PA02.1    PA100     PA102     PA115
PA12.1    PA13.1    PA13.2    PA218     PA31.1    PA502
PA512     PA513     PA52.1    PA52.3    PA52.4    PA52.5
PA531     PA594     PA92.1    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
PR274     PR288     PR29.1    PR32.2    PR33.2    PR33.3
PR35.1    PR35.2    PR35.3    PR35.4    PR35.5    PR35.6
PR35.8    PR35.9    PR36.1    PR418     PR45.1    PR529
PR530     PR560     PR80.1    PR82.1    UK102     UK560
TA146     TA147     TA198

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                                               BN150   BN305
                                                                 BN47.1  BN547
                                                                 BN70.1  ET530
                                                                 ETI2.1  HPPV.1
                                                                 HR04.9  HR06.4
                                                                 HR11.1  HR11.2
                                                                 HR13.1  HR211
                                                                 HR511   HR513
                                                                 LP130   LP51.1
                                                                 HS50.3  HS50.4
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA12.1  PA13.1
                                                                 PA13.2  PA218
                                                                 PA31.1  PA502
                                                                 ...