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 2009-Nov-19

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