Table: Purchase Order Audit Lines

Table: POPORAL
View: PO0614
Record Length: 1417

Flags: A R 

Keys: 2

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

Fields: 116

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
DETAILNUM Integer Detail Number

This page was generated on 2023-Aug-31

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