| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | WSUKID | Unique Key ID (Internal) | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 2 | WSESUNC | Estimated Unit Cost | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 3 | WSESUNB | Estimated Unit Billable | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 4 | WSESUNP | Estimated Unit Payable | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 5 | WSEPAAP | Estimated Payment Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 6 | WSAMTO | Amount - Estimated | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 7 | WSEBILL | Estimated Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 8 | WSACUNC | Actual Unit Cost | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 9 | WSACUNB | Actual Unit Billable | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 10 | WSACUNP | Actual Unit Payable | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 11 | WSAMTA | Amount - Actual | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 12 | WSTOTB | Total Billed | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | WSPAAP | Payment Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | WSCLAMT | Claim Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | WSVEND | Primary / Last Supplier Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 16 | WSPAYAB | Payable (Y/N) | Character | UDC (17 YN) | 1 | 0 | Allow NULL? |
| 17 | WSBILL | Billable (Y/N) | Character | UDC (H00 BI) | 1 | 0 | Allow NULL? |
| 18 | WSDTPAY | Date - Paid | Date | Generic Edit | 6 | 0 | |
| 19 | WSDTBIL | Date - Billed | Date | Generic Edit | 6 | 0 | |
| 20 | WSCOST | Cost Component | String | UDC (30 CA) | 3 | 0 | Allow NULL? |
| 21 | WSGLCNC | Category - G/L Non-Covered | String | UDC (41 9) | 4 | 0 | Allow NULL? |
| 22 | WSGLCCV | Category - G/L Covered | String | UDC (41 9) | 4 | 0 | Allow NULL? |
| 23 | WSENTCK | Entitlement Check | String | UDC (17 ER) | 3 | 0 | Allow NULL? |
| 24 | WSVR02 | Reference 2 | String | Generic Edit | 25 | 0 | Allow NULL? |
| 25 | WSUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | WSPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 27 | WSJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 28 | WSUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 29 | WSTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 30 | WSASN4 | Price and Adjustment Schedule-Four | String | UDC (40 AS) | 8 | 0 | Allow NULL? |
| 31 | WSASN2 | Price and Adjustment Schedule-Service | String | UDC (40 AS) | 8 | 0 | Allow NULL? |
| 32 | WSPCOVR | Percent Covered | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 33 | WSMTHPR | Method of Pricing | Character | UDC (17 MP) | 1 | 0 | Allow NULL? |
| 34 | WSSAID | Service Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 35 | WSPRODF | Product Family | String | UDC (17 PA) | 8 | 0 | Allow NULL? |
| 36 | WSPRODM | Product Model | String | UDC (17 PM) | 8 | 0 | Allow NULL? |
| 37 | WSCOVGR | Coverage Group | String | UDC (17 CG) | 8 | 0 | Allow NULL? |
| 38 | WSPMTHP | Pay Pricing Method | Character | UDC (17 MP) | 1 | 0 | Allow NULL? |
| 39 | WSPYPRT | Pay Service Provider for Parts | Character | UDC (17 YN) | 1 | 0 | Allow NULL? |
| 40 | WSCRDC | Currency Code - To | String | Generic Edit | 3 | 0 | Allow NULL? |
| 41 | WSBCRCD | Billable Currency | String | Generic Edit | 3 | 0 | Allow NULL? |
| 42 | WSBCRR | Billable Exchange Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 43 | WSBCRRM | Billable Currency Mode | Character | UDC (H00 CY) | 1 | 0 | Allow NULL? |
| 44 | WSFESUNB | Foreign Estimated Billable Unit Rate | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 45 | WSFEBILL | Foreign Estimated Billable Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 46 | WSFACUNB | Foreign Actual Billable Unit Rate | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 47 | WSFTOTB | Foreign Actual Billable Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 48 | WSPCRCD | Payable Currency | String | Generic Edit | 3 | 0 | Allow NULL? |
| 49 | WSPCRR | Payable Exchange Rate | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 50 | WSPCRRM | Payable Currency Mode | Character | UDC (H00 CY) | 1 | 0 | Allow NULL? |
| 51 | WSFESUNP | Foreign Estimated Payable Unit Rate | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 52 | WSFEPAAP | Foreign Estimated Payable Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 53 | WSFACUNP | Foreign Actual Payable Unit Rate | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 54 | WSFPAAP | Foreign Actual Payable Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 55 | WSFAILCD | Defect Code | String | UDC (17 DC) | 8 | 0 | Allow NULL? |
| 56 | WSRETPOL | Return Policy | Character | UDC (17 RT) | 1 | 0 | Allow NULL? |
| 57 | WSDTSUB | Date Submitted | Date | Generic Edit | 6 | 0 | |
| 58 | WSTMSUB | Time Submitted | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 59 | WSCSLPRT | Causal Part | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 60 | WSVMRS33 | Component Code - Part | String | UDC (17 C8) | 10 | 0 | Allow NULL? |
| 61 | WSSRVEND | Supplier Recovery Vendor Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 62 | WSRLOT | Supplier Lot Number | String | Generic Edit | 30 | 0 | Allow NULL? |
| 63 | WSMCUCSL | Causal Part Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 64 | WSTAX1 | Sales Taxable (Y/N) | Character | UDC (H00 TV) | 1 | 0 | Allow NULL? |
| 65 | WSUKIDP | Unique Key Pricing | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 66 | WSVMRS31 | Component Code - System | String | UDC (17 C6) | 2 | 0 | Allow NULL? |
| 67 | WSVMRS32 | Component Code - Assembly | String | UDC (17 C7) | 8 | 0 | Allow NULL? |
