Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

POCLINE


                              POCLINE FILE

UPDATED BY

PO520     PO53.2    PO53.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CAL-PROCURE-GROUP      Alpha 4                                   PO520   PO53.2
Element: Procure Group This field contains the identifier for a
                       group of companies that share a common
                       procurement effort. They buy items and
                       services together.

CAL-COMPANY            Numeric 4                                 PO520   PO53.2
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

CAL-PO-NUMBER          Alpha 14  (Right Justified)               PO520   PO53.2
Element: PO Number     This field contains the number
                       representing the purchase order.

CAL-PO-RELEASE         Numeric 4                                 PO520   PO53.2
Element: PO Release NumUsed to identify a purchase order
                       release (created from a Blanket or
                       Standing order).

CAL-PO-CODE            Alpha 4                                   PO520   PO53.2
Element: Po Code       This is the purchase order code.

CAL-LINE-NBR           Numeric 6                                 PO520   PO53.2
Element: Line Number   This field contains the line number.

CAL-REC-TYP            Numeric 2                                 PO520   PO53.2
Element: Rec Typ

CAL-ITEM               Alpha 32                                  PO520   PO53.2
Element: Item Number   This field contains the item
                       identifier.

CAL-ITEM-TYPE          Alpha 1                                   PO520   PO53.2
Element: Item Type     This field identifies the line item
                       type.
                       I = Invnetoried
                       S = Service
                       X = Special
                       N = Non-Stock

CAL-SERVICE-CODE       Alpha 1                                   PO520   PO53.2
Element: Service Code

CAL-DESCRIPTION        Alpha 30  (Lower Case)                    PO520   PO53.2
Element: Description   This field displays the description.

CAL-QUANTITY           Signed 13.4                               PO520   PO53.2
Element: Quantity      This field contains the desired
                       quantity.

CAL-AGREEMENT-REF      Alpha 30                                  PO520   PO53.2
Element: Agreement Ref

CAL-ENT-UNIT-CST       Signed 18.5                               PO520   PO53.2
Element: Intl Cost     The entered unit cost.

CAL-TAXBL-UNT-CST      Signed 18.5                               PO520   PO53.2
Element: Intl Cost     The portion of the line unit cost which
                       is taxable. If left blank, this field
                       will default to the line unit cost in
                       vendor price unit of measure terms.

CAL-ENT-BUY-UOM        Alpha 4                                   PO520   PO53.2
Element: Unit of MeasurEntered Buy Unit Of Measure.

CAL-EARLY-DL-DATE      Numeric 8  (yyyymmdd)                     PO520   PO53.2
Early Delivery Date    This field contains the early delivery
(Rqst DT)              date.

CAL-LATE-DL-DATE       Numeric 8  (yyyymmdd)                     PO520   PO53.2
Element: Late Delivery This field contains the late delivery
                       date.

CAL-LOCATION           Alpha 5                                   PO520   PO53.2
Element: Location Code This field contains a valid stocking
                       location within the company inventory.

CAL-VEN-ITEM           Alpha 32                                  PO520   PO53.2
Element: Item Number   The vendor's item identifer.

CAL-DIST-CODE          Alpha 9                                   PO520   PO53.2
Element: Distribution CA user-defined code used to
                       automatically create expense
                       distributions or expense distribution
                       "shells" for invoices or to split an
                       invoice distribution into multiple
                       distributions.

CAL-TAX-CODE           Alpha 10                                  PO520   PO53.2
Element: Tax Code      This field contains a code representing
                       specific tax information.  This must be
                       valid Tax Code.


CAL-WEIGHT             Signed 9.3                                PO520   PO53.2
Element: Unit Weight   This field contains the unit weight of
                       the item based on the stocking UOM.

CAL-CUBIC-FEET         Signed 9.3                                PO520   PO53.2
Element: Cubic Feet    This field contains the unit cubit feet
                       of the item based on the stocking UOM.

CAL-COST-OPTION        Alpha 1                                   PO520   PO53.2
Element: Cost Option   1 = Cosr Required
                       2 = No Charge
                       3 = Vendor Determined

CAL-CERT-REQ-FL        Alpha 1                                   PO520   PO53.2
Certification          This flag indicates whether a
Required Flag          certification is required for this line
                       when it is purchased.  This field value
                       is passed to the PO when the PO line is
                       created.  Valid values are:
                           "N" = Certification not required.
                           "Y" = Certification required.
                       N = No
                       Y = Yes

CAL-INSP-REQ-FL        Alpha 1                                   PO520   PO53.2
Element: All Flag      This flag indicates whether this item
                       has to be inspected when received via
                       PO.
                       N = No
                       Y = Yes

CAL-MSDS-FLAG          Alpha 1                                   PO520   PO53.2
Element: All Flag      This flag indicates if this item
                       requires a Material Safety Data Sheet.

CAL-NO-LT-CALC-FL      Alpha 1                                   PO520   PO53.2
Element: All Flag      N = No
                       Y = Yes

CAL-TAXABLE-FLAG       Alpha 1                                   PO520   PO53.2
Taxable or             Defines if Taxable.
Non-Taxable Flag       N = No
                       Y = Yes

CAL-OSHIP-TOL-PCT      Percent 5.3  (Percent)                    PO520   PO53.2
Overshipment           Quantity overshipment tolerance
Tolerance Percent      percentage.

