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 a  PO53.8
                       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 NumUsed 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 Number   This field contains the line number.      PO53.8

CAO-AOC-CODE           Alpha 2                                   PO520   PO53.4
Element: Add On Cost CoThis 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 ID     The vendor's identification code.         PO53.8



CAO-PURCH-FR-LOC       Alpha 4                                   PO520   PO53.4
Purchase From          The vendor's purchase from location.      PO53.8
Location Code

CAO-AOC-RATE           Percent 7.3  (Percent)                    PO520   PO53.4
Element: Add On Cost RaAdd 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     The entered unit cost.                    PO53.8

CAO-TOTAL-AOC          Signed 18.2                               PO520   PO53.4
Element: Intl Amt      The total add on cost amount can be an    PO53.8
                       entered amount if  entered at this
                       level, or a calculated  amount if a unit
                       add on cost or add on  cost percent is
                       entered.

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
Taxable or             Defines if Taxable.                       PO53.8
Non-Taxable Flag       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 FlagDefines 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 Flag   The Closed Flag.                          PO53.8
                       N = No
                       Y = Yes

CAO-LANDED-FL          Alpha 1                                   PO520   PO53.4
Element: Landed Fl     This flag will denote if the AOC of       PO53.8
                       record is landed or not landed.  Landed
                       means the AOC takes on the
                       characteristics of the goods it is
                       landed to.
                       0 = No
                       1 = Landed

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
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

CAO-ENT-CNV-RATE       Signed 14.7
Entered Conversion     Currency conversion rate at Purchase
Rate                   Order entry time.

CAO-REC-CNV-RATE       Signed 14.7
Entered Conversion     Currency conversion rate for the
Rate                   Purchase Order at receiving time.

CAO-TOTAL-AOC-PO       Signed 18.2
Element: Intl Amt

CAO-OPEN-PO-AMT        Signed 18.2
Element: Intl Amt      The portion of the total or extended
                       ordered amount that is  still open --
                       that is, it has not been cancelled or
                       paid.  This is always expressed in the
                       company base currency, and includes only
                       product costs (add on costs and taxes
                       are not included).

                         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