| PONUMBER |
char(17)
''
|
PO Number ...(more) Join Now
|
|
|
|
| ORD |
int
0
|
This is th...(more) Join Now
|
|
|
|
| POLNESTA |
smallint
0
|
PO Line St...(more) Join Now
|
|
|
|
| POTYPE |
smallint
0
|
PO Type T...(more) Join Now
|
|
|
|
| ITEMNMBR |
char(31)
''
|
Item Numbe...(more) Join Now
|
|
|
join ... more text available
|
| ITEMDESC |
char(101)
''
|
Item Descr...(more) Join Now
|
|
|
|
| VENDORID |
char(15)
''
|
Vendor ID:...(more) Join Now
|
|
|
join ... more text available
|
| VNDITNUM |
char(31)
''
|
Vendor Ite...(more) Join Now
|
|
|
|
| VNDITDSC |
char(101)
''
|
Vendor Ite...(more) Join Now
|
|
|
|
| NONINVEN |
smallint
0
|
|
|
|
|
| LOCNCODE |
char(11)
''
|
Location C...(more) Join Now
|
|
|
join ... more text available
|
| UOFM |
char(9)
''
|
U Of M The...(more) Join Now
|
|
|
See I... more text available
|
| UMQTYINB |
numeric(19,5)
0.00
|
U Of M QTY...(more) Join Now
|
ENC10111.UMQTYINB
|
|
|
| QTYORDER |
numeric(19,5)
0.00
|
|
|
|
|
| QTYCANCE |
numeric(19,5)
0.00
|
QTY Cancel...(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
|
|
|
|
| INVINDX |
int
0
|
Inventory ...(more) Join Now
|
|
|
|
| REQDATE |
datetime
'1/1/1900'
|
Required D...(more) Join Now
|
OSRC1100.REQDATE
|
|
|
| PRMDATE |
datetime
'1/1/1900'
|
Promised D...(more) Join Now
|
|
|
|
| PRMSHPDTE |
datetime
'1/1/1900'
|
Promised S...(more) Join Now
|
|
|
|
| REQSTDBY |
char(21)
''
|
|
|
|
|
| COMMNTID |
char(15)
''
|
|
|
|
join ... more text available
|
| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
|
|
|
| POLNEARY_1 |
numeric(19,5)
0.00
|
PO Line No...(more) Join Now
|
|
|
|
| POLNEARY_2 |
numeric(19,5)
0.00
|
PO Line No...(more) Join Now
|
|
|
|
| POLNEARY_3 |
numeric(19,5)
0.00
|
PO Line No...(more) Join Now
|
|
|
|
| POLNEARY_4 |
numeric(19,5)
0.00
|
PO Line No...(more) Join Now
|
|
|
|
| POLNEARY_5 |
numeric(19,5)
0.00
|
PO Line No...(more) Join Now
|
|
|
|
| POLNEARY_6 |
numeric(19,5)
0.00
|
PO Line No...(more) Join Now
|
|
|
|
| POLNEARY_7 |
numeric(19,5)
0.00
|
PO Line No...(more) Join Now
|
|
|
|
| POLNEARY_8 |
numeric(19,5)
0.00
|
PO Line No...(more) Join Now
|
|
|
|
| POLNEARY_9 |
numeric(19,5)
0.00
|
PO Line No...(more) Join Now
|
|
|
|
| DECPLCUR |
smallint
0
|
Number of ...(more) Join Now
|
|
|
|
| DECPLQTY |
smallint
0
|
Decimal Pl...(more) Join Now
|
|
|
|
| BRKFLD1 |
smallint
0
|
Break Fiel...(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
|
|
|
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| ORUNTCST |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| OREXTCST |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| LINEORIGIN |
smallint
0
|
Line Origi...(more) Join Now
|
|
|
|
| FREEONBOARD |
smallint
0
|
Free On Bo...(more) Join Now
|
|
|
|
| ODECPLCU |
smallint
0
|
|
|
|
|
| Product_Indicator |
smallint
0
|
Product In...(more) Join Now
|
|
|
|
| Source_Document_Number |
char(11)
''
|
Source Doc...(more) Join Now
|
|
|
|
| Source_Document_Line_Num |
smallint
0
|
Source Doc...(more) Join Now
|
|
|
|
| RELEASEBYDATE |
datetime
'1/1/1900'
|
Release By...(more) Join Now
|
|
|
|
| Released_Date |
datetime
'1/1/1900'
|
Released D...(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
|
|
|
|
| PURCHSITETXSCHSRC |
smallint
0
|
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
|
|
|
|
| Landed_Cost_Group_ID |
char(15)
''
|
Landed Cos...(more) Join Now
|
|
|
|
| SHIPMTHD |
char(15)
''
|
Shipping M...(more) Join Now
|
|
|
join ... more text available
|
| LineNumber |
smallint
0
|
LineNumber...(more) Join Now
|
|
|
|
| ORIGPRMDATE |
datetime
'1/1/1900'
|
Original P...(more) Join Now
|
|
|
|
| FSTRCPTDT |
datetime
'1/1/1900'
|
First Rece...(more) Join Now
|
|
|
|
| LSTRCPTDT |
datetime
'1/1/1900'
|
Last Recei...(more) Join Now
|
|
|
|
| RELEASE |
smallint
0
|
Release: ...(more) Join Now
|
|
|
|
| ADRSCODE |
char(15)
''
|
Address Co...(more) Join Now
|
|
|
|
| CMPNYNAM |
char(65)
''
|
Company Na...(more) Join Now
|
|
|
|
| CONTACT |
char(61)
''
|
|
|
|
|
| ADDRESS1 |
char(61)
''
|
Address 1:...(more) Join Now
|
|
|
|
| ADDRESS2 |
char(61)
''
|
Address 2:...(more) Join Now
|
|
|
|
| ADDRESS3 |
char(61)
''
|
Address 3:...(more) Join Now
|
|
|
|
| CITY |
char(35)
''
|
City: Shi...(more) Join Now
|
|
|
|
| STATE |
char(29)
''
|
State: Sh...(more) Join Now
|
|
|
|
| ZIPCODE |
char(11)
''
|
Zip Code: ...(more) Join Now
|
|
|
|
| CCode |
char(7)
''
|
Country Co...(more) Join Now
|
|
|
|
| COUNTRY |
char(61)
''
|
Country: ...(more) Join Now
|
|
|
|
| PHONE1 |
char(21)
''
|
Phone 1: ...(more) Join Now
|
|
|
|
| PHONE2 |
char(21)
''
|
Phone 2: ...(more) Join Now
|
|
|
|
| PHONE3 |
char(21)
''
|
Phone 3: ...(more) Join Now
|
|
|
|
| FAX |
char(21)
''
|
Fax: Ship...(more) Join Now
|
|
|
|
| ADDRSOURCE |
smallint
0
|
|
|
|
|
| Flags |
smallint
0
|
Flags:...(more) Join Now
|
|
|
|
| ProjNum |
char(15)
''
|
|
|
|
|
| CostCatID |
char(15)
''
|
|
|
|
|
| ITMTRKOP |
smallint
0
|
Item Track...(more) Join Now
|
|
|
|
| VCTNMTHD |
smallint
0
|
|
|
|
|
| Print_Phone_NumberGB |
smallint
0
|
Print_Phon...(more) Join Now
|
|
|
|
| DEX_ROW_TS |
datetime
(getutcdate())
|
Time Stamp...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|