EDCEI006 - Intrastat Select DropShip
Dynamics GP table EDCEI006 (Intrastat Select DropShip) contains 7 columns including SOPNUMBE, SOPTYPE, CMPNTSEQ....
SQL Query Builder
7 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| SOPNUMBE | SOP Number | String | 22 | ||
| SOPTYPE | SOP Type1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order (In SBF, this value is not available.) | Integer | 2 | ||
SOP Document Type values (6) 1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order | |||||
| CMPNTSEQ | Component Sequence | Long Integer | 4 | ||
| LNITMSEQ | Line Item Sequence | Long Integer | 4 | ||
| ITEMNMBR | Item Number | String | 32 | ||
| ITEMDESC | Item Description | String | 102 | ||
| DESELCTD | DESelected | Boolean | 2 | ||
Related Tables
Tables that share columns with EDCEI006. Click "Join" to add to your query.
DESELCTD