|
|
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
BL09.1 BL12.1 BL209 BL92.1 MA00.1 MA140
MA208 MA41.1 MA41.2 MA41.3 MA41.4 MA41.5
MA41.6 MA530 MA540 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 OE113 OE114
OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4
OE15.5 OE15.7 OE510 OE810 OE920 PO100
PO120 PO121 PO123 PO21.2 PO21.5 PO21.6
PO220 PO225 PO25.4 PO28.8 PO31.1 PO38.1
PO530 PO67.1 WH20.2 WH20.7
UPDATED BY
MA08.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAM-COMPANY Numeric 4 MA08.1
Company The company number.
PAM-AOC-CODE Alpha 2 MA08.1
Add On Cost Code This field contains the identifier for
the add-on cost associated with this
line item.
PAM-DESCRIPTION Alpha 30 (Lower Case) MA08.1
Description This field contains the description.
PAM-AOC-RATE Percent 7.3 (Percent) MA08.1
Add On Cost Rate 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.
PAM-SPREAD-METHOD Alpha 1 MA08.1
Spread Method 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
PAM-TAX-CODE Alpha 10 MA08.1
Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
PAM-DST-ACCT-UNIT Alpha 15 MA08.1
Distribution Contains the General Ledger accounting
Accounting Unit unit to which the amount is posted.
PAM-DST-ACCOUNT Numeric 6 MA08.1
Distribution Contains the General Ledger account to
Account Number which the amount is posted.
PAM-DST-SUB-ACCT Numeric 4 MA08.1
Distribution The general ledger subaccount to which
Subaccount Number the amount is posted.
PAM-ACTIVE-FLAG Alpha 1 MA08.1
Status The Active flag of the credit card
type.
A = Active
I = Inactive
PAM-TAXABLE-FLAG Alpha 1 MA08.1
Taxable Defines if taxable.
N = No
Y = Yes
PAM-PRINT-FLAG Alpha 1 MA08.1
Print on PO Indicates if the system prints the
add-on cost on the purchase order.
N = No
Y = Yes
PAM-SUMMARY-FLAG Alpha 1 MA08.1
Summary Only Print in summary only on the purchase
order.
N = No
Y = Yes
PAM-ERS-EDI-SPREAD Alpha 1
Ers Edi Spread This flag controls whether the add-on
costs that are added during ERS or EDI
invoice processing are spread by default
to the invoice lines.
Y = Spread on ERS and EDI Invoices
N = No Spread on ERS and EDI Invcs
POAOCMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAMSET1 COMPANY BL09.1 BL12.1
AOC-CODE BL209 BL92.1
MA00.1 MA08.1
MA140 MA208
MA41.1 MA41.2
MA41.3 MA41.4
MA41.5 MA41.6
MA530 MA540
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 OE113
...
POAOCMAST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pocompany POCOMPANY Required
PAM-COMPANY -> PCY-COMPANY
POAOCMAST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Poaocdtl POAOCDTL Delete Restricted
PAM-COMPANY -> PAO-COMPANY
PAM-AOC-CODE -> PAO-AOC-CODE
PAO-PO-NUMBER
PAO-PO-RELEASE
PAO-ORDER-NAME
PAO-LINE-NBR
|