OE/PS Sales Tax Code File: xxxPSTX.DBF
| Tag | Index |
|---|---|
| PSTXCODE2 | UPPER(PSTXCODE) + STR(PSTXLEVEL) |
| PSTXDES | UPPER(PSTXDES) + UPPER(PSTXCODE) |
| PSTXCODE(U) | UPPER(PSTXCODE) + STR(PSTXLEVEL) |
| ## | Desc | Name | Type | Size | Condition |
|---|---|---|---|---|---|
| 1.* | Sales Tax Code | PSTXCODE | CharCaps | 6 | |
| 2. | Description | PSTXDES | Character | 30 | |
| 3. | GL Account Field Length for Fund |
PSTXGLACT | CharCaps | 30 45 |
|
| 4. | Tax Percent | PSTXPERC | Numeric | 8 | (3.4) R:0-100 |
| 5. | Limit = Zero or Activation = 1 Flag | PSTXLIMF | Numeric | 1 | R:0-1 |
| 6. | Taxable Limit | PSTXLIM | Numeric | 15 | (12.2) R:0-> |
| 7. | Period End Date | PSTXDATE | Date | R:fiscal period end date | |
| 8. | Current Taxable (Unused) | PSTXCTXB | Numeric | 15 | (11.2) R:+/- |
| 9. | Current Non-Taxable (Unused) | PSTXCNON | Numeric | 15 | (11.2) R:+/- |
| 10. | Current Tax (Unused) | PSTXCTAX | Numeric | 15 | (11.2) R:+/- |
| 11. | Next Taxable (Unused) | PSTXNTXB | Numeric | 15 | (11.2) R:+/- |
| 12. | Next Non-Taxable (Unused) | PSTXNNON | Numeric | 15 | (11.2) R:+/- |
| 13. | Next Tax (Unused) | PSTXNTAX | Numeric | 15 | (11.2) R:+/- |
| 14. | YTD Taxable (Unused) | PSTXYTXB | Numeric | 15 | (11.2) R:+/- |
| 15. | YTD Non-Taxable (Unused) | PSTXYNON | Numeric | 15 | (11.2) R:+/- |
| 16. | YTD Tax (Unused) | PSTXYTAX | Numeric | 15 | (11.2) R:+/- |
| 17. | Dollar Breakdown Amount #1; (Unused) | PSTXAMT0 | Numeric | 4 | (1.2) R:0-> |
| 18. | Dollar Breakdown Amount #2; (Unused) | PSTXAMT1 | Numeric | 4 | (1.2) R:0-> |
| 19. | Dollar Breakdown Amount #3; (Unused) | PSTXAMT2 | Numeric | 4 | (1.2) R:0-> |
| 20. | Dollar Breakdown Amount #4; (Unused) | PSTXAMT3 | Numeric | 4 | (1.2) R:0-> |
| 21. | Dollar Breakdown Amount #5; (Unused) | PSTXAMT4 | Numeric | 4 | (1.2) R:0-> |
| 22. | Dollar Breakdown Amount #6; (Unused) | PSTXAMT5 | Numeric | 4 | (1.2) R:0-> |
| 23. | Dollar Breakdown Amount #7; (Unused) | PSTXAMT6 | Numeric | 4 | (1.2) R:0-> |
| 24. | Dollar Breakdown Amount #8; (Unused) | PSTXAMT7 | Numeric | 4 | (1.2) R:0-> |
| 25. | Dollar Breakdown Amount #9; (Unused) | PSTXAMT8 | Numeric | 4 | (1.2) R:0-> |
| 26. | Dollar Breakdown Amount #10; (Unused) | PSTXAMT9 | Numeric | 4 | (1.2) R:0-> |
| 27. | Vendor (Unused) | PSTXVENDOR | Character | 20 | |
| 28.* | Sales Tax Code Level | PSTXLEVEL | Numeric | 1 | R:0-9 |
| 29. | Sales Tax Code Level Description | PSTXLEVDES | Character | 30 | |
| 30.* | Uniq Field for Lookups | PSTXUNIQ | Numeric | 1 | R:0-1 |