EDCEI018 - Intrastat Invoice Setup
SQL Query Builder
14 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| DOCID | char '' | ||||
| SOPTYPE | smallint 0 | ||||
SOP Document Type values (6) 1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order | |||||
| NOTEINDX | numeric 0.00 | ||||
| SOPNUMBE | char '' | ||||
| SOPSTATUSACTIVE_1 | tinyint 0 | ||||
| SOPSTATUSACTIVE_2 | tinyint 0 | ||||
| SOPSTATUSACTIVE_3 | tinyint 0 | ||||
| SOPSTATUSACTIVE_4 | tinyint 0 | ||||
| SOPSTATUSACTIVE_5 | tinyint 0 | ||||
| SOPSTATUSACTIVE_6 | tinyint 0 | ||||
| SOPSTATUSACTIVE_7 | tinyint 0 | ||||
| SOPSTATUSACTIVE_8 | tinyint 0 | ||||
| SOPSTATUSACTIVE_9 | tinyint 0 | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Related Tables
Tables that share columns with EDCEI018. Click "Join" to add to your query.