| POSTSEQNO |
Long |
Posting Sequence |
|
| LINENO |
Long |
Line Number |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| SEQ |
Long |
Sequence |
|
| ADJUSTNO |
String*16 |
Adjustment Number |
Mask: %-16C |
| CONTRACT |
String*16 |
Contract |
Mask: %-16C |
| PROJECT |
String*16 |
Project |
Mask: %-16N |
| CATEGORY |
String*16 |
Category |
Mask: %-16N |
| RESOURCE |
String*24 |
Resource |
|
| COSTNUM |
Long |
Cost No. |
|
| REVNUM |
Long |
Revenue No. |
|
| ADJTYPE |
Integer |
Adjustment Type |
List: 2 entries
|
| CONTRACTD |
String*16 |
Adjusted to Contract |
Mask: %-16C |
| PROJECTD |
String*16 |
Adjusted to Project |
Mask: %-16N |
| CATEGORYD |
String*16 |
Adjusted to Category |
Mask: %-16N |
| RESOURCED |
String*24 |
Adjusted to Resource |
|
| TRANSDATE |
Date |
Transaction Date |
|
| FMTCONTNO |
String*16 |
Contract |
Mask: %-16C |
| FMTCONTNOD |
String*16 |
Adjusted to Contract |
Mask: %-16C |
| IDCUST |
String*12 |
Customer No. |
Mask: %-12C |
| VENDORID |
String*12 |
Vendor No. |
Mask: %-12C |
| COSTTYPE |
Integer |
Cost Class |
List: 6 entries
| 1 | = | Labor | | 2 | = | Material | | 3 | = | Equipment | | 4 | = | Subcontractor | | 5 | = | Overhead | | 6 | = | Miscellaneous |
|
| DOCNUM |
String*24 |
Document No. |
|
| MODULE |
String*6 |
Source Module |
|
| DOCTYPE |
Integer |
Document Type |
List: 11 entries
| 1 | = | Invoice | | 2 | = | Debit Note | | 3 | = | Credit Note | | 4 | = | Interest | | 5 | = | Prepayment | | 6 | = | Unapplied Cash | | 7 | = | Material Usage | | 8 | = | Material Return | | 9 | = | Equipment Usage | | 10 | = | Timecard | | 11 | = | Charges |
|
| TRANSTYPE |
Integer |
Transaction Type |
List: 30 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 | | 100 | = | Receipt/Payment | | 101 | = | Insert | | 102 | = | Delete | | 103 | = | Edit | | 104 | = | 104 | | 105 | = | 105 | | 106 | = | 106 | | 200 | = | 200 | | 201 | = | 201 | | 202 | = | 202 | | 203 | = | 203 | | 204 | = | 204 | | 205 | = | 205 | | 206 | = | 206 | | 300 | = | 300 | | 301 | = | 301 | | 302 | = | 302 | | 400 | = | 400 | | 401 | = | 401 | | 402 | = | 402 |
|
| BILLTYPE |
Integer |
Billing Type |
List: 3 entries
| 2 | = | Billable | | 3 | = | No Charge | | 1 | = | Non-billable |
|
| ARITEM |
String*16 |
A/R Item Number |
|
| ARUOM |
String*10 |
A/R Unit of Measure |
|
| ICUOM |
String*10 |
I/C Unit of Measure |
|
| INVACCT |
String*45 |
Inventory Control Account |
|
| QUANTITY |
BCD*10.5 |
Quantity |
|
| UNITCOST |
BCD*10.6 |
Unit Cost |
|
| BILLRATE |
BCD*10.6 |
Billing Rate |
|
| EXTCOSTHM |
BCD*10.3 |
Extended Cost |
|
| EXTCOSTSR |
BCD*10.3 |
Extended Cost |
|
| EXTBILLSR |
BCD*10.3 |
Extended Billing Amount |
|
| LABOR |
Integer |
Labor Type |
|
| LABORRATE |
BCD*10.6 |
Labor Rate |
|
| LABORPER |
BCD*5.5 |
Labor Percentage |
|
| LABORAMT |
BCD*10.3 |
Labor Amount |
|
| OHAMT |
BCD*10.3 |
Overhead Amount |
|
| OVERHD |
Integer |
Overhead Type |
|
| OHEADRATE |
BCD*10.6 |
Overhead Rate |
|
| HEADPER |
BCD*5.5 |
Overhead Percentage |
|
| TOTAMTHM |
BCD*10.3 |
Total Amount |
|
| TIMETYPE |
Integer |
Timecard Type |
List: 3 entries
|
| TTOTAMTHM |
BCD*10.3 |
To Total Amount |
|
| FTOTAMTHM |
BCD*10.3 |
From Total Amount |
|
| TBILLTYPE |
Integer |
To Billing Type |
List: 3 entries
| 2 | = | Billable | | 3 | = | No Charge | | 1 | = | Non-billable |
|
| FOVERHD |
Integer |
From Overhead Type |
|
| FOHEADRATE |
BCD*10.6 |
From Overhead Rate |
|
| FHEADPER |
BCD*5.5 |
From Overhead Percentage |
|
| FOHEADAMT |
BCD*10.3 |
From Overhead Amount |
|
| FLABOR |
Integer |
From Labor Type |
|
| FLABORRATE |
BCD*10.6 |
From Labor Rate |
|
| FLABORPER |
BCD*5.5 |
From Labor Percentage |
|
| FLABORAMT |
BCD*10.3 |
From Labor Amount |
|
| FBILLTYPE |
Integer |
From Billing Type |
|
| TOVERHD |
Integer |
To Overhead Type |
|
| TOHEADRATE |
BCD*10.6 |
To Overhead Rate |
|
| THEADPER |
BCD*5.5 |
To Overhead Percentage |
|
| TOHEADAMT |
BCD*10.3 |
To Overhead Amount |
|
| TLABOR |
Integer |
To Labor Type |
|
| TLABORRATE |
BCD*10.6 |
To Labor Rate |
|
| TLABORPER |
BCD*5.5 |
To Labor Percentage |
|
| TLABORAMT |
BCD*10.3 |
To Labor Amount |
|
| BILLCCY |
String*3 |
Billing Currency |
|
| FBILLACCT |
String*45 |
From Billings Account |
|
| FDEFRACCT |
String*45 |
From Deferred Revenue Account |
|
| FREVACCT |
String*45 |
From Revenue Account |
|
| FWIPACCT |
String*45 |
From Work in Progess Account |
|
| FCOSTACCT |
String*45 |
From Cost Account |
|
| FPAYACCT |
String*45 |
From Payroll Expense Account |
|
| FEXPACCT |
String*45 |
From Employee Expense Account |
|
| FEQUIPACCT |
String*45 |
From Equipment Account |
|
| FOHACCT |
String*45 |
From Overhead Account |
|
| FLABACCT |
String*45 |
From Labor Account |
|
| TBILLACCT |
String*45 |
To Billings Account |
|
| TDEFRACCT |
String*45 |
To Deferred Revenue Account |
|
| TREVACCT |
String*45 |
To Revenue Account |
|
| TWIPACCT |
String*45 |
To Work in Progress Account |
|
| TCOSTACCT |
String*45 |
To Cost Account |
|
| TPAYACCT |
String*45 |
To Payroll Expense Account |
|
| TEXPACCT |
String*45 |
To Employee Expense Account |
|
| TEQUIPACCT |
String*45 |
To Equipment Account |
|
| TOHACCT |
String*45 |
To Overhead Account |
|
| TLABACCT |
String*45 |
To Labor Account |
|
| COSTCCY |
String*3 |
Cost Currency |
|
| ICBTYPE |
Integer |
I/C Bucket Type |
List: 4 entries
| 0 | = | N/A | | 1 | = | Offset Bucket | | 2 | = | Specific Bucket | | 3 | = | Prorate |
|
| ICDOCNUM |
String*22 |
I/C Document Number |
|
| ICCMETHOD |
Integer |
I/C Cost Method |
|
| ICDATE |
Date |
I/C Transaction Date |
|
| ICLOCAT |
String*6 |
I/C Location |
|
| USERID |
String*8 |
User ID |
|
| DETAILNUM |
Long |
Detail Number |
|
|