CAL-USHIP-TOL-PCT      Percent 6.3  (Percent)                    PO520   PO53.2
Cancel Backorder       This is the quantity undership
Percent                percentage for automatic back order
                       cancellation. If a value of 10% is
                       entered here, for instance, and a
                       quantity of 91 is shipped against an
                       ordered quantity of 100, that would be
                       considered a 9% undershipment. Since
                       this is less than the 10% limit, the
                       backordered amount would be cancelled.

                       This process takes place at receiving
                       time. If a backorder is not cancelled
                       manually, the system checks, in order,
                       the PO line, the PO vendor purchase from
                       record, the PO vendor record, and the
                       company record. If an undershipment
                       percentage of a zero percent flag set to
                       Y is encountered at any level, that
                       value is used.
                       NOTE-The percentage can be set at 100%,
                       which would cancel all backorders.

CAL-USER-DATE-3        Numeric 8  (yyyymmdd)                     PO520   PO53.2
Element: Date          This field contains the third
                       user-definable date.

CAL-USER-DATE-4        Numeric 8  (yyyymmdd)                     PO520   PO53.2
Element: Date          This field contains the fourth
                       user-definable date.

CAL-PURCH-MAJCL        Alpha 4                                   PO520   PO53.2
Element: Major Class   The user defined Major Purchasing Class
                       identifier.

CAL-PURCH-MINCL        Alpha 4                                   PO520   PO53.2
Element: Minor Class   The user defined Minor purchasing Class
                       identifier.

CAL-MANUF-CODE         Alpha 4                                   PO520   PO53.2
Element: Manufacturer'sThis field contains a user defined code
                       that indicates the  manufacturer of an
                       item.

CAL-MANUF-DIVISION     Alpha 4                                   PO520   PO53.2
Manufacturer's         This is a user defined code that
Division               indicates which division of a
                       manufacturer is tied to an item.

CAL-MANUF-NBR          Alpha 15                                  PO520   PO53.2
Manufacturer's Item    This is the identifier that the
Number                 manufacturer has assigned to an item.

CAL-CLOSED-FL          Alpha 1                                   PO520   PO53.2
Element: Closed Flag   The Closed Flag.

CAL-ZERO-OSHIP-FL      Alpha 1                                   PO520   PO53.2
Element: All Flag

CAL-ZERO-USHIP-FL      Alpha 1                                   PO520   PO53.2
Element: All Flag      Set this flag to "Y" to indicate that
                       the undershipment tolerance percent
                       should be set to "zero" at this level.
                       This means that no backorders will be
                       cancelled.

                       The undershipment tolerance percent
                       must be blank to set this flag to "Y".

CAL-EXCL-AOC-SPRD      Alpha 1                                   PO520   PO53.2
Exclude from AOC       Exclude this line item from the
Spread Method          Add On Cost Spread Methods.

CAL-PO-USER-FLD-2      Alpha 2                                   PO520   PO53.2
Purchase Order User    Purchase order line user defined field.
Field 2

CAL-PO-USER-FLD-4      Alpha 30  (Lower Case)                    PO520   PO53.2
Element: User Defined FPurchase order line user defined field.

CAL-PO-USER-FLD-6      Alpha 15  (Lower Case)                    PO520   PO53.2
Element: User Defined FPurchase order line user defined field.

CAL-ELEMENT-01         Alpha 32                                  PO520   PO53.2
Element: Element 01

CAL-ELEMENT-02         Alpha 32                                  PO520   PO53.2
Element: Element 01

CAL-ELEMENT-03         Alpha 32                                  PO520   PO53.2
Element: Element 01

CAL-ELEMENT-04         Alpha 32                                  PO520   PO53.2
Element: Element 01

CAL-ELEMENT-05         Alpha 32                                  PO520   PO53.2
Element: Element 01

CAL-ELEMENT-06         Alpha 32                                  PO520   PO53.2
Element: Element 01

CAL-ELEMENT-07         Alpha 32                                  PO520   PO53.2
Element: Element 01

CAL-ELEMENT-08         Alpha 32                                  PO520   PO53.2
Element: Element 01

CAL-ELEMENT-09         Alpha 32                                  PO520   PO53.2
Element: Element 01

CAL-ELEMENT-10         Alpha 32                                  PO520   PO53.2
Element: Element 01

CAL-PLI-USR-FLD-01     Alpha 20                                  PO520   PO53.2
Element: Pli Usr Fld 01

CAL-PLI-USR-FLD-02     Alpha 20                                  PO520   PO53.2
Element: Pli Usr Fld 02

CAL-PLI-USR-FLD-03     Alpha 20                                  PO520   PO53.2
Element: Pli Usr Fld 03

CAL-PLI-USR-FLD-04     Alpha 20                                  PO520   PO53.2
Element: Pli Usr Fld 04

CAL-PLI-USR-FLD-05     Alpha 20                                  PO520   PO53.2
Element: Pli Usr Fld 05

CAL-TAX-USAGE-CD       Alpha 10                                  PO520   PO53.2
Element: Tax Usage Cd  The tax usage coe for the vendor.  This
                       filed is required if the AP Company
                       inidcates that VAT reporting required.

CAL-ICN-CODE           Alpha 8                                   PO520   PO53.2
Element: Icn Code

CAL-SUPLMNTARY-QTY     Signed 13.4                               PO520   PO53.2
Element: Quantity

CAL-PLI-SEG-BLOCK      Alpha 103                                 PO520   PO53.2
Element: User Analysis

CAL-LANDED-FLAG        Alpha 1                                   PO520   PO53.2
Element: Landed Fl     This flag is set on the AOC code and
                       notes that the AOC will take on the
                       attributes on the goods line.
                       " " = No
                       1 = Landed

                         POCLINE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CALSET1   PROCURE-GROUP                                          PO520   PO53.1
          COMPANY                                                PO53.2
          PO-NUMBER
          PO-RELEASE
          PO-CODE
          LINE-NBR
          REC-TYP