View: Receipt Lines

RotoID: PO0710
Table: PORCPL
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PORCPL

Compositions: 8

RotoID Tables Title DLL

PO0700 PORCPH1PORCPH2 Receipts PORCPH
PO0695 PORCPC Receipt Comments PORCPC
PO0699 Receipt Functions PORCPG
PO0701 PORCPI Receipt Postings PORCPI
PO0711 PORCPM Receipt Posting Lines PORCPM
PO0717 PORCPLO Receipt Detail Optional Fields PORCPLO
PO0789 PORCPLL Receipt Line Lots PORCPLL
PO0780 PORCPLS Receipt Line Serials PORCPLS

Keys: 6

Title Fields

Detail Key RCPHSEQRCPLREV
Sequence Key RCPHSEQRCPLSEQ
Order Number Key OEONUMBERRCPHSEQRCPLSEQ
Line Sequence Key RCPLSEQ
PO and Receipt Sequence Key PORHSEQPORLSEQRCPHSEQRCPLSEQ
Detail Number RCPHSEQDETAILNUMRCPLSEQ

Fields: 342

Field Index Type Title Attributes Presentation

RCPHSEQ 1 BCD*10.0 Receipt Sequence Key E A K R 
RCPLREV 2 BCD*10.0 Line Number E A K R 
RCPLSEQ 3 BCD*10.0 Receipt Line Sequence E A X 
RCPCSEQ 4 BCD*10.0 Receipt Comment Sequence A X 
OEONUMBER 5 String*22 Order Number A X  Mask: %-22C
INDBTABLE 6 Boolean Stored in Database Table A C X  List:2 entries
0 = No
1 = Yes
POSTEDTOIC 7 Boolean Posted to I/C A C X  List:2 entries
0 = No
1 = Yes
COMPLETION 8 Integer Completion Status A X  List:3 entries
1 = No
2 = Yes
3 = Yes
DTCOMPLETE 9 Date Date Completed A X 
PORHSEQ 10 BCD*10.0 Purchase Order Sequence Key A X 
PORLSEQ 11 BCD*10.0 Purchase Order Line Sequence A X 
POCOMPLETE 12 Boolean Completes PO A X  List:2 entries
0 = No
1 = Yes
ITEMEXISTS 13 Boolean Item Exists A C X  List:2 entries
0 = No
1 = Yes
ITEMNO 14 String*24 Item Number A P X  Mask: %-24C
LOCATION 15 String*6 Location A X  Mask: %-6N
ITEMDESC 16 String*60 Item Description A X 
VENDITEMNO 17 String*24 Vendor Item Number A X 
HASCOMMENT 18 Boolean Comments A X  List:2 entries
0 = No
1 = Yes
ORDERUNIT 19 String*10 Unit of Measure A X  Mask: %-10c
ORDERCONV 20 BCD*10.6 Order Unit Conversion A C X 
ORDERDECML 21 Integer Order Unit Decimals A C X 
RCPUNIT 22 String*10 Unit of Measure A X  Mask: %-10c
RCPCONV 23 BCD*10.6 Receiving Conversion Factor A C X 
RCPDECML 24 Integer Receiving Unit Decimals A C X 
STOCKDECML 25 Integer Stock Unit Decimals A C X 
OQORDERED 26 BCD*10.4 Ordered Quantity Ordered A C X 
OQPREVRECV 27 BCD*10.4 Ordered Previously Received A C X 
OQOUTSTPO 28 BCD*10.4 Ordered Outstanding on PO A C X 
RQRECEIVED 29 BCD*10.4 Quantity Received A X 
RQCANCELED 30 BCD*10.4 Quantity Canceled A X 
RQOUTSTAND 31 BCD*10.4 Quantity Outstanding A X 
SQORDERED 32 BCD*10.4 Stocking Quantity Ordered A C X 
SQPREVRECV 33 BCD*10.4 Stocking Previously Received A C X 
SQOUTSTPO 34 BCD*10.4 Stocking Outstanding on PO A C X 
RQORDERED 35 BCD*10.4 Quantity Ordered A C X 
RQPREVRECV 36 BCD*10.4 Received to Date A C X 
RQOUTSTPO 37 BCD*10.4 Quantity Outstanding A C X 
RQRCPEXTRA 38 BCD*10.4 Receiving Qty. Received Extra A C X 
SQRECEIVED 39 BCD*10.4 Stocking Quantity Received A C X 
SQCANCELED 40 BCD*10.4 Stocking Quantity Canceled A C X 
SQOUTSTAND 41 BCD*10.4 Stocking Quantity Outstanding A C X 
SQRCPEXTRA 42 BCD*10.4 Stocking Quantity Received Extra A C X 
OQRECEIVED 43 BCD*10.4 Ordered Quantity Received A C X 
OQCANCELED 44 BCD*10.4 Ordered Quantity Canceled A C X 
OQOUTSTAND 45 BCD*10.4 Ordered Quantity Outstanding A C X 
OQRCPEXTRA 46 BCD*10.4 Received Extra A C X 
RQRETURNED 47 BCD*10.4 Quantity Returned A X 
SQRETURNED 48 BCD*10.4 Stocking Quantity Returned A C X 
OQRETURNED 49 BCD*10.4 Ordered Quantity Returned A C X 
RQSTOCKED 50 BCD*10.4 Quantity Stocked A X 
SQSTOCKED 51 BCD*10.4 Stocking Quantity Stocked A C X 
OQSTOCKED 52 BCD*10.4 Ordered Quantity Stocked A C X 
RQINADJUST 53 BCD*10.4 Quantity Adjusted by Invoice A X 
SQINADJUST 54 BCD*10.4 Stocking Qty. Adj. by Invoice A C X 
OQINADJUST 55 BCD*10.4 Ordered Quantity Adj. by Invoice A C X 
RQPOFILLED 56 BCD*10.4 Quantity Filled on PO A X 
SQPOFILLED 57 BCD*10.4 Stocking Quantity Filled on PO A C X 
OQPOFILLED 58 BCD*10.4 Ordered Quantity Filled on PO A C X 
RQSETTLED 59 BCD*10.4 Quantity Settled A C X 
SQSETTLED 60 BCD*10.4 Stocking Quantity Settled A C X 
OQSETTLED 61 BCD*10.4 Ordered Quantity Settled A C X 
RQUSTOCKED 62 BCD*10.4 Quantity Unstocked A X 
SQUSTOCKED 63 BCD*10.4 Stocking Quantity Unstocked A C X 
OQUSTOCKED 64 BCD*10.4 Ordered Quantity Unstocked A C X 
UNITWEIGHT 65 BCD*10.4 Unit Weight A X 
EXTWEIGHT 66 BCD*10.4 Extended Weight A X 
UNITCOST 67 BCD*10.6 Unit Cost A X 
EXTENDED 68 BCD*10.3 Extended Cost A X 
TAXBASE1 69 BCD*10.3 Tax Base 1 A X 
TAXBASE2 70 BCD*10.3 Tax Base 2 A X 
TAXBASE3 71 BCD*10.3 Tax Base 3 A X 
TAXBASE4 72 BCD*10.3 Tax Base 4 A X 
TAXBASE5 73 BCD*10.3 Tax Base 5 A X 
TAXCLASS1 74 Integer Tax Class 1 A X 
TAXCLASS2 75 Integer Tax Class 2 A X 
TAXCLASS3 76 Integer Tax Class 3 A X 
TAXCLASS4 77 Integer Tax Class 4 A X 
TAXCLASS5 78 Integer Tax Class 5 A X 
TAXRATE1 79 BCD*8.5 Tax Rate 1 A X 
TAXRATE2 80 BCD*8.5 Tax Rate 2 A X 
TAXRATE3 81 BCD*8.5 Tax Rate 3 A X 
TAXRATE4 82 BCD*8.5 Tax Rate 4 A X 
TAXRATE5 83 BCD*8.5 Tax Rate 5 A X 
TAXINCLUD1 84 Boolean Tax Includable 1 A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD2 85 Boolean Tax Includable 2 A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD3 86 Boolean Tax Includable 3 A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD4 87 Boolean Tax Includable 4 A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD5 88 Boolean Tax Includable 5 A X  List:2 entries
0 = No
1 = Yes
TAXAMOUNT1 89 BCD*10.3 Tax Amount 1 A X 
TAXAMOUNT2 90 BCD*10.3 Tax Amount 2 A X 
TAXAMOUNT3 91 BCD*10.3 Tax Amount 3 A X 
TAXAMOUNT4 92 BCD*10.3 Tax Amount 4 A X 
TAXAMOUNT5 93 BCD*10.3 Tax Amount 5 A X 
TXRECVAMT1 94 BCD*10.3 Tax Recoverable Amount 1 A X 
TXRECVAMT2 95 BCD*10.3 Tax Recoverable Amount 2 A X 
TXRECVAMT3 96 BCD*10.3 Tax Recoverable Amount 3 A X 
TXRECVAMT4 97 BCD*10.3 Tax Recoverable Amount 4 A X 
TXRECVAMT5 98 BCD*10.3 Tax Recoverable Amount 5 A X 
TXEXPSAMT1 99 BCD*10.3 Tax Expense Amount 1 A X 
TXEXPSAMT2 100 BCD*10.3 Tax Expense Amount 2 A X 
TXEXPSAMT3 101 BCD*10.3 Tax Expense Amount 3 A X 
TXEXPSAMT4 102 BCD*10.3 Tax Expense Amount 4 A X 
TXEXPSAMT5 103 BCD*10.3 Tax Expense Amount 5 A X 
TXALLOAMT1 104 BCD*10.3 Tax Allocated Amount 1 A X 
TXALLOAMT2 105 BCD*10.3 Tax Allocated Amount 2 A X 
TXALLOAMT3 106 BCD*10.3 Tax Allocated Amount 3 A X 
TXALLOAMT4 107 BCD*10.3 Tax Allocated Amount 4 A X 
TXALLOAMT5 108 BCD*10.3 Tax Allocated Amount 5 A X 
TXBASEALLO 109 BCD*10.3 Net of Tax A X 
TXINCLUDED 110 BCD*10.3 Tax Included A C X 
TXEXCLUDED 111 BCD*10.3 Tax Excluded A C X 
TAXAMOUNT 112 BCD*10.3 Total Tax A C X 
TXRECVAMT 113 BCD*10.3 Recoverable Tax A X 
TXEXPSAMT 114 BCD*10.3 Expensed Tax A X 
TXALLOAMT 115 BCD*10.3 Allocated Tax A X 
TFBASEALLO 116 BCD*10.3 Func. Net of Tax A C X 
TFINCLUDE1 117 BCD*10.3 Func. Tax Included Amount 1 A C X 
TFINCLUDE2 118 BCD*10.3 Func. Tax Included Amount 2 A C X 
TFINCLUDE3 119 BCD*10.3 Func. Tax Included Amount 3 A C X 
TFINCLUDE4 120 BCD*10.3 Func. Tax Included Amount 4 A C X 
TFINCLUDE5 121 BCD*10.3 Func. Tax Included Amount 5 A C X 
TFALLOAMT1 122 BCD*10.3 Func. Tax Allocated Amount 1 A C X 
TFALLOAMT2 123 BCD*10.3 Func. Tax Allocated Amount 2 A C X 
TFALLOAMT3 124 BCD*10.3 Func. Tax Allocated Amount 3 A C X 
TFALLOAMT4 125 BCD*10.3 Func. Tax Allocated Amount 4 A C X 
TFALLOAMT5 126 BCD*10.3 Func. Tax Allocated Amount 5 A C X 
TFRECVAMT1 127 BCD*10.3 Func. Tax Recoverable Amount 1 A C X 
TFRECVAMT2 128 BCD*10.3 Func. Tax Recoverable Amount 2 A C X 
TFRECVAMT3 129 BCD*10.3 Func. Tax Recoverable Amount 3 A C X 
TFRECVAMT4 130 BCD*10.3 Func. Tax Recoverable Amount 4 A C X 
TFRECVAMT5 131 BCD*10.3 Func. Tax Recoverable Amount 5 A C X 
TFEXPSAMT1 132 BCD*10.3 Func. Tax Expense Amount 1 A C X 
TFEXPSAMT2 133 BCD*10.3 Func. Tax Expense Amount 2 A C X 
TFEXPSAMT3 134 BCD*10.3 Func. Tax Expense Amount 3 A C X 
TFEXPSAMT4 135 BCD*10.3 Func. Tax Expense Amount 4 A C X 
TFEXPSAMT5 136 BCD*10.3 Func. Tax Expense Amount 5 A C X 
GLACEXPENS 137 String*45 Expense Account A X  Mask: %-45C
DTARRIVAL 138 Date Arrival Date A X 
LABELCOUNT 139 Integer Number of Labels A X 
MPRORATED 140 BCD*10.3 Manual Proration A X 
HASDROPSHI 141 Boolean Drop-Ship A X  List:2 entries
0 = No
1 = Yes
DROPTYPE 142 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 143 String*12 Drop-Ship Customer A X  Mask: %-12C
IDCUSTSHPT 144 String*6 Customer Ship-To Address A X  Mask: %-6C
DLOCATION 145 String*6 Drop-Ship Location A X  Mask: %-6N
DESC 146 String*60 Drop-Ship Description A X 
ADDRESS1 147 String*60 Drop-Ship Address 1 A X 
ADDRESS2 148 String*60 Drop-Ship Address 2 A X 
ADDRESS3 149 String*60 Drop-Ship Address 3 A X 
ADDRESS4 150 String*60 Drop-Ship Address 4 A X 
CITY 151 String*30 Drop-Ship City A X 
STATE 152 String*30 Drop-Ship State/Province A X 
ZIP 153 String*20 Drop-Ship Zip/Postal Code A X 
COUNTRY 154 String*30 Drop-Ship Country A X 
PHONE 155 String*30 Drop-Ship Phone Number A X  Mask: (%-3C) %-3C-%-24C
FAX 156 String*30 Drop-Ship Fax Number A X  Mask: (%-3C) %-3C-%-24C
CONTACT 157 String*60 Drop-Ship Contact A X 
STOCKITEM 158 Boolean Stock Item A C X  List:2 entries
0 = No
1 = Yes
PONUMBER 159 String*22 Purchase Order Number A X  Mask: %-22C
TAXCLASS1D 161 String*60 Tax Class 1 Description A C X 
TAXCLASS2D 162 String*60 Tax Class 2 Description A C X 
TAXCLASS3D 163 String*60 Tax Class 3 Description A C X 
TAXCLASS4D 164 String*60 Tax Class 4 Description A C X 
TAXCLASS5D 165 String*60 Tax Class 5 Description A C X 
GLACEXPNSD 166 String*60 Expense Account Description A C X 
TXINCLUDE1 167 BCD*10.3 Included Tax Amount 1 A X 
TXINCLUDE2 168 BCD*10.3 Included Tax Amount 2 A X 
TXINCLUDE3 169 BCD*10.3 Included Tax Amount 3 A X 
TXINCLUDE4 170 BCD*10.3 Included Tax Amount 4 A X 
TXINCLUDE5 171 BCD*10.3 Included Tax Amount 5 A X 
TXEXCLUDE1 172 BCD*10.3 Excluded Tax Amount 1 A X 
TXEXCLUDE2 173 BCD*10.3 Excluded Tax Amount 2 A X 
TXEXCLUDE3 174 BCD*10.3 Excluded Tax Amount 3 A X 
TXEXCLUDE4 175 BCD*10.3 Excluded Tax Amount 4 A X 
TXEXCLUDE5 176 BCD*10.3 Excluded Tax Amount 5 A X 
ISCOMPLETE 177 Boolean Completed A X  List:2 entries
0 = No
1 = Yes
EXTRANEOUS 178 Long Extraneous Line Count A X 
TAXLINE 179 Long Lines Tax Calculation Sees A X 
LINEPRORAT 180 Long Number of Lines Prorated A X 
LINECMPL 181 Long Lines Complete A X 
LINE 182 Long Line A X 
EXSTDCOST 183 BCD*10.3 Extended Std. Cost in Src Curr A C X 
EXMRCOST 184 BCD*10.3 Extended MR Cost in Src Curr A C X 
EXALT1COST 185 BCD*10.3 Extended Cost 1 in Src Curr A C X 
EXALT2COST 186 BCD*10.3 Extended Cost 2 in Src Curr A C X 
EMAIL 187 String*50 Drop-Ship E-mail A X 
PHONEC 188 String*30 Drop-Ship Contact Phone A X  Mask: (%-3C) %-3C-%-24C
FAXC 189 String*30 Drop-Ship Contact Fax A X  Mask: (%-3C) %-3C-%-24C
EMAILC 190 String*50 Drop-Ship Contact E-mail A X 
GLNONSTKCR 191 String*45 Non-Stock Clearing Account A X  Mask: %-45C
GLNONSTKCD 192 String*60 Non-Stock Clearing Account Desc. A C X 
IPCID 193 Long Inter-process Comm. ID A X 
FORCEPOPSN 194 Boolean Force Pop-up SN A X  List:2 entries
0 = No
1 = Yes
POPUPSN 195 Integer Pop-up SN A X  List:3 entries
0 = No
1 = Pop Up S/N Entry
2 = Pop Up Auto Receive
CLOSESN 196 Boolean Close SN A X  List:2 entries
0 = No
1 = Yes
LTSETID 197 Long LT Set ID A X 
FORCEPOPLT 198 Boolean Force Pop-up LT A X  List:2 entries
0 = No
1 = Yes
POPUPLT 199 Integer Pop-up LT A X  List:2 entries
0 = No
1 = Yes
CLOSELT 200 Boolean Close LT A X  List:2 entries
0 = No
1 = Yes
MANITEMNO 201 String*24 Manufacturer's Item Number A X  Mask: %-24C
MAPMANITEM 202 Boolean Map Manufacturer's Item Number E A  List:2 entries
0 = No
1 = Yes
DISCPCT 203 BCD*5.5 Discount Percentage A X 
DISCOUNT 204 BCD*10.3 Discount Amount A X 
DISCOUNTF 205 BCD*10.3 Func. Discount Amount A X 
NETXTENDED 206 BCD*10.3 Net Extended Cost A X 
XIRQRECEVD 207 BCD*10.4 Part. Inv. Pv. Qty. Invoicied. A X 
XIEXTWGHT 208 BCD*10.4 Part. Inv. Pv. Ext. Wgt. Invcd. A X 
XINETXTEND 209 BCD*10.3 Part. Inv. Pv. Net Cost Invoiced A X 
INVLINES 210 Long Invoice Lines A X 
VALUES 211 Long Optional Fields A C X 
PORLREV 212 BCD*10.0 Line Number A C X 
PROCESSCMD 213 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
CONTRACT 214 String*16 Contract A X  Mask: %-16C
PROJECT 215 String*16 Project A X  Mask: %-16N
CCATEGORY 216 String*16 (Cost) Category A X  Mask: %-16N
COSTCLASS 217 Integer Cost Class A C X  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
BILLTYPE 218 Integer Billing Type A P X  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLRATE 219 BCD*10.6 Billing Rate A X 
BILLCURR 220 String*3 Billing Currency A C X  Mask: %-3N
ARITEMNO 221 String*16 A/R Item Number A X  Mask: %-16C
ARUNIT 222 String*10 A/R Unit of Measure A X  Mask: %-10C
RTGPERCENT 223 BCD*5.5 Retainage Percentage A X 
RTGDAYS 224 Integer Retention Period A X 
RTGAMOUNT 225 BCD*10.3 Retainage Amount A X 
RTGAMTOVER 226 Boolean Retainage Amount Overridden A C X  List:2 entries
0 = No
1 = Yes
BILLLINE 227 Long Billable Line A X 
CONTSTYLE 228 Integer Project Style A C X  List:3 entries
0 =
1 = Standard
2 = Basic
PROJTYPE 229 Integer Project Type A C X  List:4 entries
0 =
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC 230 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 231 String*16 Unformatted Contract Code A C X  Mask: %-16C
TARAMOUNT1 232 BCD*10.3 Tax Reporting Amount 1 A X 
TARAMOUNT2 233 BCD*10.3 Tax Reporting Amount 2 A X 
TARAMOUNT3 234 BCD*10.3 Tax Reporting Amount 3 A X 
TARAMOUNT4 235 BCD*10.3 Tax Reporting Amount 4 A X 
TARAMOUNT5 236 BCD*10.3 Tax Reporting Amount 5 A X 
TRALLOAMT1 237 BCD*10.3 Tax Reporting Allocated Amount 1 A X 
TRALLOAMT2 238 BCD*10.3 Tax Reporting Allocated Amount 2 A X 
TRALLOAMT3 239 BCD*10.3 Tax Reporting Allocated Amount 3 A X 
TRALLOAMT4 240 BCD*10.3 Tax Reporting Allocated Amount 4 A X 
TRALLOAMT5 241 BCD*10.3 Tax Reporting Allocated Amount 5 A X 
TRRECVAMT1 242 BCD*10.3 Tax Reporting Recoverable Amt. 1 A X 
TRRECVAMT2 243 BCD*10.3 Tax Reporting Recoverable Amt. 2 A X 
TRRECVAMT3 244 BCD*10.3 Tax Reporting Recoverable Amt. 3 A X 
TRRECVAMT4 245 BCD*10.3 Tax Reporting Recoverable Amt. 4 A X 
TRRECVAMT5 246 BCD*10.3 Tax Reporting Recoverable Amt. 5 A X 
TREXPSAMT1 247 BCD*10.3 Tax Reporting Expense Amount 1 A X 
TREXPSAMT2 248 BCD*10.3 Tax Reporting Expense Amount 2 A X 
TREXPSAMT3 249 BCD*10.3 Tax Reporting Expense Amount 3 A X 
TREXPSAMT4 250 BCD*10.3 Tax Reporting Expense Amount 4 A X 
TREXPSAMT5 251 BCD*10.3 Tax Reporting Expense Amount 5 A X 
TRINCLUDE1 252 BCD*10.3 Tax Reporting Included Amount 1 A X 
TRINCLUDE2 253 BCD*10.3 Tax Reporting Included Amount 2 A X 
TRINCLUDE3 254 BCD*10.3 Tax Reporting Included Amount 3 A X 
TRINCLUDE4 255 BCD*10.3 Tax Reporting Included Amount 4 A X 
TRINCLUDE5 256 BCD*10.3 Tax Reporting Included Amount 5 A X 
TREXCLUDE1 257 BCD*10.3 Tax Reporting Excluded Amount 1 A X 
TREXCLUDE2 258 BCD*10.3 Tax Reporting Excluded Amount 2 A X 
TREXCLUDE3 259 BCD*10.3 Tax Reporting Excluded Amount 3 A X 
TREXCLUDE4 260 BCD*10.3 Tax Reporting Excluded Amount 4 A X 
TREXCLUDE5 261 BCD*10.3 Tax Reporting Excluded Amount 5 A X 
TARAMOUNT 262 BCD*10.3 Tax Reporting Total Amount A X 
TRINCLUDED 263 BCD*10.3 Tax Reporting Included Amount A X 
TREXCLUDED 264 BCD*10.3 Tax Reporting Excluded Amount A X 
TRRECVAMT 265 BCD*10.3 Tax Reporting Recoverable Amount A X 
TREXPSAMT 266 BCD*10.3 Tax Reporting Expensed Amount A X 
TRALLOAMT 267 BCD*10.3 Tax Reporting Allocated Amount A X 
RAXBASE1 268 BCD*10.3 Retainage Tax Base 1 A X 
RAXBASE2 269 BCD*10.3 Retainage Tax Base 2 A X 
RAXBASE3 270 BCD*10.3 Retainage Tax Base 3 A X 
RAXBASE4 271 BCD*10.3 Retainage Tax Base 4 A X 
RAXBASE5 272 BCD*10.3 Retainage Tax Base 5 A X 
RAXAMOUNT1 273 BCD*10.3 Retainage Tax Amount 1 A X 
RAXAMOUNT2 274 BCD*10.3 Retainage Tax Amount 2 A X 
RAXAMOUNT3 275 BCD*10.3 Retainage Tax Amount 3 A X 
RAXAMOUNT4 276 BCD*10.3 Retainage Tax Amount 4 A X 
RAXAMOUNT5 277 BCD*10.3 Retainage Tax Amount 5 A X 
RXRECVAMT1 278 BCD*10.3 Retainage Tax Recoverable Amt. 1 A X 
RXRECVAMT2 279 BCD*10.3 Retainage Tax Recoverable Amt. 2 A X 
RXRECVAMT3 280 BCD*10.3 Retainage Tax Recoverable Amt. 3 A X 
RXRECVAMT4 281 BCD*10.3 Retainage Tax Recoverable Amt. 4 A X 
RXRECVAMT5 282 BCD*10.3 Retainage Tax Recoverable Amt. 5 A X 
RXEXPSAMT1 283 BCD*10.3 Retainage Tax Expense Amount 1 A X 
RXEXPSAMT2 284 BCD*10.3 Retainage Tax Expense Amount 2 A X 
RXEXPSAMT3 285 BCD*10.3 Retainage Tax Expense Amount 3 A X 
RXEXPSAMT4 286 BCD*10.3 Retainage Tax Expense Amount 4 A X 
RXEXPSAMT5 287 BCD*10.3 Retainage Tax Expense Amount 5 A X 
RXALLOAMT1 288 BCD*10.3 Retainage Tax Allocated Amount 1 A X 
RXALLOAMT2 289 BCD*10.3 Retainage Tax Allocated Amount 2 A X 
RXALLOAMT3 290 BCD*10.3 Retainage Tax Allocated Amount 3 A X 
RXALLOAMT4 291 BCD*10.3 Retainage Tax Allocated Amount 4 A X 
RXALLOAMT5 292 BCD*10.3 Retainage Tax Allocated Amount 5 A X 
RAXAMOUNT 293 BCD*10.3 Retainage Tax Total Amount A X 
TXRXAMT1 294 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 1 A X 
TXRXAMT2 295 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 2 A X 
TXRXAMT3 296 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 3 A X 
TXRXAMT4 297 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 4 A X 
TXRXAMT5 298 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 5 A X 
UCISMANUAL 299 Boolean Unit Cost is Manual A X  List:2 entries
0 = No
1 = Yes
WEIGHTUNIT 300 String*10 Weight Unit of Measure A X 
WEIGHTCONV 301 BCD*10.6 Weight Conversion A C X 
DEFUWEIGHT 302 BCD*10.4 Default Unit Weight A C X 
DEFEXTWGHT 303 BCD*10.4 Default Extended Weight A C X 
XIDEFEXTWT 304 BCD*10.4 Part. Inv. Pv. Def. Ext. W. Inv. A C X 
BILLRATECV 305 BCD*10.6 Billing Rate Conversion Factor A C X 
UNITBILLSR 306 BCD*10.6 Unit Billing Amount A C X 
EXTBILLSR 307 BCD*10.3 Extended Billing Amount A X 
FASDETAIL 308 Boolean Fixed Asset A X  List:2 entries
0 = No
1 = Yes
FASCREATED 309 Boolean Asset Created A X  List:2 entries
0 = No
1 = Yes
FASDB 310 String*32 Sage Fixed Assets Database A X 
FASCMP 311 String*32 Sage Fixed Assets Company/Org. A X 
FASTMPL 312 String*25 Sage Fixed Assets Template A X 
TEXTDESC 313 String*80 Sage Fixed Assets Asset Description A X 
SEPQTY 314 Boolean Separate Assets A X  List:2 entries
0 = No
1 = Yes
FASQTY 315 BCD*10.5 Sage Fixed Assets Quantity A X 
UOM 316 String*10 Sage Fixed Assets Unit of Measure A X 
AMTSC 317 BCD*10.3 Sage Fixed Assets Asset Value A X 
SERIALQTY 318 Long Serial Quantity A C X 
LOTQTY 319 BCD*10.4 Lot Quantity A C X 
SLITEM 320 Integer Item Serialized/Lotted? A C P X  List:4 entries
0 = None
1 = Serialized
2 = Lotted
3 = Both
XGENALCQTY 321 BCD*10.4 Serial/Lot Quantity to Process A C X 
XLOTMAKQTY 322 BCD*10.4 Number of Lots to Generate A C X 
XPERLOTQTY 323 BCD*10.4 Quantity per Lot A C X 
SALLOCFROM 324 String*40 Allocate from Serial A C X 
LALLOCFROM 325 String*40 Allocate from Lot A C X 
METERHWND 326 Long Serial/Lot Window Handle A C X 
DETAILNUM 327 Integer Detail Number A C X 
CAXABLE1 328 Boolean Reverse Chargeable 1 A C X  List:2 entries
0 = No
1 = Yes
CAXABLE2 329 Boolean Reverse Chargeable 2 A C X  List:2 entries
0 = No
1 = Yes
CAXABLE3 330 Boolean Reverse Chargeable 3 A C X  List:2 entries
0 = No
1 = Yes
CAXABLE4 331 Boolean Reverse Chargeable 4 A C X  List:2 entries
0 = No
1 = Yes
CAXABLE5 332 Boolean Reverse Chargeable 5 A C X  List:2 entries
0 = No
1 = Yes
CAXBASE1 333 BCD*10.3 Reverse Charges Base 1 A C X 
CAXBASE2 334 BCD*10.3 Reverse Charges Base 2 A C X 
CAXBASE3 335 BCD*10.3 Reverse Charges Base 3 A C X 
CAXBASE4 336 BCD*10.3 Reverse Charges Base 4 A C X 
CAXBASE5 337 BCD*10.3 Reverse Charges Base 5 A C X 
CAXDTAMT1 338 BCD*10.3 Reverse Charges Detail Amount 1 A C X 
CAXDTAMT2 339 BCD*10.3 Reverse Charges Detail Amount 2 A C X 
CAXDTAMT3 340 BCD*10.3 Reverse Charges Detail Amount 3 A C X 
CAXDTAMT4 341 BCD*10.3 Reverse Charges Detail Amount 4 A C X 
CAXDTAMT5 342 BCD*10.3 Reverse Charges Detail Amount 5 A C X 
BILLCURDEC 343 Integer Billing Cur. No. Of Decimals A X