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
MA01.1 PO220 PO67.1 POI7.1 POIM.1 PO225
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP220 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP520 API1.1 API2.1
IC28.1 MA08.1 MA180 MA208 MA41.2 MA43.2
MA43.9 MA530 MA531 MA540 MA60.2 MA60.3
MA60.5 MA61.1 MA66.3 MA67.1 MA67.2 MA70.1
MAI1.1 PO100 PO101 PO122 PO131 PO190
PO20.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO25.2 PO25.6 PO25.7 PO25.8 PO27.3
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO33.1 PO34.1 PO35.1 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
POI3.1 POIE.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
Company The company number. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
IC28.1 MA08.1
MA180 MA208
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
...
PAM-AOC-CODE Alpha 2 AP125 AP126
Add On Cost 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 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
IC28.1 MA08.1
MA180 MA208
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
...
PAM-DESCRIPTION Alpha 30 (Lower Case) AP125 AP126
Description This field displays the description. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
IC28.1 MA08.1
MA180 MA208
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
...
PAM-AOC-RATE Percent 7.3 (Percent) AP125 AP126
Add On Cost 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 AP220
line. AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
IC28.1 MA08.1
MA180 MA208
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
...
PAM-SPREAD-METHOD Alpha 1 AP125 AP126
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 AP220
N = No Spread AP23.1 AP25.1
Q = Quantity AP25.2 AP26.1
V = Volume AP27.1 AP520
W = Weight API1.1 API2.1
A = Amount IC28.1 MA08.1
R = Rate MA180 MA208
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
...
PAM-TAX-CODE Alpha 10 AP125 AP126
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 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
IC28.1 MA08.1
MA180 MA208
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
...
PAM-DST-ACCT-UNIT Alpha 15 AP125 AP126
Distribution Contains the General Ledger accounting AP131 AP20.1
Accounting Unit unit to which the amount is posted. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
IC28.1 MA08.1
MA180 MA208
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
...
PAM-DST-ACCOUNT Numeric 6 AP125 AP126
Distribution Contains the General Ledger account to AP131 AP20.1
Account Number which the amount is posted. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
IC28.1 MA08.1
MA180 MA208
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
...
PAM-DST-SUB-ACCT Numeric 4 AP125 AP126
Distribution The general ledger subaccount to which AP131 AP20.1
Subaccount Number the amount is posted. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
IC28.1 MA08.1
MA180 MA208
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
...
PAM-ACTIVE-FLAG Alpha 1 AP125 AP126
Status The Active flag of the credit card AP131 AP20.1
type. AP20.2 AP20.3
AP20.4 AP20.5
A = Active AP20.7 AP220
I = Inactive AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
IC28.1 MA08.1
MA180 MA208
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
...
PAM-TAXABLE-FLAG Alpha 1 AP125 AP126
Taxable Defines if taxable. AP131 AP20.1
N = No AP20.2 AP20.3
Y = Yes AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
IC28.1 MA08.1
MA180 MA208
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
...
PAM-AOC-ON-PO Alpha 1 AP125 AP126
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 AP220
Y = Yes AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
IC28.1 MA08.1
MA180 MA208
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
...
PAM-SUMMARY-FLAG Alpha 1 AP125 AP126
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 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
IC28.1 MA08.1
MA180 MA208
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
...
PAM-AOC-TYPE Alpha 1 AP125 AP126
Aoc Type C = Cost AP131 AP20.1
A = Allowance AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
IC28.1 MA08.1
MA180 MA208
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
...
PAM-DIFF-ACCT-UNIT Alpha 15 AP125 AP126
Diff Acct Unit AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
IC28.1 MA08.1
MA180 MA208
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
...
PAM-DIFF-ACCOUNT Numeric 6 AP125 AP126
Diff Account AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
IC28.1 MA08.1
MA180 MA208
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
...
PAM-DIFF-SUB-ACCT Numeric 4 AP125 AP126
Diff Sub Acct AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
IC28.1 MA08.1
MA180 MA208
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO190
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
...
POAOCMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAMSET1 COMPANY AP125 AP126
AOC-CODE AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
IC28.1 MA01.1
MA08.1 MA180
MA208 MA41.1
MA41.2 MA41.4
MA43.2 MA43.9
MA530 MA531
...
PAMSET2 COMPANY KeyChange
AOC-CODE
AOC-TYPE
PAMSET3 AOC-CODE AP125 AP126
COMPANY AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
IC28.1 MA08.1
MA180 MA208
MA41.2 MA43.2
MA43.9 MA530
MA531 MA540
MA60.2 MA60.3
...
POAOCMAST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pocompany POCOMPANY Required
PAM-COMPANY -> PCY-COMPANY
|
