| WS_Job_Number |
char(17)
|
|
|
|
|
| BACHNUMB |
char(15)
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| BCHSOURC |
char(15)
|
Batch Sour...(more) Join Now
|
|
|
|
| JRNENTRY |
int
|
Journal En...(more) Join Now
|
GL20000.JRNENTRY
|
|
|
| SQNCLINE |
numeric(19,5)
|
Sequence L...(more) Join Now
|
VAT10302.SQNCLINE
|
|
|
| Product_Indicator |
smallint
|
Product In...(more) Join Now
|
POP10110.Product_Indicator
|
|
|
| ACTINDX |
int
|
Account In...(more) Join Now
|
UPR00100.ACTINDX
|
|
join ... more text available
|
| Service_Call_ID |
char(17)
|
|
|
|
|
| Project_Number |
char(17)
|
|
|
|
|
| Cost_Code_Number_1 |
char(7)
|
|
|
|
|
| Cost_Code_Number_2 |
char(7)
|
|
|
|
|
| Cost_Code_Number_3 |
char(7)
|
|
|
|
|
| Cost_Code_Number_4 |
char(7)
|
|
|
|
|
| Cost_Code_Description |
char(31)
|
|
|
|
|
| Cost_Element |
smallint
|
|
|
|
|
| WS_Cost_Code |
int
|
|
|
|
|
| WS_Other_Cost_Sub_Code |
int
|
|
|
|
|
| Equipment_ID |
char(31)
|
|
|
|
|
| CRDTAMNT |
numeric(19,5)
|
Credit Amo...(more) Join Now
|
GL20000.CRDTAMNT
|
|
|
| DEBITAMT |
numeric(19,5)
|
Debit Amou...(more) Join Now
|
GL20000.DEBITAMT
|
|
|
| ORCRDAMT |
numeric(19,5)
|
Originatin...(more) Join Now
|
GL20000.ORCRDAMT
|
|
|
| ORDBTAMT |
numeric(19,5)
|
Originatin...(more) Join Now
|
GL20000.ORDBTAMT
|
|
|
| DSCRIPTN |
char(31)
|
Descriptio...(more) Join Now
|
CM20200.DSCRIPTN
|
|
|
| Profit_Type_Number |
smallint
|
1 = ...(more) Join Now
|
JC00701.Profit_Type_Number
|
|
|
| Profit_Amount |
numeric(19,5)
|
|
|
|
|
| TRXQTY |
numeric(19,5)
|
TRX QTY: T...(more) Join Now
|
IV10001.TRXQTY
|
|
|
| PSTGSTUS |
smallint
|
Posting St...(more) Join Now
|
RM10301.PSTGSTUS
|
|
|
| GLLINMSG |
binary(4)
|
|
|
|
|
| GLLINMS2 |
binary(4)
|
|
|
|
|
| GLLINVAL |
binary(4)
|
|
|
|
|
| ACCTTYPE |
smallint
|
|
|
|
|
| FXDORVAR |
smallint
|
|
|
|
|
| BALFRCLC |
smallint
|
|
|
|
|
| PSTNGTYP |
smallint
|
|
|
|
|
| DECPLACS |
smallint
|
Decimal Pl...(more) Join Now
|
SVC00600.DECPLACS
|
|
|
| PORDNMBR |
char(21)
|
Purchase O...(more) Join Now
|
PM10000.PORDNMBR
|
|
|
| Rate_Per_Unit |
numeric(19,5)
|
|
|
|
|
| Billing_Amount |
numeric(19,5)
|
|
|
|
|
| VENDORID |
char(15)
|
Vendor ID:...(more) Join Now
|
PM10000.VENDORID
|
|
join ... more text available
|
| EMPLOYID |
char(15)
|
Employee I...(more) Join Now
|
UPR00100.EMPLOYID
|
|
join ... more text available
|
| ITEMNMBR |
char(31)
|
span style...(more) Join Now
|
IV00101.ITEMNMBR
|
|
join ... more text available
|
| ITEMDESC |
char(101)
|
Item Descr...(more) Join Now
|
BM10300.ITEMDESC
|
|
|
| USERID |
char(15)
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| WS_Transaction_Date |
datetime
|
|
|
|
|
| OH_Amount |
numeric(19,5)
|
|
|
|
|
| OH_ACTINDX_CR |
int
|
|
|
|
|
| OH_ACTINDX_DR |
int
|
|
|
|
|
| Divisions |
char(15)
|
|
|
|
|
| TRXHRUNT |
int
|
|
|
|
|
| Payroll_Pay_Type |
smallint
|
|
|
|
|
| PAYRCORD |
char(7)
|
Pay Record...(more) Join Now
|
UPR40600.PAYRCORD
|
|
|
| PAYRATE |
numeric(19,5)
|
|
|
|
|
| DEPRTMNT |
char(7)
|
Department...(more) Join Now
|
UPR00100.DEPRTMNT
|
|
join ... more text available
|
| JOBTITLE |
char(7)
|
Job Title:...(more) Join Now
|
UPR00100.JOBTITLE
|
|
|
| PAYRTAMT |
numeric(19,5)
|
Pay Rate A...(more) Join Now
|
UPR40600.PAYRTAMT
|
|
|
| UPRTRXCD |
char(7)
|
|
|
|
|
| UOFM |
char(9)
|
U Of M: T...(more) Join Now
|
IV10001.UOFM
|
|
See I... more text available
|
| CURNCYID |
char(15)
|
Currency I...(more) Join Now
|
CM20000
|
|
join ... more text available
|
| CURRNIDX |
smallint
|
Currency I...(more) Join Now
|
CM20200.CURRNIDX
|
|
join ... more text available
|
| RTCLCMTD |
smallint
|
Rate Calcu...(more) Join Now
|
CM20200.RTCLCMTD
|
|
|
| XCHGRATE |
numeric(19,7)
|
Exchange R...(more) Join Now
|
CM20200.XCHGRATE
|
|
|
| DENXRATE |
numeric(19,7)
|
Denominati...(more) Join Now
|
CM20200.DENXRATE
|
|
|
| INTERID |
char(5)
|
|
|
|
|
| RATETPID |
char(15)
|
A valid Ra...(more) Join Now
|
|
|
|
| EXGTBLID |
char(15)
|
Exchange T...(more) Join Now
|
CM20200.EXGTBLID
|
|
|
| EXCHDATE |
datetime
|
Exchange D...(more) Join Now
|
CM20200.EXCHDATE
|
|
|
| PONUMBER |
char(17)
|
PO Number ...(more) Join Now
|
POP10110.PONUMBER
|
|
|
| TIME1 |
datetime
|
Time see ...(more) Join Now
|
CM20200.TIME1
|
|
|
| Labor_Group_Name |
char(15)
|
|
|
|
|
| Pricing_Matrix_Name |
char(15)
|
|
|
|
|
| Wennsoft_Affiliate |
char(15)
|
|
|
|
|
| Wennsoft_Region |
char(15)
|
|
|
|
|
| Wennsoft_Branch |
char(15)
|
|
|
|
|
| MODIFDT |
datetime
|
Date the r...(more) Join Now
|
|
|
|
| Modified_Time |
datetime
|
|
|
|
|
| MDFUSRID |
char(15)
|
User that ...(more) Join Now
|
|
|
join ... more text available
|
| SV_Language_ID |
smallint
|
|
|
|
|
| Time_Zone |
char(3)
|
|
|
|
|
| User_Define_1 |
char(31)
|
|
|
|
|
| User_Define_2 |
char(31)
|
|
|
|
|
| USERDEF1 |
char(21)
|
UserDefine...(more) Join Now
|
CM20200.USERDEF1
|
|
|
| USERDEF2 |
char(21)
|
UserDefine...(more) Join Now
|
CM20200.USERDEF2
|
|
|
| User_Def_Integer_1 |
int
|
|
|
|
|
| User_Def_Integer_2 |
int
|
|
|
|
|
| User_Defined_Integer_3 |
int
|
|
|
|
|
| User_Defined_Integer_4 |
int
|
|
|
|
|
| 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)
|
|
|
|
|
| USRDAT01 |
datetime
|
|
|
|
|
| USRDAT02 |
datetime
|
|
|
|
|
| USRDAT03 |
datetime
|
|
|
|
|
| User_Defined_Date2_4 |
datetime
|
|
|
|
|
| User_Defined_CB_1 |
tinyint
|
|
|
|
|
| User_Defined_CB_2 |
tinyint
|
|
|
|
|
| User_Defined_CB_3 |
tinyint
|
|
|
|
|
| User_Defined_CB_4 |
tinyint
|
|
|
|
|
| WSReserved_CB1 |
tinyint
|
|
|
|
|
| WSReserved_CB2 |
tinyint
|
|
|
|
|
| WSReserved_CB3 |
tinyint
|
|
|
|
|
| WSReserved_CB4 |
tinyint
|
|
|
|
|
| WSReserved_CB5 |
tinyint
|
|
|
|
|
| WSReserved_STR1 |
char(11)
|
|
|
|
|
| WSReserved_STR2 |
char(11)
|
|
|
|
|
| OPENYEAR |
smallint
|
Open Year:...(more) Join Now
|
GL20000.OPENYEAR
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|