RECAOCDTL – Receiving AOC Detail

System
Purchase Order (PO)
Prefix
REC
Primary key
COMPANY, REC-NUMBER, LINE-NBR, AOC-CODE
Fields
49
Updated by
225 programs
Referenced by
2 programs

RECAOCDTL is the Receiving AOC Detail table in Lawson Purchase Order (prefix REC). It is indexed by COMPANY, REC-NUMBER, LINE-NBR, AOC-CODE (RECSET1); alternate indexes: RECSET2, RECSET3, RECSET4 and RECSET5. It is related 1:1 to PORECEIVE and PORECLINE. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 217 more and referenced by MA91.1 and PO64.1. The table has 49 fields, 5 indexes and 2 documented relations.

About RECAOCDTL

No description in the Lawson data dictionary.

Fields (49)

Column = COBOL field name without the REC- 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
#REC-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.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-REC-NUMBER PK
REC_NUMBER		Numeric 10The receiver number. Assigned when this receiving information was added.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-PO-NUMBER SET2 SET3
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-PO-RELEASE SET2 SET3
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-PO-CODE SET2 SET3
PO_CODE		Alpha 4This is the purchase order code.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-AOC-CODE PK
AOC_CODE		Alpha 2This field contains the identifier for the add on cost associated with this line item.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-VENDOR SET2 SET3 SET4
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#REC-PURCH-FR-LOC
PURCH_FR_LOC		Alpha 4The vendor's purchase from location.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-LOCATION SET2 SET3
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-AOC-RATE
AOC_RATE		Percent 7.3 (Percent)Add On Cost Percentage Rate. If add on cost is spread by rate, this value times the line unit cost is the unit add on cost for the PO line.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-ENTRY
ENTRY		Alpha 1Amount Entry Method.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-QUANTITY
QUANTITY		Signed 13.4This field contains the desired quantity.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-ORIG-UNIT-CST
ORIG_UNIT_CST		Signed 18.5This is the entered unit cost.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#REC-TOTAL-AOC
TOTAL_AOC		Signed 18.2The total add on cost amount can be an entered amount if entered at this level, or a calculated amount if a unit add on cost or add on cost percent is entered.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#REC-REC-QTY
REC_QTY		Signed 13.4This is the total quantity to date received for this ordered item.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-MATCHED-QTY
MATCHED_QTY		Signed 13.4This is the qty of the receipt that has been matched.MA180, MA531, MA70.1, MA75.1, MAI1.1, PO30.1, PO30.2, PO30.3 +6 more
#REC-MISC-MA-AMT
MISC_MA_AMT		Signed 18.2OPen amount of Misc AOC.MA180, MA531, MA70.1, MA75.1, MAI1.1, PO30.1, PO30.2, PO30.3 +6 more
#REC-RECQTY-TO-MA
RECQTY_TO_MA		Signed 13.4This is the QTY remaining open to match So the RECQTY-TO-MA minus the the MATCH-QTY would replace the RECQTY-TO-MAMA180, MA531, MA70.1, MA75.1, MA80.1, MAI1.1, PO30.1, PO30.2 +7 more
#REC-RECAMT-TO-MA
RECAMT_TO_MA		Signed 18.2THis is the OPEN-TO-MATCH or the remaining amount open to matchMA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-TAX-CODE
TAX_CODE		Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-TAX-UNIT-CST
TAX_UNIT_CST		Signed 18.5—MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-TAXABLE-FLAG
TAXABLE_FLAG		Alpha 1Defines if Taxable.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-ORIGIN-CD
ORIGIN_CD		Alpha 2System origin codeMA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-AOC-ON-PO
AOC_ON_PO		Alpha 1Indicates if the add-on cost is to appear on the Purchase Order document that is issued to the vendor.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-SUMMARY-FLAG
SUMMARY_FLAG		Alpha 1Defines if add on cost is printed in summary or at a detail level on the Lawson Purchase Order document.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-ZERO-COST-FLG
ZERO_COST_FLG		Alpha 1Defines if this tax record is allowed to have a zero unit cost.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-CANCELLED-FL
CANCELLED_FL		Alpha 1—MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-CLOSED-FL
CLOSED_FL		Alpha 1The Closed Flag.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#REC-INV-SPRD-CRET
INV_SPRD_CRET		Numeric 1Defines if record was created during PO invoice spread.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-ISSUED-FLAG
ISSUED_FLAG		Alpha 1—MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-INVC-TAX-AMT
INVC_TAX_AMT		Signed 18.2—MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-ACCR-TAX-AMT
ACCR_TAX_AMT		Signed 18.2—MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-EXT-TAXBL-AMT
EXT_TAXBL_AMT		Signed 18.2—MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-LAND-UNIT-CST
LAND_UNIT_CST		Signed 18.5THis would be the landed tax amount for this AOC detail.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-LANDED-FLAG
LANDED_FLAG		Numeric 1—MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-MATCH-DTL-KEY
MATCH_DTL_KEY		Alpha 85THe match detail key is a user defined set of match criteria. The item number is required and other criteria can be added up to 85 charachters.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-XREF-VENDOR
XREF_VENDOR		Alpha 9 (Right Justified)This is a vendor that is supported on a system outside Lawson. When records are interfaces we will maintain this vendor on the file but we will use the Lawson vendor while in the lawson application.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-MATCH-REF-NBR SET4
MATCH_REF_NBR		Alpha 22Match reference number can be used to match. Set up required.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-REC-CNV-RATE
REC_CNV_RATE		Signed 14.7Currency conversion rate at Purchase Order entry time.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-TOTAL-AOC-PO
TOTAL_AOC_PO		Signed 18.2The total add-on cost amount in the Purchase Order currency.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#REC-STATUS
STATUS		Numeric 1This field displays the status of the transaction.MA180, MA531, MA70.1, MA75.1, MAI1.1, PO30.1, PO30.2, PO30.3 +6 more
#REC-OPEN-TO-MATCH
OPEN_TO_MATCH		Signed 13.4This is the amount remaining open to match.MA180, MA531, MA70.1, MA75.1, MAI1.1, PO30.1, PO30.2, PO30.3 +6 more
#REC-CHARGEBACK-QTY
CHARGEBACK_QTY		Signed 13.4This field contains the desired quantity.MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-MATCH-OBJ-ID SET5
MATCH_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.MA180, MA531, MA70.1, MA75.1, MAI1.1, PO30.1, PO30.2, PO30.3 +6 more
#REC-MATCH-SEQ-NBR SET5
MATCH_SEQ_NBR		Numeric 4An automatically assigned sequence number.MA180, MA531, MA70.1, MA75.1, MAI1.1, PO30.1, PO30.2, PO30.3 +7 more
#REC-TRACK-TYPE
TRACK_TYPE		Alpha 1" " = Other AOC
  • I Insurance
  • F Freight
  • C Customs Charges
