# View: Requisitions

RotoID: PO0345
Protocol: Superview
DLL: POFRQNL

## Compositions: 0

## Keys: 1

Title | Fields
--- | ---
Requisitions | RQNHSEQ, VDCODE, RQNLSEQ, RQNNUMBER

## Fields: 138

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 | 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: 6 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
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 | = | *
2 | = | /
COSTDATE | 1224 | Date | Cost Date for Contract | 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: 6 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
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

This page was generated on 2008-May-01

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