 |
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 AP180 AP181 AP190 AP198 AP220
AP28.1 AP28.2 AP30.4 AP300 AP305 AP45.1
API1.1 API2.1 POIJ.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PSP-COMPANY Numeric 4 AP115 AP180
Company The company number. AP181 AP190
AP220 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PSP-PO-NUMBER Alpha 14 (Right Justified) AP115 AP180
PO Number This field contains the number AP181 AP190
representing the purchase order. AP220 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.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 AP220 AP28.1
Standing order). AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PSP-PO-CODE Alpha 4 AP115 AP180
Po Code This is the purchase order code. AP181 AP190
AP220 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.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 AP220 AP28.1
line item. AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PSP-INVOICE Alpha 22 AP115 AP180
Invoice Number Used to identify the invoice. AP181 AP190
AP220 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.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 AP220 AP28.1
the line unit cost is the unit add-on AP28.2 AP30.4
cost for the purchase order line. AP305 AP45.1
API1.1 API2.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 AP220 AP28.1
order or invoice. AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.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 AP220 AP28.1
costs extended for the purchase order AP28.2 AP30.4
after using the spread feature. AP305 AP45.1
API1.1 API2.1
PSP-SPREAD-DIFF Signed 15.2 AP115 AP180
Spread Difference The difference between the entered AP181 AP190
spread amount and the accumulated spread AP220 AP28.1
amount for the purchase order. AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PSP-SPREAD-METHOD Alpha 1 AP115 AP180
Spread Method A method of spreading add-on cost AP181 AP190
amounts across the purchase order line AP220 AP28.1
level. AP28.2 AP30.4
Q = Quantity AP305 AP45.1
W = Weight API1.1 API2.1
V = Volume
A = Amount
N = No Spread
R = Rate
PSP-TAX-CODE Alpha 10 AP115 AP180
Tax Code This field contains a code representing AP181 AP190
specific tax information. This must be AP220 AP28.1
valid Tax Code. AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.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. AP220 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PSP-DST-ACCOUNT Numeric 6 AP115 AP180
Distribution Contains the General Ledger account to AP181 AP190
Account Number which the amount is posted. AP220 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.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. AP220 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PSP-TAXABLE-FLAG Alpha 1 AP115 AP180
Taxable or Defines if taxable. AP181 AP190
Non-Taxable Flag Y = Yes AP220 AP28.1
N = No AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PSP-ACCRUAL-FL Alpha 1 AP115 AP180
Accrual Flag I = Invoiced AP181 AP190
A = Accrued AP220 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PSP-TAX-AMOUNT Signed 13.5 AP115 AP180
Tax Amount AP181 AP190
AP220 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
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 AP220 AP28.1
that is issued to the vendor. AP28.2 AP30.4
Y = Yes AP305 AP45.1
N = No API1.1 API2.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 AP220 AP28.1
purchase order. AP28.2 AP30.4
N = No AP305 AP45.1
Y = Yes API1.1 API2.1
PSP-VENDOR Alpha 9 (Right Justified) AP115 AP180
Vendor ID The vendor's identification code. AP181 AP190
AP220 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PSP-PURCH-FR-LOC Alpha 4 AP115 AP180
Purchase From The vendor's purchase from location. AP181 AP190
Location Code AP220 AP28.1
AP28.2 AP30.4
AP305 AP45.1
API1.1 API2.1
PSP-SEGMENT-BLOCK Alpha 103 AP115 AP180
User Analysis This field identifies the user analysis AP181 AP190
values included in the transaction. AP220 AP28.1
AP28.2 AP30.4
You can either type up to four values AP305 AP45.1
or use Define (F6) to open the User API1.1 API2.1
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.
PSP-ACTIVITY Alpha 15 AP115 AP180
Activity Activities are the processes or AP181 AP190
procedures that produce work. Cost AP220 AP28.1
objects (products, services, customers, AP28.2 AP30.4
and so on) are the reasons for AP305 AP45.1
performing the activity. API1.1 API2.1
PSP-ACCT-CATEGORY Alpha 5 AP115 AP180
Account Category Account categories are groupings of AP181 AP190
costs, revenues, or a combination of AP220 AP28.1
both used for reporting and inquiries AP28.2 AP30.4
for activities in the Activity AP305 AP45.1
Management system. All transactions are API1.1 API2.1
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.
POAOCSPRD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PSPSET1 COMPANY POI7.1 POIJ.1
PO-NUMBER
PO-RELEASE
PO-CODE
AOC-CODE
INVOICE
PSPSET2 COMPANY Subset
PO-NUMBER Where INVOICE = Spaces
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 AP198
VENDOR Where INVOICE != Spaces AP220 AP30.4
INVOICE AP300 AP305
AOC-CODE API1.1 API2.1
API5.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
|