While this table does not have a field defined as a primary key, the ERPBILLTOACCOUNTID field should be unique and considered a primary key.
Added in version 8.3
The ERPBILLTOACCOUNT table is used for Infor CRM Back Office Extension (ICBOE) functionality.
|
|
While this table does not have a field defined as a primary key, the ERPBILLTOACCOUNTID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
| ERPBILLTOACCOUNTID |
nchar(12) |
NOT NULL |
ERPBILLTOACCOUNT_PRIMARY (AK) |
||
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
ACCOUNTID(FK) |
nchar(12) |
NULLS |
ERPBILLTOACCOUNT_ACCOUNTID(IE) |
(One) to (Many) | ACCOUNT.ACCOUNTID |
|
ERPBILLTOID(FK) |
nchar(12) |
NULLS |
ERPBILLTOACCOUNT_BILLTOID |
(One) to (Many) | ERPBILLTO.ERPBILLTID |