| SEQUENCENO |
Long |
|
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| CNTBTCH |
BCD*5.0 |
Batch |
|
| LINENO |
Integer |
Line Number |
|
| CHECKNUM |
BCD*5.0 |
Check Number |
|
| FISCALYEAR |
String*4 |
Fiscal Year |
Mask: %04D |
| FISCALPER |
Integer |
Fiscal Period |
List: 13 entries
| 1 | = | 1 | | 2 | = | 2 | | 3 | = | 3 | | 4 | = | 4 | | 5 | = | 5 | | 6 | = | 6 | | 7 | = | 7 | | 8 | = | 8 | | 9 | = | 9 | | 10 | = | 10 | | 11 | = | 11 | | 12 | = | 12 | | 13 | = | 13 |
|
| JOURNLDATE |
Date |
G/L Journal Date |
|
| TRANSDATE |
Date |
Transaction Date |
|
| CURRENCY |
String*3 |
Currency |
Mask: %-3N |
| EXCHRATE |
BCD*8.7 |
Exchange Rate |
|
| RATETYPE |
String*2 |
Rate Type |
Mask: %-2N |
| RATEDATE |
Date |
Rate Date |
|
| RATEOP |
Integer |
Rate Operator |
List: 2 entries
|
| CONTRACT |
String*16 |
Contract |
Mask: %-16C |
| PROJECT |
String*16 |
Project |
Mask: %-16N |
| CATEGORY |
String*16 |
Category |
Mask: %-16N |
| EMPLOYEE |
String*24 |
Employee |
|
| DOCTYPE |
Integer |
Document Type |
List: 2 entries
| 1 | = | System Check | | 2 | = | Manual Check |
|
| TRANSTYPE |
Integer |
Transaction Type |
List: 2 entries
|
| TRANSNUM |
Long |
PJC Transaction Number |
|
| EARNINGS |
String*6 |
Earnings or Deduction Code |
|
| QUANTITY |
BCD*10.5 |
Quantity |
|
| HOURS |
BCD*4.3 |
Hours |
|
| BASE |
BCD*10.3 |
Base |
|
| UNITRATE |
BCD*9.5 |
Unit Rate |
|
| PERCENT |
BCD*9.5 |
Percent |
|
| EXTAMTHM |
BCD*10.3 |
Extended Amount (HM) |
|
| EXTAMTSR |
BCD*10.3 |
Extended Amount (SR) |
|
| BILLRATE |
BCD*10.6 |
Billing Rate |
|
| BILLTYPE |
Integer |
Billing Type |
List: 4 entries
| 0 | = | None | | 2 | = | Billable | | 3 | = | No Charge | | 1 | = | Non-billable |
|
| WIPACCT |
String*45 |
WIP Account |
Mask: %-45C |
| TRANACCT |
String*45 |
Transaction Account |
Mask: %-45C |
| OHACCT |
String*45 |
Overhead Account |
Mask: %-45C |
| OHAMTSR |
BCD*10.3 |
Overhead Amount |
|
| OHAMTHM |
BCD*10.3 |
Overhead Amount |
|
| LABACCT |
String*45 |
Labor Account |
Mask: %-45C |
| LABORSR |
BCD*10.3 |
Labor Amount |
|
| LABORHM |
BCD*10.3 |
Labor Amount |
|
| ARITEM |
String*16 |
A/R Item Number |
Mask: %-16C |
| ARUOM |
String*10 |
A/R Unit of Measure |
Mask: %-10C |
| OVERHD |
Integer |
Overhead Type |
List: 3 entries
| 1 | = | None | | 2 | = | Flat Rate Per Unit | | 5 | = | Percentage of Cost |
|
| OHEADRATE |
BCD*10.6 |
Overhead Rate |
|
| HEADPER |
BCD*5.5 |
Overhead Percentage |
|
| LABOR |
Integer |
Labor Type |
List: 3 entries
| 1 | = | None | | 2 | = | Flat Rate Per Labor Hour/Unit | | 3 | = | Percentage of Labor Cost |
|
| LABORRATE |
BCD*10.6 |
Labor Rate |
|
| LABORPER |
BCD*5.5 |
Labor Percentage |
|
| DRILLSRCTY |
Integer |
Drill Down Type |
|
| DRILLDWNLK |
BCD*10.0 |
Drill Down Link |
|
| DRILLAPP |
String*2 |
Drill Down Application |
|
| PROJSTAT |
Integer |
Project Status |
List: 7 entries
| 10 | = | Estimate | | 20 | = | Approved | | 30 | = | Open | | 40 | = | On Hold | | 70 | = | Inactive | | 60 | = | Completed | | 50 | = | Closed |
|
| DIFF |
Integer |
Differential Record? |
|
| EXPENSEREI |
Integer |
Exp. Reimbursement? |
|
| RESOURCE |
String*24 |
Resource |
|
|