Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

POCAOCDTL


                             POCAOCDTL FILE

UPDATED BY

PO520     PO53.4    PO53.8    PO53.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

CAO-PO-NUMBER          Alpha 14  (Right Justified)               PO520   PO53.4
Element: Po Number     This field contains the number            PO53.8
                       representing the purchase order.

CAO-PO-RELEASE         Numeric 4                                 PO520   PO53.4
Element: Po Release    Used to identify a purchase order         PO53.8
                       release (created from a Blanket or
                       Standing order).

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

CAO-LINE-NBR           Numeric 6                                 PO520   PO53.4
Element: Line Nbr      This field contains the line number.      PO53.8

CAO-AOC-CODE           Alpha 2                                   PO520   PO53.4
Element: Aoc Code      This field contains the identifier for    PO53.8
                       the add on cost associated with this
                       line item.

CAO-REC-TYP            Numeric 2                                 PO520   PO53.4
Element: Rec Typ                                                 PO53.8

CAO-VENDOR             Alpha 9  (Right Justified)                PO520   PO53.4
Element: Vendor        The vendor's identification code.         PO53.8



CAO-PURCH-FR-LOC       Alpha 4                                   PO520   PO53.4
Element: Purch Fr Loc  The vendor's purchase from location.      PO53.8

CAO-AOC-RATE           Percent 7.3  (Percent)                    PO520   PO53.4
Element: Aoc Rate      Add On Cost Percentage Rate. If add on    PO53.8
                       cost is spread by rate, this value times
                       the line unit cost is the unit add on
                       cost for the PO line.

CAO-ENTRY              Alpha 1                                   PO520   PO53.4
Element: Entry         Amount Entry Method.                      PO53.8
                       U = Unit Cost Entry
                       R = Rate Percentage Entry
                       T = Total Amount Entry

CAO-QUANTITY           Signed 13.4                               PO520   PO53.4
Element: Quantity      This field contains the desired           PO53.8
                       quantity.

CAO-ENT-UNIT-CST       Signed 18.5                               PO520   PO53.4
Element: Intl Cost                                               PO53.8

CAO-TOTAL-AOC          Signed 18.2                               PO520   PO53.4
Element: Intl Amt                                                PO53.8

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

CAO-TAXABLE-FLAG       Alpha 1                                   PO520   PO53.4
Element: Taxable Flag  Defines if Taxable.                       PO53.8
                       Y = Yes
                       N = No

CAO-AOC-ON-PO          Alpha 1                                   PO520   PO53.4
Element: Aoc On Po     Indicates if the add-on cost is to        PO53.8
                       appear on the Purchase Order document
                       that is issued to the vendor.
                       Y = Yes
                       N = No

CAO-SUMMARY-FLAG       Alpha 1                                   PO520   PO53.4
Element: Summary Flag  Defines if add on cost is printed in      PO53.8
                       summary or at a detail level on the
                       Lawson Purchase Order document.
                       Y = Yes
                       N = No

CAO-ZERO-COST-FLG      Alpha 1                                   PO520   PO53.4
Element: Zero Cost Flg Defines if this tax record is allowed     PO53.8
                       to have a  zero unit cost.
                       N = No
                       Y = Yes

CAO-CLOSED-FL          Alpha 1                                   PO520   PO53.4
Element: Closed Fl     The Closed Flag.                          PO53.8
                       N = No
                       Y = Yes

CAO-XREF-VENDOR        Alpha 9  (Right Justified)                PO520   PO53.4
Element: Xref Vendor   This is a vendor that is supported on a   PO53.8
                       system outside Lawson.  When records are
                       interfaces we will maintain this vendor
                       on the file but we will use the Lawson
                       vendor while in the lawson application.

CAO-CURRENCY-CODE      Alpha 5                                   PO520   PO53.4
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

CAO-ENT-CNV-RATE       Signed 14.7                               PO53.4
Element: Ent Cnv Rate  Currency conversion rate at Purchase
                       Order entry time.

                         POCAOCDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CAOSET1   PROCURE-GROUP                                          PO520   PO53.1
          COMPANY                                                PO53.4  PO53.8
          PO-NUMBER
          PO-RELEASE
          PO-CODE
          LINE-NBR
          AOC-CODE
          REC-TYP