Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

POCHEADER


                             POCHEADER FILE

UPDATED BY

PO520     PO53.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CAR-PROCURE-GROUP      Alpha 4                                   PO520   PO53.1
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.

CAR-COMPANY            Numeric 4                                 PO520   PO53.1
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.

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

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

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

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

CAR-VENDOR             Alpha 9  (Right Justified)                PO520   PO53.1
Element: Vendor ID     The vendor's identification code.



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

CAR-BUYER-CODE         Alpha 3                                   PO520   PO53.1
Element: Buyer         The user defined buyer identifier.

CAR-BLKT-STD-REF       Alpha 30                                  PO520   PO53.1
Element: Agreement Ref

CAR-PO-DATE            Numeric 8  (yyyymmdd)                     PO520   PO53.1
Element: Date

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

CAR-ENT-CNV-RATE       Signed 14.7                               PO520   PO53.1
Entered Conversion     Currency conversion rate at Purchase
Rate                   Order entry time.

CAR-CURR-SET-FLAG      Alpha 1                                   PO520   PO53.1
Element: Currency Set FFlag defines when the currency rate
                       has been set for the Purchase Order.
                       E = Entry
                       R = Receiving
                       I = Invoicing

CAR-REVALUE-FLAG       Alpha 1                                   PO520   PO53.1
Element: All Flag      Currency will be re-evaluated when
                       Accounts Payable prints check in a
                       currency other than established on
                       the Purchase Order/Invoice.
                       Y = Yes
                       N = No

CAR-DFLT-DL-DATE       Numeric 8  (yyyymmdd)                     PO520   PO53.1
Element: Date          Default Early Delivery Date.

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

CAR-SH-NAME            Alpha 30  (Lower Case)                    PO520   PO53.1
Element: Name          This is the ship to name for a non
                       standard ship to address.

CAR-SH-ADDR1           Alpha 30  (Lower Case)                    PO520   PO53.1
Element: Address 1     This is the ship to address line one.

CAR-SH-ADDR2           Alpha 30  (Lower Case)                    PO520   PO53.1
Element: Address 1     This is the ship to address line two.

CAR-SH-ADDR3           Alpha 30  (Lower Case)                    PO520   PO53.1
Element: Address 1     This is the ship to address line
                       three.

CAR-SH-ADDR4           Alpha 30  (Lower Case)                    PO520   PO53.1
Element: Address 1     This is the ship to address line four.

CAR-SH-CITY-ADDR5      Alpha 18  (Lower Case)                    PO520   PO53.1
Element: City          This is the ship to city or the
                       ship to address line five.

CAR-SH-STATE-PROV      Alpha 2                                   PO520   PO53.1
Element: State or ProviThis is the ship to state or the
                       ship to province.

CAR-SH-POST-CODE       Alpha 10  (Lower Case)                    PO520   PO53.1
Element: Ship To PostalThis is the ship to mail code.

CAR-SH-COUNTRY-CD      Alpha 2                                   PO520   PO53.1
Element: Sh Country Cd

CAR-SH-COUNTRY         Alpha 30  (Lower Case)                    PO520   PO53.1
Element: Country or OthShip to country.

CAR-SH-COUNTY          Alpha 25  (Lower Case)                    PO520   PO53.1
Element: County

CAR-SH-PHONE-PREF      Alpha 6                                   PO520   PO53.1
Telephone Country      This is the ship to phone number
Code                   prefix.

CAR-SH-PHONE           Alpha 15                                  PO520   PO53.1
Element: Telephone NumbThis is the ship to phone number.

CAR-SH-PHONE-EXT       Alpha 5                                   PO520   PO53.1
Element: Telephone Extension

CAR-SH-CONTACT         Alpha 30  (Lower Case)                    PO520   PO53.1
Element: Contact       Ship to contact.

CAR-DROPSHIP-FL        Alpha 1                                   PO520   PO53.1
Element: Dropship Flag This flag indicates whether goods being
                       shipped by the vendor directly to a non
                       standard location need to have the
                       receiving process performed.
                       N = Receiving Required
                       Y = Receiving Not Allowed

CAR-PRT-REC-FLAG       Alpha 1                                   PO520   PO53.1
Element: All Flag      N = No
                       Y = Yes

CAR-FAX-PREFIX         Alpha 6                                   PO520   PO53.1
Telephone Country      The fax number prefix.
Code

