Import Fields

Internal_Usage_Headers

Field Name	Type
*Sequence Number	Long
Internal Usage Number	String(22)
Description	String(60)
Entry Type	Integer
Internal Usage Date	Date
Fiscal Year	String(4)
Fiscal Period	Integer
Reference	String(60)
IC-Unique Document Number	Decimal(10,0)
Record Status	Integer
Record Deleted	Boolean
Record Printed	Boolean
Employee Number	String(60)
Entered By	String(8)
Posting Date	Date

Internal_Usage_Details

Field Name	Type
*Sequence Number	Long
*Line Number	Integer
Item Number	String(24)
Category	String(6)
Location	String(6)
Quantity	Decimal(10,4)
Unit of Measure	String(10)
Unit Cost	Decimal(10,6)
Extended Cost	Decimal(10,3)
Serial Numbers	Boolean
Comments	String(250)
Manufacturer's Item Number	String(24)
Detail Line Number	Integer
GL Account	String(45)
Employee Number	String(60)
Sage Fixed Assets Attached	Boolean
Function	Integer
Revision List Line Number	Integer
Inter-process Comm. ID	Long
Force Pop-up SN	Boolean
Pop-up SN	Integer
Close SN	Boolean
LT Set ID	Long
Force Pop-up LT	Boolean
Pop-up LT	Integer
Close LT	Boolean
Unformatted Item Number	String(24)
Database	String(32)
Company	String(32)
Template	String(25)
Asset Description	String(80)
Separate Quantities	Boolean
Asset Quantity	Decimal(10,5)
Unit of Measure	String(10)
Amount	Decimal(10,3)

Internal_Usage_Optional_Fields

Field Name	Type
*Sequence Number	Long
*Optional Field	String(12)
Value	String(60)
Value Set	Integer

Internal_Usage_Detail_Optional_F

Field Name	Type
*Sequence Number	Long
*Line Number	Integer
*Optional Field	String(12)
Value	String(60)
Value Set	Integer

Internal_Usage_Serial_Numbers

Field Name	Type
*Sequence Number	Long
*Line Number	Integer
*Serial Number	String(40)
Serial Quantity	Long

Internal_Usage_Lot_Numbers

Field Name	Type
*Sequence Number	Long
*Line Number	Integer
*Lot Number	String(40)
Expiry Date	Date
Transaction Quantity	Decimal(10,4)

* = key fields