# View: Receipts

RotoID: PO0462
Table:
DLL: POIRCPH

## Compositions: 5

RotoID | Table | Title | DLL
--- | --- | --- | ---
PO0464 |  | Receipt Lines | POIRCPL
PO0460 |  | Receipt Comments | POIRCPC
PO0468 |  | Receipt Vendors | POIRCPV
PO0466 |  | Receipt Additional Costs | POIRCPS
PO0455 |  | Receipt Optional Fields | POIRCHO

## Keys: 1

Title | Fields
--- | ---
| RCPHSEQ

## Fields: 235

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
RCPHSEQ | 1 | BCD*10.0 | Receipt Sequence Key | E A K R |
NEXTLSEQ | 2 | BCD*10.0 | Next Line Sequence | A C X |
LINES | 3 | Long | Lines | E A C X |
LINESPRORA | 4 | Long | Number of Lines Prorated | E A C X |
LINESCMPL | 5 | Long | Lines Complete | E A C X |
COSTS | 6 | Long | Costs | E A C X |
COSTSPRORA | 7 | Long | Number of Costs Prorated | E A C X |
COSTSCMPL | 8 | Long | Costs Complete | E A C X |
VENDS | 9 | Long | Vendors | E A C X |
VENDSCMPL | 10 | Long | Vendors Completed | E A C X |
VENDSINVC | 11 | Long | Vendors Invoiced | E A C X |
TAXLINES | 12 | Long | Lines Tax Calculation Sees | E A C X |
EXTRANEOUS | 13 | Long | Extraneous Line Count | E A C X |
TAXAUTOCAL | 14 | Boolean | Auto. tax calculation on save | A C X | List: 2 entries
0 | = | No
1 | = | Yes
ISPRINTED | 15 | Boolean | Printed | A X | List: 2 entries
0 | = | No
1 | = | Yes
ISINVOICED | 16 | Boolean | Invoiced | A X | List: 2 entries
0 | = | No
1 | = | Yes
ISCOMPLETE | 17 | Boolean | Completed | A C X | List: 2 entries
0 | = | No
1 | = | Yes
DTCOMPLETE | 18 | Date | Date Completed | A X |
POSTDATE | 19 | Date | Last Posting Date | A C X |
DATE | 20 | Date | Receipt Date | E A X |
FISCYEAR | 21 | String*4 | Fiscal Year | E A X | Mask: %4D
FISCPERIOD | 22 | Integer | Fiscal Period | E A P X |
RCPNUMBER | 23 | String*22 | Receipt Number | E A X | Mask: %-22C
TEMPLATE | 24 | String*6 | Template Code | E A X | Mask: %-6N
FOBPOINT | 25 | String*60 | FOB Point | E A X |
VDCODE | 26 | String*12 | Vendor | E A X | Mask: %-12C
VDEXISTS | 27 | Boolean | Vendor Exists | A C X | List: 2 entries
0 | = | No
1 | = | Yes
VDNAME | 28 | String*60 | Name | E A X |
VDADDRESS1 | 29 | String*60 | Address 1 | E A X |
VDADDRESS2 | 30 | String*60 | Address 2 | E A X |
VDADDRESS3 | 31 | String*60 | Address 3 | E A X |
VDADDRESS4 | 32 | String*60 | Address 4 | E A X |
VDCITY | 33 | String*30 | City | E A X |
VDSTATE | 34 | String*30 | State/Province | E A X |
VDZIP | 35 | String*20 | Zip/Postal Code | E A X |
VDCOUNTRY | 36 | String*30 | Country | E A X |
VDPHONE | 37 | String*30 | Phone Number | E A X | Mask: (%-3C) %-3C-%-24C
VDFAX | 38 | String*30 | Fax Number | E A X | Mask: (%-3C) %-3C-%-24C
VDCONTACT | 39 | String*60 | Contact | E A X |
TERMSCODE | 40 | String*6 | Terms Code | E A X | Mask: %-6N
PORHSEQ | 41 | BCD*10.0 | Purchase Order Sequence Key | E A X |
PONUMBER | 42 | String*22 | Purchase Order Number | E A | Mask: %-22C
INVNUMBER | 43 | String*22 | Invoice Number | E A X | Mask: %-22C
DESCRIPTIO | 44 | String*60 | Description | E A X |
REFERENCE | 45 | String*60 | Reference | E A X |
COMMENT | 46 | String*250 | Comment | E A X |
VIACODE | 47 | String*6 | Ship-Via | E A X | Mask: %-6N
VIANAME | 48 | String*60 | Ship-Via Name | E A X |
CURRENCY | 57 | String*3 | Currency | A X | Mask: %-3N
RATE | 58 | BCD*8.7 | Exchange Rate | A X |
SPREAD | 59 | BCD*8.7 | Rate Spread | A X |
RATETYPE | 60 | String*2 | Rate Type | A X | Mask: %-2N
RATEMATCH | 61 | Integer | Rate Match Type | A X |
RATEDATE | 62 | Date | Rate Date | A X |
RATEOPER | 63 | Integer | Rate Operation | A X | List: 2 entries
1 | = | *
2 | = | /
RATEOVER | 64 | Boolean | Rate Overridden | A X | List: 2 entries
0 | = | No
1 | = | Yes
SCURNDECML | 65 | Integer | Decimal Places | A C X |
EXTWEIGHT | 66 | BCD*10.4 | Extended Weight | E A C X |
EXTENDED | 67 | BCD*10.3 | Extended Cost | E A C X |
DOCTOTAL | 68 | BCD*10.3 | Total | A C X |
AMOUNT | 69 | BCD*10.3 | Amount | E A C X |
RQRECEIVED | 70 | BCD*10.4 | Quantity Received | E A C X |
TAXGROUP | 71 | String*12 | Tax Group | E A X | Mask: %-12N
TAXAUTH1 | 72 | String*12 | Tax Authority 1 | A X | Mask: %-12N
TAXAUTH2 | 73 | String*12 | Tax Authority 2 | A X | Mask: %-12N
TAXAUTH3 | 74 | String*12 | Tax Authority 3 | A X | Mask: %-12N
TAXAUTH4 | 75 | String*12 | Tax Authority 4 | A X | Mask: %-12N
TAXAUTH5 | 76 | String*12 | Tax Authority 5 | A X | Mask: %-12N
TAXCLASS1 | 77 | Integer | Tax Class 1 | E A X |
TAXCLASS2 | 78 | Integer | Tax Class 2 | E A X |
TAXCLASS3 | 79 | Integer | Tax Class 3 | E A X |
TAXCLASS4 | 80 | Integer | Tax Class 4 | E A X |
TAXCLASS5 | 81 | Integer | Tax Class 5 | E A X |
TAXBASE1 | 82 | BCD*10.3 | Tax Base 1 | A X |
TAXBASE2 | 83 | BCD*10.3 | Tax Base 2 | A X |
TAXBASE3 | 84 | BCD*10.3 | Tax Base 3 | A X |
TAXBASE4 | 85 | BCD*10.3 | Tax Base 4 | A X |
TAXBASE5 | 86 | BCD*10.3 | Tax Base 5 | A X |
TXINCLUDE1 | 87 | BCD*10.3 | Included Tax Amount 1 | A X |
TXINCLUDE2 | 88 | BCD*10.3 | Included Tax Amount 2 | A X |
TXINCLUDE3 | 89 | BCD*10.3 | Included Tax Amount 3 | A X |
TXINCLUDE4 | 90 | BCD*10.3 | Included Tax Amount 4 | A X |
TXINCLUDE5 | 91 | BCD*10.3 | Included Tax Amount 5 | A X |
TXEXCLUDE1 | 92 | BCD*10.3 | Excluded Tax Amount 1 | A X |
TXEXCLUDE2 | 93 | BCD*10.3 | Excluded Tax Amount 2 | A X |
TXEXCLUDE3 | 94 | BCD*10.3 | Excluded Tax Amount 3 | A X |
TXEXCLUDE4 | 95 | BCD*10.3 | Excluded Tax Amount 4 | A X |
TXEXCLUDE5 | 96 | BCD*10.3 | Excluded Tax Amount 5 | A X |
TAXAMOUNT1 | 97 | BCD*10.3 | Tax Amount 1 | A X |
TAXAMOUNT2 | 98 | BCD*10.3 | Tax Amount 2 | A X |
TAXAMOUNT3 | 99 | BCD*10.3 | Tax Amount 3 | A X |
TAXAMOUNT4 | 100 | BCD*10.3 | Tax Amount 4 | A X |
TAXAMOUNT5 | 101 | BCD*10.3 | Tax Amount 5 | A X |
TXRECVAMT1 | 102 | BCD*10.3 | Tax Recoverable Amount 1 | A X |
TXRECVAMT2 | 103 | BCD*10.3 | Tax Recoverable Amount 2 | A X |
TXRECVAMT3 | 104 | BCD*10.3 | Tax Recoverable Amount 3 | A X |
TXRECVAMT4 | 105 | BCD*10.3 | Tax Recoverable Amount 4 | A X |
TXRECVAMT5 | 106 | BCD*10.3 | Tax Recoverable Amount 5 | A X |
TXEXPSAMT1 | 107 | BCD*10.3 | Tax Expense Amount 1 | A X |
TXEXPSAMT2 | 108 | BCD*10.3 | Tax Expense Amount 2 | A X |
TXEXPSAMT3 | 109 | BCD*10.3 | Tax Expense Amount 3 | A X |
TXEXPSAMT4 | 110 | BCD*10.3 | Tax Expense Amount 4 | A X |
TXEXPSAMT5 | 111 | BCD*10.3 | Tax Expense Amount 5 | A X |
TXALLOAMT1 | 112 | BCD*10.3 | Tax Allocated Amount 1 | A X |
TXALLOAMT2 | 113 | BCD*10.3 | Tax Allocated Amount 2 | A X |
TXALLOAMT3 | 114 | BCD*10.3 | Tax Allocated Amount 3 | A X |
TXALLOAMT4 | 115 | BCD*10.3 | Tax Allocated Amount 4 | A X |
TXALLOAMT5 | 116 | BCD*10.3 | Tax Allocated Amount 5 | A X |
TXBASEALLO | 117 | BCD*10.3 | Net of Tax | A X |
TXINCLUDED | 118 | BCD*10.3 | Tax Included | A C X |
TXEXCLUDED | 119 | BCD*10.3 | Tax Excluded | A C X |
TAXAMOUNT | 120 | BCD*10.3 | Total Tax | A C X |
TXRECVAMT | 121 | BCD*10.3 | Total Tax Recoverable | A X |
TXEXPSAMT | 122 | BCD*10.3 | Total Tax Expensed | A X |
TXALLOAMT | 123 | BCD*10.3 | Total Tax Allocated | A X |
MPRORATED | 124 | BCD*10.3 | Manual Proration Total | E A C X |
MTOPRORATE | 125 | BCD*10.3 | Manual To Prorate | E A C X |
SCAMOUNT | 126 | BCD*10.3 | Conversion Source Amount | A C X |
FCAMOUNT | 127 | BCD*10.3 | Conversion Functional Amount | A C X |
MULTIPOR | 128 | Boolean | Multiple Purchase Orders | E A X | List: 2 entries
0 | = | No
1 | = | Yes
PORS | 129 | Long |  | E A C X |
VDEMAIL | 130 | String*50 | E-mail | E A X |
VDPHONEC | 131 | String*30 | Contact Phone | E A X | Mask: (%-3C) %-3C-%-24C
VDFAXC | 132 | String*30 | Contact Fax | E A X | Mask: (%-3C) %-3C-%-24C
VDEMAILC | 133 | String*50 | Contact E-mail | E A X |
DISCPCT | 134 | BCD*5.5 | Discount Percentage | E A X |
DISCOUNT | 135 | BCD*10.3 | Discount Amount | E A X |
VALUES | 136 | Long | Optional Fields | E A C X |
VERPRORATE | 137 | Integer | Proration Version | A X | List: 2 entries
1 | = | 3.0A
2 | = | 5.3B
HASRTG | 138 | Boolean | Has Retainage | A X | List: 2 entries
0 | = | No
1 | = | Yes
RTGRATE | 139 | Integer | Retainage Exchange Rate | A X | List: 2 entries
0 | = | Use Original Document Exchange Rate
1 | = | Use Current Exchange Rate
BTCODE | 140 | String*6 | Bill-To Location | E A X | Mask: %-6N
BTDESC | 141 | String*60 | Bill-To Location Description | E A X |
BTADDRESS1 | 142 | String*60 | Bill-To Address 1 | E A X |
BTADDRESS2 | 143 | String*60 | Bill-To Address 2 | E A X |
BTADDRESS3 | 144 | String*60 | Bill-To Address 3 | E A X |
BTADDRESS4 | 145 | String*60 | Bill-To Address 4 | E A X |
BTCITY | 146 | String*30 | Bill-To City | E A X |
BTSTATE | 147 | String*30 | Bill-To State/Province | E A X |
BTZIP | 148 | String*20 | Bill-To Zip/Postal Code | E A X |
BTCOUNTRY | 149 | String*30 | Bill-To Country | E A X |
BTPHONE | 150 | String*30 | Bill-To Phone Number | E A X | Mask: (%-3C) %-3C-%-24C
BTFAX | 151 | String*30 | Bill-To Fax Number | E A X | Mask: (%-3C) %-3C-%-24C
BTCONTACT | 152 | String*60 | Bill-To Contact | E A X |
STCODE | 153 | String*6 | Ship-To Location | E A X | Mask: %-6N
STDESC | 154 | String*60 | Ship-To Location Description | E A X |
STADDRESS1 | 155 | String*60 | Ship-To Address 1 | E A X |
STADDRESS2 | 156 | String*60 | Ship-To Address 2 | E A X |
STADDRESS3 | 157 | String*60 | Ship-To Address 3 | E A X |
STADDRESS4 | 158 | String*60 | Ship-To Address 4 | E A X |
STCITY | 159 | String*30 | Ship-To City | E A X |
STSTATE | 160 | String*30 | Ship-To State/Province | E A X |
STZIP | 161 | String*20 | Ship-To Zip/Postal Code | E A X |
STCOUNTRY | 162 | String*30 | Ship-To Country | E A X |
STPHONE | 163 | String*30 | Ship-To Phone Number | E A X | Mask: (%-3C) %-3C-%-24C
STFAX | 164 | String*30 | Ship-To Fax Number | E A X | Mask: (%-3C) %-3C-%-24C
STCONTACT | 165 | String*60 | Ship-To Contact | E A X |
PDRATE | 166 | BCD*8.7 | Predecessor's Exchange Rate | A X |
PDRATETYPE | 167 | String*2 | Predecessor's Rate Type | A X | Mask: %-2N
PDRATEDATE | 168 | Date | Predecessor's Rate Date | A X |
PDRATEOPER | 169 | Integer | Predecessor's Rate Operation | A X | List: 2 entries
1 | = | *
2 | = | /
PDRATEOVER | 170 | Boolean | Predecessor's Rate Overridden | A X | List: 2 entries
0 | = | No
1 | = | Yes
BTEMAIL | 171 | String*50 | Bill-To E-mail | E A X |
BTPHONEC | 172 | String*30 | Bill-To Contact Phone | E A X | Mask: (%-3C) %-3C-%-24C
BTFAXC | 173 | String*30 | Bill-To Contact Fax | E A X | Mask: (%-3C) %-3C-%-24C
BTEMAILC | 174 | String*50 | Bill-To Contact E-mail | E A X |
STEMAIL | 175 | String*50 | Ship-To E-mail | E A X |
STPHONEC | 176 | String*30 | Ship-To Contact Phone | E A X | Mask: (%-3C) %-3C-%-24C
STFAXC | 177 | String*30 | Ship-To Contact Fax | E A X | Mask: (%-3C) %-3C-%-24C
STEMAILC | 178 | String*50 | Ship-To Contact E-mail | E A X |
TAXCLASS1D | 180 | String*60 | Tax Class 1 Description | A C X |
TAXCLASS2D | 181 | String*60 | Tax Class 2 Description | A C X |
TAXCLASS3D | 182 | String*60 | Tax Class 3 Description | A C X |
TAXCLASS4D | 183 | String*60 | Tax Class 4 Description | A C X |
TAXCLASS5D | 184 | String*60 | Tax Class 5 Description | A C X |
TAXAUTH1D | 185 | String*60 | Tax Authority 1 Description | A C X |
TAXAUTH2D | 186 | String*60 | Tax Authority 2 Description | A C X |
TAXAUTH3D | 187 | String*60 | Tax Authority 3 Description | A C X |
TAXAUTH4D | 188 | String*60 | Tax Authority 4 Description | A C X |
TAXAUTH5D | 189 | String*60 | Tax Authority 5 Description | A C X |
CURRENCYD | 190 | String*60 | Currency Description | A C X |
RATETYPED | 191 | String*60 | Rate Type Description | A C X |
LASTRECEIP | 192 | String*22 | Last Receipt Number | A X | Mask: %-22C
RCPDATE | 193 | Date | Receipt Date | A X |
RCPCOUNT | 194 | Integer | Number of Posted Receipts | A X |
TAXGROUPD | 195 | String*60 | Tax Group Description | A C X |
TERMSCODED | 196 | String*60 | Terms Code Description | A C X |
PDRATETYPD | 197 | String*60 | Predecessor's Rate Type Descript | A C X |
TCBASEALLO | 198 | BCD*10.3 | Allocated Base Amount Sum | E A C X |
TCINCLUDE1 | 199 | BCD*10.3 | Tax Included 1 Sum | E A C X |
TCINCLUDE2 | 200 | BCD*10.3 | Tax Included 2 Sum | E A C X |
TCINCLUDE3 | 201 | BCD*10.3 | Tax Included 3 Sum | E A C X |
TCINCLUDE4 | 202 | BCD*10.3 | Tax Included 4 Sum | E A C X |
TCINCLUDE5 | 203 | BCD*10.3 | Tax Included 5 Sum | E A C X |
TCALLOAMT1 | 204 | BCD*10.3 | Tax Allocated Amount 1 Sum | E A C X |
TCALLOAMT2 | 205 | BCD*10.3 | Tax Allocated Amount 2 Sum | E A C X |
TCALLOAMT3 | 206 | BCD*10.3 | Tax Allocated Amount 3 Sum | E A C X |
TCALLOAMT4 | 207 | BCD*10.3 | Tax Allocated Amount 4 Sum | E A C X |
TCALLOAMT5 | 208 | BCD*10.3 | Tax Allocated Amount 5 Sum | E A C X |
TCRECVAMT1 | 209 | BCD*10.3 | Tax Recoverable Amount 1 Sum | E A C X |
TCRECVAMT2 | 210 | BCD*10.3 | Tax Recoverable Amount 2 Sum | E A C X |
TCRECVAMT3 | 211 | BCD*10.3 | Tax Recoverable Amount 3 Sum | E A C X |
TCRECVAMT4 | 212 | BCD*10.3 | Tax Recoverable Amount 4 Sum | E A C X |
TCRECVAMT5 | 213 | BCD*10.3 | Tax Recoverable Amount 5 Sum | E A C X |
TCEXPSAMT1 | 214 | BCD*10.3 | Tax Expense Amount 1 Sum | E A C X |
TCEXPSAMT2 | 215 | BCD*10.3 | Tax Expense Amount 2 Sum | E A C X |
TCEXPSAMT3 | 216 | BCD*10.3 | Tax Expense Amount 3 Sum | E A C X |
TCEXPSAMT4 | 217 | BCD*10.3 | Tax Expense Amount 4 Sum | E A C X |
TCEXPSAMT5 | 218 | BCD*10.3 | Tax Expense Amount 5 Sum | E A C X |
TCALLOAMT | 219 | BCD*10.3 | Total Tax Allocated | E A C X |
TCINCLUDED | 220 | BCD*10.3 | Tax Included | E A C X |
TCEXCLUDED | 221 | BCD*10.3 | Tax Excluded | E A C X |
UBALTAXAMT | 222 | BCD*10.3 | Total Unbalanced Tax | E A C X |
UBALTXALLO | 223 | BCD*10.3 | Total Unbalanced Allocated Tax | E A C X |
UBALPRORAT | 224 | BCD*10.3 | Unbalanced Manual Proration Amou | E A C X |
SUBTOTAL | 225 | BCD*10.3 | Subtotal | A C X |
PENDINGCAL | 226 | Boolean | Tax calculation is pending | A C X | List: 2 entries
0 | = | No
1 | = | Yes
LOCKED | 227 | Boolean | Document Locked | A C X | List: 2 entries
0 | = | No
1 | = | Yes
CANDELETE | 228 | Boolean | Is Document Deletable | A C X | List: 2 entries
0 | = | No
1 | = | Yes
RATEEXISTS | 229 | Boolean | Exchange Rate Exists | A C X | List: 2 entries
0 | = | No
1 | = | Yes
HASDETAILS | 230 | Boolean | Has Details | A C X | List: 2 entries
0 | = | No
1 | = | Yes
DISCOUNTC | 231 | BCD*10.3 | Discount Amount Sum | E A C X |
NETXTENDED | 232 | BCD*10.3 | Net Extended Cost | A C X |
POSTSEQNUM | 233 | Long | Day End Number | A C X |
RTGTERMS | 234 | String*6 | Retainage Terms Code | A X | Mask: %-6N
JOBLINES | 235 | Long | Job Related Lines | A C X |
JOBCOSTS | 236 | Long | Job Related Costs | E A C X |
BILLLINES | 237 | Long | Billable Lines | E A C X |
COSTSBLPRO | 238 | Long | Cost Billing Rates Prorated | E A C X |
PROCESSCMD | 239 | Integer | Command | E A C X | List: 6 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
RTGTERMSD | 240 | String*60 | Retainage Terms Code Description | A C X |
HASJOB | 241 | Boolean | Job Related | E A X | List: 2 entries
0 | = | No
1 | = | Yes
RTGBASE | 242 | Integer | Retainage Base | A X | List: 2 entries
0 | = | Total After Taxes
1 | = | Total Before Taxes
RTGAMOUNT | 243 | BCD*10.3 | Retainage Amount | E A C X |
URTDTOTAL | 244 | BCD*10.3 | Unretained Total | A C X |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.