Col

 Field Name

Description

A

 Retailer Store ID

ID used by retailer to identify store.

B

 Supplier Store ID

ID used by supplier to identify retailer's store.

C

 Store Name

Retailer's store name.

D

 Invoice Date

Business date of the transactions invoiced.

E

 Creation Date

Date invoice was created in Park City Group.

F

 Invoice #

The invoice number or ID.

G

 Invoice Total

Product Total + Deposit Total + Service Fee Total (if applicable).

H

 Type

Invoice type code designating whether this is an original invoice or part of an update.

Valid values: Original, Original Addendum #, Replacement Addendum #, Error Reprocessed Addendum #.

If invoice is an addendum to the original, the addendum number is included.

Replacement Addendums are sent when the original invoice was incorrect.  For example, when an incorrect go-live date was set in a Store Supplier Profile.  In a Replacement Addendum, all item quantities are signed negative to zero-out the original invoice amount.

Error Reprocessed Addendums are the result of automatic sales or delivery reprocessing in Park City Group.

I

 Original Invoice #

If the invoice listed in this report is not the original, this field provides the ID of the original invoice.  

J

 Document ID

The retailer or supplier's document / ticket number associated with the invoiced transactions.

K

 Supplier

Supplier’s corporate name.

L

 Retailer

Retailer’s corporate name.

M

 ID for Supplier assigned

 by Retailer

ID used by the retailer to identify the supplier.

N

 ID for Retailer assigned

 by Supplier

ID used by the supplier to identify the retailer.

O

 Product Total

Total amount of items invoiced.

P

 Deposit Total

The net amount charged by the seller (Supplier) to the buyer (Retailer) for deposit charges on items sold in the store.  Calculated as the Debit portion of Deposits minus the Credit portion of Deposits, with rounding and extending rules applied.

If no item deposits are included in the store's transactions, this field will be blank.

Q

 Addendum Number

Sequential number automatically assigned to updated sales or deliveries.  If the invoice is based on scan-sales, this number is incremented as a result of a manually-submitted sales addendum or automatic error reprocessing.

If the invoice is based on deliveries, this number is incremented for deliveries that underwent automatic error reprocessing.

This field contains a 0 (zero) if no addendums or reprocessing occurred.

R

 Service Fee Total

Blank for most clients.  This fee can be used in place of shrink quantities for reimbursing supplier item loss.  Based on a simple percentage of total sales, fee can be configured for calculation before or after deposits are added.  "Capping" limits and other rules can also be applied.

For example, a typical service fee might be 1.5% of sales before deposits.

S

Tracking ID

This is any ID provided by the data sender to identify a batch sent to Park City Group.  Usually originating from the retailer, this is commonly used to track transactions by supplier.