IV40700 - Site Setup
Stores inventory site/warehouse configuration.
SQL Query Builder
33 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| LOCNCODE | char(11) '' | ||||
| LOCNDSCR | char(31) '' | ||||
| NOTEINDX | numeric(19,5) 0.00 | ||||
| ADDRESS1 | char(61) '' | ||||
| ADDRESS2 | char(61) '' | ||||
| ADDRESS3 | char(61) '' | ||||
| CITY | char(35) '' | ||||
| STATE | char(29) '' | ||||
| ZIPCODE | char(11) '' | ||||
| COUNTRY | char(61) '' | ||||
| PHONE1 | char(21) '' | ||||
| PHONE2 | char(21) '' | ||||
| PHONE3 | char(21) '' | ||||
| FAXNUMBR | char(21) '' | ||||
| Location_Segment | char(67) '' | ||||
| STAXSCHD | char(15) '' | ||||
| PCTAXSCH | char(15) '' | ||||
| INCLDDINPLNNNG | tinyint 0 | ||||
| PORECEIPTBIN | char(15) '' | ||||
| PORETRNBIN | char(15) '' | ||||
| SOFULFILLMENTBIN | char(15) '' | ||||
| SORETURNBIN | char(15) '' | ||||
| BOMRCPTBIN | char(15) '' | ||||
| MATERIALISSUEBIN | char(15) '' | ||||
| MORECEIPTBIN | char(15) '' | ||||
| REPAIRISSUESBIN | char(15) '' | ||||
| WMSINT | tinyint 0 | ||||
| PICKTICKETSITEOPT | smallint 0 | ||||
| BINBREAK | smallint 0 | ||||
| CCode | char(7) '' | ||||
| DECLID | char(15) '' | ||||
| INACTIVE | tinyint 0 | ||||
Active Status values (2) 0 = Active1 = Inactive | |||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Related Tables
Tables that share columns with IV40700. Click "Join" to add to your query.