Get documents about "Contract Sales Rep
Description
Contract Sales Rep document sample
Document Sample
Dealer ID Dealer Customer ID Customer Name (Bill-To) Customer Address 1 Customer Address 2 Customer Address 3 Customer City Customer State Customer Postal or ZIP Code Customer Country Code
XDA A1223432 Physician's Immediate Care 1194 N. 123rd St. Suite A Atlanta GA 02993 USA
XDA A1223432 Physician's Immediate Care 1194 N. 123rd St. Suite A Atlanta GA 02993 USA
XDA 017728 Wal-Mart Dental Care PO Box 920-0001 Attention: Accounts Payable Tuscon AZ 19200 USA
Ship-To ID Ship-To Name Ship-To Address 1 Ship-To Address 2 Ship-To Address 3 Ship-To City Ship-To State Ship-To Postal or ZIP Code Ship-To Country Code DEA Number GLN HIN Number
017 PIC Clininc 985 Peachtree Rd Atlanta GA 00930 USA
017 PIC Clininc 985 Peachtree Rd Atlanta GA 00930 USA
AWWP Wal-Mart Dental Care #10920 Pharmacy Receiving 1440 W. Apple Ln. Suite 340 Taos NM 56473 USA 489772233
Customer Purchase Order ID Invoice ID Invoice Date Order Date Vendor ID Vendor Name Vendor ID 2 Dealer Product ID Dealer Product Description Vendor's Product ID Quantity Ordered Quantity Shipped
A102998 0129992 4/19/2005 4/18/2005 10449 Becton-Dickinson BD BD100009 Syringe, .05g LL 10cc 100009 3.0000 2.0000
A102998 0129992 4/19/2005 4/18/2005 10449 Ansell Healthcare ANSELL ANS07777A MicroTouch Nitrile PF Exam 07777-A 10.0000 10.0000
0129998 4/20/2005 3/22/2005 3ME 3M ESPE 3MESPE 1099283884 Sinfony Indirect Lab Composite B8837 200.0000 198.0000
Quantity Back Ordered Unit of Measure Unit Cost Extended Cost Unit Contract Cost Extended Contract Cost Unit Selling Price Extended Selling Price Unit Rebate Requested Extended Rebate Requested
1.0000 BX 14.5500 29.10 14.5500 29.10 18.0000 36.00 0.0000 0.00
0.0000 CA 42.0000 420.00 42.0000 420.00 52.0000 520.00 0.0000 0.00
0.0000 EA 8.2200 1627.56 7.3500 1455.30 9.7500 1930.50 0.8700 172.26
Vendor Contract ID GPO Contract ID National Drug Code UPN UNSPSC Category Sales Rep ID Sales Rep Name
AMERINET01 SKB Scott K. Bonzo
PREMIER-MSD SKB Scott K. Bonzo
019928 NOVATIONDENTAL 011-29928-01 42151123
7367728100 1435 Jimmy J. Lee
Version 1.1 - 2005-08-31 NDC Sales Trace Format Page: 6
For GPO Sales Rebate Reporting
Max Excel Required For Required For Required For Added In
Column Level Field Name Type Size Format Rebates GPO Sales NDC Incentives Description Version
A File Dealer ID A 4 Text Yes Yes Yes NDC's Distributor ID 1.0
B Invoice Dealer Customer ID A 20 Text Yes Yes Yes Bill-to Customer Number 1.0
C Invoice Customer Name (Bill-To) A 50 Text Yes Yes Yes Bill-to Customer Name 1.0
D Invoice Customer Address 1 A 50 Text Yes Yes Yes Bill-to Customer Address 1 1.0
E Invoice Customer Address 2 A 50 Text Bill-to Customer Address 2 1.0
F Invoice Customer Address 3 A 50 Text Bill-to Customer Address 3 1.0
G Invoice Customer City A 50 Text Yes Yes Yes Bill-to Customer City 1.0
H Invoice Customer State A 2 Text Yes Yes Yes Bill-to Customer State 1.0
I Invoice Customer Postal or ZIP Code A 10 Text Yes Yes Yes Bill-to Customer Zip Code 1.0
J Invoice Customer Country Code A 20 Text Bill-to Customer Country: Example: USA, CAN 1.0
Invoice Ship-To ID A 20 Text Yes Yes Yes Ship-to Customer Number (if Ship-To info is not provided, Bill-To name and
address will be used, certain rebate and GPO programs may require Ship-To
K info) 1.0
L Invoice Ship-To Name A 50 Text Yes Yes Yes Ship-to Customer Name 1.0
M Invoice Ship-To Address 1 A 50 Text Yes Yes Yes Ship-to Customer Address 1 1.0
N Invoice Ship-To Address 2 A 50 Text Ship-to Customer Address 2 1.0
O Invoice Ship-To Address 3 A 50 Text Ship-to Customer Address 3 1.0
P Invoice Ship-To City A 50 Text Yes Yes Yes Ship-to Customer City 1.0
Q Invoice Ship-To State A 2 Text Yes Yes Yes Ship-to Customer State 1.0
R Invoice Ship-To Postal or ZIP Code A 10 Text Yes Yes Yes Ship-to Customer Zip Code 1.0
S Invoice Ship-To Country Code A 20 Text Bill-to Customer Country: Example: USA, CAN 1.0
Invoice DEA Number A 9 Text Possibly Ship-To Location DEA Number (maybe required for certain vendor's rebates to
T be processed) 1.0
U Invoice GLN A 13 Text Global Location Number 1.0
V Invoice HIN Number A 11 Text 1.0
W Invoice Customer Purchase Order ID A 20 Text 1.0
X Invoice Invoice ID A 20 Text Yes Yes Yes Your invoice number 1.0
Y Invoice Invoice Date D Text Yes Yes Yes Acceptable formats are CCYY-MM-DD, MM/DD/[CC]YY and Mon DD CCYY 1.0
Invoice Order Date D Text Yes Yes Original Order Date (can be used to resolve rebate discrepancies when product
was back ordered by the vendor and the invoice date is outside the contract
dates). Acceptable formats are CCYY-MM-DD, MM/DD/[CC]YY and Mon DD
Z CCYY 1.0
AA Detail Line Item Vendor ID A 20 Text Yes Yes Yes Distributor's Vendor ID 1.0
AB Detail Line Item Vendor Name A 50 Text Yes Yes Yes Manufacturer of the Product 1.0
AC Detail Line Item Vendor ID 2 A 8 Text NDC's Vendor ID 1.0
AD Detail Line Item Dealer Product ID A 30 Text Yes Yes Yes Distributor's Product Identification 1.0
AE Detail Line Item Dealer Product Description A 60 Text Yes Yes Yes Distributor's Product Description 1.0
AF Detail Line Item Vendor's Product ID A 30 Text Yes Yes Yes Manufacturer's Product, as listed on contract 1.0
AG Detail Line Item Quantity Ordered N 11.4 Number 4 Possibly Yes May be required for certain GPO contracts that have a fill-rate commitment 1.0
AH Detail Line Item Quantity Shipped N 11.4 Number 4 Yes Yes Yes 1.0
AI Detail Line Item Quantity Back Ordered N 11.4 Number 4 Possibly May be required for certain GPO contracts that have a fill-rate commitment 1.0
AJ Detail Line Item Unit of Measure A 10 Text Yes Yes Yes Unit of measure of the product shipped to the customer 1.0
AK Detail Line Item Unit Cost N 11.4 Number 4 Yes Yes Yes Unit cost to the Distributor (prior to rebate) 1.0
AL Detail Line Item Extended Cost N 13.2 Number 2 Yes Yes Yes Unit cost times shipped quantity 1.0
AM Detail Line Item Unit Contract Cost N 11.4 Number 4 Yes Yes Unit cost as listed on contract 1.0
AN Detail Line Item Extended Contract Cost N 13.2 Number 2 Yes Yes Unit contract cost times shipped quanitity 1.0
AO Detail Line Item Unit Selling Price N 11.4 Number 4 Yes Yes Unit price to the customer 1.0
AP Detail Line Item Extended Selling Price N 13.2 Number 2 Yes Yes Extended price to customer 1.0
AQ Detail Line Item Unit Rebate Requested N 11.4 Number 4 Yes Yes Unit cost minus unit contract cost 1.0
AR Detail Line Item Extended Rebate Requested N 13.2 Number 2 Yes Yes Unit rebate time shipped quantity 1.0
C:\Docstoc\Working\pdf\62b284ff-572f-454e-8fed-332d768fc739.xls
Version 1.1 - 2005-08-31 NDC Sales Trace Format Page: 7
For GPO Sales Rebate Reporting
Max Excel Required For Required For Required For Added In
Column Level Field Name Type Size Format Rebates GPO Sales NDC Incentives Description Version
AS Detail Line Item Vendor Contract ID A 50 Text Yes Yes As assigned by NDC, required for rebate claims 1.0
AT Detail Line Item GPO Contract ID A 20 Text Yes As assigned by NDC 1.0
AU Detail Line Item National Drug Code A 11 Text 1.0
AV Detail Line Item UPN A 20 Text Universal Product Number (at the Unit of Measure sold) 1.0
AW Detail Line Item UNSPSC Category A 8 Text 1.0
AX Detail Line Item Sales Rep ID A 20 Text Yes Sales Rep ID from Distributor's System 1.1
AY Detail Line Item Sales Rep Name A 50 Text Yes Sales Rep Name 1.1
Notes:
o File can be Excel (.xls); comma-separated-value (.csv); or tab-delimited (.txt)
o If Excel format is used, please follow the "Sample Data" worksheet in the workbook, or make certain that all non-
numeric columns have a format specified as "Text". This eliminates the potential of dropping significant leading zeroes in
item numbers, ZIP codes, etc.. No extra heading lines. Make sure all numeric columns use minus sign for negatives, not
parathesis
o The records should be in invoice number order
o All columns not marked "Yes" for required should be included if possible
o Please note that the worksheet labled "Data" must remain labled as "Data" and stay intact, unchanged in order for your
transmission to be accepted by NDC via website upload.
C:\Docstoc\Working\pdf\62b284ff-572f-454e-8fed-332d768fc739.xls
