Table: Receipt Lines

Table: PORCPL
View: PO0710
Record length: 2871
Flags: A R 

Keys: 6

Title  Flags  Fields

Detail Key  RCPHSEQ, RCPLREV
Sequence Key  RCPHSEQ, RCPLSEQ
Order Number Key  M  OEONUMBER, RCPHSEQ, RCPLSEQ
Line Sequence Key  D M  RCPLSEQ
PO and Receipt Sequence Key  PORHSEQ, PORLSEQ, RCPHSEQ, RCPLSEQ
Detail Number  M  RCPHSEQ, DETAILNUM, RCPLSEQ

Fields: 246

Field  Type  Title  Presentation 

RCPHSEQ  BCD*10.0  Receipt Sequence Key   
RCPLREV  BCD*10.0  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
RCPLSEQ  BCD*10.0  Receipt Line Sequence   
RCPCSEQ  BCD*10.0  Receipt Comment Sequence   
OEONUMBER  String*22  Order Number  Mask: %-22C
INDBTABLE  Boolean  Stored in Database Table  List: 2 entries
0=No
1=Yes
POSTEDTOIC  Boolean  Posted to I/C  List: 2 entries
0=No
1=Yes
COMPLETION  Integer  Completion Status  List: 3 entries
1=No
2=Yes
3=Yes
DTCOMPLETE  Date  Date Completed   
PORHSEQ  BCD*10.0  Purchase Order Sequence Key   
PORLSEQ  BCD*10.0  Purchase Order Line Sequence   
POCOMPLETE  Boolean  Completes PO  List: 2 entries
0=No
1=Yes
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   
VENDITEMNO  String*24  Vendor Item Number   
HASCOMMENT  Boolean  Comments  List: 2 entries
0=No
1=Yes
ORDERUNIT  String*10  Unit of Measure  Mask: %-10c
ORDERCONV  BCD*10.6  Order Unit Conversion   
ORDERDECML  Integer  Order Unit Decimals   
RCPUNIT  String*10  Unit of Measure  Mask: %-10c
RCPCONV  BCD*10.6  Receiving Conversion Factor   
RCPDECML  Integer  Receiving Unit Decimals   
STOCKDECML  Integer  Stock Unit Decimals   
OQORDERED  BCD*10.4  Ordered Quantity Ordered   
OQPREVRECV  BCD*10.4  Ordered Previously Received   
OQOUTSTPO  BCD*10.4  Ordered Outstanding on PO   
RQRECEIVED  BCD*10.4  Quantity Received   
RQCANCELED  BCD*10.4  Quantity Canceled   
RQOUTSTAND  BCD*10.4  Quantity Outstanding   
SQORDERED  BCD*10.4  Stocking Quantity Ordered   
SQPREVRECV  BCD*10.4  Stocking Previously Received   
SQOUTSTPO  BCD*10.4  Stocking Outstanding on PO   
RQORDERED  BCD*10.4  Quantity Ordered   
RQPREVRECV  BCD*10.4  Received to Date   
RQOUTSTPO  BCD*10.4  Quantity Outstanding   
RQRCPEXTRA  BCD*10.4  Receiving Qty. Received Extra   
SQRECEIVED  BCD*10.4  Stocking Quantity Received   
SQCANCELED  BCD*10.4  Stocking Quantity Canceled   
SQOUTSTAND  BCD*10.4  Stocking Quantity Outstanding   
SQRCPEXTRA  BCD*10.4  Stocking Quantity Received Extra   
OQRECEIVED  BCD*10.4  Ordered Quantity Received   
OQCANCELED  BCD*10.4  Ordered Quantity Canceled   
OQOUTSTAND  BCD*10.4  Ordered Quantity Outstanding   
OQRCPEXTRA  BCD*10.4  Received Extra   
RQRETURNED  BCD*10.4  Quantity Returned   
SQRETURNED  BCD*10.4  Stocking Quantity Returned   
OQRETURNED  BCD*10.4  Ordered Quantity Returned   
RQSTOCKED  BCD*10.4  Quantity Stocked   
SQSTOCKED  BCD*10.4  Stocking Quantity Stocked   
OQSTOCKED  BCD*10.4  Ordered Quantity Stocked   
RQINADJUST  BCD*10.4  Quantity Adjusted by Invoice   
SQINADJUST  BCD*10.4  Stocking Qty. Adj. by Invoice   
OQINADJUST  BCD*10.4  Ordered Quantity Adj. by Invoice   
RQPOFILLED  BCD*10.4  Quantity Filled on PO   
SQPOFILLED  BCD*10.4  Stocking Quantity Filled on PO   
OQPOFILLED  BCD*10.4  Ordered Quantity Filled on PO   
RQSETTLED  BCD*10.4  Quantity Settled   
SQSETTLED  BCD*10.4  Stocking Quantity Settled   
OQSETTLED  BCD*10.4  Ordered Quantity Settled   
RQUSTOCKED  BCD*10.4  Quantity Unstocked   
SQUSTOCKED  BCD*10.4  Stocking Quantity Unstocked   
OQUSTOCKED  BCD*10.4  Ordered Quantity Unstocked   
UNITWEIGHT  BCD*10.4  Unit Weight   
EXTWEIGHT  BCD*10.4  Extended Weight   
UNITCOST  BCD*10.6  Unit Cost   
EXTENDED  BCD*10.3  Extended Cost   
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   
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   
TAXRATE1  BCD*8.5  Tax Rate 1   
TAXRATE2  BCD*8.5  Tax Rate 2   
TAXRATE3  BCD*8.5  Tax Rate 3   
TAXRATE4  BCD*8.5  Tax Rate 4   
TAXRATE5  BCD*8.5  Tax Rate 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   
TXALLOAMT1  BCD*10.3  Tax Allocated Amount 1   
TXALLOAMT2  BCD*10.3  Tax Allocated Amount 2   
TXALLOAMT3  BCD*10.3  Tax Allocated Amount 3   
TXALLOAMT4  BCD*10.3  Tax Allocated Amount 4   
TXALLOAMT5  BCD*10.3  Tax Allocated Amount 5   
TXBASEALLO  BCD*10.3  Net of Tax   
TXINCLUDED  BCD*10.3  Tax Included   
TXEXCLUDED  BCD*10.3  Tax Excluded   
TAXAMOUNT  BCD*10.3  Total Tax   
TXRECVAMT  BCD*10.3  Recoverable Tax   
TXEXPSAMT  BCD*10.3  Expensed Tax   
TXALLOAMT  BCD*10.3  Allocated Tax   
TFBASEALLO  BCD*10.3  Func. Net of Tax   
TFINCLUDE1  BCD*10.3  Func. Tax Included Amount 1   
TFINCLUDE2  BCD*10.3  Func. Tax Included Amount 2   
TFINCLUDE3  BCD*10.3  Func. Tax Included Amount 3   
TFINCLUDE4  BCD*10.3  Func. Tax Included Amount 4   
TFINCLUDE5  BCD*10.3  Func. Tax Included Amount 5   
TFALLOAMT1  BCD*10.3  Func. Tax Allocated Amount 1   
TFALLOAMT2  BCD*10.3  Func. Tax Allocated Amount 2   
TFALLOAMT3  BCD*10.3  Func. Tax Allocated Amount 3   
TFALLOAMT4  BCD*10.3  Func. Tax Allocated Amount 4   
TFALLOAMT5  BCD*10.3  Func. Tax Allocated Amount 5   
TFRECVAMT1  BCD*10.3  Func. Tax Recoverable Amount 1   
TFRECVAMT2  BCD*10.3  Func. Tax Recoverable Amount 2   
TFRECVAMT3  BCD*10.3  Func. Tax Recoverable Amount 3   
TFRECVAMT4  BCD*10.3  Func. Tax Recoverable Amount 4   
TFRECVAMT5  BCD*10.3  Func. Tax Recoverable Amount 5   
TFEXPSAMT1  BCD*10.3  Func. Tax Expense Amount 1   
TFEXPSAMT2  BCD*10.3  Func. Tax Expense Amount 2   
TFEXPSAMT3  BCD*10.3  Func. Tax Expense Amount 3   
TFEXPSAMT4  BCD*10.3  Func. Tax Expense Amount 4   
TFEXPSAMT5  BCD*10.3  Func. Tax Expense Amount 5   
GLACEXPENS  String*45  Expense Account  Mask: %-45C
DTARRIVAL  Date  Arrival Date   
LABELCOUNT  Integer  Number of Labels   
MPRORATED  BCD*10.3  Manual Proration   
HASDROPSHI  Boolean  Drop-Ship  List: 2 entries
0=No
1=Yes
DROPTYPE  Integer  Drop-Ship Type  List: 4 entries
2=Address Entered
3=Inventory Location Address
4=Customer Address
5=Customer Ship-To Address
IDCUST  String*12  Drop-Ship Customer  Mask: %-12C
IDCUSTSHPT  String*6  Customer Ship-To Address  Mask: %-6C
DLOCATION  String*6  Drop-Ship Location  Mask: %-6N
DESC  String*60  Drop-Ship Description   
ADDRESS1  String*60  Drop-Ship Address 1   
ADDRESS2  String*60  Drop-Ship Address 2   
ADDRESS3  String*60  Drop-Ship Address 3   
ADDRESS4  String*60  Drop-Ship Address 4   
CITY  String*30  Drop-Ship City   
STATE  String*30  Drop-Ship State/Province   
ZIP  String*20  Drop-Ship Zip/Postal Code   
COUNTRY  String*30  Drop-Ship Country   
PHONE  String*30  Drop-Ship Phone Number  Mask: %-30c
FAX  String*30  Drop-Ship Fax Number  Mask: %-30c
CONTACT  String*60  Drop-Ship Contact   
STOCKITEM  Boolean  Stock Item  List: 2 entries
0=No
1=Yes
PONUMBER  String*22  Purchase Order Number  Mask: %-22C
EMAIL  String*50  Drop-Ship E-mail   
PHONEC  String*30  Drop-Ship Contact Phone  Mask: %-30c
FAXC  String*30  Drop-Ship Contact Fax  Mask: %-30c
EMAILC  String*50  Drop-Ship Contact E-mail   
GLNONSTKCR  String*45  Non-Stock Clearing Account  Mask: %-45C
MANITEMNO  String*24  Manufacturer's Item Number  Mask: %-24C
DISCPCT  BCD*5.5  Discount Percentage   
DISCOUNT  BCD*10.3  Discount Amount   
DISCOUNTF  BCD*10.3  Func. Discount Amount   
XIRQRECEVD  BCD*10.4  Part. Inv. Pv. Qty. Invoicied.   
XIEXTWGHT  BCD*10.4  Part. Inv. Pv. Ext. Wgt. Invcd.   
XINETXTEND  BCD*10.3  Part. Inv. Pv. Net Cost Invoiced   
INVLINES  Long  Invoice Lines   
VALUES  Long  Optional Fields   
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   
RTGAMOUNT  BCD*10.3  Retainage Amount   
RTGAMTOVER  Boolean  Retainage Amount Overridden  List: 2 entries
0=No
1=Yes
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   
TRALLOAMT1  BCD*10.3  Tax Reporting Allocated Amount 1   
TRALLOAMT2  BCD*10.3  Tax Reporting Allocated Amount 2   
TRALLOAMT3  BCD*10.3  Tax Reporting Allocated Amount 3   
TRALLOAMT4  BCD*10.3  Tax Reporting Allocated Amount 4   
TRALLOAMT5  BCD*10.3  Tax Reporting Allocated Amount 5   
TRRECVAMT1  BCD*10.3  Tax Reporting Recoverable Amt. 1   
TRRECVAMT2  BCD*10.3  Tax Reporting Recoverable Amt. 2   
TRRECVAMT3  BCD*10.3  Tax Reporting Recoverable Amt. 3   
TRRECVAMT4  BCD*10.3  Tax Reporting Recoverable Amt. 4   
TRRECVAMT5  BCD*10.3  Tax Reporting Recoverable Amt. 5   
TREXPSAMT1  BCD*10.3  Tax Reporting Expense Amount 1   
TREXPSAMT2  BCD*10.3  Tax Reporting Expense Amount 2   
TREXPSAMT3  BCD*10.3  Tax Reporting Expense Amount 3   
TREXPSAMT4  BCD*10.3  Tax Reporting Expense Amount 4   
TREXPSAMT5  BCD*10.3  Tax Reporting Expense Amount 5   
RAXBASE1  BCD*10.3  Retainage Tax Base 1   
RAXBASE2  BCD*10.3  Retainage Tax Base 2   
RAXBASE3  BCD*10.3  Retainage Tax Base 3   
RAXBASE4  BCD*10.3  Retainage Tax Base 4   
RAXBASE5  BCD*10.3  Retainage Tax Base 5   
RAXAMOUNT1  BCD*10.3  Retainage Tax Amount 1   
RAXAMOUNT2  BCD*10.3  Retainage Tax Amount 2   
RAXAMOUNT3  BCD*10.3  Retainage Tax Amount 3   
RAXAMOUNT4  BCD*10.3  Retainage Tax Amount 4   
RAXAMOUNT5  BCD*10.3  Retainage Tax Amount 5   
RXRECVAMT1  BCD*10.3  Retainage Tax Recoverable Amt. 1   
RXRECVAMT2  BCD*10.3  Retainage Tax Recoverable Amt. 2   
RXRECVAMT3  BCD*10.3  Retainage Tax Recoverable Amt. 3   
RXRECVAMT4  BCD*10.3  Retainage Tax Recoverable Amt. 4   
RXRECVAMT5  BCD*10.3  Retainage Tax Recoverable Amt. 5   
RXEXPSAMT1  BCD*10.3  Retainage Tax Expense Amount 1   
RXEXPSAMT2  BCD*10.3  Retainage Tax Expense Amount 2   
RXEXPSAMT3  BCD*10.3  Retainage Tax Expense Amount 3   
RXEXPSAMT4  BCD*10.3  Retainage Tax Expense Amount 4   
RXEXPSAMT5  BCD*10.3  Retainage Tax Expense Amount 5   
RXALLOAMT1  BCD*10.3  Retainage Tax Allocated Amount 1   
RXALLOAMT2  BCD*10.3  Retainage Tax Allocated Amount 2   
RXALLOAMT3  BCD*10.3  Retainage Tax Allocated Amount 3   
RXALLOAMT4  BCD*10.3  Retainage Tax Allocated Amount 4   
RXALLOAMT5  BCD*10.3  Retainage Tax Allocated Amount 5   
UCISMANUAL  Boolean  Unit Cost is Manual  List: 2 entries
0=No
1=Yes
WEIGHTUNIT  String*10  Weight Unit of Measure   
WEIGHTCONV  BCD*10.6  Weight Conversion   
DEFUWEIGHT  BCD*10.4  Default Unit Weight   
DEFEXTWGHT  BCD*10.4  Default Extended Weight   
XIDEFEXTWT  BCD*10.4  Part. Inv. Pv. Def. Ext. W. Inv.   
FASDETAIL  Boolean  Fixed Asset  List: 2 entries
0=No
1=Yes
SERIALQTY  Long  Serial Quantity   
LOTQTY  BCD*10.4  Lot Quantity   
SLITEM  Integer  Item Serialized/Lotted?  List: 4 entries
0=None
1=Serialized
2=Lotted
3=Both
DETAILNUM  Integer  Detail Number   

This page was generated on 2009-Nov-19

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