Added in version 8.3
The ERPBILLTO table is used for Infor CRM Back Office Extension (ICBOE) functionality.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
| ERPBILLTOID (PK) |
nchar(12) |
NOT NULL |
ERPBILLTO_PRIMARY (AK) |
(One) to (Many) | ADDRESS.ENTITYID |
| (One) to (Many) | ERPBILLTOACCOUNT.ERPBILLTOID | ||||
| (One) to (Many) | ERPBILLTOACCOUNTINGENTITY.ERPBILLTO | ||||
| (One) to (Many) | ERPBILLTOCONTACT.ERPBILLTOID | ||||
| (One) to (Many) | ERPBILLTOSHIPTO.ERPBILLTOID | ||||
| (One) to (Many) | ERPINVOICE.ERPBILLTOID | ||||
| (One) to (Many) | ERPPAYFROMBILLTO.ERPBILLTOID | ||||
| (One) to (Many) | ERPRECEIVABLE.ERPBILLTOID | ||||
| (One) to (Many) | QUOTE.BILLTOID | ||||
| (One) to (Many) | SALESORDER.ERPBILLTOID | ||||
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
ADDRESSID |
nchar(12) |
NULLS |
ERPBILLTO_ADDRESSID(IE) |
(Many) to (One) | ADDRESS.ADDRESSID |
|
CONTACTID |
nchar(12) |
NULLS |
ERPBILLTO_CONTACTID(CA) |
(Many) to (One) | CONTACT.CONTACTID |
|
NAME |
varchar(64) |
NULLS |
|||
|
CUSTOMERTYPE |
varchar(64) |
NULLS |
|||
|
TERRITORY |
varchar(64) |
NULLS |
|||
|
FAX |
varchar(48) |
NULLS |
|||
|
MAINPHONE |
varchar(48) |
NULLS |
|||
|
|
varchar(255) |
NULLS |
|||
|
ERPDISPLAYID |
varchar(100) |
NULLS |
|||
|
ERPEXTID |
varchar(100) |
NULLS |
ERPBILLITO_ERPEXTID(IE) |
||
|
ERPACCOUNTINGENTITYID |
varchar(22) |
NULLS |
|
||
|
ERPLOGICALID |
varchar(255) |
NULLS |
|
||
|
ERPVARIATIONID |
varchar(22) |
NULLS |
|
||
|
TAXCODE |
varchar(64) |
NULLS |
|
||
|
PAYMENTTERMID |
varchar(64) |
NULLS |
|
||
|
STATUSDATE |
datetime |
NULLS |
|
||
|
ERPUNIQUEID |
varchar(377) |
NULLS |
ERPBILLTO_ERPUNIQUEID(IE) |
||
|
ERPPAYMENTMETHOD |
varchar(64) |
NULLS |
|
||
|
ERPSTATUS |
varchar(64) |
NULLS |
|
||
|
SECCODEID(FK) |
nchar(12) |
NULLS |
|
(One) to (Many) | SECCODE.SECCODEID |
|
ERPSICCODE |
varchar(64) |
NULLS |
|
||
|
ERPINCOTERM |
varchar(64) |
NULLS |
|
||
|
SYNCSTATUS |
varchar(64) |
NULLS |
|
||
|
ERPNOTES |
text |
NULLS |