View: Requisition Lines

RotoID: PO0770
Table: PORQNL
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PORQNL

Compositions: 5

RotoID Tables Title DLL
PO0760 PORQNH1PORQNH2 Requisitions PORQNH
PO0750 PORQNC Requisition Comments PORQNC
PO0759 Requisition Functions PORQNG
PO0773 PORQNLO Requisition Detail Opt. Fields PORQNLO
PO0777 PORQNLV Requisition Vendors PORQNLV

Keys: 5

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

Fields: 90

Field Index Type Title Attributes Presentation
RQNHSEQ 1 BCD*10.0 Requisition Sequence Key E A K R 
RQNLREV 2 BCD*10.0 Line Number E A K R 
RQNLSEQ 3 BCD*10.0 Requisition Line Sequence E A X 
LINEORDER 4 Long Line Ordered A C X 
RQNCSEQ 5 BCD*10.0 Requisition Comment Sequence A X 
OEONUMBER 6 String*22 Order Number A X  Mask: %-22C
VDEXISTS 7 Boolean Vendor Exists A C X  List:2 entries
0 = No
1 = Yes
VDCODE 8 String*12 Vendor A X  Mask: %-12C
VDNAME 9 String*60 Name A X 
INDBTABLE 10 Boolean Stored in Database Table A C X  List:2 entries
0 = No
1 = Yes
COMPLETION 11 Integer Completion Status A X  List:3 entries
1 = No
2 = Yes
3 = Yes
DTCOMPLETE 12 Date Date Completed A X 
ITEMEXISTS 13 Boolean Item Exists A C X  List:2 entries
0 = No
1 = Yes
ITEMNO 14 String*24 Item Number A P X  Mask: %-24C
LOCATION 15 String*6 Location A X  Mask: %-6N
ITEMDESC 16 String*60 Item Description A X 
EXPARRIVAL 17 Date Expected Arrival Date A X 
VENDITEMNO 18 String*24 Vendor Item Number A X 
HASCOMMENT 19 Boolean Comments/Instructions A X  List:2 entries
0 = No
1 = Yes
ORDERUNIT 20 String*10 Unit of Measure A X  Mask: %-10c
ORDERCONV 21 BCD*10.6 Order Unit Conversion A C X 
ORDERDECML 22 Integer Order Unit Decimals A C X 
STOCKDECML 23 Integer Stock Unit Decimals A C X 
OQORDERED 24 BCD*10.4 Quantity Ordered A X 
HASDROPSHI 25 Boolean Drop-Ship A X  List:2 entries
0 = No
1 = Yes
DROPTYPE 26 Integer Drop-Ship Type A P X  List:4 entries
2 = Address Entered
3 = Inventory Location Address
4 = Customer Address
5 = Customer Ship-To Address
IDCUST 27 String*12 Drop-Ship Customer A X  Mask: %-12C
IDCUSTSHPT 28 String*6 Customer Ship-To Address A X  Mask: %-6C
DLOCATION 29 String*6 Drop-Ship Location A X  Mask: %-6N
DESC 30 String*60 Drop-Ship Description A X 
ADDRESS1 31 String*60 Drop-Ship Address 1 A X 
ADDRESS2 32 String*60 Drop-Ship Address 2 A X 
ADDRESS3 33 String*60 Drop-Ship Address 3 A X 
ADDRESS4 34 String*60 Drop-Ship Address 4 A X 
CITY 35 String*30 Drop-Ship City A X 
STATE 36 String*30 Drop-Ship State/Province A X 
ZIP 37 String*20 Drop-Ship Zip/Postal Code A X 
COUNTRY 38 String*30 Drop-Ship Country A X 
PHONE 39 String*30 Drop-Ship Phone Number A X  Mask: (%-3C) %-3C-%-24C
FAX 40 String*30 Drop-Ship Fax Number A X  Mask: (%-3C) %-3C-%-24C
CONTACT 41 String*60 Drop-Ship Contact A X 
STOCKITEM 42 Boolean Stock Item A C X  List:2 entries
0 = No
1 = Yes
EMAIL 43 String*50 Drop-Ship E-mail A X 
PHONEC 44 String*30 Drop-Ship Contact Phone A X  Mask: (%-3C) %-3C-%-24C
FAXC 45 String*30 Drop-Ship Contact Fax A X  Mask: (%-3C) %-3C-%-24C
EMAILC 46 String*50 Drop-Ship Contact E-mail A X 
MANITEMNO 47 String*24 Manufacturer's Item Number A X  Mask: %-24C
VALUES 48 Long Optional Fields A C X 
CONTRACT 49 String*16 Contract A X  Mask: %-16C
PROJECT 50 String*16 Project A X  Mask: %-16N
CCATEGORY 51 String*16 (Cost) Category A X  Mask: %-16N
COSTCLASS 52 Integer Cost Class A C X  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
SQORDERED 101 BCD*10.4 Stocking Quantity Ordered A C X 
VDONHOLD 102 Boolean Vendor On Hold A C X  List:2 entries
0 = No
1 = Yes
USEVDTYPE 103 Integer Use I/C Vendor E A C X  List:10 entries
0 = No
1 = Vendor 1
2 = Vendor 2
3 = Vendor 3
4 = Vendor 4
5 = Vendor 5
6 = Vendor 6
7 = Vendor 7
8 = Vendor 8
9 = Vendor 9
ICVDCODE 104 String*12 Vendor A C X  Mask: %-12C
ISCOMPLETE 105 Boolean Completed A X  List:2 entries
0 = No
1 = Yes
LINECMPL 106 Long Lines Complete A X 
ISACTIVE 107 Boolean Is Record Active A C X  List:2 entries
0 = No
1 = Yes
LINE 108 Long Line A X 
MAPMANITEM 109 Boolean Map Manufacturer's Item Number E A  List:2 entries
0 = No
1 = Yes
PROCESSCMD 110 Integer Command A C X  List:18 entries
0 = Nothing to Process
1 = Insert Optional Fields
2 = Default and Tranfer Optional Fields
3 = Default Opt. Fields During Record Generation
4 = Remove Optional Fields
5 = Transfer Opt. Fields from Standing Document
6 = Insert Item Serial Optional Fields
7 = Insert Item Lot Optional Fields
21 = Auto-generate Serials
22 = Auto-generate Lots
23 = Auto-allocate Serials
24 = Auto-allocate Lots
25 = Clear Serials
26 = Clear Lots
27 = Auto-assign Serials
28 = Auto-assign Lots
29 = Create Serials/Lots List
31 = Post Serials/Lots to IC Inventory
CONTSTYLE 111 Integer Project Style A C X  List:3 entries
0 =
1 = Standard
2 = Basic
PROJTYPE 112 Integer Project Type A C X  List:4 entries
0 =
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
UFMTCONTNO 113 String*16 Unformatted Contract Code A C X  Mask: %-16C
UNITCOST 201 BCD*10.6 Unit Cost A X 
UCISMANUAL 202 Boolean Unit Cost is Manual A X  List:2 entries
0 = No
1 = Yes
CPCOSTTOPO 203 Boolean Copy Cost To Purchase Order A X  List:2 entries
0 = No
1 = Yes
EXTENDED 204 BCD*10.3 Extended Cost A X 
FCEXTENDED 205 BCD*10.3 Functional Extended A X 
DISCOUNT 206 BCD*10.3 Discount Amount A X 
DISCPCT 207 BCD*5.5 Discount Percentage A X 
UNITWEIGHT 208 BCD*10.4 Unit Weight A X 
EXTWEIGHT 209 BCD*10.4 Extended Weight A X 
WEIGHTUNIT 210 String*10 Weight Unit of Measure A X 
WEIGHTCONV 211 BCD*10.6 Weight Conversion A C X 
DEFUWEIGHT 212 BCD*10.4 Default Unit Weight A C X 
DEFEXTWGHT 213 BCD*10.4 Default Extended Weight A C X 
NETXTENDED 214 BCD*10.3 Net Extended Cost A X 
LINES 215 Long Lines A C X 
CURRENCY 216 String*3 Currency A C X 
CURRENCYD 217 String*60 Currency Description A C X 
RATE 218 BCD*8.7 Exchange Rate A C X 
RATEEXISTS 219 Boolean Exchange Rate Exists A C X  List:2 entries
0 = No
1 = Yes
RATETYPE 220 String*2 Rate Type A C X 
RATETYPED 221 String*60 Rate Type Description A C X 
RATEDATE 222 Date Rate Date A C X 
RATEOPER 223 Integer Rate Operation A C X  List:2 entries
1 = Multiply
2 = Divide
COSTDATE 224 Date Cost Date for Contract A C X 
DETAILNUM 225 Integer Detail Number A C X 

This page was generated on 2022-Aug-18

© 2021 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).