POAOCSPRD

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 MA26.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 AP305
AP45.1 AP510 API1.1 API2.1 API6.4 CX100
CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1
CX300 CX506 CXCP.1 DR100 IC12.1 IC140
IC141 IC142 IC145 IC243 IC330 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC83.1 MA180 MA278
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA43.7 MA44.1 MA44.2 MA53.1 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 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 PD570 PO04.1 PO04.2 PO10.1
PO10.2 PO100 PO101 PO115 PO120 PO122
PO131 PO132 PO136 PO15.1 PO15.2 PO15.4
PO150 PO17.1 PO190 PO20.1 PO20.6 PO20.9
PO204 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO220 PO222 PO224
PO225 PO229 PO23.1 PO230 PO234 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO26.3
PO26.7 PO26.9 PO27.2 PO27.3 PO27.4 PO275
PO276 PO277 PO28.2 PO280 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 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 PO54.5 POCP.1 POD0.1
POI3.1 POID.1 POII.1 POIJ.1 RQ01.1 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810
RQIB.1 RQIF.1 RQII.1 RQIJ.1 WH130 WH132
WH190 WH20.2 WH20.7 WH222 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830 AP198 AP300

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PSP-COMPANY
Element: Company
Numeric 4
The company number.
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-PO-NUMBER
Element: Po Number
Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-PO-RELEASE
Element: Po Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-AOC-CODE
Element: Aoc Code
Alpha 2
This field contains the identifier for the add-on cost associated with this line item.
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-AOC-RATE
Element: Aoc Rate
Percent 7.3 (Percent)
Add-on cost percentage rate. If add-on cost is spread by rate, this value times the line unit cost is the unit add-on cost for the purchase order line.
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-ENT-AOC-AMOUNT
Element: Intl Amt
Signed 18.2
The amount, which is to be spread by the defined method across the purchase order or invoice.
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-CALC-SPRD-AMT
Element: Intl Amt
Signed 18.2
This calculated amount is the accumulation of all add-on cost unit costs extended for the purchase order after using the spread feature.
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA66.2
MA70.1 MA75.1
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-SPREAD-DIFF
Element: Intl Amt
Signed 18.2
The difference between the entered spread amount and the accumulated spread amount for the purchase order.
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA66.2
MA70.1 MA75.1
PO21.2 PO21.4
PO21.5 PO29.1
PO520
PSP-SPREAD-METHOD
Element: Spread Method
Alpha 1
A method of spreading add-on cost amounts across the purchase order line level.
Q = Quantity
W = Weight
V = Volume
A = Amount
N = No Spread
R = Rate
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-DST-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-DST-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-DST-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-TAXABLE-FLAG
Element: Taxable Flag
Alpha 1
Defines if taxable.
Y = Yes
N = No
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-ACCRUAL-FL
Element: Accrual Fl
Alpha 1

I = Invoiced
A = Accrued
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1
PSP-TAX-AMOUNT
Element: Intl Cost
Signed 18.5
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1
PSP-AOC-ON-PO
Element: Aoc On Po
Alpha 1
Indicates if the add-on cost is to appear on the Purchase Order document that is issued to the vendor.
Y = Yes
N = No
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-SUMMARY-FLAG
Element: Summary Flag
Alpha 1
Defines if the add-on cost is printed in summary or at a detail level on the purchase order.
N = No
Y = Yes
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-PURCH-FR-LOC
Element: Purch Fr Loc
Alpha 4
The vendor's purchase from location.
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 PO21.2
PO21.4 PO21.5
PO29.1 PO520
PSP-SEGMENT-BLOCK
Element: Segment Block
Alpha 103
This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If 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.
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1
PSP-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1
PSP-ACCT-CATEGORY
Element: Acct Category
Alpha 5
Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of 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
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.2
AP27.1 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1
PSP-BILL-CATEGORY
Element: Bill Category
Alpha 32
AP115 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.2 AP27.1
AP30.4 AP305
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1
PSP-GLBL-DOC-TYPE
Element: Glbl Doc Type
Alpha 10


POAOCSPRD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PSPSET1 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
AOC-CODE
INVOICE
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 API5.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
PSPSET2 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
AOC-CODE
INVOICE
Subset
WhereINVOICE =Spaces
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
PSPSET3 COMPANY
INVOICE
AOC-CODE
PO-NUMBER
PO-RELEASE
PO-CODE
Subset
WhereINVOICE !=Spaces
PSPSET4 COMPANY
VENDOR
INVOICE
AOC-CODE
KeyChange, Subset
WhereINVOICE !=Spaces
...
AP115 AP125
AP126 AP198
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 AP30.4
AP300 AP305
API1.1 API2.1
API6.4 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1


POAOCSPRD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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-LINE-SEQ
  PAU-PO-REVISION
  PAU-UPDATE-DATE
  PAU-UPDATE-TIME
  PAU-FLD-NBR
  PAU-AUDIT-TYPE
  PAU-AUDIT-ACTION


File created: Thu Jun 09 02:26:39 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.