# View: Requisition Lines

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

## Compositions: 5

RotoID | Tables | Title | DLL
--- | --- | --- | ---
PO0760 | PORQNH1, PORQNH2 | Requisitions | PORQNH
PO0750 | PORQNC | Requisition Comments | PORQNC
PO0759 |  | Requisition Functions | PORQNG
PO0773 | PORQNLO | Requisition Detail Opt. Fields | PORQNLO
PO0777 | PORQNLV | Requisition Vendors | PORQNLV

## Keys: 4

Title | Fields
--- | ---
Detail Key | RQNHSEQ, RQNLREV
Sequence Key | RQNHSEQ, RQNLSEQ
Requisition/Vendor/Line | RQNHSEQ, VDCODE, RQNLSEQ
Vendor/Requisition/Line | VDCODE, RQNHSEQ, RQNLSEQ

## Fields: 89

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: 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 | 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 | = | *
2 | = | /
COSTDATE | 224 | Date | Cost Date for Contract | A C X |

This page was generated on 2008-May-01

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