Table: Return Audit Lines

Table: PORETAL
View: PO0726
Record Length: 1619

Flags: A R 

Keys: 2

Title Flags Fields
Detail Key DAYENDSEQ, RETAHSEQ, RETALSEQ
Detail Number DAYENDSEQ, RETAHSEQ, DETAILNUM, RETALSEQ

Fields: 134

Field Type Title Presentation
DAYENDSEQ BCD*10.0 Day End Number
RETAHSEQ BCD*10.0 Processing Sequence
RETALSEQ BCD*10.0 Line Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
TRANSTYPE Integer Transaction Type
OEONUMBER String*22 Order Number Mask: %-22C
ITEMEXISTS Boolean Item Exists List:2 entries
0 = No
1 = Yes
ITEMNO String*24 Item Number Mask: %-24C
LOCATION String*6 Location Mask: %-6N
ITEMDESC String*60 Item Description
CNTLACCT String*6 Control Account
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
RQRETURNED BCD*10.4 Quantity Returned
RETUNIT String*10 Unit of Measure Mask: %-10c
CONVERSION BCD*10.6 Conversion Factor to Stocking
COSTCONV BCD*10.6 Cost unit conversion
SQRETURNED BCD*10.4 Stocking Quantity Returned
STOCKUNIT String*10 Unit of Measure Mask: %-10c
COSTUNIT String*10 Costing unit of measure Mask: %-10c
UNITCOST BCD*10.6 Unit Cost
PRUNITCOST BCD*10.6 Unit Cost
LOADEDCOST BCD*10.6 Fully-loaded cost
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
FCPRORATED BCD*10.3 Func. Total Prorate Allocated
SCPRORATED BCD*10.3 Total Prorate Allocated
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
TXRECVAMT1 BCD*10.3 Tax Recoverable Amount 1
TXRECVAMT2 BCD*10.3 Tax Recoverable Amount 2
TXRECVAMT3 BCD*10.3 Tax Recoverable Amount 3
TXRECVAMT4 BCD*10.3 Tax Recoverable Amount 4
TXRECVAMT5 BCD*10.3 Tax Recoverable Amount 5
TXEXPSAMT1 BCD*10.3 Tax Expense Amount 1
TXEXPSAMT2 BCD*10.3 Tax Expense Amount 2
TXEXPSAMT3 BCD*10.3 Tax Expense Amount 3
TXEXPSAMT4 BCD*10.3 Tax Expense Amount 4
TXEXPSAMT5 BCD*10.3 Tax Expense Amount 5
GLCLEARING String*45 Receipt Clearing Account Mask: %-45C
GLITEM String*45 G/L Item Mask: %-45C
GLISPOSTED Boolean G/L data to be posted? List:2 entries
0 = No
1 = Yes
GLISDEBIT Boolean Normal G/L debit convention? List:2 entries
0 = No
1 = Yes
RQRETTOTAL BCD*10.4 Total Quantity Returned
SQRETTOTAL BCD*10.4 Total Stock Quantity Returned
FCEXTTOTAL BCD*10.3 Functional Total Cost
SCEXTTOTAL BCD*10.3 Total Cost
STOCKITEM Boolean Stock Item List:2 entries
0 = No
1 = Yes
PONUMBER String*22 Purchase Order Number Mask: %-22C
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
VALUES Long Optional Fields
RCPLSEQ BCD*10.0 Receipt Line Sequence
RETLSEQ BCD*10.0 Return Line Sequence
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
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
COMMENT String*250 Comment
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
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
RTGPERCENT BCD*5.5 Retainage Percentage
RTGDAYS Integer Retention Period
SCRTGAMT BCD*10.3 Retainage Amount
SCRTGAMTOT BCD*10.3 Total Retainage Amount
RTGAMTOVER Boolean Retainage Amount Overridden List:2 entries
0 = No
1 = Yes
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
DFCUNITCST BCD*10.6 Func. Unit Cost Difference
DSCUNITCST BCD*10.6 Unit Cost Difference
DBILLRATE BCD*10.6 Billing Rate Difference
PMTRANSNUM Long PJC Transaction Number
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
SCRAXALLO BCD*10.3 Total Rtg. Tax Allocated
FCRAXALLO BCD*10.3 Func. Total Rtg. Tax Allocated
SCRAXEXPS BCD*10.3 Total Rtg. Tax Expensed
FCRAXEXPS BCD*10.3 Func. Total Rtg. Tax Expensed
DEFEXTWGHT BCD*10.4 Default Extended Weight
TOTDEFEXWT BCD*10.4 Total Def. Ext. Weight
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).