Added in version 8.3
The DISCOUNTCHARGEITEM table is used for Infor CRM Back Office Extension (ICBOE) functionality.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
| DISCOUNTCHARGEITEMID (PK) |
nchar(12) |
NOT NULL |
DISCOUNTCHARGEITEM_PRIMARY (AK) |
||
| SALESORDERID (FK) |
nchar(12) |
NULLS |
(One) to (Many) | SALESORDER.SALESORDERID | |
|
CREATEUSER (FK) |
nchar(12) |
NULLS |
|
||
|
CREATEDATE |
datetime |
NULLS |
|
||
|
MODIFYUSER (FK) |
nchar(12) |
NULLS |
|
||
|
MODIFYDATE |
datetime |
NULLS |
|
||
|
NAME |
varchar(255) |
NULLS |
COUNTRYALIAS_ALIAS(IE) |
||
|
DESCRIPTION |
varchar(255) |
NULLS |
COUNTRYALIAS_COUNTRYMAPID(IE) |
(One) to (Many) |
|
| RATE | float |
NULLS |
|||
| REASONCODE | varchr(255) |
NULLS |
|||
| SECCODEID (FK) |
nchar(12) |
NULLS |
(One) to (Many) | SECCODE.SECCODEID | |
| AMOUNT | float |
NULLS |
|||
| QUOTEID (FK) |
nchar(12) |
NULLS |
(One) to (Many) | QUOTE.QUOTEID | |
| SALESORDERITEMSID (FK) |
nchar(12) |
NULLS |
(One) to (Many) | SALESORDERITEMS.SALESORDERITEMSID | |
| QUOTEITEMID (FK) |
nchar(12) |
NULLS |
(One) to (Many) | QUOTEITEM.QUOTEITEMID | |
| SHIPMENTID (FK) |
nchar(12) |
NULLS |
(One) to (Many) | ERPSHIPMENT.ERPSHIPMENTID | |
| RECEIVABLEID (FK) |
nchar(12) |
NULLS |
(One) to (Many) | ERPRECEIVABLE.ERPRECEIVABLEID | |
| INVOICEID (FK) |
nchar(12) |
NULLS |
(One) to (Many) | ERPINVOICE.ERPINVOICEID | |
| INVOICEITEMID (FK) |
nchar(12) |
NULLS |
(One) to (Many) | ERPINVOICEITEM.ERPINVOICEITEMID | |
| DOCAMOUNT | float |
NULLS |
|||
| LINENUMBER | varchar(64) |
NULLS |
|||
| UNITADJUSTMENTAMOUNT | float |
NULLS |
|||
| DOCUNITADJUSTMENTAMOUNT | float |
NULLS |
|||
| DISTRIBUTEDTAXSOID | nchar(12) |
NULLS |
(One) to (Many) | SALESORDER.SALESORDERID | |
| DISTRIBUTEDTAXSOITEMID | nchar(12) |
NULLS |
(One) to (Many) | SALESORDERITEM.SALESORDERITEMSID | |
| CALCULATIONMETHODCODE | nvarchar(64) |
NULLS |
|||
| UNITADJUSTMENTAMOUNT | float | NULLS | |||
| DOCUNITADJUSTMENTAMOUNT | float | NULLS |