View: Receipt Posting Lines

RotoID: PO0711
Table: PORCPM
Protocol: Detail, Ordered revisions
DLL:PORCPM

Compositions: 7

RotoID Tables Title DLL
PO0701 PORCPI Receipt Postings PORCPI
PO0620 POPORH1POPORH2 Purchase Orders POPORH
PO0630 POPORL Purchase Order Lines POPORL
PO0700 PORCPH1PORCPH2 Receipts PORCPH
PO0710 PORCPL Receipt Lines PORCPL
PO0699 Receipt Functions PORCPG
PO0619 Purchase Order Functions POPORG

Keys: 1

Title Fields
Detail Key RCPISEQ, RCPHSEQ, RCPLSEQ

Fields: 146

Field Index Type Title Attributes Presentation
RCPISEQ 1 BCD*10.0 Header Sequence E A K R 
RCPHSEQ 2 BCD*10.0 Receipt Sequence Key E A K R 
RCPLSEQ 3 BCD*10.0 Receipt Line Sequence E A K R 
OPERATION 4 Integer Operation To Post E A 
ITEMDESC 5 String*60 Item Description E A 
STOCKUNIT 6 String*10 Unit of Measure E A 
RCPUNIT 7 String*10 Unit of Measure E A 
RCPCONV 8 BCD*10.6 Receiving Conversion Factor E A 
RCPDECML 9 Integer Receiving Unit Decimals E A 
RQRECEIVED 10 BCD*10.4 Quantity Received E A 
RQRETURNED 11 BCD*10.4 Quantity Returned E A 
RQCANCELED 12 BCD*10.4 Quantity Canceled E A 
SQRECEIVED 13 BCD*10.4 Stocking Quantity Received E A 
SQCANCELED 14 BCD*10.4 Stocking Quantity Canceled E A 
OQRECEIVED 15 BCD*10.4 Ordered Quantity Received E A 
OQCANCELED 16 BCD*10.4 Ordered Quantity Canceled E A 
UNITCOST 17 BCD*10.6 Unit Cost E A 
EXTENDED 18 BCD*10.3 Extended Cost E A 
UNITWEIGHT 19 BCD*10.4 Unit Weight E A 
EXTWEIGHT 20 BCD*10.3 Extended Weight E A 
RCPDAYS 21 Integer Days to Receive E A 
MPRORATED 22 BCD*10.3 Manual Proration E A 
TAXBASE1 23 BCD*10.3 Tax Base 1 E A 
TAXBASE2 24 BCD*10.3 Tax Base 2 E A 
TAXBASE3 25 BCD*10.3 Tax Base 3 E A 
TAXBASE4 26 BCD*10.3 Tax Base 4 E A 
TAXBASE5 27 BCD*10.3 Tax Base 5 E A 
TAXCLASS1 28 Integer Tax Class 1 E A 
TAXCLASS2 29 Integer Tax Class 2 E A 
TAXCLASS3 30 Integer Tax Class 3 E A 
TAXCLASS4 31 Integer Tax Class 4 E A 
TAXCLASS5 32 Integer Tax Class 5 E A 
TAXRATE1 33 BCD*8.5 Tax Rate 1 E A 
TAXRATE2 34 BCD*8.5 Tax Rate 2 E A 
TAXRATE3 35 BCD*8.5 Tax Rate 3 E A 
TAXRATE4 36 BCD*8.5 Tax Rate 4 E A 
TAXRATE5 37 BCD*8.5 Tax Rate 5 E A 
TAXINCLUD1 38 Integer Tax Includable 1 E A 
TAXINCLUD2 39 Integer Tax Includable 2 E A 
TAXINCLUD3 40 Integer Tax Includable 3 E A 
TAXINCLUD4 41 Integer Tax Includable 4 E A 
TAXINCLUD5 42 Integer Tax Includable 5 E A 
TXBASEALLO 43 BCD*10.3 Net of Tax E A 
TXINCLUDE1 44 BCD*10.3 Included Tax Amount 1 E A 
TXINCLUDE2 45 BCD*10.3 Included Tax Amount 2 E A 
TXINCLUDE3 46 BCD*10.3 Included Tax Amount 3 E A 
TXINCLUDE4 47 BCD*10.3 Included Tax Amount 4 E A 
TXINCLUDE5 48 BCD*10.3 Included Tax Amount 5 E A 
TXRECVAMT1 49 BCD*10.3 Tax Recoverable Amount 1 E A 
TXRECVAMT2 50 BCD*10.3 Tax Recoverable Amount 2 E A 
TXRECVAMT3 51 BCD*10.3 Tax Recoverable Amount 3 E A 
TXRECVAMT4 52 BCD*10.3 Tax Recoverable Amount 4 E A 
TXRECVAMT5 53 BCD*10.3 Tax Recoverable Amount 5 E A 
TXEXPSAMT1 54 BCD*10.3 Tax Expense Amount 1 E A 
TXEXPSAMT2 55 BCD*10.3 Tax Expense Amount 2 E A 
TXEXPSAMT3 56 BCD*10.3 Tax Expense Amount 3 E A 
TXEXPSAMT4 57 BCD*10.3 Tax Expense Amount 4 E A 
TXEXPSAMT5 58 BCD*10.3 Tax Expense Amount 5 E A 
TXALLOAMT1 59 BCD*10.3 Tax Allocated Amount 1 E A 
TXALLOAMT2 60 BCD*10.3 Tax Allocated Amount 2 E A 
TXALLOAMT3 61 BCD*10.3 Tax Allocated Amount 3 E A 
TXALLOAMT4 62 BCD*10.3 Tax Allocated Amount 4 E A 
TXALLOAMT5 63 BCD*10.3 Tax Allocated Amount 5 E A 
TFBASEALLO 64 BCD*10.3 Func. Net of Tax E A 
TFINCLUDE1 65 BCD*10.3 Func. Tax Included Amount 1 E A 
TFINCLUDE2 66 BCD*10.3 Func. Tax Included Amount 2 E A 
TFINCLUDE3 67 BCD*10.3 Func. Tax Included Amount 3 E A 
TFINCLUDE4 68 BCD*10.3 Func. Tax Included Amount 4 E A 
TFINCLUDE5 69 BCD*10.3 Func. Tax Included Amount 5 E A 
TFALLOAMT1 70 BCD*10.3 Func. Tax Allocated Amount 1 E A 
TFALLOAMT2 71 BCD*10.3 Func. Tax Allocated Amount 2 E A 
TFALLOAMT3 72 BCD*10.3 Func. Tax Allocated Amount 3 E A 
TFALLOAMT4 73 BCD*10.3 Func. Tax Allocated Amount 4 E A 
TFALLOAMT5 74 BCD*10.3 Func. Tax Allocated Amount 5 E A 
TFRECVAMT1 75 BCD*10.3 Func. Tax Recoverable Amount 1 E A 
TFRECVAMT2 76 BCD*10.3 Func. Tax Recoverable Amount 2 E A 
TFRECVAMT3 77 BCD*10.3 Func. Tax Recoverable Amount 3 E A 
TFRECVAMT4 78 BCD*10.3 Func. Tax Recoverable Amount 4 E A 
TFRECVAMT5 79 BCD*10.3 Func. Tax Recoverable Amount 5 E A 
TFEXPSAMT1 80 BCD*10.3 Func. Tax Expense Amount 1 E A 
TFEXPSAMT2 81 BCD*10.3 Func. Tax Expense Amount 2 E A 
TFEXPSAMT3 82 BCD*10.3 Func. Tax Expense Amount 3 E A 
TFEXPSAMT4 83 BCD*10.3 Func. Tax Expense Amount 4 E A 
TFEXPSAMT5 84 BCD*10.3 Func. Tax Expense Amount 5 E A 
DISCPCT 85 BCD*5.5 Discount Percentage E A 
DISCOUNT 86 BCD*10.3 Discount Amount E A 
DISCOUNTF 87 BCD*10.3 Func. Discount Amount E A 
BILLRATE 88 BCD*10.6 Billing Rate E A 
RTGPERCENT 89 BCD*5.5 Retainage Percentage E A 
RTGDAYS 90 Integer Retention Period E A 
RTGAMOUNT 91 BCD*10.3 Retainage Amount E A 
RTGAMTOVER 92 Boolean Retainage Amount Overridden E A 
TRINCLUDE1 93 BCD*10.3 Tax Reporting Included Amount 1 E A 
TRINCLUDE2 94 BCD*10.3 Tax Reporting Included Amount 2 E A 
TRINCLUDE3 95 BCD*10.3 Tax Reporting Included Amount 3 E A 
TRINCLUDE4 96 BCD*10.3 Tax Reporting Included Amount 4 E A 
TRINCLUDE5 97 BCD*10.3 Tax Reporting Included Amount 5 E A 
TRRECVAMT1 98 BCD*10.3 Tax Reporting Recoverable Amt. 1 E A 
TRRECVAMT2 99 BCD*10.3 Tax Reporting Recoverable Amt. 2 E A 
TRRECVAMT3 100 BCD*10.3 Tax Reporting Recoverable Amt. 3 E A 
TRRECVAMT4 101 BCD*10.3 Tax Reporting Recoverable Amt. 4 E A 
TRRECVAMT5 102 BCD*10.3 Tax Reporting Recoverable Amt. 5 E A 
TREXPSAMT1 103 BCD*10.3 Tax Reporting Expense Amount 1 E A 
TREXPSAMT2 104 BCD*10.3 Tax Reporting Expense Amount 2 E A 
TREXPSAMT3 105 BCD*10.3 Tax Reporting Expense Amount 3 E A 
TREXPSAMT4 106 BCD*10.3 Tax Reporting Expense Amount 4 E A 
TREXPSAMT5 107 BCD*10.3 Tax Reporting Expense Amount 5 E A 
TRALLOAMT1 108 BCD*10.3 Tax Reporting Allocated Amount 1 E A 
TRALLOAMT2 109 BCD*10.3 Tax Reporting Allocated Amount 2 E A 
TRALLOAMT3 110 BCD*10.3 Tax Reporting Allocated Amount 3 E A 
TRALLOAMT4 111 BCD*10.3 Tax Reporting Allocated Amount 4 E A 
TRALLOAMT5 112 BCD*10.3 Tax Reporting Allocated Amount 5 E A 
RAXBASE1 113 BCD*10.3 Retainage Tax Base 1 E A 
RAXBASE2 114 BCD*10.3 Retainage Tax Base 2 E A 
RAXBASE3 115 BCD*10.3 Retainage Tax Base 3 E A 
RAXBASE4 116 BCD*10.3 Retainage Tax Base 4 E A 
RAXBASE5 117 BCD*10.3 Retainage Tax Base 5 E A 
RXRECVAMT1 118 BCD*10.3 Retainage Tax Recoverable Amt. 1 E A 
RXRECVAMT2 119 BCD*10.3 Retainage Tax Recoverable Amt. 2 E A 
RXRECVAMT3 120 BCD*10.3 Retainage Tax Recoverable Amt. 3 E A 
RXRECVAMT4 121 BCD*10.3 Retainage Tax Recoverable Amt. 4 E A 
RXRECVAMT5 122 BCD*10.3 Retainage Tax Recoverable Amt. 5 E A 
RXEXPSAMT1 123 BCD*10.3 Retainage Tax Expense Amount 1 E A 
RXEXPSAMT2 124 BCD*10.3 Retainage Tax Expense Amount 2 E A 
RXEXPSAMT3 125 BCD*10.3 Retainage Tax Expense Amount 3 E A 
RXEXPSAMT4 126 BCD*10.3 Retainage Tax Expense Amount 4 E A 
RXEXPSAMT5 127 BCD*10.3 Retainage Tax Expense Amount 5 E A 
RXALLOAMT1 128 BCD*10.3 Retainage Tax Allocated Amount 1 E A 
RXALLOAMT2 129 BCD*10.3 Retainage Tax Allocated Amount 2 E A 
RXALLOAMT3 130 BCD*10.3 Retainage Tax Allocated Amount 3 E A 
RXALLOAMT4 131 BCD*10.3 Retainage Tax Allocated Amount 4 E A 
RXALLOAMT5 132 BCD*10.3 Retainage Tax Allocated Amount 5 E A 
WEIGHTUNIT 133 String*10 Weight Unit of Measure E A 
WEIGHTCONV 134 BCD*10.6 Weight Conversion E A 
DEFUWEIGHT 135 BCD*10.4 Default Unit Weight E A 
DEFEXTWGHT 136 BCD*10.4 Default Extended Weight E A 
QTYPOSTED 137 Boolean Is Quantity Posted? E A 
SERIALQTY 138 Long Serial Quantity E A 
LOTQTY 139 BCD*10.4 Lot Quantity E A 
XGENALCQTY 140 BCD*10.4 Serial/Lot Quantity to Process E A C 
XLOTMAKQTY 141 BCD*10.4 Number of Lots to Generate E A C 
XPERLOTQTY 142 BCD*10.4 Quantity per Lot E A C 
SALLOCFROM 143 String*40 Allocate from Serial E A C 
LALLOCFROM 144 String*40 Allocate from Lot E A C 
METERHWND 145 Long Serial/Lot Window Handle E A C 
LAST 146 Boolean Last E A 

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