# View: Purchase Order Audit Lines

RotoID: PO0614
Table: POPORAL
DLL: POPORAL

## Compositions: 2

RotoID | Table | Title | DLL
--- | --- | --- | ---
PO0612 | POPORAH | Purchase Order Audit Headers | POPORAH
PO0613 | POPOALO | PO Audit Line Optional Fields | POPOALO

## Keys: 1

Title | Fields
--- | ---
Detail Key | DAYENDSEQ, PORAHSEQ, PORALSEQ

## Fields: 97

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 | (S) 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 | (FC) Unit Cost Difference | E A |
DSCUNITCST | 43 | BCD*10.6 | Unit Cost Difference | E A |
FCEXTENDED | 44 | BCD*10.3 | (FC) Extended Amount | E A |
SCEXTENDED | 45 | BCD*10.3 | Extended Amount | E A |
FCBASEALLO | 46 | BCD*10.3 | (FC) Base to Allocate | E A |
SCBASEALLO | 47 | BCD*10.3 | Base to Allocate | E A |
FCTAXALLO | 48 | BCD*10.3 | (FC) Total Tax Allocated | E A |
SCTAXALLO | 49 | BCD*10.3 | Total Tax Allocated | E A |
FCTAXRECV | 50 | BCD*10.3 | (FC) Total Tax Recoverable | E A |
SCTAXRECV | 51 | BCD*10.3 | Total Tax Recoverable | E A |
FCTAXEXPS | 52 | BCD*10.3 | (FC) Total Tax Expensed | E A |
SCTAXEXPS | 53 | BCD*10.3 | Total Tax Expensed | E A |
FCTAXINCL | 54 | BCD*10.3 | (FC) Tax Included in Price | E A |
SCTAXINCL | 55 | BCD*10.3 | Tax Included in Price | E A |
FCTAXEXCL | 56 | BCD*10.3 | (FC) 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 | (FC) Tax Amount 1 | E A |
FCTAXAMT2 | 74 | BCD*10.3 | (FC) Tax Amount 2 | E A |
FCTAXAMT3 | 75 | BCD*10.3 | (FC) Tax Amount 3 | E A |
FCTAXAMT4 | 76 | BCD*10.3 | (FC) Tax Amount 4 | E A |
FCTAXAMT5 | 77 | BCD*10.3 | (FC) 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 | Total Cost (Functional) | 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 | (FC) Discount Amount | E A |
SCDISCOUNT | 84 | BCD*10.3 | Discount Amount | E A |
FCDISCTOT | 85 | BCD*10.3 | Total Discount (Functional) | 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 | (FC) Overhead Amount | E A |
SCOVRHDAMT | 95 | BCD*10.3 | Overhead Amount | E A |
FCLABORAMT | 96 | BCD*10.3 | (FC) Labor Burden Amount | E A |
SCLABORAMT | 97 | BCD*10.3 | Labor Burden Amount | E A |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.