Cougar Mountain Software

PS Temporary Transaction Detail File: xxxPNTMP.DBF

Tag Index
PSPNLTYPE UPPER(PSPNRGCD) + STR(PSPNLTYPE) + STR(PSPNTRNUM) + STR(PSPNDETAIL)
PSPNTRNUM(U) UPPER(PSPNRGCD) + STR(PSPNTRNUM) + STR(PSPNDETAIL)
PSPNSTK UPPER(PSPNSTK)
PSPNBDCID UPPER(PSPNRGCD) + STR(PSPNTRNUM) + STR(PSPNBDCID)


## Desc Name Type Size Condition
1. Transaction Number PSPNTRNUM Numeric 5   R:1-99999
2. Detail Line Number PSPNDETAIL Numeric 3   R:1-999
3. Line Type
0=Deleted, 1=Non-Inventory, 2=Special Order, 3=Inventory, 4=BuyXGetX, 5=Backorder Sales (Unused), 6=Job Cost, 9=Comment Line, 11=Return of Non-Inventory, 12=Return of Special Order, 13=Return of Inventory, 15=Place on Backorder (Unused) Special Line Types: 7=ROA - Received On Account (Payment to a customer's accounts receivable.) 8=Alternate Tender, 14=Serial Number description 		PSPNLTYPE Numeric 2   R:0-99
4. Stock Item Number PSPNSTK CharCaps 20    
5. Description PSPNDES Character 45    
6. Sales Department Code PSPNCOCD CharCaps 2    
7. Salesperson Code PSPNSPCD CharCaps 3    
8. Register Code PSPNRGCD CharCaps 3    
9. Vendor PSPNVND CharCaps 20    
10. Discount Code PSPNDICD CharCaps 2    
11. Inventory Code PSPNINCD CharCaps 2    
12. Product Type PSPNINTY CharCaps 15    
13. Tax Code PSPNTXCD CharCaps 6    
14. Taxable Flag PSPNTAX Numeric 1   R:0-1
15. Promotional Code PSPNPROMO CharCaps 10    
16. Posting Status PSPNPOST Numeric 3   R:0-255
17. Transaction Date PSPNDATE Date      
18. Discount Percent PSPNDIPC Numeric 8   (3.4) R:0-100
19. Quantity Sold PSPNQTY Numeric 14   (8.4) R:+/-
20. Unit Price (before Discount) PSPNPRICE Numeric 14   (9.4) R:0->
21. Extended Unit Price (after discount) PSPNEXT Numeric 14   (9.4) R:0->
22. Total Cost (not unit cost) PSPNTCOST Numeric 14   (9.4) R:0->
23. Last Unit Cost PSPNLCOST Numeric 14   (9.4) R:0->
24. Standard Cost PSPNSTAN Numeric 14   (9.4) R:0->
25. Inventory Price 1 PSPNPRI1 Numeric 14   (9.4) R:0->
26. Promotional Price PSPNPRI2 Numeric 14   (9.4) R:0->
27. Serial Number PSPNSER CharCaps 20    
28. Ending Serial Number (unused) PSPNENDSER CharCaps 20    
29. Special Order GL Acct (unused) PSPNACCT CharCaps 30    
30. Sales Tax Amount PSPNTAXAMT Numeric 14   (9.4) R:0->
31. Level Price-before discount PSPNLEVEL Numeric 14   (9.4) R:0->
32. Stock Location PSPNSTKLOC CharCaps 20    
33. Unique ID Number - for Extra Comments PSPNUNIQID Numeric 3    
34. Printable Line Number PSPNLINENO Numeric 3   R:0-255
35. Multi-Pack Code PSPNMULTIP Character 10    
36. Buy X/Get X Unique Identifier PSPNBXGXID Character 3    
37. Buy Down/Coupon Code Unique Identifier PSPNBDCID Numeric 3    
38. Miscellaneous Charge Amount (From INMAS) PSPNMISC Numeric 14   (11.2) R:0->
39. UDF 1 PSPNUDF1 Character 30    
40. UDF 2 PSPNUDF2 Character 30    
41. UDF 3 PSPNUDF3 Numeric 15   (9.4) R:+/-
42. UDF 4 PSPNUDF4 Numeric 15   (9.4) R:+/-
43. UDF 5 PSPNUDF5 Date      
44. Base Price PSPNBASE Numeric 14   (9.4) R:0->
45. Original Price PSPNORGPRC Numeric 14   (8.4) R:+/-
46. BuyXGetX Promo Quantity Sold PSPNPRMQTY Numeric 14   (8.4) R:+/-
47. Promotional Code of Buy Stock PSPNBUYPRM Character 10    

Please let us know what info we can send you now and what are the areas that are of most important to your organization.

Please fill in below, or call us on (714) 228-5444 or fax us at (800) 531-2944...

First Name :
Last Name :
Title :
Organization :
Work Phone :
FAX :
E-mail :                                    
URL / Website:
Number of Concurrent Users:  

What info can we send you?

 

email us at sales@CougarMtnSupport.com  //  phone (714) 228-5444.

(We are not Cougar Mountain Software in Boise, we take their excellent product and make it better.   We offer software products, enhanced reports, services, training and hardware that maximize the value out of this powerful accounting program.  We have been customizing solutions for Cougar Mountain since 1990.  We are located in California.