View: Purchase Order Audit Lines

RotoID: PO0614
Table: POPORAL
Protocol: Detail
DLL:POPORAL

Compositions: 2

RotoID Tables Title DLL
PO0612 POPORAH Purchase Order Audit Headers POPORAH
PO0613 POPOALO PO Audit Line Optional Fields POPOALO

Keys: 2

Title Fields
Detail Key DAYENDSEQ, PORAHSEQ, PORALSEQ
Detail Number DAYENDSEQ, PORAHSEQ, DETAILNUM, PORALSEQ

Fields: 112

Field Index Type Title Attributes Presentation
DAYENDSEQ 1 BCD*10.0 Day End Number E A K R 
PORAHSEQ 2 BCD*10.0 Processing Sequence E A K R 
PORALSEQ 3 BCD*10.0 Line Number E A K R 
TRANSTYPE 4 Integer Transaction Type E A 
AGENTLSEQ 5 BCD*10.0 Agent Line Sequence E A 
OEONUMBER 6 String*22 Order Number E A  Mask: %-22C
CONTRACT 7 String*16 Contract E A  Mask: %-16C
PROJECT 8 String*16 Project E A  Mask: %-16N
CCATEGORY 9 String*16 (Cost) Category E A  Mask: %-16N
COSTCLASS 10 Integer Cost Class E A  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
ITEMEXISTS 11 Boolean Item Exists E A  List:2 entries
0 = No
1 = Yes
ITEMNO 12 String*24 Item Number E A  Mask: %-24C
STOCKITEM 13 Boolean Stock Item E A  List:2 entries
0 = No
1 = Yes
LOCATION 14 String*6 Location E A  Mask: %-6N
ITEMDESC 15 String*60 Item Description E A 
BILLTYPE 16 Integer Billing Type E A  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLRATE 17 BCD*10.6 Billing Rate E A 
BILLCURR 18 String*3 Billing Currency E A  Mask: %-3N
ARITEMNO 19 String*16 A/R Item Number E A  Mask: %-16C
ARUNIT 20 String*10 A/R Unit of Measure E A  Mask: %-10C
PVLOCATION 21 String*6 Previous Location E A  Mask: %-6N
PVORDUNIT 22 String*10 Previous Order Unit E A  Mask: %-10c
PVORDCONV 23 BCD*10.6 Previous Order Unit Conversion E A 
PVBILLTYPE 24 Integer Previous Billing Type E A  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
DBILLRATE 25 BCD*10.6 Billing Rate Difference E A 
PVARITEMNO 26 String*16 Previous A/R Item Number E A  Mask: %-16C
PVARUNIT 27 String*10 Previous A/R Unit of Measure E A  Mask: %-10C
TAXCLASS1 28 Integer Tax Class 1 E A 
TAXCLASS2 29 Integer Tax Class 2 E A 
TAXCLASS3 30 Integer Tax Class 3 E A 
TAXCLASS4 31 Integer Tax Class 4 E A 
TAXCLASS5 32 Integer Tax Class 5 E A 
OQORDERED 33 BCD*10.4 Quantity Ordered E A 
OQRECEIVED 34 BCD*10.4 Quantity Received E A 
OQCANCELED 35 BCD*10.4 Quantity Canceled E A 
OQOUTSTAND 36 BCD*10.4 Quantity Outstanding E A 
ORDERUNIT 37 String*10 Unit of Measure E A  Mask: %-10c
CONVERSION 38 BCD*10.6 Conversion Factor to Stocking E A 
SQOUTSTAND 39 BCD*10.4 Stocking Quantity Outstanding E A 
STOCKUNIT 40 String*10 Unit of Measure E A  Mask: %-10c
UNITCOST 41 BCD*10.6 Unit Cost E A 
DFCUNITCST 42 BCD*10.6 Func. Unit Cost Difference E A 
DSCUNITCST 43 BCD*10.6 Unit Cost Difference E A 
FCEXTENDED 44 BCD*10.3 Func. Extended Amount E A 
SCEXTENDED 45 BCD*10.3 Extended Amount E A 
FCBASEALLO 46 BCD*10.3 Func. Base to Allocate E A 
SCBASEALLO 47 BCD*10.3 Base to Allocate E A 
FCTAXALLO 48 BCD*10.3 Func. Total Tax Allocated E A 
SCTAXALLO 49 BCD*10.3 Total Tax Allocated E A 
FCTAXRECV 50 BCD*10.3 Func. Total Tax Recoverable E A 
SCTAXRECV 51 BCD*10.3 Total Tax Recoverable E A 
FCTAXEXPS 52 BCD*10.3 Func. Total Tax Expensed E A 
SCTAXEXPS 53 BCD*10.3 Total Tax Expensed E A 
FCTAXINCL 54 BCD*10.3 Func. Tax Included in Price E A 
SCTAXINCL 55 BCD*10.3 Tax Included in Price E A 
FCTAXEXCL 56 BCD*10.3 Func. Tax Excluded from Price E A 
SCTAXEXCL 57 BCD*10.3 Tax Excluded from Price E A 
TAXBASE1 58 BCD*10.3 Tax Base 1 E A 
TAXBASE2 59 BCD*10.3 Tax Base 2 E A 
TAXBASE3 60 BCD*10.3 Tax Base 3 E A 
TAXBASE4 61 BCD*10.3 Tax Base 4 E A 
TAXBASE5 62 BCD*10.3 Tax Base 5 E A 
TAXINCLUD1 63 Boolean Tax Includable 1 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD2 64 Boolean Tax Includable 2 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD3 65 Boolean Tax Includable 3 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD4 66 Boolean Tax Includable 4 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD5 67 Boolean Tax Includable 5 E A  List:2 entries
0 = No
1 = Yes
TAXAMOUNT1 68 BCD*10.3 Tax Amount 1 E A 
TAXAMOUNT2 69 BCD*10.3 Tax Amount 2 E A 
TAXAMOUNT3 70 BCD*10.3 Tax Amount 3 E A 
TAXAMOUNT4 71 BCD*10.3 Tax Amount 4 E A 
TAXAMOUNT5 72 BCD*10.3 Tax Amount 5 E A 
FCTAXAMT1 73 BCD*10.3 Func. Tax Amount 1 E A 
FCTAXAMT2 74 BCD*10.3 Func. Tax Amount 2 E A 
FCTAXAMT3 75 BCD*10.3 Func. Tax Amount 3 E A 
FCTAXAMT4 76 BCD*10.3 Func. Tax Amount 4 E A 
FCTAXAMT5 77 BCD*10.3 Func. Tax Amount 5 E A 
OQOUTTOTAL 78 BCD*10.4 Total Quantity Outstanding E A 
SQOUTTOTAL 79 BCD*10.4 Total Stock Quantity Outstanding E A 
FCEXTTOTAL 80 BCD*10.3 Functional Total Cost E A 
SCEXTTOTAL 81 BCD*10.3 Total Cost E A 
DISCPCT 82 BCD*5.5 Discount Percentage E A 
FCDISCOUNT 83 BCD*10.3 Func. Discount Amount E A 
SCDISCOUNT 84 BCD*10.3 Discount Amount E A 
FCDISCTOT 85 BCD*10.3 Functional Total Discount E A 
SCDISCTOT 86 BCD*10.3 Total Discount E A 
COMMENT 87 String*250 Comment E A 
VALUES 88 Long Optional Fields E A C 
ISCOMPLETE 89 Boolean Completed E A  List:2 entries
0 = No
1 = Yes
ISRECEIVED 90 Boolean Received E A  List:2 entries
0 = No
1 = Yes
GLITEM 91 String*45 G/L Item E A  Mask: %-45C
GLOVERHEAD 92 String*45 Overhead Account E A  Mask: %-45C
GLLABOR 93 String*45 Labor Burden Account E A  Mask: %-45C
FCOVRHDAMT 94 BCD*10.3 Func. Overhead Amount E A 
SCOVRHDAMT 95 BCD*10.3 Overhead Amount E A 
FCLABORAMT 96 BCD*10.3 Func. Labor Burden Amount E A 
SCLABORAMT 97 BCD*10.3 Labor Burden Amount E A 
RCTAXALLO 98 BCD*10.3 Rptg. Total Tax Allocated E A 
RCTAXRECV 99 BCD*10.3 Rptg. Total Tax Recoverable E A 
RCTAXEXPS 100 BCD*10.3 Rptg. Total Tax Expensed E A 
RCTAXINCL 101 BCD*10.3 Rptg. Total Tax Included E A 
TARAMOUNT1 102 BCD*10.3 Tax Reporting Amount 1 E A 
TARAMOUNT2 103 BCD*10.3 Tax Reporting Amount 2 E A 
TARAMOUNT3 104 BCD*10.3 Tax Reporting Amount 3 E A 
TARAMOUNT4 105 BCD*10.3 Tax Reporting Amount 4 E A 
TARAMOUNT5 106 BCD*10.3 Tax Reporting Amount 5 E A 
DEFEXTWGHT 107 BCD*10.4 Default Extended Weight E A 
TOTDEFEXWT 108 BCD*10.4 Total Def. Ext. Weight E A 
DQOUTSTAND 109 BCD*10.4 Delta Quantity Outstanding E A 
DELTACONVE 110 BCD*10.6 Delta Unit Conversion E A 
DELTAUNIT 111 String*10 Delta Unit E A  Mask: %-10c
DETAILNUM 112 Integer Detail Number E A 

This page was generated on 2021-Nov-24

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