CAR-FAX-NUMBER         Alpha 15                                  PO520   PO53.1
Element: Telephone NumbThis field contains the fax number.

CAR-FAX-EXT            Alpha 5                                   PO520   PO53.1
Element: Telephone ExteThis field contains the fax number
                       extension.


CAR-PROCESS-LEVEL      Alpha 5                                   PO520   PO53.1
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

CAR-FREIGHT-TERMS      Alpha 1                                   PO520   PO53.1
Element: 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.

CAR-FOB-CODE           Alpha 3                                   PO520   PO53.1
Element: Shipping Term The user defined Free On Board Code.

CAR-SHIP-VIA           Alpha 12  (Lower Case)                    PO520   PO53.1
Element: Ship Via Description

CAR-TERM-CODE          Alpha 5                                   PO520   PO53.1
Element: Terms Code    A user-defined code representing a
                       method of determining invoice due and
                       discount dates.

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


CAR-LETTER-OF-CR       Alpha 20                                  PO520   PO53.1
Element: Letter of CredThis field contains the letter of
                       credit.

CAR-USER-DATE-1        Numeric 8  (yyyymmdd)                     PO520   PO53.1
Element: Date

CAR-USER-DATE-2        Numeric 8  (yyyymmdd)                     PO520   PO53.1
Element: Date

CAR-DFLT-TAXBL-FL      Alpha 1                                   PO520   PO53.1
Element: All Flag      This taxable flag is used for
                       defaulting a 'Y'es, 'N'o into Special
                       and Service items when applying them to
                       a Purchase Order.
                       Non-stock and Inventory items will
                       have this flag defined in the Lawson
                       Inventory System.
                       Y = Yes
                       N = No

CAR-DFLT-ACCT-UNIT     Alpha 15                                  PO520   PO53.1
Element: Accounting Unit

CAR-DFLT-ACCOUNT       Numeric 6                                 PO520   PO53.1
Element: Account

CAR-DFLT-SUB-ACCT      Numeric 4                                 PO520   PO53.1
Element: Subaccount

CAR-DFLT-DIST-CO       Numeric 4                                 PO520   PO53.1
Element: Company

CAR-DFLT-ACTIVITY      Alpha 15                                  PO520   PO53.1
Element: Activity

CAR-DFLT-ACCT-CAT      Alpha 5                                   PO520   PO53.1
Element: Account Category

CAR-DFLT-BILL-CAT      Alpha 32                                  PO520   PO53.1
Element: Bill Category

CAR-DFLT-REQ-LOC       Alpha 5                                   PO520   PO53.1
Element: To Location

CAR-DFLT-REQUESTER     Alpha 10  (Lower Case)                    PO520   PO53.1
Element: Requester

CAR-DFLT-DEL-TO        Alpha 30  (Lower Case)                    PO520   PO53.1
Element: Deliver To Name

CAR-DFLT-SRC-DOC       Alpha 10                                  PO520   PO53.1
Element: Dflt Src Doc

CAR-CLOSED-FL          Alpha 1                                   PO520   PO53.1
Element: Closed Flag   The Closed Flag.
                       N = No
                       Y = Yes
                       H = Historical

CAR-PO-USER-FLD-1      Alpha 1                                   PO520   PO53.1
Purchase Order User    Purchase Order header user field one.
Field 1

CAR-PO-USER-FLD-3      Alpha 30                                  PO520   PO53.1
Item Mster User        Purchase Order header user field two.
Defined Field2

CAR-PO-USER-FLD-5      Alpha 30  (Lower Case)                    PO520   PO53.1
Element: User Defined FPurchase Order header user field three.

CAR-INVC-MTHD-CODE     Alpha 3                                   PO520   PO53.1
Element: Invc Mthd CodeThe method the vendor is to use to
                       invoice the order (manual, EDI, or
                       evaluated receipts settlement).

CAR-ISSUE-METH         Alpha 1                                   PO520   PO53.1
Element: Issue Meth    Specifies the method that will be used
                       to issue the purchase order to the
                       vendor.
                       P = Paper
                       F = Fax
                       E = EDI
                       I = Internet Mail
                       D = Do Not Print

