| WS_Job_Number |
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
|
|
|
|
|
| Job_TRX_Number |
char(21)
|
|
|
|
|
| Document_Source |
char(3)
|
GL = Journ...(more) Join Now
|
|
|
|
| TRXSORCE |
char(13)
|
Transactio...(more) Join Now
|
|
|
|
| JRNENTRY |
int
|
Journal En...(more) Join Now
|
GL20000.JRNENTRY
|
|
|
| ACTINDX |
int
|
Account In...(more) Join Now
|
UPR00100.ACTINDX
|
|
join ... more text available
|
| DISTTYPE |
smallint
|
|
Distribution
Type
|
Integer Value
|
Sales /
Invoices
|
Sched
Payments
|
Debit
Memos
|
Finance
Charges
|
Service
Repairs
|
Warranty
|
Credit
Memos
|
Returns
|
Cash
Receipts
|
|
Cash
|
1
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
*
|
|
Terms Taken
|
2
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
*
|
|
Accts Rec
|
3
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
*
|
|
Writeoffs
|
4
|
|
na
|
|
|
|
|
*
|
*
|
*
|
|
Terms Avail
|
5
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
*
|
|
GST
|
6
|
|
na
|
|
|
|
|
*
|
*
|
*
|
|
PPS
|
7
|
|
na
|
|
|
|
|
*
|
*
|
*
|
|
Other
|
8
|
*
|
na
|
*
|
*
|
*
|
*
|
*
|
*
|
*
|
|
Sales
|
9
|
*
|
na
|
|
|
|
|
|
|
|
|
Trade
|
10
|
*
|
na
|
*
|
*
|
*
|
*
|
*
|
*
|
|
|
Freight
|
11
|
*
|
na
|
*
|
*
|
*
|
*
|
*
|
*
|
|
|
Miscellaneous
|
12
|
*
|
na
|
*
|
*
|
*
|
*
|
*
|
*
|
|
|
Taxes
|
13
|
*
|
na
|
*
|
*
|
*
|
*
|
*
|
*
|
|
|
COGS
|
14
|
*
|
na
|
*
|
*
|
*
|
*
|
*
|
*
|
|
|
Inventory
|
15
|
*
|
na
|
*
|
*
|
*
|
*
|
*
|
*
|
|
|
Finance Chrg
|
16
|
|
na
|
|
*
|
|
|
|
|
|
|
Returns
|
17
|
|
na
|
|
|
|
|
|
*
|
|
|
Debit Memo
|
18
|
|
na
|
*
|
|
|
|
|
|
|
|
Credit Memo
|
19
|
|
na
|
|
|
|
|
*
|
|
|
|
Service
|
20
|
|
na
|
|
|
*
|
|
|
|
|
|
Warr Exp
|
21
|
|
na
|
|
|
|
*
|
|
|
|
|
Warr Sls
|
22
|
|
na
|
|
|
|
*
|
|
|
|
|
Comm Exp
|
23
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
|
|
Comm Pay
|
24
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
|
|
Unit Acc
|
25
|
*
|
na
|
*
|
*
|
*
|
*
|
*
|
*
|
*
|
|
ROUND
|
26
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
*
|
|
RZGain
|
27
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
*
|
|
RZLOSS
|
28
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
*
|
|
URZGain
|
29
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
*
|
|
URZLoss
|
30
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
*
|
|
RVLPD030.DISTTYPE
|
|
|
| DOCNUMBR |
char(21)
|
Document N...(more) Join Now
|
PM10000.DOCNUMBR
|
|
|
| LNSEQNBR |
numeric(19,5)
0
|
Line SEQ N...(more) Join Now
|
|
|
|
| PYADNMBR |
int
|
|
|
|
|
| TRXDSCRN |
char(31)
|
Transactio...(more) Join Now
|
PM10000.TRXDSCRN
|
|
|
| Cost_Code_Act_Cost_TTD |
numeric(19,5)
|
|
|
|
|
| Cost_Code_Actual_Org_Cst |
numeric(19,5)
|
|
|
|
|
| DOCDATE |
datetime
|
Document D...(more) Join Now
|
PM10000.DOCDATE
|
|
|
| DOCAMNT |
numeric(19,5)
|
Source Doc...(more) Join Now
|
PM10000.DOCAMNT
|
|
|
| DOCTYPE |
smallint
|
Document T...(more) Join Now
|
PM10000.DOCTYPE
|
|
|
| GLPOSTDT |
datetime
|
GLPostingDate GL Date that posts distributions when the transaction was posted
|
PAM30900.GLPOSTDT
|
|
|
| Profit_Type_Number |
smallint
|
1 = ...(more) Join Now
|
|
|
|
| Profit_Amount |
numeric(19,5)
|
|
|
|
|
| Job_Type |
char(7)
|
|
|
|
|
| IVDOCTYP |
smallint
|
IV Documen...(more) Join Now
|
IV10000.IVDOCTYP
|
|
|
| VENDORID |
char(15)
|
Vendor ID:...(more) Join Now
|
PM10000.VENDORID
|
|
join ... more text available
|
| ITEMNMBR |
char(31)
|
span style...(more) Join Now
|
|
|
join ... more text available
|
| UOFM |
char(9)
|
U Of M: T...(more) Join Now
|
IV10001.UOFM
|
|
See I... more text available
|
| TRXQTY |
numeric(19,5)
|
TRX QTY: T...(more) Join Now
|
IV10001.TRXQTY
|
|
|
| TRX_QTY_PR |
int
|
|
|
|
|
| TRXLOCTN |
char(11)
|
TRX Locati...(more) Join Now
|
IV10001.TRXLOCTN
|
|
|
| UNITCOST |
numeric(19,5)
|
Unit Cost:...(more) Join Now
|
IV10001.UNITCOST
|
|
|
| BACHNUMB |
char(15)
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| BCHSOURC |
char(15)
|
Batch Sour...(more) Join Now
|
|
|
|
| EMPLOYID |
char(15)
|
Employee I...(more) Join Now
|
UPR00100.EMPLOYID
|
|
join ... more text available
|
| Payroll_Pay_Type |
smallint
|
|
|
|
|
| COMPTRTP |
smallint
|
|
|
|
|
| UPRTRXCD |
char(7)
|
|
|
|
|
| TRXHRUNT |
int
|
|
|
|
|
| PAYRTAMT |
numeric(19,5)
|
Pay Rate A...(more) Join Now
|
UPR40600.PAYRTAMT
|
|
|
| VARDBAMT |
numeric(19,5)
|
|
|
|
|
| Transaction_Pay_Period |
smallint
|
|
|
|
|
| TRXBEGDT |
datetime
|
|
|
|
|
| TRXENDDT |
datetime
|
|
|
|
|
| WS_Transaction_Date |
datetime
|
|
|
|
|
| Unit_Decimal_Places |
smallint
|
|
|
|
|
| Cost_Decimal_Places |
smallint
|
|
|
|
|
| Ovrhd_1_Unit_Dec_Places |
smallint
|
|
|
|
|
| Overhead_1_Cst_Dec_Plcs |
smallint
|
|
|
|
|
| Overhead_Units_1 |
numeric(19,5)
|
|
|
|
|
| Overhead_1_Cst_Per_Unit |
numeric(19,5)
|
|
|
|
|
| Overhead_1_Pct_Rate |
numeric(19,5)
|
|
|
|
|
| UNIONCD |
char(7)
|
Union Code...(more) Join Now
|
UPR00100.UNIONCD
|
|
|
| DAYSWRDK |
int
|
|
|
|
|
| WKSWRKD |
int
|
|
|
|
|
| DEPRTMNT |
char(7)
|
Department...(more) Join Now
|
UPR00100.DEPRTMNT
|
|
join ... more text available
|
| JOBTITLE |
char(7)
|
Job Title:...(more) Join Now
|
UPR00100.JOBTITLE
|
|
|
| STATECD |
char(3)
|
State Code...(more) Join Now
|
UPR00300.STATECD
|
|
|
| LOCALTAX |
char(7)
|
Local Tax:...(more) Join Now
|
UPR00300.LOCALTAX
|
|
|
| SUTASTAT |
char(3)
|
Suta State...(more) Join Now
|
UPR00100.SUTASTAT
|
|
|
| WRKRCOMP |
char(7)
|
Workers Co...(more) Join Now
|
|
|
|
| FEDCLSSCD |
char(11)
|
Federal
...(more) Join Now
|
UPR00100.FEDCLSSCD
|
|
|
| Production_Actual_Qty |
numeric(19,5)
|
|
|
|
|
| Est_Pct_Complete_to_Date |
smallint
|
|
|
|
|
| Overhead_Group_Code |
char(5)
|
|
|
|
|
| Labor_Fixed_OH |
numeric(19,5)
|
|
|
|
|
| Labor_OH_Percentage |
int
|
|
|
|
|
| Certified_Payroll |
tinyint
|
|
|
|
|
| Monday |
int
|
|
|
|
|
| Tuesday |
int
|
|
|
|
|
| Wednesday |
int
|
|
|
|
|
| Thursday |
int
|
|
|
|
|
| Friday |
int
|
|
|
|
|
| Saturday |
int
|
|
|
|
|
| Sunday |
int
|
|
|
|
|
| PSTGSTUS |
smallint
|
Posting St...(more) Join Now
|
RM10301.PSTGSTUS
|
|
|
| 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
|
| PORDNMBR |
char(21)
|
Purchase O...(more) Join Now
|
|
|
|
| Rate_Per_Unit |
numeric(19,5)
|
|
|
|
|
| Billed_Amount |
numeric(19,5)
|
|
|
|
|
| Billed_Invoice_Number_1 |
char(17)
|
|
|
|
|
| Billed_Invoice_Number_2 |
char(17)
|
|
|
|
|
| Billed_Transaction |
tinyint
|
|
|
|
|
| Credit_Memo_Number |
char(17)
|
|
|
|
|
| Credit_Transaction |
tinyint
|
|
|
|
|
| Unbillable_Transaction |
tinyint
|
|
|
|
|
| RATECLSS |
char(15)
|
Rate Class...(more) Join Now
|
UPR00100.RATECLSS
|
|
|
| WS_Cost_Type |
smallint
|
|
|
|
|
| ICCURRID |
char(15)
|
|
|
|
|
| ICCURRIX |
smallint
|
|
|
|
|
| SHFTCODE |
char(7)
|
Shift Code...(more) Join Now
|
UPR00400.SHFTCODE
|
|
|
| SHFTPREM |
numeric(19,5)
|
|
|
|
|
| Tax_Date |
datetime
|
Tax Date: ...(more) Join Now
|
RM20101.Tax_Date
|
|
|
| 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_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
|
|
|
|
|
| User_Defined_Date_3 |
datetime
|
|
|
|
|
| User_Defined_Date_4 |
datetime
|
|
|
|
|
| User_Defined_CB_1 |
tinyint
|
|
|
|
|
| User_Defined_CB_2 |
tinyint
|
|
|
|
|
| User_Defined_CB_3 |
tinyint
|
|
|
|
|
| User_Defined_CB_4 |
tinyint
|
|
|
|
|
| Wennsoft_Affiliate |
char(15)
|
|
|
|
|
| Wennsoft_Branch |
char(15)
|
|
|
|
|
| Wennsoft_Region |
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)
|
|
|
|
|
| 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
|
|
|
|