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 DAYENDSEQRETAHSEQRETALSEQ
Detail Number DAYENDSEQRETAHSEQDETAILNUMRETALSEQ

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