Added in version 8.3
The ERPRECEIVABLEITEM 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 |
ERPRECEIVABLEITEM_PRIMARY (AK) |
||
| ERPRECEIVABLEID (FK) |
nchar(12) |
NOT NULL |
ERPRECEIVABLEITEM_ERPRECEIVABLEID (IE) |
(One) to (Many) | ERPRECEIVABLE.ERPRECEIVABLEID |
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
DOCUMENTREFERENCETYPE |
varchar(100) |
NULLS |
|||
|
DOCUMENTREFERENCEID |
varchar(100) |
NULLS |
|||
|
DOCUMENTREFERENCELINE |
varchar(22) |
NULLS |
|||
|
EXTENDEDPRICE |
float |
NULLS |
|||
|
INVOICEREFERENCE |
varchar(100) |
NULLS |
|||
|
ERPINVOICEID(FK) |
nchar(22) |
NULLS |
ERPRECEIVABLEITEM_ERPINVOICEID (IE) |
(One) to (Many) | ERPINVOICE.ERPINVOICEID |
|
PRODUCTID(FK) |
nchar(12) |
NULLS |
ERPRECEIVABLEITEM_ERPPRODUCTID (IE) |
(One) to (Many) | PRODUCT.PRODUCTID |
|
ERPLINENUMBER |
varchar(64) |
NULLS |
|||
|
ERPINVOICELINE |
varchar(100) |
NULLS |
|
||
|
DESCRIPTION |
varchar(1024) |
NULLS |
|||
|
ERPSTATUS |
varchar(64) |
NULLS |
|
||
|
ERPLINETOTALAMOUNT |
float |
NULLS |
|||
|
PRODUCTNAME |
varchar(100) |
NULLS |
|||
|
EXTENDEDBASEAMOUNT |
float |
NULLS |
|||
|
TOTALBASEAMOUNT |
float |
NULLS |
|||
|
LINENUMBER |
int |
NULLS |
|||
|
ERPNOTES |
text |
NULLS |