View: Credit/Debit Notes

RotoID: PO0311
Tables: POCRNH1, POCRNH2
Protocol: Header, Key auto generate
DLL:POCRNH

Compositions: 7

RotoID Tables Title DLL
PO0309 POCRNC Credit/Debit Note Comments POCRNC
PO0315 POCRNL Credit/Debit Note Lines POCRNL
PO0320 POCRNS CR/DR Note Additional Costs POCRNS
PO0310 Credit/Debit Note Functions POCRNG
PO0325 POCRNS CR/DR Add. Costs Superview POCRNW
PO0314 POCRNHO Credit/Debit Note Opt. Fields POCRNHO
PO0326 POCRND CR/DR Note Cost Distributions POCRND

Keys: 6

Title Fields
Master Key CRNHSEQ
Credit/Debit Notes CRNNUMBER
Vendor VDCODE, CRNHSEQ
Return Sequence RETHSEQ
Invoice Sequence INVHSEQ
Vendor Document Number VDCODE, CRNNUMBER

Fields: 407

Field Index Type Title Attributes Presentation
CRNHSEQ 1 BCD*10.0 Credit/Debit Note Sequence Key E A K R 
NEXTLSEQ 2 BCD*10.0 Next Line Sequence A X 
LINES 3 Long Lines E A C X 
LINESCMPL 4 Long Lines Complete E A C X 
COSTS 5 Long Costs E A C X 
COSTSCMPL 6 Long Costs Complete E A C X 
TAXLINES 7 Long Lines Tax Calculation Sees E A C X 
EXTRANEOUS 8 Long Extraneous Line Count E A C X 
TAXAUTOCAL 9 Boolean Auto. tax calculation on save A C X  List:2 entries
0 = No
1 = Yes
ISCOMPLETE 10 Boolean Completed A C X  List:2 entries
0 = No
1 = Yes
DTCOMPLETE 11 Date Date Completed A X 
POSTDATE 12 Date Last Posting Date A C X 
PORHSEQ 13 BCD*10.0 Purchase Order Sequence Key E A X 
PONUMBER 14 String*22 Purchase Order Number E A X  Mask: %-22C
DATE 15 Date Credit/Debit Note Date E A X 
FISCYEAR 16 String*4 Fiscal Year A X  Mask: %4D
FISCPERIOD 17 Integer Fiscal Period A P X  List:12 entries
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
7 = 7
8 = 8
9 = 9
10 = 10
11 = 11
12 = 12
CRNNUMBER 18 String*22 Credit/Debit Note Number E A  Mask: %-22C
TRANSTYPE 19 Integer Transaction Type E A X  List:2 entries
6 = Credit Note
7 = Debit Note
FROMDOC 20 Integer From Document E A P X  List:2 entries
4 = Return
5 = Invoice
VDCODE 21 String*12 Vendor E A X  Mask: %-12C
VDEXISTS 22 Boolean Vendor Exists A C X  List:2 entries
0 = No
1 = Yes
VDNAME 23 String*60 Name E A X 
VDADDRESS1 24 String*60 Address 1 E A X 
VDADDRESS2 25 String*60 Address 2 E A X 
VDADDRESS3 26 String*60 Address 3 E A X 
VDADDRESS4 27 String*60 Address 4 E A X 
VDCITY 28 String*30 City E A X 
VDSTATE 29 String*30 State/Province E A X 
VDZIP 30 String*20 Zip/Postal Code E A X 
VDCOUNTRY 31 String*30 Country E A X 
VDPHONE 32 String*30 Phone Number E A X  Mask: (%-3C) %-3C-%-24C
VDFAX 33 String*30 Fax Number E A X  Mask: (%-3C) %-3C-%-24C
VDCONTACT 34 String*60 Contact E A X 
RCPHSEQ 35 BCD*10.0 Receipt Sequence Key A X 
RETHSEQ 36 BCD*10.0 Return Sequence Key E A X 
RETNUMBER 37 String*22 Return Number E A X  Mask: %-22C
RETDATE 38 Date Return Date A X 
INVHSEQ 39 BCD*10.0 Invoice Sequence Key E A X 
INVNUMBER 40 String*22 Invoice Number E A X  Mask: %-22C
INVDATE 41 Date Invoice Date A X 
DESCRIPTIO 42 String*60 Description E A X 
REFERENCE 43 String*60 Reference E A X 
COMMENT 44 String*250 Comment E A X 
CURRENCY 53 String*3 Currency E A X  Mask: %-3N
RATE 54 BCD*8.7 Exchange Rate A X 
SPREAD 55 BCD*8.7 Rate Spread A X 
RATETYPE 56 String*2 Rate Type A X  Mask: %-2N
RATEMATCH 57 Integer Rate Match Type A X 
RATEDATE 58 Date Rate Date A X 
RATEOPER 59 Integer Rate Operation A X  List:2 entries
1 = Multiply
2 = Divide
RATEOVER 60 Boolean Rate Overridden A X  List:2 entries
0 = No
1 = Yes
SCURNDECML 61 Integer Decimal Places A X 
EXTWEIGHT 62 BCD*10.4 Extended Weight E A C X 
EXTENDED 63 BCD*10.3 Extended Cost E A C X 
DOCTOTAL 64 BCD*10.3 Total A C X 
AMOUNT 65 BCD*10.3 Amount E A C X 
RQRETURNED 66 BCD*10.4 Quantity Returned E A C X 
TAXGROUP 67 String*12 Tax Group E A X  Mask: %-12N
TAXAUTH1 68 String*12 Tax Authority 1 A X  Mask: %-12N
TAXAUTH2 69 String*12 Tax Authority 2 A X  Mask: %-12N
TAXAUTH3 70 String*12 Tax Authority 3 A X  Mask: %-12N
TAXAUTH4 71 String*12 Tax Authority 4 A X  Mask: %-12N
TAXAUTH5 72 String*12 Tax Authority 5 A X  Mask: %-12N
TAXCLASS1 73 Integer Tax Class 1 E A X 
TAXCLASS2 74 Integer Tax Class 2 E A X 
TAXCLASS3 75 Integer Tax Class 3 E A X 
TAXCLASS4 76 Integer Tax Class 4 E A X 
TAXCLASS5 77 Integer Tax Class 5 E A X 
TAXBASE1 78 BCD*10.3 Tax Base 1 E A X 
TAXBASE2 79 BCD*10.3 Tax Base 2 E A X 
TAXBASE3 80 BCD*10.3 Tax Base 3 E A X 
TAXBASE4 81 BCD*10.3 Tax Base 4 E A X 
TAXBASE5 82 BCD*10.3 Tax Base 5 E A X 
TXINCLUDE1 83 BCD*10.3 Included Tax Amount 1 A X 
TXINCLUDE2 84 BCD*10.3 Included Tax Amount 2 A X 
TXINCLUDE3 85 BCD*10.3 Included Tax Amount 3 A X 
TXINCLUDE4 86 BCD*10.3 Included Tax Amount 4 A X 
TXINCLUDE5 87 BCD*10.3 Included Tax Amount 5 A X 
TXEXCLUDE1 88 BCD*10.3 Excluded Tax Amount 1 A X 
TXEXCLUDE2 89 BCD*10.3 Excluded Tax Amount 2 A X 
TXEXCLUDE3 90 BCD*10.3 Excluded Tax Amount 3 A X 
TXEXCLUDE4 91 BCD*10.3 Excluded Tax Amount 4 A X 
TXEXCLUDE5 92 BCD*10.3 Excluded Tax Amount 5 A X 
TAXAMOUNT1 93 BCD*10.3 Tax Amount 1 E A X 
TAXAMOUNT2 94 BCD*10.3 Tax Amount 2 E A X 
TAXAMOUNT3 95 BCD*10.3 Tax Amount 3 E A X 
TAXAMOUNT4 96 BCD*10.3 Tax Amount 4 E A X 
TAXAMOUNT5 97 BCD*10.3 Tax Amount 5 E A X 
TXRECVAMT1 98 BCD*10.3 Tax Recoverable Amount 1 A X 
TXRECVAMT2 99 BCD*10.3 Tax Recoverable Amount 2 A X 
TXRECVAMT3 100 BCD*10.3 Tax Recoverable Amount 3 A X 
TXRECVAMT4 101 BCD*10.3 Tax Recoverable Amount 4 A X 
TXRECVAMT5 102 BCD*10.3 Tax Recoverable Amount 5 A X 
TXEXPSAMT1 103 BCD*10.3 Tax Expense Amount 1 A X 
TXEXPSAMT2 104 BCD*10.3 Tax Expense Amount 2 A X 
TXEXPSAMT3 105 BCD*10.3 Tax Expense Amount 3 A X 
TXEXPSAMT4 106 BCD*10.3 Tax Expense Amount 4 A X 
TXEXPSAMT5 107 BCD*10.3 Tax Expense Amount 5 A X 
TXALLOAMT1 108 BCD*10.3 Tax Allocated Amount 1 A X 
TXALLOAMT2 109 BCD*10.3 Tax Allocated Amount 2 A X 
TXALLOAMT3 110 BCD*10.3 Tax Allocated Amount 3 A X 
TXALLOAMT4 111 BCD*10.3 Tax Allocated Amount 4 A X 
TXALLOAMT5 112 BCD*10.3 Tax Allocated Amount 5 A X 
TXBASEALLO 113 BCD*10.3 Net of Tax A X 
TXINCLUDED 114 BCD*10.3 Tax Included A C X 
TXEXCLUDED 115 BCD*10.3 Tax Excluded A C X 
TAXAMOUNT 116 BCD*10.3 Total Tax A C X 
TXRECVAMT 117 BCD*10.3 Total Tax Recoverable A X 
TXEXPSAMT 118 BCD*10.3 Total Tax Expensed A X 
TXALLOAMT 119 BCD*10.3 Total Tax Allocated A X 
F1099CLASS 120 String*6 1099/CPRS Class E A X  Mask: %-6N
F1099AMT 121 BCD*10.3 The 1099/CPRS Amount E A X 
MPRORATED 122 BCD*10.3 Manual Proration Total E A C X 
MTOPRORATE 123 BCD*10.3 Manual To Prorate E A C X 
SCAMOUNT 124 BCD*10.3 Conversion Source Amount A C X 
FCAMOUNT 125 BCD*10.3 Conversion Functional Amount A C X 
BTCODE 131 String*6 Bill-To Location E A X  Mask: %-6N
BTDESC 132 String*60 Bill-To Location Description E A X 
BTADDRESS1 133 String*60 Bill-To Address 1 E A X 
BTADDRESS2 134 String*60 Bill-To Address 2 E A X 
BTADDRESS3 135 String*60 Bill-To Address 3 E A X 
BTADDRESS4 136 String*60 Bill-To Address 4 E A X 
BTCITY 137 String*30 Bill-To City E A X 
BTSTATE 138 String*30 Bill-To State/Province E A X 
BTZIP 139 String*20 Bill-To Zip/Postal Code E A X 
BTCOUNTRY 140 String*30 Bill-To Country E A X 
BTPHONE 141 String*30 Bill-To Phone Number E A X  Mask: (%-3C) %-3C-%-24C
BTFAX 142 String*30 Bill-To Fax Number E A X  Mask: (%-3C) %-3C-%-24C
BTCONTACT 143 String*60 Bill-To Contact E A X 
STCODE 144 String*6 Ship-To Location E A X  Mask: %-6N
STDESC 145 String*60 Ship-To Location Description E A X 
STADDRESS1 146 String*60 Ship-To Address 1 E A X 
STADDRESS2 147 String*60 Ship-To Address 2 E A X 
STADDRESS3 148 String*60 Ship-To Address 3 E A X 
STADDRESS4 149 String*60 Ship-To Address 4 E A X 
STCITY 150 String*30 Ship-To City E A X 
STSTATE 151 String*30 Ship-To State/Province E A X 
STZIP 152 String*20 Ship-To Zip/Postal Code E A X 
STCOUNTRY 153 String*30 Ship-To Country E A X 
STPHONE 154 String*30 Ship-To Phone Number E A X  Mask: (%-3C) %-3C-%-24C
STFAX 155 String*30 Ship-To Fax Number E A X  Mask: (%-3C) %-3C-%-24C
STCONTACT 156 String*60 Ship-To Contact E A X 
RTCODE 157 String*6 Remit-To Location E A X  Mask: %-6N
RTDESC 158 String*60 Remit-To Location Description A X 
RTADDRESS1 159 String*60 Remit-To Address 1 A X 
RTADDRESS2 160 String*60 Remit-To Address 2 A X 
RTADDRESS3 161 String*60 Remit-To Address 3 A X 
RTADDRESS4 162 String*60 Remit-To Address 4 A X 
RTCITY 163 String*30 Remit-To City A X 
RTSTATE 164 String*30 Remit-To State/Province A X 
RTZIP 165 String*20 Remit-To Zip/Postal Code A X 
RTCOUNTRY 166 String*30 Remit-To Country A X 
RTPHONE 167 String*30 Remit-To Phone Number A X  Mask: (%-3C) %-3C-%-24C
RTFAX 168 String*30 Remit-To Fax Number A X  Mask: (%-3C) %-3C-%-24C
RTCONTACT 169 String*60 Remit-To Contact A X 
PDRATE 170 BCD*8.7 Predecessor's Exchange Rate A X 
PDRATETYPE 171 String*2 Predecessor's Rate Type A X  Mask: %-2N
PDRATEDATE 172 Date Predecessor's Rate Date A X 
PDRATEOPER 173 Integer Predecessor's Rate Operation A X  List:2 entries
1 = Multiply
2 = Divide
PDRATEOVER 174 Boolean Predecessor's Rate Overridden A X  List:2 entries
0 = No
1 = Yes
TAXCLASS1D 181 String*60 Tax Class 1 Description A C X 
TAXCLASS2D 182 String*60 Tax Class 2 Description A C X 
TAXCLASS3D 183 String*60 Tax Class 3 Description A C X 
TAXCLASS4D 184 String*60 Tax Class 4 Description A C X 
TAXCLASS5D 185 String*60 Tax Class 5 Description A C X 
TAXAUTH1D 186 String*60 Tax Authority 1 Description A C X 
TAXAUTH2D 187 String*60 Tax Authority 2 Description A C X 
TAXAUTH3D 188 String*60 Tax Authority 3 Description A C X 
TAXAUTH4D 189 String*60 Tax Authority 4 Description A C X 
TAXAUTH5D 190 String*60 Tax Authority 5 Description A C X 
CURRENCYD 191 String*60 Currency Description A C X 
RATETYPED 192 String*60 Rate Type Description A C X 
TAXGROUPD 193 String*60 Tax Group Description A C X 
PDRATETYPD 194 String*60 Predecessor's Rate Type Description A C X 
TCBASEALLO 195 BCD*10.3 Net of Tax Sum E A C X 
TCINCLUDE1 196 BCD*10.3 Tax Included 1 Sum E A C X 
TCINCLUDE2 197 BCD*10.3 Tax Included 2 Sum E A C X 
TCINCLUDE3 198 BCD*10.3 Tax Included 3 Sum E A C X 
TCINCLUDE4 199 BCD*10.3 Tax Included 4 Sum E A C X 
TCINCLUDE5 200 BCD*10.3 Tax Included 5 Sum E A C X 
TCALLOAMT1 201 BCD*10.3 Tax Allocated Amount 1 Sum E A C X 
TCALLOAMT2 202 BCD*10.3 Tax Allocated Amount 2 Sum E A C X 
TCALLOAMT3 203 BCD*10.3 Tax Allocated Amount 3 Sum E A C X 
TCALLOAMT4 204 BCD*10.3 Tax Allocated Amount 4 Sum E A C X 
TCALLOAMT5 205 BCD*10.3 Tax Allocated Amount 5 Sum E A C X 
TCRECVAMT1 206 BCD*10.3 Tax Recoverable Amount 1 Sum E A C X 
TCRECVAMT2 207 BCD*10.3 Tax Recoverable Amount 2 Sum E A C X 
TCRECVAMT3 208 BCD*10.3 Tax Recoverable Amount 3 Sum E A C X 
TCRECVAMT4 209 BCD*10.3 Tax Recoverable Amount 4 Sum E A C X 
TCRECVAMT5 210 BCD*10.3 Tax Recoverable Amount 5 Sum E A C X 
TCEXPSAMT1 211 BCD*10.3 Tax Expense Amount 1 Sum E A C X 
TCEXPSAMT2 212 BCD*10.3 Tax Expense Amount 2 Sum E A C X 
TCEXPSAMT3 213 BCD*10.3 Tax Expense Amount 3 Sum E A C X 
TCEXPSAMT4 214 BCD*10.3 Tax Expense Amount 4 Sum E A C X 
TCEXPSAMT5 215 BCD*10.3 Tax Expense Amount 5 Sum E A C X 
TCALLOAMT 216 BCD*10.3 Total Tax Allocated E A C X 
TCINCLUDED 217 BCD*10.3 Tax Included E A C X 
TCEXCLUDED 218 BCD*10.3 Tax Excluded E A C X 
UBALTAXAMT 219 BCD*10.3 Total Unbalanced Tax E A C X 
UBALTXALLO 220 BCD*10.3 Total Unbalanced Allocated Tax E A C X 
UBALPRORAT 221 BCD*10.3 Unbalanced Manual Proration Amount E A C X 
CRNTOTAL 222 BCD*10.3 Credit/Debit Note Total E A X 
SUBTOTAL 223 BCD*10.3 Subtotal A C X 
PENDINGCAL 224 Boolean Tax calculation is pending A C X  List:2 entries
0 = No
1 = Yes
USE1099 225 Boolean Subject to 1099/CPRS Reporting A C X  List:2 entries
0 = No
1 = Yes
LOCKED 226 Boolean Document Locked A C X  List:2 entries
0 = No
1 = Yes
CANDELETE 227 Boolean Is Document Deletable A C X  List:2 entries
0 = No
1 = Yes
RATEEXISTS 228 Boolean Exchange Rate Exists A C X  List:2 entries
0 = No
1 = Yes
HASDETAILS 229 Boolean Has Details A C X  List:2 entries
0 = No
1 = Yes
COSTGRPS 230 Long Number of Cost Groups A C X 
VDEMAIL 231 String*50 E-mail E A X 
VDPHONEC 232 String*30 Contact Phone E A X  Mask: (%-3C) %-3C-%-24C
VDFAXC 233 String*30 Contact Fax E A X  Mask: (%-3C) %-3C-%-24C
VDEMAILC 234 String*50 Contact E-mail E A X 
BTEMAIL 235 String*50 Bill-To E-mail E A X 
BTPHONEC 236 String*30 Bill-To Contact Phone E A X  Mask: (%-3C) %-3C-%-24C
BTFAXC 237 String*30 Bill-To Contact Fax E A X  Mask: (%-3C) %-3C-%-24C
BTEMAILC 238 String*50 Bill-To Contact E-mail E A X 
STEMAIL 239 String*50 Ship-To E-mail E A X 
STPHONEC 240 String*30 Ship-To Contact Phone E A X  Mask: (%-3C) %-3C-%-24C
STFAXC 241 String*30 Ship-To Contact Fax E A X  Mask: (%-3C) %-3C-%-24C
STEMAILC 242 String*50 Ship-To Contact E-mail E A X 
RTEMAIL 243 String*50 Remit-To E-mail A X 
RTPHONEC 244 String*30 Remit-To Contact Phone A X  Mask: (%-3C) %-3C-%-24C
RTFAXC 245 String*30 Remit-To Contact Fax A X  Mask: (%-3C) %-3C-%-24C
RTEMAILC 246 String*50 Remit-To Contact E-mail A X 
DISCPCT 247 BCD*5.5 Discount Percentage E A X 
DISCOUNT 248 BCD*10.3 Discount Amount E A X 
DISCOUNTC 249 BCD*10.3 Discount Amount Sum E A C X 
NETXTENDED 250 BCD*10.3 Net Extended Cost A C X 
VALUES 251 Long Optional Fields E A C X 
PROCESSCMD 252 Integer Command E 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
ONHOLD 253 Boolean On Hold E A X  List:2 entries
0 = No
1 = Yes
VERPRORATE 254 Integer Proration Version A X  List:2 entries
1 = 3.0A
2 = 5.3B
HASRTG 255 Boolean Has Retainage A X  List:2 entries
0 = No
1 = Yes
RTGRATE 256 Integer Retainage Exchange Rate A X  List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGBASE 257 Integer Retainage Base A X  List:2 entries
0 = Total After Taxes
1 = Total Before Taxes
RTGAMOUNT 258 BCD*10.3 Retainage Amount E A C X 
JOBLINES 259 Long Job Related Lines A C X 
JOBCOSTS 260 Long Job Related Costs E A C X 
HASJOB 261 Boolean Job Related E A X  List:2 entries
0 = No
1 = Yes
URTDTOTAL 262 BCD*10.3 Unretained Total A C X 
TRCURRENCY 263 String*3 Tax Reporting Currency A X  Mask: %-3N
RATERC 264 BCD*8.7 Tax Reporting Exchange Rate A X 
SPREADRC 265 BCD*8.7 Tax Reporting Rate Spread A X 
RATETYPERC 266 String*2 Tax Reporting Rate Type A X  Mask: %-2N
RATEMTCHRC 267 Integer Tax Reporting Rate Match Type A X 
RATEDATERC 268 Date Tax Reporting Rate Date A X 
RATEOPERRC 269 Integer Tax Reporting Rate Operation A X  List:2 entries
1 = Multiply
2 = Divide
RATERCOVER 270 Boolean Tax Reporting Rate Overridden A X  List:2 entries
0 = No
1 = Yes
RCURNDECML 271 Integer Tax Reporting Decimal Places A X 
TARAMOUNT1 272 BCD*10.3 Tax Reporting Amount 1 A X 
TARAMOUNT2 273 BCD*10.3 Tax Reporting Amount 2 A X 
TARAMOUNT3 274 BCD*10.3 Tax Reporting Amount 3 A X 
TARAMOUNT4 275 BCD*10.3 Tax Reporting Amount 4 A X 
TARAMOUNT5 276 BCD*10.3 Tax Reporting Amount 5 A X 
TRINCLUDE1 277 BCD*10.3 Tax Reporting Included Amount 1 A X 
TRINCLUDE2 278 BCD*10.3 Tax Reporting Included Amount 2 A X 
TRINCLUDE3 279 BCD*10.3 Tax Reporting Included Amount 3 A X 
TRINCLUDE4 280 BCD*10.3 Tax Reporting Included Amount 4 A X 
TRINCLUDE5 281 BCD*10.3 Tax Reporting Included Amount 5 A X 
TREXCLUDE1 282 BCD*10.3 Tax Reporting Excluded Amount 1 A X 
TREXCLUDE2 283 BCD*10.3 Tax Reporting Excluded Amount 2 A X 
TREXCLUDE3 284 BCD*10.3 Tax Reporting Excluded Amount 3 A X 
TREXCLUDE4 285 BCD*10.3 Tax Reporting Excluded Amount 4 A X 
TREXCLUDE5 286 BCD*10.3 Tax Reporting Excluded Amount 5 A X 
TRRECVAMT1 287 BCD*10.3 Tax Reporting Recoverable Amt. 1 A X 
TRRECVAMT2 288 BCD*10.3 Tax Reporting Recoverable Amt. 2 A X 
TRRECVAMT3 289 BCD*10.3 Tax Reporting Recoverable Amt. 3 A X 
TRRECVAMT4 290 BCD*10.3 Tax Reporting Recoverable Amt. 4 A X 
TRRECVAMT5 291 BCD*10.3 Tax Reporting Recoverable Amt. 5 A X 
TREXPSAMT1 292 BCD*10.3 Tax Reporting Expense Amount 1 A X 
TREXPSAMT2 293 BCD*10.3 Tax Reporting Expense Amount 2 A X 
TREXPSAMT3 294 BCD*10.3 Tax Reporting Expense Amount 3 A X 
TREXPSAMT4 295 BCD*10.3 Tax Reporting Expense Amount 4 A X 
TREXPSAMT5 296 BCD*10.3 Tax Reporting Expense Amount 5 A X 
TRALLOAMT1 297 BCD*10.3 Tax Reporting Allocated Amount 1 A X 
TRALLOAMT2 298 BCD*10.3 Tax Reporting Allocated Amount 2 A X 
TRALLOAMT3 299 BCD*10.3 Tax Reporting Allocated Amount 3 A X 
TRALLOAMT4 300 BCD*10.3 Tax Reporting Allocated Amount 4 A X 
TRALLOAMT5 301 BCD*10.3 Tax Reporting Allocated Amount 5 A X 
PDRATERC 302 BCD*8.7 Pred. Tax Reporting Exch. Rate A X 
PDRATTYPRC 303 String*2 Pred. Tax Reporting Rate Type A X  Mask: %-2N
PDRATEDTRC 304 Date Pred. Tax Reporting Rate Date A X 
PDRATEOPRC 305 Integer Pred. Tax Reporting Rate Oper. A X  List:2 entries
1 = Multiply
2 = Divide
PDRATERCOV 306 Boolean Pred. Tax Reporting Rate Overrd. A X  List:2 entries
0 = No
1 = Yes
RATERCEXST 307 Boolean Tax Reporting Exch. Rate Exists A C X  List:2 entries
0 = No
1 = Yes
RATERCC 308 BCD*8.7 Derived Tax Reporting Exch. Rate A C X 
TRCURRDESC 309 String*60 Tax Reporting Currency Desc. A C X 
RATETYPRCD 310 String*60 Tax Reporting Rate Type Desc. A C X 
PDRATTPRCD 311 String*60 Pred. Tax Rep. Rate Type Desc. A C X 
TARAMOUNT 312 BCD*10.3 Tax Reporting Total Amount A X 
TRINCLUDED 313 BCD*10.3 Tax Reporting Included Amount A X 
TREXCLUDED 314 BCD*10.3 Tax Reporting Excluded Amount A X 
TRRECVAMT 315 BCD*10.3 Tax Reporting Recoverable Amount A X 
TREXPSAMT 316 BCD*10.3 Tax Reporting Expensed Amount A X 
TRALLOAMT 317 BCD*10.3 Tax Reporting Allocated Amount A X 
TACBASE1 318 BCD*10.3 Tax Base 1 Sum E A C X 
TACBASE2 319 BCD*10.3 Tax Base 2 Sum E A C X 
TACBASE3 320 BCD*10.3 Tax Base 3 Sum E A C X 
TACBASE4 321 BCD*10.3 Tax Base 4 Sum E A C X 
TACBASE5 322 BCD*10.3 Tax Base 5 Sum E A C X 
TACAMOUNT1 323 BCD*10.3 Tax Amount 1 Sum E A C X 
TACAMOUNT2 324 BCD*10.3 Tax Amount 2 Sum E A C X 
TACAMOUNT3 325 BCD*10.3 Tax Amount 3 Sum E A C X 
TACAMOUNT4 326 BCD*10.3 Tax Amount 4 Sum E A C X 
TACAMOUNT5 327 BCD*10.3 Tax Amount 5 Sum E A C X 
TCEXCLUDE1 328 BCD*10.3 Tax Excluded 1 Sum E A C X 
TCEXCLUDE2 329 BCD*10.3 Tax Excluded 2 Sum E A C X 
TCEXCLUDE3 330 BCD*10.3 Tax Excluded 3 Sum E A C X 
TCEXCLUDE4 331 BCD*10.3 Tax Excluded 4 Sum E A C X 
TCEXCLUDE5 332 BCD*10.3 Tax Excluded 5 Sum E A C X 
TALAMOUNT1 333 BCD*10.3 Tax Reporting Amount 1 Sum E A C X 
TALAMOUNT2 334 BCD*10.3 Tax Reporting Amount 2 Sum E A C X 
TALAMOUNT3 335 BCD*10.3 Tax Reporting Amount 3 Sum E A C X 
TALAMOUNT4 336 BCD*10.3 Tax Reporting Amount 4 Sum E A C X 
TALAMOUNT5 337 BCD*10.3 Tax Reporting Amount 5 Sum E A C X 
TLINCLUDE1 338 BCD*10.3 Tax Reporting Included 1 Sum E A C X 
TLINCLUDE2 339 BCD*10.3 Tax Reporting Included 2 Sum E A C X 
TLINCLUDE3 340 BCD*10.3 Tax Reporting Included 3 Sum E A C X 
TLINCLUDE4 341 BCD*10.3 Tax Reporting Included 4 Sum E A C X 
TLINCLUDE5 342 BCD*10.3 Tax Reporting Included 5 Sum E A C X 
TLEXCLUDE1 343 BCD*10.3 Tax Reporting Excluded 1 Sum E A C X 
TLEXCLUDE2 344 BCD*10.3 Tax Reporting Excluded 2 Sum E A C X 
TLEXCLUDE3 345 BCD*10.3 Tax Reporting Excluded 3 Sum E A C X 
TLEXCLUDE4 346 BCD*10.3 Tax Reporting Excluded 4 Sum E A C X 
TLEXCLUDE5 347 BCD*10.3 Tax Reporting Excluded 5 Sum E A C X 
TLALLOAMT1 348 BCD*10.3 Tax Rep. Allocated Amount 1 Sum E A C X 
TLALLOAMT2 349 BCD*10.3 Tax Rep. Allocated Amount 2 Sum E A C X 
TLALLOAMT3 350 BCD*10.3 Tax Rep. Allocated Amount 3 Sum E A C X 
TLALLOAMT4 351 BCD*10.3 Tax Rep. Allocated Amount 4 Sum E A C X 
TLALLOAMT5 352 BCD*10.3 Tax Rep. Allocated Amount 5 Sum E A C X 
TLRECVAMT1 353 BCD*10.3 Tax Rep. Recoverable Amt. 1 Sum E A C X 
TLRECVAMT2 354 BCD*10.3 Tax Rep. Recoverable Amt. 2 Sum E A C X 
TLRECVAMT3 355 BCD*10.3 Tax Rep. Recoverable Amt. 3 Sum E A C X 
TLRECVAMT4 356 BCD*10.3 Tax Rep. Recoverable Amt. 4 Sum E A C X 
TLRECVAMT5 357 BCD*10.3 Tax Rep. Recoverable Amt. 5 Sum E A C X 
TLEXPSAMT1 358 BCD*10.3 Tax Rep. Expense Amount 1 Sum E A C X 
TLEXPSAMT2 359 BCD*10.3 Tax Rep. Expense Amount 2 Sum E A C X 
TLEXPSAMT3 360 BCD*10.3 Tax Rep. Expense Amount 3 Sum E A C X 
TLEXPSAMT4 361 BCD*10.3 Tax Rep. Expense Amount 4 Sum E A C X 
TLEXPSAMT5 362 BCD*10.3 Tax Rep. Expense Amount 5 Sum E A C X 
RTGTAXREP 363 Integer Report Retainage Tax A X  List:2 entries
0 = At Time of Original Document
1 = As Per Tax Authority
TAXVERSION 364 Long Tax State Version A X 
RAXBASE1 365 BCD*10.3 Retainage Tax Base 1 A X 
RAXBASE2 366 BCD*10.3 Retainage Tax Base 2 A X 
RAXBASE3 367 BCD*10.3 Retainage Tax Base 3 A X 
RAXBASE4 368 BCD*10.3 Retainage Tax Base 4 A X 
RAXBASE5 369 BCD*10.3 Retainage Tax Base 5 A X 
RAXAMOUNT1 370 BCD*10.3 Retainage Tax Amount 1 A X 
RAXAMOUNT2 371 BCD*10.3 Retainage Tax Amount 2 A X 
RAXAMOUNT3 372 BCD*10.3 Retainage Tax Amount 3 A X 
RAXAMOUNT4 373 BCD*10.3 Retainage Tax Amount 4 A X 
RAXAMOUNT5 374 BCD*10.3 Retainage Tax Amount 5 A X 
RXRECVAMT1 375 BCD*10.3 Retainage Tax Recoverable Amt. 1 A X 
RXRECVAMT2 376 BCD*10.3 Retainage Tax Recoverable Amt. 2 A X 
RXRECVAMT3 377 BCD*10.3 Retainage Tax Recoverable Amt. 3 A X 
RXRECVAMT4 378 BCD*10.3 Retainage Tax Recoverable Amt. 4 A X 
RXRECVAMT5 379 BCD*10.3 Retainage Tax Recoverable Amt. 5 A X 
RXEXPSAMT1 380 BCD*10.3 Retainage Tax Expense Amount 1 A X 
RXEXPSAMT2 381 BCD*10.3 Retainage Tax Expense Amount 2 A X 
RXEXPSAMT3 382 BCD*10.3 Retainage Tax Expense Amount 3 A X 
RXEXPSAMT4 383 BCD*10.3 Retainage Tax Expense Amount 4 A X 
RXEXPSAMT5 384 BCD*10.3 Retainage Tax Expense Amount 5 A X 
RXALLOAMT1 385 BCD*10.3 Retainage Tax Allocated Amount 1 A X 
RXALLOAMT2 386 BCD*10.3 Retainage Tax Allocated Amount 2 A X 
RXALLOAMT3 387 BCD*10.3 Retainage Tax Allocated Amount 3 A X 
RXALLOAMT4 388 BCD*10.3 Retainage Tax Allocated Amount 4 A X 
RXALLOAMT5 389 BCD*10.3 Retainage Tax Allocated Amount 5 A X 
RTGTXSHIFT 390 Boolean Warn On Retainage Tax Shift A C X  List:2 entries
0 = No
1 = Yes
RAXAMOUNT 391 BCD*10.3 Retainage Tax Total Amount A X 
TXRXAMT1 392 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 1 A X 
TXRXAMT2 393 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 2 A X 
TXRXAMT3 394 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 3 A X 
TXRXAMT4 395 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 4 A X 
TXRXAMT5 396 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 5 A X 
RACBASE1 397 BCD*10.3 Retainage Tax Base 1 Sum E A C X 
RACBASE2 398 BCD*10.3 Retainage Tax Base 2 Sum E A C X 
RACBASE3 399 BCD*10.3 Retainage Tax Base 3 Sum E A C X 
RACBASE4 400 BCD*10.3 Retainage Tax Base 4 Sum E A C X 
RACBASE5 401 BCD*10.3 Retainage Tax Base 5 Sum E A C X 
RACAMOUNT1 402 BCD*10.3 Retainage Tax Amount 1 Sum E A C X 
RACAMOUNT2 403 BCD*10.3 Retainage Tax Amount 2 Sum E A C X 
RACAMOUNT3 404 BCD*10.3 Retainage Tax Amount 3 Sum E A C X 
RACAMOUNT4 405 BCD*10.3 Retainage Tax Amount 4 Sum E A C X 
RACAMOUNT5 406 BCD*10.3 Retainage Tax Amount 5 Sum E A C X 
RCRECVAMT1 407 BCD*10.3 Rtg. Tax Recoverable Amt. 1 Sum E A C X 
RCRECVAMT2 408 BCD*10.3 Rtg. Tax Recoverable Amt. 2 Sum E A C X 
RCRECVAMT3 409 BCD*10.3 Rtg. Tax Recoverable Amt. 3 Sum E A C X 
RCRECVAMT4 410 BCD*10.3 Rtg. Tax Recoverable Amt. 4 Sum E A C X 
RCRECVAMT5 411 BCD*10.3 Rtg. Tax Recoverable Amt. 5 Sum E A C X 
RCEXPSAMT1 412 BCD*10.3 Rtg. Tax Expense Amount 1 Sum E A C X 
RCEXPSAMT2 413 BCD*10.3 Rtg. Tax Expense Amount 2 Sum E A C X 
RCEXPSAMT3 414 BCD*10.3 Rtg. Tax Expense Amount 3 Sum E A C X 
RCEXPSAMT4 415 BCD*10.3 Rtg. Tax Expense Amount 4 Sum E A C X 
RCEXPSAMT5 416 BCD*10.3 Rtg. Tax Expense Amount 5 Sum E A C X 
RCALLOAMT1 417 BCD*10.3 Rtg. Tax Allocated Amount 1 Sum E A C X 
RCALLOAMT2 418 BCD*10.3 Rtg. Tax Allocated Amount 2 Sum E A C X 
RCALLOAMT3 419 BCD*10.3 Rtg. Tax Allocated Amount 3 Sum E A C X 
RCALLOAMT4 420 BCD*10.3 Rtg. Tax Allocated Amount 4 Sum E A C X 
RCALLOAMT5 421 BCD*10.3 Rtg. Tax Allocated Amount 5 Sum E A C X 
VDACCTSET 422 String*6 Vendor Account Set E A X  Mask: %-6N
VDACCTDESC 423 String*60 Vendor Account Set Description A X 
DATEBUS 424 Date Posting Date E A X 
ENTEREDBY 425 String*8 Entered By A X 
DETAILNEXT 426 Integer Next Detail Number A X 

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