View: Purchase Order Postings

RotoID: PO0621
Table: POPORI
Protocol: Header, Key auto generate
DLL:POPORI

Compositions: 8

RotoID Tables Title DLL
PO0631 POPORM Purchase Order Posting Lines POPORM
PO0619 Purchase Order Functions POPORG
PO0620 POPORH1POPORH2 Purchase Orders POPORH
PO0750 PORQNC Requisition Comments PORQNC
PO0759 Requisition Functions PORQNG
PO0760 PORQNH1PORQNH2 Requisitions PORQNH
PO0770 PORQNL Requisition Lines PORQNL
PO0777 PORQNLV Requisition Vendors PORQNLV

Keys: 2

Title Fields
Master Key PORISEQ
Receipts PORHSEQ

Fields: 60

Field Index Type Title Attributes Presentation
PORISEQ 1 BCD*10.0 Purchase Order Sequence Key E A K R 
OPERATION 2 Integer Operation To Post E A 
DATE 3 Date Date E A 
POSTDATE 4 Date Last Posting Date E A 
ISCOMPLETE 5 Boolean Completed A  List:2 entries
0 = No
1 = Yes
DTCOMPLETE 6 Date Date Completed A 
PORHSEQ 7 BCD*10.0 Purchase Order Sequence Key E A X 
CURRENCY 8 String*3 Currency E A 
TAXCLASS1 9 Integer Tax Class 1 E A 
TAXCLASS2 10 Integer Tax Class 2 E A 
TAXCLASS3 11 Integer Tax Class 3 E A 
TAXCLASS4 12 Integer Tax Class 4 E A 
TAXCLASS5 13 Integer Tax Class 5 E A 
SCDOCTOTAL 14 BCD*10.3 Source Document Total E A 
ISPRINTED 15 Boolean Printed E A  List:2 entries
0 = No
1 = Yes
PONUMBER 16 String*22 Purchase Order Number E A 
LASTRECEIP 17 String*22 Last Receipt Number E A 
RCPCOUNT 18 Integer Number of Posted Receipts E A 
DESCRIPTIO 19 String*60 Description E A 
REFERENCE 20 String*60 Reference E A 
HASRQNDATA 21 Boolean Requisitions E A  List:2 entries
0 = No
1 = Yes
PORTYPE 22 Integer Purchase Order Type E A 
ONHOLD 23 Boolean On Hold E A  List:2 entries
0 = No
1 = Yes
RQNNUMBER 24 String*22 Requisition Number E A 
RQNHSEQ 25 BCD*10.0 Requisition Sequence Key E A 
VDCODE 26 String*12 Vendor E A 
VDNAME 27 String*60 Name E A 
RATE 28 BCD*8.7 Exchange Rate E A 
RATETYPE 29 String*2 Rate Type E A 
RATEDATE 30 Date Rate Date E A 
RATEOPER 31 Integer Rate Operation E A 
RATEOVER 32 Boolean Rate Overridden E A  List:2 entries
0 = No
1 = Yes
SCURNDECML 33 Integer Decimal Places E A 
TAXGROUP 34 String*12 Tax Group E A 
TAXAUTH1 35 String*12 Tax Authority 1 E A 
TAXAUTH2 36 String*12 Tax Authority 2 E A 
TAXAUTH3 37 String*12 Tax Authority 3 E A 
TAXAUTH4 38 String*12 Tax Authority 4 E A 
TAXAUTH5 39 String*12 Tax Authority 5 E A 
SCAMOUNT 40 BCD*10.3 Conversion Source Amount E A 
FCAMOUNT 41 BCD*10.3 Conversion Functional Amount E A 
HASJOB 42 Boolean Job Related E A  List:2 entries
0 = No
1 = Yes
AGENTTTYPE 43 Integer Agent Transaction Type E A 
AGENTHSEQ 44 BCD*10.0 Agent Sequence Key E A 
AGTRANSNUM 45 BCD*10.0 Agent Dayend Transaction Number E A 
AGDOCNUM 46 String*22 Agent Document Number E A 
AGSRCDOC 47 String*22 Agent Source Document E A 
AGMULTIDOC 48 Boolean Agent Is From Multiple Documents E A  List:2 entries
0 = No
1 = Yes
AGDATE 49 Date Agent Date E A 
AGFISCYEAR 50 String*4 Agent Fiscal Year E A 
AGFISCPER 51 Integer Agent Fiscal Period E A 
AGDESC 52 String*60 Agent Description E A 
AGREF 53 String*60 Agent Reference E A 
TRCURRENCY 54 String*3 Tax Reporting Currency E A 
RATERC 55 BCD*8.7 Tax Reporting Exchange Rate E A 
RATETYPERC 56 String*2 Tax Reporting Rate Type E A 
RATEDATERC 57 Date Tax Reporting Rate Date E A 
RATEOPERRC 58 Integer Tax Reporting Rate Operation E A 
RATERCOVER 59 Boolean Tax Reporting Rate Overridden E A  List:2 entries
0 = No
1 = Yes
RCURNDECML 60 Integer Tax Reporting Decimal Places E A 

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).