Seq

Col

Field Name

Description

1

A

 Data Type

The type of item movement being invoiced.

CNTINV for Count (Shrink) Invoices.

2

B

 Supplier Name

Supplier's corporate name.

3

C

 Supplier ID

Supplier's Park City Group Business Unit ID (BU ID).

4

D

 Retailer Invoice ID for

 Supplier

ID used by retailer to reference supplier in invoices. 

This can be set up in the Store Supplier Profile, or it can be defaulted based on the Service Agreement established for the trading partnership.

5

E

 Supplier DUNS

Supplier's 9-digit DUNS (Dun & Bradstreet assigned) number.

6

F

 Supplier DUNS Suffix

The 4 digits of a supplier's DUNS +4.  This is a suffix to the supplier's 9-digit DUNS.

7

G

 Supplier Address 1

First line of supplier's street address.

8

H

 Supplier Address 2

Second line of supplier's street address.

9

I

 Supplier City

City associated with supplier's street address.

10

J

 Supplier State

State associated with supplier's street address.

11

K

 Supplier Zip

ZIP or other postal code associated with supplier's street address.

12

L

 Retailer Name

Retailer's corporate name.

13

M

 Retailer ID

Retailer's Park City Group Business Unit ID (BU ID).

14

N

 Supplier Invoice ID for

 Retailer

ID used by supplier to reference retailer.

15

O

 Retailer DUNS

Retailer's 9-digit DUNS (Dun & Bradstreet assigned) number.

16

P

 Retailer DUNS Suffix

The 4 digits of a retailer's DUNS +4.  This is a suffix to the retailer's 9-digit DUNS.

17

Q

 Retailer Address 1

First line of retailer's street address.

18

R

 Retailer Address 2

Second line of retailer's street address.

19

S

 Retailer City

City associated with retailer's street address.

20

T

 Retailer State

State associated with retailer's street address.

21

U

 Retailer Zip

ZIP or other postal code associated with retailer's street address.

22

V

 Store ID

Park City Group internal ID used to reference store.

23

W

 Store Name

Retailer's name for the store.

24

X

 Retailer Store ID

ID used by retailer to reference the store.

25

Y

 Supplier Store ID

ID used by supplier to reference the store.

26

Z

 Store Address 1

First line of stores street address.

27

AA

 Store Address 2

Second line of stores street address.

28

AB

 Store City

City associated with stores street address.

29

AC

 Store State

State associated with stores street address.

30

AD

 Store Zip

ZIP or other postal code associated with stores street address.

31

AE

 Warehouse ID

The retailer's ID for the warehouse or distribution center to which the sales / delivery store is assigned.  Empty if no warehouse assignment

32

AF

 Invoice ID

The invoice number or ID.  If this is an original invoice, it is the same as the Original Invoice Number.  If this is a replacement or reversal invoice, this number will be different from the original.

33

AG

 Invoice Date

The date of the invoice in 8-character calendar-date format YYYYMMDD.

34

AH

 Julian Invoice Date

The date of the invoice in 7-character Julian-date format YYYYDDD.

35

AI

 Invoice Type

Code designating whether this is an original invoice or part of an update.

Will always be Original for count (shrink) invoices.

36

AJ

 Original Invoice ID

The ID of the original invoice. 

37

AK

 Source

Why the invoice was generated.  For example:

• Shrink Invoice For Supplier

• Shrink Invoice For Retailer

38

AL

 Invoice Total

Total net amount due.

39

AM

 Shrink Terms

Terms in place to divide shrink costs between trading partners.

Most shrink division is based on a simple % split.

• For example “Retailer covers 50.00 % of total store level shrink without cap."

If shrink totals $100.00, the retailer pays $50.00 and the supplier absorbs $50.00.  There is no limit to the retailer’s share.

However, specialized shrink terns can be set to limit or cap a partner's responsibility.

• For example "Retailer covers 50.00 % of total store-level shrink with a cap of 1000.00."  

If the shrink totals $2,000, the retailer only pays 50% of $1,000, with the remaining $1,500 being the responsibility of the supplier.

• A more complex example is "Retailer covers 50% of total store-level shrink with a cap of 3%.  If cap is reached, retailer will cover 1.25% of total shrink."

In this example, if shrink is at or below 3% of the total items, the retailer pays 50%.  However, if shrink is greater than 3%, retailer will only pay 1.25%.  

40

AN

 Segment

Item Basis Code or other client-specific information.(Empty for most clients.)

41

AO

 Item Nbr / Group Code

Supplier's item order number or item group in Park City Group.

42

AU

 Item Description

Supplier's description or name of the item.

43

AQ

 UPC Type

Format of the product code.

Value       Description

UABC...... UPCA 10 digits in format 0-5-5-0

UAUI........ UPCA 11 digits in format 1-5-5-0

UAUA...... UPCA 12 digits in format 2-5-5-0

UAUP...... UPCA 12 digits in format 1-5-5-1

UACD...... UPCA 11 digits in format 0-5-5-1

UAAD...... UPCA 13 digits in format 2-5-5-1

UA3D....... UPCA 14 digits in format 3-5-5-1

UA30....... UPCA 13 digits in format 3-5-5-0

UAZS....... UPCA 6 digits zero suppressed

EAUA...... EAN 12 digits in format 2-5-5-0

EAAD...... EAN 13 digits in format 2-5-5-1

GT3D....... GTIN 14 digits in format 3-5-5-1

ZZ         Private Product Code up to 15 characters.

44

AR

 UPC

UPC or other product code. 

45

AS

 SKU

If available, the retailer's stock keeping unit (SKU) assigned to the item.

46

AT

 Qty

The number of units counted.

47

AU

 Extended Cost

The (Qty x Net Cost) + (Qty x Deposit).

48

AV

 Shared Cost

Invoice recipient’s share of shrink.

Available only when shrink-sharing rule is based on flat percentages.  (No specialized Shrink Terms are in place.)

For example, supplier pays 50%, retailer pays 50%.