PROCTEMPLN – Procurement Template Line

System
Purchase Order (PO)
Prefix
POE
Primary key
PROCURE-GROUP, TEMPLATE-REF, LINE-NBR
Fields
23
Updated by
7 programs
Referenced by
222 programs

PROCTEMPLN is the Procurement Template Line table in Lawson Purchase Order (prefix POE). It is indexed by PROCURE-GROUP, TEMPLATE-REF, LINE-NBR (POESET1); alternate indexes: POESET2, POESET3 and POESET4. It is related 1:1 to POVAGRMTLN, ITEMMAST and PROCUREGRP and 1:M to POVAGRMTLN and POITEMVEN. It is updated by IC216, PO00.1, PO115, PO15.1, PO15.2, PO15.4 and PO27.4 and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 214 more. The table has 23 fields, 4 indexes and 5 documented relations.

About PROCTEMPLN

No description in the Lawson data dictionary.

Fields (23)

Column = COBOL field name without the POE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
POE-PROCURE-GROUP PK
PROCURE_GROUP		Alpha 4Type or select a procurement group. A procurement group is a group of companies that share a common procurement effort. They buy items and services together.PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-TEMPLATE-REF PK
TEMPLATE_REF		Alpha 30—PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-ITEM
ITEM		Alpha 32This field contains the item identifier.PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-SERVICE-DESC
SERVICE_DESC		Alpha 30 (Lower Case)—PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-SERVICE-CODE
SERVICE_CODE		Alpha 1" " = Not Service Item
  • Q Quantity
  • A Amount
PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-UOM
UOM		Alpha 4This field contains the valid stock unit of measure for this item.PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-QUANTITY
QUANTITY		Signed 13.4This field contains the desired quantity.PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-ACCT-UNIT-FL
ACCT_UNIT_FL		Numeric 1This flag will be used allow the requesting location accounting unit to override the IC02 flag to use the GL category accounting unit.
  • 0 No
  • 1 Yes
PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-DIST-COMPANY
DIST_COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-ACCT-UNIT
ACCT_UNIT		Alpha 15The 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.PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-ACCOUNT
ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-SUB-ACCT
SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-ACTIVITY
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account categories are groupings of costs, revenues, or a combination of 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 thruPO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-BILL-CATEGORY
BILL_CATEGORY		Alpha 32—PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-FROM-COMPANY
FROM_COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-FROM-LOCATION
FROM_LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-COMMODITY-CODE
COMMODITY_CODE		Alpha 35—PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-SPECIAL-DESC
SPECIAL_DESC		Alpha 30 (Lower Case)—PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-VEN-AGRMT-REF
VEN_AGRMT_REF		Alpha 30—PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-TEMPLT-DOC-NBR
TEMPLT_DOC_NBR		Numeric 8—PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3
POE-PVN-OBJ-ID
PVN_OBJ_ID		Numeric 12—PO115, PO15.1, PO15.2, PO15.4, PO21.1, PO27.4, RQ10.3

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
POESET1PROCURE-GROUP, TEMPLATE-REF, LINE-NBRPrimaryPO00.1, PO115, PO15.1, PO15.2, PO15.4, PO20.1, PO21.1, PO215 +8 more
POESET2PROCURE-GROUP, TEMPLATE-REF, ITEM, LINE-NBRKeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
POESET3PROCURE-GROUP, ITEM, TEMPLATE-REF, LINE-NBRKeyChangeIC11.1, IC216, PO115, PO45.1, RQID.1, RQIF.1, RQIJ.1
POESET4PROCURE-GROUP, TEMPLT-DOC-NBR, LINE-NBRKeyChange, SubsetWhere TEMPLT-DOC-NBR != ZeroesPO100

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AgrmtlinecostPOVAGRMTLNNot RequiredValid When POE-PVN-OBJ-ID != ZeroesPOE-PVN-OBJ-ID → PVN-PVN-OBJ-ID
ItemmastITEMMASTNot RequiredValid When (POE-SERVICE-CODE = Spaces)PCG-ITEM-GROUP → ITE-ITEM-GROUP, POE-ITEM → ITE-ITEM
ProcuregroupPROCUREGRPNot RequiredPOE-PROCURE-GROUP → PCG-PROCURE-GROUP

One to many (2) — child tables

RelationTableRulesConditionField map
AgreementitemsPOVAGRMTLNValid When POE-VEN-AGRMT-REF != SpacesPOE-PROCURE-GROUP → PVN-PROCURE-GROUP, POE-ITEM → PVN-ITEM, POE-VEN-AGRMT-REF → PVN-VEN-AGRMT-REF, → PVN-LINE-NBR
PoitemvenPOITEMVENPOE-PROCURE-GROUP → PIV-PROCURE-GROUP, POE-ITEM → PIV-ITEM, → PIV-VENDOR, → PIV-VEN-ITEM

Programs

Updated by (7)

Referenced by (222)