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