View: Purchase Order Lines

RotoID: PO0630
Table: POPORL
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:POPORL

Compositions: 6

RotoID Tables Title DLL

PO0620 POPORH1POPORH2 Purchase Orders POPORH
PO0610 POPORC Purchase Order Comments POPORC
PO0619 Purchase Order Functions POPORG
PO0621 POPORI Purchase Order Postings POPORI
PO0631 POPORM Purchase Order Posting Lines POPORM
PO0633 POPORLO Purchase Order Det. Opt. Fields POPORLO

Keys: 10

Title Fields

Detail Key PORHSEQPORLREV
Sequence Key PORHSEQPORLSEQ
Order Number Key OEONUMBERPORHSEQPORLSEQ
Item/Exp. Arrival Key ITEMNOEXPARRIVALPORHSEQPORLSEQ
Exp. Arrival/Qty. Ordered Key EXPARRIVALOQORDEREDITEMNOLOCATION
Exp. Arrival/Item No./Completion EXPARRIVALITEMNOCOMPLETION
Exp. Arrival/Qty. Outstanding EXPARRIVALOQOUTSTANDITEMNO
Item/ExpArrival/Loc./Completion ITEMNOEXPARRIVALLOCATIONCOMPLETION
Detail Number PORHSEQDETAILNUMPORLSEQ
Item/ExpArrival/Loc./Completion PORHSEQEXPARRIVALLOCATIONCOMPLETION

Fields: 252

Field Index Type Title Attributes Presentation

