Table PURTRS @ L.V. Expertise X3

Table	Abbreviation	Description	Module	Activity code
PURTRS	PTR	Entered purchase transactions	Purchasing

Key	Description	Duplicates	Activity code
PTR0	PTRTYP+PTRNUM	No
PTR1	PTRNUM+PTRTYP	No

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
ACCCOD	General account		M	15	35
ACCSCR	General account		M	18	99
ACSCOD	Access code		ACS			[ACS]ACS0=[PTR]ACSCOD	Block
ADDCOD	Address		M	15	35
ADDSCR	Address		M	18	99
APPFLG	Signed		M	4	1
APPSCR	Signed		M	18	99
AUUID	Single identifier		AUUID
AVSTOCOD1	Available stock		M	15	35
AVSTOSCR1	Available stock		M	15	99
BPRDATCOD	Supplier inv date		M	15	35
BPRSACCOD	Control		M	15	35
BPRVCRCOD	Supplier inv no.		M	15	35
BPSCOD	Supplier	3	M	15	35
BPSLOTCOD	Supplier lot	2	M	15	35
BPSLOTFLG	Supplier lot		M	4	1
BPSLOTSCR	Supplier lot	2	M	18	99
BPSLOTSCR1	Supplier lot		M	18	99
BPSNDEFLG	Supplier packing slip		M	4	1
BPSNDESCR	Supplier packing slip		M	18	99
BPSSCR	Supplier	3	M	18	99
BPTCOD	Carrier		M	15	35
BUYCOD	Buyer		M	15	35
BUYFLG	Buyer		M	4	1
CCEDEF	Default dimension		CDE			[CDE]CDE0=CCEDEF;[V]GSUPCLE	Block
CLEBUT	Close		M	4	1
CLEFLG	Closed		M	4	1
CLESCR	Closed		M	18	99
CONSMAT	Material consumption		M	15	354
CONTINFOCOD	Containers		M	15	35
CPRCOD	Stock cost		M	15	35
CPRCOECOD	LC coefficient		M	15	35
CPRCOESCR	LC coef		M	18	99
CPRSCR	Stock cost		M	18	99
CREDAT	Date created		D
CREDATTIM	Date time		ADATIM
CREUSR	Creation user		A	5
CSTCOD	Cost		M	15	35
CSTMAJCOD	New cost		M	15	35
CSTMAJSCR	New cost		M	15	99
CSTPURCOD	Purchase cost		M	15	35
CSTPURSCR	Purchase cost		M	18	99
CURCOD	Currency		M	15	35
DAS2COD	Fees declaration		M	15	35			FEE
DEPCOD	Settlement discount		M	15	35
DESAXX	Description		AX3
DESCOD	Comments		M	15	35
DIFPRIFLG	Cost difference		M	4	1
DIFPRISCR	Cost difference		M	18	99
DIFQTYFLG	Quantity difference		M	4	1
DIFQTYSCR	Quantity difference		M	18	99
DISCRGCOD	Disc/charge values		M	15	35			PPR
DISCRGSCR	Disc/charge values		M	18	99			PPR
DOCFLG	Auto print		M	4	1
DOCNAM	Document		ARP			[ARP]ARP0=[PTR]DOCNAM	Block
ECCCOD	Major version		M	15	35			ECC
ECCCODMIN	Minor version		M	15	35			ECC
ECCFLG	Version		M	4	1			ECC
ECCSCR	Major version		M	15	99			ECC
ECCSCRMIN	Minor version		M	15	99			ECC
EECICTCOD	Incoterm		M	15	35
EECINCCOD	Intrastat increase		M	15	35			DEB
EECINCSCR	Intrastat increase		M	18	99			DEB
ENAFLG	Active		M	4	1
ENTCOD	Automatic journal		GAU			[GAU]GAU0=[PTR]ENTCOD	Block
ENTCODS	Automatic journal		GAU			[GAU]GAU0=[PTR]ENTCODS	Other
EXPNUM	Export number		L	8
EXTQTYCOD	Planned quantity		M	15	35
FCSCODCOD	Cost		M	15	35
FCSCODSCR	Cost		M	15	99
FUPDATFLG	Reminder date		M	4	1
FUPDATSCR	Reminder date		M	18	99
FUPFLG	No. of reminders		M	4	1
FUPSCR	Reminders		M	18	99
GENBUT	Generation		M	4	1
GFY	Group		AGF			[AGF]AGF0=[PTR]GFY	Block
GPGCODCOD	Grouping code		M	15	35
GROPRICOD	Gross price		M	15	35
GROPRISCR	Gross price		M	18	99
IDECOD01	Identifier 1		M	15	35
IDECOD02	Identifier 2		M	15	35
IDECOD1	Identifier 1		M	15	35
IDECOD2	Identifier 2		M	15	35
IDESCR01	Identifier 1		M	15	99
IDESCR02	Identifier 2		M	15	99
IDESCR1	Identifier 1		M	18	99
IDESCR2	Identifier 2		M	18	99
INVDTACOD	Invoicing elements		M	15	35
INVFCYCOD	Invoicing site		M	15	35
INVREFCOD	Internal reference		M	15	35
ITMDESCOD	Descriptions	2	M	15	35
ITMDESSCR	Descriptions	2	M	18	99
ITMKNDCOD	Product type		M	15	35
ITMKNDSCR	Product type		M	15	99
LEDTYPCOD	Ledger type	20	M	15	35
LEDTYPSCR	Ledger type		M	18	99
LEDTYPSRT	Sort by ledger type	20	C	4
LINAMTFLG	Line amount - tax		M	4	1
LINAMTSCR	Line amount - tax		M	18	99
LININVFLG	Invoiced line		M	4	1
LININVSCR	Invoiced line		M	18	99
LINTYPFLG	Line type		M	4	1
LINTYPSCR	Line type		M	18	99
LOCCOD	Location		M	15	35
LOCSCR	Location		M	18	99
LOTCOD	Lot		M	15	35
LOTFLG	Lot		M	4	1
LOTSCR	Lot		M	18	99
LPNCOD	Container		M	15	35
LPNFLG	Container		M	4	1
LPNSCR	Container		M	15	99
MATFLG	Matching tolerance		M	4	1
MATSCR	Tolerance code		M	18	99
MATTOLCOD	Matching tolerance		M	15	35
MATTOLSCR	Matching tolerance		M	18	99
MATTYPCOD	Tolerance code		M	15	35
MATTYPSCR	Tolerance code		M	18	99
MCCIMPMOD	Provisional cost		M	15	2366
MDLCOD	Delivery mode		M	15	35
MFGFCYCOD	Production site		M	15	35
MFGNUMFLG	Work order		M	4	1
MFGNUMSCR	Work order no.		M	18	99
MODALL	Allocation method		M	15	398
MVTDESCOD	Movement description	2	M	15	35
MVTDESSCR	Movement description		M	18	99
MVTPRICOD	Movement price	2	M	15	35
MVTPRISCR	Movement price		M	18	99
NBRCOL	No. of fixed columns		C	2
NBSLOFLG	Sub-lot no.		M	4	1
NPRFLG	Auto print		M	4	1
NPRNAM	Document		ARP			[ARP]ARP0=[PTR]NPRNAM	Block
OCNDATCOD	Acknowledgment date		M	15	35
OCNDATFLG	Acknowledgment date		M	4	1
OCNDATSCR	Ack. date		M	18	99
OCNNUMCOD	Acknowledgement ID		M	15	35
OCNNUMFLG	Acknowledgement ID		M	4	1
OCNNUMSCR	Ack. ID		M	18	99
OCNREMCOD	Ack. notes		M	15	35
OPEENDCOD	End date		M	15	35
OPESTRCOD	Start date		M	15	35
ORDDATCOD	Order date		M	15	35
ORDDATSCR	Order date		M	18	99
ORDFREFRTCOD	Free freight threshold		M	15	35
ORDMAXAMTCOD	Maximum order		M	15	35
ORDREFCOD	Internal reference		M	15	35
ORDVOLCOD	Order volume total		M	15	35
ORDWEICOD	Order weight total		M	15	35
ORICRYCOD	Country of origin		M	15	35
ORICRYSCR	Country of origin		M	18	99
ORIFLG	Request source		M	4	1
ORISCR	Request source		M	18	99
PICRETFLG	Requirement considered		M	4	1
PIOCOD	Priority		M	15	35
PJTCOD	Project		M	15	35
PJTHCOD	Header project		M	15	35
PJTSCR	Project		M	18	99
PLICOD	Price list code		M	15	35
POHFCYCOD	Order site		M	15	35
POHFCYSCR	Order site		M	18	99
POHNLCOD	Order no. and line		M	15	35
POHNLFLG	Start/end ln		M	4	556
POHNLSCR	Order no. and line		M	18	99
POHNUMFLG	Purchase order		M	4	1
POHNUMSCR	Purchase order		M	18	99
PORTVACOD	Portuguese VAT		M	15	35
PORTVASCR	Portuguese VAT		M	15	99
PRICOD	Net price		M	15	35
PRIFLG	Net price		M	4	1
PRISCR	Net price		M	18	99
PRNCOD1	Printing		M	15	708
PRNFLG	Printed		M	4	1
PRNNBFLG1	No. prints		M	4	1
PRNNBSCR1	No. prints		M	15	99
PRNSCR	Printed		M	18	99
PRNSCR1	Printing		M	15	99
PSHFLG	Request		M	4	1
PSHSCR	Request		M	18	99
PTECOD	Payment term		M	15	35
PTRDES	Description		A	35
PTRNUM	Transaction		TRS
PTRTYP	Transaction type		M	20	517
PTRTYPCAR	Alpha no.		A	2
PURTYPCOD	Purchase type		M	15	35
PURTYPSCR	Purchase type		M	18	99
PUUFLG	Purchase unit		M	4	1
PUUSCR	Purchase unit		M	18	99
QRQBUT	RFQs		M	4	1
QTYPICFLG	Selected quantity		M	4	1
QTYPICSCR	Selected qty		M	18	99
QTYPUUCOD	PUR quantity		M	20	514
QTYSTUCOD	STK quantity		M	15	35
QTYSTUSCR	STK quantity		M	18	99
QTYUOMCOD	Ordered qty.		M	20	514
QTYVOUCOD	Volume		M	15	35
QTYVOUSCR	Volume		M	18	99
QTYWEUCOD	Weight		M	15	35
QTYWEUSCR	Weight		M	18	99
QUAFLG	QC management		M	4	1
QUAFLGCOD	QC code		M	15	35
QUAFLGSCR	QC code		M	18	99
QUASCR	QC management		M	18	99
RATCURCOD	Currency rate		M	15	35
RCPADDCOD	Receipt address		M	15	35
RCPADDSCR	Receipt address		M	18	99
RCPDAT1COD	Receipt date		M	15	35
RCPFCYCOD	Receiving site		M	15	35
RCPFCYSCR	Receiving site		M	18	99
REACSTPURCOD	Actual purchase cost		M	15	35
REACSTPURSCR	Actual purchase cost		M	18	99
REFORICOD	Original document ref		M	15	35
REFORIPOS	Position on line		M	18	556
REFORISCR	Original document ref		M	18	99
REQCOD	Requester		M	15	35
REVFLG	Revision no.		M	4	1
REVSCR	Revision no.		M	18	99
RSPFLG	No. of responses		M	4	1
RSPSCR	Responses		M	18	99
SCOADDCOD	Subcontract address		M	15	35
SCOADDSCR	Subcon. address		M	18	99
SCOLTICOD	Subcontract LT		M	15	35
SCOSTA	Authorized statuses		M	15	370
SERCOD	Starting serial number		M	15	35
SERECOD	Ending serial number	2	M	15	35
SERESCR	Ending serial number	2	M	18	99
SERESCR1	Ending serial number		M	15	99
SERSCR	Starting serial number		M	18	99
SLOCOD	Sublot		M	15	35
SLOSCR	Sublot		M	18	99
SOHNUMFLG	Sales order		M	4	1
SOHNUMSCR	Sales order		M	18	99
SPERFLG	Expiration		M	4	1
SPOTFLG	Potency		M	4	1
SPTVACOD	VAT Spain		M	15	35
SRGWAIFLG	Receipt at dock		M	4	1
SRUB1FLG	Heading 1		M	4	1
SRUB2FLG	Section 2		M	4	1
SRUB3FLG	Section 3		M	4	1
SRUB4FLG	Section 4		M	4	1
STACOD	Status		M	15	35
STAFLG	Document status		M	4	1
STASCR	Status		M	18	99
STCNUMCOD	Cost structure		M	15	35
STCNUMSCR	Cost structure		M	18	99
STKFLG	Automatic issue		M	4	1
STOCODMAN	Manual only		M	4	1
STOFCYCOD	Shipment site	2	M	15	35
STOFCYSCR	Shipment site		M	18	99
STRDATCOD	Due date basis		M	15	35
SVCDATCOD	Benefit period	2	M	15	35
SVCDATSCR	Benefit period	2	M	15	99
TECFLG	Auto print		M	4	1
TECNAM	Document		ARP			[ARP]ARP0=[PTR]TECNAM	Block
TRSAUTO	Automtc. transaction		M	4	1
TRSCOD	Movement code		ADI			[ADI]CODE=14;TRSCOD	Block
TRSCODS	Movement code		ADI			[ADI]CODE=14;TRSCODS	Other
TRSFAMCOD	Stock movement group		M	15	35
TRSFAMDEF	Transaction group		ADI			[ADI]CODE=9;TRSFAMDEF	Block
TRSFAMS	Transaction group		ADI			[ADI]CODE=9;TRSFAMS	Other
TRSFAMSCR	Stock movement group		M	18	99
UNTWEICOD	Unit weight		M	15	35
UNTWEISCR	Unit weight		M	18	99
UOMCOECOD	Coefficient		M	15	35
UOMCOESCR	Coefficient		M	18	99
UOMSAIFLG	UOM entry		M	4	1
UOMSAIFLG1	Enter PAC		M	4	1
UPDDAT	Change date		D
UPDDATTIM	Date time		ADATIM
UPDUSR	Change user		A	5
USEPLCCOD	Location reference		M	15	35
USEPLCSCR	Location reference		M	18	99
VACBPRCOD	Tax rule		M	15	35
VATCOD	Tax codes	7	M	15	35
VATSCR	Tax codes	7	M	18	99
VLTFDRCOD	Valuation tab		M	15	35
WRHCOD	Warehouse		M	15	35
WRHCOD1	Line warehouse		M	15	35
WRHOBY	Single warehouse		M	15	1
WRHSCR	Warehouse		M	15	99
WRHSCR1	Line warehouse		M	15	99