| DAYENDSEQ |
Long |
Day End Sequence |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| DAYENDDATE |
Date |
Day End Date |
|
| DOCTYPE |
Integer |
Document Type |
List: 8 entries
| 1 | = | Purchase Order | | 2 | = | Receipt | | 3 | = | Return | | 4 | = | Invoice | | 5 | = | Credit Note | | 6 | = | Debit Note | | 7 | = | Committed Receipt | | 9 | = | Committed Invoice |
|
| TRANSTYPE |
Integer |
Transaction Type |
List: 4 entries
| 1 | = | Posted | | 2 | = | Cost Adjustment | | 3 | = | Commitment Update | | 4 | = | Billing Adjustment |
|
| ADDCOST |
Integer |
Additional Cost Type |
List: 4 entries
| 0 | = | None (Item) | | 1 | = | Prorated | | 2 | = | Prorated Manually | | 3 | = | Expensed |
|
| MULTIFROM |
Integer |
From Multiple Documents |
List: 2 entries
|
| FROMDOC |
String*22 |
From Document Number |
|
| FRMDOCTYPE |
Integer |
From Document Type |
List: 5 entries
| 8 | = | Requisition | | 1 | = | Purchase Order | | 2 | = | Receipt | | 3 | = | Return | | 4 | = | Invoice |
|
| SEQUENCENO |
BCD*10.0 |
Sequence Key |
|
| LINENO |
BCD*10.0 |
Line Number |
|
| COSTLINENO |
BCD*10.0 |
Additional Cost Line Number |
|
| DOCNUM |
String*24 |
Document Number |
Mask: %-22C |
| 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 |
|
| REFERENCE |
String*60 |
Reference |
|
| DESC |
String*60 |
Description |
|
| VENDORID |
String*12 |
Vendor Number |
Mask: %-12C |
| TRANSDATE |
Date |
Transaction Date |
|
| CURRENCY |
String*3 |
Currency Code |
Mask: %-3N |
| RATETYPE |
String*2 |
Rate Type |
Mask: %-2N |
| RATEDATE |
Date |
Rate Date |
|
| RATEOP |
Integer |
Rate Operator |
List: 2 entries
|
| RATE |
BCD*8.7 |
Rate |
|
| CONTRACT |
String*16 |
Contract |
Mask: %-16C |
| PROJECT |
String*16 |
Project |
Mask: %-16N |
| CATEGORY |
String*16 |
Category |
Mask: %-16N |
| RESOURCE |
String*24 |
Resource |
Mask: %-24C |
| ARITEM |
String*16 |
A/R Item Number |
Mask: %-16C |
| ARUOM |
String*10 |
A/R Unit of Measure |
Mask: %-10C |
| ITEMNO |
String*24 |
Item Number |
|
| LOCATION |
String*6 |
Location |
Mask: %-6N |
| QUANTITY |
BCD*10.5 |
Quantity |
|
| UNIT |
String*10 |
Unit Of Measure |
Mask: %-10c |
| CONVERSION |
BCD*10.6 |
Conversion |
|
| UNITCOSTSR |
BCD*10.6 |
Unit Cost (source) |
|
| UNITCOSTHM |
BCD*10.6 |
Unit Cost (functional) |
|
| DISCOUNTSR |
BCD*10.6 |
Discount Amount in source curren |
|
| DISCOUNTHM |
BCD*10.6 |
Discount Amount in functional cu |
|
| ALLOTAXSR |
BCD*10.3 |
Allocated Tax (source) |
|
| ALLOTAXHM |
BCD*10.3 |
Allocated Tax (functional) |
|
| EXPTAXSR |
BCD*10.3 |
Expensed Tax (source) |
|
| EXPTAXHM |
BCD*10.3 |
Expensed Tax (functional) |
|
| RTAXAMTSR |
BCD*10.3 |
Recoverable Tax (source) |
|
| RTAXAMTHM |
BCD*10.3 |
Recoverable Tax (functional) |
|
| EXTAMTSR |
BCD*10.3 |
Extended Amount (source) |
|
| EXTAMTHM |
BCD*10.3 |
Extended Amount (functional) |
|
| TOTAMTSR |
BCD*10.3 |
Total Amount (source) |
|
| TOTAMTHM |
BCD*10.3 |
Total Amount (fucntional) |
|
| TAXAMTSR |
BCD*10.3 |
Total tax amout (source) |
|
| TAXAMTHM |
BCD*10.3 |
Total tax amout (functional) |
|
| TAMTSR |
BCD*10.3 |
Total Amount inc. tax (source) |
|
| TAMTHM |
BCD*10.3 |
Total Amount inc. tax (functiona |
|
| 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 |
Work In Process Account |
Mask: %-45C |
| CVACCT |
String*45 |
Cost Variance Account |
Mask: %-45C |
| CALCOHEAD |
Integer |
Calculate Overhead? |
List: 3 entries
|
| CALCLABOR |
Integer |
Calculate Labor? |
List: 3 entries
|
| COMMENTS |
String*250 |
Comments |
|
| TAUTH1 |
String*12 |
Tax Authority 1 |
Mask: %-12N |
| TAUTH2 |
String*12 |
Tax Authority 2 |
Mask: %-12N |
| TAUTH3 |
String*12 |
Tax Authority 3 |
Mask: %-12N |
| TAUTH4 |
String*12 |
Tax Authority 4 |
Mask: %-12N |
| TAUTH5 |
String*12 |
Tax Authority 5 |
Mask: %-12N |
| TCLASS1 |
Integer |
Tax Class 1 |
|
| TCLASS2 |
Integer |
Tax Class 2 |
|
| TCLASS3 |
Integer |
Tax Class 3 |
|
| TCLASS4 |
Integer |
Tax Class 4 |
|
| TCLASS5 |
Integer |
Tax Class 5 |
|
| TITMCLSS1 |
Integer |
Item Tax Class for Tax Authority |
|
| TITMCLSS2 |
Integer |
Item Tax Class for Tax Authority |
|
| TITMCLSS3 |
Integer |
Item Tax Class for Tax Authority |
|
| TITMCLSS4 |
Integer |
Item Tax Class for Tax Authority |
|
| TITMCLSS5 |
Integer |
Item Tax Class for Tax Authority |
|
| TINCLUDE1 |
Integer |
Tax Included 1 |
|
| TINCLUDE2 |
Integer |
Tax Included 2 |
|
| TINCLUDE3 |
Integer |
Tax Included 3 |
|
| TINCLUDE4 |
Integer |
Tax Included 4 |
|
| TINCLUDE5 |
Integer |
Tax Included 5 |
|
| TAXBASES1 |
BCD*10.3 |
Tax Base 1 (source) |
|
| TAXBASES2 |
BCD*10.3 |
Tax Base 2 (source) |
|
| TAXBASES3 |
BCD*10.3 |
Tax Base 3 (source) |
|
| TAXBASES4 |
BCD*10.3 |
Tax Base 4 (source) |
|
| TAXBASES5 |
BCD*10.3 |
Tax Base 5 (source) |
|
| TAXBASEH1 |
BCD*10.3 |
Tax Base 1 (functional) |
|
| TAXBASEH2 |
BCD*10.3 |
Tax Base 2 (functional) |
|
| TAXBASEH3 |
BCD*10.3 |
Tax Base 3 (functional) |
|
| TAXBASEH4 |
BCD*10.3 |
Tax Base 4 (functional) |
|
| TAXBASEH5 |
BCD*10.3 |
Tax Base 5 (functional) |
|
| TAXAMTS1 |
BCD*10.3 |
Tax Amount 1 (source) |
|
| TAXAMTS2 |
BCD*10.3 |
Tax Amount 2 (source) |
|
| TAXAMTS3 |
BCD*10.3 |
Tax Amount 3 (source) |
|
| TAXAMTS4 |
BCD*10.3 |
Tax Amount 4 (source) |
|
| TAXAMTS5 |
BCD*10.3 |
Tax Amount 5 (source) |
|
| TAXAMTH1 |
BCD*10.3 |
Tax Amount 1 (functional) |
|
| TAXAMTH2 |
BCD*10.3 |
Tax Amount 2 (functional) |
|
| TAXAMTH3 |
BCD*10.3 |
Tax Amount 3 (functional) |
|
| TAXAMTH4 |
BCD*10.3 |
Tax Amount 4 (functional) |
|
| TAXAMTH5 |
BCD*10.3 |
Tax Amount 5 (functional) |
|
| DRILLSRCTY |
Integer |
Drill Down Type |
|
| DRILLDWNLK |
BCD*10.0 |
Drill Down Link |
|
| DRILLAPP |
String*2 |
Drill Down Application |
|
| OHACCT |
String*45 |
Overhead Account |
Mask: %-45C |
| 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 |
|
| OHSR |
BCD*10.3 |
Overhead Amount |
|
| OHHM |
BCD*10.3 |
Overhead Amount |
|
| LABACCT |
String*45 |
Labor Account |
Mask: %-45C |
| 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 |
|
| LABORSR |
BCD*10.3 |
Labor Amount |
|
| LABORHM |
BCD*10.3 |
Labor Amount |
|
| TRANSNUM |
Long |
Transaction Number |
|
| VALUES |
Long |
Optional Fields |
|
| TAMTRETSR |
BCD*10.3 |
Source Retainage Amount |
|
| TAMTRETHM |
BCD*10.3 |
Functional Retainage Amount |
|
| RETDUEDT |
Date |
Retainage Due Date |
|
| OHLABORQTY |
BCD*10.5 |
Quantity for Additional Costs |
|
| PROJSTAT |
Integer |
Project Status |
List: 7 entries
| 10 | = | Estimate | | 20 | = | Approved | | 30 | = | Open | | 40 | = | On Hold | | 70 | = | Inactive | | 60 | = | Completed | | 50 | = | Closed |
|
| TXEXPCOMSR |
BCD*10.3 |
Tax (exp) Committed (source) |
|
| TXEXPCOMHM |
BCD*10.3 |
Tax (exp) Committed (func) |
|
| TXALLCOMSR |
BCD*10.3 |
Tax (all) Committed (source) |
|
| TXALLCOMHM |
BCD*10.3 |
Tax (all) Committed (func) |
|
| TRANSREF |
Long |
Transaction Reference |
|
| OTHERREF |
Long |
Cost/Revenue TRANSNUM |
|
|