|
|
POCOMPANY FILE
Company System Master
A file of valid Purchase Order companies and corresponding parameters.
REFERENCED BY
AP125 AP126 AP225 AP226 AP25.1 AP25.2
AP26.1 AP90.4 BL92.1 CX05.1 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 CXCP.1 DR100 IC140 IC141 IC142
IC242 IC50.2 IC522 IC523 IC524 IC525
IC526 IC83.1 PC120 PC20.1 PC540 IN20.1
MA03.1 MA04.1 MA04.2 MA05.1 MA06.1 MA08.1
MA140 MA190 MA200 MA203 MA204 MA205
MA206 MA208 MA278 MA300 MA40.1 MA40.2
MA41.1 MA41.2 MA41.3 MA41.4 MA41.5 MA41.6
MA52.1 MA95.1 MA95.2 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 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE810
OE830 OE920 OE950 PO02.1 PO10.1 PO10.2
PO115 PO12.1 PO120 PO121 PO122 PO123
PO125 PO13.1 PO130 PO131 PO132 PO133
PO14.1 PO15.1 PO150 PO16.1 PO16.2 PO17.1
PO180 PO199 PO202 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO21.6 PO210 PO212 PO214
PO216 PO220 PO221 PO223 PO224 PO225
PO227 PO23.1 PO23.2 PO230 PO233 PO236
PO24.1 PO251 PO26.1 PO272 PO274 PO275
PO276 PO277 PO28.1 PO28.3 PO28.4 PO28.5
PO28.6 PO28.7 PO28.8 PO280 PO29.1 PO295
PO32.1 PO32.2 PO32.4 PO32.5 PO33.1 PO33.2
PO34.1 PO34.2 PO35.1 PO37.1 PO39.1 PO52.1
PO522 PO529 PO53.1 PO550 PO560 PO60.1
PO61.1 PO62.1 PO63.1 PO64.1 PO66.1 PO67.1
PO68.1 PO69.1 PO72.2 PO822 PO85.1 PO94.1
PO990 RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ120
RQ125 RQ35.1 RQ500 SEA3.1 WH02.1 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1
WH32.2 WH32.3 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
WO132 WO140
UPDATED BY
MA00.1 MA00.2 MA00.3 MA00.4 MA43.1 MA43.2
MA43.3 MA520 MA530 MA540 PO100 PO135
PO20.1 PO22.3 PO25.1 PO30.1 PO30.2 PO31.1
PO50.1 PO530 PO820 PO821 RQ20.1 RQ20.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCY-COMPANY Numeric 4 MA00.1 MA00.2
Company The company number. MA00.3 MA00.4
PCY-NAME Alpha 30 (Lower Case) MA00.1
Name Contains the company description.
PCY-BUYER-CODE Alpha 3 MA00.1
Default Buyer The user-defined buyer identifier.
PCY-BASE-CURR-CD Alpha 5 MA00.1
Base Currency Code The general ledger-defined currency
code for this purchase order company.
PCY-BASE-CUC-DESC Alpha 30 (Lower Case) MA00.1
Base Cuc Desc The company base currency code
description.
PCY-BASE-ND Numeric 1 MA00.1
Base Number Of The number of decimal positions defined
Decimals for the company base currency.
PCY-NUM-PO-FLAG Alpha 1 MA00.1
Numeric PO The numeric purchase order flag defines
the attributes of the purchase order
number. If the flag is set to Yes, the
purchase order must be numeric, whether
manually entered or automatically
generated.
N = No
Y = Yes
PCY-AUTO-NBR-FL Alpha 1 MA00.1
Auto Assign The Auto Number Flag defines whether
auto numbering will take place.
N = NO
Y = YES
PCY-LAST-PO-NBR Numeric 7 MA00.1 MA00.3
Last PO Number The last purchase order number used for MA520 PO100
this company. PO20.1 PO22.3
PO25.1 PO820
PO821 RQ20.1
RQ20.3
PCY-BEG-MANUAL-PO Numeric 7 MA00.1
Manual Range - Beginning purchase order number for the
Starting PO Nbr manual purchase order number range.
PCY-END-MANUAL-PO Numeric 7 MA00.1
Manual Range - Ending purchase order number for the
Ending PO Nbr manual purchase order number range.
PCY-HIN-NBR Alpha 9
Hin Nbr The Health Industry Number is a unique
number assigned to any company or
facility doing business in the health
industry. This number is assigned by the
Health Industry Business Communications
Council (HIBCC).
PCY-FREIGHT-TERMS Alpha 1 MA00.1
Default Freight Default terms code used to describe the
Terms terms of the freight on a purchase
order.
PCY-UOM-REQ-FL Alpha 1 MA00.1
Require UOM If the Unit of Measure Required flag is
set to Yes, entry of the unit of measure
field is required for both the purchase
order entry and the receiving entry.
N = No
Y = Yes
PCY-PRT-AUDIT-FL Alpha 1 MA00.1
Print Change Audit This flag determines if the audit
records created as the result of a
purchase order revision are printed on
the purchase order.
N = No
Y = Yes
PCY-PO-COM-OPT Alpha 1 Occurs 10 Times MA00.2
Purchase Order Indicates which inventory control
Comment Type comment types (created for the item)
automatically print on the purchase
order when the item is on the purchase
order.
X = Select.
PCY-POE-COM-OPT Alpha 1 Occurs 10 Times MA00.2
Transmitted POs Indicates which inventory control
Comment Type comment types (created for the item) are
automatically included with the purchase
order transmitted document when the item
is on the purchase order.
X = Select.
PCY-REC-COM-OPT Alpha 1 Occurs 10 Times MA00.2
Receiving Document Indicates which inventory control
Comt Type comment types (created for the item)
automatically print on the receiving
document when the item is on the
receiving document.
X = Select.
PCY-UPO-COM-OPT Alpha 1 Occurs 10 Times MA00.2
Unreleased POs Indicates which inventory control
Comment Type comment types (created for the item)
automatically print on the unreleased
purchase order report when the item
prints on this report.
X = Select.
PCY-OPO-COM-OPT Alpha 1 Occurs 10 Times MA00.2
Open POs Comment Indicate which inventory control
Type comment types (created for the item)
automatically print on the open purchase
order report when the item prints on
this report.
X = Select.
PCY-URC-COM-OPT Alpha 1 Occurs 10 Times MA00.2
Unreleased Indicates which inventory control
Receivings Cmt Type comment types (created for the item)
automatically print on the unreleased
receivings report when the item prints
on the report.
X = Select.
PCY-NUM-REC-FLAG Alpha 1 MA00.1 MA00.3
Numeric Receivers User-defined flag indicates whether the
receiver number must be edited to be
numeric.
N = No
Y = Yes
PCY-AUTO-REC-FLAG Alpha 1 MA00.1 MA00.3
Auto Assign This flag defines if the receiver
Receivers number is automatically and sequentially
assigned or if manual entry is required.
If this flag is set to Yes, the numeric
receiver flag must also be set to Yes.
N = No
Y = Yes
PCY-LAST-REC-NBR Numeric 10 MA00.3 PO30.1
Last Receiver Number The last receiver number assigned PO530
displays here. It can be used at system
startup time to define the number before
the first number to be automatically
assigned.
PCY-PRT-QTY-FLAG Alpha 1 MA00.1 MA00.3
Print Quantity on This flag defines if the open order
Document (unreceived) quantity for a purchase
order line item prints on the receiver.
N = No
Y = Yes
PCY-DISP-QTY-FLAG Alpha 1 MA00.1 MA00.3
Display Quantity on This flag defines if the open order
Screen (unreceived) quantity for a purchase
order line item prints on the receiving
forms.
N = No
Y = Yes
PCY-USE-ALL-FLAG Alpha 1 MA00.1 MA00.3
Receive All This flag defines if the Receive All
flag can be used in the online receiving
process.
N = No
Y = Yes
PCY-OK-OSHIP-FLAG Alpha 1 MA00.1 MA00.3
Accept All Defines if the company policy is to
Shipments Flag accept all shipments. If the flag is set
to Yes, overshipment tolerances are
ignored and buyer messages are not
generated for excess overshipments.
N = No
Y = Yes
PCY-OSHIP-TOL-PCT Percent 5.3 (Percent) MA00.3
Overshipment Quantity overshipment tolerance
Percentage percentage.
PCY-USHIP-TOL-PCT Percent 6.3 (Percent) MA00.3
Undershipment Cncl This is the quantity undership
Percentage percentage for automatic back order
cancellation. If a value of 10% is
entered here, for instance, and a
quantity of 91 is shipped against an
ordered quantity of 100, that would be
considered a 9% undershipment. Since
this is less than the 10% limit, the
backordered amount would be canceled.
This process takes place at receiving
time. If a backorder is not canceled
manually, the system checks, in order,
the purchase order line, the purchase
order vendor purchase from record, the
purchase order vendor record, and the
company record. If an undershipment
percentage of a zero percent flag set to
Y is encountered at any level, that
value is used.
NOTE-The percentage can be set at 100%,
which would cancel all backorders.
PCY-RET-REAS-CD-FL Alpha 1 MA00.3
Reason Code Required This field, if set to Y, indicates a
reason code must be entered when
performing returns processing. If set to
N, a reason code can be entered, but it
is not a requirement.
N = No
Y = Yes
PCY-RT-AUTO-ASN-FL Alpha 1 MA00.3
Auto Assign Returns This field indicates if return numbers
are to be auto assigned.
N = No
Y = Yes
PCY-LAST-RTN-NBR Numeric 10 MA00.3 PO31.1
Last Return Number This field indicates the last return
number assigned.
PCY-BEG-RET-PO Numeric 7 MA00.3
Return PO Range - Enter a value in this field to indicate
Starting Nbr the beginning of the range of numbers
for return purchase orders. The range
must be at least 10,000 numbers apart.
NOTE-The range for return purchase
orders should be a subset of the full
range of purchase order numbers you
intend to use, otherwise the system will
not be able to find any numbers to auto
assign to regular purchase orders.
PCY-END-RET-PO Numeric 7 MA00.3
Return PO Range - Enter a value in this field to indicate
Ending Nbr the end of the range of numbers for
return purchase orders. The range must
be at least 10,000 numbers.
PCY-LST-RET-PO-USD Numeric 7 MA00.3 PO31.1
Last Return PO This field indicates the last return
Number purchase order number assigned.
PCY-RNI-ACCT-UNIT Alpha 15 MA00.4
Rcvd, Not Invd Acct The received, not invoiced set of
Unit accounts is used in three instances.
First, they are used to temporarily
accrue values for any Nonstock or
Special Order items that are received
but not approved for payment at the end
of the month when the PO135 (Received
Not Invoiced) report is run. The
temporary accruals are backed out when
the General Ledger system creates an
auto reversing entry is created after
month end.
Second, they are used to temporarily
accrue values when inventory items are
posted to Insight General Ledger by the
PO180 (GL Transaction Register) program.
These temporary accruals are backed out
when the goods are approved for payment
in the Accounts Payable system.
The third instance is when inventory
items being approved for payment where
the invoice unit cost and purchase order
line unit cost (for nonstandard cost
companies) or standard cost (for
standard cost companies) are different.
In that case the distribution that is
created for the difference uses the
received not invoiced set of accounts.
The offset to received not invoiced is
created in Insight Inventory Control
when the cost variance is posted.
PCY-RNI-ACCOUNT Numeric 6 MA00.4
Rcvd, Not Invd Acct The Received, Not Invoiced account
Nbr Account number.
See Received Not Invoiced Accounting
Unit for further detail.
PCY-RNI-SUB-ACCT Numeric 4 MA00.4
Rcvd, Not Invd The Received, Not Invoiced account Sub
Subacct Account number.
See Received Not Invoiced Accounting
Unit for further detail.
PCY-INR-ACCT-UNIT Alpha 15 MA00.4
Invd, Not Rcvd Acct The Invoiced, Not Received account
Unit Accounting Unit.
PCY-INR-ACCOUNT Numeric 6 MA00.4
Invd, Not Rcvd Acct The Invoiced, Not Received account
Nbr Account number.
PCY-INR-SUB-ACCT Numeric 4 MA00.4
Invd, Not Rcvd The Invoiced, Not Received account
Subacct Subaccount number.
PCY-VAR-ACCT-UNIT Alpha 15 MA00.4
Invc Cost Variance The cost variance set of accounts is
Acct Unit used in two instances. The first
instance is when a receipt of an
inventory item for a standard cost
company is posted, and the standard cost
and purchase order unit cost are
different. This account is used as a
suspense account between the time the
receipts are posted and the time the
invoice approval is posted.
The second instance is when an invoice
which is automatched is not perfectly
matched, but within invoice level
tolerances. In that case, an adjusting
distribution is created against the
invoice using the variance accounts.
PCY-VAR-ACCOUNT Numeric 6 MA00.4
Invc Cost Variance The variance account account number.
Acct Nbr See the variance accounting unit for
additional details.
PCY-VAR-SUB-ACCT Numeric 4 MA00.4
Invc Cost Variance The variance account subaccount number.
Subacct See the variance accounting unit for
additional details.
PCY-RNI-POST-DATE Numeric 8 (yyyymmdd) PO135
RNI Posting Date The received not invoiced general
ledger posting date from the last closed
period.
PCY-PRNI-POST-DAT Numeric 8 (yyyymmdd) PO135
Prni Post Dat The received not invoiced General
Ledger posting date from the closing
period prior to the last closed period.
PCY-APP-EXC-FLAG Alpha 1 MA00.4
Approved Exceeds This flag defines if the purchase order
Received system allows the release of an invoice
for an item(s) not yet received.
N = No
Y = Yes
PCY-RMV-HOLD-FLAG Alpha 1 MA00.4
Remove Hold Code This flag determines if hold codes are
Flag removed when a receiver is released.
N = No
Y = Yes
PCY-PENDING-HOLD Alpha 4 MA00.4
AP Hold Code This user-entered hold code is applied
to any invoice that purchase order has
found to be incomplete relative to
inspections or receivings.
PCY-COST-TOL-PCT Percent 5.3 (Percent) MA00.4
Unit Cost Variance This is the unit cost tolerance percent.
Pct
PCY-AMT-INV-OVER Signed 15.2 MA00.4
Variance Amount This amount controls the total line
item variance allowed for invoice
approval. If the extended approved
amount exceeds the extended purchase
order ordered amount by this much or
more, a buyer message is generated and
the buyer must approve the excess
amount.
PCY-CAPITALIZE-TAX Alpha 1 MA00.4
Capitalize Tax If set to "Y", when invoices are
released that contain PO line approvals
that have assets and tax codes attached
to the PO lines, the tax distributions
that are created in AP will have asset
information attached to them.
Y = Yes
N = No
PCY-LAST-MSG-SEQ Numeric 6 MA43.1 MA43.2
Last Message This is the last assigned message MA43.3 MA530
Sequence Number sequence number for generated buyer MA540 PO30.1
messages. PO30.2 PO31.1
PO50.1 PO530
PCY-COMPLETE-FLAG Alpha 1 MA00.4
Company Complete This flag must be set to Yes to
indicate that the last form of company
parameters in MA00 (Company Setup) has
been updated.
PCY-REOPEN-FL Alpha 1 MA00.1
Reopen History PO This flag indicates whether or not the
company allows a closed purchase order
to be reopened.
N = No
Y = Yes
PCY-SUBSYS-CL-FLG Alpha 1 MA00.4
Subsystem Close Flag Company is using the subsystem close
feature.
Y = Yes
N = No
PCY-AOC-ACT-DAYS Numeric 3 MA00.4
Miscellaneous AOC Miscellaneous add-on cost no activity
Closed Days close days.
PCY-ALL-MULT-CUR Alpha 1 MA00.1
Multiple Currencies Allow multiple currencies for this
company.
Y = Yes
N = No
PCY-PO-DELETE-PT Alpha 1
Purchase Order Company policy defining the latest time
Delete Point in the purchase order life cycle for
deletion.
R = Release
P = Printed
A = Activity
X = Always
PCY-PO-RESEQ-PT Alpha 1
PO Resequenced Point Company policy that defines the latest
cycle in which the purchase order can be
resequenced.
R = Release
P = Printed
A = Activity
X = Always
PCY-PO-REV-PT Alpha 1
PO Revision Point Company policy that defines the latest
cycle in which the purchase order can be
revised.
R = Release
P = Printed
A = Activity
X = Always
POCOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCYSET1 COMPANY AP125 AP126
AP225 AP226
AP25.1 AP25.2
AP26.1 AP90.4
BL92.1 CX05.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC141 IC142
IC242 IC50.2
IC522 IC523
IC524 IC525
...
POCOMPANY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Default Buyer BUYER Not Required
PCY-COMPANY -> BUY-COMPANY
PCY-BUYER-CODE -> BUY-BUYER-CODE
Iccompany ICCOMPANY Required
PCY-COMPANY -> ICC-COMPANY
Itemgroup ITEMGROUP Required
ICC-ITEM-GROUP -> ITG-ITEM-GROUP
Rec Ni Acct GLMASTER Required
PCY-COMPANY -> GLM-COMPANY
PCY-RNI-ACCT-UNIT -> GLM-ACCT-UNIT
PCY-RNI-ACCOUNT -> GLM-ACCOUNT
PCY-RNI-SUB-ACCT -> GLM-SUB-ACCOUNT
POCOMPANY FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Buyer BUYER Delete Restricted
PCY-COMPANY -> BUY-COMPANY
BUY-BUYER-CODE
Buyergrp BUYERGRP Delete Restricted
PCY-COMPANY -> BGP-COMPANY
BGP-BUYER-GRP
Fobcode FOBCODE Delete Restricted
PCY-COMPANY -> FOB-COMPANY
FOB-FOB-CODE
Iclocation ICLOCATION
PCY-COMPANY -> ICL-COMPANY
ICL-LOCATION
Poaocdtl POAOCDTL Delete Restricted
PCY-COMPANY -> PAO-COMPANY
PAO-ORDER-NAME
PAO-PO-NUMBER
PAO-PO-RELEASE
PAO-LINE-NBR
PAO-AOC-CODE
Poaocmast POAOCMAST Delete Restricted
PCY-COMPANY -> PAM-COMPANY
PAM-AOC-CODE
Pofrtterm FOBCODE Delete Restricted
PCY-COMPANY -> FOB-COMPANY
FOB-FOB-CODE
Poproclev POPROCLEV Delete Restricted
PCY-COMPANY -> POP-COMPANY
POP-PROCESS-LEVEL
Povendor POVENDOR Delete Restricted
PCY-COMPANY -> POV-COMPANY
POV-VENDOR
Purchorder PURCHORDER Delete Restricted
PCY-COMPANY -> PCR-COMPANY
PCR-PO-NUMBER
PCR-PO-RELEASE
Stcomments STCOMMENTS Delete Restricted
PCY-COMPANY -> STC-COMPANY
STC-COMMENT-CODE
STC-LANGUAGE-CODE
STC-SEQ
|