View: Requisitions

RotoID: PO0760
Tables: PORQNH1PORQNH2
Protocol: Header, Key auto generate
DLL:PORQNH

Compositions: 5

RotoID Tables Title DLL

PO0750 PORQNC Requisition Comments PORQNC
PO0770 PORQNL Requisition Lines PORQNL
PO0759 Requisition Functions PORQNG
PO0763 PORQNHO Requisition Header Opt. Fields PORQNHO
PO0777 PORQNLV Requisition Vendors PORQNLV

Keys: 5

Title Fields

Master Key RQNHSEQ
Requisitions RQNNUMBER
Vendor VDCODERQNHSEQ
Request By REQUESTBYRQNNUMBER
Vendor Document Number VDCODERQNNUMBER

Fields: 46

Field Index Type Title Attributes Presentation

RQNHSEQ 1 BCD*10.0 Requisition Sequence Key E A K R 
NEXTLSEQ 2 BCD*10.0 Next Line Sequence A C X 
LINES 3 Long Lines E A C X 
LINESCMPL 4 Long Lines Complete E A C X 
LINESORDER 5 Long Lines Ordered E A C X 
ISPRINTED 6 Boolean Printed E A X  List:2 entries
0 = No
1 = Yes
ISCOMPLETE 7 Boolean Completed A C X  List:2 entries
0 = No
1 = Yes
DTCOMPLETE 8 Date Date Completed A X 
POSTDATE 9 Date Last Posting Date A C X 
DATE 10 Date Requisition Date E A X 
RQNNUMBER 11 String*22 Requisition Number E A X  Mask: %-22C
VDCODE 12 String*12 Vendor E A X  Mask: %-12C
VDEXISTS 13 Boolean Vendor Exists A C X  List:2 entries
0 = No
1 = Yes
VDNAME 14 String*60 Name E A X 
ONHOLD 15 Boolean On Hold E A X  List:2 entries
0 = No
1 = Yes
ORDEREDON 16 Date Order Date E A X 
EXPARRIVAL 17 Date Date Required E A X 
EXPIRATION 18 Date Expiration Date E A X 
DESCRIPTIO 19 String*60 Description E A X 
REFERENCE 20 String*60 Reference E A X 
COMMENT 21 String*250 Comment E A X 
OQORDERED 29 BCD*10.4 Quantity Ordered E A C X 
REQUESTBY 30 String*60 Requested by E A X 
DOCSOURCE 31 Integer Document Source E A X  List:2 entries
0 = Entered
1 = Internet
VALUES 32 Long Optional Fields E A C X 
JOBLINES 33 Long Job Related Lines A C X 
STCODE 121 String*6 Location E A X  Mask: %-6N
STDESC 122 String*60 Location Description E A X 
APPROVED 131 Integer Approval Status A X  List:2 entries
11 = Entered
12 = Approved
APPROVER 132 String*8 Approver ID E A X 
ENTEREDBY 139 String*8 Entered By A X 
EXTWEIGHT 141 BCD*10.4 Extended Weight E A C X 
FCEXTENDED 142 BCD*10.3 Func. Extended Amount E A X 
VDONHOLD 151 Boolean Vendor On Hold A C X  List:2 entries
0 = No
1 = Yes
LOCKED 152 Boolean Document Locked A C X  List:2 entries
0 = No
1 = Yes
EXPIRED 153 Boolean Requisition Has Expired A C X  List:2 entries
0 = No
1 = Yes
CANDELETE 154 Boolean Is Document Deletable A C X  List:2 entries
0 = No
1 = Yes
ISACTIVE 155 Boolean Is Record Active A C X  List:2 entries
0 = No
1 = Yes
HASDETAILS 156 Boolean Has Details A C X  List:2 entries
0 = No
1 = Yes
CPACTIVE 157 Boolean Is Canadian Payroll Active? A C X  List:2 entries
0 = No
1 = Yes
UPACTIVE 158 Boolean Is U.S. Payroll Active? A C X  List:2 entries
0 = No
1 = Yes
PROCESSCMD 159 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
HASJOB 160 Boolean Job Related E A X  List:2 entries
0 = No
1 = Yes
APPNAME 161 String*60 Approver Name A C X 
FCCURRENCY 162 String*3 Functional Currency A C X  Mask: %-3N
DETAILNEXT 163 Integer Next Detail Number A X