Overview
When Invoice Items is selected in Requested Data, the report will return the following details.
|
Field Name |
Data Type |
Information |
|---|---|---|
|
InvoiceItem_IIID |
Integer (Unsigned) |
The primary key for an invoice item |
|
Invoice_IID |
Integer (Unsigned) |
The ID of the invoice that the invoice item belongs to |
|
Quantity |
Decimal |
The quantity assigned to this invoice item |
|
Amount |
Decimal |
The amount per unit assigned to this invoice item |
|
Currency |
String |
The currency assigned to the invoice item |
|
Tax_TID |
Integer |
The foreign key of the tax to which this invoice item belongs |
|
Description |
String |
The description assign to this invoice item |
|
Employee_MID |
Integer (Unsigned) |
The Employee ID linked to the invoice item, if any |
|
Job_UID |
Integer (Unsigned) |
The Job ID linked to the invoice item, if any |
|
LeaveManagementType _LM_type_id |
Integer |
The ID of the leave type to which this invoice item belongs If = 0 then this invoice item does not denote leave take If < 0 then this invoice item denotes subtraction of base hours for retroactive leave applications |
|
Timesheet_TSID |
Integer (Unsigned) |
The timesheet ID linked to the invoice item |
|
ExpenseReport_ERID |
Integer (Unsigned) |
The ID of the expense report linked to the invoice item, if any |
|
Expense_EID |
Integer (Unsigned) |
The ID of the expense linked to the invoice, if any |
|
PayCat_PCID |
Integer (Unsigned) |
The ID of the pay category to which this InvoiceItem belongs 0 = base unit |
|
ChargeItem_CCID |
Integer (Unsigned) |
The ID of the charge item linked to the invoice item 0 = base unit |
|
InvoiceItemType_ID |
Integer (Unsigned) |
The ID of the invoice item type set on the invoice item 0 = none |
Comments
0 comments
Please sign in to leave a comment.