View: Return Audit Lines

RotoID: PO0726
Table: PORETAL
Protocol: Detail
DLL:PORETAL

Compositions: 2

RotoID Tables Title DLL
PO0724 PORETAH Return Audit Headers PORETAH
PO0741 POREALO Return Audit Line Opt. Fields POREALO

Keys: 2

Title Fields
Detail Key DAYENDSEQ, RETAHSEQ, RETALSEQ
Detail Number DAYENDSEQ, RETAHSEQ, DETAILNUM, RETALSEQ

Fields: 130

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 
RETALSEQ 3 BCD*10.0 Line Number E A K R 
TRANSTYPE 4 Integer Transaction Type E A 
OEONUMBER 5 String*22 Order Number E A  Mask: %-22C
ITEMEXISTS 6 Boolean Item Exists E A  List:2 entries
0 = No
1 = Yes
ITEMNO 7 String*24 Item Number E A  Mask: %-24C
LOCATION 8 String*6 Location E A  Mask: %-6N
ITEMDESC 9 String*60 Item Description E A 
CNTLACCT 10 String*6 Control Account E A 
TAXCLASS1 11 Integer Tax Class 1 E A 
TAXCLASS2 12 Integer Tax Class 2 E A 
TAXCLASS3 13 Integer Tax Class 3 E A 
TAXCLASS4 14 Integer Tax Class 4 E A 
TAXCLASS5 15 Integer Tax Class 5 E A 
RQRETURNED 16 BCD*10.4 Quantity Returned E A 
RETUNIT 17 String*10 Unit of Measure E A  Mask: %-10c
CONVERSION 18 BCD*10.6 Conversion Factor to Stocking E A 
COSTCONV 19 BCD*10.6 Cost unit conversion E A 
SQRETURNED 20 BCD*10.4 Stocking Quantity Returned E A 
STOCKUNIT 21 String*10 Unit of Measure E A  Mask: %-10c
COSTUNIT 22 String*10 Costing unit of measure E A  Mask: %-10c
UNITCOST 23 BCD*10.6 Unit Cost E A 
PRUNITCOST 24 BCD*10.6 Unit Cost E A 
LOADEDCOST 25 BCD*10.6 Fully-loaded cost E A 
FCEXTENDED 26 BCD*10.3 Func. Extended Amount E A 
SCEXTENDED 27 BCD*10.3 Extended Amount E A 
FCBASEALLO 28 BCD*10.3 Func. Base to Allocate E A 
SCBASEALLO 29 BCD*10.3 Base to Allocate E A 
FCTAXALLO 30 BCD*10.3 Func. Total Tax Allocated E A 
SCTAXALLO 31 BCD*10.3 Total Tax Allocated E A 
FCPRORATED 32 BCD*10.3 Func. Total Prorate Allocated E A 
SCPRORATED 33 BCD*10.3 Total Prorate Allocated E A 
FCTAXINCL 34 BCD*10.3 Func. Tax Included in Price E A 
SCTAXINCL 35 BCD*10.3 Tax Included in Price E A 
FCTAXEXCL 36 BCD*10.3 Func. Tax Excluded from Price E A 
SCTAXEXCL 37 BCD*10.3 Tax Excluded from Price E A 
TAXBASE1 38 BCD*10.3 Tax Base 1 E A 
TAXBASE2 39 BCD*10.3 Tax Base 2 E A 
TAXBASE3 40 BCD*10.3 Tax Base 3 E A 
TAXBASE4 41 BCD*10.3 Tax Base 4 E A 
TAXBASE5 42 BCD*10.3 Tax Base 5 E A 
TAXINCLUD1 43 Boolean Tax Includable 1 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD2 44 Boolean Tax Includable 2 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD3 45 Boolean Tax Includable 3 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD4 46 Boolean Tax Includable 4 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD5 47 Boolean Tax Includable 5 E A  List:2 entries
0 = No
1 = Yes
TAXAMOUNT1 48 BCD*10.3 Tax Amount 1 E A 
TAXAMOUNT2 49 BCD*10.3 Tax Amount 2 E A 
TAXAMOUNT3 50 BCD*10.3 Tax Amount 3 E A 
TAXAMOUNT4 51 BCD*10.3 Tax Amount 4 E A 
TAXAMOUNT5 52 BCD*10.3 Tax Amount 5 E A 
TXRECVAMT1 53 BCD*10.3 Tax Recoverable Amount 1 E A 
TXRECVAMT2 54 BCD*10.3 Tax Recoverable Amount 2 E A 
TXRECVAMT3 55 BCD*10.3 Tax Recoverable Amount 3 E A 
TXRECVAMT4 56 BCD*10.3 Tax Recoverable Amount 4 E A 
TXRECVAMT5 57 BCD*10.3 Tax Recoverable Amount 5 E A 
TXEXPSAMT1 58 BCD*10.3 Tax Expense Amount 1 E A 
TXEXPSAMT2 59 BCD*10.3 Tax Expense Amount 2 E A 
TXEXPSAMT3 60 BCD*10.3 Tax Expense Amount 3 E A 
TXEXPSAMT4 61 BCD*10.3 Tax Expense Amount 4 E A 
TXEXPSAMT5 62 BCD*10.3 Tax Expense Amount 5 E A 
GLCLEARING 63 String*45 Receipt Clearing Account E A  Mask: %-45C
GLITEM 64 String*45 G/L Item E A  Mask: %-45C
GLISPOSTED 65 Boolean G/L data to be posted? E A  List:2 entries
0 = No
1 = Yes
GLISDEBIT 66 Boolean Normal G/L debit convention? E A  List:2 entries
0 = No
1 = Yes
RQRETTOTAL 67 BCD*10.4 Total Quantity Returned E A 
SQRETTOTAL 68 BCD*10.4 Total Stock Quantity Returned E A 
FCEXTTOTAL 69 BCD*10.3 Functional Total Cost E A 
SCEXTTOTAL 70 BCD*10.3 Total Cost E A 
STOCKITEM 71 Boolean Stock Item E A  List:2 entries
0 = No
1 = Yes
PONUMBER 72 String*22 Purchase Order Number E A  Mask: %-22C
DISCPCT 73 BCD*5.5 Discount Percentage E A 
FCDISCOUNT 74 BCD*10.3 Func. Discount Amount E A 
SCDISCOUNT 75 BCD*10.3 Discount Amount E A 
FCDISCTOT 76 BCD*10.3 Functional Total Discount E A 
SCDISCTOT 77 BCD*10.3 Total Discount E A 
VALUES 78 Long Optional Fields E A C 
RCPLSEQ 79 BCD*10.0 Receipt Line Sequence E A 
RETLSEQ 80 BCD*10.0 Return Line Sequence E A 
FCTAXRECV 81 BCD*10.3 Func. Total Tax Recoverable E A 
SCTAXRECV 82 BCD*10.3 Total Tax Recoverable E A 
FCTAXEXPS 83 BCD*10.3 Func. Total Tax Expensed E A 
SCTAXEXPS 84 BCD*10.3 Total Tax Expensed E A 
FCTAXAMT1 85 BCD*10.3 Func. Tax Amount 1 E A 
FCTAXAMT2 86 BCD*10.3 Func. Tax Amount 2 E A 
FCTAXAMT3 87 BCD*10.3 Func. Tax Amount 3 E A 
FCTAXAMT4 88 BCD*10.3 Func. Tax Amount 4 E A 
FCTAXAMT5 89 BCD*10.3 Func. Tax Amount 5 E A 
COMMENT 90 String*250 Comment E A 
CONTRACT 91 String*16 Contract E A  Mask: %-16C
PROJECT 92 String*16 Project E A  Mask: %-16N
CCATEGORY 93 String*16 (Cost) Category E A  Mask: %-16N
COSTCLASS 94 Integer Cost Class E A  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
BILLTYPE 95 Integer Billing Type E A  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLRATE 96 BCD*10.6 Billing Rate E A 
BILLCURR 97 String*3 Billing Currency E A  Mask: %-3N
ARITEMNO 98 String*16 A/R Item Number E A  Mask: %-16C
ARUNIT 99 String*10 A/R Unit of Measure E A  Mask: %-10C
RTGPERCENT 100 BCD*5.5 Retainage Percentage E A 
RTGDAYS 101 Integer Retention Period E A 
SCRTGAMT 102 BCD*10.3 Retainage Amount E A 
SCRTGAMTOT 103 BCD*10.3 Total Retainage Amount E A 
RTGAMTOVER 104 Boolean Retainage Amount Overridden E A  List:2 entries
0 = No
1 = Yes
GLOVERHEAD 105 String*45 Overhead Account E A  Mask: %-45C
GLLABOR 106 String*45 Labor Burden Account E A  Mask: %-45C
FCOVRHDAMT 107 BCD*10.3 Func. Overhead Amount E A 
SCOVRHDAMT 108 BCD*10.3 Overhead Amount E A 
FCLABORAMT 109 BCD*10.3 Func. Labor Burden Amount E A 
SCLABORAMT 110 BCD*10.3 Labor Burden Amount E A 
DFCUNITCST 111 BCD*10.6 Func. Unit Cost Difference E A 
DSCUNITCST 112 BCD*10.6 Unit Cost Difference E A 
DBILLRATE 113 BCD*10.6 Billing Rate Difference E A 
PMTRANSNUM 114 Long PJC Transaction Number E A 
RCTAXALLO 115 BCD*10.3 Rptg. Total Tax Allocated E A 
RCTAXRECV 116 BCD*10.3 Rptg. Total Tax Recoverable E A 
RCTAXEXPS 117 BCD*10.3 Rptg. Total Tax Expensed E A 
RCTAXINCL 118 BCD*10.3 Rptg. Total Tax Included E A 
TARAMOUNT1 119 BCD*10.3 Tax Reporting Amount 1 E A 
TARAMOUNT2 120 BCD*10.3 Tax Reporting Amount 2 E A 
TARAMOUNT3 121 BCD*10.3 Tax Reporting Amount 3 E A 
TARAMOUNT4 122 BCD*10.3 Tax Reporting Amount 4 E A 
TARAMOUNT5 123 BCD*10.3 Tax Reporting Amount 5 E A 
SCRAXALLO 124 BCD*10.3 Total Rtg. Tax Allocated E A 
FCRAXALLO 125 BCD*10.3 Func. Total Rtg. Tax Allocated E A 
SCRAXEXPS 126 BCD*10.3 Total Rtg. Tax Expensed E A 
FCRAXEXPS 127 BCD*10.3 Func. Total Rtg. Tax Expensed E A 
DEFEXTWGHT 128 BCD*10.4 Default Extended Weight E A 
TOTDEFEXWT 129 BCD*10.4 Total Def. Ext. Weight E A 
DETAILNUM 130 Integer Detail Number E A 

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