Module List > Module PA tables PA10702
You are currently viewing the COMPANY database.
Change

COMPANY..PA10702 Table Definition

(COMPANY..PA PO Receipt Line)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3