GP Tables

PA23202 - PA Billing Sub-Detail OPEN FF

Dynamics GP table PA23202 (PA Billing Sub-Detail OPEN FF) contains 45 columns including PABILLTRXT, PADocnumber20, PAPROJNUMBER....

SQL Query Builder

45 Columns

Column Description Type Length
PABILLTRXT PA Biller Trx Type Integer 2
PADocnumber20 PA Document No. String 18
PAPROJNUMBER PA Project Number String 16
CUTOFDAT Cutoff Date Date 4
PACOSTCATID PA Cost Category ID String 16
PATU PA Transaction Usage1 = Timesheet2 = Equipment Log3 = Miscellaneous Log4 = Purchases/Material5 = Employee Expense Integer 2
PAAcctgMethod PA Accounting Method Integer 2
PATOTCST PA Total Cost Currency 10
PATQTY PA Total Quantity Currency 10
PAPercentCompleted PA Percent Completed Currency 10
PAFFbillamount PA Billing Amount - FF Currency 10
PARetentionFeeAmount PA Retention Fee Amount Currency 10
PARetainerAmt PA Retainer Amount Currency 10
PAbillnoteidx PA Billing Note Index Currency 10
PAbilltaxscheduleid PA Billing Tax Schedule ID String 16
PAFFtaxamt PA Tax Amt - FF Currency 10
PACostPcntCompleted PA Cost Percent Completed Currency 10
PAQuantityPcntCompleted PA Quantity Percent Completed Currency 10
PAObservedPcntCompleted PA Observed Percent Completed Currency 10
PAPreviously_Billed PA Previously Billed Currency 10
PAAmount_Earned PA Amount Earned Currency 10
LNITMSEQ Line Item Sequence Long Integer 4
PABACKBILL PA Backout Bill Amount Currency 10
PAAR_IDX PA AR IDX Long Integer 4
PABillRevAcctIdx PA Billing/Rev Acct Index Long Integer 4
PABPSE PA Bill Progress Subline Errors Long Integer 4
CURTRXAM Current Trx Amount Currency 10
ORTRXAMT Original Trx Amount Currency 10
PA_Trade_Discount_Amount PA Trade Discount Amount Currency 10
PA_Retention_IDX PA Retention IDX Long Integer 4
PAORIGTOTCOST PA Originating Total Cost Currency 10
PAOrigBillingAmtFF PA Originating Billing Amount - FF Currency 10
PAOrigRetentionFeeAmt PA Originating Retention Fee Amt Currency 10
PAOrigTaxAmtFF PA Originating Tax Amt - FF Currency 10
PAOrigPrevBill PA Originating Prev Billed Currency 10
PAOrigAmtEarned PA Originating Amt Earned Currency 10
PAOrigBackoutBillAmt PA Originating Backout Bill Amt Currency 10
PAOrigTradeDiscAmt PA Originating Trade Discount Amt Currency 10
ORCTRXAM Originating Current Trx Amount Currency 10
ORORGTRX Originating Original Trx Amount Currency 10
PA_Previous_Retention PA Previous Retention Currency 10
PAOPREVRETENTION PA Originating Previous Retention Currency 10
PACHGORDNO PA Change Order Number String 18
PA_Backout_Retention_Amt PA Backout Retention Amount Currency 10
PA_OrigBackRetentionAmt PA Originating Backout Retention Amount Currency 10

Related Tables

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

LNITMSEQ

ASIEXP20 ASIEXP25 ASIEXP26 DO10100 EDCEI006 EEPAIVRQ ERB10300 ERB10700

PAPROJNUMBER

PA00402 PA00502 PA00503 PA01201 PA01221 PA01241 PA01251 PA01301

PACOSTCATID

PA01001 PA01301 PA01303 PA01304 PA01341 PA01342 PA10001 PA10101

PACHGORDNO

PA01301 PA01303 PA02101 PA05200 PA10001 PA10101 PA10201 PA10501

PAbillnoteidx

PA01001 PA01101 PA01201 PA01301 PA01303 PA02101 PA10001 PA10101

CURTRXAM

ASIEXP08 ASIEXP09 CFM20101 CFM20102 CN100201 CN20100 ICJC9001 PA23200

PATU

PA000002 PA01001 PA01301 PA01304 PA01341 PA01342 PA10601 PA10702

PATOTCST

PA01342 PA10001 PA10101 PA10201 PA10901 PA11801 PA12001 PA13202

PADocnumber20

PA11300 PA11800 PA11801 PA13100 PA13200 PA13201 PA13202 PA13203

PAbilltaxscheduleid

PA00401 PA01001 PA02101 PA12001 PA12102 PA13201 PA13202 PA13203