You are here: File Descriptions > Contractors' Job Cost > ARJBxxx - AIA Schedule Detail File

# ARJBxxx - AIA Schedule Detail File

The Accounts Receivable AIA Schedule Detail file contains one record for each billing breakdown and each change order used when billing jobs through AIA. Each line is make up of the billing ID, change order number, description of what's being billed, scheduled value, amount billed, amount for the material stored, GL sales accounts, and tax class.

| Template: |
| IOLIST: | 0999 ARJBXXX: IOLIST JD0$, JD1$, JD2$, JD3$, JD[ALL], JD99$[ALL], JD99[ALL]
| Array Sizes: | DIM JD[4], JD99[1]
| String Sizes: | DIM JD0$(14), JD1$(40), JD2$(6), JD3$(12)

Key Definitions

| Key Number | Field | Description
| 0 | [1:1:14] |
| 1 | [1:1:6] + | Job ID +
|  | [3:1:6] + | Phase Interface +
|  | [1:7:6] + | Bill ID +
|  | [1:13:2] | Change Order Number
|  | __________ |
|  | 5 segments |

AIA Schedule Detail File

| File Name: | ARJBxxx | Record Size: | 126(256)
| File Type: | Mkeyed - Dynamic | Number of Keys: | 2

| Field | Field Name | Variable | Description | A/N | Length | Note
| 1(1,6) | JOB | JD0$(1,6) | Job ID | A | 6 |
| 1(7,6) | BILL | JD0$(7,6) | Bill ID | A | 6 |
| 1(13,2) | CHGNO | JD0$(13,2) | Change Order Number | A | 2 |
| 2 | DESC | JD1$ | Description | A | 40 |
| 3 | PHASE | JD2$ | Phase Interface | A | 6 |
| 4 | SACCT | JD3$ | GL Sales Account | A | 12 |
| 5 | EST | JD[0] | Estimated Billing Amount | N | 12 | 8.2-
| 6 | BILLAMT | JD[1] | Amount Billed | N | 12 | 8.2-
| 7 | MAT | JD[2] | Msterial Stored | N | 12 | 8.2-
| 8 | TXCLS | JD[3] | Tax Class | N | 1 |
| 9 | RSV1 | JD[4] | Reserved for OSD | N | 2 |
| 10 | ISVA | JD99$[0] | Reserved for ISV | A | 1 |
| 11 | ISVN[1] | JD99[0] | Reserved for ISV | N | 1 |
| 12 | ISVN[2] | JD99[1] | Reserved for ISV | N | 1 |