PA Purchase Order Line History (PA30601)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA30601

Product: Project Accounting (258)
Series: Project

Display Name: PA Purchase Order Line History
Physical Name: PA30601
Technical Name: PA_PO_HIST_LINE

Group Display Name: PA Purchasing History
Group Technical Name: PA Purchasing History

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	PApurordnum	PA Purchase Order No.	STR17_LBAU	String	18	17
2	ORD	Ord	LI_Sequence_Number	Long Integer	4	10
3	BRKFLD1	Break Field 1	INT1	Integer	2	1
4	ITEMNMBR	Item Number	STR30_Item_Number	String	32	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['PA Purchase Order Line History'].ITEMNMBR AS 'PA Purchase Order Line History-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM PA30601 AS ['PA Purchase Order Line History'] INNER JOIN IV00101 AS ['Item Master'] ON ['PA Purchase Order Line History'].ITEMNMBR = ['Item Master'].ITEMNMBR
5	VNDITNUM	Vendor Item Number	Item_Number	String	32	30
6	BackoutTradeDiscTax	Backout Trade Discount Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
7	Capital_Item	Capital Item	CB_Capital_Item	Boolean	2	0
8	CURNCYID	Currency ID	STR15_Currency_ID	String	16	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['PA Purchase Order Line History'].CURNCYID AS 'PA Purchase Order Line History-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM PA30601 AS ['PA Purchase Order Line History'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['PA Purchase Order Line History'].CURNCYID = ['Currency Setup'].CURNCYID
9	DENXRATE	Denomination Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
10	XCHGRATE	Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
11	FRTAMNT	Freight Amount	DLR17_RBS0_UTR$	Currency	10	17
12	ITMTSHID	Item Tax Schedule ID	STR15_LBAU	String	16	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['PA Purchase Order Line History'].ITMTSHID AS 'PA Purchase Order Line History-Item Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM PA30601 AS ['PA Purchase Order Line History'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['PA Purchase Order Line History'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
13	ITMTRKOP	Item Tracking Option	DDL_Track	Integer	2	0
14	MSCCHAMT	Misc Charges Amount	DLR17_RBS0_UTR$	Currency	10	17
15	OrigBackoutTradeDiscTax	Originating Backout Trade Discount Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
16	ORFRTAMT	Originating Freight Amount	DLR17_RBS0_UTR$	Currency	10	17
17	OMISCAMT	Originating Misc Charges Amount	DLR17_RBS0_UTR$	Currency	10	17
18	ORTDISAM	Originating Trade Discount Amount	DLR17_RBS0_UTR$	Currency	10	17
19	PAbillnoteidx	PA Billing Note Index	DLR14	Currency	10	14
20	PACBADDFRMFLY	PA CB From Add On The Fly	CB	Boolean	2	0
21	PACHGORDNO	PA Change Order Number	STR17_LBAU	String	18	17
22	PACogs_Idx	PA COGS IDX	LI_14	Long Integer	4	14
23	PACOSTCATID	PA Cost Category ID	STR15_Cost_Category_ID	String	16	15
24	PAIV_Item_Checkbox	PA IV Item Checkbox	PA_CB_IV_Item	Boolean	2	0
25	PALineItemSeq	PA Line Item Sequence	LI_Sequence_Number	Long Integer	4	10
26	PAprojname	PA Project Name	STR30_PTBS Description 1	String	32	30
27	PAPROJNUMBER	PA Project Number	STR15_LBAU	String	16	15
28	PAProjectType	PA Project Type	PA_DDL_Project_Type	Integer	2	0
29	PAPurchase_Tax_Options	PA Purchase Tax Options	PA_DDL_Tax_Options_Purchase	Integer	2	0
30	PATU	PA Transaction Usage	PA_DDL_Transaction_Usage	Integer	2	0
31	PACGBWIPIDX	PA WIP IDX	LI_14	Long Integer	4	14
32	PRICELVL	Price Level	STR15_LBAU	String	16	15
33	QTYCMTBASE	QTY Committed In Base	DLR17_QTY_RBS0_STR	Currency	10	17
34	QTYUNCMTBASE	QTY Uncommitted In Base	DLR17_QTY_RBS0_STR	Currency	10	17
35	RATECALC	Rate Calc Method	INT	Integer	2	0
36	TRDISAMT	Trade Discount Amount	DLR17_RBS0_UTR$	Currency	10	17
37	DEX_ROW_ID		int	int	10	10
	DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurve Products Project Accounting (258)ProjectPA Purchase Order Line History (PA30601)

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply