| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | QBCO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | QBDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 3 | QBKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 4 | QBDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 5 | QBSFX | Document Pay Item | String | Generic Edit | 3 | 0 | Allow NULL? |
| 6 | QBAN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 7 | QBTAXC | Person/Corporation Code | Character | UDC (H00 TA) | 1 | 0 | Allow NULL? |
| 8 | QBPYE | Payee Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 9 | QBDGJ | Date - For G/L (and Voucher) - Julian | Date | Generic Edit | 6 | 0 | |
| 10 | QBVINV | Supplier Invoice Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 11 | QBI75ORST | Origin State | String | UDC (00 S) | 3 | 0 | Allow NULL? |
| 12 | QBAG | Amount - Gross | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | QBAA | Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | QBYTXB | TDS Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | QBYTXS | TDS Surcharge | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 16 | QBYTYP | TDS Type | Character | UDC (75I TY) | 1 | 0 | Allow NULL? |
| 17 | QBI75WCTY | Work Contract Tax Type | Character | UDC (75I TY) | 1 | 0 | Allow NULL? |
| 18 | QBYERT | Rate Effective % | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 19 | QBI75TDSR | TDS Rate | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 20 | QBI75TSUR | Surcharge Rate | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 21 | QBYGRP | TDS Group | Character | UDC (75I TG) | 1 | 0 | Allow NULL? |
| 22 | QBADT | Date - Adjustment | Date | Generic Edit | 6 | 0 | |
| 23 | QBADTJ | Date - Applied | Date | Generic Edit | 6 | 0 | |
| 24 | QBCPDT | Date - Current Position | Date | Generic Edit | 6 | 0 | |
| 25 | QBBAN8 | Address Number - Beneficiary | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 26 | QBYGCA | Gross Contract Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 27 | QBYSNM | Receipt Number | String | Generic Edit | 40 | 0 | Allow NULL? |
| 28 | QBYAOC | Assessing Certificate Number | String | Generic Edit | 40 | 0 | Allow NULL? |
| 29 | QBYDSD | Date Submit NIL Declaration | Date | Generic Edit | 6 | 0 | |
| 30 | QBYDFD | Date Foward Declaration to Commision | Date | Generic Edit | 6 | 0 | |
| 31 | QBYJIF | JDS/TDS Interface Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 32 | QBIRSO | Taxable Amount Subject to W/T | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 33 | QBFADT | Amount - Additional Federal Tax | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 34 | QBATTL | Professional Title | String | Generic Edit | 40 | 0 | Allow NULL? |
| 35 | QBUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 36 | QBPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 37 | QBJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 38 | QBUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 39 | QBUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 40 | QBTORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 41 | QBCHGF | Change Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 42 | QBI75CERA | Cess Rate | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 43 | QBI75CEAM | Cess Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 44 | QBI75PRSU | Processing Surchange Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 45 | QBAPAOW | Paid - Unit Cost | String | Generic Edit | 15 | 0 | Allow NULL? |
| 46 | QBCKCS | Spending Account Claim Number | String | Generic Edit | 15 | 0 | Allow NULL? |
| 47 | QBAAMF | Automatic Acct Instructions Merge Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 48 | QBSFXE | Pay Item Extension Number | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 49 | QBPST | Pay Status Code | Character | UDC (00 PS) | 1 | 0 | Allow NULL? |
| 50 | QBPYST | Pay Status Code | Character | UDC | 1 | 0 | Allow NULL? |
| 51 | QBGLC | G/L Offset | String | Generic Edit | 4 | 0 | Allow NULL? |
| 52 | QBTAWH | Tax Authority for A/P Withholding | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 53 | QBSFXM | Document Pay Item - Matching(Pmt/Item) | String | Generic Edit | 3 | 0 | Allow NULL? |
| 54 | QBSFXO | Order Suffix | String | Generic Edit | 3 | 0 | Allow NULL? |
| 55 | QBACR | Amount - Currency | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 56 | QBACRF | Amount - Currency - Offset Accting Distr | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 57 | QBDDJ | Date - Net Due | Date | Generic Edit | 6 | 0 | |
| 58 | QBFY | Fiscal Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 59 | QBCTRY | Century | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 60 | QBI75CHNO | Challan No | String | Generic Edit | 60 | 0 | Allow NULL? |
| 61 | QBI75CHDT | Challan Date | Date | Generic Edit | 6 | 0 | |
| 62 | QBI75CENO | Certificate Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 63 | QBI75PRTD | Processing TDS Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |