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 POI7.1 POIT.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 MA41.7 MA43.1 MA43.2 MA43.3 MA43.9
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.1 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.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 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
POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQIE.1
WH20.2 WH20.7
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
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA41.7
MA43.2 PO21.2
PO21.4 PO21.5
PO29.1
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
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA41.7
MA43.2 PO21.2
PO21.4 PO21.5
PO29.1
PSP-PO-RELEASE Numeric 4 AP115 AP180
Element: PO Release NumUsed 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 MA41.7
MA43.2 PO21.2
PO21.4 PO21.5
PO29.1
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
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA41.7
MA43.2 PO21.2
PO21.4 PO21.5
PO29.1
PSP-AOC-CODE Alpha 2 AP115 AP180
Element: Add On Cost CoThis 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 MA41.7
MA43.2 PO21.2
PO21.4 PO21.5
PO29.1
PSP-INVOICE Alpha 22 AP115 AP180
Element: Invoice NumberUsed 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 MA41.7
MA43.2 PO21.2
PO21.4 PO21.5
PO29.1
PSP-AOC-RATE Percent 7.3 (Percent) AP115 AP180
Element: Add On Cost RaAdd-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 MA41.7
MA43.2 PO21.2
PO21.4 PO21.5
PO29.1
PSP-ENT-AOC-AMOUNT Signed 15.2 AP115 AP180
Element: Adj 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
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA41.7
MA43.2 PO21.2
PO21.4 PO21.5
PO29.1
PSP-CALC-SPRD-AMT Signed 15.2 AP115 AP180
Element: Adj 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
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA41.7
MA43.2 MA66.2
MA70.1 MA75.1
PO21.2 PO21.4
PO21.5 PO29.1
PSP-SPREAD-DIFF Signed 15.2 AP115 AP180
Element: Spread DiffereThe 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 MA41.7
MA43.2 MA66.2
MA70.1 MA75.1
PO21.2 PO21.4
PO21.5 PO29.1
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 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 MA41.7
MA43.2 PO21.2
PO21.4 PO21.5
PO29.1
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
AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA41.7
MA43.2 PO21.2
PO21.4 PO21.5
PO29.1
PSP-DST-ACCT-UNIT Alpha 15 AP115 AP180
Element: Accounting Unit 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 MA41.7
MA43.2 PO21.2
PO21.4 PO21.5
PO29.1
PSP-DST-ACCOUNT Numeric 6 AP115 AP180
Element: Account 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 MA41.7
MA43.2 PO21.2
PO21.4 PO21.5
PO29.1
PSP-DST-SUB-ACCT Numeric 4 AP115 AP180
Element: Subaccount 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 MA41.7
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 MA41.7
MA43.2 PO21.2
PO21.4 PO21.5
PO29.1
PSP-ACCRUAL-FL Alpha 1 AP115 AP180
Element: 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 MA41.7
MA43.2
PSP-TAX-AMOUNT Signed 13.5 AP115 AP180
Element: Base Cost 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 MA41.7
MA43.2
PSP-AOC-ON-PO Alpha 1 AP115 AP180
Element: All Flag Y = Yes AP181 AP190
N = No 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 MA41.7
MA43.2 PO21.2
PO21.4 PO21.5
PO29.1
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 AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA41.7
MA43.2 PO21.2
PO21.4 PO21.5
PO29.1
PSP-VENDOR Alpha 9 (Right Justified) AP115 AP180
Element: 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 MA41.7
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 MA41.7
MA43.2 PO21.2
PO21.4 PO21.5
PO29.1
PSP-SEGMENT-BLOCK Alpha 103 AP115 AP180
Element: 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 MA41.7
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
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. AP220 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA41.2 MA41.7
MA43.2
PSP-ACCT-CATEGORY Alpha 5 AP115 AP180
Element: Account CategoAccount 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 MA41.7
category using AC07.1 (Account MA43.2
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 AP20.1
PO-RELEASE AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
AOC-CODE AP20.7 AP23.1
INVOICE AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
API5.1 IC28.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
...
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 AP23.1
INVOICE AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
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 MA41.7
MA43.2 MA61.1
MA66.2 MA70.1
MA75.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
|