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.

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

IndexKeysFlagsConditionUsed in
RSPSET1COMPANY, REQ-NUMBER, AOC-CODEPrimaryRQ01.1, RQ11.3, RQ11.4, RQ11.5, RQ111

Programs

Updated by (3)

Referenced by (2)