# Table: Purchase Order Audit Lines

Table: POPORAL
View: PO0614
Record length: 1415
Flags: A R

## Keys: 1

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

## Fields: 115

Field | Type | Title | Presentation
--- | --- | --- | ---
DAYENDSEQ | BCD*10.0 | Day End Number |
PORAHSEQ | BCD*10.0 | Processing Sequence |
PORALSEQ | BCD*10.0 | Line Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
TRANSTYPE | Integer | Transaction Type |
AGENTLSEQ | BCD*10.0 | Agent Line Sequence |
OEONUMBER | String*22 | Order Number | Mask: %-22C
CONTRACT | String*16 | Contract | Mask: %-16C
PROJECT | String*16 | Project | Mask: %-16N
CCATEGORY | String*16 | (Cost) Category | Mask: %-16N
COSTCLASS | Integer | Cost Class | List: 7 entries
0 | = |
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
ITEMEXISTS | Boolean | Item Exists | List: 2 entries
0 | = | No
1 | = | Yes
ITEMNO | String*24 | Item Number | Mask: %-24C
STOCKITEM | Boolean | Stock Item | List: 2 entries
0 | = | No
1 | = | Yes
LOCATION | String*6 | Location | Mask: %-6N
ITEMDESC | String*60 | Item Description |
BILLTYPE | Integer | Billing Type | List: 4 entries
0 | = |
1 | = | Non-billable
2 | = | Billable
3 | = | No Charge
BILLRATE | BCD*10.6 | Billing Rate |
BILLCURR | String*3 | Billing Currency | Mask: %-3N
ARITEMNO | String*16 | A/R Item Number | Mask: %-16C
ARUNIT | String*10 | A/R Unit of Measure | Mask: %-10C
PVLOCATION | String*6 | Previous Location | Mask: %-6N
PVORDUNIT | String*10 | Previous Order Unit | Mask: %-10c
PVORDCONV | BCD*10.6 | Previous Order Unit Conversion |
PVBILLTYPE | Integer | Previous Billing Type | List: 4 entries
0 | = |
1 | = | Non-billable
2 | = | Billable
3 | = | No Charge
DBILLRATE | BCD*10.6 | Billing Rate Difference |
PVARITEMNO | String*16 | Previous A/R Item Number | Mask: %-16C
PVARUNIT | String*10 | Previous A/R Unit of Measure | Mask: %-10C
TAXCLASS1 | Integer | Tax Class 1 |
TAXCLASS2 | Integer | Tax Class 2 |
TAXCLASS3 | Integer | Tax Class 3 |
TAXCLASS4 | Integer | Tax Class 4 |
TAXCLASS5 | Integer | Tax Class 5 |
OQORDERED | BCD*10.4 | Quantity Ordered |
OQRECEIVED | BCD*10.4 | Quantity Received |
OQCANCELED | BCD*10.4 | Quantity Canceled |
OQOUTSTAND | BCD*10.4 | Quantity Outstanding |
ORDERUNIT | String*10 | Unit of Measure | Mask: %-10c
CONVERSION | BCD*10.6 | Conversion Factor to Stocking |
SQOUTSTAND | BCD*10.4 | Stocking Quantity Outstanding |
STOCKUNIT | String*10 | Unit of Measure | Mask: %-10c
UNITCOST | BCD*10.6 | Unit Cost |
DFCUNITCST | BCD*10.6 | Func. Unit Cost Difference |
DSCUNITCST | BCD*10.6 | Unit Cost Difference |
FCEXTENDED | BCD*10.3 | Func. Extended Amount |
SCEXTENDED | BCD*10.3 | Extended Amount |
FCBASEALLO | BCD*10.3 | Func. Base to Allocate |
SCBASEALLO | BCD*10.3 | Base to Allocate |
FCTAXALLO | BCD*10.3 | Func. Total Tax Allocated |
SCTAXALLO | BCD*10.3 | Total Tax Allocated |
FCTAXRECV | BCD*10.3 | Func. Total Tax Recoverable |
SCTAXRECV | BCD*10.3 | Total Tax Recoverable |
FCTAXEXPS | BCD*10.3 | Func. Total Tax Expensed |
SCTAXEXPS | BCD*10.3 | Total Tax Expensed |
FCTAXINCL | BCD*10.3 | Func. Tax Included in Price |
SCTAXINCL | BCD*10.3 | Tax Included in Price |
FCTAXEXCL | BCD*10.3 | Func. Tax Excluded from Price |
SCTAXEXCL | BCD*10.3 | Tax Excluded from Price |
TAXBASE1 | BCD*10.3 | Tax Base 1 |
TAXBASE2 | BCD*10.3 | Tax Base 2 |
TAXBASE3 | BCD*10.3 | Tax Base 3 |
TAXBASE4 | BCD*10.3 | Tax Base 4 |
TAXBASE5 | BCD*10.3 | Tax Base 5 |
TAXINCLUD1 | Boolean | Tax Includable 1 | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD2 | Boolean | Tax Includable 2 | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD3 | Boolean | Tax Includable 3 | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD4 | Boolean | Tax Includable 4 | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD5 | Boolean | Tax Includable 5 | List: 2 entries
0 | = | No
1 | = | Yes
TAXAMOUNT1 | BCD*10.3 | Tax Amount 1 |
TAXAMOUNT2 | BCD*10.3 | Tax Amount 2 |
TAXAMOUNT3 | BCD*10.3 | Tax Amount 3 |
TAXAMOUNT4 | BCD*10.3 | Tax Amount 4 |
TAXAMOUNT5 | BCD*10.3 | Tax Amount 5 |
FCTAXAMT1 | BCD*10.3 | Func. Tax Amount 1 |
FCTAXAMT2 | BCD*10.3 | Func. Tax Amount 2 |
FCTAXAMT3 | BCD*10.3 | Func. Tax Amount 3 |
FCTAXAMT4 | BCD*10.3 | Func. Tax Amount 4 |
FCTAXAMT5 | BCD*10.3 | Func. Tax Amount 5 |
OQOUTTOTAL | BCD*10.4 | Total Quantity Outstanding |
SQOUTTOTAL | BCD*10.4 | Total Stock Quantity Outstanding |
FCEXTTOTAL | BCD*10.3 | Functional Total Cost |
SCEXTTOTAL | BCD*10.3 | Total Cost |
DISCPCT | BCD*5.5 | Discount Percentage |
FCDISCOUNT | BCD*10.3 | Func. Discount Amount |
SCDISCOUNT | BCD*10.3 | Discount Amount |
FCDISCTOT | BCD*10.3 | Functional Total Discount |
SCDISCTOT | BCD*10.3 | Total Discount |
COMMENT | String*250 | Comment |
VALUES | Long | Optional Fields |
ISCOMPLETE | Boolean | Completed | List: 2 entries
0 | = | No
1 | = | Yes
ISRECEIVED | Boolean | Received | List: 2 entries
0 | = | No
1 | = | Yes
GLITEM | String*45 | G/L Item | Mask: %-45C
GLOVERHEAD | String*45 | Overhead Account | Mask: %-45C
GLLABOR | String*45 | Labor Burden Account | Mask: %-45C
FCOVRHDAMT | BCD*10.3 | Func. Overhead Amount |
SCOVRHDAMT | BCD*10.3 | Overhead Amount |
FCLABORAMT | BCD*10.3 | Func. Labor Burden Amount |
SCLABORAMT | BCD*10.3 | Labor Burden Amount |
RCTAXALLO | BCD*10.3 | Rptg. Total Tax Allocated |
RCTAXRECV | BCD*10.3 | Rptg. Total Tax Recoverable |
RCTAXEXPS | BCD*10.3 | Rptg. Total Tax Expensed |
RCTAXINCL | BCD*10.3 | Rptg. Total Tax Included |
TARAMOUNT1 | BCD*10.3 | Tax Reporting Amount 1 |
TARAMOUNT2 | BCD*10.3 | Tax Reporting Amount 2 |
TARAMOUNT3 | BCD*10.3 | Tax Reporting Amount 3 |
TARAMOUNT4 | BCD*10.3 | Tax Reporting Amount 4 |
TARAMOUNT5 | BCD*10.3 | Tax Reporting Amount 5 |
DEFEXTWGHT | BCD*10.4 | Default Extended Weight |
TOTDEFEXWT | BCD*10.4 | Total Def. Ext. Weight |
DQOUTSTAND | BCD*10.4 | Delta Quantity Outstanding |
DELTACONVE | BCD*10.6 | Delta Unit Conversion |
DELTAUNIT | String*10 | Delta Unit | Mask: %-10c

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.