CPOP_Line_Ctrl (CPO10110)

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

Display Name: CPOP_Line_Ctrl
Physical Name: CPO10110
Technical Name: CPOP_Line_Ctrl

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PONUMBER	PO Number	String	STR17_POP_Number	17
2	ORD	Ord	Long Integer	LI_Sequence_Number	10
3	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['CPOP_Line_Ctrl'].ACTINDX AS 'CPOP_Line_Ctrl-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM CPO10110 AS ['CPOP_Line_Ctrl'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['CPOP_Line_Ctrl'].ACTINDX = ['Account Index Master'].ACTINDX
4	REQDATE	Required Date	Date	DATE_L	0
5	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['CPOP_Line_Ctrl'].VENDORID AS 'CPOP_Line_Ctrl-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM CPO10110 AS ['CPOP_Line_Ctrl'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['CPOP_Line_Ctrl'].VENDORID = ['PM Vendor Master File'].VENDORID
6	APPROVL	Approval	Boolean	CB_Approval	0
7	Committed_Amount	Committed Amount	Currency	DLR17_RBS0_UTR$	17
8	POLNESTA	PO Line Status	Integer	DDL_PO_Line_Status	0
9	QTYCANCE	QTY Canceled	Currency	DLR17_QTY_RBS0_UTR	17
10	UNITCOST	Unit Cost	Currency	DLR17_RBS0_UTR$	17
11	PostedSubtotal	Posted Subtotal	Currency	DLR17_RBS0_STR$	17