Added in version 8.3
The ERPRECEIVABLE table is used for Infor CRM Back Office Extension (ICBOE) functionality.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
ERPRECEIVABLEID (PK) |
nchar(12) |
NOT NULL |
ERPRECEIVABLE_PRIMARY (AK) |
(One) to (Many) | DISCOUNTCHARGEITEM.RECEIVABLEID |
| (One) to (Many) | ERPRECEIVABLEADDRESS.ERPRECEIVABLEID | ||||
| (One) to (Many) | ERPRECEIVABLEITEM.ERPRECEIVABLEID | ||||
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
ACCOUNTID (FK) |
nchar(12) |
NULLS |
ERPRECEIVABLE_ACCOUNTID(IE) |
(One) to (Many) | ACCOUNT.ACCOUNTID |
|
RECIVABLENUMBER |
varchar(100) |
NULLS |
|
||
|
ERPEXTID |
varchar(100) |
NULLS |
ERPRECEIVABLE_ERPEXTID(IE) |
||
|
ERPACCOUNTINGENTITYID |
varchar(22) |
NULLS |
|||
|
ERPLOGICALID |
varchar(255) |
NULLS |
|||
|
ERPLOCATION |
varchar(22) |
NULLS |
|||
|
ERPEXTENDEDAMOUNT |
float |
NULLS |
|||
|
ERPINVOICENUMBER |
varchar(100) |
NULLS |
|||
|
ERPINVOICEIDLOGICALID |
varchar(255) |
NULLS |
|||
|
ERPINVOICELOCATION |
varchar(22) |
NULLS |
|||
|
ERPPAYMENTMETHOD |
varchar(64) |
NULLS |
|||
|
ERPPAYMENTTERMID |
varchar(64) |
NULLS |
|
||
|
ERPRECEIPTAMOUNT |
float |
NULLS |
|||
|
SHIPPINGADDRESSID (FK) |
nchar(12) |
NULLS |
ERPRECEIVABLE_SHIPPINGADDRID(IE) |
(Many) to (One) | ERPRECEIVABLEADDRESS.ERPRECEIVABLEADDRESSID |
|
ERPSHIPTOID (FK) |
nchar(12) |
NULLS |
ERPRECEIVABLE_SHIPTOID(IE) |
(One) to (Many) | ERPSHIPTO.ERPSHIPTOID |
|
ERPSTATUS |
varchar(64) |
NULLS |
|
||
|
ERPSTATUSDATE |
datetime |
NULLS |
|
||
|
GRANDTOTAL |
float |
NULLS |
|
||
|
ERPPAYFROMID (FK) |
nchar(12) |
NULLS |
ERPRECEIVABLE_PAYFROMID(IE) |
(One) to (Many) | ERPPAYFROM.ERPPAYFROMID |
|
ERPUNIQUEID |
varchar(377) |
NULLS |
ERPRECEIVABLE_ERPUNIQUEID(IE) |
||
|
RECEIVABLEAMOUNT |
float |
NULLS |
|
||
|
ERPVARIATIONID |
varchar(22) |
NULLS |
|||
|
ERPBILLTOID (FK) |
nchar(12) |
NULLS |
ERPRECEIVABLE_ERPBILLTOID(IE) |
(One) to (Many) | ERPBILLTO.ERPBILLTOID |
|
ERPINVOICEID (FK) |
nchar(12) |
NULLS |
ERPRECEIVABLE_INVOICEID(IE) |
(One) to (Many) | ERPINVOICE.ERPINVOICEID |
|
ERPINVOICEACCOUNTINGENTITYID |
varchar(22) |
NULLS |
|
||
|
TYPE |
varchar(100) |
NULLS |
|||
|
RECEIVEDAMOUNT |
float |
NULLS |
|
||
|
BILLINGADDRESSID (FK) |
nchar(12) |
NULLS |
ERPRECEIVABLE_BILLINGADDRESSID(IE) |
(Many) to (One) | ERPRECEIVABLEADDRESS.ERPRECEIVABLEADDRESSID |
|
PAYFROMADDRESSID (FK) |
nchar(12) |
NULLS |
ERPRECEIVABLE_PAYFROMADDRESSID(IE) |
(Many) to (One) | ERPRECEIVABLEADDRESS.ERPRECEIVABLEADDRESSID |
|
DESCRIPTION |
varchar(1024) |
NULLS |
|||
|
ERPDOCUMENTDATE |
datetime |
NULLS |
|||
|
ERPLASTMODIFIEDDATE |
datetime |
NULLS |
|||
|
BASECURRENCYAMOUNT |
float |
NULLS |
|||
|
CURRENCYCODE |
varchar(64) |
NULLS |
|||
|
BASECURRENCYCODE |
varchar(64) |
NULLS |
|||
|
ERPEXTENDEDBASEAMOUNT |
float |
NULLS |
|
||
|
RECEIPTBASEAMOUNT |
float |
NULLS |
|
||
|
RECEIVABLEBASEAMOUNT |
float |
NULLS |
|
||
|
RECEIVEDBASEAMOUNT |
float |
NULLS |
|
||
|
TOTALBASEAMOUNT |
float |
NULLS |
|
||
|
ERPNOTES |
text |
NULLS |
|||
| ISNORMALIZED | char(1) |
NULLS |