| Name | Description | Type | Additional information |
|---|---|---|---|
| WHCODE | string |
None. |
|
| NAME | string |
None. |
|
| ADR1 | string |
None. |
|
| ADR2 | string |
None. |
|
| ADR3 | string |
None. |
|
| CITY | string |
None. |
|
| STATE | string |
None. |
|
| LONGITUDE | decimal number |
None. |
|
| LATITUDE | decimal number |
None. |
|
| COUNTRY | string |
None. |
|
| COUNTY | string |
None. |
|
| REGION | string |
None. |
|
| ZIP | string |
None. |
|
| TEL1 | string |
None. |
|
| FAX1 | string |
None. |
|
| CCODE | string |
None. |
|
| WHTYPE | string |
None. |
|
| SHIP_CODE | string |
None. |
|
| SHIPFROM | string |
None. |
|
| CALC_AVERAGE | string |
None. |
|
| CALC_AVAILABILITY | string |
None. |
|
| ECOMMERCE_PUBLISH | string |
None. |
|
| AUTOMATED_WAREHOUSE | string |
None. |
|
| ADD_COST_CAP | string |
None. |
|
| ADD_PO_GL_ACCOUNT | string |
None. |
|
| PUBLISH | string |
None. |
|
| INTERNAL_USE | string |
None. |
|
| DO_NOT_SHOW_IN_PMR | string |
None. |
|
| OWNER_TYPE | string |
None. |
|
| OWNER_ACCTNO | string |
None. |
|
| OWNER_SUBC | string |
None. |
|
| GL_ACCOUNT | string |
None. |
|
| GL_DB_CODE | string |
None. |
|
| GL_CR_CODE | string |
None. |
|
| DELTA_GL_DEBIT_CODE | string |
None. |
|
| DELTA_GL_CREDIT_CODE | string |
None. |
|
| WHTRANSFER_GL_ACCOUNT | string |
None. |
|
| PO_GL_ACCOUNT | string |
None. |
|
| COMPANYNO | integer |
None. |
|
| DIVISION | string |
None. |
|
| DEPART | string |
None. |
|
| LOT_TYPE | string |
None. |
|
| LOT_QUARANTIN | string |
None. |
|
| LOT_DATE | date |
None. |
|
| LOT_VALUE | decimal number |
None. |
|
| LOT_QPARTS | decimal number |
None. |
|
| LOT_TOTALCOST | decimal number |
None. |
|
| LOT_TOTALSELL | decimal number |
None. |
|
| LOT_TOTALSELL_EXCLUDE_TAX | decimal number |
None. |
|
| C_LOT_TOTALSELL_EXCLUDE_TAX | decimal number |
None. |
|
| CALC_LOT_BALANCE_INCLUDE_TAX | string |
None. |
|
| LOT_COSTFROMWH | string |
None. |
|
| IGNORE_EXPENSED_COST | string |
None. |
|
| LOT_PERCENT | decimal number |
None. |
|
| LOT_COST_VALUE | decimal number |
None. |
|
| LOT_SELL_VALUE | decimal number |
None. |
|
| LOT_PURCHASE_COST | decimal number |
None. |
|
| MANUAL_LOT_ADJUSTMENT | decimal number |
None. |
|
| WH_TRANSFER_ADJUSTMENT | decimal number |
None. |
|
| ATTACH_MISC_INVOICE | decimal number |
None. |
|
| PROFIT_NET_GROSS | string |
None. |
|
| TAX_A_CODE | string |
None. |
|
| CURENCY_BASE | string |
None. |
|
| CURENCY_CONV | string |
None. |
|
| CURENCY_STATE | string |
None. |
|
| CURENCY_FACTOR | decimal number |
None. |
|
| CURENCY_DATE | date |
None. |
|
| C_LOT_VALUE | decimal number |
None. |
|
| C_LOT_TOTALCOST | decimal number |
None. |
|
| C_LOT_TOTALSELL | decimal number |
None. |
|
| C_LOT_COSTFROMWH | string |
None. |
|
| C_LOT_COST_VALUE | decimal number |
None. |
|
| C_LOT_SELL_VALUE | decimal number |
None. |
|
| C_LOT_PURCHASE_COST | decimal number |
None. |
|
| C_MANUAL_LOT_ADJUSTMENT | decimal number |
None. |
|
| C_WH_TRANSFER_ADJUSTMENT | decimal number |
None. |
|
| C_ATTACH_MISC_INVOICE | decimal number |
None. |
|
| REGISTRATION_NO | string |
None. |
|
| REGISTRATION_UPD | date |
None. |
|
| REGISTRATION_VALID | date |
None. |
|
| HIGHT | decimal number |
None. |
|
| WIDTH | decimal number |
None. |
|
| LENGTH | decimal number |
None. |
|
| UM | string |
None. |
|
| ADD_TO_PROJECT | string |
None. |
|
| CITY_CODE | string |
None. |
|
| ISACTIVE | string |
None. |
|
| SPEC2000 | string |
None. |
|
| FIRST_ACTION_CODE | string |
None. |
|
| SECOND_ACTION_CODE | string |
None. |
|
| THIRD_ACTION_CODE | string |
None. |
|
| SIS_ACCOUNT | string |
None. |
|
| SIS_PASSWORD | string |
None. |
|
| PARTS_COST_PERCENT | decimal number |
None. |
|
| RECLOCK | string |
None. |
|
| ADDED_USR | string |
None. |
|
| ADDED_DTE | date |
None. |
|
| UPDATED_USR | string |
None. |
|
| UPDATED_DTE | date |
None. |