Table: Return Audit Costs

Table: PORETAS
View: PO0728
Record Length: 812

Flags: A R 

Keys: 1

Title Flags Fields
Detail Key DAYENDSEQ, RETAHSEQ, RETASSEQ

Fields: 71

Field Type Title Presentation
DAYENDSEQ BCD*10.0 Day End Number
RETAHSEQ BCD*10.0 Processing Sequence
RETASSEQ BCD*10.0 Cost Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
TRANSTYPE Integer Transaction Type
PONUMBER String*22 Purchase Order Number Mask: %-22C
RCPNUMBER String*22 Receipt Number Mask: %-22C
INVNUMBER String*22 Invoice Number Mask: %-22C
CRNNUMBER String*22 Credit/Debit Note Number Mask: %-22C
ADDCOST String*6 Additional Cost Mask: %-6N
DESCRIPTIO String*60 Description
PRORMETHOD Integer Proration Method List:5 entries
1 = No Proration
2 = Prorate by Quantity
3 = Prorate by Cost
4 = Prorate by Weight
5 = Prorate Manually
REPRORATE Integer Reproration Method List:3 entries
1 = Leave
2 = Prorate
3 = Expense
VENDOR String*12 Vendor Mask: %-12C
VENDORNAME String*60 Name
TAXGROUP String*12 Tax Group Mask: %-12N
TAXAUTH1 String*12 Tax Authority 1
TAXAUTH2 String*12 Tax Authority 2
TAXAUTH3 String*12 Tax Authority 3
TAXAUTH4 String*12 Tax Authority 4
TAXAUTH5 String*12 Tax Authority 5
CURRENCY 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
TAXVCLASS1 Integer Vendor Tax Class 1
TAXVCLASS2 Integer Vendor Tax Class 2
TAXVCLASS3 Integer Vendor Tax Class 3
TAXVCLASS4 Integer Vendor Tax Class 4
TAXVCLASS5 Integer Vendor Tax Class 5
TAXICLASS1 Integer Cost Tax Class 1
TAXICLASS2 Integer Cost Tax Class 2
TAXICLASS3 Integer Cost Tax Class 3
TAXICLASS4 Integer Cost Tax Class 4
TAXICLASS5 Integer Cost Tax Class 5
TAXINCLUD1 Boolean Tax Includable 1 List:2 entries
0 = No
1 = Yes
TAXINCLUD2 Boolean Tax Includable 2 List:2 entries
0 = No
1 = Yes
TAXINCLUD3 Boolean Tax Includable 3 List:2 entries
0 = No
1 = Yes
TAXINCLUD4 Boolean Tax Includable 4 List:2 entries
0 = No
1 = Yes
TAXINCLUD5 Boolean Tax Includable 5 List:2 entries
0 = No
1 = Yes
NOPRORTOGL Boolean Exp. Add'l Cost G/L data posted? List:2 entries
0 = No
1 = Yes
COMMENT String*250 Comment
CONTRACT String*16 Contract Mask: %-16C
PROJECT String*16 Project Mask: %-16N
CCATEGORY String*16 (Cost) Category Mask: %-16N
COSTCLASS Integer Cost Class List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
RESOURCE String*24 Resource Mask: %-24C
BILLTYPE Integer Billing Type List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLCURR String*3 Billing Currency Mask: %-3N
ARITEMNO String*16 A/R Item Number Mask: %-16C
ARUNIT String*10 A/R Unit of Measure Mask: %-10C
CALCOVRHD Boolean Calculate Overhead List:2 entries
0 = No
1 = Yes
CALCLABOR Boolean Calculate Labor List:2 entries
0 = No
1 = Yes
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
RTGPERCENT BCD*5.5 Retainage Percentage
RTGDAYS Integer Retention Period
PMTRANSNUM Long PJC Transaction Number
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

This page was generated on 2023-Aug-31

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