View: Purchase Order Audit Headers

RotoID: PO0612
Table: POPORAH
Protocol: Header
DLL:POPORAH

Compositions: 2

RotoID Tables Title DLL
PO0614 POPORAL Purchase Order Audit Lines POPORAL
PO0611 POPOAHO PO Audit Hdr. Optional Fields POPOAHO

Keys: 4

Title Fields
Master Key DAYENDSEQ, PORAHSEQ
Vendor VENDOR, DAYENDSEQ, PORAHSEQ
Transaction Date TRANSDATE, DAYENDSEQ, PORAHSEQ
Document Number PONUMBER, DAYENDSEQ, PORAHSEQ

Fields: 67

Field Index Type Title Attributes Presentation
DAYENDSEQ 1 BCD*10.0 Day End Number E A K R 
PORAHSEQ 2 BCD*10.0 Processing Sequence E A K R 
ISPRINTED 3 Boolean Printed E A  List:2 entries
0 = No
1 = Yes
PORHSEQ 4 BCD*10.0 Purchase Order Sequence Key E A 
POSTDATE 5 Date Last Posting Date E A 
DAYENDDATE 6 Date Day End Processing Date E A 
TRANSDATE 7 Date Transaction Date E A 
PORTYPE 8 Integer Purchase Order Type E A  List:4 entries
1 = Active
2 = Standing
3 = Future
4 = Blanket
ONHOLD 9 Boolean On Hold E A  List:2 entries
0 = No
1 = Yes
REFERENCE 10 String*60 Reference E A 
DESCRIPTIO 11 String*60 Description E A 
TRANSTYPE 12 Integer Transaction Type E A  List:3 entries
1 = Purchase Order
2 = Purchase Order Adjustment
3 = Purchase Order Deletion
VENDOR 13 String*12 Vendor E A  Mask: %-12C
VENDORNAME 14 String*60 Name E A 
TAXGROUP 15 String*12 Tax Group E A  Mask: %-12N
TAXAUTH1 16 String*12 Tax Authority 1 E A  Mask: %-12N
TAXAUTH2 17 String*12 Tax Authority 2 E A  Mask: %-12N
TAXAUTH3 18 String*12 Tax Authority 3 E A  Mask: %-12N
TAXAUTH4 19 String*12 Tax Authority 4 E A  Mask: %-12N
TAXAUTH5 20 String*12 Tax Authority 5 E A  Mask: %-12N
TAXCLASS1 21 Integer Tax Class 1 E A 
TAXCLASS2 22 Integer Tax Class 2 E A 
TAXCLASS3 23 Integer Tax Class 3 E A 
TAXCLASS4 24 Integer Tax Class 4 E A 
TAXCLASS5 25 Integer Tax Class 5 E A 
PONUMBER 26 String*22 Purchase Order Number E A  Mask: %-22C
LASTRECEIP 27 String*22 Last Receipt Number E A  Mask: %-22C
RCPCOUNT 28 Integer Number of Posted Receipts E A 
POCURR 29 String*3 Currency E A  Mask: %-3N
EXRATE 30 BCD*8.7 Exchange Rate E A 
RATEDATE 31 Date Rate Date E A 
RATETYPE 32 String*2 Rate Type E A  Mask: %-2N
RATEOPER 33 Integer Rate Operation E A  List:2 entries
1 = Multiply
2 = Divide
RATEOVER 34 Boolean Rate Overridden E A  List:2 entries
0 = No
1 = Yes
SCURNDECML 35 Integer Decimal Places E A 
FCDOCTOTAL 36 BCD*10.3 Functional Total Cost E A 
SCDOCTOTAL 37 BCD*10.3 Source Document Total E A 
COMPLETE 38 Boolean Completed E A  List:2 entries
0 = No
1 = Yes
PRINTED 39 Boolean Printed E A  List:2 entries
0 = No
1 = Yes
HASRQNDATA 40 Boolean Requisitions E A  List:2 entries
0 = No
1 = Yes
PGMVER 41 String*3 Program Version E A 
VALUES 42 Long Optional Fields E A C 
HASJOB 43 Boolean Job Related E A  List:2 entries
0 = No
1 = Yes
PVTRANDATE 44 Date Previous Transaction Date E A 
PVEXRATE 45 BCD*8.7 Previous Exchange Rate E A 
PVRATEDATE 46 Date Previous Rate Date E A 
PVRATETYPE 47 String*2 Previous Rate Type E A  Mask: %-2N
PVRATEOPER 48 Integer Previous Rate Operation E A  List:2 entries
1 = Multiply
2 = Divide
AGENTTTYPE 49 Integer Agent Transaction Type E A  List:3 entries
99 = None
3 = Receipt
5 = Invoice
AGENTHSEQ 50 BCD*10.0 Agent Sequence Key E A 
AGTRANSNUM 51 BCD*10.0 Agent Dayend Transaction Number E A 
AGDOCNUM 52 String*22 Agent Document Number E A  Mask: %-22C
AGSRCDOC 53 String*22 Agent Source Document E A  Mask: %-22C
AGMULTIDOC 54 Boolean Agent Is From Multiple Documents E A  List:2 entries
0 = No
1 = Yes
AGDATE 55 Date Agent Date E A 
AGFISCYEAR 56 String*4 Agent Fiscal Year E A  Mask: %4D
AGFISCPER 57 Integer Agent Fiscal Period E A 
AGDESC 58 String*60 Agent Description E A 
AGREF 59 String*60 Agent Reference E A 
TRCURRENCY 60 String*3 Tax Reporting Currency E A  Mask: %-3N
EXRATERC 61 BCD*8.7 Tax Reporting Exchange Rate E A 
RATEDATERC 62 Date Tax Reporting Rate Date E A 
RATETYPERC 63 String*2 Tax Reporting Rate Type E A  Mask: %-2N
RATEOPERRC 64 Integer Tax Reporting Rate Operation E A  List:2 entries
1 = Multiply
2 = Divide
RATERCOVER 65 Boolean Tax Reporting Rate Overridden E A  List:2 entries
0 = No
1 = Yes
RCURNDECML 66 Integer Tax Reporting Decimal Places E A 
VDACCTSET 67 String*6 Vendor Account Set E A  Mask: %-6N

This page was generated on 2021-Nov-24

© 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).