|
|
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 POIF.1 POIM.1
PO225
UPDATED BY
AP125 AP126 AP131 AP220 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 IC28.1 MA08.1 MA180
MA208 MA530 MA531 MA540 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 MA67.1 MA67.2
MA70.1 MA75.1 MA80.1 MAI1.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 OE111
OE113 OE114 OE116 OE129 OE13.2 OE13.3
OE13.5 OE13.6 OE14.4 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510
OE530 OE81.1 OE810 OE830 OE90.1 OE90.2
PO100 PO101 PO122 PO131 PO190 PO20.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO229
PO23.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 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 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
Element: Company The company number. AP131 AP220
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 IC28.1
MA08.1 MA180
MA208 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
PAM-AOC-CODE Alpha 2 AP125 AP126
Element: Add On Cost CoThis field contains the identifier for AP131 AP220
the add-on cost associated with this AP25.1 AP25.2
line item. 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 IC28.1
MA08.1 MA180
MA208 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
PAM-DESCRIPTION Alpha 30 (Lower Case) AP125 AP126
Element: Description This field displays the description. AP131 AP220
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 IC28.1
MA08.1 MA180
MA208 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
PAM-AOC-RATE Percent 7.3 (Percent) AP125 AP126
Element: Add On Cost RaAdd-on cost percentage rate. If add-on AP131 AP220
cost is spread by rate, this value AP25.1 AP25.2
multiplied by the line unit cost is the AP26.1 AP27.1
unit add-on cost for the purchase order AP30.4 AP520
line. 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 IC28.1
MA08.1 MA180
MA208 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
PAM-SPREAD-METHOD Alpha 1 AP125 AP126
Element: Spread Method A method of spreading add-on costs AP131 AP220
across the purchase order line level. AP25.1 AP25.2
Spread can be by volume, quantity, AP26.1 AP27.1
weight or amount. Default is no spread. AP30.4 AP520
N = No Spread API1.1 API2.1
Q = Quantity BL09.1 BL12.1
V = Volume BL120 BL122
W = Weight BL130 BL20.1
A = Amount BL20.3 BL209
R = Rate BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA08.1 MA180
MA208 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
PAM-TAX-CODE Alpha 10 AP125 AP126
Element: Tax Code This field contains a code representing AP131 AP220
specific tax information. This must be AP25.1 AP25.2
valid Tax Code. 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 IC28.1
MA08.1 MA180
MA208 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
PAM-DST-ACCT-UNIT Alpha 15 AP125 AP126
Element: Accounting UniContains the General Ledger accounting AP131 AP220
unit to which the amount is posted. 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 IC28.1
MA08.1 MA180
MA208 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
PAM-DST-ACCOUNT Numeric 6 AP125 AP126
Element: Account Contains the General Ledger account to AP131 AP220
which the amount is posted. 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 IC28.1
MA08.1 MA180
MA208 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
PAM-DST-SUB-ACCT Numeric 4 AP125 AP126
Element: Subaccount The general ledger subaccount to which AP131 AP220
the amount is posted. 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 IC28.1
MA08.1 MA180
MA208 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
PAM-ACTIVE-FLAG Alpha 1 AP125 AP126
Element: Status The Active flag of the credit card AP131 AP220
type. AP25.1 AP25.2
A = Active AP26.1 AP27.1
I = Inactive 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 IC28.1
MA08.1 MA180
MA208 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
PAM-TAXABLE-FLAG Alpha 1 AP125 AP126
Element: Taxable Defines if taxable. AP131 AP220
N = No AP25.1 AP25.2
Y = Yes 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 IC28.1
MA08.1 MA180
MA208 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
PAM-AOC-ON-PO Alpha 1 AP125 AP126
Element: Aoc On Po Indicates if the add-on cost is to AP131 AP220
appear on the Purchase Order document AP25.1 AP25.2
that is issued to the vendor. AP26.1 AP27.1
N = No AP30.4 AP520
Y = Yes 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 IC28.1
MA08.1 MA180
MA208 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
PAM-SUMMARY-FLAG Alpha 1 AP125 AP126
Element: Summary Only Print in summary only on the purchase AP131 AP220
order. AP25.1 AP25.2
N = No AP26.1 AP27.1
Y = Yes 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 IC28.1
MA08.1 MA180
MA208 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
PAM-AOC-TYPE Alpha 1 AP125 AP126
Element: Aoc Type C = Cost AP131 AP220
A = Allowance 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 IC28.1
MA08.1 MA180
MA208 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
PAM-DIFF-ACCT-UNIT Alpha 15 AP125 AP126
Element: Accounting Unit AP131 AP220
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 IC28.1
MA08.1 MA180
MA208 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
PAM-DIFF-ACCOUNT Numeric 6 AP125 AP126
Element: Account AP131 AP220
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 IC28.1
MA08.1 MA180
MA208 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
PAM-DIFF-SUB-ACCT Numeric 4 AP125 AP126
Element: Subaccount AP131 AP220
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 IC28.1
MA08.1 MA180
MA208 MA530
MA531 MA540
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
PAM-LANDED-FLAG Numeric 1
Element: Landed Flag 0 = NO
1 = Yes
POAOCMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAMSET1 COMPANY AP125 AP126
AOC-CODE AP131 AP220
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 IC28.1
MA01.1 MA08.1
...
PAMSET2 COMPANY KeyChange
AOC-CODE
AOC-TYPE
PAMSET3 AOC-CODE AP125 AP126
COMPANY AP131 AP220
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 IC28.1
MA08.1 MA180
...
POAOCMAST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pocompany POCOMPANY Required
PAM-COMPANY -> PCY-COMPANY
|
