GP Tables

PA23201 - PA Billing Sub-Detail OPEN Fee

Dynamics GP table PA23201 (PA Billing Sub-Detail OPEN Fee) contains 47 columns including PABILLTRXT, PADocnumber20, PAPROJNUMBER....

SQL Query Builder

47 Columns

Column Description Type Length
PABILLTRXT PA Biller Trx Type Integer 2
PADocnumber20 PA Document No. String 18
PAPROJNUMBER PA Project Number String 16
LNITMSEQ Line Item Sequence Long Integer 4
CUTOFDAT Cutoff Date Date 4
PAFeeID PA Fee ID String 16
PAFeebillamount PA Billing Amount - Fee Currency 10
PAFeeAmount PA Fee Amount Currency 10
PAPreviously_Billed PA Previously Billed Currency 10
PAbillnoteidx PA Billing Note Index Currency 10
PAbilltaxscheduleid PA Billing Tax Schedule ID String 16
PAFeetaxamount PA Tax Amt - Fee Currency 10
PABACKBILL PA Backout Bill Amount Currency 10
PAFeeType PA Fee Type Integer 2
PARetainer_Fee_Amount PA Retainer Fee Amount Currency 10
CURTRXAM Current Trx Amount Currency 10
ORTRXAMT Original Trx Amount Currency 10
PA_Project_Sales_IDX PA Project Sales IDX Long Integer 4
PAAR_IDX PA AR IDX Long Integer 4
PA_Deferred_RevIDX PA Deferred Rev IDX Long Integer 4
PACGBWIPIDX PA WIP IDX Long Integer 4
PABProjectBlgsIDX PA Project Blgs IDX Long Integer 4
PA_FF_AR_IDX PA FF AR IDX Long Integer 4
PABProjectRevenueIDX PA Project Revenue IDX Long Integer 4
PA_Retention_AR PA Retention AR IDX Long Integer 4
PA_FF_Deferred_Rev_IDX PA FF Deferred Rev IDX Long Integer 4
PA_Trade_Discount_Amount PA Trade Discount Amount Currency 10
PARetentionFeeAmount PA Retention Fee Amount Currency 10
PA_Retention_IDX PA Retention IDX Long Integer 4
PAUD1 PA User Defined 1 String 22
PAUD2 PA User Defined 2 String 22
PAOrigBillingAmtFee PA Originating Billing Amount - Fee Currency 10
PAOrigFeeAmount PA Originating Fee Amount Currency 10
PAOrigPrevBill PA Originating Prev Billed Currency 10
PAOrigTaxAmtFee PA Originating Tax Amt - Fee Currency 10
PAOrigBackoutBillAmt PA Originating Backout Bill Amt Currency 10
ORCTRXAM Originating Current Trx Amount Currency 10
ORORGTRX Originating Original Trx Amount Currency 10
PAOrigTradeDiscAmt PA Originating Trade Discount Amt Currency 10
PAOrigRetentionFeeAmt PA Originating Retention Fee Amt Currency 10
PA_Previous_Retention PA Previous Retention Currency 10
PAOPREVRETENTION PA Originating Previous Retention Currency 10
PACHGORDNO PA Change Order Number String 18
BackoutTradeDisc Backout Trade Discount Amount Currency 10
OrigBackoutTradeDisc Originating Backout Trade Discount Amount Currency 10
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 PA23201. 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

PACHGORDNO

PA01301 PA01303 PA02101 PA05200 PA10001 PA10101 PA10201 PA10501

PAbillnoteidx

PA01001 PA01101 PA01201 PA01301 PA01303 PA02101 PA10001 PA10101

PAUD1

PA00401 PA00501 PA00601 PA00701 PA00801 PA00901 PA01001 PA02101

PAUD2

PA00401 PA00501 PA00601 PA00701 PA00801 PA00901 PA01001 PA02101

CURTRXAM

ASIEXP08 ASIEXP09 CFM20101 CFM20102 CN100201 CN20100 ICJC9001 PA23200

PACGBWIPIDX

PA10001 PA10101 PA10201 PA10501 PA10601 PA10702 PA10901 PA11801

PADocnumber20

PA11300 PA11800 PA11801 PA13100 PA13200 PA13201 PA13202 PA13203

PAbilltaxscheduleid

PA00401 PA01001 PA02101 PA12001 PA12102 PA13201 PA13202 PA13203