| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | BPCKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | BPAUBP | Australia Payment Type | Character | UDC (75A BP) | 1 | 0 | Allow NULL? |
| 3 | BPMEOT | Method Of Taxation | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 4 | BPCKDT | Date - Pay Check | Date | Generic Edit | 6 | 0 | |
| 5 | BPTARA | Tax Area (Work) | String | Generic Edit | 10 | 0 | Allow NULL? |
| 6 | BPPTAX | Tax Type | String | UDC (06 TX) | 2 | 0 | Allow NULL? |
| 7 | BPEFTB | Date - Beginning Effective | Date | Generic Edit | 6 | 0 | |
| 8 | BPEFTE | Date - Ending Effective | Date | Generic Edit | 6 | 0 | |
| 9 | BPAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 10 | BPHMCO | Company - Home | String | Generic Edit | 5 | 0 | Allow NULL? |
| 11 | BPTAXX | Tax Identification Number | String | Generic Edit | 20 | 0 | Allow NULL? |
| 12 | BPPCCD | Pay Cycle Code | String | UDC (06 PY) | 5 | 0 | Allow NULL? |
| 13 | BPPFRQ | Pay Frequency | Character | UDC (06 PF) | 1 | 0 | Allow NULL? |
| 14 | BPATA | Amount To Allocate | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | BPAPGP | Amount Previous Gross Paid | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 16 | BPAPTP | Amount Previous Tax Paid | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 17 | BPOPNW | Override Period Normal Wages | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 18 | BPDPNW | Derived Period Normal Wages | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 19 | BPPNTX | Period Normal Tax | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 20 | BPACGW | Amount Combined Gross Wages | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 21 | BPACTAX | Amount Combined Taxes | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 22 | BPAUNP | Australia Number Of Periods | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 23 | BPANTP | Amount New Tax Paid | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 24 | BPUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 25 | BPPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | BPJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 27 | BPUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 28 | BPUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |