| CRDUNIQ |
BCD*10.0 |
CN 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 |
|
| STOCKITEM |
Boolean |
Stock Item |
|
| QTYRETURN |
BCD*10.4 |
Quantity Returned |
|
| QTYSHIPPED |
BCD*10.4 |
Quantity Shipped |
|
| QTYBACKORD |
BCD*10.4 |
Quantity Backordered |
|
| CRDUNIT |
String*10 |
Order Unit |
Mask: %-10c |
| UNITCONV |
BCD*10.6 |
Unit Conversion |
|
| UNITPRICE |
BCD*10.6 |
Unit Price |
|
| PRICEOVER |
Boolean |
Price Override |
|
| UNITCOST |
BCD*10.6 |
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 |
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 |
Mask: %-10c |
| COSUNTCST |
BCD*10.6 |
Costing Unit Cost |
|
| COSUNTCONV |
BCD*10.6 |
Costing Unit Conversion |
|
| EXTCCOST |
BCD*10.3 |
Extended Detail Cost |
|
| EXTCRDMISC |
BCD*10.3 |
Extended Amount/Misc. Charge |
|
| CRDDISC |
BCD*10.3 |
Credit Note Discount Amount |
|
| EXTOVER |
Boolean |
Extended Amount Override |
|
| EXTICOST |
BCD*10.3 |
Invoice Extended Cost |
|
| UNITWEIGHT |
BCD*10.4 |
Unit Weight |
|
| EXTWEIGHT |
BCD*10.4 |
Extended Weight |
|
| RETURNTYPE |
Integer |
Return Type |
List: 3 entries
| 1 | = | Items Returned to Inventory | | 2 | = | Damaged Items | | 3 | = | Price Adjustment |
|
| 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 |
Have Serial Numbers for Item |
List: 2 entries
|
| COMMINST |
Boolean |
Have 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 |
|
| 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 |
|
| EXPDATE |
Date |
Shipment Date |
|
| QTYORDERED |
BCD*10.4 |
Invoice Current Qty. Outstanding |
|
| INVUNIT |
String*10 |
Invoice Unit of Measure |
|
| INVUNITCON |
BCD*10.6 |
Invoice Unit Conversion |
|
| ORDQTYORD |
BCD*10.4 |
Order Quantity Ordered |
|
| ORDQTYBKOR |
BCD*10.4 |
Order Quantity Backordered |
|
| ORDQTYCOMM |
BCD*10.4 |
Order Quantity Committed |
|
| ORDQTYSTD |
BCD*10.4 |
Order Quantity Shipped-to-date |
|
| ORDUNIT |
String*10 |
Order Unit of Measure |
|
| ORDUNITCON |
BCD*10.6 |
Order Unit Conversion |
|
| MANITEMNO |
String*24 |
Manufacturer's Item Number |
Mask: %-24C |
| CUSTITEMNO |
String*24 |
Customer Item Number |
Mask: %-24C |
| 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 |
|
| INVNUMBER |
String*22 |
Invoice Number |
Mask: %-22C |
| NEXTCMPNUM |
Long |
Next Component Number |
|
| EPOSPROMID |
Integer |
ePOS Promotion ID |
|
| BASEWUNIT |
String*10 |
Pricing Base Weight Unit |
|
| WEIGHTUNIT |
String*10 |
Weight Unit of Measure |
|
| WEIGHTCONV |
BCD*10.6 |
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 |
|
| CTRAMOUNT1 |
BCD*10.3 |
TR Tax Amount 1 |
|
| CTRAMOUNT2 |
BCD*10.3 |
TR Tax Amount 2 |
|
| CTRAMOUNT3 |
BCD*10.3 |
TR Tax Amount 3 |
|
| CTRAMOUNT4 |
BCD*10.3 |
TR Tax Amount 4 |
|
| CTRAMOUNT5 |
BCD*10.3 |
TR Tax Amount 5 |
|
| COG |
BCD*10.3 |
Cost of Goods |
|
| COSTED |
Boolean |
Record Costed |
List: 2 entries
|
| 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 |
| 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 |
|
| PRICEOPT |
Integer |
Default O/E Price |
List: 4 entries
| 0 | = | | | 1 | = | Billing Rate | | 2 | = | Use Customer Price List | | 3 | = | Use Specified Price List |
|
|