RQAOCDTL – No description in the Lawson data dictionary

System: Requisitions (RQ)
Prefix: RAO
Primary key: COMPANY, REQ-NUMBER, LINE-NBR, AOC-CODE
Fields: 22
Updated by: 16 programs
Referenced by: 9 programs

RQAOCDTL is a Lawson Requisitions table (prefix RAO); no description in the lawson data dictionary. It is indexed by COMPANY, REQ-NUMBER, LINE-NBR, AOC-CODE (RAOSET1); alternate indexes: RAOSET2. It is related 1:1 to POAOCMAST. It is updated by DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 and 8 more and referenced by PO100, PO23.1, POIF.1, POIG.1, RQ01.1, RQ111, RQ12.1, RQ13.1 and 1 more. The table has 22 fields, 2 indexes and 1 documented relation.

About RQAOCDTL

No description in the Lawson data dictionary.

Fields (22)

Column = COBOL field name without the RAO- 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 / column	Type	Description & values	Updated by
#`RAO-COMPANY` PK COMPANY	Numeric 4	—	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-REQ-NUMBER` PK REQ_NUMBER	Numeric 7	—	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-LINE-NBR` PK LINE_NBR	Numeric 6	—	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-AOC-CODE` PK AOC_CODE	Alpha 2	—	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-VENDOR` VENDOR	Alpha 9 (Right Justified)	—	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-PURCH-FR-LOC` PURCH_FR_LOC	Alpha 4	—	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-LOCATION` LOCATION	Alpha 5	—	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-AOC-RATE` AOC_RATE	Percent 7.3 (Percent)	—	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-ENTRY` ENTRY	Alpha 1	— `U` Unit Cost `R` Rate Percentage `T` Total Amount	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-QUANTITY` QUANTITY	Signed 13.4	—	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-ENT-UNIT-CST` ENT_UNIT_CST	Signed 18.5	—	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-TOTAL-AOC` TOTAL_AOC	Signed 18.2	—	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-TAX-CODE` TAX_CODE	Alpha 10	—	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-TAXABLE-FLAG` TAXABLE_FLAG	Alpha 1	— `Y` Yes `N` No	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-AOC-ON-RQ` AOC_ON_RQ	Alpha 1	— `Y` Yes `N` No	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-SUMMARY-FLAG` SUMMARY_FLAG	Alpha 1	— `Y` Yes `N` No	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-ZERO-COST-FLG` ZERO_COST_FLG	Alpha 1	— `N` No `Y` Yes	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-LANDED-FLAG` LANDED_FLAG	Numeric 1	— `0` No `1` Yes	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	—	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-PO-CODE` PO_CODE	Alpha 4	—	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-GLBL-DOC-TYPE` GLBL_DOC_TYPE	Alpha 10	—	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#`RAO-GLBL-LINE-TYPE` GLBL_LINE_TYPE	Alpha 15	—	DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more

Indexes (2)

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.

Index	Keys	Flags	Condition	Used in
`RAOSET1`	`COMPANY` `REQ-NUMBER` `LINE-NBR` `AOC-CODE`	Primary		DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +17 more
`RAOSET2`	`COMPANY` `AOC-CODE` `REQ-NUMBER` `LINE-NBR`			IC83.1, RQ10.1, RQ10.4, RQ11.3, RQ11.4, RQ11.5, RQIF.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

One to one (1) — lookups and parents

Relation Table Rules Condition Field map

Poaocmast

POAOCMAST

Required

`RAO-COMPANY`	→	`PAM-COMPANY`
`RAO-AOC-CODE`	→	`PAM-AOC-CODE`

Programs

Updated by (16)

DR100 Distribution Requirements Report
IC141 Location Replenishment Report
IC142 Replenishment by Requisition PO's
IC83.1 Par Location Counts
RQ10.1 Requisition
RQ10.3 Select and Copy
RQ10.4 Requisition Line Entry Detail
RQ10.5 Substitutes
RQ11.1 Kit Accessories
RQ11.3 AOC Spread
RQ11.4 Miscellaneous AOC
RQ11.5 Item AOC
RQ300 Requisition Purge
RQ35.1 Requisition Returns
RQ500 Requisition Interface
RQIF.1 RQRLNUPD Invoke Object

Referenced by (9)

PO100 Purchase Order Interface from Lawson Applications
PO23.1 Purchase Order Worksheet
POIF.1 MMDIST Activity Commit
POIG.1 MMDIST Budget Check
RQ01.1 Requesting Locations
RQ111 Print Requisitions
RQ12.1 Approval Review
RQ13.1 Direct Approval
RQ13.2 Direct Line Approval

RQAOCDTL – No description in the Lawson data dictionary

About RQAOCDTL

Fields (22) Copy as SQL

Indexes (2)

Relations

One to one (1) — lookups and parents

Programs

Updated by (16)

Referenced by (9)

Fields (22)