RQAOCSPRD – No description in the Lawson data dictionary

System
Requisitions (RQ)
Prefix
RSP
Primary key
COMPANY, REQ-NUMBER, AOC-CODE
Fields
24
Updated by
3 programs
Referenced by
2 programs

RQAOCSPRD is a Lawson Requisitions table (prefix RSP); no description in the lawson data dictionary. It is indexed by COMPANY, REQ-NUMBER, AOC-CODE (RSPSET1). It is updated by RQ11.3, RQ11.4 and RQ11.5 and referenced by RQ01.1 and RQ111. The table has 24 fields, 1 index and 0 documented relations.

About RQAOCSPRD

No description in the Lawson data dictionary.

Fields (24)

Column = COBOL field name without the RSP- 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
#RSP-COMPANY PK
COMPANY		Numeric 4—RQ11.3, RQ11.4, RQ11.5
#RSP-REQ-NUMBER PK
REQ_NUMBER		Numeric 7—RQ11.3, RQ11.4, RQ11.5
#RSP-AOC-CODE PK
AOC_CODE		Alpha 2—RQ11.3, RQ11.4, RQ11.5
#RSP-AOC-RATE
AOC_RATE		Percent 7.3 (Percent)—RQ11.3, RQ11.4, RQ11.5
#RSP-ENT-AOC-AMOUNT
ENT_AOC_AMOUNT		Signed 18.2—RQ11.3, RQ11.4, RQ11.5
#RSP-CALC-SPRD-AMT
CALC_SPRD_AMT		Signed 18.2—RQ11.3, RQ11.4, RQ11.5
#RSP-SPREAD-DIFF
SPREAD_DIFF		Signed 18.2—RQ11.3, RQ11.4, RQ11.5
#RSP-SPREAD-METHOD
SPREAD_METHOD		Alpha 1—
  • Q Quantity
  • W Weight
  • V Volume
  • A Amount
  • N No Spread
  • R Rate
RQ11.3, RQ11.4, RQ11.5
#RSP-TAX-CODE
TAX_CODE		Alpha 10—RQ11.3, RQ11.4, RQ11.5
#RSP-TAXABLE-FLAG
TAXABLE_FLAG		Alpha 1—
  • Y Yes
  • N No
RQ11.3, RQ11.4, RQ11.5
#RSP-DST-ACCT-UNIT
DST_ACCT_UNIT		Alpha 15—RQ11.3, RQ11.4, RQ11.5
#RSP-DST-ACCOUNT
DST_ACCOUNT		Numeric 6—RQ11.3, RQ11.4, RQ11.5
#RSP-DST-SUB-ACCT
DST_SUB_ACCT		Numeric 4—RQ11.3, RQ11.4, RQ11.5
#RSP-ACCRUAL-FL
ACCRUAL_FL		Alpha 1——
#RSP-TAX-AMOUNT
TAX_AMOUNT		Signed 18.5——
#RSP-AOC-ON-RQ
AOC_ON_RQ		Alpha 1—
  • Y Yes
  • N No
RQ11.3, RQ11.4, RQ11.5
#RSP-SUMMARY-FLAG
SUMMARY_FLAG		Alpha 1—
  • Y Yes
  • N No
RQ11.3, RQ11.4, RQ11.5
#RSP-VENDOR
VENDOR		Alpha 9 (Right Justified)—RQ11.3, RQ11.4, RQ11.5
#RSP-PURCH-FR-LOC
PURCH_FR_LOC		Alpha 4—RQ11.3, RQ11.4, RQ11.5
#RSP-SEGMENT-BLOCK
SEGMENT_BLOCK		Alpha 103——
#RSP-ACTIVITY
ACTIVITY		Alpha 15——
#RSP-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5——
#RSP-BILL-CATEGORY
BILL_CATEGORY		Alpha 32——
#RSP-GLBL-DOC-TYPE
GLBL_DOC_TYPE		Alpha 10——

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
RSPSET1
  1. COMPANY
  2. REQ-NUMBER
  3. AOC-CODE
PrimaryRQ01.1, RQ11.3, RQ11.4, RQ11.5, RQ111

Programs

Updated by (3)

Referenced by (2)