Lawson Insight Technical Documentation |
|
POAOCSPRD
POAOCSPRD FILE
Add On Cost Spread
This file is used internally to document the add on cost spread method used
when entering or invoicing a Lawson Purchase Order.
REFERENCED BY
API5.1 MA540 POI7.1 POIT.1
UPDATED BY
AP115 AP125 AP126 AP131 AP180 AP181
AP190 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP21.1 AP220 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP28.1 AP28.2 AP30.4 AP300
AP305 AP45.1 API1.1 API2.1 BL120 BL122
BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1
BL29.2 BL520 BL820 BL92.1 MA180 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.7 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA66.3 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PO100 PO101 PO122 PO131 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.1
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO27.2
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO32.4 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 POD0.1 POI3.1
POID.1 POII.1 POIJ.1 RQ10.1 RQ10.2 WH20.2
WH20.7 AP198
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PSP-COMPANY Numeric 4 AP115 AP180
Element: Company The company number. AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-PO-NUMBER Alpha 14 (Right Justified) AP115 AP180
Element: Po Number This field contains the number AP181 AP190
representing the purchase order. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-PO-RELEASE Numeric 4 AP115 AP180
Element: Po Release Used to identify a purchase order AP181 AP190
release (created from a Blanket or AP20.1 AP20.2
Standing order). AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-PO-CODE Alpha 4 AP115 AP180
Element: Po Code This is the purchase order code. AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-AOC-CODE Alpha 2 AP115 AP180
Element: Aoc Code This field contains the identifier for AP181 AP190
the add-on cost associated with this AP20.1 AP20.2
line item. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-INVOICE Alpha 22 AP115 AP180
Element: Invoice Used to identify the invoice. AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-AOC-RATE Percent 7.3 (Percent) AP115 AP180
Element: Aoc Rate Add-on cost percentage rate. If add-on AP181 AP190
cost is spread by rate, this value times AP20.1 AP20.2
the line unit cost is the unit add-on AP20.3 AP20.4
cost for the purchase order line. AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-ENT-AOC-AMOUNT Signed 18.2 AP115 AP180
Element: Intl Amt The amount, which is to be spread by AP181 AP190
the defined method across the purchase AP20.1 AP20.2
order or invoice. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-CALC-SPRD-AMT Signed 18.2 AP115 AP180
Element: Intl Amt This calculated amount is the AP181 AP190
accumulation of all add-on cost unit AP20.1 AP20.2
costs extended for the purchase order AP20.3 AP20.4
after using the spread feature. AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA66.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-SPREAD-DIFF Signed 18.2 AP115 AP180
Element: Intl Amt The difference between the entered AP181 AP190
spread amount and the accumulated spread AP20.1 AP20.2
amount for the purchase order. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA66.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-SPREAD-METHOD Alpha 1 AP115 AP180
Element: Spread Method A method of spreading add-on cost AP181 AP190
amounts across the purchase order line AP20.1 AP20.2
level. AP20.3 AP20.4
Q = Quantity AP20.5 AP20.7
W = Weight AP21.1 AP220
V = Volume AP23.1 AP25.2
A = Amount AP26.1 AP27.1
N = No Spread AP28.1 AP28.2
R = Rate AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-TAX-CODE Alpha 10 AP115 AP180
Element: Tax Code This field contains a code representing AP181 AP190
specific tax information. This must be AP20.1 AP20.2
valid Tax Code. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-DST-ACCT-UNIT Alpha 15 AP115 AP180
Element: Acct Unit The accounting unit is a shorthand AP181 AP190
notation representing the variable level AP20.1 AP20.2
number. When used in the General Ledger AP20.3 AP20.4
Account Master file, the accounting unit AP20.5 AP20.7
must be defined in the General Ledger AP21.1 AP220
Names file as a posting accounting unit. AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-DST-ACCOUNT Numeric 6 AP115 AP180
Element: Account This field along with the accounting AP181 AP190
unit and subaccount make up the location AP20.1 AP20.2
(account) where amounts and other AP20.3 AP20.4
account information is stored. AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-DST-SUB-ACCT Numeric 4 AP115 AP180
Element: Sub Acct This field contains the subaccount from AP181 AP190
your general ledger chart of accounts AP20.1 AP20.2
that was charged with the amount carried AP20.3 AP20.4
on this record. AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-TAXABLE-FLAG Alpha 1 AP115 AP180
Element: Taxable Flag Defines if taxable. AP181 AP190
Y = Yes AP20.1 AP20.2
N = No AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-ACCRUAL-FL Alpha 1 AP115 AP180
Element: Accrual Fl I = Invoiced AP181 AP190
A = Accrued AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PSP-TAX-AMOUNT Signed 18.5 AP115 AP180
Element: Intl Cost AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PSP-AOC-ON-PO Alpha 1 AP115 AP180
Element: Aoc On Po Indicates if the add-on cost is to AP181 AP190
appear on the Purchase Order document AP20.1 AP20.2
that is issued to the vendor. AP20.3 AP20.4
Y = Yes AP20.5 AP20.7
N = No AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-SUMMARY-FLAG Alpha 1 AP115 AP180
Element: Summary Flag Defines if the add-on cost is printed AP181 AP190
in summary or at a detail level on the AP20.1 AP20.2
purchase order. AP20.3 AP20.4
N = No AP20.5 AP20.7
Y = Yes AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-VENDOR Alpha 9 (Right Justified) AP115 AP180
Element: Vendor The vendor's identification code. AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-PURCH-FR-LOC Alpha 4 AP115 AP180
Element: Purch Fr Loc The vendor's purchase from location. AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-SEGMENT-BLOCK Alpha 103 AP115 AP180
Element: Segment Block This field identifies the user analysis AP181 AP190
values included in the transaction. AP20.1 AP20.2
AP20.3 AP20.4
You can either type up to four values AP20.5 AP20.7
or use Define (F6) to open the User AP21.1 AP220
Analysis Entry subform. Use this subform AP23.1 AP25.2
to select the user analysis values you AP26.1 AP27.1
want to include in the transaction. If AP28.1 AP28.2
you choose to type values, use commas to AP30.4 AP305
separate them. For example: AP45.1 API1.1
value1,value2,value3,value4 API2.1 MA41.1
MA41.2 MA41.4
There are three conditions that affect MA41.7 MA43.2
how you can select user analysis values.
See the User Analysis Entry form help or
the Strategic Ledger procedures manual
for additional information.
PSP-ACTIVITY Alpha 15 AP115 AP180
Element: Activity Activities are the processes or AP181 AP190
procedures that produce work. Cost AP20.1 AP20.2
objects (products, services, customers, AP20.3 AP20.4
and so on) are the reasons for AP20.5 AP20.7
performing the activity. AP21.1 AP220
AP23.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP305
AP45.1 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
PSP-ACCT-CATEGORY Alpha 5 AP115 AP180
Element: Acct Category Account categories are groupings of AP181 AP190
costs, revenues, or a combination of AP20.1 AP20.2
both used for reporting and inquiries AP20.3 AP20.4
for activities in the Activity AP20.5 AP20.7
Management system. All transactions are AP21.1 AP220
posted to an account category within an AP23.1 AP25.2
activity. You can assign a specific AP26.1 AP27.1
General Ledger account or range of AP28.1 AP28.2
accounts (company, accounting unit, AP30.4 AP305
account, and subaccount) that make up AP45.1 API1.1
the transactions posted to an account API2.1 MA41.1
category using AC07.1 (Account MA41.2 MA41.4
Assignment). MA41.7 MA43.2
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
PSP-BILL-CATEGORY Alpha 32 AP115 AP20.1
Element: Bill Category AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
POAOCSPRD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PSPSET1 COMPANY AP125 AP126
PO-NUMBER AP131 AP20.1
PO-RELEASE AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
AOC-CODE AP20.7 AP21.1
INVOICE AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API5.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
PSPSET2 COMPANY Subset AP125 AP126
PO-NUMBER Where INVOICE = Spaces AP131 AP20.1
PO-RELEASE AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
AOC-CODE AP20.7 AP21.1
INVOICE AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
PSPSET3 COMPANY Subset
INVOICE Where INVOICE != Spaces
AOC-CODE
PO-NUMBER
PO-RELEASE
PO-CODE
PSPSET4 COMPANY KeyChange, Subset AP115 AP125
VENDOR Where INVOICE != Spaces AP126 AP198
INVOICE AP20.1 AP20.2
AOC-CODE AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP300 AP305
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA66.2 MA70.1
...
POAOCSPRD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Poaocmast POAOCMAST Required
PSP-COMPANY -> PAM-COMPANY
PSP-AOC-CODE -> PAM-AOC-CODE
Txtaxcode TXTAXCODE Required
PSP-COMPANY -> TAC-COMPANY
PSP-TAX-CODE -> TAC-TAX-CODE
POAOCSPRD FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Poaudit POAUDIT
PSP-COMPANY -> PAU-COMPANY
PSP-PO-NUMBER -> PAU-PO-NUMBER
PSP-PO-RELEASE -> PAU-PO-RELEASE
PSP-PO-CODE -> PAU-PO-CODE
Zeroes -> PAU-PO-LINE-NBR
PSP-AOC-CODE -> PAU-AOC-CODE
PAU-PO-REVISION
PAU-UPDATE-DATE
PAU-UPDATE-TIME
PAU-FLD-NBR
PAU-AUDIT-TYPE
PAU-AUDIT-ACTION
|