GP Tables

PA02101 - PA Project Fee Master File

Dynamics GP table PA02101 (PA Project Fee Master File) contains 47 columns including PAPROJNUMBER, PALineItemSeq, PAFeeID....

SQL Query Builder

47 Columns

Column Description Type Length
PAPROJNUMBER PA Project Number String 16
PALineItemSeq PA Line Item Sequence Long Integer 4
PAFeeID PA Fee ID String 16
PAFeeName PA Fee Name String 32
PAFeeType PA Fee Type Integer 2
PAFeeAmount PA Fee Amount Currency 10
PAPercent_Cost PA Percent Cost Currency 10
PAPercent_Revenue PA Percent Revenue Currency 10
PA_Retention_Percent PA Retention Percent Currency 10
PAFeeToUse PA Fee To Use Integer 2
PAbilltaxscheduleid PA Billing Tax Schedule ID String 16
PASales_Tax_Options PA Sales Tax Options Integer 2
PAbillnoteidx PA Billing Note Index Currency 10
PAbegindate PA Begin Date Date 4
PAEnDate PA End Date Date 4
PAFrequency PA Frequency Integer 2
STRTDATE Start Date Date 4
ENDDATE End Date Date 4
PARenew PA Renew Boolean 2
PARenewal_Date PA Renewal Date Date 4
PATotAmt PA Total Amount Currency 10
TM_AR_Fee_SRC TM AR Fee SRC Integer 2
TM_Prj_Deferred_Rev_Fee_ TM Prj Deferred Rev Fee SRC Integer 2
TM_Prj_Rev_Fee_SRC TM Prj Rev Fee SRC Integer 2
PAFF_AR_Fee_SRC FF AR Fee SRC Integer 2
FF_Prj_Billings_Fee_SRC FF Prj Billings Fee SRC Integer 2
FF_Prj_Rev_Fee_SRC FF Prj Rev Fee SRC Integer 2
FF_Retention_Fee_SRC FF Retention Fee SRC Integer 2
FF_WIP_Fee_SRC FF WIP Fee SRC Integer 2
FF_Prj_Deferred_Rev_Fee_ FF Prj Deferred Rev Fee SRC Integer 2
FF_BIEE_Fee_SRC FF BIEE Fee SRC Integer 2
FF_EIEB_Fee_SRC FF EIEB Fee SRC Integer 2
PAtotcbts PA Label Checkbox - TS Boolean 2
PAtotcbEL PA Label Checkbox - EL Boolean 2
PAtotcbML PA Label Checkbox - ML Boolean 2
PAtotcbvi PA Label Checkbox - VI Boolean 2
PAtotcber PA Label Checkbox - EE Boolean 2
PAtotcbinv PA Label Checkbox - INV Boolean 2
PA_Renew_Day PA Renew Day Integer 2
PA_Renew_Month PA Renew Month Integer 2
PAUD1 PA User Defined 1 String 22
PAUD2 PA User Defined 2 String 22
PACHGORDNO PA Change Order Number String 18
PAService_Fee_Amount PA Service Fee Amount Currency 10
PA_MC_Fee_Amount PA MC Fee Amount Currency 10
PA_MC_Service_Fee_Amount PA MC Service Fee Amount Currency 10
PA_MC_Total_Amount PA MC Total Amount Currency 10

Related Tables

Tables that share columns with PA02101. Click "Join" to add to your query.

PAPROJNUMBER

PA00402 PA00502 PA00503 PA01201 PA01221 PA01241 PA01251 PA01301

PACHGORDNO

PA01301 PA01303 PA05200 PA10001 PA10101 PA10201 PA10501 PA10601

PAbillnoteidx

PA01001 PA01101 PA01201 PA01301 PA01303 PA10001 PA10101 PA10201

PAUD1

PA00401 PA00501 PA00601 PA00701 PA00801 PA00901 PA01001 PA10000

PAUD2

PA00401 PA00501 PA00601 PA00701 PA00801 PA00901 PA01001 PA10000

PALineItemSeq

PA000002 PA01301 PA01303 PA10601 PA10702 PA10901 PA11903 PA11904

PAbilltaxscheduleid

PA00401 PA01001 PA12001 PA12102 PA13201 PA13202 PA13203 PA23201

STRTDATE

AHR2AP05 AHR2AP06 ASIEXP05 ASIEXP10 ASIEXP18 ASIEXP32 CN04000 EDCVAT09

PAFeeAmount

PA00401 PA00402 PA00511 PA01121 PA01221 PA01304 PA05200 PA11904

PAEnDate

PA10500 PA12000 PA12001 PA12101 PA12102 PA23400 PA23401 PA30500