Table: Requisition Lines

Table: PORQNL
View: PO0770
Record length: 1224
Flags: A R 

Keys: 5

Title  Flags  Fields
Detail Key  RQNHSEQ, RQNLREV
Sequence Key  RQNHSEQ, RQNLSEQ
Requisition/Vendor/Line  M  RQNHSEQ, VDCODE, RQNLSEQ
Vendor/Requisition/Line  M  VDCODE, RQNHSEQ, RQNLSEQ
Detail Number  M  RQNHSEQ, DETAILNUM, RQNLSEQ

Fields: 68

Field  Type  Title  Presentation 
RQNHSEQ  BCD*10.0  Requisition Sequence Key   
RQNLREV  BCD*10.0  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
RQNLSEQ  BCD*10.0  Requisition Line Sequence   
LINEORDER  Long  Line Ordered   
RQNCSEQ  BCD*10.0  Requisition Comment Sequence   
OEONUMBER  String*22  Order Number  Mask: %-22C
VDEXISTS  Boolean  Vendor Exists  List: 2 entries
0=No
1=Yes
VDCODE  String*12  Vendor  Mask: %-12C
VDNAME  String*60  Name   
INDBTABLE  Boolean  Stored in Database Table  List: 2 entries
0=No
1=Yes
COMPLETION  Integer  Completion Status  List: 3 entries
1=No
2=Yes
3=Yes
DTCOMPLETE  Date  Date Completed   
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   
EXPARRIVAL  Date  Expected Arrival Date   
VENDITEMNO  String*24  Vendor Item Number   
HASCOMMENT  Boolean  Comments/Instructions  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   
STOCKDECML  Integer  Stock Unit Decimals   
OQORDERED  BCD*10.4  Quantity Ordered   
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
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   
MANITEMNO  String*24  Manufacturer's Item Number  Mask: %-24C
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
UNITCOST  BCD*10.6  Unit Cost   
CPCOSTTOPO  Boolean  Copy Cost To Purchase Order  List: 2 entries
0=No
1=Yes
UCISMANUAL  Boolean  Unit Cost is Manual  List: 2 entries
0=No
1=Yes
EXTENDED  BCD*10.3  Extended Cost   
FCEXTENDED  BCD*10.3  Functional Extended   
UNITWEIGHT  BCD*10.4  Unit Weight   
EXTWEIGHT  BCD*10.4  Extended Weight   
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   
DETAILNUM  Integer  Detail Number   

This page was generated on 2009-Nov-19

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