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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PODSET1PROCURE-GROUP, COMPANY, TYPE, PO-CODEPrimaryAM17.1, AM19.1, AM219, AP125, AP126, AP131, AP170, AP193 +22 more (list truncated in source)

Programs

Updated by (3)

Referenced by (277)