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