| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | PIKCO | Document Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | PIDCT | Document Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 3 | PIDOC | Document (Voucher Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 4 | PIAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 5 | PIANTY | Type - Address Number | Character | UDC (40 AN) | 1 | 0 | Allow NULL? |
| 6 | PII75RETY | Registration Type | String | Generic Edit | 3 | 0 | Allow NULL? |
| 7 | PII75CERC | CERC Number | String | Generic Edit | 15 | 0 | Allow NULL? |
| 8 | PID03 | Date - End of Period 03 | Date | Generic Edit | 6 | 0 | |
| 9 | PII75ECCN | Excise Control Code Number | String | Generic Edit | 15 | 0 | Allow NULL? |
| 10 | PII75ORAC | Organization Account Current Number | String | Generic Edit | 40 | 0 | Allow NULL? |
| 11 | PII75RNGE | Range | String | Generic Edit | 40 | 0 | Allow NULL? |
| 12 | PII75DVSN | Division | String | Generic Edit | 40 | 0 | Allow NULL? |
| 13 | PII75ZONE | Zone | String | Generic Edit | 40 | 0 | Allow NULL? |
| 14 | PII75REGN | Region | String | Generic Edit | 40 | 0 | Allow NULL? |
| 15 | PII75CIRC | Circle | String | Generic Edit | 40 | 0 | Allow NULL? |
| 16 | PII75COTR | Collectorate | String | Generic Edit | 40 | 0 | Allow NULL? |
| 17 | PII75CST | CST Registration Number | String | Generic Edit | 40 | 0 | Allow NULL? |
| 18 | PID02 | Date - End of Period 02 | Date | Generic Edit | 6 | 0 | |
| 19 | PII75LST | LST Registration Number | String | Generic Edit | 40 | 0 | Allow NULL? |
| 20 | PID01 | Date - End of Period 01 | Date | Generic Edit | 6 | 0 | |
| 21 | PII75SERT | Service Tax Registration Number | String | Generic Edit | 15 | 0 | Allow NULL? |
| 22 | PID04 | Date - End of Period 04 | Date | Generic Edit | 6 | 0 | |
| 23 | PII75WCT | WCT Registration Number | String | Generic Edit | 40 | 0 | Allow NULL? |
| 24 | PID05 | Date - End of Period 05 | Date | Generic Edit | 6 | 0 | |
| 25 | PII75TIN | Tax Identification Number | String | Generic Edit | 40 | 0 | Allow NULL? |
| 26 | PID06 | Date - End of Period 06 | Date | Generic Edit | 6 | 0 | |
| 27 | PIYTN1 | Tax Account Number-1 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 28 | PIYPN1 | Permanent Account Number-1 | String | Generic Edit | 40 | 0 | Allow NULL? |