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 PO25.5 PO27.2 POIT.1
UPDATED BY
AP115 AP125 AP126 AP131 AP180 AP181
AP190 AP198 AP220 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 IC28.1 MA180 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 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE111 OE113 OE114 OE116
OE129 OE13.2 OE13.3 OE13.5 OE13.6 OE14.4
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE530 OE81.1 OE810
OE830 OE90.1 OE90.2 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 AP125
Element: Company The company number. AP126 AP180
AP181 AP190
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-PO-NUMBER Alpha 14 (Right Justified) AP115 AP125
Element: PO Number This field contains the number AP126 AP180
representing the purchase order. AP181 AP190
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-PO-RELEASE Numeric 4 AP115 AP125
Element: PO Release NumUsed to identify a purchase order AP126 AP180
release (created from a Blanket or AP181 AP190
Standing order). AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-PO-CODE Alpha 4 AP115 AP125
Element: Po Code This is the purchase order code. AP126 AP180
AP181 AP190
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-AOC-CODE Alpha 2 AP115 AP125
Element: Add On Cost CoThis field contains the identifier for AP126 AP180
the add-on cost associated with this AP181 AP190
line item. AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-INVOICE Alpha 22 AP115 AP125
Element: Invoice NumberUsed to identify the invoice. AP126 AP180
AP181 AP190
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-AOC-RATE Percent 7.3 (Percent) AP115 AP125
Element: Add On Cost RaAdd-on cost percentage rate. If add-on AP126 AP180
cost is spread by rate, this value times AP181 AP190
the line unit cost is the unit add-on AP220 AP25.1
cost for the purchase order line. AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-ENT-AOC-AMOUNT Signed 18.2 AP115 AP125
Element: Intl Amt The amount, which is to be spread by AP126 AP180
the defined method across the purchase AP181 AP190
order or invoice. AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-CALC-SPRD-AMT Signed 18.2 AP115 AP125
Element: Intl Amt This calculated amount is the AP126 AP180
accumulation of all add-on cost unit AP181 AP190
costs extended for the purchase order AP220 AP25.1
after using the spread feature. AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA61.1 MA66.2
MA70.1 MA75.1
MAI1.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-SPREAD-DIFF Signed 18.2 AP115 AP125
Element: Intl Amt The difference between the entered AP126 AP180
spread amount and the accumulated spread AP181 AP190
amount for the purchase order. AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
MA61.1 MA66.2
MA70.1 MA75.1
PO21.2 PO21.4
PO21.5
PSP-SPREAD-METHOD Alpha 1 AP115 AP125
Element: Spread Method A method of spreading add-on cost AP126 AP180
amounts across the purchase order line AP181 AP190
level. AP220 AP25.1
Q = Quantity AP25.2 AP26.1
W = Weight AP27.1 AP28.1
V = Volume AP28.2 AP30.4
A = Amount AP305 AP45.1
N = No Spread API1.1 API2.1
R = Rate PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-TAX-CODE Alpha 10 AP115 AP125
Element: Tax Code This field contains a code representing AP126 AP180
specific tax information. This must be AP181 AP190
valid Tax Code. AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-DST-ACCT-UNIT Alpha 15 AP115 AP125
Element: Accounting UniContains the General Ledger accounting AP126 AP180
unit to which the amount is posted. AP181 AP190
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-DST-ACCOUNT Numeric 6 AP115 AP125
Element: Account Contains the General Ledger account to AP126 AP180
which the amount is posted. AP181 AP190
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-DST-SUB-ACCT Numeric 4 AP115 AP125
Element: Subaccount Contains the General Ledger subaccount AP126 AP180
to which the amount is posted. AP181 AP190
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-TAXABLE-FLAG Alpha 1 AP115 AP125
Taxable or Defines if taxable. AP126 AP180
Non-Taxable Flag Y = Yes AP181 AP190
N = No AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-ACCRUAL-FL Alpha 1 AP115 AP125
Element: Accrual Flag I = Invoiced AP126 AP180
A = Accrued AP181 AP190
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PSP-TAX-AMOUNT Signed 18.5 AP115 AP125
Element: Intl Cost AP126 AP180
AP181 AP190
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PSP-AOC-ON-PO Alpha 1 AP115 AP125
Element: Aoc On Po Indicates if the add-on cost is to AP126 AP180
appear on the Purchase Order document AP181 AP190
that is issued to the vendor. AP220 AP25.1
Y = Yes AP25.2 AP26.1
N = No AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-SUMMARY-FLAG Alpha 1 AP115 AP125
Element: Summary Flag Defines if the add-on cost is printed AP126 AP180
in summary or at a detail level on the AP181 AP190
purchase order. AP220 AP25.1
N = No AP25.2 AP26.1
Y = Yes AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-VENDOR Alpha 9 (Right Justified) AP115 AP125
Element: Vendor ID The vendor's identification code. AP126 AP180
AP181 AP190
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-PURCH-FR-LOC Alpha 4 AP115 AP125
Purchase From The vendor's purchase from location. AP126 AP180
Location Code AP181 AP190
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-SEGMENT-BLOCK Alpha 103 AP115 AP125
Element: User Analysis This field identifies the user analysis AP126 AP180
values included in the transaction. AP181 AP190
AP220 AP25.1
You can either type up to four values AP25.2 AP26.1
or use Define (F6) to open the User AP27.1 AP28.1
Analysis Entry subform. Use this subform AP28.2 AP30.4
to select the user analysis values you AP305 AP45.1
want to include in the transaction. If API1.1 API2.1
you choose to type values, use commas to
separate them. For example:
value1,value2,value3,value4
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 AP125
Element: Activity Activities are the processes or AP126 AP180
procedures that produce work. Cost AP181 AP190
objects (products, services, customers, AP220 AP25.1
and so on) are the reasons for AP25.2 AP26.1
performing the activity. AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PSP-ACCT-CATEGORY Alpha 5 AP115 AP125
Element: Account CategoAccount categories are groupings of AP126 AP180
costs, revenues, or a combination of AP181 AP190
both used for reporting and inquiries AP220 AP25.1
for activities in the Activity AP25.2 AP26.1
Management system. All transactions are AP27.1 AP28.1
posted to an account category within an AP28.2 AP30.4
activity. You can assign a specific AP305 AP45.1
General Ledger account or range of API1.1 API2.1
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
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.
Valid account category types are:
cost
revenue
accrual
pass thru
PSP-BILL-CATEGORY Alpha 32 AP115 AP125
Element: Bill Category AP126 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP305
API1.1 API2.1
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 AP30.4
AOC-CODE API5.1 BL120
INVOICE BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
...
PSPSET2 COMPANY Subset AP125 AP126
PO-NUMBER Where INVOICE = Spaces AP131 AP25.1
PO-RELEASE AP25.2 AP26.1
PO-CODE AP27.1 AP30.4
AOC-CODE BL120 BL122
INVOICE BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
...
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 AP220 AP25.1
AOC-CODE AP25.2 AP26.1
AP27.1 AP30.4
AP300 AP305
API1.1 API2.1
API5.1 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
|