| SEQ |
Long |
Sequence |
|
| LINENO |
Long |
Line Number |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| MATERIALNO |
String*16 |
Material Number |
Mask: %-16C |
| FMTCONTNO |
String*16 |
^1 |
Mask: %-16C |
| CONTRACT |
String*16 |
^1 |
Mask: %-16C |
| PROJECT |
String*16 |
^2 |
Mask: %-16N |
| CATEGORY |
String*16 |
^3 |
Mask: %-16N |
| RESOURCE |
String*24 |
Item Number |
Mask: %-24C |
| DESC |
String*60 |
Description |
|
| LOCATION |
String*6 |
Location |
Mask: %-6N |
| QUANTITY |
BCD*10.5 |
Quantity |
|
| UOM |
String*10 |
Item Unit of Measure |
Mask: %-10c |
| CONVERSION |
BCD*10.6 |
Conversion |
|
| UNITCOST |
BCD*10.6 |
Unit Cost |
|
| ADJUNITCST |
BCD*10.5 |
Reserved |
|
| ADJCOST |
BCD*10.5 |
Reserved |
|
| COSTSEQNUM |
Long |
Reserved |
|
| COSTDATE |
Date |
Reserved |
|
| ADDCOST |
BCD*10.3 |
Additional Cost |
|
| STOCKITEM |
Boolean |
Stock Item |
|
| COSTMETHOD |
Integer |
Cost Method |
List: 6 entries
| 1 | = | Moving Average | | 2 | = | FIFO | | 3 | = | LIFO | | 4 | = | Standard Cost | | 5 | = | Most Recent Cost | | 6 | = | User-specified |
|
| UNFMTITEM |
String*24 |
Item Number |
|
| CHKBDLZERO |
Boolean |
Check Below Zero |
|
| COSTCCY |
String*3 |
Cost Currency |
Mask: %-3N |
| EXTCOSTSR |
BCD*10.3 |
Extended Cost |
|
| EXTCOSTHM |
BCD*10.3 |
Extended Cost |
|
| COMMENTS |
String*250 |
Comments |
|
| ICACCT |
String*45 |
Inventory Control Account |
Mask: %-45C |
| WIPACCT |
String*45 |
WIP/COS Account |
Mask: %-45C |
| OHACCT |
String*45 |
Overhead Account |
Mask: %-45C |
| BILLTYPE |
Integer |
Billing Type |
List: 3 entries
| 2 | = | Billable | | 3 | = | No Charge | | 1 | = | Non-billable |
|
| FIXEDBILL |
Integer |
Bill Amount Based On |
List: 2 entries
| 1 | = | Invoice This Amount | | 2 | = | Invoice Based on Exchange Rate |
|
| ESTBILLCCY |
Integer |
Revenue And Cost Currency |
List: 3 entries
| 1 | = | Revenue and Costs in Functional Currency | | 2 | = | Revenue in Customer Currency | | 3 | = | Revenue and Costs in Customer Currency |
|
| BILLRATE |
BCD*10.6 |
Billing Rate |
|
| EXTBILLSR |
BCD*10.3 |
Extended Billing Amount |
|
| EXTBILLHM |
BCD*10.3 |
Reserved |
|
| TOTCOSTSR |
BCD*10.3 |
Total Cost |
|
| TOTCOSTHM |
BCD*10.3 |
Total Cost |
|
| OVERHD |
Integer |
Overhead Type |
|
| OHEADRATE |
BCD*10.6 |
Overhead Rate |
|
| HEADPER |
BCD*5.5 |
Overhead Percentage |
|
| OHSR |
BCD*10.3 |
Overhead Amount |
|
| OHHM |
BCD*10.3 |
Overhead Amount |
|
| BILLCCY |
String*3 |
Billing Currency |
Mask: %-3N |
| DETAILNUM |
Long |
Detail Number |
|
| ARITEM |
String*16 |
A/R Item Number |
Mask: %-16C |
| ARUOM |
String*10 |
A/R Unit of Measure |
Mask: %-10C |
| 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 |
|
| TINCLUDED1 |
Boolean |
Tax Included 1 |
|
| TINCLUDED2 |
Boolean |
Tax Included 2 |
|
| TINCLUDED3 |
Boolean |
Tax Included 3 |
|
| TINCLUDED4 |
Boolean |
Tax Included 4 |
|
| TINCLUDED5 |
Boolean |
Tax Included 5 |
|
| PROJTYPE |
Integer |
^2 Type |
List: 3 entries
| 1 | = | Time and Materials | | 2 | = | Fixed Price | | 3 | = | Cost Plus |
|
| CONTSTYLE |
Integer |
^1 Style |
List: 2 entries
|
| CUSTOMER |
String*12 |
Customer |
Mask: %-12C |
| REVREC |
Integer |
Accounting Method |
List: 7 entries
| 1 | = | Completed Project | | 2 | = | Total Cost Percentage Complete | | 3 | = | Labor Hours Percentage Complete | | 4 | = | Billings and Costs | | 5 | = | Project Percentage Complete | | 6 | = | Category Percentage Complete | | 8 | = | Accrual-Basis |
|
| INVTYPE |
Integer |
Invoice Type |
List: 2 entries
|
| VALUES |
Long |
Optional Fields |
|
| FASDETAIL |
Boolean |
FAS Attached |
List: 2 entries
|
| FASDB |
String*32 |
Database |
|
| FASCMP |
String*32 |
Company |
|
| FASTMPL |
String*25 |
Template |
|
| TEXTDESC |
String*80 |
Asset Description |
|
| SEPQTY |
Boolean |
Seperate Quantities |
|
| FASQTY |
BCD*10.5 |
Asset Quantity |
|
| FASUOM |
String*10 |
Unit of Measure |
|
| AMTHC |
BCD*10.3 |
Amount |
|
| EMPLOYEENO |
String*60 |
Used By |
|
| BINTERNAL |
Boolean |
Internal Usage |
|
| CLOSESN |
Boolean |
Close SN |
|
| PROID |
Long |
SN inter-communication ID |
|
| POPUPSN |
Integer |
Popup SN |
|
| POPUPLT |
Integer |
Popup LT |
|
| CLOSELT |
Boolean |
Close LT |
|
| LTSETID |
Long |
LT inter-communication ID |
|
| FORCEPOPSN |
Boolean |
Force popup SN |
|
| FORCEPOPLT |
Boolean |
Force popup LT |
|
| GENICSEQ |
Boolean |
Generate IC Seq. |
|
| PRICELIST |
String*6 |
Price List |
Mask: %-6N |
| CUSTCCY |
String*3 |
Customer Currency |
|
|