View: Requisitions

RotoID: PO0345

Protocol: Superview
DLL:POFRQNL

Keys: 1

Title Fields
Requisitions RQNHSEQ, VDCODE, RQNLSEQ, RQNNUMBER

Fields: 140

Field Index Type Title Attributes Presentation
RQNHSEQ 1 BCD*10.0 Requisition Sequence Key E A 
VDCODE 2 String*12 Vendor E A  Mask: %-12C
RQNLSEQ 3 BCD*10.0 Requisition Line Sequence E A 
RQNNUMBER 4 String*22 Requisition Number E A  Mask: %-22C
RQNHSEQ1 1001 BCD*10.0 Requisition Sequence Key A C 
RQNLREV 1002 BCD*10.0 Line Number A C 
RQNLSEQ1 1003 BCD*10.0 Requisition Line Sequence A C 
LINEORDER 1004 Long Line Ordered A C 
RQNCSEQ 1005 BCD*10.0 Requisition Comment Sequence A C 
OEONUMBER 1006 String*22 Order Number A C  Mask: %-22C
VDEXISTS 1007 Boolean Vendor Exists A C  List:2 entries
0 = No
1 = Yes
VDCODE1 1008 String*12 Vendor A C  Mask: %-12C
VDNAME 1009 String*60 Name A C 
INDBTABLE 1010 Boolean Stored in Database Table A C  List:2 entries
0 = No
1 = Yes
COMPLETION 1011 Integer Completion Status A C  List:3 entries
1 = No
2 = Yes
3 = Yes
DTCOMPLETE 1012 Date Date Completed A C 
ITEMEXISTS 1013 Boolean Item Exists A C  List:2 entries
0 = No
1 = Yes
ITEMNO 1014 String*24 Item Number A C  Mask: %-24C
LOCATION 1015 String*6 Location A C  Mask: %-6N
ITEMDESC 1016 String*60 Item Description A C 
EXPARRIVAL 1017 Date Expected Arrival Date A C 
VENDITEMNO 1018 String*24 Vendor Item Number A C 
HASCOMMENT 1019 Boolean Comments/Instructions A C  List:2 entries
0 = No
1 = Yes
ORDERUNIT 1020 String*10 Unit of Measure A C  Mask: %-10c
ORDERCONV 1021 BCD*10.6 Order Unit Conversion A C 
ORDERDECML 1022 Integer Order Unit Decimals A C 
STOCKDECML 1023 Integer Stock Unit Decimals A C 
OQORDERED 1024 BCD*10.4 Quantity Ordered A C 
HASDROPSHI 1025 Boolean Drop-Ship A C  List:2 entries
0 = No
1 = Yes
DROPTYPE 1026 Integer Drop-Ship Type A C  List:4 entries
2 = Address Entered
3 = Inventory Location Address
4 = Customer Address
5 = Customer Ship-To Address
IDCUST 1027 String*12 Drop-Ship Customer A C  Mask: %-12C
IDCUSTSHPT 1028 String*6 Customer Ship-To Address A C  Mask: %-6C
DLOCATION 1029 String*6 Drop-Ship Location A C  Mask: %-6N
DESC 1030 String*60 Drop-Ship Description A C 
ADDRESS1 1031 String*60 Drop-Ship Address 1 A C 
ADDRESS2 1032 String*60 Drop-Ship Address 2 A C 
ADDRESS3 1033 String*60 Drop-Ship Address 3 A C 
ADDRESS4 1034 String*60 Drop-Ship Address 4 A C 
CITY 1035 String*30 Drop-Ship City A C 
STATE 1036 String*30 Drop-Ship State/Province A C 
ZIP 1037 String*20 Drop-Ship Zip/Postal Code A C 
COUNTRY 1038 String*30 Drop-Ship Country A C 
PHONE 1039 String*30 Drop-Ship Phone Number A C  Mask: (%-3C) %-3C-%-24C
FAX 1040 String*30 Drop-Ship Fax Number A C  Mask: (%-3C) %-3C-%-24C
CONTACT 1041 String*60 Drop-Ship Contact A C 
STOCKITEM 1042 Boolean Stock Item A C  List:2 entries
0 = No
1 = Yes
EMAIL 1043 String*50 Drop-Ship E-mail A C 
PHONEC 1044 String*30 Drop-Ship Contact Phone A C  Mask: (%-3C) %-3C-%-24C
FAXC 1045 String*30 Drop-Ship Contact Fax A C  Mask: (%-3C) %-3C-%-24C
EMAILC 1046 String*50 Drop-Ship Contact E-mail A C 
MANITEMNO 1047 String*24 Manufacturer's Item Number A C  Mask: %-24C
VALUES 1048 Long Optional Fields A C 
CONTRACT 1049 String*16 Contract A C  Mask: %-16C
PROJECT 1050 String*16 Project A C  Mask: %-16N
CCATEGORY 1051 String*16 (Cost) Category A C  Mask: %-16N
COSTCLASS 1052 Integer Cost Class A C  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
SQORDERED 1101 BCD*10.4 Stocking Quantity Ordered A C 
VDONHOLD 1102 Boolean Vendor On Hold A C  List:2 entries
0 = No
1 = Yes
USEVDTYPE 1103 Integer Use I/C Vendor A C  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 1104 String*12 Vendor A C  Mask: %-12C
ISCOMPLETE 1105 Boolean Completed A C  List:2 entries
0 = No
1 = Yes
LINECMPL 1106 Long Lines Complete A C 
ISACTIVE 1107 Boolean Is Record Active A C  List:2 entries
0 = No
1 = Yes
LINE 1108 Long Line A C 
MAPMANITEM 1109 Boolean Map Manufacturer's Item Number A C  List:2 entries
0 = No
1 = Yes
PROCESSCMD 1110 Integer Command A C  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 1111 Integer Project Style A C  List:3 entries
0 =
1 = Standard
2 = Basic
PROJTYPE 1112 Integer Project Type A C  List:4 entries
0 =
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
UFMTCONTNO 1113 String*16 Unformatted Contract Code A C  Mask: %-16C
UNITCOST 1201 BCD*10.6 Unit Cost A C 
UCISMANUAL 1202 Boolean Unit Cost is Manual A C  List:2 entries
0 = No
1 = Yes
CPCOSTTOPO 1203 Boolean Copy Cost To Purchase Order A C  List:2 entries
0 = No
1 = Yes
EXTENDED 1204 BCD*10.3 Extended Cost A C 
FCEXTENDED 1205 BCD*10.3 Functional Extended A C 
DISCOUNT 1206 BCD*10.3 Discount Amount A C 
DISCPCT 1207 BCD*5.5 Discount Percentage A C 
UNITWEIGHT 1208 BCD*10.4 Unit Weight A C 
EXTWEIGHT 1209 BCD*10.4 Extended Weight A C 
WEIGHTUNIT 1210 String*10 Weight Unit of Measure A C 
WEIGHTCONV 1211 BCD*10.6 Weight Conversion A C 
DEFUWEIGHT 1212 BCD*10.4 Default Unit Weight A C 
DEFEXTWGHT 1213 BCD*10.4 Default Extended Weight A C 
NETXTENDED 1214 BCD*10.3 Net Extended Cost A C 
LINES 1215 Long Lines A C 
CURRENCY 1216 String*3 Currency A C 
CURRENCYD 1217 String*60 Currency Description A C 
RATE 1218 BCD*8.7 Exchange Rate A C 
RATEEXISTS 1219 Boolean Exchange Rate Exists A C  List:2 entries
0 = No
1 = Yes
RATETYPE 1220 String*2 Rate Type A C 
RATETYPED 1221 String*60 Rate Type Description A C 
RATEDATE 1222 Date Rate Date A C 
RATEOPER 1223 Integer Rate Operation A C  List:2 entries
1 = Multiply
2 = Divide
COSTDATE 1224 Date Cost Date for Contract A C 
DETAILNUM 1225 Integer Detail Number A C 
RQNHSEQ2 2001 BCD*10.0 Requisition Sequence Key A C 
NEXTLSEQ 2002 BCD*10.0 Next Line Sequence A C 
LINES 2003 Long Lines A C 
LINESCMPL 2004 Long Lines Complete A C 
LINESORDER 2005 Long Lines Ordered A C 
ISPRINTED 2006 Boolean Printed A C  List:2 entries
0 = No
1 = Yes
ISCOMPLET2 2007 Boolean Completed A C  List:2 entries
0 = No
1 = Yes
DTCOMPLET2 2008 Date Date Completed A C 
POSTDATE 2009 Date Last Posting Date A C 
DATE 2010 Date Requisition Date A C 
RQNNUMBER2 2011 String*22 Requisition Number A C  Mask: %-22C
VDCODE2 2012 String*12 Vendor A C  Mask: %-12C
VDEXISTS2 2013 Boolean Vendor Exists A C  List:2 entries
0 = No
1 = Yes
VDNAME2 2014 String*60 Name A C 
ONHOLD 2015 Boolean On Hold A C  List:2 entries
0 = No
1 = Yes
ORDEREDON 2016 Date Order Date A C 
EXPARRIVA2 2017 Date Date Required A C 
EXPIRATION 2018 Date Expiration Date A C 
DESCRIPTIO 2019 String*60 Description A C 
REFERENCE 2020 String*60 Reference A C 
COMMENT 2021 String*250 Comment A C 
OQORDERED2 2029 BCD*10.4 Quantity Ordered A C 
REQUESTBY 2030 String*60 Requested by A C 
DOCSOURCE 2031 Integer Document Source A C  List:2 entries
0 = Entered
1 = Internet
VALUES2 2032 Long Optional Fields A C 
JOBLINES 2033 Long Job Related Lines A C 
STCODE 2121 String*6 Location A C  Mask: %-6N
STDESC 2122 String*60 Location Description A C 
APPROVED 2131 Integer Approval Status A C  List:2 entries
11 = Entered
12 = Approved
APPROVER 2132 String*8 Approver ID A C 
ENTEREDBY 2139 String*8 Entered By A C 
EXTWEIGHT 2141 BCD*10.4 Extended Weight A C 
FCEXTENDED 2142 BCD*10.3 Func. Extended Amount A C 
VDONHOLD2 2151 Boolean Vendor On Hold A C  List:2 entries
0 = No
1 = Yes
LOCKED 2152 Boolean Document Locked A C  List:2 entries
0 = No
1 = Yes
EXPIRED 2153 Boolean Requisition Has Expired A C  List:2 entries
0 = No
1 = Yes
CANDELETE 2154 Boolean Is Document Deletable A C  List:2 entries
0 = No
1 = Yes
ISACTIVE2 2155 Boolean Is Record Active A C  List:2 entries
0 = No
1 = Yes
HASDETAILS 2156 Boolean Has Details A C  List:2 entries
0 = No
1 = Yes
CPACTIVE 2157 Boolean Is Canadian Payroll Active? A C  List:2 entries
0 = No
1 = Yes
UPACTIVE 2158 Boolean Is U.S. Payroll Active? A C  List:2 entries
0 = No
1 = Yes
PRCESSCMD2 2159 Integer Command A C  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
HASJOB 2160 Boolean Job Related A C  List:2 entries
0 = No
1 = Yes
APPNAME 2161 String*60 Approver Name A C 
FCCURRENCY 2162 String*3 Functional Currency A C  Mask: %-3N
DETAILNEXT 2163 Integer Next Detail Number A C 

This page was generated on 2021-Nov-24

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