| PAVIDN |
char(17)
''
|
PA Vendor ...(more) Join Now
|
|
|
|
| RCPTLNNM |
int
0
|
Receipt Li...(more) Join Now
|
|
|
|
| PApurordnum |
char(17)
''
|
The purcha...(more) Join Now
|
|
|
|
| ITEMNMBR |
char(31)
''
|
Item Numbe...(more) Join Now
|
|
|
join ... more text available
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| DATEVAL |
datetime
'1/1/1900'
|
|
|
|
|
| DENXRATE |
numeric(19,7)
0.00
|
Exchange R...(more) Join Now
|
|
|
|
| EXCHDATE |
datetime
'1/1/1900'
|
Exchange D...(more) Join Now
|
|
|
|
| XCHGRATE |
numeric(19,7)
0.00
|
Exchange R...(more) Join Now
|
MC00100.XCHGRATE
|
|
|
| EXGTBLID |
char(15)
''
|
Exchange T...(more) Join Now
|
MC00100.EXGTBLID
|
|
|
| ITMTSHID |
char(15)
''
|
Item Tax S...(more) Join Now
|
|
|
|
| MCTRXSTT |
smallint
0
|
MC Transac...(more) Join Now
|
|
|
|
| ORD |
int
0
|
|
|
|
|
| ORTDISAM |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| PAAcctgMethod |
smallint
0
|
Useful in ...(more) Join Now
|
|
|
|
| PAACREV |
numeric(19,5)
0.00
|
PA Accrued...(more) Join Now
|
|
|
|
| PA_Base_Billing_Rate |
numeric(19,5)
0.00
|
PA Base Bi...(more) Join Now
|
|
|
|
| PABaseOvhdCost |
numeric(19,5)
0.00
|
PA Base Ov...(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
|
|
|
|
| PABILRATE |
numeric(19,5)
0.00
|
PA Billing...(more) Join Now
|
|
|
|
| PABilling_StatusN |
smallint
0
|
p>1 = Bill...(more) Join Now
|
|
|
|
| PAbllngtype |
smallint
0
|
1=Billable...(more) Join Now
|
|
|
|
| PACBADDFRMFLY |
tinyint
0
|
|
|
|
|
| PACHGORDNO |
char(17)
''
|
PA Change ...(more) Join Now
|
|
|
|
| PACogs_Idx |
int
0
|
ACTIDX of ...(more) Join Now
|
|
|
|
| PAContra_Account_IDX |
int
0
|
PA Contra ...(more) Join Now
|
|
|
|
| PACONTNUMBER |
char(11)
''
|
PA Contrac...(more) Join Now
|
|
|
|
| PACOSTCATID |
char(15)
''
|
PA Cost Ca...(more) Join Now
|
|
|
|
| PACOSTCATNME |
char(31)
''
|
PA Cost Ca...(more) Join Now
|
|
|
|
| PAIV_Item_Checkbox |
tinyint
0
|
|
|
|
|
| PALineItemSeq |
int
0
|
PA Line It...(more) Join Now
|
|
|
|
| PAMARKPERCENT |
numeric(19,5)
0.00
|
PA Markup ...(more) Join Now
|
|
|
|
| PA_MC_Accrued_Revenue |
numeric(19,5)
0.00
|
PA MC Accr...(more) Join Now
|
|
|
|
| PA_MC_Base_Billing_Rate |
numeric(19,5)
0.00
|
PA MC Base...(more) Join Now
|
|
|
|
| PA_MC_Billing_Rate |
numeric(19,5)
0.00
|
PA MC Bill...(more) Join Now
|
|
|
|
| PAMCCURNCYID |
char(15)
''
|
PA MC Curr...(more) Join Now
|
|
|
|
| PA_MC_VarianceAccruedRev |
numeric(19,5)
0.00
|
PA MC Vari...(more) Join Now
|
|
|
|
| PAORIACCRREV |
numeric(19,5)
0.00
|
PA Origina...(more) Join Now
|
|
|
|
| PAORIGBASEOVRHCST |
numeric(19,5)
0.00
|
PA Origina...(more) Join Now
|
|
|
|
| PAORIGBILLRATE |
numeric(19,5)
0.00
|
PA Origina...(more) Join Now
|
|
|
|
| PAORIGOVHDAMT |
numeric(19,5)
0.00
|
PA Origina...(more) Join Now
|
|
|
|
| PAORIGPROFAMT |
numeric(19,5)
0.00
|
PA Origina...(more) Join Now
|
|
|
|
| PAOrigSEC |
numeric(19,5)
0.00
|
PA Origina...(more) Join Now
|
|
|
|
| PAORIGTOTOVRHD |
numeric(19,5)
0.00
|
PA Origina...(more) Join Now
|
|
|
|
| PAORIGTOTPROF |
numeric(19,5)
0.00
|
PA Origina...(more) Join Now
|
|
|
|
| PAOrigVarExt |
numeric(19,5)
0.00
|
PA Origina...(more) Join Now
|
|
|
|
| PAOverhead_Amount |
numeric(19,5)
0.00
|
PA Overhea...(more) Join Now
|
|
|
|
| PAOverhead_IDX |
int
0
|
ACTIDX of ...(more) Join Now
|
|
|
|
| PAOverheaPercentage |
numeric(19,5)
0.00
|
PA Overhea...(more) Join Now
|
|
|
|
| PAPO_Line_Errors |
binary(4)
0
|
PA PO Line...(more) Join Now
|
|
|
|
| PAProfitAmount |
numeric(19,5)
0.00
|
PA Profit ...(more) Join Now
|
|
|
|
| PAProfitPercent |
numeric(19,5)
0.00
|
PA Profit ...(more) Join Now
|
|
|
|
| PAProfitType |
smallint
0
|
PA Profit ...(more) Join Now
|
|
|
|
| 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
|
|
|
|
| PAShipmentExtCost |
numeric(19,5)
0.00
|
PA Shipmen...(more) Join Now
|
|
|
|
| PATOTALOVERH |
numeric(19,5)
0.00
|
PA Total O...(more) Join Now
|
|
|
|
| PATotalProfit |
numeric(19,5)
0.00
|
PA Total P...(more) Join Now
|
|
|
|
| PATU |
smallint
0
|
PA Transac...(more) Join Now
|
|
|
|
| PAUnbilled_AR_Idx |
int
0
|
PA Unbille...(more) Join Now
|
|
|
|
| PAUnbilled_Proj_Rev_Idx |
int
0
|
PA Unbille...(more) Join Now
|
|
|
|
| PAUD1 |
char(21)
''
|
PA User De...(more) Join Now
|
|
|
|
| PAUD2 |
char(21)
''
|
PA User De...(more) Join Now
|
|
|
|
| PA_Variance_Cost |
tinyint
0
|
PA Varianc...(more) Join Now
|
|
|
|
| PA_Variance_Accrued_Reve |
numeric(19,5)
0.00
|
PA Varianc...(more) Join Now
|
|
|
|
| PA_Variance_QTY_Accrued_ |
numeric(19,5)
0.00
|
PA Varianc...(more) Join Now
|
|
|
|
| PACGBWIPIDX |
int
0
|
ACTIDX of ...(more) Join Now
|
|
|
|
| POTYPE |
smallint
0
|
PO Type: ...(more) Join Now
|
|
|
|
| POPTYPE |
smallint
0
|
POP Type: ...(more) Join Now
|
|
|
|
| PRICELVL |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| RATECALC |
smallint
0
|
Rate Calc ...(more) Join Now
|
|
|
|
| RATETPID |
char(15)
''
|
|
|
|
|
| receiptdate |
datetime
'1/1/1900'
|
Receipt Da...(more) Join Now
|
|
|
|
| TIME1 |
datetime
'1/1/1900'
|
Time Time...(more) Join Now
|
WO010213.TIME1
|
|
|
| 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
|
| VENDORID |
char(15)
''
|
Vendor ID ...(more) Join Now
|
WC010931.VENDORID
|
|
join ... more text available
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|