Table: Purchase Order Audit Headers

Table: POPORAH
View: PO0612
Record Length: 707

Flags: A R 

Keys: 4

Title Flags Fields

Master Key DAYENDSEQPORAHSEQ
Vendor VENDORDAYENDSEQPORAHSEQ
Transaction Date TRANSDATEDAYENDSEQPORAHSEQ
Document Number PONUMBERDAYENDSEQPORAHSEQ

Fields: 71

Field Type Title Presentation

DAYENDSEQ BCD*10.0 Day End Number
PORAHSEQ BCD*10.0 Processing Sequence
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
ISPRINTED Boolean Printed List:2 entries
0 = No
1 = Yes
PORHSEQ BCD*10.0 Purchase Order Sequence Key
POSTDATE Date Last Posting Date
DAYENDDATE Date Day End Processing Date
TRANSDATE Date Transaction Date
PORTYPE Integer Purchase Order Type List:4 entries
1 = Active
2 = Standing
3 = Future
4 = Blanket
ONHOLD Boolean On Hold List:2 entries
0 = No
1 = Yes
REFERENCE String*60 Reference
DESCRIPTIO String*60 Description
TRANSTYPE Integer Transaction Type List:3 entries
1 = Purchase Order
2 = Purchase Order Adjustment
3 = Purchase Order Deletion
VENDOR String*12 Vendor Mask: %-12C
VENDORNAME String*60 Name
TAXGROUP String*12 Tax Group Mask: %-12N
TAXAUTH1 String*12 Tax Authority 1 Mask: %-12N
TAXAUTH2 String*12 Tax Authority 2 Mask: %-12N
TAXAUTH3 String*12 Tax Authority 3 Mask: %-12N
TAXAUTH4 String*12 Tax Authority 4 Mask: %-12N
TAXAUTH5 String*12 Tax Authority 5 Mask: %-12N
TAXCLASS1 Integer Tax Class 1
TAXCLASS2 Integer Tax Class 2
TAXCLASS3 Integer Tax Class 3
TAXCLASS4 Integer Tax Class 4
TAXCLASS5 Integer Tax Class 5
PONUMBER String*22 Purchase Order Number Mask: %-22C
LASTRECEIP String*22 Last Receipt Number Mask: %-22C
RCPCOUNT Integer Number of Posted Receipts
POCURR String*3 Currency Mask: %-3N
EXRATE BCD*8.7 Exchange Rate
RATEDATE Date Rate Date
RATETYPE String*2 Rate Type Mask: %-2N
RATEOPER Integer Rate Operation List:2 entries
1 = Multiply
2 = Divide
RATEOVER Boolean Rate Overridden List:2 entries
0 = No
1 = Yes
SCURNDECML Integer Decimal Places
FCDOCTOTAL BCD*10.3 Functional Total Cost
SCDOCTOTAL BCD*10.3 Source Document Total
COMPLETE Boolean Completed List:2 entries
0 = No
1 = Yes
PRINTED Boolean Printed List:2 entries
0 = No
1 = Yes
HASRQNDATA Boolean Requisitions List:2 entries
0 = No
1 = Yes
PGMVER String*3 Program Version
VALUES Long Optional Fields
HASJOB Boolean Job Related List:2 entries
0 = No
1 = Yes
PVTRANDATE Date Previous Transaction Date
PVEXRATE BCD*8.7 Previous Exchange Rate
PVRATEDATE Date Previous Rate Date
PVRATETYPE String*2 Previous Rate Type Mask: %-2N
PVRATEOPER Integer Previous Rate Operation List:2 entries
1 = Multiply
2 = Divide
AGENTTTYPE Integer Agent Transaction Type List:3 entries
99 = None
3 = Receipt
5 = Invoice
AGENTHSEQ BCD*10.0 Agent Sequence Key
AGTRANSNUM BCD*10.0 Agent Dayend Transaction Number
AGDOCNUM String*22 Agent Document Number Mask: %-22C
AGSRCDOC String*22 Agent Source Document Mask: %-22C
AGMULTIDOC Boolean Agent Is From Multiple Documents List:2 entries
0 = No
1 = Yes
AGDATE Date Agent Date
AGFISCYEAR String*4 Agent Fiscal Year Mask: %4D
AGFISCPER Integer Agent Fiscal Period
AGDESC String*60 Agent Description
AGREF String*60 Agent Reference
TRCURRENCY String*3 Tax Reporting Currency Mask: %-3N
EXRATERC BCD*8.7 Tax Reporting Exchange Rate
RATEDATERC Date Tax Reporting Rate Date
RATETYPERC String*2 Tax Reporting Rate Type Mask: %-2N
RATEOPERRC Integer Tax Reporting Rate Operation List:2 entries
1 = Multiply
2 = Divide
RATERCOVER Boolean Tax Reporting Rate Overridden List:2 entries
0 = No
1 = Yes
RCURNDECML Integer Tax Reporting Decimal Places
VDACCTSET String*6 Vendor Account Set Mask: %-6N