Added in version 8.3
The ERPINVOICEITEM table is used for Infor CRM Back Office Extension (ICBOE) functionality.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
| ERPINVOICEITEMID (PK) |
nchar(12) |
NOT NULL |
ERPINVOICEITEM_PRIMARY (AK) |
(One) to (Many) | DISCOUNTCHARGEITEM.INVOICEITEMID |
| ERPINVOICEID |
nchar(12) |
NOT NULL |
ERPINVOICEITEM_ERPINVOICEID (IE) |
(One) to (Many) | ERPINVOICE.ERPINVOICEID |
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
UOMQUANTITY |
decimal (17,4) |
NULLS |
|||
|
DOCUMENTREFERENCETYPE |
varchar(100) |
NULLS |
|||
|
DOCUMENTREFERENCEID |
varchar(100) |
NULLS |
|||
|
DOCUMENTREFERENCELINE |
varchar(22) |
NULLS |
|||
|
EXTENDEDPRICE |
float |
NULLS |
|||
|
DESCRIPTION |
varchar(1024) |
NULLS |
|||
|
PRODUCTID(FK) |
nchar(22) |
NULLS |
ERPINVOICEITEM_ERPPRODUCTID (IE) |
(One) to (Many) | PRODUCT.PRODUCTID |
|
ERPLINENUMBER |
varchar(22) |
NULLS |
|||
|
QUANTITY |
decimal (17,4) |
NULLS |
|||
|
UNITOFMEASUREID |
nchar(12) |
NULLS |
ERPINVOICEITEM_UOMID (IE) |
(One) to (Many) | UNITOFMEASURE.UNITOFMEASUREID |
|
ERPREQUESTEDDELIVERYDATE |
datetime |
NULLS |
|||
|
SALESORDERREFERENCE |
varchar(100) |
NULLS |
|||
|
SALESORDERID (FK) |
nchar(12) |
NULLS |
ERPINVOICEITEM_SALESORDERID (IE) |
(One) to (Many) | SALESORDER.SALESORDERID |
|
SALESORDERLINEREFERENCE |
varchar(100) |
NULLS |
|||
|
ERPLINETOTALAMOUNT |
float |
NULLS |
|||
|
PRICE |
float |
NULLS |
|||
|
ERPUNITPRICEPERQUANTITY |
decimal (17,4) |
NULLS |
|||
|
ERPUNITPRICEPERQUANTITYUOM |
varchar(100) |
NULLS |
|||
|
OPENITEMINDICATOR |
nchar(1) |
NULLS |
|||
|
PRODUCTNAME |
varchar(100) |
NULLS |
|||
|
ERPBASEAMOUNT |
float |
NULLS |
|||
|
ERPLINETOTALBASEAMOUNT |
float |
NULLS |
|||
|
BASEUNITPRICE |
float |
NULLS |
|
||
|
BASECURRENCYCODE |
varchar(64) |
NULLS |
|
||
|
ERPEXTENDEDCOST |
float |
NULLS |
|
||
| EXTENDEDBASECOST |
float |
NULLS |
|||
| LINENUMBER |
int |
NULLS |
|||
|
ERPNOTES |
text |
NULLS |
|||
|
EXTENDEDBASEPRICE |
float |
NULLS |