RECAOCDTL

Receiving AOC Detail
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 API2.1
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 DR100 IC140
IC66.1 IC83.1 MA180 MA310 MA41.1 MA41.2
MA41.4 MA41.7 MA42.2 MA43.2 MA43.7 MA44.1
MA44.2 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MA90.2 MA90.3
MA90.5 MA90.6 MA91.1 MAI1.1 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PO100 PO101
PO122 PO131 PO136 PO150 PO190 PO20.1
PO20.6 PO20.9 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.3 PO22.4 PO23.1 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO27.2 PO28.2
PO29.1 PO30.1 PO30.2 PO30.3 PO30.4 PO300
PO31.1 PO31.2 PO32.2 PO32.4 PO33.1 PO34.1
PO35.1 PO36.1 PO36.2 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 PO536 PO54.5
PO64.1 POCP.1 POD0.1 POI3.1 POID.1 POII.1
POIJ.1 RQ10.1 RQ10.2 RQ10.4 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ500 RQIF.1 WH130 WH132
WH190 WH20.2 WH20.7 WH222 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
REC-COMPANY
Element: Company
Numeric 4
Identifies 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
PO34.1 PO35.1
PO38.1 PO52.1
REC-REC-NUMBER
Element: Rec Number
Numeric 10
The receiver number. Assigned when this receiving information was added.
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-PO-NUMBER
Element: 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
PO34.1 PO35.1
PO38.1 PO52.1
REC-PO-RELEASE
Element: Po Release
Numeric 4
Used 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
PO34.1 PO35.1
PO38.1 PO52.1
REC-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-AOC-CODE
Element: Aoc Code
Alpha 2
This 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
PO34.1 PO35.1
PO38.1 PO52.1
REC-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
REC-PURCH-FR-LOC
Element: Purch Fr Loc
Alpha 4
The vendor's purchase from location.
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-AOC-RATE
Element: 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
PO34.1 PO35.1
PO38.1 PO52.1
REC-ENTRY
Element: Entry
Alpha 1
Amount Entry Method.
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-QUANTITY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-ORIG-UNIT-CST
Element: Intl Cost
Signed 18.5
This is the entered unit cost.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
REC-TOTAL-AOC
Element: Intl Amt
Signed 18.2
The 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
REC-REC-QTY
Element: Rec Qty
Signed 13.4
This 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
PO34.1 PO35.1
PO38.1 PO52.1
REC-MATCHED-QTY
Element: Matched Qty
Signed 13.4
This is the qty of the receipt that has been matched.
MA180 MA531
MA70.1 MA75.1
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-MISC-MA-AMT
Element: Intl Amt
Signed 18.2
OPen amount of Misc AOC.
MA180 MA531
MA70.1 MA75.1
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-RECQTY-TO-MA
Element: Rec Qty
Signed 13.4
This is the QTY remaining open to match So the RECQTY-TO-MA minus the the MATCH-QTY would replace the RECQTY-TO-MA
MA180 MA531
MA70.1 MA75.1
MA80.1 MAI1.1
PO30.1 PO30.2
PO30.3 PO30.4
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-RECAMT-TO-MA
Element: Intl Amt
Signed 18.2
THis is the OPEN-TO-MATCH or the remaining amount open to match
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-TAX-CODE
Element: Tax Code
Alpha 10
This 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
PO34.1 PO35.1
PO38.1 PO52.1
REC-TAX-UNIT-CST
Element: Intl Cost
Signed 18.5
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-TAXABLE-FLAG
Element: Taxable Flag
Alpha 1
Defines if Taxable.
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-ORIGIN-CD
Element: Origin Code
Alpha 2
System origin code
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-AOC-ON-PO
Element: Aoc On Po
Alpha 1
Indicates 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
PO34.1 PO35.1
PO38.1 PO52.1
REC-SUMMARY-FLAG
Element: Summary Flag
Alpha 1
Defines 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
PO34.1 PO35.1
PO38.1 PO52.1
REC-ZERO-COST-FLG
Element: Zero Cost Flg
Alpha 1
Defines 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
PO34.1 PO35.1
PO38.1 PO52.1
REC-CANCELLED-FL
Element: All Flag
Alpha 1
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-CLOSED-FL
Element: Closed Fl
Alpha 1
The Closed Flag.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
REC-INV-SPRD-CRET
Element: Inv Sprd Cret
Numeric 1
Defines if record was created during PO invoice spread.
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-ISSUED-FLAG
Element: All Flag
Alpha 1
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-INVC-TAX-AMT
Element: Intl Amt
Signed 18.2
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-ACCR-TAX-AMT
Element: Intl Amt
Signed 18.2
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-EXT-TAXBL-AMT
Element: Intl Amt
Signed 18.2
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-LAND-UNIT-CST
Element: Intl Cost
Signed 18.5
THis would be the landed tax amount for this AOC detail.
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-LANDED-FLAG
Element: Landed Flag
Numeric 1
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-MATCH-DTL-KEY
Element: Match Dtl Key
Alpha 85
THe 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
PO34.1 PO35.1
PO38.1 PO52.1
REC-XREF-VENDOR
Element: 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
PO34.1 PO35.1
PO38.1 PO52.1
REC-MATCH-REF-NBR
Element: Match Ref Nbr
Alpha 22
Match reference number can be used to match. Set up required.
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-CURRENCY-CODE
Element: Currency Code
Alpha 5
This 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
PO34.1 PO35.1
PO38.1 PO52.1
REC-REC-CNV-RATE
Element: Ent Cnv Rate
Signed 14.7
Currency conversion rate at Purchase Order entry time.
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-TOTAL-AOC-PO
Element: Intl Amt
Signed 18.2
The total add-on cost amount in the Purchase Order currency.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
REC-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction.
MA180 MA531
MA70.1 MA75.1
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-OPEN-TO-MATCH
Element: Open To Match
Signed 13.4
This is the amount remaining open to match.
MA180 MA531
MA70.1 MA75.1
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-CHARGEBACK-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-MATCH-OBJ-ID
Element: Obj Id
Numeric 12
This 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
PO30.4 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-MATCH-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
MA180 MA531
MA70.1 MA75.1
MAI1.1 PO30.1
PO30.2 PO30.3
PO30.4 PO300
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1


RECAOCDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RECSET1 COMPANY
REC-NUMBER
LINE-NBR
AOC-CODE
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
RECSET2 COMPANY
VENDOR
PO-NUMBER
PO-RELEASE
PO-CODE
LOCATION
REC-NUMBER
LINE-NBR
AOC-CODE
KeyChange, Subset
WhereCLOSED-FL ="N"
AndCANCELLED-FL ="N"
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
RECSET3 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
REC-NUMBER
LINE-NBR
AOC-CODE
VENDOR
LOCATION
KeyChange
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
RECSET4 COMPANY
VENDOR
MATCH-REF-NBR
REC-NUMBER
LINE-NBR
AOC-CODE
KeyChange, Subset
WhereMATCH-REF-NBR !=Spaces
MA60.3 MA68.3
MAI1.1
RECSET5 COMPANY
MATCH-OBJ-ID
MATCH-SEQ-NBR
REC-NUMBER
LINE-NBR
AOC-CODE
KeyChange
MA70.1 MA75.1
MA90.2 MA90.3
MA90.5 MA90.6


RECAOCDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Poreceive PORECEIVE Not Required
REC-COMPANY->POR-COMPANY
REC-REC-NUMBER->POR-REC-NUMBER
Porecline PORECLINE Required
REC-COMPANY->PRL-COMPANY
REC-REC-NUMBER->PRL-REC-NUMBER
REC-LINE-NBR->PRL-LINE-NBR


File created: Thu Jun 09 11:25:30 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.