Route4Me ERP Assets Data Reference Tables For Different Asset Types

Currencies

Central reference list of currencies (ISO code + display label) used across AR/AP, pricing, GL, and reporting.

Currency codes (e.g., `TCURC`)

Currency master (e.g., `FND_CURRENCIES*`)

Currency record (Lists → Accounting → Currencies)

Currency / TransactionCurrency

Currency master (varies by Sage product line)

Currency (Currency Management / CM)

UOM groups

UOM “dimensions/classes” that organize units (Count, Length, Mass, etc.) for consistent conversions, item setup, and analytics.

UoM catalog & dimensional grouping around `T006`

UOM class setup driving Inventory UOMs

Unit Types (UOM families)

Unit groups / unit schedule

UOM groups (varies)

Units of Measure setup (CS203500)

Units of measure

Approved UOM code list used on items and transactions; supports conversions and standardized reporting.

Units of measure (`T006`)

Inventory units of measure (`INV_UNITS_OF_MEASURE_B/TL`)

Units of Measure / Unit Types

Units / UoM

Units of measure

Inventory unit conversions (`INUnit`)

Item identifier type variants

Normalized “identifier taxonomy” (GTIN/UPC/EAN/SKU/MPN, etc.) for validation and item cross-references/barcodes.

GTIN/EAN/UPC identification (including additional GTINs)

GTIN cross-reference & item cross-reference relationships

UPC Code on item / UPC features

Item–barcode association entities

Item barcodes / identifiers (varies)

Inventory item barcodes / cross-references

Availability classes

Standard availability categories used by inventory rules (ATP exposure, reservation behavior, usable vs not usable).

Stock/availability states (unrestricted, quality, blocked, etc.)

Material/Inventory status concepts

Inventory Status feature

Inventory status

Inventory status

Availability/allocations concepts

Sourcing buckets

Where the quantity “comes from” (on hand, on order, in transit, production/WIP, returns, consignment).

Inventory + procurement buckets (stock + open PO/STO + transit + consignment)

Supply types / ATP buckets

Quantity buckets (on hand/on order/in transit/committed, etc.)

On-hand and supply/demand buckets

Quantity buckets

Quantity buckets (IN/PO dependent)

Ledger treatment

Accounting/planning treatment of quantities (physical vs logical vs planning vs derived).

Posting/statistical/planning distinctions across Inventory + FI

Posting/valuation vs planning signals

Posting vs non-posting quantity concepts

Posting vs planning quantities

Varies

Posting vs planning quantities

Movement directions

Whether a transaction increases, decreases, or is neutral to a bucket (used by rules/transaction typing).

Goods movement behavior by movement type & posting logic

Inventory transaction action (issue/receipt/transfer)

Transaction type behavior

Inventory transaction direction

Varies

Inventory transaction direction

Quantity types

Business-facing inventory buckets combining availability + sourcing + ledger treatment (On Hand, Reserved, In Transit, WIP, etc.) for ATP/MRP and reporting.

Stock categories + reservations/ATP buckets

On-hand/available/reserved/in-transit/WIP buckets

Quantity Available/Committed/On Order/In Transit

On-hand and reservation buckets

Quantity buckets

Availability/allocations buckets

Item statuses

Item lifecycle states that govern allowed transactions (Active/Inactive/Blocked/Obsolete/Draft).

Cross-plant material status (`MSTAE`)

Item Status attribute

Item “Inactive” + custom lifecycle status

Product lifecycle/state

Item status

Stock item status

Invoice statuses

AR invoice lifecycle for customer billing and collections (Draft → Approved/Open → Paid/Void).

AR/FI doc workflow + clearing status

Receivables transaction status

Invoice status (Open/Paid/Void, etc.)

Invoice state/status

Invoice status

AR invoice status

Asset types

Operational asset classification (vehicle, equipment, facility, etc.) used for fixed assets, maintenance, and reporting.

Asset classes (FI-AA)

Asset categories (`FA_CATEGORIES_B`)

Fixed Asset Type/category (Fixed Assets)

Fixed asset groups

Asset class/type

Fixed asset classes

GL entry types

Standardized “why did this entry happen?” categories (receipts, credit memos, write-offs, reversals) for AR/GL automation.

FI document types (`BLART`) / document type configuration

Journal source/category conventions

Transaction types (payment, credit memo, journal, etc.)

Voucher/journal types

Posting types

Batch/document types

GL entry statuses

Operational workflow states for posting + cash application (approval pending → posted → applied/reconciled).

Parked/posted/cleared workflow concepts

Journal batch & approval status concepts

Approval/posting states

Posting workflow states

Workflow states

Posting/release workflow states

USD

US Dollar

CAD

Canadian Dollar

EUR

Euro

COUNT

Count

LENGTH

Length

AREA

Area

VOLUME

Volume

MASS

Mass

TIME

Time

ENERGY

Energy

