IM_Warehouse IM Warehouse Code Rel: 6.00 Bld: 1024 3/10/2020 Physical Path: "MAS_"+%C$+"/IM"+%C$+"/IM_Warehouse.M4T" SQL Create: Y SQL Sys DB: N SQL Null Dates: N Exclude V/I: N Create Tbl: N Bus Obj: IM_Warehouse_bus BM_ProductionRegister_upd BM_DisassemblyRegister_upd
KPRIMARY: WarehouseCode
Fld Column Name M/L TUR Description/Notes Class
1 WarehouseCode . . . . . . . . 3 SYY Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM Notes: {IMC$(1,3)} 2 WarehouseDesc . . . . . . . . 30 SNN Warehouse Description . . . . .DESCRIPTION Notes: {IMC$(4,30)} 3 WarehouseName . . . . . . . . 30 SNN Warehouse Name. . . . . . . . .NAME Notes: {IMC$(34,30)} 4 WarehouseAddress1 . . . . . . 30 SNN Warehouse Address Line 1. . . .ADDRESSLINE Notes: {IMC$(64,30)} 5 WarehouseAddress2 . . . . . . 30 SNN Warehouse Address Line 2. . . .ADDRESSLINE Notes: {IMC$(94,30)} 6 WarehouseAddress3 . . . . . . 30 SNN Warehouse Address Line 3. . . .ADDRESSLINE Notes: {IMC$(124,30)} 7 WarehouseCity . . . . . . . . 20 SNN Warehouse City. . . . . . . . .CITY 8 WarehouseState. . . . . . . . 2 SYN Warehouse State . . . . . . . .STATE 9 WarehouseZipCode. . . . . . . 10 SYN Warehouse Zip Code. . . . . . .ZIPCODE 10 WarehouseCountryCode. . . . . 3 SYN Warehouse Country Code. . . . .COUNTRY 11 TelephoneNo . . . . . . . . . 17 SNN Telephone Number. . . . . . . .TELEPHONENO 12 TelephoneExt. . . . . . . . . 5 SNN Telephone Extension . . . . . .TELEPHONEEXT 13 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO 14 EmailAddress. . . . . . . . . 50 SNN Email Address . . . . . . . . .EMAILADDRESS 15 ContactName . . . . . . . . . 30 SNN Contact Name. . . . . . . . . .NAME 16 WarehouseStatus . . . . . . . 1 SYY Warehouse Status. . . . . . . . DfltVal:A Valid:A,I,R Notes: A = Active, I = Inactive, R = Restricted 17 StatusComment . . . . . . . . 50 SNN Status Comment. . . . . . . . . 18 RestrictedStartDate . . . . . 8 SNN Resticted Start Date. . . . . .DATE 19 RestrictedEndDate . . . . . . 8 SNN Restricted End Date . . . . . .DATE 20 PostToGLSubAcct . . . . . . . 15 SYN Post To G/L Sub Account . . . .SUBACCOUNT Notes: {IMC$(154,15)} 21 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 22 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .TIME Read Only:Y 23 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 24 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 25 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .TIME Read Only:Y 26 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL