MACRECLINE

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


MACRECLINE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MRLSET1 COMPANY
REFERENCE-NO
LINE-NBR
SEQ-NBR


File created: Wed Jun 08 20:50:09 2016

Home
Contact Us



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