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

COMPANY..PA41701A Table Definition

(COMPANY..PA Project Source Setup)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PAcosttrxid char(17)
''
This one i...(more) Join Now PA43001.PAcosttrxid
TM_WIP_SRC smallint
0
TM WIP SRC...(more) Join Now PA01301.TM_WIP_SRC
TM_COGS_SRC smallint
0
TM COGS SR...(more) Join Now PA01301.TM_COGS_SRC
TM_Cost_Contra_SRC smallint
0
M Cost Con...(more) Join Now PA01301.TM_Cost_Contra_SRC
TM_Unbilled_AR_SRC smallint
0
TM Unbille...(more) Join Now PA01301.TM_Unbilled_AR_SRC
TM_Unbilled_Rev_SRC smallint
0
TM Unbille...(more) Join Now PA01301.TM_Unbilled_Rev_SRC
TM_AR_SRC smallint
0
TM AR SRC ...(more) Join Now PA01301.TM_AR_SRC
TM_Prj_Rev_SRC smallint
0
TM Prj Rev...(more) Join Now PA01301.TM_Prj_Rev_SRC
TM_OVHD_SRC smallint
0
TM OVHD SR...(more) Join Now PA01301.TM_OVHD_SRC
FF_WIP_SRC smallint
0
FF WIP SRC...(more) Join Now PA01301.FF_WIP_SRC
FF_Cost_Contra_SRC smallint
0
FF Cost Co...(more) Join Now PA01301.FF_Cost_Contra_SRC
FF_AR_SRC smallint
0
FF AR SRC ...(more) Join Now PA01301.FF_AR_SRC
FF_Prj_Billings_SRC smallint
0
FF Prj Bil...(more) Join Now PA01301.FF_Prj_Billings_SRC
FF_Prj_Expense_SRC smallint
0
FF Prj Exp...(more) Join Now PA01301.FF_Prj_Expense_SRC
FF_Prj_Revenue_SRC smallint
0
FF Prj Rev...(more) Join Now PA01301.FF_Prj_Revenue_SRC
FF_Prj_Loss_SRC smallint
0
FF Prj Los...(more) Join Now PA01301.FF_Prj_Loss_SRC
FF_BIEE_SRC smallint
0
FF BIEE SR...(more) Join Now PA01301.FF_BIEE_SRC
FF_EIEB_SRC smallint
0
FF EIEB SR...(more) Join Now PA01301.FF_EIEB_SRC
FF_OVHD_SRC smallint
0
FF OVHD SR...(more) Join Now PA01301.FF_OVHD_SRC
TM_Prj_Deferred_Rev_Fee_ smallint
0
TM Prj Def...(more) Join Now
TM_Prj_Rev_Fee_SRC smallint
0
TM Prj Rev...(more) Join Now
TM_AR_Fee_SRC smallint
0
TM AR Fee ...(more) Join Now
TM_BIEE_Fee_SRC smallint
0

TM_EIEB_Fee_SRC smallint
0

FF_WIP_Fee_SRC smallint
0
FF WIP Fee...(more) Join Now
FF_Prj_Billings_Fee_SRC smallint
0
FF Prj Bil...(more) Join Now
PAFF_AR_Fee_SRC smallint
0
FF AR Fee ...(more) Join Now
FF_Prj_Rev_Fee_SRC smallint
0
FF Prj Rev...(more) Join Now
FF_Retention_Fee_SRC smallint
0
FF Retenti...(more) Join Now
FF_Prj_Deferred_Rev_Fee_ smallint
0
FF Prj Def...(more) Join Now
FF_BIEE_Fee_SRC smallint
0
FF BIEE Fe...(more) Join Now
FF_EIEB_Fee_SRC smallint
0
FF EIEB Fe...(more) Join Now
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