PA11700 - PA Billing Subline Tax Detail | Prospr

PA11700 - PA Billing Subline Tax Detail

Select * from PA11700

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PADocnumber20	PA Document No.	String	18	View
PAPROJNUMBER	PA Project Number	String	16	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
PABillSubDetailType	PA Bill Sub-Detail Type	Integer	2	View
PABILLSUBLINESEQ	PA Biller Subline Sequence No.	Long Integer	4	View
PATU	PA Transaction Usage 1 = Timesheet 2 = Equipment Log 3 = Miscellaneous Log 4 = Purchases/Material 5 = Employee Expense	Integer	2	View
TAXDTLID	Tax Detail ID	String	16	View
SEQNUMBR	Sequence Number	Long Integer	4	View
ACTINDX	Account Index	Long Integer	4	View
TAXAMNT	Tax Amount	Currency	10	View
FRTTXAMT	Freight Tax Amount	Currency	10	View
MSCTXAMT	Misc Tax Amount	Currency	10	View
PABilledTax	PA Billed Tax	Currency	10	View
PAtotbillings	PA Total Billings	Currency	10	View
PATotalTaxableBillings	PA Total Taxable Billings	Currency	10	View
ORTAXAMT	Originating Tax Amount	Currency	10	View
ORFRTTAX	Originating Freight Tax Amount	Currency	10	View
ORMSCTAX	Originating Misc Tax Amount	Currency	10	View
PAOrigBilledTax	PA Originating Billed Tax	Currency	10	View
PAOrigTotalBilings	PA Originating Total Billings	Currency	10	View
PAOrigTotalTaxableBill	PA Originating Total Taxable Billings	Currency	10	View