CustomerInvoiceItem

Sedona internal autonumber for the Invoice Item record

Foreign key from AR_Invoice table

Foreign key from AR_Customer_Site table

Abbreviated Item Code, from AR_Item table; must specify either an ItemCode or PartCode

Foreign key from IN_Part table; do not set explicitly; instead pass in PartCode and this will be validated and set automatically

Abbreviated Part Code, from IN_Part table; must specify either an ItemCode or PartCode

automatically set to Description from AR_Item or IN_Part if not supplied

code from IN_Unit_Of_Measure table; automatically set to UnitOfMeasure for Item or Part if not supplied

if Quantity = 1 and Rate is not supplied, Rate will default to the Amount

Monthly Amount (CycleAmount / # months in BillCycle)

Required for Item Codes where Item Type is Recurring (SS_Item_Type.Is_Recurring)

Required for Item Codes where Item Type is Recurring (SS_Item_Type.Is_Recurring)

Abbreviated Warehouse code; for parts, set this to relieve inventory; defaults to N/A if not supplied

Foreign key from AR_Customer_System table

M = Monthly, Q = Quarterly, S = Semi-annual, A = Annual; will also be set to an empty sting on non-recurring items

calculated automatically as Rate * Mos. in BillCycle

creates a record in the AR_Customer_Equipment table, but only if BuildEquipmentRecord config setting = 1