Receiving AOC Detail
UPDATED BY
| 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. |
|
||||||||||||||||
| REC-REC-NUMBER Element: Rec Number | Numeric 10 The receiver number. Assigned when this receiving information was added. |
|
||||||||||||||||
| REC-PO-NUMBER Element: Po Number | Alpha 14 (Right Justified) This field contains the number representing the purchase order. |
|
||||||||||||||||
| REC-PO-RELEASE Element: Po Release | Numeric 4 Used to identify a purchase order release (created from a Blanket or Standing order). |
|
||||||||||||||||
| REC-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code. |
|
||||||||||||||||
| REC-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the line number. |
|
||||||||||||||||
| REC-AOC-CODE Element: Aoc Code | Alpha 2 This field contains the identifier for the add on cost associated with this line item. |
|
||||||||||||||||
| REC-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. |
|||||||||||||||||
| REC-PURCH-FR-LOC Element: Purch Fr Loc | Alpha 4 The vendor's purchase from location. |
|
||||||||||||||||
| REC-LOCATION Element: Location | Alpha 5 This field contains a valid stocking location within the company inventory. |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| REC-ENTRY Element: Entry | Alpha 1 Amount Entry Method. |
|
||||||||||||||||
| REC-QUANTITY Element: Quantity | Signed 13.4 This field contains the desired quantity. |
|
||||||||||||||||
| REC-ORIG-UNIT-CST Element: Intl Cost | Signed 18.5 This is the entered unit cost. |
|||||||||||||||||
| 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. |
|||||||||||||||||
| REC-REC-QTY Element: Rec Qty | Signed 13.4 This is the total quantity to date received for this ordered item. |
|
||||||||||||||||
| REC-MATCHED-QTY Element: Matched Qty | Signed 13.4 This is the qty of the receipt that has been matched. |
|
||||||||||||||||
| REC-MISC-MA-AMT Element: Intl Amt | Signed 18.2 OPen amount of Misc AOC. |
|
||||||||||||||||
| 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 |
|
||||||||||||||||
| REC-RECAMT-TO-MA Element: Intl Amt | Signed 18.2 THis is the OPEN-TO-MATCH or the remaining amount open to match |
|
||||||||||||||||
| REC-TAX-CODE Element: Tax Code | Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code. |
|
||||||||||||||||
| REC-TAX-UNIT-CST Element: Intl Cost | Signed 18.5 |
|
||||||||||||||||
| REC-TAXABLE-FLAG Element: Taxable Flag | Alpha 1 Defines if Taxable. |
|
||||||||||||||||
| REC-ORIGIN-CD Element: Origin Code | Alpha 2 System origin code |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| REC-ZERO-COST-FLG Element: Zero Cost Flg | Alpha 1 Defines if this tax record is allowed to have a zero unit cost. |
|
||||||||||||||||
| REC-CANCELLED-FL Element: All Flag | Alpha 1 |
|
||||||||||||||||
| REC-CLOSED-FL Element: Closed Fl | Alpha 1 The Closed Flag. |
|||||||||||||||||
| REC-INV-SPRD-CRET Element: Inv Sprd Cret | Numeric 1 Defines if record was created during PO invoice spread. |
|
||||||||||||||||
| REC-ISSUED-FLAG Element: All Flag | Alpha 1 |
|
||||||||||||||||
| REC-INVC-TAX-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||
| REC-ACCR-TAX-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||
| REC-EXT-TAXBL-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||
| REC-LAND-UNIT-CST Element: Intl Cost | Signed 18.5 THis would be the landed tax amount for this AOC detail. |
|
||||||||||||||||
| REC-LANDED-FLAG Element: Landed Flag | Numeric 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. |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| REC-MATCH-REF-NBR Element: Match Ref Nbr | Alpha 22 Match reference number can be used to match. Set up required. |
|
||||||||||||||||
| REC-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||||||||||||||
| REC-REC-CNV-RATE Element: Ent Cnv Rate | Signed 14.7 Currency conversion rate at Purchase Order entry time. |
|
||||||||||||||||
| REC-TOTAL-AOC-PO Element: Intl Amt | Signed 18.2 The total add-on cost amount in the Purchase Order currency. |
|||||||||||||||||
| REC-STATUS Element: Status | Numeric 1 This field displays the status of the transaction. |
|
||||||||||||||||
| REC-OPEN-TO-MATCH Element: Open To Match | Signed 13.4 This is the amount remaining open to match. |
|
||||||||||||||||
| REC-CHARGEBACK-QTY Element: Quantity | Signed 13.4 This field contains the desired quantity. |
|
||||||||||||||||
| 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. |
|
||||||||||||||||
| REC-MATCH-SEQ-NBR Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RECSET1 |
COMPANY REC-NUMBER LINE-NBR AOC-CODE |
|
|||||||||||||||||||
| RECSET2 |
COMPANY VENDOR PO-NUMBER PO-RELEASE PO-CODE LOCATION REC-NUMBER LINE-NBR AOC-CODE |
|
|||||||||||||||||||
| RECSET3 |
COMPANY PO-NUMBER PO-RELEASE PO-CODE REC-NUMBER LINE-NBR AOC-CODE VENDOR LOCATION |
|
|||||||||||||||||||
| RECSET4 |
COMPANY VENDOR MATCH-REF-NBR REC-NUMBER LINE-NBR AOC-CODE |
|
| ||||||||||||||||||
| RECSET5 |
COMPANY MATCH-OBJ-ID MATCH-SEQ-NBR REC-NUMBER LINE-NBR AOC-CODE |
|
| ||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Poreceive | PORECEIVE |
Not Required
| |||||||||
| Porecline | PORECLINE |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.