| TRANSTYPE |
Integer |
Transaction Type |
List: 5 entries
| 1 | = | Invoice | | 2 | = | Credit Note | | 3 | = | Shipment | | 4 | = | Debit Note | | 5 | = | Order |
|
| DAYENDNUM |
Long |
Day End Number |
|
| ENTRYNUM |
Long |
Entry Number |
|
| LINENUM |
Integer |
Line Number |
|
| AUDTDATE |
Date |
|
|
| AUDTTIME |
Time |
|
|
| AUDTUSER |
String*8 |
|
|
| AUDTORG |
String*6 |
|
|
| LINETYPE |
Integer |
Line Type |
List: 2 entries
|
| ITEM |
String*24 |
Item Number |
|
| MISCCHARGE |
String*6 |
Miscellaneous Charge Code |
|
| DESC |
String*60 |
Description |
|
| PRICELIST |
String*6 |
Price List |
|
| CATEGORY |
String*6 |
Category |
Mask: %-6N |
| LOCATION |
String*6 |
Location |
Mask: %-6N |
| QTYSHIPPED |
BCD*10.4 |
Quantity Shipped |
|
| INVUNIT |
String*10 |
Unit of Measure |
|
| UNITPRICE |
BCD*10.6 |
Unit Price |
|
| PRICEOVER |
Boolean |
Price Override |
|
| UNITCOST |
BCD*10.6 |
Unit Cost |
|
| EXTCOSTH |
BCD*10.3 |
Extended Cost (Functional) |
|
| EXTCOSTS |
BCD*10.3 |
Extended Cost (Source) |
|
| COSTVARH |
BCD*10.3 |
Cost Variance (Functional) |
|
| COSTVARS |
BCD*10.3 |
Cost Variance (Source) |
|
| EXTOVER |
Boolean |
Extended Amount Override |
|
| EXTINVMISC |
BCD*10.3 |
Extended Amount |
|
| REVAMTH |
BCD*10.3 |
Revenue (Functional) |
|
| REVAMTS |
BCD*10.3 |
Revenue (Source) |
|
| UNITWEIGHT |
BCD*10.4 |
Unit Weight |
|
| EXTWEIGHT |
BCD*10.4 |
Extended Weight |
|
| 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 |
|
| TBASE1 |
BCD*10.3 |
Tax Base 1 |
|
| TBASE2 |
BCD*10.3 |
Tax Base 2 |
|
| TBASE3 |
BCD*10.3 |
Tax Base 3 |
|
| TBASE4 |
BCD*10.3 |
Tax Base 4 |
|
| TBASE5 |
BCD*10.3 |
Tax Base 5 |
|
| TAMOUNT1 |
BCD*10.3 |
Tax Amount 1 |
|
| TAMOUNT2 |
BCD*10.3 |
Tax Amount 2 |
|
| TAMOUNT3 |
BCD*10.3 |
Tax Amount 3 |
|
| TAMOUNT4 |
BCD*10.3 |
Tax Amount 4 |
|
| TAMOUNT5 |
BCD*10.3 |
Tax Amount 5 |
|
| REVENUACCT |
String*45 |
Revenue Account |
Mask: %-45C |
| COGSACCT |
String*45 |
Cost of Goods Sold Account |
Mask: %-45C |
| VARIANACCT |
String*45 |
Variance Account |
Mask: %-45C |
| INVACCT |
String*45 |
Inventory Control Account |
Mask: %-45C |
| RETURNTYPE |
Integer |
Return Type |
List: 3 entries
| 1 | = | Items Returned to Inventory | | 2 | = | Damaged Items | | 3 | = | Price Adjustment |
|
| SHPCLRACCT |
String*45 |
Shipment Clearing Account |
Mask: %-45C |
| EXTCSTADJH |
BCD*10.3 |
Functional Adjusted Ext.Cost |
|
| EXTCSTADJS |
BCD*10.3 |
Source Adjusted Ext. Cost |
|
| CSTVARADJH |
BCD*10.3 |
Functional Adjusted Cost Variance |
|
| CSTVARADJS |
BCD*10.3 |
Source Adjusted Cost Variance |
|
| INVDISC |
BCD*10.3 |
Invoice Discount |
|
| FROMDOC |
String*22 |
From Document |
|
| DDTLNO |
String*6 |
Kit No. |
Mask: %-6N |
| VALUES |
Long |
Optional Fields |
|
| TERMDISCBL |
Integer |
Discountable |
List: 2 entries
|
| WEIGHTUNIT |
String*10 |
Weight Unit of Measure |
|
| DEFUWEIGHT |
BCD*10.4 |
Def. Weight UOM Unit Weight |
|
| DEFEXTWGHT |
BCD*10.4 |
Def. Weight UOM Ext. Unit Weight |
|
| PRPRICEBY |
Integer |
Price By |
List: 2 entries
|
| CAPPROVEBY |
String*8 |
Price Approved By |
Mask: %-8N |
| TRAMOUNT1 |
BCD*10.3 |
Tax Reporting Amount 1 |
|
| TRAMOUNT2 |
BCD*10.3 |
Tax Reporting Amount 2 |
|
| TRAMOUNT3 |
BCD*10.3 |
Tax Reporting Amount 3 |
|
| TRAMOUNT4 |
BCD*10.3 |
Tax Reporting Amount 4 |
|
| TRAMOUNT5 |
BCD*10.3 |
Tax Reporting Amount 5 |
|
| JOBRELATED |
Boolean |
Job Related |
|
| CONTRACT |
String*16 |
Contract Code |
Mask: %-16C |
| PROJECT |
String*16 |
Project Code |
Mask: %-16N |
| CCATEGORY |
String*16 |
Category Code |
Mask: %-16N |
| COSTCLASS |
Integer |
Cost Class |
List: 7 entries
| 0 | = | | | 1 | = | Labor | | 2 | = | Material | | 3 | = | Equipment | | 4 | = | Subcontractor | | 5 | = | Overhead | | 6 | = | Miscellaneous |
|
| PROJSTYLE |
Integer |
Project Style |
List: 3 entries
|
| PROJTYPE |
Integer |
Project Type |
List: 4 entries
| 0 | = | | | 1 | = | Time and Materials | | 2 | = | Fixed Price | | 3 | = | Cost Plus |
|
| REVREC |
Integer |
Accounting Method |
List: 9 entries
| 0 | = | | | 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 | | 7 | = | Completed Contract | | 8 | = | Accrual-Basis |
|
| BILLTYPE |
Integer |
Billing Type |
List: 4 entries
| 0 | = | | | 1 | = | Non-billable | | 2 | = | Billable | | 3 | = | No Charge |
|
| ARITEMNO |
String*16 |
A/R Item Number |
|
| ARUNIT |
String*10 |
A/R Item Unit |
|
| RTGAMOUNT |
BCD*10.3 |
Retainage Amount |
|
| RTGPERCENT |
BCD*5.5 |
Retainage Percent |
|
| RTGDAYS |
Integer |
Retainage Days |
|
| RTGDATEDUE |
Date |
Retainage Due Date |
|
| RTGDDTOVR |
Boolean |
Retainage Due Date Override |
|
| RTGAMTOVR |
Boolean |
Retainage Amount Override |
|
| RTGTXBASE1 |
BCD*10.3 |
Retainage Tax Base 1 |
|
| RTGTXBASE2 |
BCD*10.3 |
Retainage Tax Base 2 |
|
| RTGTXBASE3 |
BCD*10.3 |
Retainage Tax Base 3 |
|
| RTGTXBASE4 |
BCD*10.3 |
Retainage Tax Base 4 |
|
| RTGTXBASE5 |
BCD*10.3 |
Retainage Tax Base 5 |
|
| RTGTXAMT1 |
BCD*10.3 |
Retainage Tax Amount 1 |
|
| RTGTXAMT2 |
BCD*10.3 |
Retainage Tax Amount 2 |
|
| RTGTXAMT3 |
BCD*10.3 |
Retainage Tax Amount 3 |
|
| RTGTXAMT4 |
BCD*10.3 |
Retainage Tax Amount 4 |
|
| RTGTXAMT5 |
BCD*10.3 |
Retainage Tax Amount 5 |
|
| OVERHDACCT |
String*45 |
Overhead Account |
Mask: %-45C |
| OVERHDH |
BCD*10.3 |
Overhead (Functional) |
|
| OVERHDS |
BCD*10.3 |
Overhead (Source) |
|
| LABORACCT |
String*45 |
Labor Account |
Mask: %-45C |
| LABORH |
BCD*10.3 |
Labor (Functional) |
|
| LABORS |
BCD*10.3 |
Labor (Source) |
|
| PMTRANSNBR |
Long |
PM Transaction Number |
|
|