POAOCSPRD – Add On Cost Spread

System
Purchase Order (PO)
Prefix
PSP
Primary key
COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, AOC-CODE, INVOICE
Fields
27
Updated by
233 programs
Referenced by
5 programs

POAOCSPRD is the Add On Cost Spread table in Lawson Purchase Order (prefix PSP). It is indexed by COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, AOC-CODE, INVOICE (PSPSET1); alternate indexes: PSPSET2, PSPSET3 and PSPSET4. It is related 1:1 to POAOCMAST and TXTAXCODE and 1:M to POAUDIT. It is updated by AP115, AP125, AP126, AP131, AP180, AP181, AP190, AP198 and 225 more and referenced by API5.1, MA26.1, MA540, POI7.1 and POIT.1. The table has 27 fields, 4 indexes and 3 documented relations.

About POAOCSPRD

This file is used internally to document the add on cost spread method used when entering or invoicing a Lawson Purchase Order.

Fields (27)

Column = COBOL field name without the PSP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PSP-COMPANY PK
COMPANY		Numeric 4The company number.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +30 more
#PSP-PO-NUMBER PK
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 +30 more
#PSP-PO-RELEASE PK
PO_RELEASE		Numeric 4Used 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 +30 more
#PSP-PO-CODE PK
PO_CODE		Alpha 4This is the purchase order code.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +30 more
#PSP-AOC-CODE PK
AOC_CODE		Alpha 2This 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 +30 more
#PSP-INVOICE PK
INVOICE		Alpha 22Used to identify the invoice.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +30 more
#PSP-AOC-RATE
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 +30 more
#PSP-ENT-AOC-AMOUNT
ENT_AOC_AMOUNT		Signed 18.2The 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 +30 more
#PSP-CALC-SPRD-AMT
CALC_SPRD_AMT		Signed 18.2This 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 +31 more
#PSP-SPREAD-DIFF
SPREAD_DIFF		Signed 18.2The 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 +31 more
#PSP-SPREAD-METHOD
SPREAD_METHOD		Alpha 1A 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 +30 more
#PSP-TAX-CODE
TAX_CODE		Alpha 10This 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 +30 more
#PSP-DST-ACCT-UNIT
DST_ACCT_UNIT		Alpha 15The 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 +30 more
#PSP-DST-ACCOUNT
DST_ACCOUNT		Numeric 6This 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 +30 more
#PSP-DST-SUB-ACCT
DST_SUB_ACCT		Numeric 4This 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 +30 more
#PSP-TAXABLE-FLAG
TAXABLE_FLAG		Alpha 1Defines if taxable.
  • Y Yes
  • N No
AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +30 more
#PSP-ACCRUAL-FL
ACCRUAL_FL		Alpha 1—
  • I Invoiced
  • A Accrued
AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +25 more
#PSP-TAX-AMOUNT
TAX_AMOUNT		Signed 18.5—AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +25 more
#PSP-AOC-ON-PO
AOC_ON_PO		Alpha 1Indicates 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 +30 more
#PSP-SUMMARY-FLAG
SUMMARY_FLAG		Alpha 1Defines 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 +30 more
#PSP-VENDOR SET4
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +30 more
#PSP-PURCH-FR-LOC
PURCH_FR_LOC		Alpha 4The vendor's purchase from location.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +30 more
#PSP-SEGMENT-BLOCK
SEGMENT_BLOCK		Alpha 103This 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 +25 more
#PSP-ACTIVITY
ACTIVITY		Alpha 15Activities 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 +25 more
#PSP-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account 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 thruAP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +25 more
#PSP-BILL-CATEGORY
BILL_CATEGORY		Alpha 32—AP115, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1 +19 more
#PSP-GLBL-DOC-TYPE
GLBL_DOC_TYPE		Alpha 10——

Indexes (4)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PSPSET1
  1. COMPANY
  2. PO-NUMBER
  3. PO-RELEASE
  4. PO-CODE
  5. AOC-CODE
  6. INVOICE
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PSPSET2
  1. COMPANY
  2. PO-NUMBER
  3. PO-RELEASE
  4. PO-CODE
  5. AOC-CODE
  6. INVOICE
SubsetWhere INVOICE = SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PSPSET3
  1. COMPANY
  2. INVOICE
  3. AOC-CODE
  4. PO-NUMBER
  5. PO-RELEASE
  6. PO-CODE
SubsetWhere INVOICE != Spaces—
PSPSET4
  1. COMPANY
  2. VENDOR
  3. INVOICE
  4. AOC-CODE
KeyChange, SubsetWhere INVOICE != SpacesAP115, AP125, AP126, AP198, AP20.1, AP20.2, AP20.3, AP20.4 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
POAOCMASTTXTAXCODEPOAUDITPOAOCSPRD

One to one (2) — lookups and parents

RelationTableRulesConditionField map
PoaocmastPOAOCMASTRequired
PSP-COMPANY→PAM-COMPANY
PSP-AOC-CODE→PAM-AOC-CODE
TxtaxcodeTXTAXCODERequired
PSP-COMPANY→TAC-COMPANY
PSP-TAX-CODE→TAC-TAX-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
PoauditPOAUDIT
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

Programs

Updated by (233)

Referenced by (5)