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. |