| Divisions |
char(15)
|
|
|
|
|
| CB_Trade_Discount |
tinyint
|
|
|
|
|
| FREIGHT |
tinyint
|
|
|
|
|
| MISC |
tinyint
|
|
|
|
|
| TAX |
tinyint
|
|
|
|
|
| Cost_Code_Number_Array_1_1 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_1_2 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_1_3 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_1_4 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_2_1 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_2_2 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_2_3 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_2_4 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_3_1 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_3_2 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_3_3 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_3_4 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_4_1 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_4_2 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_4_3 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_4_4 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_5_1 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_5_2 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_5_3 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_5_4 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_6_1 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_6_2 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_6_3 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_6_4 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_7_1 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_7_2 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_7_3 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_7_4 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_8_1 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_8_2 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_8_3 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_8_4 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_9_1 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_9_2 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_9_3 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_9_4 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_10_1 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_10_2 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_10_3 |
char(7)
|
|
|
|
|
| Cost_Code_Number_Array_10_4 |
char(7)
|
|
|
|
|
| Cost_Element_Array_1 |
smallint
|
|
|
|
|
| Cost_Element_Array_2 |
smallint
|
|
|
|
|
| Cost_Element_Array_3 |
smallint
|
|
|
|
|
| Cost_Element_Array_4 |
smallint
|
|
|
|
|
| Cost_Element_Array_5 |
smallint
|
|
|
|
|
| Cost_Element_Array_6 |
smallint
|
|
|
|
|
| Cost_Element_Array_7 |
smallint
|
|
|
|
|
| Cost_Element_Array_8 |
smallint
|
|
|
|
|
| Cost_Element_Array_9 |
smallint
|
|
|
|
|
| Cost_Element_Array_10 |
smallint
|
|
|
|
|
| Cost_Code_Desc_Array_1 |
char(31)
|
|
|
|
|
| Cost_Code_Desc_Array_2 |
char(31)
|
|
|
|
|
| Cost_Code_Desc_Array_3 |
char(31)
|
|
|
|
|
| Cost_Code_Desc_Array_4 |
char(31)
|
|
|
|
|
| Cost_Code_Desc_Array_5 |
char(31)
|
|
|
|
|
| Cost_Code_Desc_Array_6 |
char(31)
|
|
|
|
|
| Cost_Code_Desc_Array_7 |
char(31)
|
|
|
|
|
| Cost_Code_Desc_Array_8 |
char(31)
|
|
|
|
|
| Cost_Code_Desc_Array_9 |
char(31)
|
|
|
|
|
| Cost_Code_Desc_Array_10 |
char(31)
|
|
|
|
|
| CC_Account_Index_Array_1 |
int
|
|
|
|
|
| CC_Account_Index_Array_2 |
int
|
|
|
|
|
| CC_Account_Index_Array_3 |
int
|
|
|
|
|
| CC_Account_Index_Array_4 |
int
|
|
|
|
|
| CC_Account_Index_Array_5 |
int
|
|
|
|
|
| CC_Account_Index_Array_6 |
int
|
|
|
|
|
| CC_Account_Index_Array_7 |
int
|
|
|
|
|
| CC_Account_Index_Array_8 |
int
|
|
|
|
|
| CC_Account_Index_Array_9 |
int
|
|
|
|
|
| CC_Account_Index_Array_10 |
int
|
|
|
|
|
| USERID |
char(15)
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| User_Define_1 |
char(31)
|
|
|
|
|
| User_Define_2 |
char(31)
|
|
|
|
|
| USERDEF1 |
char(21)
|
UserDefine...(more) Join Now
|
|
|
|
| USERDEF2 |
char(21)
|
UserDefine...(more) Join Now
|
|
|
|
| User_Defined_CB_1 |
tinyint
|
|
|
|
|
| User_Defined_CB_2 |
tinyint
|
|
|
|
|
| User_Defined_CB_3 |
tinyint
|
|
|
|
|
| User_Defined_CB_4 |
tinyint
|
|
|
|
|
| USRDAT01 |
datetime
|
|
|
|
|
| USRDAT02 |
datetime
|
|
|
|
|
| User_Defined_Date_3 |
datetime
|
|
|
|
|
| User_Defined_Date_4 |
datetime
|
|
|
|
|
| User_Defined_Dollar_1 |
numeric(19,5)
|
|
|
|
|
| User_Defined_Dollar_2 |
numeric(19,5)
|
|
|
|
|
| User_Defined_Dollar_3 |
numeric(19,5)
|
|
|
|
|
| User_Defined_Dollar_4 |
numeric(19,5)
|
|
|
|
|
| User_Def_Integer_1 |
int
|
|
|
|
|
| User_Def_Integer_2 |
int
|
|
|
|
|
| User_Defined_Integer_3 |
int
|
|
|
|
|
| User_Defined_Integer_4 |
int
|
|
|
|
|
| Wennsoft_Affiliate |
char(15)
|
|
|
|
|
| Wennsoft_Branch |
char(15)
|
|
|
|
|
| Wennsoft_Region |
char(15)
|
|
|
|
|
| SV_Language_ID |
smallint
|
|
|
|
|
| Time_Zone |
char(3)
|
|
|
|
|
| MODIFDT |
datetime
|
Date the r...(more) Join Now
|
|
|
|
| Modified_Time |
datetime
|
|
|
|
|
| MDFUSRID |
char(15)
|
User that ...(more) Join Now
|
|
|
join ... more text available
|
| WSReserved_CB1 |
tinyint
|
|
|
|
|
| WSReserved_CB2 |
tinyint
|
|
|
|
|
| WSReserved_CB3 |
tinyint
|
|
|
|
|
| WSReserved_CB4 |
tinyint
|
|
|
|
|
| WSReserved_CB5 |
tinyint
|
|
|
|
|
| WSReserved_STR1 |
char(11)
|
|
|
|
|
| WSReserved_STR2 |
char(11)
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|