CFM_POPSQL (CFM40100)

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

Display Name: CFM_POPSQL
Physical Name: CFM40100
Technical Name: CFM_POPSQL

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['CFM_POPSQL'].VENDORID AS 'CFM_POPSQL-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM CFM40100 AS ['CFM_POPSQL'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['CFM_POPSQL'].VENDORID = ['PM Vendor Master File'].VENDORID
2	PONUMBER	PO Number	String	STR17_POP_Number	17
3	POSTATUS	PO Status	Integer	DDL_PO_Status	0
4	DOCDATE	Document Date	Date	DT	8
5	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['CFM_POPSQL'].PYMTRMID AS 'CFM_POPSQL-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM CFM40100 AS ['CFM_POPSQL'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['CFM_POPSQL'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
6	DISGRPER	Discount Grace Period	Integer	INT2_U0	2
7	DUEGRPER	Due Date Grace Period	Integer	INT2_U0	2
8	Amount	Amount	Currency	Currency_19_0	19