CAR-REVISIONS-INCL     Alpha 1                                   PO520   PO53.1
Element: Revisions InclSpecifies what information will be
                       included when a revised Purchase Order
                       is re-issued.

                       You may specify that only the revised
                       information is included, along with
                       messages that indicate what was revised
                       (option O - Revisions Only).

                       Alternately, you may specify that the
                       entire PO is included, along with
                       messages that indicate the revisions.

                       Finally, you may specify that the entire
                       PO is re-issued.  No revision messages
                       will appear.

                       If the PO has not been printed, or the
                       revised PO is not to be re-issued, this
                       field will be blank (Not Applicable).
                       O = Revisions Only
                       C = Revisions Complete
                       I = Reissue
                       N = Not Applicable
                       " " = Not Revised

CAR-USER-ID            Alpha 10  (Lower Case)                    PO520   PO53.1
Element: User          Contains the user ID of the person who
                       last changed this record.

CAR-PCR-USR-FLD-01     Alpha 20                                  PO520   PO53.1
Element: Pcr Usr Fld 01

CAR-PCR-USR-FLD-02     Alpha 20                                  PO520   PO53.1
Element: Pcr Usr Fld 02

CAR-PCR-USR-FLD-03     Alpha 20                                  PO520   PO53.1
Element: Pcr Usr Fld 03

CAR-PCR-USR-FLD-04     Alpha 20                                  PO520   PO53.1
Element: Pcr Usr Fld 04

CAR-PCR-USR-FLD-05     Alpha 20                                  PO520   PO53.1
Element: Pcr Usr Fld 05

CAR-UNLOADING-PORT     Alpha 5                                   PO520   PO53.1
Element: Unloading PortThe prot where the goods are unloaded if
                       required.  Must be defined in IN04.1
                       (Port Maintenance)

CAR-DEST-REGION        Alpha 2                                   PO520   PO53.1
Element: Dest Region   The region of the country to which the
                       goods were shipped, if required.  Must
                       be a valid region in IN02.1 (Region
                       Maintenance)

CAR-NOTC               Alpha 2                                   PO520   PO53.1
Element: Notc          The Nature of Transaction code.  Must
                       be a valid code defined in IN07.1 (NOTC
                       Maintenance).

CAR-STAT-PROC          Alpha 6                                   PO520   PO53.1
Element: Stat Proc     The statistical procedure code applied
                       to the data.  The code must be defined
                       in IN06.1. (Statistical Procedure
                       Maintenance).

CAR-PCR-SEG-BLOCK      Alpha 103                                 PO520   PO53.1
Element: User Analysis

CAR-XREF-VENDOR        Alpha 9  (Right Justified)                PO520   PO53.1
Element: Xref Vendor   This is a vendor that is supported on a
                       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.

CAR-SHIP-TO-ARRIVE     Numeric 8  (yyyymmdd)                     PO520   PO53.1
Element: Date          Date when the goods are expected

CAR-SUBCONTRACT-PO     Numeric 1                                 PO520   PO53.1
Element: Subcontract PoThis field indicates if the purchase
                       order is a subcontractor PO. Only valid
                       with Grant Management setup.

CAR-WRHS-NUMBER        Alpha 5                                   PO520   PO53.1
Element: Wrhs Number   A warehouse number

CAR-MTCH-PRPY-FL       Alpha 1                                   PO520   PO53.1
Element: Mtch Prpy Fl  This field will be populated from the
                       INVOICE file if the invoice is
                       INVOICE-TYPE R for Match Prepayment.
                       When the receipt is entered or
                       interfaced the same firled on the
                       receipt record will be populated in
                       oreder to note that it will be matched
                       to a match prepayment invoice.
                       " " = No Option
                       R = Invoice Type Match Prepay

CAR-IMAGE-NUMBER       Alpha 100                                 PO520   PO53.1
Element: Image Number  A number associated with a scanned image
                       or URL

                         POCHEADER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CARSET1   PROCURE-GROUP                                          PO520   PO53.1
          COMPANY
          PO-CODE
          PO-NUMBER
          PO-RELEASE
          REC-TYP

CARSET2   VENDOR
          COMPANY
          PURCH-FR-LOC
          PO-DATE*
          PO-CODE
          PO-NUMBER*
          PO-RELEASE*
          REC-TYP*

CARSET3   COMPANY
          BUYER-CODE
          PO-DATE*
          PO-CODE
          PO-NUMBER*
          PO-RELEASE*
          REC-TYP*

CARSET4   COMPANY
          PO-DATE*
          PO-NUMBER*
          PO-CODE
          PO-RELEASE*
          REC-TYP*

CARSET5   COMPANY
          PO-CODE
          PO-DATE*
          PO-NUMBER*
          PO-RELEASE*
          REC-TYP*