Lawson Insight Technical Documentation |
|
RECAOCDTL
RECAOCDTL FILE
Receiving AOC Detail
REFERENCED BY
MA90.2 MA90.3 MA90.5 MA310 MA91.1
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 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA70.1 MA75.1 MA80.1
MAI1.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PO100 PO101 PO122 PO131 PO190
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO29.1 PO30.1 PO30.2 PO30.3
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
POD0.1 POI3.1 POID.1 POII.1 POIJ.1 RQ10.1
RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
REC-COMPANY Numeric 4 MA180 MA531
Element: Company Identifies the AP company if the MAI1.1 PO30.1
resource type = V. Identifies the HR PO30.2 PO30.3
company if the resource type = E. It is PO33.1 PO34.1
blank for type A, P or Q resources. PO35.1 PO38.1
PO52.1
REC-REC-NUMBER Numeric 10 MA180 MA531
Element: Rec Number The receiver number. Assigned when MAI1.1 PO30.1
this receiving information was added. PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-PO-NUMBER Alpha 14 (Right Justified) MA180 MA531
Element: Po Number This field contains the number MAI1.1 PO30.1
representing the purchase order. PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-PO-RELEASE Numeric 4 MA180 MA531
Element: Po Release Used to identify a purchase order MAI1.1 PO30.1
release (created from a Blanket or PO30.2 PO30.3
Standing order). PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-PO-CODE Alpha 4 MA180 MA531
Element: Po Code This is the purchase order code. MAI1.1 PO30.1
PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-LINE-NBR Numeric 6 MA180 MA531
Element: Line Nbr This field contains the line number. MAI1.1 PO30.1
PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-AOC-CODE Alpha 2 MA180 MA531
Element: Aoc Code This field contains the identifier for MAI1.1 PO30.1
the add on cost associated with this PO30.2 PO30.3
line item. PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-VENDOR Alpha 9 (Right Justified) MA180 MA531
Element: Vendor The vendor's identification code. MAI1.1 PO30.1
PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1 POII.1
REC-PURCH-FR-LOC Alpha 4 MA180 MA531
Element: Purch Fr Loc The vendor's purchase from location. MAI1.1 PO30.1
PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-LOCATION Alpha 5 MA180 MA531
Element: Location This field contains a valid stocking MAI1.1 PO30.1
location within the company inventory. PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-AOC-RATE Percent 7.3 (Percent) MA180 MA531
Element: Aoc Rate Add On Cost Percentage Rate. If add on MAI1.1 PO30.1
cost is spread by rate, this value times PO30.2 PO30.3
the line unit cost is the unit add on PO33.1 PO34.1
cost for the PO line. PO35.1 PO38.1
PO52.1
REC-ENTRY Alpha 1 MA180 MA531
Element: Entry Amount Entry Method. MAI1.1 PO30.1
PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-QUANTITY Signed 13.4 MA180 MA531
Element: Quantity This field contains the desired MAI1.1 PO30.1
quantity. PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-ORIG-UNIT-CST Signed 18.5 AP125 AP126
Element: Intl Cost This is the entered unit cost. 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 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
MAI1.1 PD10.1
PD10.2 PD130
PD20.1 PD20.2
...
REC-TOTAL-AOC Signed 18.2 AP125 AP126
Element: Intl Amt The total add on cost amount can be an AP131 AP20.1
entered amount if entered at this level, AP20.2 AP20.3
or a calculated amount if a unit add on AP20.4 AP20.5
cost or add on cost percent is entered. AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
MAI1.1 PD10.1
PD10.2 PD130
PD20.1 PD20.2
...
REC-REC-QTY Signed 13.4 MA180 MA531
Element: Rec Qty This is the total quantity to date MAI1.1 PO30.1
received for this ordered item. PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-MATCHED-QTY Signed 13.4 MA180 MA531
Element: Matched Qty This is the qty of the receipt that has MA70.1 MA75.1
been matched. MAI1.1 PO30.1
PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-MISC-MA-AMT Signed 18.2 AP125 AP126
Element: Intl Amt OPen amount of Misc AOC. AP25.1 AP25.2
AP26.1 AP27.1
MA180 MA531
MA70.1 MA75.1
MAI1.1 PO30.1
PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-RECQTY-TO-MA Signed 13.4 AP125 AP126
Element: Rec Qty This is the QTY remaining open to match AP25.1 AP25.2
So the RECQTY-TO-MA minus the the AP26.1 AP27.1
MATCH-QTY would replace the RECQTY-TO-MA MA180 MA531
MA70.1 MA75.1
MA80.1 MAI1.1
PO30.1 PO30.2
PO30.3 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
REC-RECAMT-TO-MA Signed 18.2 AP125 AP126
Element: Intl Amt THis is the OPEN-TO-MATCH or the AP25.1 AP25.2
remaining amount open to match AP26.1 AP27.1
MA180 MA531
MAI1.1 PO30.1
PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-TAX-CODE Alpha 10 MA180 MA531
Element: Tax Code This field contains a code representing MAI1.1 PO30.1
specific tax information. This must be PO30.2 PO30.3
valid Tax Code. PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-TAX-UNIT-CST Signed 18.5 MA180 MA531
Element: Intl Cost MAI1.1 PO30.1
PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-TAXABLE-FLAG Alpha 1 MA180 MA531
Element: Taxable Flag Defines if Taxable. MAI1.1 PO30.1
PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-ORIGIN-CD Alpha 2 MA180 MA531
Element: Origin Code System origin code MAI1.1 PO30.1
PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-AOC-ON-PO Alpha 1 MA180 MA531
Element: Aoc On Po Indicates if the add-on cost is to MAI1.1 PO30.1
appear on the Purchase Order document PO30.2 PO30.3
that is issued to the vendor. PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-SUMMARY-FLAG Alpha 1 MA180 MA531
Element: Summary Flag Defines if add on cost is printed in MAI1.1 PO30.1
summary or at a detail level on the PO30.2 PO30.3
Lawson Purchase Order document. PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-ZERO-COST-FLG Alpha 1 MA180 MA531
Element: Zero Cost Flg Defines if this tax record is allowed MAI1.1 PO30.1
to have a zero unit cost. PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-CANCELLED-FL Alpha 1 MA180 MA531
Element: All Flag MAI1.1 PO30.1
PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-CLOSED-FL Alpha 1 AP125 AP126
Element: Closed Fl The Closed Flag. 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 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
MAI1.1 PD10.1
PD10.2 PD130
PD20.1 PD20.2
...
REC-INV-SPRD-CRET Numeric 1 MA180 MA531
Element: Inv Sprd Cret Defines if record was created during PO MAI1.1 PO30.1
invoice spread. PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-ISSUED-FLAG Alpha 1 MA180 MA531
Element: All Flag MAI1.1 PO30.1
PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-INVC-TAX-AMT Signed 18.2 MA180 MA531
Element: Intl Amt MAI1.1 PO30.1
PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-ACCR-TAX-AMT Signed 18.2 MA180 MA531
Element: Intl Amt MAI1.1 PO30.1
PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-EXT-TAXBL-AMT Signed 18.2 MA180 MA531
Element: Intl Amt MAI1.1 PO30.1
PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-LAND-UNIT-CST Signed 18.5 MA180 MA531
Element: Intl Cost THis would be the landed tax amount for MAI1.1 PO30.1
this AOC detail. PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-LANDED-FLAG Numeric 1 MA180 MA531
Element: Landed Flag MAI1.1 PO30.1
PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-MATCH-DTL-KEY Alpha 85 MA180 MA531
Element: Match Dtl Key THe match detail key is a user defined MAI1.1 PO30.1
set of match criteria. The item number PO30.2 PO30.3
is required and other criteria can be PO33.1 PO34.1
added up to 85 charachters. PO35.1 PO38.1
PO52.1
REC-XREF-VENDOR Alpha 9 (Right Justified) MA180 MA531
Element: Xref Vendor This is a vendor that is supported on a MAI1.1 PO30.1
system outside Lawson. When records are PO30.2 PO30.3
interfaces we will maintain this vendor PO33.1 PO34.1
on the file but we will use the Lawson PO35.1 PO38.1
vendor while in the lawson application. PO52.1
REC-MATCH-REF-NBR Alpha 22 MA180 MA531
Element: Match Ref Nbr Match reference number can be used to MAI1.1 PO30.1
match. Set up required. PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-CURRENCY-CODE Alpha 5 MA180 MA531
Element: Currency Code This field contains the company base MAI1.1 PO30.1
currency code established in Company PO30.2 PO30.3
(GL10.1 ). PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-REC-CNV-RATE Signed 14.7 MA180 MA531
Element: Ent Cnv Rate Currency conversion rate at Purchase MAI1.1 PO30.1
Order entry time. PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-TOTAL-AOC-PO Signed 18.2 AP125 AP126
Element: Intl Amt The total add-on cost amount in the AP131 AP20.1
Purchase Order currency. 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 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
MAI1.1 PD10.1
PD10.2 PD130
PD20.1 PD20.2
...
REC-STATUS Numeric 1 AP125 AP126
Element: Status This field displays the status of the AP25.1 AP25.2
transaction. AP26.1 AP27.1
MA180 MA531
MA70.1 MA75.1
MAI1.1 PO30.1
PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-OPEN-TO-MATCH Signed 13.4 AP125 AP126
Element: Open To Match This is the amount remaining open to AP25.1 AP25.2
match. AP26.1 AP27.1
MA180 MA531
MA70.1 MA75.1
MAI1.1 PO30.1
PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-CHARGEBACK-QTY Signed 13.4 MA180 MA531
Element: Quantity This field contains the desired MAI1.1 PO30.1
quantity. PO30.2 PO30.3
PO33.1 PO34.1
PO35.1 PO38.1
PO52.1
REC-MATCH-OBJ-ID Numeric 12 MA180 MA531
Element: Obj Id This is the object identifier. It is MA70.1 MA75.1
used to relate commitments or posted MAI1.1 PO30.1
transactions back to the originating PO30.2 PO30.3
subsystems. Each subsystem record that PO33.1 PO34.1
is updated as a commitment or posted PO35.1 PO38.1
transaction is assigned an object PO52.1
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.
REC-MATCH-SEQ-NBR Numeric 4 MA180 MA531
Element: Seq Nbr An automatically assigned sequence MA70.1 MA75.1
number. MAI1.1 PO30.1
PO30.2 PO30.3
PO300 PO33.1
PO34.1 PO35.1
PO38.1 PO52.1
RECAOCDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RECSET1 COMPANY AP125 AP126
REC-NUMBER AP131 AP20.1
LINE-NBR AP20.2 AP20.3
AOC-CODE AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
RECSET2 COMPANY KeyChange, Subset AP125 AP126
VENDOR Where CLOSED-FL = "N" AP131 AP20.1
PO-NUMBER And CANCELLED-FL = "N" AP20.2 AP20.3
PO-RELEASE AP20.4 AP20.5
PO-CODE AP20.7 AP21.1
LOCATION AP23.1 AP25.1
REC-NUMBER AP25.2 AP26.1
LINE-NBR AP27.1 AP30.4
AOC-CODE API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
RECSET3 COMPANY KeyChange AP125 AP126
PO-NUMBER AP131 AP20.1
PO-RELEASE AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
REC-NUMBER AP20.7 AP21.1
LINE-NBR AP23.1 AP25.1
AOC-CODE AP25.2 AP26.1
VENDOR AP27.1 AP30.4
LOCATION API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
RECSET4 COMPANY KeyChange, Subset MA60.3 MA68.3
VENDOR Where MATCH-REF-NBR != Spaces MAI1.1
MATCH-REF-NBR
REC-NUMBER
LINE-NBR
AOC-CODE
RECSET5 COMPANY KeyChange MA70.1 MA75.1
MATCH-OBJ-ID MA90.2 MA90.3
MATCH-SEQ-NBR MA90.5
REC-NUMBER
LINE-NBR
AOC-CODE
RECAOCDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Poreceive PORECEIVE Not Required
REC-COMPANY -> POR-COMPANY
REC-REC-NUMBER -> POR-REC-NUMBER
|