View: Return Audit Costs

RotoID: PO0728
Table: PORETAS
Protocol: Detail
DLL:PORETAS

Compositions: 1

RotoID Tables Title DLL
PO0724 PORETAH Return Audit Headers PORETAH

Keys: 1

Title Fields
Detail Key DAYENDSEQ, RETAHSEQ, RETASSEQ

Fields: 67

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 
RETASSEQ 3 BCD*10.0 Cost Number E A K R 
TRANSTYPE 4 Integer Transaction Type E A 
PONUMBER 5 String*22 Purchase Order Number E A  Mask: %-22C
RCPNUMBER 6 String*22 Receipt Number E A  Mask: %-22C
INVNUMBER 7 String*22 Invoice Number E A  Mask: %-22C
CRNNUMBER 8 String*22 Credit/Debit Note Number E A  Mask: %-22C
ADDCOST 9 String*6 Additional Cost E A  Mask: %-6N
DESCRIPTIO 10 String*60 Description E A 
PRORMETHOD 11 Integer Proration Method E A  List:5 entries
1 = No Proration
2 = Prorate by Quantity
3 = Prorate by Cost
4 = Prorate by Weight
5 = Prorate Manually
REPRORATE 12 Integer Reproration Method E A  List:3 entries
1 = Leave
2 = Prorate
3 = Expense
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 
TAXAUTH2 17 String*12 Tax Authority 2 E A 
TAXAUTH3 18 String*12 Tax Authority 3 E A 
TAXAUTH4 19 String*12 Tax Authority 4 E A 
TAXAUTH5 20 String*12 Tax Authority 5 E A 
CURRENCY 21 String*3 Currency E A  Mask: %-3N
EXRATE 22 BCD*8.7 Exchange Rate E A 
RATEDATE 23 Date Rate Date E A 
RATETYPE 24 String*2 Rate Type E A  Mask: %-2N
RATEOPER 25 Integer Rate Operation E A  List:2 entries
1 = Multiply
2 = Divide
RATEOVER 26 Boolean Rate Overridden E A  List:2 entries
0 = No
1 = Yes
SCURNDECML 27 Integer Decimal Places E A 
TAXVCLASS1 28 Integer Vendor Tax Class 1 E A 
TAXVCLASS2 29 Integer Vendor Tax Class 2 E A 
TAXVCLASS3 30 Integer Vendor Tax Class 3 E A 
TAXVCLASS4 31 Integer Vendor Tax Class 4 E A 
TAXVCLASS5 32 Integer Vendor Tax Class 5 E A 
TAXICLASS1 33 Integer Cost Tax Class 1 E A 
TAXICLASS2 34 Integer Cost Tax Class 2 E A 
TAXICLASS3 35 Integer Cost Tax Class 3 E A 
TAXICLASS4 36 Integer Cost Tax Class 4 E A 
TAXICLASS5 37 Integer Cost Tax Class 5 E A 
TAXINCLUD1 38 Boolean Tax Includable 1 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD2 39 Boolean Tax Includable 2 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD3 40 Boolean Tax Includable 3 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD4 41 Boolean Tax Includable 4 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD5 42 Boolean Tax Includable 5 E A  List:2 entries
0 = No
1 = Yes
NOPRORTOGL 43 Boolean Exp. Add'l Cost G/L data posted? E A  List:2 entries
0 = No
1 = Yes
COMMENT 44 String*250 Comment E A 
CONTRACT 45 String*16 Contract E A  Mask: %-16C
PROJECT 46 String*16 Project E A  Mask: %-16N
CCATEGORY 47 String*16 (Cost) Category E A  Mask: %-16N
COSTCLASS 48 Integer Cost Class E A  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
RESOURCE 49 String*24 Resource E A  Mask: %-24C
BILLTYPE 50 Integer Billing Type E A  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLCURR 51 String*3 Billing Currency E A  Mask: %-3N
ARITEMNO 52 String*16 A/R Item Number E A  Mask: %-16C
ARUNIT 53 String*10 A/R Unit of Measure E A  Mask: %-10C
CALCOVRHD 54 Boolean Calculate Overhead E A  List:2 entries
0 = No
1 = Yes
CALCLABOR 55 Boolean Calculate Labor E A  List:2 entries
0 = No
1 = Yes
HASRTG 56 Boolean Has Retainage E A  List:2 entries
0 = No
1 = Yes
RTGRATE 57 Integer Retainage Exchange Rate E A  List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGPERCENT 58 BCD*5.5 Retainage Percentage E A 
RTGDAYS 59 Integer Retention Period E A 
PMTRANSNUM 60 Long PJC Transaction Number E A 
TRCURRENCY 61 String*3 Tax Reporting Currency E A  Mask: %-3N
EXRATERC 62 BCD*8.7 Tax Reporting Exchange Rate E A 
RATEDATERC 63 Date Tax Reporting Rate Date E A 
RATETYPERC 64 String*2 Tax Reporting Rate Type E A  Mask: %-2N
RATEOPERRC 65 Integer Tax Reporting Rate Operation E A  List:2 entries
1 = Multiply
2 = Divide
RATERCOVER 66 Boolean Tax Reporting Rate Overridden E A  List:2 entries
0 = No
1 = Yes
RCURNDECML 67 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).