Contract Sales Rep by lvw56778

VIEWS: 1 PAGES: 7

More Info
									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

								
To top