PORHSEQ 1 BCD*10.0 Purchase Order Sequence Key E A K R 
PORLREV 2 BCD*10.0 Line Number E A K R 
PORLSEQ 3 BCD*10.0 Purchase Order Line Sequence E A X 
PORCSEQ 4 BCD*10.0 Purchase Order Comment Sequence A X 
INDBTABLE 5 Boolean Stored in Database Table A C X  List:2 entries
0 = No
1 = Yes
CONSOLSEQ 6 BCD*10.0 Consolidated to line A C X 
RQNHSEQ 7 BCD*10.0 Requisition Sequence Key A X 
RQNLSEQ 8 BCD*10.0 Requisition Line Sequence A X 
OEONUMBER 9 String*22 Order Number A X  Mask: %-22C
POSTEDTOIC 10 Boolean Posted to I/C A C X  List:2 entries
0 = No
1 = Yes
TOPOSTTOIC 11 Boolean To Post to I/C A C X  List:2 entries
0 = No
1 = Yes
STPRINT 12 Boolean Print Status A X  List:2 entries
0 = No
1 = Yes
COMPLETION 13 Integer Completion Status A X  List:3 entries
1 = No
2 = Yes
3 = Yes
DTCOMPLETE 14 Date Date Completed A X 
ITEMEXISTS 15 Boolean Item Exists A C X  List:2 entries
0 = No
1 = Yes
ITEMNO 16 String*24 Item Number A P X  Mask: %-24C
LOCATION 17 String*6 Location A X  Mask: %-6N
ITEMDESC 18 String*60 Item Description A X 
EXPARRIVAL 19 Date Expected Arrival Date A X 
VENDITEMNO 20 String*24 Vendor Item Number A X 
HASCOMMENT 21 Boolean Comments/Instructions A X  List:2 entries
0 = No
1 = Yes
ORDERUNIT 22 String*10 Unit of Measure A X  Mask: %-10c
ORDERCONV 23 BCD*10.6 Order Unit Conversion A C X 
ORDERDECML 24 Integer Order Unit Decimals A C X 
STOCKDECML 25 Integer Stock Unit Decimals A C X 
OQORDERED 26 BCD*10.4 Quantity Ordered A X 
OQRECEIVED 27 BCD*10.4 Quantity Received A C X 
OQCANCELED 28 BCD*10.4 Quantity Canceled A X 
OQRCPEXTRA 29 BCD*10.4 Received Extra A C X 
OQOUTSTAND 30 BCD*10.4 Quantity Outstanding A X 
SQORDERED 31 BCD*10.4 Stocking Quantity Ordered A C X 
SQRECEIVED 32 BCD*10.4 Stocking Quantity Received A C X 
SQCANCELED 33 BCD*10.4 Stocking Quantity Canceled A C X 
SQRCPEXTRA 34 BCD*10.4 Stocking Quantity Received Extra A C X 
SQSETTLED 35 BCD*10.4 Stocking Quantity Settled A C X 
SQOUTSTAND 36 BCD*10.4 Stocking Quantity Outstanding A C X 
UNITWEIGHT 37 BCD*10.4 Unit Weight A X 
EXTWEIGHT 38 BCD*10.4 Extended Weight A X 
OQRCPDAYS 39 BCD*10.4 Days * Quantity Received A C X 
EXTRECEIVE 40 BCD*10.3 Extended Received Amount A C X 
EXTCANCEL 41 BCD*10.3 Extended Canceled Amount A C X 
SRRECEIVED 42 BCD*10.3 Amount Received To Date A X 
UNITCOST 43 BCD*10.6 Unit Cost A X 
EXTENDED 44 BCD*10.3 Extended Cost A X 
TAXBASE1 45 BCD*10.3 Tax Base 1 A X 
TAXBASE2 46 BCD*10.3 Tax Base 2 A X 
TAXBASE3 47 BCD*10.3 Tax Base 3 A X 
TAXBASE4 48 BCD*10.3 Tax Base 4 A X 
TAXBASE5 49 BCD*10.3 Tax Base 5 A X 
TAXCLASS1 50 Integer Tax Class 1 A X 
TAXCLASS2 51 Integer Tax Class 2 A X 
TAXCLASS3 52 Integer Tax Class 3 A X 
TAXCLASS4 53 Integer Tax Class 4 A X 
TAXCLASS5 54 Integer Tax Class 5 A X 
TAXRATE1 55 BCD*8.5 Tax Rate 1 A X 
TAXRATE2 56 BCD*8.5 Tax Rate 2 A X 
TAXRATE3 57 BCD*8.5 Tax Rate 3 A X 
TAXRATE4 58 BCD*8.5 Tax Rate 4 A X 
TAXRATE5 59 BCD*8.5 Tax Rate 5 A X 
TAXINCLUD1 60 Boolean Tax Includable 1 A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD2 61 Boolean Tax Includable 2 A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD3 62 Boolean Tax Includable 3 A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD4 63 Boolean Tax Includable 4 A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD5 64 Boolean Tax Includable 5 A X  List:2 entries
0 = No
1 = Yes
TAXAMOUNT1 65 BCD*10.3 Tax Amount 1 A X 
TAXAMOUNT2 66 BCD*10.3 Tax Amount 2 A X 
TAXAMOUNT3 67 BCD*10.3 Tax Amount 3 A X 
TAXAMOUNT4 68 BCD*10.3 Tax Amount 4 A X 
TAXAMOUNT5 69 BCD*10.3 Tax Amount 5 A X 
TXALLOAMT1 70 BCD*10.3 Tax Allocated Amount 1 A X 
TXALLOAMT2 71 BCD*10.3 Tax Allocated Amount 2 A X 
TXALLOAMT3 72 BCD*10.3 Tax Allocated Amount 3 A X 
TXALLOAMT4 73 BCD*10.3 Tax Allocated Amount 4 A X 
TXALLOAMT5 74 BCD*10.3 Tax Allocated Amount 5 A X 
TXRECVAMT1 75 BCD*10.3 Tax Recoverable Amount 1 A X 
TXRECVAMT2 76 BCD*10.3 Tax Recoverable Amount 2 A X 
TXRECVAMT3 77 BCD*10.3 Tax Recoverable Amount 3 A X 
TXRECVAMT4 78 BCD*10.3 Tax Recoverable Amount 4 A X 
TXRECVAMT5 79 BCD*10.3 Tax Recoverable Amount 5 A X 
TXEXPSAMT1 80 BCD*10.3 Tax Expense Amount 1 A X 
TXEXPSAMT2 81 BCD*10.3 Tax Expense Amount 2 A X 
TXEXPSAMT3 82 BCD*10.3 Tax Expense Amount 3 A X 
TXEXPSAMT4 83 BCD*10.3 Tax Expense Amount 4 A X 
TXEXPSAMT5 84 BCD*10.3 Tax Expense Amount 5 A X 
TXBASEALLO 85 BCD*10.3 Net of Tax A X 
TXINCLUDED 86 BCD*10.3 Tax Included A C X 
TXEXCLUDED 87 BCD*10.3 Tax Excluded A C X 
TAXAMOUNT 88 BCD*10.3 Total Tax A C X 
TXRECVAMT 89 BCD*10.3 Recoverable Tax A X 
TXEXPSAMT 90 BCD*10.3 Expensed Tax A X 
TXALLOAMT 91 BCD*10.3 Allocated Tax A X 
FCEXTENDED 92 BCD*10.3 Rcp. Ext. Amt. A X 
GLACEXPENS 93 String*45 Expense Account A X  Mask: %-45C
HASDROPSHI 94 Boolean Drop-Ship A X  List:2 entries
0 = No
1 = Yes
DROPTYPE 95 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 96 String*12 Drop-Ship Customer A X  Mask: %-12C
IDCUSTSHPT 97 String*6 Customer Ship-To Address A X  Mask: %-6C
DLOCATION 98 String*6 Drop-Ship Location A X  Mask: %-6N
DESC 99 String*60 Drop-Ship Description A X 
ADDRESS1 100 String*60 Drop-Ship Address 1 A X 
ADDRESS2 101 String*60 Drop-Ship Address 2 A X 
ADDRESS3 102 String*60 Drop-Ship Address 3 A X 
ADDRESS4 103 String*60 Drop-Ship Address 4 A X 
CITY 104 String*30 Drop-Ship City A X 
STATE 105 String*30 Drop-Ship State/Province A X 
ZIP 106 String*20 Drop-Ship Zip/Postal Code A X 
COUNTRY 107 String*30 Drop-Ship Country A X 
PHONE 108 String*30 Drop-Ship Phone Number A X  Mask: (%-3C) %-3C-%-24C
FAX 109 String*30 Drop-Ship Fax Number A X  Mask: (%-3C) %-3C-%-24C
CONTACT 110 String*60 Drop-Ship Contact A X 
STOCKITEM 111 Boolean Stock Item A C X  List:2 entries
0 = No
1 = Yes
EMAIL 112 String*50 Drop-Ship E-mail A X 
PHONEC 113 String*30 Drop-Ship Contact Phone A X  Mask: (%-3C) %-3C-%-24C
FAXC 114 String*30 Drop-Ship Contact Fax A X  Mask: (%-3C) %-3C-%-24C
EMAILC 115 String*50 Drop-Ship Contact E-mail A X 
GLNONSTKCR 116 String*45 Non-Stock Clearing Account A X  Mask: %-45C
MANITEMNO 117 String*24 Manufacturer's Item Number A X  Mask: %-24C
DISCPCT 118 BCD*5.5 Discount Percentage A X 
DISCOUNT 119 BCD*10.3 Discount Amount A X 
VALUES 120 Long Optional Fields A C X 
DISCOUNTF 121 BCD*10.3 Func. Discount Amount A X 
ISRECEIVED 122 Boolean Received A X  List:2 entries
0 = No
1 = Yes
AGENTLSEQ 123 BCD*10.0 Agent Line Sequence A X 
CONTRACT 124 String*16 Contract A X  Mask: %-16C
PROJECT 125 String*16 Project A X  Mask: %-16N
CCATEGORY 126 String*16 (Cost) Category A X  Mask: %-16N
COSTCLASS 127 Integer Cost Class A C X  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
BILLTYPE 128 Integer Billing Type A P X  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLRATE 129 BCD*10.6 Billing Rate A X 
BILLCURR 130 String*3 Billing Currency A C X  Mask: %-3N
ARITEMNO 131 String*16 A/R Item Number A X  Mask: %-16C
ARUNIT 132 String*10 A/R Unit of Measure A X  Mask: %-10C
TAXCLASS1D 141 String*60 Tax Class 1 Description A C X 
TAXCLASS2D 142 String*60 Tax Class 2 Description A C X 
TAXCLASS3D 143 String*60 Tax Class 3 Description A C X 
TAXCLASS4D 144 String*60 Tax Class 4 Description A C X 
TAXCLASS5D 145 String*60 Tax Class 5 Description A C X 
GLACEXPNSD 146 String*60 Expense Account Description A C X 
TXINCLUDE1 147 BCD*10.3 Included Tax Amount 1 A X 
TXINCLUDE2 148 BCD*10.3 Included Tax Amount 2 A X 
TXINCLUDE3 149 BCD*10.3 Included Tax Amount 3 A X 
TXINCLUDE4 150 BCD*10.3 Included Tax Amount 4 A X 
TXINCLUDE5 151 BCD*10.3 Included Tax Amount 5 A X 
TXEXCLUDE1 152 BCD*10.3 Excluded Tax Amount 1 A X 
TXEXCLUDE2 153 BCD*10.3 Excluded Tax Amount 2 A X 
TXEXCLUDE3 154 BCD*10.3 Excluded Tax Amount 3 A X 
TXEXCLUDE4 155 BCD*10.3 Excluded Tax Amount 4 A X 
TXEXCLUDE5 156 BCD*10.3 Excluded Tax Amount 5 A X 
SREXTORDER 157 BCD*10.3 Extended Order Amount A C X 
ISCOMPLETE 158 Boolean Completed A X  List:2 entries
0 = No
1 = Yes
ISACTIVE 159 Boolean Is Record Active A C X  List:2 entries
0 = No
1 = Yes
TAXLINE 160 Long Lines Tax Calculation Sees A X 
LINECMPL 161 Long Lines Complete A X 
LINE 162 Long Line A X 
EXSTDCOST 163 BCD*10.3 Extended Std. Cost in Src Curr A C X 
EXMRCOST 164 BCD*10.3 Extended MR Cost in Src Curr A C X 
EXALT1COST 165 BCD*10.3 Extended Cost 1 in Src Curr A C X 
EXALT2COST 166 BCD*10.3 Extended Cost 2 in Src Curr A C X 
GLNONSTKCD 167 String*60 Non-Stock Clearing Account Desc. A C X 
MAPMANITEM 168 Boolean Map Manufacturer's Item Number E A  List:2 entries
0 = No
1 = Yes
NETXTENDED 169 BCD*10.3 Net Extended Cost A X 
OOVERSEQ 170 BCD*10.0 Process Command Sequence Number A C X 
OOVERLSEQ 171 BCD*10.0 Process Command Line Sequence A C X 
RQNLREV 172 BCD*10.0 Line Number A C X 
PROCESSCMD 173 Integer Command 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
TFBASEALLO 174 BCD*10.3 Func. Net of Tax A C X 
TFINCLUDE1 175 BCD*10.3 Func. Tax Included Amount 1 A C X 
TFINCLUDE2 176 BCD*10.3 Func. Tax Included Amount 2 A C X 
TFINCLUDE3 177 BCD*10.3 Func. Tax Included Amount 3 A C X 
TFINCLUDE4 178 BCD*10.3 Func. Tax Included Amount 4 A C X 
TFINCLUDE5 179 BCD*10.3 Func. Tax Included Amount 5 A C X 
TFALLOAMT1 180 BCD*10.3 Func. Tax Allocated Amount 1 A C X 
TFALLOAMT2 181 BCD*10.3 Func. Tax Allocated Amount 2 A C X 
TFALLOAMT3 182 BCD*10.3 Func. Tax Allocated Amount 3 A C X 
TFALLOAMT4 183 BCD*10.3 Func. Tax Allocated Amount 4 A C X 
TFALLOAMT5 184 BCD*10.3 Func. Tax Allocated Amount 5 A C X 
TFRECVAMT1 185 BCD*10.3 Func. Tax Recoverable Amount 1 A C X 
TFRECVAMT2 186 BCD*10.3 Func. Tax Recoverable Amount 2 A C X 
TFRECVAMT3 187 BCD*10.3 Func. Tax Recoverable Amount 3 A C X 
TFRECVAMT4 188 BCD*10.3 Func. Tax Recoverable Amount 4 A C X 
TFRECVAMT5 189 BCD*10.3 Func. Tax Recoverable Amount 5 A C X 
TFEXPSAMT1 190 BCD*10.3 Func. Tax Expense Amount 1 A C X 
TFEXPSAMT2 191 BCD*10.3 Func. Tax Expense Amount 2 A C X 
TFEXPSAMT3 192 BCD*10.3 Func. Tax Expense Amount 3 A C X 
TFEXPSAMT4 193 BCD*10.3 Func. Tax Expense Amount 4 A C X 
TFEXPSAMT5 194 BCD*10.3 Func. Tax Expense Amount 5 A C X 
CONTSTYLE 195 Integer Project Style A C X  List:3 entries
0 =
1 = Standard
2 = Basic
PROJTYPE 196 Integer Project Type A C X  List:4 entries
0 =
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC 197 Integer Accounting Method A C X  List:9 entries
0 =
1 = Completed Project
2 = Total Cost Percentage Complete
3 = Labor Hours Percentage Complete
4 = Billings and Costs
5 = Project Percentage Complete
6 = Category Percentage Complete
7 = Completed Contract
8 = Accrual-Basis
UFMTCONTNO 198 String*16 Unformatted Contract Code A C X  Mask: %-16C
TARAMOUNT1 199 BCD*10.3 Tax Reporting Amount 1 A X 
TARAMOUNT2 200 BCD*10.3 Tax Reporting Amount 2 A X 
TARAMOUNT3 201 BCD*10.3 Tax Reporting Amount 3 A X 
TARAMOUNT4 202 BCD*10.3 Tax Reporting Amount 4 A X 
TARAMOUNT5 203 BCD*10.3 Tax Reporting Amount 5 A X 
TRALLOAMT1 204 BCD*10.3 Tax Reporting Allocated Amount 1 A X 
TRALLOAMT2 205 BCD*10.3 Tax Reporting Allocated Amount 2 A X 
TRALLOAMT3 206 BCD*10.3 Tax Reporting Allocated Amount 3 A X 
TRALLOAMT4 207 BCD*10.3 Tax Reporting Allocated Amount 4 A X 
TRALLOAMT5 208 BCD*10.3 Tax Reporting Allocated Amount 5 A X 
TRRECVAMT1 209 BCD*10.3 Tax Reporting Recoverable Amt. 1 A X 
TRRECVAMT2 210 BCD*10.3 Tax Reporting Recoverable Amt. 2 A X 
TRRECVAMT3 211 BCD*10.3 Tax Reporting Recoverable Amt. 3 A X 
TRRECVAMT4 212 BCD*10.3 Tax Reporting Recoverable Amt. 4 A X 
TRRECVAMT5 213 BCD*10.3 Tax Reporting Recoverable Amt. 5 A X 
TREXPSAMT1 214 BCD*10.3 Tax Reporting Expense Amount 1 A X 
TREXPSAMT2 215 BCD*10.3 Tax Reporting Expense Amount 2 A X 
TREXPSAMT3 216 BCD*10.3 Tax Reporting Expense Amount 3 A X 
TREXPSAMT4 217 BCD*10.3 Tax Reporting Expense Amount 4 A X 
TREXPSAMT5 218 BCD*10.3 Tax Reporting Expense Amount 5 A X 
TRINCLUDE1 219 BCD*10.3 Tax Reporting Included Amount 1 A X 
TRINCLUDE2 220 BCD*10.3 Tax Reporting Included Amount 2 A X 
TRINCLUDE3 221 BCD*10.3 Tax Reporting Included Amount 3 A X 
TRINCLUDE4 222 BCD*10.3 Tax Reporting Included Amount 4 A X 
TRINCLUDE5 223 BCD*10.3 Tax Reporting Included Amount 5 A X 
TREXCLUDE1 224 BCD*10.3 Tax Reporting Excluded Amount 1 A X 
TREXCLUDE2 225 BCD*10.3 Tax Reporting Excluded Amount 2 A X 
TREXCLUDE3 226 BCD*10.3 Tax Reporting Excluded Amount 3 A X 
TREXCLUDE4 227 BCD*10.3 Tax Reporting Excluded Amount 4 A X 
TREXCLUDE5 228 BCD*10.3 Tax Reporting Excluded Amount 5 A X 
TARAMOUNT 229 BCD*10.3 Tax Reporting Total Amount A X 
TRINCLUDED 230 BCD*10.3 Tax Reporting Included Amount A X 
TREXCLUDED 231 BCD*10.3 Tax Reporting Excluded Amount A X 
TRRECVAMT 232 BCD*10.3 Tax Reporting Recoverable Amount A X 
TREXPSAMT 233 BCD*10.3 Tax Reporting Expensed Amount A X 
TRALLOAMT 234 BCD*10.3 Tax Reporting Allocated Amount A X 
UCISMANUAL 235 Boolean Unit Cost is Manual A X  List:2 entries
0 = No
1 = Yes
WEIGHTUNIT 236 String*10 Weight Unit of Measure A X 
WEIGHTCONV 237 BCD*10.6 Weight Conversion A C X 
DEFUWEIGHT 238 BCD*10.4 Default Unit Weight A C X 
DEFEXTWGHT 239 BCD*10.4 Default Extended Weight A C X 
BILLRATECV 240 BCD*10.6 Billing Rate Conversion Factor A C X 
UNITBILLSR 241 BCD*10.6 Unit Billing Amount A C X 
EXTBILLSR 242 BCD*10.3 Extended Billing Amount A X 
COPYDETAIL 243 Boolean Copy This Detail Line? A X  List:2 entries
0 = No
1 = Yes
DETAILNUM 244 Integer Detail Number A C X 
CAXABLE1 245 Boolean Reverse Chargeable 1 A C X  List:2 entries
0 = No
1 = Yes
CAXABLE2 246 Boolean Reverse Chargeable 2 A C X  List:2 entries
0 = No
1 = Yes
CAXABLE3 247 Boolean Reverse Chargeable 3 A C X  List:2 entries
0 = No
1 = Yes
CAXABLE4 248 Boolean Reverse Chargeable 4 A C X  List:2 entries
0 = No
1 = Yes
CAXABLE5 249 Boolean Reverse Chargeable 5 A C X  List:2 entries
0 = No
1 = Yes
CAXBASE1 250 BCD*10.3 Reverse Charges Base 1 A C X 
CAXBASE2 251 BCD*10.3 Reverse Charges Base 2 A C X 
CAXBASE3 252 BCD*10.3 Reverse Charges Base 3 A C X 
CAXBASE4 253 BCD*10.3 Reverse Charges Base 4 A C X 
CAXBASE5 254 BCD*10.3 Reverse Charges Base 5 A C X 
CAXDTAMT1 255 BCD*10.3 Reverse Charges Detail Amount 1 A C X 
CAXDTAMT2 256 BCD*10.3 Reverse Charges Detail Amount 2 A C X 
CAXDTAMT3 257 BCD*10.3 Reverse Charges Detail Amount 3 A C X 
CAXDTAMT4 258 BCD*10.3 Reverse Charges Detail Amount 4 A C X 
CAXDTAMT5 259 BCD*10.3 Reverse Charges Detail Amount 5 A C X 
BILLCURDEC 260 Integer Billing Cur. No. Of Decimals A X