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     BN47.1    BN547     BN70.1    HPPV.1    HR06.4
HR11.1    HR11.2    HR211     HR511     HS50.3    HS50.4
PA02.1    PA100     PA102     PA13.1    PA13.2    PA31.1
PA502     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    PR206     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
PR82.1    UK102     TA146     TA147     TA198     TP135

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   BN47.1
                                                                 BN547   BN70.1
                                                                 HPPV.1  HR06.4
                                                                 HR11.1  HR11.2
                                                                 HR211   HR511
                                                                 HS50.3  HS50.4
                                                                 PA02.1  PA100
                                                                 PA102   PA13.1
                                                                 PA13.2  PA31.1
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA531   PA594
                                                                 PA92.1  PR03.1
                                                                 PR05.4  PR05.5
                                                                 ...