Table: Return Audit Headers

Table: PORETAH
View: PO0724
Record Length: 529

Flags: A R 

Keys: 4

Title Flags Fields

Master Key DAYENDSEQRETAHSEQ
Vendor VENDORDAYENDSEQRETAHSEQ
Transaction Date TRANSDATEDAYENDSEQRETAHSEQ
Document Number RETNUMBERDAYENDSEQRETAHSEQ

Fields: 60

Field Type Title Presentation

DAYENDSEQ BCD*10.0 Day End Number
RETAHSEQ 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
RETHSEQ BCD*10.0 Return Sequence Key
POSTDATE Date Last Posting Date
DAYENDDATE Date Day End Processing Date
TRANSDATE Date Transaction Date
REFERENCE String*60 Reference
FISCYEAR String*4 Fiscal Year Mask: %4D
FISCPERIOD Integer Fiscal Period
DESCRIPTIO String*60 Description
TRANSTYPE Integer Transaction Type List:4 entries
1 = Receipt
2 = Receipt Adjustment
3 = Return
99 = Sequence Placeholder (?)
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
RETNUMBER String*22 Return Number
PONUMBER String*22 Purchase Order Number
RCPNUMBER String*22 Receipt Number
RCPCURR 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
VALUES Long Optional Fields
PGMVER String*3 Program Version
VERPRORATE Integer Proration Version List:2 entries
1 = 3.0A
2 = 5.3B
HASRTG Boolean Has Retainage List:2 entries
0 = No
1 = Yes
RTGRATE Integer Retainage Exchange Rate List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGBASE Integer Retainage Base List:2 entries
0 = Total After Taxes
1 = Total Before Taxes
SCRTGAMT BCD*10.3 Retainage Amount
HASJOB Boolean Job Related List:2 entries
0 = No
1 = Yes
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
DATEBUS Date Posting Date
VDACCTSET String*6 Vendor Account Set Mask: %-6N