View: Requisition Vendors

RotoID: PO0777
Table: PORQNLV
Protocol: Detail, Ordered revisions
DLL:PORQNLV

Compositions: 3

RotoID Tables Title DLL
PO0760 PORQNH1PORQNH2 Requisitions PORQNH
PO0759 Requisition Functions PORQNG
PO0770 PORQNL Requisition Lines PORQNL

Keys: 1

Title Fields
Master key RQNHSEQ, VDCODE

Fields: 27

Field Index Type Title Attributes Presentation
RQNHSEQ 1 BCD*10.0 Requisition Sequence Key E A K R 
VDCODE 2 String*12 Vendor E A K R  Mask: %-12C
LINES 3 Long Lines E A C X 
LINESCMPL 4 Long Lines Complete E A C X 
INDBTABLE 5 Boolean Stored in Database Table A C X  List:2 entries
0 = No
1 = Yes
VDEXISTS 6 Boolean Vendor Exists A C X  List:2 entries
0 = No
1 = Yes
CURRENCY 7 String*3 Currency E A X  Mask: %-3N
RATE 8 BCD*8.7 Exchange Rate A X 
SPREAD 9 BCD*8.7 Rate Spread A X 
RATETYPE 10 String*2 Rate Type A X  Mask: %-2N
RATEMATCH 11 Integer Rate Match Type A X 
RATEDATE 12 Date Rate Date A X 
RATEOPER 13 Integer Rate Operation A X  List:2 entries
1 = Multiply
2 = Divide
RATEOVER 14 Boolean Rate Overridden A X  List:2 entries
0 = No
1 = Yes
SCURNDECML 15 Integer Decimal Places A X 
EXTENDED 16 BCD*10.3 Extended Cost A X 
FCEXTENDED 17 BCD*10.3 Func. Extended Amount A C X 
ISCOMPLETE 18 Boolean Completed A C X  List:2 entries
0 = No
1 = Yes
DTCOMPLETE 19 Date Date Completed A X 
CURRENCYD 300 String*60 Currency Description A C X 
RATETYPED 301 String*60 Rate Type Description A C X 
VEND 302 Long Vendors A C X 
VENDCMPL 303 Long Vendors Completed A C X 
LOCKED 304 Boolean Document Locked A C X  List:2 entries
0 = No
1 = Yes
RATEEXISTS 305 Boolean Exchange Rate Exists A C X  List:2 entries
0 = No
1 = Yes
HASDETAILS 306 Boolean Has Details A C X  List:2 entries
0 = No
1 = Yes
PROCESSCMD 307 Integer Command E A C X  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

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