Added in version 8.3
The ERPINVOICE table is used for Infor CRM Back Office Extension (ICBOE) functionality.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
ERPINVOICEID(PK) |
nchar(12) |
NOT NULL |
ERPINVOICE_PRIMARY (AK) |
(One) to (Many) | DISCOUNTCHARGEITEM.INVOICEID |
| (One) to (Many) | ERPINVOICEADDRESS.ERPINVOICEID | ||||
| (One) to (Many) | ERPINVOICEITEM.ERPINVOICEID | ||||
| (One) to (Many) | ERPINVOICEPERSON.ERPINVOICEID | ||||
| (One) to (Many) | ERPRECEIVABLE.ERPINVOICEID | ||||
| (One) to (Many) | ERPRECEIVABLEITEM.ERPINVOICEID | ||||
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
ERPBILLTOID(FK) |
nchar(12) |
NULLS |
ERPINVOICE_ERPBILLTOID(IE) | (One) to (Many) | ERPBILLTO.ERPBILLTOID |
|
ACCOUNTID(FK) |
nchar(12) |
NULLS |
ERPINVOICE_ACCOUNTID(IE) |
(One) to (Many) | ACCOUNT.ACCOUNTID |
|
INVOICENUMBER |
varchar(100) |
NULLS |
|
||
|
ERPEXTERNALID |
varchar(100) |
NULLS |
ERPINVOICE_ERPEXTID(IE) |
||
|
ERPACCOUNTINGENTITYID |
varchar(22) |
NULLS |
|
||
|
ERPLOGICALID |
varchar(100) |
NULLS |
|
||
|
ERPLOCATION |
varchar(22) |
NULLS |
|
||
|
ERPDOCREFERENCETYPE |
varchar(100) |
NULLS |
|
||
|
ERPDOCREFERENCE |
varchar(100) |
NULLS |
|
||
|
ERPDOCREFLOGICALID |
varchar(100) |
NULLS |
|
||
|
ERPDOCLOCATION |
varchar(100) |
NULLS |
|
||
|
ERPPAYMENTERMID |
varchar(64) |
NULLS |
|
||
|
SHIPPINGADDRESSID(FK) |
nchar(12) |
NULLS |
ERPINVOICE_SHIPPINGADDRID(IE) |
(Many) to (One) | ERPINVOICEADDRESS.ADDRESSID |
|
BILLINGADDRESSID(FK) |
nchar(12) |
NULLS |
ERPINVOICE_BILLINGADDRID(IE) |
(Many) to (One) | ERPINVOICEADDRESS.ADDRESSID |
|
ERPSHIPTOID |
nchar(12) |
NULLS |
ERPINVOICE_SHIPTOID(IE) |
(One) to (Many) | ERPSHIPTO.ERPSHIPTOID |
|
ERPSTATUS |
varchar(64) |
NULLS |
|
||
|
ERPSTATUSDATE |
datetime |
NULLS |
|
||
|
GRANDTOTAL |
float |
NULLS |
|
||
|
ERPUNIQUEID |
varchar(377) |
NULLS |
ERPINVOICE_ERPUNIQUEID(IE) |
||
|
ERPVARIATIONID |
varchar(22) |
NULLS |
|
||
|
SECCODEID(FK) |
nchar(12) |
NULLS |
|
(One) to (Many) | SECCODE.SECCODEID |
|
DESCRIPTION |
varchar(1024) |
NULLS |
|
||
|
ERPPAYFROMID(FK) |
nchar(12) |
NULLS |
ERPINVOICE_ERPPAYFROMID(IE) |
(One) to (Many) | ERPPAYFROM.ERPPAYFROMID |
|
PAYFROMADDRESSID(FK) |
nchar(12) |
NULLS |
|
(Many) to (One) | ERPINVOICEADDRESS.ADDRESSID |
|
ERPDOCREFACCTENTITYID(FK) |
varchar(22) |
NULLS |
|
||
|
ERPLASTMODIFIEDDATE |
datetime |
NULLS |
|
||
|
ERPDOCUMENTDATE |
datetime |
NULLS |
|
||
|
BASECURRENCYCODE |
varchar(64) |
NULLS |
|
||
|
ERPEXTENDEDAMOUNT |
float |
NULLS |
|
||
|
ERPEXTENDEDBASEAMOUNT |
float |
NULLS |
|
||
|
ERPTOTALBASEAMOUNT |
float |
NULLS |
|
||
|
CURRENCYCODE |
nvarchar(64) |
NULLS |
|
||
|
TYPE |
nvarchar(64) |
NULLS |
|||
|
DUEDATE |
datetime |
NULLS |
|||
|
ERPNOTES |
text |
NULLS |
|||
| ISNORMALIZED | char(1) |
NULLS |