View: Return Audit Headers

RotoID: PO0724
Table: PORETAH
Protocol: Header
DLL:PORETAH

Compositions: 4

RotoID Tables Title DLL
PO0726 PORETAL Return Audit Lines PORETAL
PO0727 PORETAQ Return Audit Prorate Lines PORETAQ
PO0728 PORETAS Return Audit Costs PORETAS
PO0740 POREAHO Return Audit Hdr. Opt. Fields POREAHO

Keys: 4

Title Fields
Master Key DAYENDSEQ, RETAHSEQ
Vendor VENDOR, DAYENDSEQ, RETAHSEQ
Transaction Date TRANSDATE, DAYENDSEQ, RETAHSEQ
Document Number RETNUMBER, DAYENDSEQ, RETAHSEQ

Fields: 56

Field Index Type Title Attributes Presentation
DAYENDSEQ 1 BCD*10.0 Day End Number E A K R 
RETAHSEQ 2 BCD*10.0 Processing Sequence E A K R 
ISPRINTED 3 Boolean Printed E A  List:2 entries
0 = No
1 = Yes
RETHSEQ 4 BCD*10.0 Return 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 
REFERENCE 8 String*60 Reference E A 
FISCYEAR 9 String*4 Fiscal Year E A  Mask: %4D
FISCPERIOD 10 Integer Fiscal Period E A 
DESCRIPTIO 11 String*60 Description E A 
TRANSTYPE 12 Integer Transaction Type E A  List:4 entries
1 = Receipt
2 = Receipt Adjustment
3 = Return
99 = Sequence Placeholder (?)
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 
RETNUMBER 26 String*22 Return Number E A 
PONUMBER 27 String*22 Purchase Order Number E A 
RCPNUMBER 28 String*22 Receipt Number E A 
RCPCURR 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
VALUES 40 Long Optional Fields E A C 
PGMVER 41 String*3 Program Version E A 
VERPRORATE 42 Integer Proration Version E A  List:2 entries
1 = 3.0A
2 = 5.3B
HASRTG 43 Boolean Has Retainage E A  List:2 entries
0 = No
1 = Yes
RTGRATE 44 Integer Retainage Exchange Rate E A  List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGBASE 45 Integer Retainage Base E A  List:2 entries
0 = Total After Taxes
1 = Total Before Taxes
SCRTGAMT 46 BCD*10.3 Retainage Amount E A 
HASJOB 47 Boolean Job Related E A  List:2 entries
0 = No
1 = Yes
TRCURRENCY 48 String*3 Tax Reporting Currency E A  Mask: %-3N
EXRATERC 49 BCD*8.7 Tax Reporting Exchange Rate E A 
RATEDATERC 50 Date Tax Reporting Rate Date E A 
RATETYPERC 51 String*2 Tax Reporting Rate Type E A  Mask: %-2N
RATEOPERRC 52 Integer Tax Reporting Rate Operation E A  List:2 entries
1 = Multiply
2 = Divide
RATERCOVER 53 Boolean Tax Reporting Rate Overridden E A  List:2 entries
0 = No
1 = Yes
RCURNDECML 54 Integer Tax Reporting Decimal Places E A 
DATEBUS 55 Date Posting Date E A 
VDACCTSET 56 String*6 Vendor Account Set E A  Mask: %-6N

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