| ORDUNIQ |
BCD*10.0 |
Order Uniquifier |
|
| 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 |
Mask: %-24C |
| MISCCHARGE |
String*6 |
Miscellaneous Charges Code |
Mask: %-6N |
| DESC |
String*60 |
Description |
|
| ACCTSET |
String*6 |
Item Account Set |
Mask: %-6N |
| USERCOSTMD |
Boolean |
User-Specified Costing Method |
|
| PRICELIST |
String*6 |
Price List |
Mask: %-6N |
| CATEGORY |
String*6 |
Category |
Mask: %-6N |
| LOCATION |
String*6 |
Location |
Mask: %-6N |
| PICKSEQ |
String*10 |
Picking Sequence |
|
| EXPDATE |
Date |
Expected Shipment Date |
|
| STOCKITEM |
Boolean |
Stock Item |
|
| QTYORDERED |
BCD*10.4 |
Quantity Ordered |
|
| QTYSHIPPED |
BCD*10.4 |
Quantity Shipped |
|
| QTYBACKORD |
BCD*10.4 |
Quantity Backordered |
|
| QTYSHPTODT |
BCD*10.4 |
Quantity Shipped-to-date |
|
| ORIGQTY |
BCD*10.4 |
Original Quantity Ordered |
|
| QTYPO |
BCD*10.4 |
P/O Quantity Ordered |
|
| ORDUNIT |
String*10 |
Order Unit of Measure |
Mask: %-10c |
| UNITCONV |
BCD*10.6 |
Order Unit Conversion |
|
| UNITPRICE |
BCD*10.6 |
Order Unit Price |
|
| PRICEOVER |
Boolean |
Price Override |
List: 2 entries
|
| UNITCOST |
BCD*10.6 |
Order Unit Cost |
|
| MOSTREC |
BCD*10.6 |
Most Recent Unit Cost |
|
| STDCOST |
BCD*10.6 |
Standard Unit Cost |
|
| COST1 |
BCD*10.6 |
Alternate Unit Cost 1 |
|
| COST2 |
BCD*10.6 |
Alternate Unit Cost 2 |
|
| UNITPRCDEC |
Integer |
Unit Price No. of Decimals |
|
| PRICEUNIT |
String*10 |
Pricing Unit of Measure |
Mask: %-10c |
| PRIUNTPRC |
BCD*10.6 |
Pricing Unit Price |
|
| PRIUNTCONV |
BCD*10.6 |
Pricing Unit Conversion |
|
| PRIPERCENT |
BCD*5.5 |
Price Discount Percentage |
|
| PRIAMOUNT |
BCD*10.3 |
Price Discount Amount |
|
| BASEUNIT |
String*10 |
Pricing Base Unit |
Mask: %-10c |
| PRIBASPRC |
BCD*10.6 |
Pricing Base Unit Price |
|
| PRIBASCONV |
BCD*10.6 |
Pricing Base Unit Conversion |
|
| COSTUNIT |
String*10 |
Costing Unit of Measure |
Mask: %-10c |
| COSUNTCST |
BCD*10.6 |
Costing Unit Cost |
|
| COSUNTCONV |
BCD*10.6 |
Costing Unit Conversion |
|
| EXTOPRICE |
BCD*10.3 |
Extended Order Amount |
|
| EXTOCOST |
BCD*10.3 |
Extended Order Cost |
|
| EXTINVMISC |
BCD*10.3 |
Extended Amount |
|
| INVDISC |
BCD*10.3 |
Order Discount Amount |
|
| EXTICOST |
BCD*10.3 |
Extended Detail Cost |
|
| EXTOVER |
Boolean |
Extended Shipped Amt. Override |
|
| UNITWEIGHT |
BCD*10.4 |
Unit Weight |
|
| EXTWEIGHT |
BCD*10.4 |
Extended Weight |
|
| COMPLETE |
Integer |
Detail Completed |
List: 4 entries
| 0 | = | Not completed | | 1 | = | Completed/Not In Database | | 2 | = | Completed | | 3 | = | Processed by day end |
|
| ADDTOILOC |
Boolean |
Recognized In Item/Location |
|
| SALESLOST |
BCD*10.3 |
Lost Sales Amount |
|
| 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 |
|
| TRATE1 |
BCD*8.5 |
Tax Rate 1 |
|
| TRATE2 |
BCD*8.5 |
Tax Rate 2 |
|
| TRATE3 |
BCD*8.5 |
Tax Rate 3 |
|
| TRATE4 |
BCD*8.5 |
Tax Rate 4 |
|
| TRATE5 |
BCD*8.5 |
Tax Rate 5 |
|
| DETAILNUM |
Integer |
Detail Number |
|
| HAVESERIAL |
Boolean |
Use Item Serial Numbers |
List: 2 entries
|
| COMMINST |
Boolean |
Use Comments/Instructions |
List: 2 entries
|
| GLNONSTKCR |
String*45 |
Non-stock Clearing Account |
Mask: %-45C |
| AVGCOST |
BCD*10.6 |
Average Unit Cost |
|
| LASTCOST |
BCD*10.6 |
Last Unit Cost |
|
| COPYDETAIL |
Boolean |
Copy This Detail Line |
List: 2 entries
|
| QUONUMBER |
String*22 |
Quote Number |
Mask: %-22C |
| QUODTLNUM |
Integer |
Quote Detail Line Number |
|
| SHIPTRACK |
String*36 |
Shipment Tracking Number |
|
| SHIPVIA |
String*6 |
Ship-Via Code |
Mask: %-6N |
| VIADESC |
String*60 |
Ship-Via Code Description |
|
| DISCPER |
BCD*5.5 |
Discount Percent |
|
| QTYCOMMIT |
BCD*10.4 |
Quantity Committed |
|
| MANITEMNO |
String*24 |
Manufacturer's Item Number |
Mask: %-24C |
| CUSTITEMNO |
String*24 |
Customer Item Number |
Mask: %-24C |
| QTYTRUECOM |
BCD*10.4 |
True Quantity Committed |
|
| VALUES |
Long |
Optional Fields |
|
| DDTLTYPE |
Integer |
Kitting/BOM |
List: 3 entries
|
| DDTLNO |
String*6 |
Kit/BOM Number |
Mask: %-6N |
| BUILDQTY |
BCD*10.4 |
BOM Build Qty. |
|
| BUILDUNIT |
String*10 |
BOM Build Unit |
Mask: %-10c |
| BLDUNTCONV |
BCD*10.6 |
BOM Build Unit Conversion |
|
| FRMNUMBER |
String*22 |
Predecessor Number |
Mask: %-22C |
| NEXTCMPNUM |
Long |
Next Component Number |
|
| EPOSPROMID |
Integer |
ePOS Promotion ID |
|
| BASEWUNIT |
String*10 |
Pricing Base Weight Unit |
|
| WEIGHTUNIT |
String*10 |
Order Weight UOM |
|
| WEIGHTCONV |
BCD*10.6 |
Order Weight Conversion Factor |
|
| PRWGHTUNIT |
String*10 |
Pricing Weight UOM |
|
| PRWGHTCONV |
BCD*10.6 |
Pricing Weight Conversion Factor |
|
| PRIBASWCNV |
BCD*10.6 |
Pricing Base Weight Conv. Factor |
|
| 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
|
| NEEDPCHECK |
Boolean |
Price Check Pending |
|
| CAPPROVEBY |
String*8 |
Price Approved By |
Mask: %-8N |
| HDRDISC |
BCD*10.3 |
Header Discount |
|
| OTRAMOUNT1 |
BCD*10.3 |
TR Tax Amount 1 |
|
| OTRAMOUNT2 |
BCD*10.3 |
TR Tax Amount 2 |
|
| OTRAMOUNT3 |
BCD*10.3 |
TR Tax Amount 3 |
|
| OTRAMOUNT4 |
BCD*10.3 |
TR Tax Amount 4 |
|
| OTRAMOUNT5 |
BCD*10.3 |
TR Tax Amount 5 |
|
| PSPRINTED |
Boolean |
Picking Slip Printed |
|
| 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 |
|
| REVBILL |
String*45 |
Revenue/Billing Account |
Mask: %-45C |
| COGSWIP |
String*45 |
COGS/WIP Account |
Mask: %-45C |
| RTGPERCENT |
BCD*5.5 |
Retainage Percent |
|
| RTGDAYS |
Integer |
Retainage Days |
|
| PRICEOPT |
Integer |
Default O/E Price |
List: 4 entries
| 0 | = | | | 1 | = | Billing Rate | | 2 | = | Use Customer Price List | | 3 | = | Use Specified Price List |
|
| ARITEMNO |
String*16 |
A/R Item Number |
Mask: %-16C |
| ARUNIT |
String*10 |
A/R Item Unit |
Mask: %-10C |
| PAYMNTDIST |
BCD*10.3 |
Prepayment Distributed |
|
|