|
|
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
BL92.1 IN20.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 OE113 OE114 OE129
OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5
OE15.7 OE510 OE810 OE920 PO100 WH20.2
WH20.7
UPDATED BY
MA300 MA40.1 MA41.4 MA41.6 MA43.4 PO21.2
PO22.3 PO20.1 RQ20.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PSP-COMPANY Numeric 4 MA41.6 PO21.2
Company The company number.
PSP-PO-NUMBER Alpha 7 (Right Justified) MA41.6 PO21.2
PO Number This field contains the number PO22.3
representing the purchase order.
PSP-PO-RELEASE Numeric 6 MA41.6 PO21.2
PO Release Number Used to identify a purchase order PO22.3
release (created from a Blanket or
Standing order).
PSP-AOC-CODE Alpha 2 MA41.6 PO21.2
Add On Cost Code This field contains the identifier for
the add-on cost associated with this
line item.
PSP-INVOICE Alpha 22 MA41.6 PO21.2
Invoice Number Used to identify the invoice.
PSP-SPREAD-TYPE Alpha 1 MA41.6 PO21.2
Spread Type Spread type defines at which process
the spreading has occurred:
E indicates the purchase order add-on
cost entry process.
I indicates purchase order add-on cost
invoicing process.
PSP-AOC-RATE Percent 7.3 (Percent) MA41.6 PO21.2
Add On Cost Rate 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.
PSP-ENT-AOC-AMOUNT Signed 15.2 MA41.6 PO21.2
Ent Aoc Amount The amount, which is to be spread by PO22.3
the defined method across the purchase
order or invoice.
PSP-CALC-SPRD-AMT Signed 15.2 MA41.6 PO21.2
Calculated Spread This calculated amount is the PO22.3
Amount accumulation of all add-on cost unit
costs extended for the purchase order
after using the spread feature.
PSP-SPREAD-DIFF Signed 15.2 MA41.6 PO21.2
Spread Difference The difference between the entered PO22.3
spread amount and the accumulated spread
amount for the purchase order.
PSP-SPREAD-METHOD Alpha 1 MA41.6 PO21.2
Spread Method A method of spreading add-on cost
amounts across the purchase order line
level.
Q = Quantity
W = Weight
V = Volume
A = Amount
PSP-TAX-CODE Alpha 10 MA41.6 PO21.2
Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
PSP-DIST-COMPANY Numeric 4 MA41.6
Distribution Company The company number used for posting the
transaction. A valid intercompany
relationship must be defined in the
General Ledger system.
PSP-DST-ACCT-UNIT Alpha 15 MA41.6
Distribution Contains the General Ledger accounting
Accounting Unit unit to which the amount is posted.
PSP-DST-ACCOUNT Numeric 6 MA41.6
Distribution Contains the General Ledger account to
Account Number which the amount is posted.
PSP-DST-SUB-ACCT Numeric 4 MA41.6
Distribution Contains the General Ledger subaccount
Subaccount Number to which the amount is posted.
PSP-TAXABLE-FLAG Alpha 1 MA41.6 PO21.2
Taxable or Defines if taxable.
Non-Taxable Flag
PSP-PRINT-FLAG Alpha 1 MA41.6 PO21.2
Print Flag Indicates if the system prints the
add-on cost on the purchase order.
PSP-SUMMARY-FLAG Alpha 1 MA41.6 PO21.2
Summary Flag Defines if the add-on cost is printed
in summary or at a detail level on the
purchase order.
PSP-VENDOR Alpha 9 MA41.6 PO21.2
Vendor ID The vendor's identification code.
PSP-PURCH-FR-LOC Alpha 4 MA41.6 PO21.2
Purchase From The vendor's purchase from location.
Location Code
POAOCSPRD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PSPSET1 COMPANY MA300 PO20.1
PO-NUMBER PO21.2 PO21.5
PO-RELEASE RQ20.4
AOC-CODE
INVOICE
SPREAD-TYPE
PSPSET2 COMPANY Subset BL92.1 IN20.1
PO-NUMBER Where INVOICE = Spaces MA41.6 OE10.1
PO-RELEASE And SPREAD-TYPE = "E" OE10.2 OE10.3
AOC-CODE OE10.4 OE10.5
INVOICE OE10.6 OE10.7
SPREAD-TYPE OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 PO100
...
PSPSET3 COMPANY Subset MA40.1 MA41.4
INVOICE Where INVOICE != Spaces MA41.6 MA43.4
AOC-CODE And SPREAD-TYPE = "I"
PO-NUMBER
PO-RELEASE
SPREAD-TYPE
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
Poinvoice POINVOICE Required
When PSP-SPREAD-TYPE = "I"
And PSP-INVOICE != Spaces
PSP-COMPANY -> POI-COMPANY
PSP-PO-NUMBER -> POI-PO-NUMBER
PSP-PO-RELEASE -> POI-PO-RELEASE
PCR-VENDOR -> POI-VENDOR
PSP-INVOICE -> POI-INVOICE
Zeroes -> POI-SUFFIX
Purchorder PURCHORDER Required
When PSP-SPREAD-TYPE = "E"
And PSP-INVOICE = Spaces
PSP-COMPANY -> PCR-COMPANY
PSP-PO-NUMBER -> PCR-PO-NUMBER
PSP-PO-RELEASE -> PCR-PO-RELEASE
POAOCSPRD FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Poaocdtl POAOCDTL Delete Cascades
PSP-COMPANY -> PAO-COMPANY
PSP-AOC-CODE -> PAO-AOC-CODE
PSP-PO-NUMBER -> PAO-PO-NUMBER
PSP-PO-RELEASE -> PAO-PO-RELEASE
PAO-ORDER-NAME
PAO-LINE-NBR
Poapprove POAPPROVE Delete Cascades
PSP-COMPANY -> POA-COMPANY
PSP-VENDOR -> POA-VENDOR
PSP-INVOICE -> POA-INVOICE
Zeroes -> POA-SUFFIX
PSP-PO-NUMBER -> POA-PO-NUMBER
PSP-PO-RELEASE -> POA-PO-RELEASE
POA-LINE-NBR
POA-AOC-CODE
|