Lawson Insight Technical Documentation |
|
POAOCMAST
POAOCMAST FILE
Add On Cost Master
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.
REFERENCED BY
AM19.1 AM19.2 AP115 AP305 MA01.1 MA126
MA310 MA53.6 MA54.1 MA54.7 MA63.1 MA65.1
MA69.1 MA69.2 MA69.3 MA69.4 MA69.5 MA69.6
PO220 PO67.1 POI7.1 POIF.1 POIM.1 PO225
UPDATED BY
AP125 AP126 AP131 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 AP520
API1.1 API2.1 BL09.1 BL12.1 BL120 BL122
BL130 BL20.1 BL20.3 BL209 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 MA08.1
MA180 MA208 MA278 MA279 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.7
MA530 MA531 MA540 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA66.3 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
PO100 PO101 PO122 PO131 PO190 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO229 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO29.1 PO30.1 PO30.2 PO30.3
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 PO53.4
PO53.5 PO53.8 PO536 POI3.1 POID.1 POII.1
POIJ.1 POIT.1 RQ10.1 RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAM-COMPANY Numeric 4 AP125 AP126
Element: Company The company number. AP131 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 AP520
API1.1 API2.1
BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA08.1
MA180 MA208
MA278 MA279
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
...
PAM-AOC-CODE Alpha 2 AP125 AP126
Element: Aoc Code This field contains the identifier for AP131 AP20.1
the add-on cost associated with this AP20.2 AP20.3
line item. AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA08.1
MA180 MA208
MA278 MA279
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
...
PAM-DESCRIPTION Alpha 30 (Lower Case) AP125 AP126
Element: Description This field displays the description. AP131 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 AP520
API1.1 API2.1
BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA08.1
MA180 MA208
MA278 MA279
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
...
PAM-AOC-RATE Percent 7.3 (Percent) AP125 AP126
Element: Aoc Rate Add-on cost percentage rate. If add-on AP131 AP20.1
cost is spread by rate, this value AP20.2 AP20.3
multiplied by the line unit cost is the AP20.4 AP20.5
unit add-on cost for the purchase order AP20.7 AP21.1
line. AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA08.1
MA180 MA208
MA278 MA279
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
...
PAM-SPREAD-METHOD Alpha 1 AP125 AP126
Element: Spread Method A method of spreading add-on costs AP131 AP20.1
across the purchase order line level. AP20.2 AP20.3
Spread can be by volume, quantity, AP20.4 AP20.5
weight or amount. Default is no spread. AP20.7 AP21.1
N = No Spread AP220 AP23.1
Q = Quantity AP25.1 AP25.2
V = Volume AP26.1 AP27.1
W = Weight AP30.4 AP520
A = Amount API1.1 API2.1
R = Rate BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA08.1
MA180 MA208
MA278 MA279
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
...
PAM-TAX-CODE Alpha 10 AP125 AP126
Element: Tax Code This field contains a code representing AP131 AP20.1
specific tax information. This must be AP20.2 AP20.3
valid Tax Code. AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA08.1
MA180 MA208
MA278 MA279
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
...
PAM-DST-ACCT-UNIT Alpha 15 AP125 AP126
Element: Acct Unit The accounting unit is a shorthand AP131 AP20.1
notation representing the variable level AP20.2 AP20.3
number. When used in the General Ledger AP20.4 AP20.5
Account Master file, the accounting unit AP20.7 AP21.1
must be defined in the General Ledger AP220 AP23.1
Names file as a posting accounting unit. AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA08.1
MA180 MA208
MA278 MA279
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
...
PAM-DST-ACCOUNT Numeric 6 AP125 AP126
Element: Account This field along with the accounting AP131 AP20.1
unit and subaccount make up the location AP20.2 AP20.3
(account) where amounts and other AP20.4 AP20.5
account information is stored. AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA08.1
MA180 MA208
MA278 MA279
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
...
PAM-DST-SUB-ACCT Numeric 4 AP125 AP126
Element: Sub Acct The general ledger subaccount to which AP131 AP20.1
the amount is posted. 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 AP520
API1.1 API2.1
BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA08.1
MA180 MA208
MA278 MA279
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
...
PAM-ACTIVE-FLAG Alpha 1 AP125 AP126
Element: Active Flag The Active flag of the credit card AP131 AP20.1
type. AP20.2 AP20.3
A = Active AP20.4 AP20.5
I = Inactive AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA08.1
MA180 MA208
MA278 MA279
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
...
PAM-TAXABLE-FLAG Alpha 1 AP125 AP126
Element: Taxable Defines if taxable. AP131 AP20.1
N = No AP20.2 AP20.3
Y = Yes AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA08.1
MA180 MA208
MA278 MA279
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
...
PAM-AOC-ON-PO Alpha 1 AP125 AP126
Element: Aoc On Po Indicates if the add-on cost is to AP131 AP20.1
appear on the Purchase Order document AP20.2 AP20.3
that is issued to the vendor. AP20.4 AP20.5
N = No AP20.7 AP21.1
Y = Yes AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA08.1
MA180 MA208
MA278 MA279
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
...
PAM-SUMMARY-FLAG Alpha 1 AP125 AP126
Element: Summary Only Print in summary only on the purchase AP131 AP20.1
order. AP20.2 AP20.3
N = No AP20.4 AP20.5
Y = Yes AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA08.1
MA180 MA208
MA278 MA279
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
...
PAM-AOC-TYPE Alpha 1 AP125 AP126
Element: Aoc Type C = Cost AP131 AP20.1
A = Allowance 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 AP520
API1.1 API2.1
BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA08.1
MA180 MA208
MA278 MA279
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
...
PAM-DIFF-ACCT-UNIT Alpha 15 AP125 AP126
Element: Acct Unit The accounting unit is a shorthand AP131 AP20.1
notation representing the variable level AP20.2 AP20.3
number. When used in the General Ledger AP20.4 AP20.5
Account Master file, the accounting unit AP20.7 AP21.1
must be defined in the General Ledger AP220 AP23.1
Names file as a posting accounting unit. AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA08.1
MA180 MA208
MA278 MA279
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
...
PAM-DIFF-ACCOUNT Numeric 6 AP125 AP126
Element: Account This field along with the accounting AP131 AP20.1
unit and subaccount make up the location AP20.2 AP20.3
(account) where amounts and other AP20.4 AP20.5
account information is stored. AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA08.1
MA180 MA208
MA278 MA279
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
...
PAM-DIFF-SUB-ACCT Numeric 4 AP125 AP126
Element: Sub Acct This field contains the subaccount from AP131 AP20.1
your general ledger chart of accounts AP20.2 AP20.3
that was charged with the amount carried AP20.4 AP20.5
on this record. AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA08.1
MA180 MA208
MA278 MA279
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
...
PAM-LANDED-FLAG Numeric 1 AP125 AP126
Element: Landed Flag 0 = NO AP131 AP20.1
1 = Yes 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 AP520
API1.1 API2.1
BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA08.1
MA180 MA208
MA278 MA279
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
...
POAOCMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAMSET1 COMPANY AM19.1 AM19.2
AOC-CODE AP115 AP125
AP126 AP131
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.2
AP30.4 AP305
AP520 API1.1
API2.1 BL09.1
BL12.1 BL120
BL122 BL130
...
PAMSET2 COMPANY KeyChange MA531 PO30.1
AOC-CODE PO30.2 PO30.3
AOC-TYPE PO33.1 PO34.1
PO35.1 PO52.1
PAMSET3 AOC-CODE AP125 AP126
COMPANY AP131 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 AP520
API1.1 API2.1
BL09.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL209
BL21.2 BL21.5
...
POAOCMAST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pocompany POCOMPANY Required
PAM-COMPANY -> PCY-COMPANY
|