| PApurordnum |
char(17)
''
|
The purcha...(more) Join Now
|
|
|
|
| ORD |
int
0
|
|
|
|
|
| BRKFLD1 |
smallint
0
|
Break Fiel...(more) Join Now
|
SOP10200.BRKFLD1
|
|
|
| ITEMNMBR |
char(31)
''
|
Item Numbe...(more) Join Now
|
|
|
join ... more text available
|
| VNDITNUM |
char(31)
''
|
Vendor Ite...(more) Join Now
|
|
|
|
| DATEVAL |
datetime
'1/1/1900'
|
|
|
|
|
| FRTAMNT |
numeric(19,5)
0.00
|
Freight Am...(more) Join Now
|
|
|
|
| ITMTSHID |
char(15)
''
|
Item Tax S...(more) Join Now
|
|
|
|
| MSCCHAMT |
numeric(19,5)
0.00
|
Misc Charg...(more) Join Now
|
|
|
|
| ORFRTAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| OMISCAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORTDISAM |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| PABase_Qty |
numeric(19,5)
0.00
|
PA Base Qt...(more) Join Now
|
|
|
|
| PABase_Unit_Cost |
numeric(19,5)
0.00
|
PA Base Un...(more) Join Now
|
|
|
|
| PAbillnoteidx |
numeric(19,5)
0.00
|
PA Billing...(more) Join Now
|
|
|
|
| PACBADDFRMFLY |
tinyint
0
|
|
|
|
|
| PACHGORDNO |
char(17)
''
|
PA Change ...(more) Join Now
|
|
|
|
| PACogs_Idx |
int
0
|
ACTIDX of ...(more) Join Now
|
|
|
|
| PACOSTCATID |
char(15)
''
|
PA Cost Ca...(more) Join Now
|
|
|
|
| PAIV_Item_Checkbox |
tinyint
0
|
|
|
|
|
| PALineItemSeq |
int
0
|
PA Line It...(more) Join Now
|
|
|
|
| PAORGBSUNITCST |
numeric(19,5)
0.00
|
PA Origina...(more) Join Now
|
|
|
|
| PAprojname |
char(31)
''
|
|
|
|
|
| PAPROJNUMBER |
char(15)
''
|
PA Project...(more) Join Now
|
|
|
join ... more text available
|
| PAProjectType |
smallint
0
|
Project ty...(more) Join Now
|
|
|
|
| PAPurchase_Tax_Options |
smallint
0
|
PA Purchas...(more) Join Now
|
|
|
|
| PATU |
smallint
0
|
PA Transac...(more) Join Now
|
|
|
|
| PACGBWIPIDX |
int
0
|
ACTIDX of ...(more) Join Now
|
|
|
|
| PostedSubtotal |
numeric(19,5)
0.00
|
|
|
|
|
| PRICELVL |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| TRDISAMT |
numeric(19,5)
0.00
|
Trade Disc...(more) Join Now
|
|
|
|
| UOMSCHDL |
char(11)
''
|
U Of M Sch...(more) Join Now
|
|
|
join ... more text available
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|