Added in version 8.3
The ERPPAYFROM table is used for Infor CRM Back Office Extension (ICBOE) functionality.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
ERPPAYFROMID (PK) |
nchar(12) |
NOT NULL |
ERPPAYFROM_PRIMARY (AK) |
(One) to (Many) | ADDRESS.ENTITYID |
| (One) to (Many) | ERPINVOICE.ERPPAYFROMID | ||||
| (One) to (Many) | ERPPAYFROMACCOUNTINGENTITY.ERPPAYFROMID | ||||
| (One) to (Many) | ERPPAYFROMBILLTO.ERPPAYFROMID | ||||
| (One) to (Many) | ERPPAYFROMCONTACT.ERPPAYFROMID | ||||
| (One) to (Many) | ERPRECEIVABLE.ERPPAYFROMID | ||||
| (One) to (Many) | QUOTE.ERPPAYFROMID | ||||
| (One) to (Many) | SALESORDER.ERPPAYFROMID | ||||
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
ADDRESSID (FK) |
nchar(12) |
NULLS |
ERPPAYFROM_ADDRESSID(IE) |
(Many) to (One) | ADDRESS.ADDRESSID |
|
ERPBILLTOID |
nchar(12) |
NULLS |
ERPPAYFROM_ERPBILLTOID(IE) |
||
|
NAME |
varchar(100) |
NULLS |
|||
|
CUSTOMERTYPE |
varchar(64) |
NULLS |
|||
|
FAX |
varchar(48) |
NULLS |
|||
|
MAINPHONE |
varchar(48) |
NULLS |
|||
|
|
varchar(255) |
NULLS |
|||
|
ERPDISPLAYID |
varchar(100) |
NULLS |
|||
|
ERPEXTID |
varchar(100) |
NULLS |
ERPPAYFROM_ERPEXTID(IE) |
||
|
ERPACCOUNTINGENTITYID |
nchar(22) |
NULLS |
|||
|
ERPLOGICALID |
varchar(255) |
NULLS |
|||
|
ERPVARIATIONID |
varchar(22) |
NULLS |
|||
|
TAXCODE |
varchar(64) |
NULLS |
|||
|
PAYMENTTERMID |
varchar(64) |
NULLS |
|
||
|
STATUSDATE |
datetime |
NULLS |
|
||
|
STATUSDESCRIPTION |
varchar(100) |
NULLS |
|
||
|
ERPUNIQUEID |
varchar(377) |
NULLS |
ERPPAYFROM_ERPUNIQUEID(IE) |
||
|
ERPSTATUS |
varchar(64) |
NULLS |
|
||
|
SECCODEID (FK) |
nchar(12) |
NULLS |
|
(One) to (Many) | SECCODE.SECCODEID |
|
SYNCSTATUS |
varchar(64) |
NULLS |
|
||
|
ERPNOTES |
text |
NULLS |