|
|
PROCTEMPLN FILE
REFERENCED BY
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO215 RQ10.1 RQ10.3 RQ10.2 RQIC.1 RQIG.1
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 CXCP.1 DR100 IC141 IC142
IC21.1 IC21.2 IC28.1 IC500 IC83.1 MA180
MA530 MA531 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 PO22.1 PO23.1 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO33.1 PO34.1 PO35.1 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 POI3.1 POIE.1
POII.1 POIJ.1 RQ11.1 RQ35.1 RQ500 RQID.1
RQIF.1 RQIJ.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 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 IC11.1 PO45.1
UPDATED BY
PO115 PO15.1 PO15.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POE-PROCURE-GROUP Alpha 4 PO115 PO15.1
Element: Procure Group This field contains the identifier for a PO15.2 PO21.1
group of companies that share a common RQ10.3
procurement effort. They buy items and
services together.
POE-TEMPLATE-REF Alpha 30 PO115 PO15.1
Element: Template Ref PO15.2 PO21.1
RQ10.3
POE-LINE-NBR Numeric 6 PO115 PO15.1
Element: Line Number This field contains the line number. PO15.2 PO21.1
RQ10.3
POE-ITEM Alpha 32 PO115 PO15.1
Element: Item Number This field contains the item PO15.2 PO21.1
identifier. RQ10.3
POE-SERVICE-DESC Alpha 30 (Lower Case) PO115 PO15.1
Element: Service Desc PO15.2 PO21.1
RQ10.3
POE-SERVICE-CODE Alpha 1 PO115 PO15.1
Element: Service Code Q = Quantity PO15.2 PO21.1
A = Amount RQ10.3
" " = Not Service Item
POE-UOM Alpha 4 PO115 PO15.1
Element: Unit of MeasurThis field contains the valid stock PO15.2 PO21.1
unit of measure for this item. RQ10.3
POE-QUANTITY Signed 13.4 PO115 PO15.1
Element: Quantity This field contains the desired PO15.2 PO21.1
quantity. RQ10.3
POE-ACCT-UNIT-FL Numeric 1 PO115 PO15.1
Element: Acct Unit Fl This flag will be used allow the PO15.2 PO21.1
requesting location accounting unit to RQ10.3
override the IC02 flag to use the GL
category accounting unit.
0 = No
1 = Yes
POE-DIST-COMPANY Numeric 4 PO115 PO15.1
Element: Company The company number used for posting the PO15.2 PO21.1
transaction. A valid intercompany RQ10.3
relationship must be defined in the
Lawson General Ledger system.
POE-ACCT-UNIT Alpha 15 PO115 PO15.1
Element: Accounting UniThe accounting unit is a shorthand PO15.2 PO21.1
notation representing the variable level RQ10.3
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.
POE-ACCOUNT Numeric 6 PO115 PO15.1
Element: Account This field along with the accounting PO15.2 PO21.1
unit and subaccount make up the location RQ10.3
(account) where amounts and other
account information is stored.
POE-SUB-ACCT Numeric 4 PO115 PO15.1
Element: Subaccount This field contains the subaccount from PO15.2 PO21.1
your general ledger chart of accounts RQ10.3
that was charged with the amount carried
on this record.
POE-ACTIVITY Alpha 15 PO115 PO15.1
Element: Activity Activities are the processes or PO15.2 PO21.1
procedures that produce work. Cost RQ10.3
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
POE-ACCT-CATEGORY Alpha 5 PO115 PO15.1
Element: Account CategoAccount categories are groupings of PO15.2 PO21.1
costs, revenues, or a combination of RQ10.3
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
POE-BILL-CATEGORY Alpha 32 PO115 PO15.1
Element: Bill Category PO15.2 PO21.1
RQ10.3
POE-FROM-COMPANY Numeric 4 PO115 PO15.1
Element: Company This is the company that is the source PO15.2 PO21.1
of the items. RQ10.3
POE-FROM-LOCATION Alpha 5 PO115 PO15.1
Element: Location Code This is the inventory location that PO15.2 PO21.1
supplies the items or it is the purchase RQ10.3
order ship to location that receives the
items.
PROCTEMPLN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POESET1 PROCURE-GROUP PO115 PO15.1
TEMPLATE-REF PO15.2 PO20.1
LINE-NBR PO21.1 PO215
RQ10.1 RQ10.3
RQIC.1 RQIG.1
POESET2 PROCURE-GROUP KeyChange AP125 AP126
TEMPLATE-REF AP131 AP25.1
ITEM AP25.2 AP26.1
LINE-NBR AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC141 IC142
IC21.1 IC21.2
IC28.1 IC500
IC83.1 MA180
...
POESET3 PROCURE-GROUP KeyChange IC11.1 PO115
ITEM PO45.1 RQID.1
TEMPLATE-REF RQIF.1 RQIJ.1
LINE-NBR
PROCTEMPLN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemmast ITEMMAST Not Required
Valid When (POE-SERVICE-CODE = Spaces )
PCG-ITEM-GROUP -> ITE-ITEM-GROUP
POE-ITEM -> ITE-ITEM
Procuregroup PROCUREGRP Not Required
POE-PROCURE-GROUP -> PCG-PROCURE-GROUP
|
