Table: Receipt Audit Lines

Table: PORCPAL
View: PO0688
Record Length: 1691

Flags: A R 

Keys: 2

Title Flags Fields

Detail Key DAYENDSEQRCPAHSEQRCPALSEQ
Detail Number DAYENDSEQRCPAHSEQDETAILNUMRCPALSEQ

Fields: 142

Field Type Title Presentation

DAYENDSEQ BCD*10.0 Day End Number
RCPAHSEQ BCD*10.0 Processing Sequence
RCPALSEQ 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
RQRECEIVED BCD*10.4 Quantity Received
RQCANCELED BCD*10.4 Quantity Canceled
RCPUNIT String*10 Unit of Measure Mask: %-10c
CONVERSION BCD*10.6 Conversion Factor to Stocking
COSTCONV BCD*10.6 Cost unit conversion
SQRECEIVED BCD*10.4 Stocking Quantity Received
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
RECENTCOST BCD*10.6 Most recent 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
FCMPRORATE BCD*10.3 Func. Manual Prorate Allocated
SCMPRORATE BCD*10.3 Manual Prorate Allocated
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
RQRECTOTAL BCD*10.4 Total Quantity Received
SQRECTOTAL BCD*10.4 Total Stock Quantity Received
FCEXTTOTAL BCD*10.3 Functional Total Cost
SCEXTTOTAL BCD*10.3 Total Cost
RCPDAYS Integer Days to Receive
LASTCOST BCD*10.6 Last Unit Cost
STOCKITEM Boolean Stock Item List:2 entries
0 = No
1 = Yes
PONUMBER String*22 Purchase Order Number Mask: %-22C
QIVALINSTK Boolean Item Valuation Qty. In Stocking List:2 entries
0 = No
1 = Yes
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
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
DQRECEIVED BCD*10.4 Delta Quantity Received
DELTACONVE BCD*10.6 Delta Unit Conversion
DELTAUNIT String*10 Delta Unit Mask: %-10c
DETAILNUM Integer Detail Number