POS Mapping

Prev Next

POS-to-GL account mappings for sales categories, payment types, jobs, and paid-outs, with one row per mapping.

Before querying this table, complete Snowflake Data Share setup. See Snowflake Data Share Setup for step-by-step instructions.

Column reference

Column

Type

Description

tenant_id

NUMBER(38,0)

Customer's account identifier within the R365 platform.

legal_entity_id

VARCHAR

Job mappings only: identifier of the legal entity that the location belongs to. Blank for other mapping types.

legal_entity_name

VARCHAR

Job mappings only: name of the legal entity that the location belongs to. Blank for other mapping types.

location_id

VARCHAR

Job mappings only: identifier of the location the mapping is set up for. Blank for other mapping types, which are not set per location.

location_name

VARCHAR

Job mappings only: name of the location the mapping is set up for. Blank for other mapping types.

location_number

VARCHAR

Job mappings only: number of the location the mapping is set up for. Blank for other mapping types.

mapping_type

VARCHAR

What the mapping is for: SALES_ACCOUNT, PAYMENT_TYPE, JOB or PAID_OUT.

id

VARCHAR

Unique identifier of the mapping. Unique within tenant_id and mapping_type.

name

VARCHAR

Name of the mapping as set up in R365.

gl_account_id

VARCHAR

Identifier of the GL account the item is mapped to. Blank when no account is assigned.

gl_account_name

VARCHAR

Name of the mapped GL account. Blank when no account is assigned or the account was deleted.

gl_account_number

VARCHAR

Number of the mapped GL account. Blank when no account is assigned or the account was deleted.

gl_account_type

VARCHAR

Type of the mapped GL account (for example, Expense). Blank when the type cannot be determined.

modified_on

TIMESTAMP_NTZ

Date and time the mapping was last changed. Blank on a few records that have no change time.

is_deleted

BOOLEAN

True if the mapping was deleted. Deleted mappings are kept in the table.

service_type

VARCHAR

Sales account mappings only: name of the service type (order type) set up in R365 that the mapping applies to. Blank for other mapping types.

category_id

VARCHAR

Sales account mappings only: identifier of the sales category. Blank for other mapping types.

category_name

VARCHAR

Sales account mappings only: name of the sales category. Blank for other mapping types.

sales_account_type

VARCHAR

Sales account mappings only: the kind of sales line: Standard, Tax, Catering Item, Cash Refund, House Account Payment, Catering Deposit, Gift Card or Tip. Blank when the kind is not recognized.

is_exception

BOOLEAN

Payment type mappings only: true if the payment type is flagged as an exception type. Blank for other mapping types.

exception_comment

VARCHAR

Payment type mappings only: the comment entered for an exception payment type. Blank for other mapping types.

payment_group

VARCHAR

Payment type mappings only: the group the payment type belongs to: Cash, Credit Card - Individual, Credit Card - Combined, Gift Card, House Account, Catering Receivable, Third Party Delivery, P.I.A., Comp, Coupon, Discount, Void or Noncashtips. Blank when the group is not recognized.

job_code

VARCHAR

Job mappings only: the job code from the POS system.

department

VARCHAR

Job mappings only: name of the department the job is linked to. If the job is linked to more than one active department, the one with the lowest ID is shown. Blank when no active department applies.

legal_entity_number

VARCHAR

Job mappings only: number of the legal entity that the location belongs to. Blank for other mapping types.

exclude_from_pos_import

BOOLEAN

Paid-out mappings only: true if paid-outs of this type are left out of the POS import. Blank for other mapping types.