Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             POFRTTERM FILE

                          Freight Term Master

Purchase Order Freight Terms Master File.

REFERENCED BY

BL92.1    IN20.1    MA00.1    MA200     MA206     MA300
MA40.1    MA520     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     OE113     OE114     OE129
OE14.4    OE15.1    OE15.2    OE15.3    OE15.4    OE15.5
OE15.7    OE510     OE810     OE920     PO10.1    PO10.2
PO100     PO120     PO121     PO123     PO130     PO20.1
PO210     PO22.1    PO22.2    PO22.3    PO220     PO225
PO25.1    PO30.1    PO33.1    PO34.1    PO68.1    PO820
RQ20.1    RQ20.3    RQ20.4    WH20.2    WH20.7

UPDATED BY

MA06.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

POF-COMPANY          Numeric 4                                   MA06.1
Company              The company number.

POF-FREIGHT-TERMS    Alpha 1                                     MA06.1
Freight Terms        Freight terms are used to define who
                     pays for freight costs incurred when
                     goods are shipped. Prepaid, for
                     instance, would normally mean that the
                     vendor would pay for freight. Collect
                     would mean the customer would pay for
                     freight.

                     A freight terms code can be entered on
                     a purchase order, or defaulted by vendor
                     or company.

POF-FRT-TERM-DESC    Alpha 15  (Lower Case)                      MA06.1  PO68.1
Freight Term         The user-defined freight term
Description          description.

                         POFRTTERM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

POFSET1   COMPANY                                                BL92.1  IN20.1
          FREIGHT-TERMS                                          MA00.1  MA06.1
                                                                 MA200   MA206
                                                                 MA300   MA40.1
                                                                 MA520   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
                                                                 OE113   OE114
                                                                 OE129   OE14.4
                                                                 OE15.1  OE15.2
                                                                 OE15.3  OE15.4
                                                                 ...

                         POFRTTERM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pocompany      POCOMPANY    Required

                            POF-COMPANY    -> PCY-COMPANY