POWER

Power

Count (COUNT)

EA

EACH

Count (COUNT)

PC

PIECE

Count (COUNT)

SET

SET

Count (COUNT)

PK

PACK

Count (COUNT)

DOZ

DOZEN

Length (LENGTH)

MM

MILLIMETER

Length (LENGTH)

CM

CENTIMETER

Length (LENGTH)

M

METER

Length (LENGTH)

KM

KILOMETER

Length (LENGTH)

IN

INCH

Length (LENGTH)

FT

FOOT

Length (LENGTH)

YD

YARD

Length (LENGTH)

MI

MILE

Area (AREA)

MM2

SQUARE MILLIMETER

Area (AREA)

CM2

SQUARE CENTIMETER

Area (AREA)

M2

SQUARE METER

Area (AREA)

KM2

SQUARE KILOMETER

Area (AREA)

FT2

SQUARE FOOT

Area (AREA)

YD2

SQUARE YARD

Area (AREA)

ACR

ACRE

Area (AREA)

HEC

HECTARE

Volume (VOLUME)

ML

MILLILITER

Volume (VOLUME)

CL

CENTILITER

Volume (VOLUME)

L

LITER

Volume (VOLUME)

M3

CUBIC METER

Volume (VOLUME)

IN3

CUBIC INCH

Volume (VOLUME)

FT3

CUBIC FOOT

Volume (VOLUME)

GAL

GALLON (US)

Volume (VOLUME)

QT

QUART (US)

Volume (VOLUME)

PT

PINT (US)

Mass (MASS)

MG

MILLIGRAM

Mass (MASS)

G

GRAM

Mass (MASS)

KG

KILOGRAM

Mass (MASS)

T

METRIC TON

Mass (MASS)

LB

POUND

Mass (MASS)

OZ

OUNCE

Mass (MASS)

CWT

HUNDREDWEIGHT (US)

Time (TIME)

SEC

SECOND

Time (TIME)

MIN

MINUTE

Time (TIME)

HR

HOUR

Time (TIME)

DAY

DAY

Time (TIME)

WK

WEEK

Time (TIME)

MON

MONTH

Time (TIME)

YR

YEAR

Energy (ENERGY)

J

JOULE

Energy (ENERGY)

KWH

KILOWATT HOUR

Energy (ENERGY)

CAL

CALORIE

Energy (ENERGY)

BTU

BRITISH THERMAL UNIT

Power (POWER)

W

WATT

Power (POWER)

KW

KILOWATT

Power (POWER)

MW

MEGAWATT

GTIN

Global Trade Item Number

Umbrella term for globally standardized product identifiers used to uniquely identify trade items.

UPC

Universal Product Code

12-digit code primarily used in the U.S. and Canada for retail products; a GTIN subtype.

EAN

European Article Number

8- or 13-digit identifier used mainly outside North America; a GTIN subtype.

JAN

Japanese Article Number

Japan-specific variant of EAN used for retail products; a GTIN subtype.

ISBN

International Standard Book Number

Globally standardized identifier for books and similar media (ISBN-10/ISBN-13).

ITF-14

Interleaved Two of Five (14-digit GTIN)

14-digit GTIN used on logistics/shipping containers (case/pack level).

SKU

Stock Keeping Unit

Business-defined, internal alphanumeric code for inventory tracking; not globally standardized.

ASIN

Amazon Standard Identification Number

Amazon’s proprietary catalog identifier used within the Amazon ecosystem.

TCIN

Target Item Number

Target’s proprietary internal catalog/inventory identifier.

FNSKU

Fulfillment Network Stock Keeping Unit

Amazon fulfillment identifier linking stored units to a specific seller/listing.

MPN

Manufacturer Part Number

Manufacturer-assigned identifier for a specific part or component, widely used in B2B contexts.

available

Available

reserved

Reserved

unavailable

Unavailable

on_hand

On Hand

on_order

On Order

in_transit

In Transit

production

Production

returns

Returns

consigned_in

Consigned In

consigned_out

Consigned Out

physical

Physical

logical

Logical

planning

Planning

derived

Derived

increase

Increase

decrease

Decrease

neutral

Neutral

on_hand

On Hand

Lowest

Available

On Hand

Physical

Neutral

Physically present, usable stock.

reserved

Reserved

Lowest

Reserved

On Hand

Logical

Neutral

Committed to demand; excluded from ATP.

quality_hold

Quality Hold

Lowest

Unavailable

On Hand

Logical

Neutral

Stock in inspection/quarantine.

on_order

On Order

Lowest

Unavailable

On Order

Planning

Increase

Inbound supply from PO/production orders.

in_transit

In Transit

Lowest

Unavailable

In Transit

Physical

Neutral

Stock shipped but not yet received.

wip

Work in Process

Lowest

Unavailable

Production

Planning

Neutral

Inventory in production process.

returns_pending

Returns Pending

