| ITEMNMBR |
char(31)
''
|
span style...(more) Join Now
|
|
|
join ... more text available
|
| SEQNUMBR |
int
0
|
Sequence N...(more) Join Now
|
|
|
|
| DOCDATE |
datetime
'1/1/1900'
|
The date a...(more) Join Now
|
|
|
|
| GLPOSTDT |
datetime
'1/1/1900'
|
Date that ...(more) Join Now
|
|
|
|
| DOCNUMBR |
char(21)
''
|
Document N...(more) Join Now
|
|
|
|
| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
|
|
|
| LOCNCODE |
char(11)
''
|
Location C...(more) Join Now
|
|
|
join ... more text available
|
| RCPTNMBR |
char(21)
''
|
Receipt Nu...(more) Join Now
|
|
|
|
| RCTSEQNM |
int
0
|
Receipt SE...(more) Join Now
|
|
|
|
| PCHSRCTY |
smallint
0
|
Purchase R...(more) Join Now
|
|
|
|
| QTYTYPE |
smallint
0
|
QTY Type T...(more) Join Now
|
BM10400.QTYTYPE
|
|
|
| UOFM |
char(9)
''
|
U Of M: Th...(more) Join Now
|
|
|
See I... more text available
|
| TRXQTYInBase |
numeric(19,5)
0.00
|
This is th...(more) Join Now
|
|
|
|
| TRXQTY |
numeric(19,5)
0.00
|
TRX QTY: T...(more) Join Now
|
IV10001.TRXQTY
|
|
|
| VARIANCEQTY |
numeric(19,5)
0.00
|
Variance Q...(more) Join Now
|
|
|
|
| UNITCOST |
numeric(19,5)
0.00
|
Unit Cost:...(more) Join Now
|
|
|
|
| EXTDCOST |
numeric(19,5)
0.00
|
Extended C...(more) Join Now
|
|
|
|
| DECPLQTY |
smallint
0
|
Decimal Pl...(more) Join Now
|
|
|
|
| DECPLCUR |
smallint
0
|
Number of ...(more) Join Now
|
|
|
|
| IsOverrideReceipt |
tinyint
0
|
span style...(more) Join Now
|
|
|
|
| IsOverrideRelieved |
tinyint
0
|
Is Overrid...(more) Join Now
|
|
|
|
| OverrideRelievedDate |
datetime
'1/1/1900'
|
span style...(more) Join Now
|
|
|
|
| RCPTNMBR1 |
char(21)
''
|
Receipt Nu...(more) Join Now
|
|
|
|
| HSTMODUL |
char(3)
''
|
|
|
|
|
| ORTRXSRC |
char(13)
0
|
Originatin...(more) Join Now
|
|
|
|
| LNSEQNBR |
numeric(19,5)
0
|
Line SEQ N...(more) Join Now
|
|
|
|
| LNITMSEQ |
int
0
|
Line Item ...(more) Join Now
|
PA01301.LNITMSEQ
|
|
|
| CMPNTSEQ |
int
0
|
Component ...(more) Join Now
|
SOP10200.CMPNTSEQ
|
|
|
| SRCRFRNCNMBR |
char(31)
''
|
Source Ref...(more) Join Now
|
IV10000.SRCRFRNCNMBR
|
|
|
| VENDORID |
char(15)
''
|
Vendor ID:...(more) Join Now
|
PM10000.VENDORID
|
|
join ... more text available
|
| PONUMBER |
char(17)
''
|
PO Number&...(more) Join Now
|
|
|
|
| TRXREFERENCE |
smallint
0
|
|
|
|
|
| VCTNMTHD |
smallint
0
|
span style...(more) Join Now
|
IV00101.VCTNMTHD
|
|
|
| IVIVINDX |
int
0
|
IV IV Inde...(more) Join Now
|
IV00101.IVIVINDX
|
|
|
| IVIVOFIX |
int
0
|
IV IV Offs...(more) Join Now
|
IV00101.IVIVOFIX
|
|
|
| JRNENTRY |
int
0
|
Journal En...(more) Join Now
|
DTA10100.JRNENTRY
|
|
|
| TRXSORCE |
char(13)
''
|
Transactio...(more) Join Now
|
|
|
|
| DEBITAMT |
numeric(19,5)
0.00
|
Debit Amou...(more) Join Now
|
GL10001.DEBITAMT
|
|
|
| CRDTAMNT |
numeric(19,5)
0.00
|
Credit Amo...(more) Join Now
|
GL10001.CRDTAMNT
|
|
|
| DATE1 |
datetime
'1/1/1900'
|
Date: Date...(more) Join Now
|
SY03900.DATE1
|
|
|
| TIME1 |
datetime
'1/1/1900'
|
Time see ...(more) Join Now
|
CM20200.TIME1
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|