Invoice Conversion/Interface
The Invoice Conversion/Interface file contains invoice detail information
that has been interfaced or converted from an external source.
UPDATED BY
MA54.1 | MA54.3 | MA540 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
MOP-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. |
|
||
MOP-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. |
|
||
MOP-EDI-NBR Element: Edi Nbr | Alpha 15 The electronic data interchange (EDI) number assigned to the vendor. |
|
||
MOP-INVOICE Element: Invoice | Alpha 22 Used to identify the invoice. |
|
||
MOP-SUFFIX Element: Suffix | Numeric 3 This is the suffix for the invoice. |
|
||
MOP-SEQ-NBR Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||
MOP-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the line number of the purchase order. |
|
||
MOP-PO-NUMBER Element: Po Number | Alpha 14 (Right Justified) This field contains the number representing the purchase order. |
|
||
MOP-PO-RELEASE Element: Po Release | Numeric 4 Used to identify a purchase order release (created from a Blanket or Standing order). |
|
||
MOP-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code. |
|
||
MOP-ITEM Element: Item | Alpha 32 This field contains the item identifier. |
|
||
MOP-VEN-ITEM Element: Item | Alpha 32 This field contains the item identifier. |
|
||
MOP-ENTERED-QTY Element: Quantity | Signed 13.4 Required. The quantity of goods being invoiced on the detail line. |
|
||
MOP-ENT-UOM Element: Uom | Alpha 4 The unit of measure the entered quantity is expressed in. If left blank, the unit of measure will default from the item/vendor definition, if it exists. If no item/vendor definition exists, the default vendor buy unit of measure will be used. The unit of measure must be valid for the item. |
|
||
MOP-UNIT-COST Element: Intl Cost | Signed 18.5 Required. The unit cost of the line item detail. |
|
||
MOP-EXTENDED-AMT Element: Extended Amount | Signed 18.2 The total value of all the items received on a given receiver. |
|
||
MOP-LOCATION Element: Location | Alpha 5 This field contains a valid stocking location within the company inventory system. Must be equal to the invoice company location. |
|
||
MOP-AOC-CODE Element: Aoc Code | Alpha 2 This field contains the identifier for the add on cost associated with this line item. |
|
||
MOP-TOTAL-AOC Element: Intl Amt | Signed 18.2 The total add on cost amount. Required if an AOC code is defined. |
|
||
MOP-RTL-UNIT-COST Element: Retail Unit Cost | Signed 18.5 The retail unit cost of the line item detail. |
|
||
MOP-ELEMENT-VAL Element: Element Value | Alpha 32 Occurs 10 Times |
|
||
MOP-DIST-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. |
|
||
MOP-ACCT-UNIT Element: Acct Unit | Alpha 15 The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. |
|
||
MOP-ACCOUNT Element: Account | Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. |
|
||
MOP-SUB-ACCT Element: Sub Acct | Numeric 4 This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. |
|
||
MOP-ACTIVITY Element: Activity | Alpha 15 Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. |
|
||
MOP-ACCT-CATEGORY Element: Acct Category | Alpha 5 Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru |
|
||
MOP-BILL-CATEGORY Element: Bill Category | Alpha 32 |
|
||
MOP-TAX-CODE Element: Tax Code | Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code. |
|
||
MOP-NO-TAX-FLAG Element: Account Flag | Alpha 1 N = No Y = Yes |
|
||
MOP-TAX-USAGE-CD Element: Tax Usage Cd | Alpha 10 The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required. |
|
||
MOP-ICN-CODE Element: Icn Code | Alpha 8 |
|
||
MOP-SUPLMNTARY-QTY Element: Quantity | Signed 13.4 This field contains the desired quantity. |
|
||
MOP-WEIGHT Element: Weight | Signed 9.3 This field contains the unit weight of the item based on the stocking UOM. |
|
||
MOP-SEGMENT-BLOCK Element: Segment Block | Alpha 103 This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information. |
|
||
MOP-PREPAY-QTY Element: Prepay Qty | Signed 13.4 |
|
||
MOP-PRPY-UNIT-CST Element: Intl Cost | Signed 18.5 |
|
||
MOP-PRPY-TAX-CODE Element: Prpy Tax Code | Alpha 10 |
|
||
MOP-PRPY-TAX-AMT Element: Intl Amt | Signed 18.2 |
|
||
MOP-PRPY-RTL-UCST Element: Intl Cost | Signed 18.5 |
|
||
MOP-PREPAY-DATE Element: Prepay Date | Numeric 8 (yyyymmdd) |
|
||
MOP-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. |
|
||
MOP-CATCH-WGT-COST Element: Intl Cost | Signed 18.5 |
|
||
MOP-COMMODITY-CODE Element: Commodity Code | Alpha 35 |
|
||
MOP-RET-PCT Element: Pct | Percent 5.2 (Percent) |
|
||
MOP-GTIN Element: Gtin | Numeric 14 |
|
||
MOP-GLBL-LINE-TYPE Element: Glbl Line Type | Alpha 15 |
|
||
MOP-COST-OPTION Element: Cost Option | Alpha 1 " " = Default from PO line 1 = Cost Required 2 = No Charge 3 = Vendor Determined |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MOPSET1 |
COMPANY VENDOR EDI-NBR INVOICE SUFFIX SEQ-NBR |
|
|
All trademarks and registered trademarks are the property of their
respective owners.