Lowest

Unavailable

Returns

Logical

Neutral

MA received but not dispositioned.

consigned_in

Consigned In

Lowest

Available

Consigned In

Logical

Neutral

Supplier-owned stock at facility.

consigned_out

Consigned Out

Lowest

Reserved

Consigned Out

Logical

Neutral

Customer-held consignment; bill on consumption.

Active

Item is active and can be used in transactions.

Inactive

Item is temporarily inactive and cannot be used in transactions.

Obsolete

Item has been retired and is no longer valid.

Draft

Item record exists but is not yet approved for use.

Blocked

Item exists but is blocked for sale or procurement.

Draft

Draft

Approved

Approved

Pending

Pending

Void

Void

Partially Paid

Partially Paid

Fully Paid

Fully Paid

Vehicle

Vehicle Asset

Assets classified as vehicles, such as cars, trucks, buses, or transport equipment.

Facility

Facility Asset

Assets classified as facilities, such as general buildings, warehouses, or operational sites.

Equipment

Equipment Asset

Machinery, manufacturing equipment, and heavy-duty tools used in operations.

IT System

IT System Asset

Computers, servers, networking equipment, and enterprise IT infrastructure.

Furniture

Furniture Asset

Desks, chairs, workstations, and other office or facility furnishings.

Tool

Tool Asset

Hand tools, power tools, and other smaller operational instruments.

Software

Software Asset

Licensed or internally developed software applications and systems.

Land

Land Asset

Parcels of land owned or leased by the organization.

Building

Building Asset

Individual buildings such as offices, plants, and other structures.

Leasehold

Leasehold Improvement

Improvements made to leased property, such as renovations or fit-outs.

Infrastructure

Infrastructure Asset

Infrastructure such as roads, utilities, pipelines, or network cabling.

Intangible

Intangible Asset

Non-physical assets such as patents, trademarks, or goodwill.

Room

Room Asset

Individual rooms within a building or facility that are managed as assets.

Yard

Yard Asset

Outdoor yard areas such as storage yards, loading zones, or managed open spaces.

Shed

Shed Asset

Smaller standalone structures such as sheds or outbuildings used for storage or operations.

AR_PAYMENT_RECEIPT

Customer payment receipt

AR_CREDIT_MEMO

Credit memo issued to customer

AR_ADJUSTMENT

Accounts receivable manual adjustment

AR_PREPAYMENT

Customer deposit received (unearned revenue)

AR_REFUND

Refund issued back to customer

AR_DEBIT_MEMO

Debit memo to increase customer balance

AR_WRITE_OFF

Write-off of uncollectible receivable

AR_SMALL_BALANCE_ADJUSTMENT

Auto-adjust small remaining balances

UNAPPLIED_CASH

Receipt recorded but not yet applied

NSF_RETURN

Returned/bounced payment (NSF)

BANK_FEE

Bank service/transaction fee

BANK_CHARGEBACK

Card chargeback received

BANK_CHARGEBACK_REVERSAL

Reversal of previously recorded chargeback

MERCHANT_PAYOUT

Processor sweep from clearing to bank

MERCHANT_FEE

Processor fee withheld from payout

FX_REALIZED_GAIN

Realized FX gain on settlement

FX_REALIZED_LOSS

Realized FX loss on settlement

FX_UNREALIZED_REVALUATION

Period-end FX revaluation of AR

ROUNDING_ADJUSTMENT

Rounding or penny adjustment

INTERCOMPANY_AR

Intercompany AR posting

OPENING_BALANCE

Conversion/opening balance load

CORRECTION

Manual correction entry

REVERSAL

System-generated reversal of a prior entry

APPROVAL_PENDING

Awaiting approval

APPROVED

Approved and ready for posting

READY_TO_POST

Validated; queued for posting

POSTING

Posting in progress

PARTIALLY_APPLIED

Part of the amount is applied to invoices

FULLY_APPLIED

Fully applied to invoices

UNAPPLIED

Not applied to any invoice

PARTIALLY_RECONCILED

Partially reconciled to bank statement

RECONCILED

Fully reconciled to bank statement

PENDING_SETTLEMENT

Settlement in progress (merchant/ACH)

SETTLED

Funds settled/cleared

DISPUTED

Dispute open (e.g., chargeback)

CHARGEBACK_OPEN

Chargeback opened by network

CHARGEBACK_WON

Chargeback resolved in our favor

CHARGEBACK_LOST

Chargeback resolved against us

REFUND_IN_PROGRESS

Refund processing initiated

REFUNDED

Refund completed

WRITE_OFF_PENDING

Write-off pending approval

WRITTEN_OFF

Amount written off

CORRECTION_POSTED

Correction successfully posted

ERROR

Error state; needs attention

CANCELLED

Cancelled before posting

ARCHIVED

Closed and archived

EXPORTED

Exported to external system

IMPORTED

IMPORTED