 |
Lawson Insight Technical Documentation |
|
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
POI7.1 API5.1
UPDATED BY
AP115 AP125 AP126 AP131 AP180 AP181
AP190 AP198 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 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 IC28.1 MA180
MA41.2 MA43.2 MA43.9 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.3 MA67.1 MA67.2
MA70.1 MAI1.1 PO100 PO101 PO122 PO131
PO20.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 POI3.1 POIE.1 POII.1 POIJ.1 RQ10.1
RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PSP-COMPANY Numeric 4 AP115 AP180
Company The company number. AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PSP-PO-NUMBER Alpha 14 (Right Justified) AP115 AP180
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
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PSP-PO-RELEASE Numeric 4 AP115 AP180
PO Release Number 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
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PSP-PO-CODE Alpha 4 AP115 AP180
Po Code This is the purchase order code. AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PSP-AOC-CODE Alpha 2 AP115 AP180
Add On Cost 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
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PSP-INVOICE Alpha 22 AP115 AP180
Invoice Number Used to identify the invoice. AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PSP-AOC-RATE Percent 7.3 (Percent) AP115 AP180
Add On Cost 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
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PSP-ENT-AOC-AMOUNT Signed 15.2 AP115 AP180
Ent Aoc Amount 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
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PSP-CALC-SPRD-AMT Signed 15.2 AP115 AP180
Calculated Spread This calculated amount is the AP181 AP190
Amount 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
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
MA61.1 MA70.1
MAI1.1 PO21.2
PO21.4 PO21.5
PO29.1
PSP-SPREAD-DIFF Signed 15.2 AP115 AP180
Spread Difference 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
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
MA61.1 MA70.1
PO21.2 PO21.4
PO21.5
PSP-SPREAD-METHOD Alpha 1 AP115 AP180
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 AP220 AP23.1
V = Volume AP25.2 AP26.1
A = Amount AP27.1 AP28.1
N = No Spread AP28.2 AP30.4
R = Rate AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PSP-TAX-CODE Alpha 10 AP115 AP180
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
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PSP-DST-ACCT-UNIT Alpha 15 AP115 AP180
Distribution Contains the General Ledger accounting AP181 AP190
Accounting Unit unit to which the amount is posted. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PSP-DST-ACCOUNT Numeric 6 AP115 AP180
Distribution Contains the General Ledger account to AP181 AP190
Account Number which the amount is posted. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PSP-DST-SUB-ACCT Numeric 4 AP115 AP180
Distribution Contains the General Ledger subaccount AP181 AP190
Subaccount Number to which the amount is posted. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PSP-TAXABLE-FLAG Alpha 1 AP115 AP180
Taxable or Defines if taxable. AP181 AP190
Non-Taxable Flag Y = Yes AP20.1 AP20.2
N = No AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PSP-ACCRUAL-FL Alpha 1 AP115 AP180
Accrual Flag I = Invoiced AP181 AP190
A = Accrued AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PSP-TAX-AMOUNT Signed 13.5 AP115 AP180
Tax Amount AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PSP-AOC-ON-PO Alpha 1 AP115 AP180
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 AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PSP-SUMMARY-FLAG Alpha 1 AP115 AP180
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 AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PSP-VENDOR Alpha 9 (Right Justified) AP115 AP180
Vendor ID The vendor's identification code. AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PSP-PURCH-FR-LOC Alpha 4 AP115 AP180
Purchase From The vendor's purchase from location. AP181 AP190
Location Code AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PO21.2 PO21.4
PO21.5 PO29.1
PSP-SEGMENT-BLOCK Alpha 103 AP115 AP180
User Analysis 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 AP220 AP23.1
Analysis Entry subform. Use this subform AP25.2 AP26.1
to select the user analysis values you AP27.1 AP28.1
want to include in the transaction. If AP28.2 AP30.4
you choose to type values, use commas to AP305 AP45.1
separate them. For example: API1.1 API2.1
value1,value2,value3,value4 MA41.2 MA43.2
There are three conditions that affect
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
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. AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA43.2
PSP-ACCT-CATEGORY Alpha 5 AP115 AP180
Account 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 AP220 AP23.1
posted to an account category within an AP25.2 AP26.1
activity. You can assign a specific AP27.1 AP28.1
General Ledger account or range of AP28.2 AP30.4
accounts (company, accounting unit, AP305 AP45.1
account, and subaccount) that make up API1.1 API2.1
the transactions posted to an account MA41.2 MA43.2
category using AC07.1 (Account
Assignment).
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.
POAOCSPRD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PSPSET1 COMPANY AP125 AP126
PO-NUMBER AP131 AP25.1
PO-RELEASE AP25.2 AP26.1
PO-CODE AP27.1 IC28.1
AOC-CODE MA180 MA43.9
INVOICE MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
...
PSPSET2 COMPANY Subset PO21.2 PO21.4
PO-NUMBER Where INVOICE = Spaces PO21.5 PO29.1
PO-RELEASE
PO-CODE
AOC-CODE
INVOICE
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
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP300
AP305 API1.1
API2.1 API5.1
MA41.2 MA43.2
MA61.1 MA70.1
MAI1.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
|