View: Receipt Audit Lines

RotoID: PO0688
Table: PORCPAL
Protocol: Detail
DLL:PORCPAL

Compositions: 2

RotoID Tables Title DLL
PO0686 PORCPAH Receipt Audit Headers PORCPAH
PO0682 PORCALO Receipt Audit Line Opt. Fields PORCALO

Keys: 2

Title Fields
Detail Key DAYENDSEQ, RCPAHSEQ, RCPALSEQ
Detail Number DAYENDSEQ, RCPAHSEQ, DETAILNUM, RCPALSEQ

Fields: 138

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