MACRECLINE

UPDATED BY
MA53.1 MA53.5 MA531

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MRL-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.
MA53.1 MA531
MRL-REFERENCE-NO
Element: Reference No
Alpha 10 (Right Justified)
MA53.1 MA531
MRL-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
MA53.1 MA531
MRL-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
MA53.1
MRL-REC-NUMBER
Element: Rec Number
Numeric 10
The receiver number. Assigned when this receiving information was added.
MA531
MRL-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
MA53.1 MA531
MRL-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
MA53.1 MA531
MRL-ITEM-TYPE
Element: Item Type
Alpha 1
This field identifies the line item type.
MA53.1 MA531
MRL-VEN-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
MA53.1 MA531
MRL-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
MA53.1 MA531
MRL-ENT-REC-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
MA53.1 MA531
MRL-ENT-REC-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
MA53.1 MA531
MRL-ENT-RUOM-MULT
Element: Uom Mult
Signed 13.7
This field contains the multiplier for converting this unit of measure to the stock unit of measure.
MA531
MRL-CATCH-WT-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
MA53.1 MA531
MRL-ORIG-UNIT-CST
Element: Intl Cost
Signed 18.5
MA53.1 MA531
MRL-BIN
Element: Bin
Alpha 7
This field contains a storage area for an item or any number of items.
MA531
MRL-CANCEL-BO-FL
Element: All Flag
Alpha 1
MA53.1 MA531
MRL-REC-COMMENTS
Element: Ers Comments
Alpha 100 (Lower Case)
MA53.1
MRL-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction.
MA53.1 MA531
MRL-UPDATE-DATE
Element: Update Date
Numeric 8 (yyyymmdd)
This field contains the date the record was updated.
MA53.1 MA531
MRL-UPDATE-TIME
Element: Update Time
Numeric 6
This field contains the system time when the record was updated.
MA53.1 MA531
MRL-ELEMENT-01
Element: Element 01
Alpha 32
MA53.1 MA531
MRL-ELEMENT-02
Element: Element 01
Alpha 32
MA53.1 MA531
MRL-ELEMENT-03
Element: Element 01
Alpha 32
MA53.1 MA531
MRL-ELEMENT-04
Element: Element 01
Alpha 32
MA53.1 MA531
MRL-ELEMENT-05
Element: Element 01
Alpha 32
MA53.1 MA531
MRL-ELEMENT-06
Element: Element 01
Alpha 32
MA53.1 MA531
MRL-ELEMENT-07
Element: Element 01
Alpha 32
MA53.1 MA531
MRL-ELEMENT-08
Element: Element 01
Alpha 32
MA53.1 MA531
MRL-ELEMENT-09
Element: Element 01
Alpha 32
MA53.1 MA531
MRL-ELEMENT-10
Element: Element 01
Alpha 32
MA53.1 MA531
MRL-VPRI-QUANTITY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
MA531
MRL-VPRI-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
MA53.1 MA531
MRL-VPRI-UOM-MULT
Element: Uom Mult
Signed 13.7
This field contains the multiplier for converting this unit of measure to the stock unit of measure.
MA53.1 MA531
MRL-BUOM-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
MA531
MRL-VBUY-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
MA531
MRL-VBUY-UOM-MULT
Element: Uom Mult
Signed 13.7
This field contains the multiplier for converting this unit of measure to the stock unit of measure.
MA531
MRL-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
MA53.1 MA531
MRL-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.
MA53.1 MA531
MRL-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.
MA53.1 MA531
MRL-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.
MA53.1 MA531
MRL-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.
MA53.1 MA531
MRL-MSDS-FLAG
Element: All Flag
Alpha 1
MA53.1 MA531
MRL-MSDS-VERSION
Element: Msds Version
Alpha 4
The version number of the most recent MSDS that was received.
MA53.1 MA531
MRL-MSDS-DOCUMENT
Element: Msds Document
Alpha 30
The document number from the most recent MSDS that was received.
MA53.1 MA531
MRL-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.
MA53.1 MA531
MRL-CATCH-WGT-COST
Element: Intl Cost
Signed 18.5
MRL-TAX-UNIT-CST
Element: Intl Cost
Signed 18.5
MRL-INSP-REQ-FL
Element: All Flag
Alpha 1
MA53.1
MRL-COMMODITY-CODE
Element: Commodity Code
Alpha 35
MA53.1
MRL-PROD-TAX-CAT
Element: Prod Tax Cat
Alpha 15
MA531
MRL-GTIN
Element: Gtin
Numeric 14
MA53.1


MACRECLINE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MRLSET1 COMPANY
REFERENCE-NO
LINE-NBR
SEQ-NBR
MA53.1 MA53.5
MA531


File created: Thu Jun 09 11:20:19 2016

Home
Contact Us



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