Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             POAOCMAST FILE

                           Add On Cost Master

 The Purchase Order Add On Cost Master.  This file is used to define Add On
 Cost codes for miscellaneous costs related to a Purchase Order.

REFERENCED BY

MA01.1    PO220     PO67.1    POI7.1    PO225

UPDATED BY

AP220     AP520     API1.1    API2.1    BL09.1    BL12.1
BL209     MA08.1    MA208     PO190     POIJ.1    POIT.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PAM-COMPANY          Numeric 4                                   AP220   AP520
Company              The company number.                         API1.1  API2.1
                                                                 BL09.1  BL12.1
                                                                 BL209   MA08.1
                                                                 MA208   PO190
                                                                 POIJ.1  POIT.1

PAM-AOC-CODE         Alpha 2                                     AP220   AP520
Add On Cost Code     This field contains the identifier for      API1.1  API2.1
                     the add-on cost associated with this        BL09.1  BL12.1
                     line item.                                  BL209   MA08.1
                                                                 MA208   PO190
                                                                 POIJ.1  POIT.1

PAM-DESCRIPTION      Alpha 30  (Lower Case)                      AP220   AP520
Description          This field displays the description.        API1.1  API2.1
                                                                 BL09.1  BL12.1
                                                                 BL209   MA08.1
                                                                 MA208   PO190
                                                                 POIJ.1  POIT.1

PAM-AOC-RATE         Percent 7.3  (Percent)                      AP220   AP520
Add On Cost Rate     Add-on cost percentage rate. If add-on      API1.1  API2.1
                     cost is spread by rate, this value          BL09.1  BL12.1
                     multiplied by the line unit cost is the     BL209   MA08.1
                     unit add-on cost for the purchase order     MA208   PO190
                     line.                                       POIJ.1  POIT.1

PAM-SPREAD-METHOD    Alpha 1                                     AP220   AP520
Spread Method        A method of spreading add-on costs          API1.1  API2.1
                     across the purchase order line level.       BL09.1  BL12.1
                     Spread can be by volume, quantity,          BL209   MA08.1
                     weight or amount. Default is no spread.     MA208   PO190
                     N = No Spread                               POIJ.1  POIT.1
                     Q = Quantity
                     V = Volume
                     W = Weight
                     A = Amount
                     R = Rate

PAM-TAX-CODE         Alpha 10                                    AP220   AP520
Tax Code             This field contains a code representing     API1.1  API2.1
                     specific tax information.  This must be     BL09.1  BL12.1
                     valid Tax Code.                             BL209   MA08.1
                                                                 MA208   PO190
                                                                 POIJ.1  POIT.1

PAM-DST-ACCT-UNIT    Alpha 15                                    AP220   AP520
Distribution         Contains the General Ledger accounting      API1.1  API2.1
Accounting Unit      unit to which the amount is posted.         BL09.1  BL12.1
                                                                 BL209   MA08.1
                                                                 MA208   PO190
                                                                 POIJ.1  POIT.1

PAM-DST-ACCOUNT      Numeric 6                                   AP220   AP520
Distribution         Contains the General Ledger account to      API1.1  API2.1
Account Number       which the amount is posted.                 BL09.1  BL12.1
                                                                 BL209   MA08.1
                                                                 MA208   PO190
                                                                 POIJ.1  POIT.1

PAM-DST-SUB-ACCT     Numeric 4                                   AP220   AP520
Distribution         The general ledger subaccount to which      API1.1  API2.1
Subaccount Number    the amount is posted.                       BL09.1  BL12.1
                                                                 BL209   MA08.1
                                                                 MA208   PO190
                                                                 POIJ.1  POIT.1

PAM-ACTIVE-FLAG      Alpha 1                                     AP220   AP520
Status               The Active flag of the credit card          API1.1  API2.1
                     type.                                       BL09.1  BL12.1
                     A = Active                                  BL209   MA08.1
                     I = Inactive                                MA208   PO190
                                                                 POIJ.1  POIT.1

PAM-TAXABLE-FLAG     Alpha 1                                     AP220   AP520
Taxable              Defines if taxable.                         API1.1  API2.1
                     N = No                                      BL09.1  BL12.1
                     Y = Yes                                     BL209   MA08.1
                                                                 MA208   PO190
                                                                 POIJ.1  POIT.1

PAM-AOC-ON-PO        Alpha 1                                     AP220   AP520
Aoc On Po            Indicates if the add-on cost is to          API1.1  API2.1
                     appear on the Purchase Order document       BL09.1  BL12.1
                     that is issued to the vendor.               BL209   MA08.1
                     N = No                                      MA208   PO190
                     Y = Yes                                     POIJ.1  POIT.1

PAM-SUMMARY-FLAG     Alpha 1                                     AP220   AP520
Summary Only         Print in summary only on the purchase       API1.1  API2.1
                     order.                                      BL09.1  BL12.1
                     N = No                                      BL209   MA08.1
                     Y = Yes                                     MA208   PO190
                                                                 POIJ.1  POIT.1

PAM-AOC-TYPE         Alpha 1                                     AP220   AP520
Aoc Type             C = Cost                                    API1.1  API2.1
                     A = Allowance                               BL09.1  BL12.1
                                                                 BL209   MA08.1
                                                                 MA208   PO190
                                                                 POIJ.1  POIT.1

PAM-DIFF-ACCT-UNIT   Alpha 15                                    AP220   AP520
Diff Acct Unit                                                   API1.1  API2.1
                                                                 BL09.1  BL12.1
                                                                 BL209   MA08.1
                                                                 MA208   PO190
                                                                 POIJ.1  POIT.1

PAM-DIFF-ACCOUNT     Numeric 6                                   AP220   AP520
Diff Account                                                     API1.1  API2.1
                                                                 BL09.1  BL12.1
                                                                 BL209   MA08.1
                                                                 MA208   PO190
                                                                 POIJ.1  POIT.1

PAM-DIFF-SUB-ACCT    Numeric 4                                   AP220   AP520
Diff Sub Acct                                                    API1.1  API2.1
                                                                 BL09.1  BL12.1
                                                                 BL209   MA08.1
                                                                 MA208   PO190
                                                                 POIJ.1  POIT.1

                         POAOCMAST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PAMSET1   COMPANY                                                AP220   AP520
          AOC-CODE                                               API1.1  API2.1
                                                                 BL09.1  BL12.1
                                                                 BL209   MA01.1
                                                                 MA08.1  MA208
                                                                 PO190   PO220
                                                                 PO67.1  POI7.1
                                                                 POIJ.1  POIT.1

PAMSET2   COMPANY       KeyChange
          AOC-CODE
          AOC-TYPE

PAMSET3   AOC-CODE                                               AP220   AP520
          COMPANY                                                API1.1  API2.1
                                                                 BL09.1  BL12.1
                                                                 BL209   MA08.1
                                                                 MA208   PO190
                                                                 PO225   POIJ.1
                                                                 POIT.1

                         POAOCMAST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pocompany      POCOMPANY    Required

                            PAM-COMPANY    -> PCY-COMPANY