| Service_Call_ID |
char(17)
|
|
|
|
|
| Call_Invoice_Number |
char(17)
|
|
|
|
|
| Wennsoft_Affiliate |
char(15)
|
|
|
|
|
| Wennsoft_Region |
char(15)
|
|
|
|
|
| Wennsoft_Branch |
char(15)
|
|
|
|
|
| USERID |
char(15)
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| Technician_ID |
char(15)
|
|
|
|
|
| Technician_Team |
char(15)
|
|
|
|
|
| Reference_TRX_Number |
char(17)
|
|
|
|
|
| CUSTNMBR |
char(15)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| ADRSCODE |
char(15)
|
Field Type...(more) Join Now
|
|
|
|
| SEQNUMBR |
int
|
Field Type...(more) Join Now
|
|
|
|
| Job_Name |
char(31)
|
|
|
|
|
| Job_Type |
char(7)
|
|
|
|
|
| WS_Cost_Code |
int
|
|
|
|
|
| Cost_Code_Description |
char(31)
|
|
|
|
|
| Task_Code |
char(11)
|
|
|
|
|
| DOCTYPE |
smallint
|
Document T...(more) Join Now
|
PM10000.DOCTYPE
|
|
|
| DOCAMNT |
numeric(19,5)
|
Field Type...(more) Join Now
|
|
|
|
| DOCDATE |
datetime
|
Document D...(more) Join Now
|
PM10000.DOCDATE
|
|
|
| TRXDSCRN |
char(31)
|
Transactio...(more) Join Now
|
PM10000.TRXDSCRN
|
|
|
| Billable_Check_Box |
tinyint
|
|
|
|
|
| TAXABLE |
tinyint
|
Taxable: ...(more) Join Now
|
UPR00400.TAXABLE
|
|
|
| TRXSOURC |
char(25)
|
|
|
|
|
| Billing_Amount |
numeric(19,5)
|
|
|
|
|
| VENDORID |
char(15)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| VENDNAME |
char(65)
|
Vendor Nam...(more) Join Now
|
POP30300.VENDNAME
|
|
|
| Equipment_ID |
char(31)
|
|
|
|
|
| Equipment_Type |
char(31)
|
|
|
|
|
| Dynamics_Status |
char(5)
|
|
|
|
|
| Wennsoft_Status |
char(5)
|
|
|
|
|
| BACHNUMB |
char(15)
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| BCHSOURC |
char(15)
|
Batch Sour...(more) Join Now
|
|
|
|
| TRXHRUNT |
int
|
|
|
|
|
| EMPLOYID |
char(15)
|
Employee I...(more) Join Now
|
UPR00100.EMPLOYID
|
|
join ... more text available
|
| EMPLNAME |
char(41)
|
|
|
|
|
| VCHNUMWK |
char(17)
|
Voucher Nu...(more) Join Now
|
PM10000.VCHNUMWK
|
|
|
| OH_Amount |
numeric(19,5)
|
|
|
|
|
| EXTDCOST |
numeric(19,5)
|
Field Type...(more) Join Now
|
|
|
|
| WS_Extended_Cost |
numeric(19,5)
|
|
|
|
|
| TRXQTY |
numeric(19,5)
|
TRX QTY: T...(more) Join Now
|
|
|
|
| UOFM |
char(9)
|
Field Type...(more) Join Now
|
|
|
See I... more text available
|
| ITEMNMBR |
char(31)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| ITEMDESC |
char(101)
|
Field Type...(more) Join Now
|
|
|
|
| UNITPRCE |
numeric(19,5)
|
Field Type...(more) Join Now
|
|
|
|
| JOBTITLE |
char(7)
|
Job Title:...(more) Join Now
|
UPR00100.JOBTITLE
|
|
|
| PAYRCORD |
char(7)
|
Pay Record...(more) Join Now
|
UPR40600.PAYRCORD
|
|
|
| PAYRATE |
numeric(19,5)
|
|
|
|
|
| Billing_Rate |
numeric(19,5)
|
|
|
|
|
| Add_New_Equipment_Record |
tinyint
|
|
|
|
|
| New_Equipment_ID |
char(11)
|
|
|
|
|
| Wennsoft_Model_Number |
char(21)
|
|
|
|
|
| Wennsoft_Serial_Number |
char(41)
|
|
|
|
|
| Manufacturer_ID |
char(15)
|
|
|
|
|
| Note_Checkbox |
tinyint
|
|
|
|
|
| Service_User_Define_1 |
char(21)
|
|
|
|
|
| Service_User_Define_2 |
char(21)
|
|
|
|
|
| Service_User_Define_5 |
int
|
|
|
|
|
| Service_User_Define_6 |
int
|
|
|
|
|
| Service_User_Define_7 |
int
|
|
|
|
|
| Service_User_Define_8 |
int
|
|
|
|
|
| Service_User_Define_9 |
datetime
|
|
|
|
|
| Service_User_Define_10 |
datetime
|
|
|
|
|
| Service_User_Define_11 |
datetime
|
|
|
|
|
| Service_User_Define_12 |
datetime
|
|
|
|
|
| Service_User_Define_18 |
tinyint
|
|
|
|
|
| Service_User_Define_19 |
tinyint
|
|
|
|
|
| Service_User_Define_20 |
tinyint
|
|
|
|
|
| Service_User_Define_21 |
tinyint
|
|
|
|
|
| Service_User_Define_22 |
numeric(19,5)
|
|
|
|
|
| Service_User_Define_23 |
numeric(19,5)
|
|
|
|
|
| Service_User_Define_24 |
numeric(19,5)
|
|
|
|
|
| Service_User_Define_25 |
numeric(19,5)
|
|
|
|
|
| MODIFDT |
datetime
|
Date the r...(more) Join Now
|
|
|
|
| Modified_Time |
datetime
|
|
|
|
|
| MDFUSRID |
char(15)
|
User that ...(more) Join Now
|
|
|
join ... more text available
|
| Time_Zone |
char(3)
|
|
|
|
|
| SV_Language_ID |
smallint
|
|
|
|
|
| Base_Currency_ID |
char(15)
|
|
|
|
|
| Base_Curr_Conv_Factor |
numeric(19,7)
|
|
|
|
|
| Billing_Currency_ID |
char(15)
|
|
|
|
|
| Billing_Curr_Conv_Factor |
numeric(19,7)
|
|
|
|
|
| Local_Currency_ID |
char(15)
|
|
|
|
|
| WSReserved_CB1 |
tinyint
|
|
|
|
|
| WSReserved_CB2 |
tinyint
|
|
|
|
|
| WSReserved_CB3 |
tinyint
|
|
|
|
|
| WSReserved_CB4 |
tinyint
|
|
|
|
|
| WSReserved_CB5 |
tinyint
|
|
|
|
|
| WSReserved_CB6 |
tinyint
|
|
|
|
|
| WSReserved_CB7 |
tinyint
|
|
|
|
|
| WSReserved_CB8 |
tinyint
|
|
|
|
|
| WSReserved_CB9 |
tinyint
|
|
|
|
|
| WSReserved_CB10 |
tinyint
|
|
|
|
|
| WSReserved_STR1 |
char(11)
|
|
|
|
|
| WSReserved_STR2 |
char(11)
|
|
|
|
|
| Subcontractor_Percent |
int
|
|
|
|
|
| JRNENTRY |
int
|
Journal En...(more) Join Now
|
GL20000.JRNENTRY
|
|
|
| OH_ACTINDX_CR |
int
|
|
|
|
|
| OH_ACTINDX_DR |
int
|
|
|
|
|
| Divisions |
char(15)
|
|
|
|
|
| UNITCOST |
numeric(19,5)
|
Field Type...(more) Join Now
|
|
|
|
| Added_Rate |
tinyint
|
|
|
|
|
| Travel_Transaction |
tinyint
|
|
|
|
|
| WS_Other_Cost_Sub_Code |
int
|
|
|
|
|
| TRXHRUNTBILL |
int
|
|
|
|
|
| TRXQTYBILL |
numeric(19,5)
|
|
|
|
|
| ACTINDX_CR |
int
|
|
|
|
|
| ACTINDX_DR |
int
|
|
|
|
|
| Labor_Group_Name |
char(15)
|
|
|
|
|
| Pricing_Matrix_Name |
char(15)
|
|
|
|
|
| GLPOSTDT |
datetime
|
GLPostingDate GL Date that posts distributions when the transaction was posted
|
PAM30900.GLPOSTDT
|
|
|
| Import_Journal_Number |
char(15)
|
|
|
|
|
| Import_Journal_Number_Count |
smallint
|
|
|
|
|
| Import_Status |
char(15)
|
|
|
|
|
| Import_Status_Descriptio |
char(89)
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|