POAOCMAST

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 MA126 MA26.1
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 PO99.9 POI7.1 POIF.1 POIM.1
MM280 MM80.1 MM80.2 MA01.1


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 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC140 IC66.1 IC83.1 MA08.1 MA180
MA208 MA278 MA279 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MA44.1 MA44.2 MA530 MA531
MA540 MA60.2 MA60.3 MA60.5 MA61.1 MA66.2
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 PO136 PO150 PO190 PO20.1 PO20.6
PO20.9 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO225 PO229 PO23.1
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO27.2
PO28.2 PO29.1 PO30.1 PO30.2 PO30.3 PO30.4
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 PO54.5 POCP.1 POI3.1
POID.1 POII.1 POIJ.1 POIT.1 RQ10.1 RQ10.2
RQ10.4 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500
RQIF.1 WH130 WH132 WH190 WH20.2 WH20.7
WH222 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAM-COMPANY
Element: Company
Numeric 4
The company number.
...
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA08.1 MA180
MA208 MA278
MA279 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
PAM-AOC-CODE
Element: Aoc Code
Alpha 2
This 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
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA08.1 MA180
MA208 MA278
MA279 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
PAM-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
...
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA08.1 MA180
MA208 MA278
MA279 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
PAM-AOC-RATE
Element: 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
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA08.1 MA180
MA208 MA278
MA279 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
PAM-SPREAD-METHOD
Element: Spread Method
Alpha 1
A 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
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA08.1 MA180
MA208 MA278
MA279 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
PAM-TAX-CODE
Element: Tax Code
Alpha 10
This 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
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA08.1 MA180
MA208 MA278
MA279 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
PAM-DST-ACCT-UNIT
Element: Acct Unit
Alpha 15
The 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
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA08.1 MA180
MA208 MA278
MA279 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
PAM-DST-ACCOUNT
Element: Account
Numeric 6
This 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
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA08.1 MA180
MA208 MA278
MA279 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
PAM-DST-SUB-ACCT
Element: Sub Acct
Numeric 4
The general ledger subaccount to which the amount is posted.
...
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA08.1 MA180
MA208 MA278
MA279 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
PAM-ACTIVE-FLAG
Element: Active Flag
Alpha 1
The Active flag of the credit card type.
A = Active
I = Inactive
...
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA08.1 MA180
MA208 MA278
MA279 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
PAM-TAXABLE-FLAG
Element: Taxable
Alpha 1
Defines if taxable.
N = No
Y = Yes
...
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA08.1 MA180
MA208 MA278
MA279 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
PAM-AOC-ON-PO
Element: Aoc On Po
Alpha 1
Indicates 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
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA08.1 MA180
MA208 MA278
MA279 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
PAM-SUMMARY-FLAG
Element: Summary Only
Alpha 1
Print in summary only on the purchase order.
N = No
Y = Yes
...
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA08.1 MA180
MA208 MA278
MA279 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
PAM-AOC-TYPE
Element: Aoc Type
Alpha 1

C = Cost
A = Allowance
...
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA08.1 MA180
MA208 MA278
MA279 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
PAM-DIFF-ACCT-UNIT
Element: Acct Unit
Alpha 15
The 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
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA08.1 MA180
MA208 MA278
MA279 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
PAM-DIFF-ACCOUNT
Element: Account
Numeric 6
This 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
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA08.1 MA180
MA208 MA278
MA279 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
PAM-DIFF-SUB-ACCT
Element: Sub Acct
Numeric 4
This 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
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AP520
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA08.1 MA180
MA208 MA278
MA279 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
PAM-LANDED-FLAG
Element: Landed Flag
Numeric 1

0 = NO
1 = Yes
...
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA08.1 MA180
MA208 MA278
MA279 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA540 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3


POAOCMAST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAMSET1 COMPANY
AOC-CODE
...
AM19.1 AM19.2
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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
PAMSET2 COMPANY
AOC-CODE
AOC-TYPE
KeyChange
MA531 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO52.1
PAMSET3 AOC-CODE
COMPANY
...
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1


POAOCMAST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Pocompany POCOMPANY Required
PAM-COMPANY->PCY-COMPANY


File created: Thu Jun 09 11:23:44 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.