Lawson Insight Technical Documentation |
|
RECAOCDTL
RECAOCDTL FILE
Receiving AOC Detail
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 IC28.1 MA180 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA66.3
MA67.1 MA67.2 MA70.1 MA75.1 MA80.1 MAI1.1
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE111 OE113 OE114 OE116 OE129
OE13.2 OE13.3 OE13.5 OE13.6 OE14.4 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE530 OE81.1 OE810 OE830
OE90.1 OE90.2 PO100 PO101 PO122 PO131
PO20.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 POI3.1 POIE.1 POII.1 POIJ.1 RQ10.1
RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
REC-COMPANY Numeric 4 MA531 PO30.1
Element: Company Identifies the AP company if the PO30.2 PO30.3
resource type = V. Identifies the HR PO35.1 PO38.1
company if the resource type = E. It is PO52.1
blank for type A, P or Q resources.
REC-REC-NUMBER Numeric 10 MA531 PO30.1
Element: Receiver NumbeThe receiver number. Assigned when PO30.2 PO30.3
this receiving information was added. PO35.1 PO38.1
PO52.1
REC-PO-NUMBER Alpha 14 (Right Justified) MA531 PO30.1
Element: PO Number This field contains the number PO30.2 PO30.3
representing the purchase order. PO35.1 PO38.1
PO52.1
REC-PO-RELEASE Numeric 4 MA531 PO30.1
Element: PO Release NumUsed to identify a purchase order PO30.2 PO30.3
release (created from a Blanket or PO35.1 PO38.1
Standing order). PO52.1
REC-PO-CODE Alpha 4 MA531 PO30.1
Element: Po Code This is the purchase order code. PO30.2 PO30.3
PO35.1 PO38.1
PO52.1
REC-LINE-NBR Numeric 6 MA531 PO30.1
Element: Line Number This field contains the line number. PO30.2 PO30.3
PO35.1 PO38.1
PO52.1
REC-AOC-CODE Alpha 2 MA531 PO30.1
Element: Add On Cost CoThis field contains the identifier for PO30.2 PO30.3
the add on cost associated with this PO35.1 PO38.1
line item. PO52.1
REC-VENDOR Alpha 9 (Right Justified) MA531 PO30.1
Element: Vendor ID The vendor's identification code. PO30.2 PO30.3
PO35.1 PO38.1
PO52.1
REC-PURCH-FR-LOC Alpha 4 MA531 PO30.1
Purchase From The vendor's purchase from location. PO30.2 PO30.3
Location Code PO35.1 PO38.1
PO52.1
REC-LOCATION Alpha 5 MA531 PO30.1
Element: Location Code This field contains a valid stocking PO30.2 PO30.3
location within the company inventory. PO35.1 PO38.1
PO52.1
REC-AOC-RATE Percent 7.3 (Percent) MA531 PO30.1
Element: Add On Cost RaAdd On Cost Percentage Rate. If add on PO30.2 PO30.3
cost is spread by rate, this value times PO35.1 PO38.1
the line unit cost is the unit add on PO52.1
cost for the PO line.
REC-ENTRY Alpha 1 MA531 PO30.1
Element: Entry Amount Entry Method. PO30.2 PO30.3
PO35.1 PO38.1
PO52.1
REC-QUANTITY Signed 13.4 MA531 PO30.1
Element: Quantity This field contains the desired PO30.2 PO30.3
quantity. PO35.1 PO38.1
PO52.1
REC-ORIG-UNIT-CST Signed 18.5 MA531 PO30.1
Element: Intl Cost PO30.2 PO30.3
PO35.1 PO38.1
PO52.1
REC-ENT-UNIT-CST Signed 18.5 MA531 PO30.1
Element: Intl Cost The entered unit cost. PO30.2 PO30.3
PO35.1 PO38.1
PO52.1
REC-TOTAL-AOC Signed 18.2 MA531 PO30.1
Element: Intl Amt The total add on cost amount can be an PO30.2 PO30.3
entered amount if entered at this PO35.1 PO38.1
level, or a calculated amount if a unit PO52.1
add on cost or add on cost percent is
entered.
REC-REC-QTY Signed 13.4 MA531 PO30.1
Element: Receiving QuanThis is the total quantity to date PO30.2 PO30.3
received for this ordered item. PO35.1 PO38.1
PO52.1
REC-MATCHED-QTY Signed 13.4 MA531 PO30.1
Element: Matched Qty PO30.2 PO30.3
PO35.1 PO38.1
PO52.1
REC-MISC-MA-AMT Signed 18.2 MA531 PO30.1
Element: Intl Amt PO30.2 PO30.3
PO35.1 PO38.1
PO52.1
REC-RECQTY-TO-MA Signed 13.4 MA531 PO30.1
Element: Receiving QuanThis is the QTY remaining open to match PO30.2 PO30.3
PO35.1 PO38.1
PO52.1
REC-RECAMT-TO-MA Signed 18.2 MA531 PO30.1
Element: Intl Amt This is the AMT remaining to match PO30.2 PO30.3
PO35.1 PO38.1
PO52.1
REC-TAX-CODE Alpha 10 MA531 PO30.1
Element: Tax Code This field contains a code representing PO30.2 PO30.3
specific tax information. This must be PO35.1 PO38.1
valid Tax Code. PO52.1
REC-TAX-UNIT-CST Signed 18.5 MA531 PO30.1
Element: Intl Cost PO30.2 PO30.3
PO35.1 PO38.1
PO52.1
REC-TAXABLE-FLAG Alpha 1 MA531 PO30.1
Taxable or Defines if Taxable. PO30.2 PO30.3
Non-Taxable Flag PO35.1 PO38.1
PO52.1
REC-ORIGIN-CD Alpha 2 MA531 PO30.1
Element: Origin Code This field identifies the system that PO30.2 PO30.3
created this record. PO35.1 PO38.1
PO52.1
REC-AOC-ON-PO Alpha 1 MA531 PO30.1
Element: Aoc On Po Indicates if the add-on cost is to PO30.2 PO30.3
appear on the Purchase Order document PO35.1 PO38.1
that is issued to the vendor. PO52.1
REC-SUMMARY-FLAG Alpha 1 MA531 PO30.1
Element: Summary Flag Defines if add on cost is printed in PO30.2 PO30.3
summary or at a detail level on the PO35.1 PO38.1
Lawson Purchase Order document. PO52.1
REC-ZERO-COST-FLG Alpha 1 MA531 PO30.1
Element: Zero Cost FlagDefines if this tax record is allowed PO30.2 PO30.3
to have a zero unit cost. PO35.1 PO38.1
PO52.1
REC-CANCELLED-FL Alpha 1 MA531 PO30.1
Element: All Flag The canceled flag. PO30.2 PO30.3
PO35.1 PO38.1
PO52.1
REC-CLOSED-FL Alpha 1 MA531 PO30.1
Element: Closed Flag The Closed Flag. PO30.2 PO30.3
PO35.1 PO38.1
PO52.1
REC-INV-SPRD-CRET Numeric 1 MA531 PO30.1
Element: Inv Sprd Cret Defines if record was created during PO PO30.2 PO30.3
invoice spread. PO35.1 PO38.1
PO52.1
REC-ISSUED-FLAG Alpha 1 MA531 PO30.1
Element: All Flag This is the issue status of the purchase PO30.2 PO30.3
order source record. If the PO has been PO35.1 PO38.1
issued at least once since the PO source PO52.1
record was created, this flag will be
set to a value of "Y". Once set to "Y",
it never changes.
REC-INVC-TAX-AMT Signed 18.2 MA531 PO30.1
Element: Intl Amt The tax amount that is to be invoiced. PO30.2 PO30.3
PO35.1 PO38.1
PO52.1
REC-ACCR-TAX-AMT Signed 18.2 MA531 PO30.1
Element: Intl Amt The tax amount that is to be accrued. PO30.2 PO30.3
PO35.1 PO38.1
PO52.1
REC-EXT-TAXBL-AMT Signed 18.2 MA531 PO30.1
Element: Intl Amt The extended taxable amount -- taxable PO30.2 PO30.3
unit cost * (quantity - cancelled PO35.1 PO38.1
quantity). PO52.1
REC-LAND-UNIT-CST Signed 18.5 MA531 PO30.1
Element: Intl Cost All add on costs that are landed PO30.2 PO30.3
in addition to the product unit cost. PO35.1 PO38.1
PO52.1
REC-BL-INVC-AMT Signed 18.2 MA531 PO30.1
Element: Intl Amt PO30.2 PO30.3
PO35.1 PO38.1
PO52.1
REC-LANDED-FL Alpha 1 MA531 PO30.1
Element: Landed Fl This flag will denote if the AOC of PO30.2 PO30.3
record is landed or not landed. Landed PO35.1 PO38.1
means the AOC takes on the PO52.1
characteristics of the goods it is
landed to.
REC-MATCH-DTL-KEY Alpha 85 MA531 PO30.1
Element: Match Dtl Key PO30.2 PO30.3
PO35.1 PO38.1
PO52.1
REC-XREF-VENDOR Alpha 9 (Right Justified) MA531 PO30.1
Element: Xref Vendor This is a vendor that is supported on a PO30.2 PO30.3
system outside Lawson. When records are PO35.1 PO38.1
interfaces we will maintain this vendor PO52.1
on the file but we will use the Lawson
vendor while in the lawson application.
REC-MATCH-REF-NBR Alpha 22 MA531 PO30.1
Element: Match Ref Nbr PO30.2 PO30.3
PO35.1 PO38.1
PO52.1
REC-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
REC-REC-CNV-RATE Signed 14.7
Entered Conversion Currency conversion rate for the
Rate Purchase Order at receiving time.
REC-TOTAL-AOC-PO Signed 18.2
Element: Intl Amt The total add-on cost amount in the
Purchase Order currency.
REC-STATUS Numeric 1
Element: Status This field displays the status of the
transaction.
REC-OPEN-TO-MATCH Signed 13.4
Element: Open To Match
RECAOCDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RECSET1 COMPANY AP125 AP126
REC-NUMBER AP131 AP25.1
LINE-NBR AP25.2 AP26.1
AOC-CODE AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
...
RECSET2 COMPANY
REC-NUMBER
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
AOC-CODE
VENDOR
RECSET3 COMPANY MA531 PO30.1
PO-NUMBER PO30.2 PO30.3
PO-RELEASE PO35.1 PO52.1
PO-CODE
REC-NUMBER
LINE-NBR
AOC-CODE
VENDOR
LOCATION
RECSET4 COMPANY
REC-NUMBER
VENDOR
LINE-NBR
AOC-CODE
RECSET5 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
REC-NUMBER
AOC-CODE
VENDOR
LOCATION
RECAOCDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Poreceive PORECEIVE Not Required
REC-COMPANY -> POR-COMPANY (PORSET1)
REC-REC-NUMBER -> POR-REC-NUMBER
|