| CNTBTCH |
1 |
BCD*5.0 |
Batch Number |
E A |
|
| CNTENT |
2 |
BCD*4.0 |
Batch Entry Number |
E A |
|
| CNTLINE |
3 |
BCD*3.0 |
Batch Line Number |
E A |
|
| TRANSDATE |
4 |
Date |
Transaction Date |
E A |
|
| DTEBTCH |
5 |
Date |
Batch Date |
E A |
|
| DOCDATE |
6 |
Date |
Entry Date |
E A |
|
| POSTSEQ |
7 |
Long |
Posting Sequence |
E A |
|
| FISCALYEAR |
8 |
String*4 |
Fiscal Year |
E A |
Mask: %04D |
| FISCALPER |
9 |
Integer |
Fiscal Period |
E A |
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 |
|
| DOCNUM |
10 |
String*22 |
Document Number |
E A |
|
| VENDORID |
11 |
String*12 |
Vendor Number |
E A |
|
| CCY |
12 |
String*3 |
Transaction Currency |
E A |
Mask: %-3N |
| RATETYPE |
13 |
String*2 |
Rate Type |
E A |
Mask: %-2N |
| RATEDATE |
14 |
Date |
Rate Date |
E A |
|
| RATEOP |
15 |
Integer |
Rate Operator |
E A |
List: 2 entries
|
| RATEOVER |
16 |
Boolean |
Rate Override |
E A |
List: 2 entries
|
| RATE |
17 |
BCD*8.7 |
Exchange Rate |
E A |
|
| DOCTYPE |
18 |
Integer |
Document Type |
E A |
List: 8 entries
| 1 | = | Invoice | | 2 | = | Debit Note | | 3 | = | Credit Note | | 4 | = | Interest | | 5 | = | Prepayment | | 13 | = | Retainage Invoice | | 14 | = | Retainage Credit Note | | 15 | = | Retainage Debit Note |
|
| TRANSTYPE |
19 |
Integer |
Transaction Type |
E A |
List: 14 entries
| 1 | = | Posted | | 2 | = | Discount | | 3 | = | Write-off | | 4 | = | Apply From | | 5 | = | Apply To | | 6 | = | Payment/Receipt Reversal | | 7 | = | Rounding (multicurrency) | | 8 | = | Realized Exchange Gain/Loss | | 9 | = | Unrealized Exchange Gain/Loss | | 10 | = | Adjustment | | 11 | = | Receipt/Payment | | 20 | = | Retainage Rounding | | 21 | = | Retainage Realized Exchange Gain/Loss | | 22 | = | Retainage Unrealized Exchange Gain/Loss |
|
| TRANSNUM |
20 |
Long |
Transaction Number |
E A |
|
| CONTRACT |
21 |
String*16 |
Contract |
E A R |
Mask: %-16C |
| PROJECT |
22 |
String*16 |
Project |
E A |
Mask: %-16N |
| CATEGORY |
23 |
String*16 |
Category |
E A |
Mask: %-16N |
| RESOURCE |
24 |
String*24 |
Resource |
E A |
Mask: %-24C |
| ARITEM |
25 |
String*16 |
A/R Item Number |
E A |
Mask: %-16C |
| ARUOM |
26 |
String*10 |
Unit of Measure |
E A |
Mask: %-10C |
| REFERENCE |
27 |
String*60 |
Reference |
E A |
|
| DESC |
28 |
String*60 |
Description |
E A |
|
| QUANTITY |
29 |
BCD*10.5 |
Quantity |
E A |
|
| UNITCOST |
30 |
BCD*10.6 |
Unit Cost |
E A |
|
| BILLRATE |
31 |
BCD*10.6 |
Billing Rate |
E A |
|
| TOTAMTSR |
32 |
BCD*10.3 |
Total Amount (ex tax) |
E A |
|
| TOTAMTHM |
33 |
BCD*10.3 |
Total Amount (ex tax) |
E A |
|
| TAXAMTSR |
34 |
BCD*10.3 |
Tax Amount |
E A |
|
| TAXAMTHM |
35 |
BCD*10.3 |
Tax Amount |
E A |
|
| RTAXAMTSR |
36 |
BCD*10.3 |
Recoverable Tax |
E A |
|
| RTAXAMTHM |
37 |
BCD*10.3 |
Recoverable Tax |
E A |
|
| TAMTSR |
38 |
BCD*10.3 |
Total Amount (inc tax) |
E A |
|
| TAMTHM |
39 |
BCD*10.3 |
Total Amount (inc tax) |
E A |
|
| PAYAMTSR |
40 |
BCD*10.3 |
Amount Paid |
E A |
|
| PAYAMTHM |
41 |
BCD*10.3 |
Amount Paid |
E A |
|
| REFDOC |
42 |
String*22 |
Reference Document |
E A |
|
| WIPACCT |
43 |
String*45 |
Work in Progress Account |
E A |
Mask: %-45C |
| COSTACCT |
44 |
String*45 |
Cost Account |
E A |
Mask: %-45C |
| OHACCT |
45 |
String*45 |
Overhead Account |
E A |
Mask: %-45C |
| OHSR |
46 |
BCD*10.3 |
Overhead Amount |
E A |
|
| OHHM |
47 |
BCD*10.3 |
Overhead Amount |
E A |
|
| LABACCT |
48 |
String*45 |
Labor Account |
E A |
Mask: %-45C |
| LABORSR |
49 |
BCD*10.3 |
Labor Amount |
E A |
|
| LABORHM |
50 |
BCD*10.3 |
Labor Amount |
E A |
|
| BILLTYPE |
51 |
Integer |
Billing Type |
E A |
List: 4 entries
| 0 | = | None | | 2 | = | Billable | | 3 | = | No Charge | | 1 | = | Non-billable |
|
| COMMENTS |
52 |
String*250 |
Comments |
E A |
|
| TAUTH1 |
53 |
String*12 |
Tax Authority 1 |
E A |
Mask: %-12N |
| TAUTH2 |
54 |
String*12 |
Tax Authority 2 |
E A |
Mask: %-12N |
| TAUTH3 |
55 |
String*12 |
Tax Authority 3 |
E A |
Mask: %-12N |
| TAUTH4 |
56 |
String*12 |
Tax Authority 4 |
E A |
Mask: %-12N |
| TAUTH5 |
57 |
String*12 |
Tax Authority 5 |
E A |
Mask: %-12N |
| TCLASS1 |
58 |
Integer |
Customer/Vendor Tax Class 1 |
E A |
|
| TCLASS2 |
59 |
Integer |
Customer/Vendor Tax Class 2 |
E A |
|
| TCLASS3 |
60 |
Integer |
Customer/Vendor Tax Class 3 |
E A |
|
| TCLASS4 |
61 |
Integer |
Customer/Vendor Tax Class 4 |
E A |
|
| TCLASS5 |
62 |
Integer |
Customer/Vendor Tax Class 5 |
E A |
|
| TITMCLSS1 |
63 |
Integer |
Item Tax Class 1 |
E A |
|
| TITMCLSS2 |
64 |
Integer |
Item Tax Class 2 |
E A |
|
| TITMCLSS3 |
65 |
Integer |
Item Tax Class 3 |
E A |
|
| TITMCLSS4 |
66 |
Integer |
Item Tax Class 4 |
E A |
|
| TITMCLSS5 |
67 |
Integer |
Item Tax Class 5 |
E A |
|
| TINCLUDE1 |
68 |
Integer |
Tax Included 1 |
E A |
|
| TINCLUDE2 |
69 |
Integer |
Tax Included 2 |
E A |
|
| TINCLUDE3 |
70 |
Integer |
Tax Included 3 |
E A |
|
| TINCLUDE4 |
71 |
Integer |
Tax Included 4 |
E A |
|
| TINCLUDE5 |
72 |
Integer |
Tax Included 5 |
E A |
|
| TAXBASES1 |
73 |
BCD*10.3 |
Tax Base 1 Source Currency |
E A |
|
| TAXBASES2 |
74 |
BCD*10.3 |
Tax Base 2 Source Currency |
E A |
|
| TAXBASES3 |
75 |
BCD*10.3 |
Tax Base 3 Source Currency |
E A |
|
| TAXBASES4 |
76 |
BCD*10.3 |
Tax Base 4 Source Currency |
E A |
|
| TAXBASES5 |
77 |
BCD*10.3 |
Tax Base 5 Source Currency |
E A |
|
| TAXBASEH1 |
78 |
BCD*10.3 |
Tax Base 1 Functional Currency |
E A |
|
| TAXBASEH2 |
79 |
BCD*10.3 |
Tax Base 2 Functional Currency |
E A |
|
| TAXBASEH3 |
80 |
BCD*10.3 |
Tax Base 3 Functional Currency |
E A |
|
| TAXBASEH4 |
81 |
BCD*10.3 |
Tax Base 4 Functional Currency |
E A |
|
| TAXBASEH5 |
82 |
BCD*10.3 |
Tax Base 5 Functional Currency |
E A |
|
| TAXAMTS1 |
83 |
BCD*10.3 |
Tax Amount 1 Source Currency |
E A |
|
| TAXAMTS2 |
84 |
BCD*10.3 |
Tax Amount 2 Source Currency |
E A |
|
| TAXAMTS3 |
85 |
BCD*10.3 |
Tax Amount 3 Source Currency |
E A |
|
| TAXAMTS4 |
86 |
BCD*10.3 |
Tax Amount 4 Source Currency |
E A |
|
| TAXAMTS5 |
87 |
BCD*10.3 |
Tax Amount 5 Source Currency |
E A |
|
| TAXAMTH1 |
88 |
BCD*10.3 |
Tax Amount 1 Functional Currency |
E A |
|
| TAXAMTH2 |
89 |
BCD*10.3 |
Tax Amount 2 Functional Currency |
E A |
|
| TAXAMTH3 |
90 |
BCD*10.3 |
Tax Amount 3 Functional Currency |
E A |
|
| TAXAMTH4 |
91 |
BCD*10.3 |
Tax Amount 4 Functional Currency |
E A |
|
| TAXAMTH5 |
92 |
BCD*10.3 |
Tax Amount 5 Functional Currency |
E A |
|
| TRANSREF |
93 |
Long |
Transaction Reference |
E A |
|
| TAMTRETSR |
94 |
BCD*10.3 |
Retainage Amount (Source) |
E A |
|
| TAMTRETHM |
95 |
BCD*10.3 |
Retainage Amount (Functional) |
E A |
|
| RETDUEDT |
96 |
Date |
Retainage Due Date |
E A |
|
| ORIGDOC |
97 |
String*24 |
Original Document Number |
E A |
|
| OVERHD |
98 |
Integer |
Overhead Type |
E A |
|
| OHEADRATE |
99 |
BCD*10.6 |
Overhead Rate |
E A |
|
| HEADPER |
100 |
BCD*5.5 |
Overhead Percentage |
E A |
|
| LABOR |
101 |
Integer |
Labor Type |
E A |
|
| LABORRATE |
102 |
BCD*10.6 |
Labor Rate |
E A |
|
| LABORPER |
103 |
BCD*5.5 |
Labor Percentage |
E A |
|
|