POAOCMAST – Add On Cost Master

System
Purchase Order (PO)
Prefix
PAM
Primary key
COMPANY, AOC-CODE
Fields
19
Updated by
233 programs
Referenced by
29 programs

POAOCMAST is the Add On Cost Master table in Lawson Purchase Order (prefix PAM). It is indexed by COMPANY, AOC-CODE (PAMSET1); alternate indexes: PAMSET2 and PAMSET3. It is related 1:1 to POCOMPANY. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 225 more and referenced by AM19.1, AM19.2, AP115, AP305, MA01.1, MA126, MA26.1, MA54.1 and 21 more. The table has 19 fields, 3 indexes and 1 documented relation.

About POAOCMAST

The Purchase Order Add On Cost Master. This file is used to define Add On Cost codes for miscellaneous costs related to a Purchase Order.

Fields (19)

Column = COBOL field name without the PAM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PAM-COMPANY PK
COMPANY
Numeric 4The company number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAM-AOC-CODE PK
AOC_CODE
Alpha 2This field contains the identifier for the add-on cost associated with this line item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAM-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field displays the description.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAM-AOC-RATE
AOC_RATE
Percent 7.3 (Percent)Add-on cost percentage rate. If add-on cost is spread by rate, this value multiplied by the line unit cost is the unit add-on cost for the purchase order line.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAM-SPREAD-METHOD
SPREAD_METHOD
Alpha 1A method of spreading add-on costs across the purchase order line level. Spread can be by volume, quantity, weight or amount. Default is no spread.
  • N No Spread
  • Q Quantity
  • V Volume
  • W Weight
  • A Amount
  • R Rate
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAM-TAX-CODE
TAX_CODE
Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAM-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.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAM-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.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAM-DST-SUB-ACCT
DST_SUB_ACCT
Numeric 4The general ledger subaccount to which the amount is posted.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAM-ACTIVE-FLAG
ACTIVE_FLAG
Alpha 1The Active flag of the credit card type.
  • A Active
  • I Inactive
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAM-TAXABLE-FLAG
TAXABLE_FLAG
Alpha 1Defines if taxable.
  • N No
  • Y Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAM-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.
  • N No
  • Y Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAM-SUMMARY-FLAG
SUMMARY_FLAG
Alpha 1Print in summary only on the purchase order.
  • N No
  • Y Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAM-AOC-TYPE
AOC_TYPE
Alpha 1
  • C Cost
  • A Allowance
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAM-DIFF-ACCT-UNIT
DIFF_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.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAM-DIFF-ACCOUNT
DIFF_ACCOUNT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAM-DIFF-SUB-ACCT
DIFF_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.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAM-LANDED-FLAG
LANDED_FLAG
Numeric 1
  • 0 NO
  • 1 Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PAM-TRACK-TYPE
TRACK_TYPE
Alpha 1" " = Other AOC
  • I Insurance
  • F Freight
  • C Customs Charges
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PAMSET1COMPANY, AOC-CODEPrimaryAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)
PAMSET2COMPANY, AOC-CODE, AOC-TYPEKeyChangeMA531, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1, PO34.1, PO35.1 +1 more
PAMSET3AOC-CODE, COMPANYAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
PocompanyPOCOMPANYRequiredPAM-COMPANYPCY-COMPANY

Programs

Updated by (233)

Referenced by (29)