|
|
|
|
|
The Import file must be a text file with one line per Estimate line. The fields on the line may be separated by Tab characters (Tab delimited), or commas (CSV format).
The first line of the file must contain the version number MJCT8.01
Fields must be in the specified order, with delimiter (comma or tab) if a field is left empty.
Separators are not required past the last field with a non-empty value.
Field |
Format |
Size |
Notes |
Custom 1 |
Alpha |
30 character |
|
Estimate Line Type |
Alpha |
1 character |
|
Comment |
Alpha |
30 character |
|
Cost Centre Code |
Alpha |
4 character |
|
Component Code |
Alpha |
4 character |
|
Product Code |
Alpha |
28 character |
|
Quantity/UOM Quantity |
Numeric |
|
|
Unit |
Alpha |
4 character |
|
Unit Cost / UOM Unit Cost Price |
Numeric |
|
|
Unit Sell / UOM Unit Sell Price |
Numeric |
|
|
Description |
Alpha |
60 character |
|
Custom 2 |
Alpha |
30 characters |
|
Reference |
Alpha |
20 characters |
|
Sales Group Code |
Alpha |
|
Defaults from Product if not specified |
Discount Percentage |
Numeric |
|
|
Branch Code (Accredo Saturn Only) |
Alpha |
|
Defaults from Job if not specified |
Department Code (Accredo Saturn Only) |
Alpha |
|
Defaults from Job if not specified
|
UOM Code |
Alpha |
|
Defaults to Base UOM if not specified. |
Example (Accredo Saturn)
MJCT8.01
,M,,ASS,RIMU,T1MLR,5.6,,58,83.31,1M sq Laminated Rimu,,,PART,0,ACK,MANU
,M,,ASS,RIMU,T470MMLR,2,,34,58.6,470mm Laminated Rimu,,,PART,0,ACK,MANU
,M,,ASS,RIMU,T70SQR,7,,7,10.16,70mm x 70mm Rimu,,,PART,0,ACK,MANU
,M,,ASS,RIMU,T25MMRF,5,,1,1.89,15mm Rimu Facing,,,PART,0,ACK,MANU
,M,,ASS,RIMU,T180MMTR,2.8,,11,15.99,180mm x 48mm Rimu,,,PART,0,ACK,MANU
,M,,ASS,FIT,BRASS52LOCK,1,,26,37.65,Brass 52 Lock & Key,,,PART,0,ACK,MANU
,M,,ASS,FIT,VIC38BRASSK,1,,11,15.94,Victorian 38mm Brass Doorknob,,,PART,0,ACK,MANU
,T,,PRE,LAB,ASSEMBLY,1,,28,45.01,Workshop Overhead,,,LAB,0,ACK,MANU
,T,,ASS,LAB,LABOUR,2,,22,40,Labour Charge,,,LAB,0,ACK,MANU
,T,,FIN,LAB,LABOUR,1,,22,40,Labour Charge,LAB,0,ACK,MANU