(Applies to FieldByID and FieldByName methods of the IRdaDocument object.)
Departments
RDA2 Constant ID# Name Type Size Caption Description
fidDC1 50 fldDept String 1 Dept Department
fidClass 51 fldClass String 1 Class Class
fidSubClass 52 fldSubClass String 1 Subclass Subclass
fidDC 2 fldDCS String 9 DCS Full Department Code
fidTax 49 fldTaxCd Enumerated 0 Tax Tax Code
fidCoeff 115 fldCoeff Double 0 Coef Coefficient
fidQuantityDecimals 200 fldDecimals Boolean 0 Qty Decimals Quantity Decimals fidAllocPttrn 201 fldAllocPttrn String 20 Alloc Pattern Allocation Pattern fidDeptName 3 fldDCSName String 30 DCS Name Full Department Name fidMrgP 13 fldDefMgnPrc Integer 0 Mrg% Default Margin % fidMupP 104 fldDefMkUpPrc Integer 0 MkUp% Default Mark Up % fidDeptPicture 209 fldDeptPicture String 20 Department Image Department Image fidDeptName10 29 fldDeptName String 10 Dept Name Department Name fidClassName10 30 fldClassName String 10 Class Name Class Name fidSubClassName10 31 fldSubClassName String 10 Sub-class Name Sub-class Name
Customers
RDA2 Constant ID# Name Type Size Caption Description
fidCustID 236 fldCustID Integer 0 Cust ID Customer ID fidCustCompany 210 fldCompany String 25 Company Company Name fidCustTitle 211 fldTitle String 15 Title Title fidCustFName 212 fldFName String 30 First First Name
fidCustLName 213 fldLName String 30 Last Last Name fidCustAddr1 214 fldAddr1 String 31 Address 1 Address 1
fidCustAddr2 215 fldAddr2 String 31 Address 2 Address 2 fidCustAddr3 216 fldAddr3 String 31 Address 3 Address 3
fidCustZIP 217 fldZIP String 10 ZIP ZIP Code fidCustPhone1 218 fldPhone1 String 15 Phone 1 Telephone 1
fidCustPhone2 219 fldPhone2 String 15 Phone 2 Telephone 2 fidCustInfo1 221 fldInfo1 String 20 Info 1 Information 1
fidCustInfo2 222 fldInfo2 String 20 Info 2 Information 2 fidCustShare 238 fldShare Enumerated 0 Share Sharing Status
fidCustAR 239 fldCliAR Enumerated 0 AR Accounts Receivable fidCustAcptChks 240 fldAccChk Boolean 0 Checks Accept Checks
fidCustStoreCr 241 fldStCred Double 0 Store Credit Store Credit fidCustCredLim 242 fldCredLim Double 0 Chrg Limit Charge Limit fidCustCredUsed 243 fldCredUsed Double 0 Chrg Bal Charge Balance fidCustLastSale 244 fldLastSale Date 0 Last Sale Last Sale Date fidCustUDF0 224 fldCntUDF0 Date 0 UDF 1 User-Defined Field 1 -None- 225 fldCntUDF1 Date 0 UDF 2 User-Defined Field 2 -None- 226 fldCntUDF2 String 20 UDF 3 User-Defined Field 3 -None- 227 fldCntUDF3 String 20 UDF 4 User-Defined Field 4 -None- 228 fldCntUDF4 String 20 UDF 5 User-Defined Field 5 -None- 229 fldCntUDF5 String 20 UDF 6 User-Defined Field 6 -None- 230 fldCntUDF6 String 20 UDF 7 User-Defined Field 7 fidCustUDF7 231 fldCntUDF7 String 20 UDF 8 User-Defined Field 8 fidCustSearchPhone 220 fldSrchPhone String 15 Phone Telephone fidCustSearchInfo 223 fldSrchInfo String 20 Info Information
RDA2 Constant ID# Name Type Size Caption Description
fidCustSID 245 fldCustSID Int64 0 Customer SID Customer System ID fidStoreStation 563 fldStoreStatn String 4 Str/Sta Store and Station fidPrcLvl 107 fldPrcLvl Enumerated 0 Prc Lvl Price Level fidCustMark1 248 fldCustMark1 String 4 Mark 1 Mark 1 fidCustMark2 249 fldCustMark2 String 4 Mark 2 Mark 2 fidCustSrchMark 250 fldCustSrchMark String 4 Mark Mark fidCustDetax 251 fldCustDetax Boolean 0 Export Export fidFullName 235 fldFullName String 0 Full Name Full Name fidCustInactive 270 fldCustInactive Boolean 0 Inactive Inactive fidCustAux0 280 fldCustAux0 Enumerated 0 Aux 1 Auxiliary field 1 -None- 281 fldCustAux1 Enumerated 0 Aux 2 Auxiliary field 2 -None- 282 fldCustAux2 Enumerated 0 Aux 3 Auxiliary field 3 -None- 283 fldCustAux3 Enumerated 0 Aux 4 Auxiliary field 4 -None- 284 fldCustAux4 Enumerated 0 Aux 5 Auxiliary field 5 -None- 285 fldCustAux5 Enumerated 0 Aux 6 Auxiliary field 6 -None- 286 fldCustAux6 Enumerated 0 Aux 7 Auxiliary field 7 -None- 287 fldCustAux7 Enumerated 0 Aux 8 Auxiliary field 8 -None- 288 fldCustAux8 Enumerated 0 Aux 9 Auxiliary field 9 -None- 289 fldCustAux9 Enumerated 0 Aux 10 Auxiliary field 10 -None- 290 fldCustAux10 Enumerated 0 Aux 11 Auxiliary field 11 fidCustAux11 291 fldCustAux11 Enumerated 0 Aux 12 Auxiliary field 12 fidCustDiscPercentAlw
d 292 fldCustDiscPercentAlwd Double 0 Customer Disc % Customer discount percent fidCustSysDate 293 fldCustSysDate Date 0 Customer System Date Customer System Date fidCustNotes 232 fldCustNotes String 245 Cust.Notes Cust.Notes
fidEMail 237 fldEMail String 60 E-Mail E-Mail address fidTaxArea2 7005 fldTaxArea2 String 11 Tax Area 2 Tax Area 2
fidCustMarkedForDele
Vendors
RDA2 Constant ID# Name Type Size Caption Description
fidVndrCompany 210 fldCompany String 25 Company Company Name fidVndrTitle 211 fldTitle String 15 Title Title
fidVndrFName 212 fldFName String 30 First First Name fidVndrLName 213 fldLName String 30 Last Last Name
fidVndrAddr1 214 fldAddr1 String 31 Address 1 Address 1 fidVndrAddr2 215 fldAddr2 String 31 Address 2 Address 2 fidVndrAddr3 216 fldAddr3 String 31 Address 3 Address 3 fidVndrZIP 217 fldZIP String 10 ZIP ZIP Code fidVndrPhone1 218 fldPhone1 String 15 Phone 1 Telephone 1 fidVndrPhone2 219 fldPhone2 String 15 Phone 2 Telephone 2
fidVndrInfo1 221 fldInfo1 String 20 Info 1 Information 1 fidVndrInfo2 222 fldInfo2 String 20 Info 2 Information 2
fidVndrNotes 232 fldNotes String 245 Vendor Notes Vendor Notes fidVndrAccNum 233 fldAccNum String 10 Acct # Account Number
fidVndrAP 234 fldVndAP Enumerated 0 AP Accounts Payable fidVndrUDF0 224 fldCntUDF0 Date 0 UDF 1 User-Defined Field 1 -None- 225 fldCntUDF1 Date 0 UDF 2 User-Defined Field 2 -None- 226 fldCntUDF2 String 20 UDF 3 User-Defined Field 3 -None- 227 fldCntUDF3 String 20 UDF 4 User-Defined Field 4 -None- 228 fldCntUDF4 String 20 UDF 5 User-Defined Field 5 -None- 229 fldCntUDF5 String 20 UDF 6 User-Defined Field 6 -None- 230 fldCntUDF6 String 20 UDF 7 User-Defined Field 7 fidVndrUDF7 231 fldCntUDF7 String 20 UDF 8 User-Defined Field 8 fidVndrSearchPhone 220 fldSrchPhone String 15 Phone Telephone
fidVndrSearchInfo 223 fldSrchInfo String 20 Info Information fidVC 4 fldVendorCode String 3 Vend Code Vendor Code
fidVouPaid 516 fldVouTerms String 0 Terms Payment Terms fidVndrPicture 246 fldVendorPicture String 20 Vendor Image Vendor Image
fidTradeDiscPercent 194 fldTradeDiscPercent Double 0 Trade Discount % Trade Discount % fidEMail 237 fldEMail String 60 E-Mail E-Mail address
Items
RDA2 Constant ID# Name Type Size Caption Description
fidDC 2 fldDCS String 9 DCS Full Department Code fidVC 4 fldVendorCode String 3 Vend Code Vendor Code
fidDesc1 5 fldDesc1 String 16 Desc 1 Description 1 fidDesc2 8 fldDesc2 String 17 Desc 2 Description 2
fidAttr 6 fldAttr String 4 Attr Attribute fidSIZE 7 fldSize String 4 Size Size
fidUPC 9 fldUPC String 13 UPC UPC fidALU 166 fldALU String 20 ALU Alternate Look Up fidUsrCd0 146 fldUDF0 Enumerated 0 UDF 1 User-Defined Field 1 fidUsrCd1 163 fldUDF1 Enumerated 0 UDF 2 User-Defined Field 2 fidUsrCd2 164 fldUDF2 Enumerated 0 UDF 3 User-Defined Field 3 fidUsrCd3 165 fldUDF3 Enumerated 0 UDF 4 User-Defined Field 4 fidCommCod 181 fldCommCod Integer 0 Comm Code Commission Code fidSPIF 182 fldSPIF Double 0 SPIF Sales Person Incentive Fee fidTax 49 fldTaxCd Enumerated 0 Tax Tax Code fidInvenFlag 127 fldFlag Enumerated 0 Flag Inventory Flag
fidEDIStatus 109 fldEDI Enumerated 0 EDI EDI Status fidPromoPrc 145 fldPlnPrc Boolean 0 Plan Price Planned Price Flag fidDateRcvd 14 fldLRecvD Date 0 Last Rcvd Last Received Date fidDateSold 15 fldLSoldD Date 0 Last Sold Last Sold Date fidFDateRcvd 66 fldFRecvD Date 0 First Rcvd First Received Date fidDateMarked 173 fldLMrkDnD Date 0 Last MkDn Last Markdown Date fidDateDiscon 176 fldDiscD Date 0 Discont Date Discontinue Date fidInvnPrc 11 fldPrice Double 0 Inven P$ Inventory Price fidInvnCost 12 fldCost Double 0 Cost Cost fidMrgD 69 fldMgn Double 0 Margin $ Margin Amount fidMrgP 13 fldMgnPrc Integer 0 Mrg% Margin % fidCoeff 115 fldCoeff Double 0 Coef Coefficient
fidTaxP 118 fldTaxPrc Double 0 Tax % Tax % fidTaxAmt 119 fldTax Double 0 Tax $ Tax Amount
RDA2 Constant ID# Name Type Size Caption Description
fidFrmrPrc 17 fldFrmrPrc Double 0 Frmr P$ Former Price fidMin 55 fldMin Double 0 Min Minimum
fidMax 56 fldMax Double 0 Max Maximum fidInvnPWT 116 fldPrcWTx Double 0 Inven P$T$ Inventory Price with Tax fidMrgT 70 fldMrgWTx Double 0 M$T$ Margin with Tax fidFrmrPWT 128 fldFrmrPrcWTx Double 0 Frmr P$T$ Former Price with Tax fidUnitsPerCase 135 fldUnitsCase Integer 0 Units/Case Units/Case fidQtyCas 136 fldCaseQty Double 0 Case Qty Case Quantity
fidNumberOfDecima
ls 202 fldNDecimals Integer 0 Qty Decimals Number of Decimals fidPrtTag 184 fldPrintTags Boolean 0 Tags Print Tags
fidDeptName 3 fldDCSName String 30 DCS Name Full Department Name fidMupP 104 fldMkUpPrc Integer 0 MkUp% Mark Up %
fidTotO_H 18 fldTotOnHnd Double 0 Cmp Qty Company Quantity fidTotO_O 19 fldTotOnOrder Double 0 Cmp On Ordr Company On Order
fidTotRcvd 20 fldTotRcvd Double 0 Cmp Rcvd Company Received fidTotSold 21 fldTotSold Double 0 Cmp Sold Company Sold
fidStrOrd 101 fldStrOnOrder Double 0 Str On Ordr Store On Order fidStrRcvd 102 fldStrRcvd Double 0 Str Rcvd Store Received fidStrSold 100 fldStrSold Double 0 Str Sold Store Sold fidStyleSid 207 fldStyleSID Int64 0 Style SID Style SID fidStylePicture 204 fldStylePicture String 20 Style Image Style Image fidItemNo 1 fldItemNum Integer 0 Item # Item Number fidItemSID 208 fldItemSID Int64 0 Item SID Item SID fidItemPicture 199 fldItemPicture String 20 Item Image Item Image
fidFC1Prc 177 fldFC1Prc Double 0 FC1 P$ Foreign Currency 1 Price fidFC1PWT 178 fldFC1PrcWTx Double 0 FC1 P$T$ Foreign Currency 1 Price with Tax fidFC1TaxAmt 179 fldFC1Tx Double 0 FC1 T$ Foreign Currency 1 Tax Amount fidItemScale 205 fldItemScale Enumerated 0 Scale Item Scale
fidSchedNo 175 fldDscSch Integer 0 Promo # Promotional Pricing Number fidDC1 50 fldDept String 1 Dept Department
RDA2 Constant ID# Name Type Size Caption Description
fidCmpMax 58 fldCmpMax Double 0 Cmp Max Company Maximum fidDesc3 197 fldDesc3 String 11 Desc 3 Description 3 fidDesc4 198 fldDesc4 String 11 Desc 4 Description 4
fidInvnUDFStr 75 fldInvnUDFStr String 20 UDF Name User-Defined Name fidInvnAux0 78 fldInvnAUX0 Enumerated 0 Aux 1 Auxiliary Field 1 -None- 79 fldInvnAUX1 Enumerated 0 Aux 2 Auxiliary Field 2 -None- 80 fldInvnAUX2 Enumerated 0 Aux 3 Auxiliary Field 3 -None- 81 fldInvnAUX3 Enumerated 0 Aux 4 Auxiliary Field 4 -None- 82 fldInvnAUX4 Enumerated 0 Aux 5 Auxiliary Field 5 -None- 83 fldInvnAUX5 Enumerated 0 Aux 6 Auxiliary Field 6 -None- 84 fldInvnAUX6 Enumerated 0 Aux 7 Auxiliary Field 7 fidInvnAux7 85 fldInvnAUX7 Enumerated 0 Aux 8 Auxiliary Field 8 fidInvnUDFDate 87 fldInvnUDFDate Date 0 UDF Date User-Defined Date fidInvnFrstPrc 195 fldInvnFrstPrc Double 0 First P$ First Price fidInvnFrstPWT 196 fldInvnFrstPWT Double 0 First P$T$ First Price with Tax
fidInvnSerialFlg 88 fldInvnSerialFlg Enumerated 0 Serial Serial Item Flag fidFCC 89 fldFCC Double 0 FOC$ Foreign Order Cost
fidFCCType 90 fldFCCType Enumerated 0 FOC$ Type Foreign Order Cost Type fidMaxDisc1 97 fldMaxDisc1 Double 0 Max Discount Percentage 1 Max Discount Percentage 1 fidMaxDisc2 98 fldMaxDisc2 Double 0 Max Discount Percentage 2 Max Discount Percentage 2 fidVndrListCst 193 fldVndrListCst Double 0 Vendor List Cost Vendor List Cost fidTradeDiscPercent 194 fldTradeDiscPercent Double 0 Trade Discount % Trade Discount % fidInvnCostCode 36 fldCostCode String 0 Cost Code Cost Code fidLastRcvdCode 37 fldLRcvdCode String 0 Last Rcvd Code Last Received Code fidKitItemType 96 fldKitItemType Enumerated 0 Kit Item Type Kit Item Type fidNonInventory 1099 fldNonInventory Boolean 0 Non-Inventory Non-Inventory fidCommitted 1097 fldCommitted Boolean 0 Committed Committed fidDocLastEdit 569 fldDocLastEdit Date 0 Last Edit Last Edit fidSaleDiscPercent 1123 fldSaleDiscPercent Double 0 Sale Disc % Sale Disc % fidSaleDisc 1124 fldSaleDisc Double 0 Sale Disc $ Sale Disc $ fidTotalTaxAmt 7003 fldTotalTax Double 0 Total Tax $ Total Tax Amount fidTax2Prc 700fldTax2Prc Double 0 Tax 2 % Tax 2 Percent
RDA2 Constant ID# Name Type Size Caption Description
fidAltTax2 7004 fldTax2Cd String 0 Tax Code 2 Tax Code 2 fidAltTax1 7002 fldTax1Cd String 0 Tax Code Tax Code
Invoices
RDA2 Constant ID# Name Type Size Caption Description
fidInvcHdrNotes 350 fldInvcHdrNotes String 7 Notes Receipt Header Notes fidStoreStation 563 fldStoreStatn String 4 Str/Sta Store and Station
fidTaxAmt 119 fldTax Double 0 Tax $ Tax Amount fidTaxP 118 fldTaxPrc Double 0 Tax % Tax % fidDiscPercent 500 fldDiscPrc Double 0 Disc % Discount % fidDisc 34 fldDiscount Double 0 Disc $ Discount Amount fidShipping 505 fldShipping Double 0 Shipping Shipping fidFee 508 fldFee Double 0 Fee Fee Amount
fidInvcComment1 371 fldInvcComment1 String 25 Comment 1 Receipt Comment 1 fidInvcComment2 372 fldInvcComment2 String 25 Comment 2 Receipt Comment 2 fidTaxArea 54 fldTaxArea String 11 Tax Area Tax Area fidShippingPercent 504 fldShippingPrc Double 0 Shipping % Shipping % fidFeeType 506 fldFeeType String 6 Fee Type Fee Type fidFeeTaxPercent 507 fldFeeTaxPrc Double 0 Fee Tax % Fee Tax % fidTaxOnFeeShip 509 fldTaxOnFeeShip Double 0 Tax On Fee/Ship Tax On Fee/Ship fidTaxRebatePercent 510 fldTaxRebatePrc Double 0 Tax Rebate % Tax Rebate % fidTaxRebate 511 fldTaxRebate Double 0 Tax Rebate Tax Rebate Amount fidInvcRoundAmt 375 fldInvcRoundAmt Double 0 Round $ Receipt Round Amount fidInvcTotalRoundAmt 376 fldInvcTotalRoundAmt Double 0 Total+Round $ Receipt Total Plus Round Amount fidItemsCount 512 fldItemsCount Integer 0 No of Items Items Count
fidInvcTotalOfLineDisc 377 fldInvcTotalOfLineDisc Double 0 Total of Line Disc Receipt Total of Line Discount fidInvcHdrRcptStatus 378 fldInvcHdrRcptStatus Enumerated 0 Receipt Status Receipt Status
fidInvcHdrRcptType 379 fldInvcHdrRcptType Enumerated 0 Receipt Type Receipt Type fidCashier 517 fldCashier String 8 Cashier Cashier
fidDocDate 518 fldDocDate Date 0 Date Document Date fidInvcNum 560 fldInvcNum Integer 0 Receipt # Receipt Number
fidClerk 65 fldClerk String 8 Associate Associate fidBillToCustID 520 fldBillToCustNumber String 0 Bill To Cust # Bill To Customer Number fidBillToCustComp 521 fldBillToCustCompany String 25 Bill To Company Bill To Company fidBillToCustFName 523 fldBillToFName String 30 Bill To F.Name Bill To First Name
RDA2 Constant ID# Name Type Size Caption Description
fidBillToAddr1 525 fldBillToAddr1 String 31 Bill To Address 1 Bill To Address 1 fidBillToAddr2 526 fldBillToAddr2 String 31 Bill To Address 2 Bill To Address 2 fidBillToAddr3 527 fldBillToAddr3 String 31 Bill To Address 3 Bill To Address 3 fidBillToZip 528 fldBillToZip String 10 Bill To ZIP Bill To ZIP fidBillToInfo1 531 fldBillToInfo1 String 20 Bill To Info 1 Bill To Info 1 fidBillToInfo2 532 fldBillToInfo2 String 20 Bill To Info 2 Bill To Info 2
fidShipToCustID 540 fldShipToCustNumber String 0 Ship To Cust # Ship To Customer Number fidShipToCustComp 541 fldShipToCustCompany String 25 Ship To Company Ship To Company fidShipToCustFName 543 fldShipToFName String 30 Ship To F.Name Ship To First Name fidShipToCustLName 542 fldShipToLName String 30 Ship To L.Name Ship To Last Name fidShipToCustTitle 544 fldShipToTitle String 15 Ship To Title Ship To Title fidShipToAddr1 545 fldShipToAddr1 String 31 Ship To Address 1 Ship To Address 1 fidShipToAddr2 546 fldShipToAddr2 String 31 Ship To Address 2 Ship To Address 2 fidShipToAddr3 547 fldShipToAddr3 String 31 Ship To Address 3 Ship To Address 3 fidShipToZip 548 fldShipToZip String 10 Ship To ZIP Ship To ZIP fidShipToInfo1 551 fldShipToInfo1 String 20 Ship To Info 1 Ship To Info 1 fidShipToInfo2 552 fldShipToInfo2 String 20 Ship To Info 2 Ship To Info 2 fidBillToCustSID 533 fldBillToCustSID Int64 16 Bill To Cust. SID Bill To Customer SID fidShipToCustSID 553 fldShipToCustSID Int64 16 Ship To Cust. SID Ship To Customer SID fidSubTotal 564 fldSubtotal Double 0 SubTotal SubTotal
fidTotal 565 fldTotal Double 0 Total Total fidBillToFullName 536 fldBillToFullName String 0 Bill To Full Name Bill To Full Name fidShipToFullName 556 fldShipToFullName String 0 Ship To Full Name Ship To Full Name fidWorkstation 501 fldWorkstation Integer 0 Wks Workstation
fidDocTime 502 fldDocTime Date 0 Time Document Time fidBillToSC 537 fldBillToSC Double 0 St. Credit Bill To Store Credit
fidBillToChks 538 fldBillToChks Boolean 0 Checks Bill To Checks fidSONum 600 fldSONumber String 14 SO Number SO Number fidSOType 609 fldSOType Enumerated 0 SO Type SO Type fidBillToPicture 557 fldBillToPicture String 20 Bill To Image Bill To Image fidShipToPicture 558 fldShipToPicture String 20 Ship To Image Ship To Image
RDA2 Constant ID# Name Type Size Caption Description
fidFlag2 576 fldFlag2 Enumerated 0 Flag 2 Flag 2 fidFlag3 577 fldFlag3 Enumerated 0 Flag 3 Flag 3 fidGL 578 fldGL Boolean 0 GL General Ledger
fidAR1 579 fldAR1 Boolean 0 AR Accounts Receivable fidPR 582 fldPR Boolean 0 PR Payroll
fidInvcIdx2 381 fldInvcIdx2 String 53 Cust.(Company priority) Customer (Company priority) fidInvcIdx12 382 fldInvcIdx12 String 53 Cust.(Name priority) Customer (Name priority) fidBillToPhone1 529 fldBillToPhone1 String 15 Bill To Phone 1 Bill To Phone 1 fidBillToPhone2 530 fldBillToPhone2 String 15 Bill To Phone 2 Bill To Phone 2 fidShipToPhone1 549 fldShipToPhone1 String 15 Ship To Phone 1 Ship To Phone 1 fidShipToPhone2 550 fldShipToPhone2 String 15 Ship To Phone 2 Ship To Phone 2 fidBusCon 591 fldBusCon Enumerated 0 Business/Consumer Business/Consumer
fidCustPONumber 601 fldSOCustPONumber String 10 Cust PO # Customer Purchase Order Number fidStoreHeading1 585 fldStoreHeading1 String 40 Store Heading 1 Store Heading 1
fidStoreHeading2 586 fldStoreHeading2 String 40 Store Heading 2 Store Heading 2 fidStoreHeading3 587 fldStoreHeading3 String 40 Store Heading 3 Store Heading 3
fidInvcIdx7 383 fldInvcIdx7 String 0 St/Sta/Ws/Date Store/Station/Workstation/Date fidTender 519 fldTender Enumerated 0 Tender Tender fidInvcIdx6 384 fldInvcIdx6 String 0 St/Sta/Cashier Store/Station/Cashier fidStore 53 fldStore String 3 Store Store fidStation 48 fldStation String 1 Station Station
fidDocLastEdit 569 fldDocLastEdit Date 0 Last Edit Last Edit fidTransmitted 823 fldTransmitted Boolean 0 Transmitted Transmitted fidStylePicture 204 fldStylePicture String 20 Style Image Style Image fidDocPostDate 568 fldDocPostDate Date 0 Post Date Post Date fidTrackingNum 652 fldTrackingNum String 24 Tracking # Tracking Number fidCustCredLim 242 fldCredLim Double 0 Chrg Limit Charge Limit fidRefDocNum 300 fldRefDocNum String 0 Reference Doc # Reference Doc Number fidRefDocPostDt 301 fldRefDocPostDt Date 0 Reference Post Date Reference Post Date fidTotalQty 597 fldInvcTotalQty Double 0 Total Qty Sold Total Quantity Sold fidCustCredUsed 243 fldCredUsed Double 0 Chrg Bal Charge Balance fidFC1Total 1110 fldTotalFC1 Double 0 FC1 Total Foreign Currency 1 Total
RDA2 Constant ID# Name Type Size Caption Description
fidStoreHeading5 1586 fldStoreHeading5 String 40 Store Heading 5 Store Heading 5 fidStoreHeading6 1587 fldStoreHeading6 String 40 Store Heading 6 Store Heading 6 fidPrcLvl 107 fldPrcLvl Enumerated 0 Prc Lvl Price Level
fidExtOrigPrice 61 fldExtOrigPrc Double 0 Ext. Orig. Price Extened Original Price fidOrigStoreStation 1121 fldOrigStoreStatn String 4 Orig. Str/Sta Originating Store and Station fidAudited 1122 fldAudited Boolean 0 Audited Audited
fidTaxArea2 7005 fldTaxArea2 String 11 Tax Area 2 Tax Area 2 fidTotalTaxAmt 7003 fldTotalTax Double 0 Total Tax $ Total Tax Amount fidTax2Amt 7001 fldTax2 Double 0 Tax 2 $ Tax 2 Amount fidTax2Prc 7000 fldTax2Prc Double 0 Tax 2 % Tax 2 Percent fidDefSubLoc 1127 fldDefSubLoc String 12 Default Sub-Location Default sub-location
fidMovNoteShipNum 1128 fldMovNoteShipNum String 9 Movement Note Shipment# Movement note shipment number fidWSSeqNo 1129 fldSeqWSNo Integer 0 WS Seq # WS Seq #
fidDataOrigin 1131 fldDataOrigin Enumerated 0 Data Origin Data Origin fidChargeDueDate 1132 fldChargeDueDate Date 0 Charge Due Date Charge Due Date fidSubTotalWithoutTax 562 fldSubTotalWithoutTax Double 0 Subtotal w/o Tax Subtotal w/o Tax fidShipToAux11 7211 fldShipToAux12 Enumerated 0 Ship To Aux 12 Auxiliary field 12 -None- 7210 fldShipToAux11 Enumerated 0 Ship To Aux 11 Auxiliary field 11 -None- 7209 fldShipToAux10 Enumerated 0 Ship To Aux 10 Auxiliary field 10 -None- 7208 fldShipToAux9 Enumerated 0 Ship To Aux 9 Auxiliary field 9 -None- 7207 fldShipToAux8 Enumerated 0 Ship To Aux 8 Auxiliary field 8 -None- 7206 fldShipToAux7 Enumerated 0 Ship To Aux 7 Auxiliary field 7 -None- 7205 fldShipToAux6 Enumerated 0 Ship To Aux 6 Auxiliary field 6 -None- 7204 fldShipToAux5 Enumerated 0 Ship To Aux 5 Auxiliary field 5 -None- 7203 fldShipToAux4 Enumerated 0 Ship To Aux 4 Auxiliary field 4 -None- 7202 fldShipToAux3 Enumerated 0 Ship To Aux 3 Auxiliary field 3 -None- 7201 fldShipToAux2 Enumerated 0 Ship To Aux 2 Auxiliary field 2 fidShipToAux0 7200 fldShipToAux1 Enumerated 0 Ship To Aux 1 Auxiliary field 1 fidBillToAux11 7111 fldBillToAux12 Enumerated 0 Bill To Aux 12 Auxiliary field 12 -None- 7110 fldBillToAux11 Enumerated 0 Bill To Aux 11 Auxiliary field 11 -None- 7109 fldBillToAux10 Enumerated 0 Bill To Aux 10 Auxiliary field 10
RDA2 Constant ID# Name Type Size Caption Description
-None- 7106 fldBillToAux7 Enumerated 0 Bill To Aux 7 Auxiliary field 7 -None- 7105 fldBillToAux6 Enumerated 0 Bill To Aux 6 Auxiliary field 6 -None- 7104 fldBillToAux5 Enumerated 0 Bill To Aux 5 Auxiliary field 5 -None- 7103 fldBillToAux4 Enumerated 0 Bill To Aux 4 Auxiliary field 4 -None- 7102 fldBillToAux3 Enumerated 0 Bill To Aux 3 Auxiliary field 3 -None- 7101 fldBillToAux2 Enumerated 0 Bill To Aux 2 Auxiliary field 2 fidBillToAux0 7100 fldBillToAux1 Enumerated 0 Bill To Aux 1 Auxiliary field 1 fidBillToUDF7 7120 fldBillToUDF8 String 20 Bill To UDF 8 User-Defined Field 8 -None- 7119 fldBillToUDF7 String 20 Bill To UDF 7 User-Defined Field 7 -None- 7118 fldBillToUDF6 String 20 Bill To UDF 6 User-Defined Field 6 -None- 7117 fldBillToUDF5 String 20 Bill To UDF 5 User-Defined Field 5 -None- 7116 fldBillToUDF4 String 20 Bill To UDF 4 User-Defined Field 4 -None- 7115 fldBillToUDF3 String 20 Bill To UDF 3 User-Defined Field 3 -None- 7114 fldBillToUDF2 Date 0 Bill To UDF 2 User-Defined Field 2 fidShipToUDF7 7220 fldShipToUDF8 String 20 Ship To UDF 8 User-Defined Field 8 -None- 7219 fldShipToUDF7 String 20 Ship To UDF 7 User-Defined Field 7 -None- 7218 fldShipToUDF6 String 20 Ship To UDF 6 User-Defined Field 6 -None- 7217 fldShipToUDF5 String 20 Ship To UDF 5 User-Defined Field 5 -None- 7216 fldShipToUDF4 String 20 Ship To UDF 4 User-Defined Field 4 -None- 7215 fldShipToUDF3 String 20 Ship To UDF 3 User-Defined Field 3 -None- 7214 fldShipToUDF2 Date 0 Ship To UDF 2 User-Defined Field 2 fidBillToUDF0 7113 fldBillToUDF1 Date 0 Bill To UDF 1 User-Defined Field 1 fidShipToUDF0 7213 fldShipToUDF1 Date 0 Ship To UDF 1 User-Defined Field 1 fidBillToEMail 534 fldBillToEMail String 60 Bill To E-Mail Bill To E-Mail address fidShipToEMail 554 fldShipToEMail String 60 Ship To E-Mail Ship To E-Mail address fidDocVAT 7227 fldDocVAT Boolean 0 VAT Document VAT flag fidRefDocSID 299 fldRefDocSID Int64 0 Ref Doc SID Ref document SID
ReceiptItem (Nested Table)
RDA2 Constant ID# Name Type Size Caption Description
fidDC 2 fldDCS String 9 DCS Full Department Code fidVC 4 fldVendorCode String 3 Vend Code Vendor Code
fidDesc1 5 fldDesc1 String 16 Desc 1 Description 1 fidDesc2 8 fldDesc2 String 17 Desc 2 Description 2
fidAttr 6 fldAttr String 4 Attr Attribute fidSIZE 7 fldSize String 4 Size Size
fidUPC 9 fldUPC String 13 UPC UPC fidALU 166 fldALU String 20 ALU Alternate Look Up fidUsrCd0 146 fldUDF0 Enumerated 0 UDF 1 User-Defined Field 1 fidUsrCd1 163 fldUDF1 Enumerated 0 UDF 2 User-Defined Field 2 fidUsrCd2 164 fldUDF2 Enumerated 0 UDF 3 User-Defined Field 3 fidUsrCd3 165 fldUDF3 Enumerated 0 UDF 4 User-Defined Field 4 fidCommCod 181 fldCommCod Integer 0 Comm Code Commission Code fidSPIF 182 fldSPIF Double 0 SPIF Sales Person Incentive Fee fidCommAmt 183 fldCommAmt Double 0 Comm $ Commission Amount fidTax 49 fldTaxCd Enumerated 0 Tax Tax Code
fidEDIStatus 109 fldEDI Enumerated 0 EDI EDI Status fidMrgD 69 fldMgn Double 0 Margin $ Margin Amount
fidMrgP 13 fldMgnPrc Integer 0 Mrg% Margin % fidCoeff 115 fldCoeff Double 0 Coef Coefficient
fidTaxP 118 fldTaxPrc Double 0 Tax % Tax % fidTaxAmt 119 fldTax Double 0 Tax $ Tax Amount
fidQTY 10 fldQty Double 0 Qty Quantity fidQtyO_H 26 fldStrQty Double 0 Str Qty Store Quantity
fidMrgT 70 fldMrgWTx Double 0 M$T$ Margin with Tax fidUnitsPerCase 135 fldUnitsCase Integer 0 Units/Case Units/Case fidQtyCas 136 fldCaseQty Double 0 Case Qty Case Quantity fidNumberOfDecimals 202 fldNDecimals Integer 0 Qty Decimals Number of Decimals fidDocItmPrc 41 fldInvcItemPrc Double 0 Rcpt P$ Receipt Price fidDocItmPWT 132 fldInvcItemPWT Double 0 Rcpt P$T$ Receipt Price with Tax
RDA2 Constant ID# Name Type Size Caption Description
fidDeptName 3 fldDCSName String 30 DCS Name Full Department Name fidMupP 104 fldMkUpPrc Integer 0 MkUp% Mark Up %
fidTotO_H 18 fldTotOnHnd Double 0 Cmp Qty Company Quantity fidExtPrc 33 fldExtPrc Double 0 Ext P$ Extended Price fidExtCost 38 fldExtCost Double 0 Ext C$ Extended Cost fidExtPwt 117 fldExtPWT Double 0 Ext P$T$ Extended Price with Tax fidDiscLvl 106 fldDocItemDiscLvl Enumerated 0 Disc Type Discount Type fidQtyO_HCas 138 fldCaseStrQty Double 0 Str Case Qty Store Quantity in Cases fidOrigPrc 32 fldDocItemOrigPrc Double 0 Orig P$ Original Price fidOrigTax 162 fldDocItemOrigTax Double 0 Orig T$ Original Tax Amount fidClerk 65 fldClerk String 8 Associate Associate fidItemLookup 567 fldItemLookup String 20 Item # Item Lookup
fidPrcLvl 107 fldPrcLvl Enumerated 0 Prc Lvl Price Level
fidSchedNo 175 fldDscSch Integer 0 Promo # Promotional Pricing Number fidItemModified 590 fldItemModified Boolean 0 MOD Modified fidOrigPWT 123 fldDocItemOrigPWT Double 0 Orig P$T$ Original Price with Tax fidItemSID 208 fldItemSID Int64 0 Item SID Item SID
fidDisc 34 fldDocItemDiscAmt Double 0 Disc $ Item Discount -None- 2003 fldRecNo Integer 0 Rec # Record Number fidFC1Prc 177 fldFC1Prc Double 0 FC1 P$ Foreign Currency 1 Price fidFC1PWT 178 fldFC1PrcWTx Double 0 FC1 P$T$ Foreign Currency 1 Price with Tax fidStyleSid 207 fldStyleSID Int64 0 Style SID Style SID
fidDesc3 197 fldDesc3 String 11 Desc 3 Description 3 fidDesc4 198 fldDesc4 String 11 Desc 4 Description 4
fidInvnAux0 78 fldInvnAUX0 Enumerated 0 Aux 1 Auxiliary Field 1 -None- 79 fldInvnAUX1 Enumerated 0 Aux 2 Auxiliary Field 2 -None- 80 fldInvnAUX2 Enumerated 0 Aux 3 Auxiliary Field 3 -None- 81 fldInvnAUX3 Enumerated 0 Aux 4 Auxiliary Field 4