| POPRCTNM |
char(17)
''
|
POP Receip...(more) Join Now
|
|
|
|
| RCPTLNNM |
int
0
|
Receipt Li...(more) Join Now
|
|
|
|
| PONUMBER |
char(17)
''
|
PO Number ...(more) Join Now
|
|
|
|
| ITEMNMBR |
char(31)
''
|
Item Numbe...(more) Join Now
|
|
|
join ... more text available
|
| ITEMDESC |
char(101)
''
|
Item Descr...(more) Join Now
|
|
|
|
| VNDITNUM |
char(31)
''
|
Vendor Ite...(more) Join Now
|
|
|
|
| VNDITDSC |
char(101)
''
|
Vendor Ite...(more) Join Now
|
|
|
|
| UMQTYINB |
numeric(19,5)
0.00
|
U Of M QTY...(more) Join Now
|
ENC10111.UMQTYINB
|
|
|
| ACTLSHIP |
datetime
'1/1/1900'
|
Actual Shi...(more) Join Now
|
|
|
|
| COMMNTID |
char(15)
''
|
|
|
|
join ... more text available
|
| INVINDX |
int
0
|
Inventory ...(more) Join Now
|
|
|
|
| UOFM |
char(9)
''
|
U Of M The...(more) Join Now
|
|
|
See I... more text available
|
| UNITCOST |
numeric(19,5)
0.00
|
Unit Cost ...(more) Join Now
|
|
|
|
| EXTDCOST |
numeric(19,5)
0.00
|
Extended C...(more) Join Now
|
|
|
|
| LOCNCODE |
char(11)
''
|
Location C...(more) Join Now
|
|
|
join ... more text available
|
| RcptLineNoteIDArray_1 |
numeric(19,5)
0.00
|
NOTEINDX f...(more) Join Now
|
|
|
|
| RcptLineNoteIDArray_2 |
numeric(19,5)
0.00
|
NOTEINDX f...(more) Join Now
|
|
|
|
| RcptLineNoteIDArray_3 |
numeric(19,5)
0.00
|
NOTEINDX f...(more) Join Now
|
|
|
|
| RcptLineNoteIDArray_4 |
numeric(19,5)
0.00
|
|
|
|
|
| RcptLineNoteIDArray_5 |
numeric(19,5)
0.00
|
|
|
|
|
| RcptLineNoteIDArray_6 |
numeric(19,5)
0.00
|
NOTEINDX f...(more) Join Now
|
|
|
|
| RcptLineNoteIDArray_7 |
numeric(19,5)
0.00
|
span style...(more) Join Now
|
|
|
|
| RcptLineNoteIDArray_8 |
numeric(19,5)
0.00
|
|
|
|
|
| NONINVEN |
smallint
0
|
|
|
|
|
| DECPLCUR |
smallint
0
|
Number of ...(more) Join Now
|
|
|
|
| DECPLQTY |
smallint
0
|
Decimal Pl...(more) Join Now
|
|
|
|
| ITMTRKOP |
smallint
0
|
Item Track...(more) Join Now
|
|
|
|
| VCTNMTHD |
smallint
0
|
|
|
|
|
| TRXSORCE |
char(13)
''
|
Transactio...(more) Join Now
|
|
|
|
| JOBNUMBR |
char(17)
''
|
Job Number...(more) Join Now
|
|
|
|
| COSTCODE |
char(27)
''
|
Cost Code ...(more) Join Now
|
|
|
|
| COSTTYPE |
smallint
0
|
Cost Code ...(more) Join Now
|
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| RATETPID |
char(15)
''
|
Rate Type ...(more) Join Now
|
|
|
|
| XCHGRATE |
numeric(19,7)
0.00
|
Exchange R...(more) Join Now
|
|
|
|
| RATECALC |
smallint
0
|
Rate Calc ...(more) Join Now
|
|
|
|
| DENXRATE |
numeric(19,7)
0.00
|
Denominati...(more) Join Now
|
|
|
|
| ORUNTCST |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| OREXTCST |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ODECPLCU |
smallint
0
|
|
|
|
|
| BOLPRONUMBER |
char(31)
''
|
|
|
|
|
| Capital_Item |
tinyint
0
|
Capital It...(more) Join Now
|
|
|
|
| Product_Indicator |
smallint
0
|
Product In...(more) Join Now
|
|
|
|
| Purchase_IV_Item_Taxable |
smallint
0
|
Purchase I...(more) Join Now
|
|
|
|
| Purchase_Item_Tax_Schedu |
char(15)
''
|
Purchase I...(more) Join Now
|
|
|
|
| Purchase_Site_Tax_Schedu |
char(15)
''
|
Purchase S...(more) Join Now
|
|
|
|
| BSIVCTTL |
tinyint
0
|
Based On I...(more) Join Now
|
|
|
|
| TAXAMNT |
numeric(19,5)
0.00
|
Tax Amount...(more) Join Now
|
|
|
|
| ORTAXAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| BCKTXAMT |
numeric(19,5)
0.00
|
Backout Ta...(more) Join Now
|
|
|
|
| OBTAXAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| Revalue_Inventory |
tinyint
0
|
Revalue In...(more) Join Now
|
|
|
|
| Tolerance_Percentage |
int
0
|
Tolerance ...(more) Join Now
|
|
|
|
| PURPVIDX |
int
0
|
Purchase P...(more) Join Now
|
|
|
|
| Remaining_AP_Amount |
numeric(19,5)
0.00
|
|
|
|
|
| SHIPMTHD |
char(15)
''
|
Shipping M...(more) Join Now
|
|
|
join ... more text available
|
| Landed_Cost_Group_ID |
char(15)
''
|
Landed Cos...(more) Join Now
|
|
|
|
| Landed_Cost_Warnings |
smallint
0
|
|
|
|
|
| BackoutTradeDiscTax |
numeric(19,5)
0.00
|
Backout Tr...(more) Join Now
|
|
|
|
| OrigBackoutTradeDiscTax |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| Landed_Cost |
tinyint
0
|
span style...(more) Join Now
|
IV10200.Landed_Cost
|
|
|
| Invoice_Match |
tinyint
0
|
|
|
|
|
| RCPTRETNUM |
char(17)
''
|
|
|
|
|
| RCPTRETLNNUM |
int
0
|
|
|
|
|
| INVRETNUM |
char(17)
''
|
|
|
|
|
| INVRETLNNUM |
int
0
|
|
|
|
|
| ISLINEINTRA |
tinyint
0
|
IsLineIntr...(more) Join Now
|
|
|
|
| ProjNum |
char(15)
''
|
|
|
|
|
| CostCatID |
char(15)
''
|
|
|
|
|
| TrackedDropShipped |
tinyint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| OriginatingPrepaymentAmt |
numeric
0.00
|
|
|
|
|
| ORDISTKN |
numeric
0.00
|
Orig Disco...(more) Join Now
|
RM20102.ORDISTKN
|
|
|
| ORTDISAM |
numeric
0.00
|
|
|
|
|
| ORFRTAMT |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORMISCAMT |
numeric
0.00
|
|
|
|
|