RDA2 Constant ID# Name Type Size Caption Description
fidPONumber 400 fldPONumber String 20 PO # PO Number fidVC 4 fldVendorCode String 3 Vend Code Vendor Code fidVndrCompany 210 fldCompany String 25 Company Company Name fidVndrAccNum 233 fldAccNum String 10 Acct # Account Number fidVouNumber 700 fldVouNumber Integer 0 Voucher # Voucher Number fidClerk 65 fldClerk String 8 Associate Associate fidStoreStation 563 fldStoreStatn String 4 Str/Sta Store and Station fidDocDate 518 fldDocDate Date 0 Date Document Date
fidVouPaid 516 fldVouTerms String 0 Terms Payment Terms fidSubTotal 564 fldSubtotal Double 0 SubTotal SubTotal
fidTotal 565 fldTotal Double 0 Total Total fidDiscPercent 500 fldDiscPrc Double 0 Disc % Discount %
fidDisc 34 fldDiscount Double 0 Disc $ Discount Amount fidFee 508 fldFee Double 0 Fee Fee Amount fidVouArrivalDate 701 fldVouArrivalDate Date 0 Arriv. Date Arrival Date fidVouPayeeCode 702 fldVouPayeeCode String 6 Payee Payee Code fidVouPayeeName 703 fldVouPayeeName String 26 Payee Name Payee Name fidVouInvoiceNumber 704 fldVouInvcNumber String 15 Invoice # Invoice Number fidVouFreight 706 fldVouFreight Double 0 Freight Freight fidVouTaxIncPrc 707 fldVouTaxIncPrc Double 0 Tax Incl % Tax Included % fidVouTaxIncAmt 708 fldVouTaxIncAmt Double 0 Tax Incl $ Tax Included Amount fidVouTaxExcPrc 709 fldVouTaxExcPrc Double 0 Tax Excl % Tax Excluded % fidVouTaxExcAmt 710 fldVouTaxExcAmt Double 0 Tax Excl $ Tax Excluded Amount fidVouInvoiceDate 711 fldVouInvcDate Date 0 Invoice Date Invoice Date
fidVouType 712 fldVouType Enumerated 0 Type Voucher Type fidVouStatus 713 fldVouStatus Enumerated 0 Status Voucher Status
fidItemPicture 199 fldItemPicture String 20 Item Image Item Image fidVouCostMethod 714 fldVouCostMethod Enumerated 0 Cost Method Cost Method
fidGL 578 fldGL Boolean 0 GL General Ledger fidAP 581 fldAP Boolean 0 AP Accounts Payable
RDA2 Constant ID# Name Type Size Caption Description
fidDocLastEdit 569 fldDocLastEdit Date 0 Last Edit Last Edit fidDocPostDate 568 fldDocPostDate Date 0 Post Date Post Date
fidDocTime 502 fldDocTime Date 0 Time Document Time 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 fidWorkstation 501 fldWorkstation Integer 0 Wks Workstation
fidItemsCount 512 fldItemsCount Integer 0 No of Items Items Count fidMarked 592 fldMarked Boolean 0 Marked Marked fidVouPackageNumber 715 fldVouPackageNumber String 20 Package # Package Number fidVouComm1 716 fldVouComm1 String 60 Comment 1 Voucher Comment 1 -None- 717 fldVouComm2 String 60 Comment 2 Voucher Comment 2 -None- 718 fldVouComm3 String 60 Comment 3 Voucher Comment 3 -None- 719 fldVouComm4 String 60 Comment 4 Voucher Comment 4 -None- 720 fldVouComm5 String 60 Comment 5 Voucher Comment 5 -None- 721 fldVouComm6 String 60 Comment 6 Voucher Comment 6 -None- 722 fldVouComm7 String 60 Comment 7 Voucher Comment 7 -None- 723 fldVouComm8 String 60 Comment 8 Voucher Comment 8 -None- 724 fldVouComm9 String 60 Comment 9 Voucher Comment 9 fidVouComm10 725 fldVouComm10 String 60 Comment 10 Voucher Comment 10 fidVouPayeeAddr1 726 fldVouPayeeAddr1 String 31 Payee Address 1 Payee Address 1 fidVouPayeeAddr2 727 fldVouPayeeAddr2 String 31 Payee Address 2 Payee Address 2 fidVouPayeeAddr3 728 fldVouPayeeAddr3 String 31 Payee Address 3 Payee Address 3 fidVouPayeeZip 729 fldVouPayeeZip String 10 Payee ZIP Payee ZIP Code fidVouPayeeAcctNum 730 fldVouPayeeAcctNum String 10 Payee Acct # Payee Account Number fidTONumber 950 fldTONumber String 8 TO # TO 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 fidVndrTitle 211 fldTitle String 15 Title Title
RDA2 Constant ID# Name Type Size Caption Description
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 fidVouPayeeTitle 731 fldVouPayeeTitle String 15 Payee Title Payee Title
fidVouPayeeFName 732 fldVouPayeeFName String 30 Payee First Payee First Name fidVouPayeeLName 735 fldVouPayeeLName String 30 Payee Last Payee Last Name fidVouPayeePhone1 736 fldVouPayeePhone1 String 15 Payee Phone 1 Payee Telephone 1 fidVouPayeePhone2 737 fldVouPayeePhone2 String 15 Payee Phone 2 Payee Telephone 2 fidVouPayeeInfo1 738 fldVouPayeeInfo1 String 20 Payee Info 1 Payee Information 1 fidVouPayeeInfo2 739 fldVouPayeeInfo2 String 20 Payee Info 2 Payee Information 2 fidStore 53 fldStore String 3 Store Store fidStation 48 fldStation String 1 Station Station
fidTransmitted 823 fldTransmitted Boolean 0 Transmitted Transmitted fidStylePicture 204 fldStylePicture String 20 Style Image Style Image
fidShipmentNum 1079 fldShipmentNumber String 16 Shipment Number Shipment Number fidRefDocNum 300 fldRefDocNum String 0 Reference Doc # Reference Doc Number fidRefDocPostDt 301 fldRefDocPostDt Date 0 Reference Post Date Reference Post Date fidTotalQty 597 fldVchrTotalQty Double 0 Total Qty Received Total Quantity Received fidStoreHeading4 1585 fldStoreHeading4 String 40 Store Heading 4 Store Heading 4 fidStoreHeading5 1586 fldStoreHeading5 String 40 Store Heading 5 Store Heading 5 fidStoreHeading6 1587 fldStoreHeading6 String 40 Store Heading 6 Store Heading 6
fidOrigStoreStation 1121 fldOrigStoreStatn String 4 Orig. Str/Sta Originating Store and Station fidAudited 1122 fldAudited Boolean 0 Audited Audited 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 fidVndrInvcTotal 1135 fldVndrInvcTotal Double 0 Vendor Invoice Total Vendor Invoice Total fidReviewedBy 1137 fldReviewedBy String 8 Reviewed By Reviewed By fidReviewedDT 1138 fldReviewedDT Date 0 Reviewed Date/Time Reviewed Date/Time
RDA2 Constant ID# Name Type Size Caption Description
fidRefDocSID 299 fldRefDocSID Int64 0 Ref Doc SID Ref document SID fidDocSID 595 fldDocSID Int64 0 SID Document SID fidVouTotalPrice 449 fldVouTotalPrice Double 0 Price Price fidVouTotalPrcTax 450 fldVouTotalPrcTax Double 0 P$T$ P$T$
VoucherItem (Nested Table)
RDA2 Constant ID# Name Type Size Caption Description
fidDC 2 fldDCS String 9 DCS Full Department Code fidDeptName 3 fldDCSName String 30 DCS Name Full Department Name 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 fidFDateRcvd 66 fldFRecvD Date 0 First Rcvd First Received 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 % fidMupP 104 fldMkUpPrc Integer 0 MkUp% Mark Up % fidCoeff 115 fldCoeff Double 0 Coef Coefficient fidTaxAmt 119 fldTax Double 0 Tax $ Tax Amount fidQtyRcvd 28 fldItmRcvd Double 0 Qty Rcvd Quantity Received fidExtPrc 33 fldExtPrc Double 0 Ext P$ Extended Price fidExtCost 38 fldExtCost Double 0 Ext C$ Extended Cost fidInvnPWT 116 fldPrcWTx Double 0 Inven P$T$ Inventory Price with Tax fidMrgT 70 fldMrgWTx Double 0 M$T$ Margin with Tax fidExtPwt 117 fldExtPWT Double 0 Ext P$T$ Extended Price with Tax fidQtyRcvdCas 140 fldCaseQtyRcvd Double 0 Case Rcvd Case Quantity Received fidPrtTag 184 fldPrintTags Boolean 0 Tags Print Tags fidDiscPercent 500 fldDocItemDisc Double 0 Disc % Item Discount %
RDA2 Constant ID# Name Type Size Caption Description
fidDocItmPrc 41 fldVouItmPrc Double 0 Voucher P$ Voucher Price fidVouItmCartonID 733 fldCartonID Integer 0 Carton ID Carton ID fidItemLookup 567 fldItemLookup String 20 Item # Item Lookup fidVouItmOrigQty 734 fldVouItmOrigQty Double 0 Ship Qty Ship Quantity fidNumberOfDecimals 202 fldNDecimals Integer 0 Qty Decimals Number of Decimals fidTotO_H 18 fldTotOnHnd Double 0 Cmp Qty Company Quantity fidQtyO_H 26 fldStrQty Double 0 Str Qty Store Quantity fidItemSID 208 fldItemSID Int64 0 Item SID Item SID
fidTax 49 fldTaxCd Enumerated 0 Tax Tax Code fidTaxP 118 fldTaxPrc Double 0 Tax % Tax %
fidExtTax 121 fldExtTax Double 0 Ext T$ Extended Tax -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 fidLastCost 16 fldOrdCost Double 0 Ord C$ Order Cost
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 -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 fidInvnUDFStr 75 fldInvnUDFStr String 20 UDF Name User-Defined Name 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
RDA2 Constant ID# Name Type Size Caption Description
fidSerialNum 651 fldSerialNum String 25 Serial # Serial Number -None- 740 fldAssociatePO String 20 Associate PO Associate PO fidInvnCostCode 36 fldCostCode String 0 Cost Code Cost Code fidDocCostCode 559 fldVouItmCostCode String 0 Voucher Cost Code Voucher Cost Code fidCommitted 1097 fldCommitted Boolean 0 Committed Committed
fidQtyO_HCas 138 fldCaseStrQty Double 0 Str Case Qty Store Quantity in Cases 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 7000 fldTax2Prc Double 0 Tax 2 % Tax 2 Percent fidTax2Amt 7001 fldTax2 Double 0 Tax 2 $ Tax 2 Amount fidAltTax2 7004 fldTax2Cd String 0 Tax Code 2 Tax Code 2 fidAltTax1 7002 fldTax1Cd String 0 Tax Code Tax Code fidDefSubLoc 1127 fldDefSubLoc String 12 Default Sub-Location Default sub-location fidItemScale 205 fldItemScale Enumerated 0 Scale Item Scale fidSeqNum 1130 fldSeqNum Integer 0 Seq # Sequence number
Memos
RDA2 Constant ID# Name Type Size Caption Description
fidPrcLvl 107 fldPrcLvl Enumerated 0 Prc Lvl Price Level fidDocDate 518 fldDocDate Date 0 Date Document Date
fidDocTime 502 fldDocTime Date 0 Time Document Time fidClerk 65 fldClerk String 8 Associate Associate
fidMemoSource 800 fldMemoSource Enumerated 0 Source Memo Source fidMemoCreatingDocNum 801 fldMemoCreatingDocNum Integer 0 Creating Doc # Creating Doc Number fidMemoType 802 fldMemoType Enumerated 0 Type Memo Type fidMemoReason 803 fldMemoReason String 8 Reason Memo Reason
fidMemoNum 804 fldMemoNum Integer 0 Memo # Memo Number fidStore 53 fldStore String 3 Store Store
fidMemoOldStrQty 807 fldMemoOldStrQty Double 0 Old Str Qty Old Store Quantity fidMemoOldCmpQty 808 fldMemoOldCmpQty Double 0 Old Cmp Qty Old Company Quantity fidMemoAdjStrQty 809 fldMemoAdjStrQty Double 0 Adj Str Qty Adjusted Store Quantity fidMemoAdjCmpQty 810 fldMemoAdjCmpQty Double 0 Adj Cmp Qty Adjusted Company Quantity fidMemoOldPrcPWT 812 fldMemoOldPrcPWT Double 0 Old Prc Old Price fidMemoAdjPrcPWT 813 fldMemoAdjPrcPWT Double 0 Adj Prc Adjusted Price fidMemoOldCost 815 fldMemoOldCost Double 0 Old C$ Old Cost fidMemoAdjCost 816 fldMemoAdjCost Double 0 Adj C$ Adjusted Cost fidMemoDifQty 811 fldMemoDifQty Double 0 Dif Qty Difference in Quantity fidMemoDifPrcPWT 814 fldMemoDifPrcPWT Double 0 Dif Prc Difference in Price fidMemoDifCost 817 fldMemoDifCost Double 0 Dif C$ Difference in Cost fidDocPostDate 568 fldDocPostDate Date 0 Post Date Post Date fidDocLastEdit 569 fldDocLastEdit Date 0 Last Edit Last Edit fidItemPicture 199 fldItemPicture String 20 Item Image Item Image
fidGL 578 fldGL Boolean 0 GL General Ledger fidMemoReversed 821 fldMemoReversed Enumerated 0 Status Memo Status
fidMemoCopyed 822 fldMemoCopyed Boolean 0 Copied Copied fidMemoODBCancelled 825 fldMemoODBCancelled Boolean 0 RDW Cancelled RDW Cancelled fidItemsCount 512 fldItemsCount Integer 0 No of Items Items Count fidWorkstation 501 fldWorkstation Integer 0 Wks Workstation
RDA2 Constant ID# Name Type Size Caption Description
fidStoreHeading3 587 fldStoreHeading3 String 40 Store Heading 3 Store Heading 3 fidMemoComm1 836 fldMemoComm1 String 60 Comment 1 Memo Comment 1 -None- 837 fldMemoComm2 String 60 Comment 2 Memo Comment 2 -None- 838 fldMemoComm3 String 60 Comment 3 Memo Comment 3 -None- 839 fldMemoComm4 String 60 Comment 4 Memo Comment 4 -None- 840 fldMemoComm5 String 60 Comment 5 Memo Comment 5 -None- 841 fldMemoComm6 String 60 Comment 6 Memo Comment 6 -None- 842 fldMemoComm7 String 60 Comment 7 Memo Comment 7 -None- 843 fldMemoComm8 String 60 Comment 8 Memo Comment 8 -None- 844 fldMemoComm9 String 60 Comment 9 Memo Comment 9 fidMemoComm10 845 fldMemoComm10 String 60 Comment 10 Memo Comment 10 fidTransmitted 823 fldTransmitted Boolean 0 Transmitted Transmitted fidStylePicture 204 fldStylePicture String 20 Style Image Style Image fidODSExported 1066 fldODSExported Boolean 0 ODS Exported ODS Exported fidStoreHeading4 1585 fldStoreHeading4 String 40 Store Heading 4 Store Heading 4 fidStoreHeading5 1586 fldStoreHeading5 String 40 Store Heading 5 Store Heading 5 fidStoreHeading6 1587 fldStoreHeading6 String 40 Store Heading 6 Store Heading 6 fidOrigStoreStation 1121 fldOrigStoreStatn String 4 Orig. Str/Sta Originating Store and Station fidAudited 1122 fldAudited Boolean 0 Audited Audited 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 fidDocSID 595 fldDocSID Int64 0 SID Document SID
MemoItem(Nested Table)
RDA2 Constant ID# Name Type Size Caption Description
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 fidMemoOldCmpQty 808 fldMemoOldCmpQty Double 0 Old Cmp Qty Old Company Quantity fidMemoOldStrQty 807 fldMemoOldStrQty Double 0 Old Str Qty Old Store Quantity fidMemoAdjStrQty 809 fldMemoAdjStrQty Double 0 Adj Str Qty Adjusted Store Quantity fidMemoOldCost 815 fldMemoOldCost Double 0 Old C$ Old Cost
fidMemoAdjCost 816 fldMemoAdjCost Double 0 Adj C$ Adjusted Cost fidItemLookup 567 fldItemLookup String 20 Item # Item Lookup fidMemoOldPrcPWT 812 fldMemoOldPrcPWT Double 0 Old Prc Old Price fidMemoAdjPrcPWT 813 fldMemoAdjPrcPWT Double 0 Adj Prc Adjusted Price fidDC 2 fldDCS String 9 DCS Full Department Code fidMemoQtyDiff 826 fldMemoQtyDiff Double 0 Qty Diff Quantity Difference fidNumberOfDecimals 202 fldNDecimals Integer 0 Qty Decimals Number of Decimals fidItemSID 208 fldItemSID Int64 0 Item SID Item SID
-None- 2003 fldRecNo Integer 0 Rec # Record Number 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 fidInvnSerialFlg 88 fldInvnSerialFlg Enumerated 0 Serial Serial Item Flag
fidSerialNum 651 fldSerialNum String 25 Serial # Serial Number fidNonInventory 1099 fldNonInventory Boolean 0 Non-Inventory Non-Inventory
fidCommitted 1097 fldCommitted Boolean 0 Committed Committed fidMemoDifCost 817 fldMemoDifCost Double 0 Dif C$ Difference in Cost
fidMemoDifPrcPWT 814 fldMemoDifPrcPWT Double 0 Dif Prc Difference in Price fidSaleDiscPercent 1123 fldSaleDiscPercent Double 0 Sale Disc % Sale Disc %
RDA2 Constant ID# Name Type Size Caption Description
fidItemScale 205 fldItemScale Enumerated 0 Scale Item Scale fidSeqNum 1130 fldSeqNum Integer 0 Seq # Sequence number 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
Slips
RDA2 Constant ID# Name Type Size Caption Description
fidStoreStation 563 fldStoreStatn String 4 Str/Sta Store and Station fidClerk 65 fldClerk String 8 Associate Associate
fidDocDate 518 fldDocDate Date 0 Date Document Date fidDocTime 502 fldDocTime Date 0 Time Document Time
fidSlipFromStore 900 fldSlipFromStore String 3 From Store From Store fidSlipToStore 901 fldSlipToStore String 3 To Store To Store fidSlipConfirmation 902 fldSlipConfirmation Enumerated 0 Confirmation Confirmation fidSlipCarrier 903 fldSlipCarrier String 15 Carrier Carrier
fidSlipETA 904 fldSlipETA Date 0 ETA ETA fidSlipTONum 905 fldSlipTONum String 8 TO # TO Number
fidSlipNum 906 fldSlipNum Integer 0 Slip # Slip Number fidOutSlipNum 907 fldOutSlipNum Integer 0 Out Slip # Out Slip Number fidItemsCount 512 fldItemsCount Integer 0 No of Items Items Count fidSlipPrice 45 fldSlipPrice Double 0 Total Price Total Price fidSlipCost 46 fldSlipCost Double 0 Total Cost Total Cost fidSlipFreight 910 fldSlipFreight Double 0 Freight Freight fidDocPostDate 568 fldDocPostDate Date 0 Post Date Post Date fidDocLastEdit 569 fldDocLastEdit Date 0 Last Edit Last Edit fidSlipStatus 912 fldSlipStatus Enumerated 0 Status Slip Status fidItemPicture 199 fldItemPicture String 20 Item Image Item Image
fidGL 578 fldGL Boolean 0 GL General Ledger 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 fidSlipComm1 922 fldSlipComm1 String 60 Comment 1 Slip Comment 1 -None- 923 fldSlipComm2 String 60 Comment 2 Slip Comment 2 -None- 924 fldSlipComm3 String 60 Comment 3 Slip Comment 3 -None- 925 fldSlipComm4 String 60 Comment 4 Slip Comment 4 -None- 926 fldSlipComm5 String 60 Comment 5 Slip Comment 5 -None- 927 fldSlipComm6 String 60 Comment 6 Slip Comment 6
RDA2 Constant ID# Name Type Size Caption Description
-None- 930 fldSlipComm9 String 60 Comment 9 Slip Comment 9 fidSlipComm10 931 fldSlipComm10 String 60 Comment 10 Slip Comment 10 fidSlipToStoreHeading1 932 fldSlipToStoreHeading1 String 40 To Store Heading 1 To Store Heading 1 fidSlipToStoreHeading2 933 fldSlipToStoreHeading2 String 40 To Store Heading 2 To Store Heading 2 fidSlipToStoreHeading3 934 fldSlipToStoreHeading3 String 40 To Store Heading 3 To Store Heading 3 fidMarked 592 fldMarked Boolean 0 Marked Marked
fidSlipCopied 936 fldSlipCopied Boolean 0 Copied Copied fidSlipODBCancelled 938 fldSlipODBCancelled Boolean 0 RDW Cancelled RDW Cancelled
fidStore 53 fldStore String 3 Store Store fidStation 48 fldStation String 1 Station Station
fidSlipType 939 fldSlipType Enumerated 0 Slip Type Slip Type fidTransmitted 823 fldTransmitted Boolean 0 Transmitted Transmitted fidStylePicture 204 fldStylePicture String 20 Style Image Style Image fidODSExported 1066 fldODSExported Boolean 0 ODS Exported ODS Exported fidSlipCompStore 940 fldSlipCompStore String 6 Out To Comp/Store Out To Comp/Store fidSlipCompStoreDesc 941 fldSlipCompStoreDesc String 0 Comp/Store Description Comp/Store Description fidRefDocNum 300 fldRefDocNum String 0 Reference Doc # Reference Doc Number fidRefDocPostDt 301 fldRefDocPostDt Date 0 Reference Post Date Reference Post Date fidTotalQty 597 fldSlipTotalQty Double 0 Total Qty Transferred Total Quantity Transferred fidStoreHeading4 1585 fldStoreHeading4 String 40 Store Heading 4 Store Heading 4 fidStoreHeading5 1586 fldStoreHeading5 String 40 Store Heading 5 Store Heading 5 fidStoreHeading6 1587 fldStoreHeading6 String 40 Store Heading 6 Store Heading 6 fidSlipToStoreHeading4 1932 fldSlipToStoreHeading4 String 40 To Store Heading 4 To Store Heading 4 fidSlipToStoreHeading5 1933 fldSlipToStoreHeading5 String 40 To Store Heading 5 To Store Heading 5 fidSlipToStoreHeading6 1934 fldSlipToStoreHeading6 String 40 To Store Heading 6 To Store Heading 6 fidOrigStoreStation 1121 fldOrigStoreStatn String 4 Orig. Str/Sta Originating Store and Station fidSlipDaysInTransit 942 fldSlipDaysInTransit Integer 0 Days In-Transit Days In-Transit
fidSlipTargetUpdated 943 fldSlipTargetUpdated Boolean 0 Target Updated Target Updated fidAudited 1122 fldAudited Boolean 0 Audited Audited fidSlipTransferComplete
d 944 fldSlipTransferComplete Date 0 Transfer Complete Transfer Complete fidSlipResolvedBy 945 fldSlipResolvedBy String 8 Resolved By Resolved By
RDA2 Constant ID# Name Type Size Caption Description
fidSlipResolutionTime 947 fldSlipResolutionTime Date 0 Resolution Date/Time Resolution Date/Time fidDefSubLoc 1127 fldDefSubLoc String 12 Default Sub-Location Default sub-location fidMovNoteShipNum 1128 fldMovNoteShipNum String 9Movement Note
Shipment# Movement note shipment number fidWSSeqNo 1129 fldSeqWSNo Integer 0 WS Seq # WS Seq #
fidDataOrigin 1131 fldDataOrigin Enumerated 0 Data Origin Data Origin fidWorkstation 501 fldWorkstation Integer 0 Wks Workstation fidSlipPackageNum 4000 fldSlipPackageNum String 15 Package # Slip Package # fidRefDocSID 299 fldRefDocSID Int64 0 Ref Doc SID Ref document SID
SlipItem (Nested Table)
RDA2 Constant ID# Name Type Size Caption Description
fidDC 2 fldDCS String 9 DCS Full Department Code fidDeptName 3 fldDCSName String 30 DCS Name Full Department Name 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 fidEDIStatus 109 fldEDI Enumerated 0 EDI EDI Status fidMrgD 69 fldMgn Double 0 Margin $ Margin Amount fidMrgP 13 fldMgnPrc Integer 0 Mrg% Margin % fidMupP 104 fldMkUpPrc Integer 0 MkUp% Mark Up % fidCoeff 115 fldCoeff Double 0 Coef Coefficient fidTaxAmt 119 fldTax Double 0 Tax $ Tax Amount fidQTY 10 fldQty Double 0 Qty Quantity fidExtPrc 33 fldExtPrc Double 0 Ext P$ Extended Price fidExtCost 38 fldExtCost Double 0 Ext C$ Extended Cost fidMrgT 70 fldMrgWTx Double 0 M$T$ Margin with Tax fidExtPwt 117 fldExtPWT Double 0 Ext P$T$ Extended Price with Tax fidQtyCas 136 fldCaseQty Double 0 Case Qty Case Quantity fidDocItmPWT 132 fldSlpPWT Double 0 Slip P$T$ Slip Price with Tax fidItemLookup 567 fldItemLookup String 20 Item # Item Lookup fidNumberOfDeci
mals 202 fldNDecimals Integer 0 Qty Decimals Number of Decimals fidItemSID 208 fldItemSID Int64 0 Item SID Item SID
RDA2 Constant ID# Name Type Size Caption Description
fidDocItmCost 44 fldSlipItmCost Double 0 Slip C$ Slip Cost 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 -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 fidInvnUDFStr 75 fldInvnUDFStr String 20 UDF Name User-Defined Name 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 fidSerialNum 651 fldSerialNum String 25 Serial # Serial Number
fidInvnCostCode 36 fldCostCode String 0 Cost Code Cost Code fidDocCostCode 559 fldSlipCostCode String 0 Slip Cost Code Slip Cost Code fidCommitted 1097 fldCommitted Boolean 0 Committed Committed fidQtyO_HCas 138 fldCaseStrQty Double 0 Str Case Qty Store Quantity in Cases fidQtyO_H 26 fldStrQty Double 0 Str Qty Store Quantity 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 fidTax2Amt 7001 fldTax2 Double 0 Tax 2 $ Tax 2 Amount fidDefSubLoc 1127 fldDefSubLoc String 12 Default Sub-Location Default sub-location fidItemScale 205 fldItemScale Enumerated 0 Scale Item Scale fidSeqNum 1130 fldSeqNum Integer 0 Seq # Sequence number
SubLocDefs
RDA2 Constant ID# Name Type Size Caption Description
fidSubLocID 1050 fldSubLocID String 12 Sub-Loc ID Sub-Location ID fidSubLocName 1051 fldSubLocName String 20 Sub-Loc Name Sub-Location Name fidStore 53 fldStore String 3 Store Store fidSecLvl 594 fldSecLvl Enumerated 0 Security Level Security Level
fidSubLocSID 1076 fldSubLocSID Int64 0 Sub-Location SID Sub-Location SID fidSubLocSuspended 1052 fldSubLocSuspended Boolean 0 Suspended Suspended fidSubLocAssStore 1074 fldSubLocAssStore String 3 Associated Store Associated Store fidSubLocAssDCS 1075 fldSubLocAssDCS String 9 Associated DCS Associated DCS
fidSubLocDefault 1089 fldSubLocDefault Boolean 0 Default Default Sub-Location fidSubLocDefType 1090 fldSubLocType Enumerated 0 Type Sub-Location Type
fidSubLocSeg1 1091 fldSubLocSeg1 String 1 Sub-Loc Seg. 1 Sub-Loc Seg. 1 fidSubLocSeg2 1092 fldSubLocSeg2 String 1 Sub-Loc Seg 2 Sub-Loc Seg 2 fidSubLocSeg3 1093 fldSubLocSeg3 String 1 Sub-Loc Seg 3 Sub-Loc Seg 3 fidSubLocSingleItem 1094 fldSubLocSingleItem Boolean 0 Single Item Restrict Sub-Location to single item fidCommitted 1097 fldCommitted Boolean 0 Committed Committed
SubLocQtys
RDA2 Constant ID# Name Type Size Caption Description
fidStore 53 fldStore String 3 Store Store fidSubLocID 1050 fldSubLocID String 12 Sub-Loc ID Sub-Location ID fidSubLocName 1051 fldSubLocName String 20 Sub-Loc Name Sub-Location Name 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 fidSubLocQty 1085 fldSubLocQty Double 0 Sub-Loc Qty Sub-Loc Quantity fidTotalQty 597 fldTotalQty Double 0 Total Qty Total Quantity
MovNotes
RDA2 Constant ID# Name Type Size Caption Description
fidWorkstation 501 fldWorkstation Integer 0 Wks Workstation fidMovNoteNumber 1057 fldMovNoteNumber Integer 0 Number Movement Note Number