MA180, MA531, MAI1.1, PO30.1, PO30.2, PO30.3, PO30.4, PO33.1 +4 more
#REC-GLBL-LINE-TYPE
GLBL_LINE_TYPE		Alpha 15——

Indexes (5)

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
RECSET1
  1. COMPANY
  2. REC-NUMBER
  3. LINE-NBR
  4. AOC-CODE
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
RECSET2
  1. COMPANY
  2. VENDOR
  3. PO-NUMBER
  4. PO-RELEASE
  5. PO-CODE
  6. LOCATION
  7. REC-NUMBER
  8. LINE-NBR
  9. AOC-CODE
KeyChange, SubsetWhere CLOSED-FL = "N" And CANCELLED-FL = "N"AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
RECSET3
  1. COMPANY
  2. PO-NUMBER
  3. PO-RELEASE
  4. PO-CODE
  5. REC-NUMBER
  6. LINE-NBR
  7. AOC-CODE
  8. VENDOR
  9. LOCATION
KeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
RECSET4
  1. COMPANY
  2. VENDOR
  3. MATCH-REF-NBR
  4. REC-NUMBER
  5. LINE-NBR
  6. AOC-CODE
KeyChange, SubsetWhere MATCH-REF-NBR != SpacesMA60.3, MA68.3, MAI1.1
RECSET5
  1. COMPANY
  2. MATCH-OBJ-ID
  3. MATCH-SEQ-NBR
  4. REC-NUMBER
  5. LINE-NBR
  6. AOC-CODE
KeyChangeMA70.1, MA75.1, MA90.2, MA90.3, MA90.5, MA90.6

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
PoreceivePORECEIVENot Required
REC-COMPANY→POR-COMPANY
REC-REC-NUMBER→POR-REC-NUMBER
PoreclinePORECLINERequired
REC-COMPANY→PRL-COMPANY
REC-REC-NUMBER→PRL-REC-NUMBER
REC-LINE-NBR→PRL-LINE-NBR

Programs

Updated by (225)

Referenced by (2)