PODOCREF – Document Reference

System
Purchase Order (PO)
Prefix
POD
Primary key
PROCURE-GROUP, COMPANY, TYPE, PO-CODE
Fields
9
Updated by
3 programs
Referenced by
277 programs

PODOCREF is the Document Reference table in Lawson Purchase Order (prefix POD). It is indexed by PROCURE-GROUP, COMPANY, TYPE, PO-CODE (PODSET1). It is updated by IC00.1, POI4.1 and POI6.1 and referenced by AM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 and 269 more. The table has 9 fields, 1 index and 0 documented relations.

About PODOCREF

No description in the Lawson data dictionary.

Fields (9)

Column = COBOL field name without the POD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#POD-PROCURE-GROUP PK
PROCURE_GROUP		Alpha 4This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together.IC00.1, POI4.1
#POD-COMPANY PK
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.IC00.1, POI4.1
#POD-TYPE PK
TYPE		Alpha 2This identifies what type of document the identifying number is defaulting for.
  • PO Purchase Order
  • RC PO Receiver
  • VR Vendor Return
  • RA Receiving Adjustment
  • IN Receiving Inspection
  • PA Price Agreement
  • RQ Requisition
  • IC Item Number
  • RE Inventory Receipt
  • IS Inventory Issue
  • IT Inventory Transfer
  • RT Inventory Intransit Receiving
  • AJ Inventory Adjustment
  • BT Inventory Bin Transfer
IC00.1, POI4.1
#POD-PO-CODE PK
PO_CODE		Alpha 4This is the purchase order code.IC00.1, POI4.1
#POD-NUM-DOC-FLAG
NUM_DOC_FLAG		Alpha 1Enter a Yes or No in this field to indicate if document numbers must be numeric.
  • Y Yes
  • N No
IC00.1, POI4.1
#POD-AUTO-NBR-FL
AUTO_NBR_FL		Alpha 1Enter a Yes or No into this field to indicate if document numbers are automatically assigned by the system.
  • Y Yes
  • N No
IC00.1, POI4.1
#POD-LAST-DOC-NBR
LAST_DOC_NBR		Numeric 14This is the last document number used.IC00.1, POI4.1, POI6.1
#POD-BEG-MANUAL-DOC
BEG_MANUAL_DOC		Numeric 14Enter a number here to indicate the beginning of a range of manually entered purchase order numbers you want to limit users to, if purchase order numbers are normally auto assigned.POI4.1
#POD-END-MANUAL-DOC
END_MANUAL_DOC		Numeric 14Enter a number here to indicate the end of a range of manual purchase order numbers allowed to be entered, if purchase order numbers are normally auto assigned.POI4.1

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PODSET1
  1. PROCURE-GROUP
  2. COMPANY
  3. TYPE
  4. PO-CODE
PrimaryAM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +22 more (list truncated in source)

Programs

Updated by (3)

Referenced by (277)