# Table: Requisitions

Table: PORQNH1
View: PO0760
Record length: 638
Flags: A R

## Keys: 5

Title | Flags | Fields
--- | --- | ---
Master Key |  | RQNHSEQ
Requisitions |  | RQNNUMBER
Vendor | M | VDCODE, RQNHSEQ
Request By | M | REQUESTBY, RQNNUMBER
Vendor Document Number | M | VDCODE, RQNNUMBER

## Fields: 30

Field | Type | Title | Presentation
--- | --- | --- | ---
RQNHSEQ | BCD*10.0 | Requisition Sequence Key |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
NEXTLSEQ | BCD*10.0 | Next Line Sequence |
LINES | Long | Lines |
LINESCMPL | Long | Lines Complete |
LINESORDER | Long | Lines Ordered |
ISPRINTED | Boolean | Printed | List: 2 entries
0 | = | No
1 | = | Yes
ISCOMPLETE | Boolean | Completed | List: 2 entries
0 | = | No
1 | = | Yes
DTCOMPLETE | Date | Date Completed |
POSTDATE | Date | Last Posting Date |
DATE | Date | Requisition Date |
RQNNUMBER | String*22 | Requisition Number | Mask: %-22C
VDCODE | String*12 | Vendor | Mask: %-12C
VDEXISTS | Boolean | Vendor Exists | List: 2 entries
0 | = | No
1 | = | Yes
VDNAME | String*60 | Name |
ONHOLD | Boolean | On Hold | List: 2 entries
0 | = | No
1 | = | Yes
ORDEREDON | Date | Order Date |
EXPARRIVAL | Date | Date Required |
EXPIRATION | Date | Expiration Date |
DESCRIPTIO | String*60 | Description |
REFERENCE | String*60 | Reference |
COMMENT | String*250 | Comment |
OQORDERED | BCD*10.4 | Quantity Ordered |
REQUESTBY | String*60 | Requested by |
DOCSOURCE | Integer | Document Source | List: 2 entries
0 | = | Entered
1 | = | Internet
VALUES | Long | Optional Fields |
JOBLINES | Long | Job Related Lines |

This page was generated on 2009-Nov-19

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