| VENDORID |
char(15)
|
Vendor ID:...(more) Join Now
|
PM10000.VENDORID
|
|
join ... more text available
|
| WS_Job_Number |
char(17)
|
|
|
|
|
| Job_TRX_Number |
char(21)
|
|
|
|
|
| LNSEQNBR |
numeric(19,5)
0
|
Line SEQ N...(more) Join Now
|
|
|
|
| CNTRLTYP |
smallint
|
Control Ty...(more) Join Now
|
PM00400.CNTRLTYP
|
|
|
| BACHNUMB |
char(15)
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| BCHSOURC |
char(15)
|
Batch Sour...(more) Join Now
|
|
|
|
| PORDNMBR |
char(21)
|
Purchase O...(more) Join Now
|
|
|
|
| DOCDATE |
datetime
|
Document D...(more) Join Now
|
PM10000.DOCDATE
|
|
|
| PSTGDATE |
datetime
|
Posting Da...(more) Join Now
|
PM10000.PSTGDATE
|
|
|
| DOCNUMBR |
char(21)
|
Document N...(more) Join Now
|
PM10000.DOCNUMBR
|
|
|
| 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
|
| HOLD |
tinyint
|
Hold: 1 i...(more) Join Now
|
RM00101.HOLD
|
|
|
| VOIDED |
tinyint
|
Voided Tru...(more) Join Now
|
CM20200.VOIDED
|
|
|
| Voucher_Created |
tinyint
|
|
|
|
|
| Original_Document_Amount |
numeric(19,5)
|
|
|
|
|
| DOCAMNT |
numeric(19,5)
|
Source Doc...(more) Join Now
|
PM10000.DOCAMNT
|
|
|
| Retention_Withheld |
numeric(19,5)
|
|
|
|
|
| Apply_Doc_Paid_Amount |
numeric(19,5)
|
|
|
|
|
| Retention_Apply |
numeric(19,5)
|
|
|
|
|
| Retention_Invoiced |
numeric(19,5)
|
|
|
|
|
| Retention_Pct |
numeric(19,5)
|
|
|
|
|
| TRXQTY |
numeric(19,5)
|
TRX QTY: T...(more) Join Now
|
IV10001.TRXQTY
|
|
|
| Document_Source |
char(3)
|
|
|
|
|
| Date_Paid |
datetime
|
|
|
|
|
| Remaining_Amount |
numeric(19,5)
|
|
|
|
|
| PMNTNMBR |
char(21)
|
Payment Nu...(more) Join Now
|
CM20300.PMNTNMBR
|
|
|
| TRXSORCE |
char(13)
|
Transactio...(more) Join Now
|
|
|
|
| OrgOrgnlDocAmt |
numeric(19,5)
|
|
|
|
|
| ORDOCAMT |
numeric(19,5)
|
Field Type...(more) Join Now
|
SVC30603.ORDOCAMT
|
|
|
| Org_Retention_Withheld |
numeric(19,5)
|
|
|
|
|
| Org_Retention_Apply |
numeric(19,5)
|
|
|
|
|
| Org_Retention_Invoiced |
numeric(19,5)
|
|
|
|
|
| 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
|
|
|
|
|
| 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)
|
|
|
|
|
| Wennsoft_Affiliate |
char(15)
|
|
|
|
|
| Wennsoft_Branch |
char(15)
|
|
|
|
|
| Wennsoft_Region |
char(15)
|
|
|
|
|
| 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
|
|
|
|