|
|
POPROCLEV FILE
PO Process Level Master
This file of valid process levels contains default General Ledger account
numbers used by the Purchase Order system.
REFERENCED BY
AP125 AP126 AP225 AP226 AP25.1 AP25.2
AP26.1 IC242 MA00.1 MA140 MA205 MA40.1
MA41.6 MA530 MA540 PO135 PO180 PO236
PO25.1 PO295 PO31.1
UPDATED BY
MA05.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POP-COMPANY Numeric 4 MA05.1
Company The company number.
POP-PROCESS-LEVEL Alpha 5 MA05.1
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
POP-NAME Alpha 30 (Lower Case) MA05.1
Name Contains the company description.
POP-RNI-ACCT-UNIT Alpha 15 MA05.1
Default Rcvd Not The Received, Not Invoiced set of
Inv Acct 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 Insight 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 non standard 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.
POP-RNI-ACCOUNT Numeric 6 MA05.1
Default Rcvd Not The Received, Not Invoiced account
Inv Acct Nbr Account number.
See Received Not Invoiced Accounting
Unit for further detail.
POP-RNI-SUB-ACCT Numeric 4 MA05.1
Default Rcvd Not The Received, Not Invoiced account Sub
Inv Subacct Account number.
See Received Not Invoiced Accounting
Unit for further detail.
POP-INR-ACCT-UNIT Alpha 15 MA05.1
Default Inv Not The Invoiced, Not Received account
Rcvd Acct Unit Accounting Unit.
POP-INR-ACCOUNT Numeric 6 MA05.1
Default Inv Not The Invoiced, Not Received account
Rcvd Acct Nbr Account number.
POP-INR-SUB-ACCT Numeric 4 MA05.1
Default Inv Not The Invoiced, Not Received account
Rcvd Subacct Subaccount number.
POP-VAR-ACCT-UNIT Alpha 15 MA05.1
Cost Variance The cost variance set of accounts is
Accounting 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.
POP-VAR-ACCOUNT Numeric 6 MA05.1
Cost Variance The variance account account number.
Account Number See the variance account accounting
unit for additional details.
POP-VAR-SUB-ACCT Numeric 4 MA05.1
Cost Variance The variance account subaccount number.
Subaccount See the variance account accounting unit
for additional details.
POPROCLEV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POPSET1 COMPANY AP125 AP126
PROCESS-LEVEL AP225 AP226
AP25.1 AP25.2
AP26.1 IC242
MA00.1 MA05.1
MA140 MA205
MA40.1 MA41.6
MA530 MA540
PO135 PO180
PO236 PO25.1
PO295 PO31.1
POPROCLEV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ap Proc Level APPROCLEV Required
POP-COMPANY -> APR-COMPANY
POP-PROCESS-LEVEL -> APR-PROC-LEVEL
Cost Var Acct GLMASTER Required
POP-COMPANY -> GLM-COMPANY
POP-VAR-ACCT-UNIT -> GLM-ACCT-UNIT
POP-VAR-ACCOUNT -> GLM-ACCOUNT
POP-VAR-SUB-ACCT -> GLM-SUB-ACCOUNT
Inr Account GLMASTER Required
POP-COMPANY -> GLM-COMPANY
POP-INR-ACCT-UNIT -> GLM-ACCT-UNIT
POP-INR-ACCOUNT -> GLM-ACCOUNT
POP-INR-SUB-ACCT -> GLM-SUB-ACCOUNT
Pocompany POCOMPANY Required
POP-COMPANY -> PCY-COMPANY
Rni Account GLMASTER Required
POP-COMPANY -> GLM-COMPANY
POP-RNI-ACCT-UNIT -> GLM-ACCT-UNIT
POP-RNI-ACCOUNT -> GLM-ACCOUNT
POP-RNI-SUB-ACCT -> GLM-SUB-ACCOUNT
|