Return Details

Column Headings defined as follows:

Year: Year
Period: Month (ex. January = 1 and the number progresses for each month)
Credit Memo Id: Generated by Ingram when return is processed.
Credit Memo Date: Date the credit memo is generated.
Bill To: Billing account number.
Ship To: Shipping account number assigned to a shipping location.
HQ BP ID: Headquarter, business partner ID.
BA BP ID: Billing account, business partner ID.
SL BP ID: Shipping location, business partner ID.
SL State CD: Shipping location state or province.
SL Country CD: Shipping location country code.
Class of Trade CD: Class of Trade Code – Examples:
AU Author
BC Book Club
CA Catalog and Direct Response
CD Canadian RDC
CG Canadian Retail Internet Gold
CL Canadian Library
CM Canadian Merchandising Wholesaler
CO Corporate Account
CT Canadian Trade
CW Canadian Wholesaler
DM Display Marketer
GT Gift Retailer
HE Higher Education
I0 International 40-120
I1 International 45-120
I2 International 50-120
I3 International 55-120
I4 International 60-120
I5 International 65-120
I6 International 70-120
I7 International 55-30
I8 International 55-150
I9 International 60-150
ID International RDC
IN International Other
IR Independent Regional Distribution Center
IW International Wholesaler
LB Library
LR Lawn and Garden Retailer
LW Lawn and Garden Wholesaler
MI Ministry
MW Merchandising Wholesaler
NR Other
R9 Retail 90
RC Retail Internet
RD Retail Distribution Center
RG Retail Internet Gold
RM Retail Mass Merchant
RO Retail Other (museums, drugstores, gift shops, etc.)
RS Retail Specialty Store
RT Retail Trade Bookstore
SD Specialty Distribution Center
SW Specialty Wholesaler
WH Wholesaler
IPS Return: Y=Yes and N=No.
Pub #: Publisher number at Ingram.
EAN: 13 digit code used to identify the product (ISBN).
Item Name: Name of the item, most likely the title.
Return Credit: Y=Yes and N=No.
Quantity Sign: 
Adjustment Type Code:
S Sales Adjustment
R Returns Adjustment
N Not an Adjustment
Consignment Flag: Consignment = C
Rtn Unit Count: Return Unit Count – The number of units returned.
Rtn Item Disc Amt Ext: Return Item Discount Amount Extended - The discount per item amount multiplied by the number of units returned.
Unit Price: Price of an individual unit.
Customer Pickup: Y=Yes, N=No.
IPS Pub Acct: Indicates if it is an ‘Ingram Publisher Services’ publisher account. Y=Yes and N=No.