You are here: File Descriptions > Contractors' Job Cost > ARJCxxx - AIA Invoice Transaction Header

# ARJCxxx - AIA Invoice Transaction Header

The Accounts Receivable AIA Invoice Transaction file stores the current AIA invoice billing information until it is posted if the invoice is not on hold. The detail record contains the job ID, billing ID, and change order number (if any) for the detail and the amounts being billed for current work completed and stored materials. The header record stores the job ID, invoice number, billing period, final billing flag, invoice on hold flag, and retainage information.

| Template: |
| IOLIST: | 0999 ARJCXXX: IOLIST JE0$, JE1$, JE2$, JE3$, JE4$, JE[ALL], JE99$[ALL], JE99[ALL]
| Array Sizes: | DIM JE[3], JE99[1]
| String Sizes: | DIM JE0$(14), JE1$(8), JE2$(30), JE3$(3), JE4$(6)

Key Definitions

| Key Number | Field | Description
| 0 | [1:1:6] + | Job ID +
|  | [1:7:8] | Bill ID + Change Order Number
| 1 | [5:3:4] + | GL Year +
|  | [5:1:2] + | GL Period +
|  | [1:1:6] + | Job ID +
|  | [1:7:8] | Bill ID + Change Order Number
|  | __________ |
|  | 6 segments |

AIA Invoice Transaction Detail

| File Name: | ARJCxxx | Record Size: | 100(128)
| File Type: | Mkeyed - Dynamic | Number of Keys: | 2

| Field | Field Name | Variable | Description | A/N | Length | Note
| 1(1,6) | JOBID | JE0$(1,6) | Job ID | A | 6 |
| 1(7,8) | BICORDNUM | JE0$(7,8) | Bill ID + Change Order Number | A | 8 |
| 2 | RSV | JE1$ | Reserved | A | 8 |
| 3 | RSV1 | JE2$ | Reserved | A | 30 |
| 4 | RSV2 | JE3$ | Reserved | A | 3 |
| 5 | RSV3 | JE4$ | Reserved | A | 6 |
| 6 | WCOMP | JE[0] | Work Completed | N | 11 |
| 7 | MATSTORE | JE[1] | Material Stored Amount | N | 11 |
| 8 | RSV4 | JE[2] | Reserved | N | 1 |
| 9 | RSV5 | JE[3] | Reserved | N | 1 |
| 10 | ISVA | JE99$[0] | Reserved for ISV | A | 1 |
| 11 | ISVN[1] | JE99[0] | Reserved for ISV | N | 1 |
| 12 | ISVN[2] | JE99[1] | Reserved for ISV | N | 1 |