View: Invoices

RotoID: PO0420
Tables: POINVH1, POINVH2
Protocol: Header, Key auto generate
DLL:POINVH

Compositions: 9

RotoID Tables Title DLL
PO0416 POINVC Invoice Comments POINVC
PO0430 POINVL Invoice Lines POINVL
PO0440 POINVS Invoice Additional Costs POINVS
PO0436 POINVP Invoice Payment Schedules POINVP
PO0419 Invoice Functions POINVG
PO0438 POINVR Invoice Receipts POINVR
PO0444 POINVS Inv. Add. Costs Superview POINVW
PO0423 POINVHO Invoice Optional Fields POINVHO
PO0415 POINVD Invoice Cost Distributions POINVD

Keys: 7

Title Fields
Master Key INVHSEQ
Invoices INVNUMBER
Receipts RCPNUMBER
Vendor VDCODE, INVHSEQ
Returns RETNUMBER
Receipt Sequence RCPHSEQ
Vendor Document Number VDCODE, INVNUMBER

Fields: 442

Field Index Type Title Attributes Presentation
INVHSEQ 1 BCD*10.0 Invoice 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 
PAYMENTS 7 Long Payments E A C X 
TAXLINES 8 Long Lines Tax Calculation Sees 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 A C X  Mask: %-22C
DATE 15 Date Invoice 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
INVNUMBER 18 String*22 Invoice Number E A X  Mask: %-22C
VDCODE 19 String*12 Vendor E A X  Mask: %-12C
VDEXISTS 20 Boolean Vendor Exists A C X  List:2 entries
0 = No
1 = Yes
VDNAME 21 String*60 Name E A X 
VDADDRESS1 22 String*60 Address 1 E A X 
VDADDRESS2 23 String*60 Address 2 E A X 
VDADDRESS3 24 String*60 Address 3 E A X 
VDADDRESS4 25 String*60 Address 4 E A X 
VDCITY 26 String*30 City E A X 
VDSTATE 27 String*30 State/Province E A X 
VDZIP 28 String*20 Zip/Postal Code E A X 
VDCOUNTRY 29 String*30 Country E A X 
VDPHONE 30 String*30 Phone Number E A X  Mask: (%-3C) %-3C-%-24C
VDFAX 31 String*30 Fax Number E A X  Mask: (%-3C) %-3C-%-24C
VDCONTACT 32 String*60 Contact E A X 
TERMSCODE 33 String*6 Terms Code E A X  Mask: %-6N
FROMDOC 34 Integer From Document E A X  List:2 entries
3 = Receipt
4 = Return
FORPRIMARY 35 Integer Primary Vendor A C X  List:3 entries
1 = Primary Vendor
2 = Secondary Vendor
3 = New Vendor
RCPHSEQ 36 BCD*10.0 Receipt Sequence Key E A X 
RCPNUMBER 37 String*22 Receipt Number E A X  Mask: %-22C
RCPDATE 38 Date Receipt Date A X 
RETHSEQ 39 BCD*10.0 Return Sequence Key E A X 
RETNUMBER 40 String*22 Return Number E A X  Mask: %-22C
RETDATE 41 Date Return 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 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 
DTPYMTASOF 62 Date Payment As Of Date E A X 
TERMDUEAMT 63 BCD*10.3 Total Terms Amount Due E A C X 
EXTWEIGHT 64 BCD*10.4 Extended Weight E A C X 
EXTENDED 65 BCD*10.3 Extended Cost E A C X 
DOCTOTAL 66 BCD*10.3 Total A C X 
AMOUNT 67 BCD*10.3 Additional Costs E A C X 
RQRECEIVED 68 BCD*10.4 Quantity Received E A C X 
TAXGROUP 69 String*12 Tax Group E A X  Mask: %-12N
TAXAUTH1 70 String*12 Tax Authority 1 A X  Mask: %-12N
TAXAUTH2 71 String*12 Tax Authority 2 A X  Mask: %-12N
TAXAUTH3 72 String*12 Tax Authority 3 A X  Mask: %-12N
TAXAUTH4 73 String*12 Tax Authority 4 A X  Mask: %-12N
TAXAUTH5 74 String*12 Tax Authority 5 A X  Mask: %-12N
TAXCLASS1 75 Integer Tax Class 1 E A X 
TAXCLASS2 76 Integer Tax Class 2 E A X 
TAXCLASS3 77 Integer Tax Class 3 E A X 
TAXCLASS4 78 Integer Tax Class 4 E A X 
TAXCLASS5 79 Integer Tax Class 5 E A X 
TAXBASE1 80 BCD*10.3 Tax Base 1 E A X 
TAXBASE2 81 BCD*10.3 Tax Base 2 E A X 
TAXBASE3 82 BCD*10.3 Tax Base 3 E A X 
TAXBASE4 83 BCD*10.3 Tax Base 4 E A X 
TAXBASE5 84 BCD*10.3 Tax Base 5 E A X 
TXINCLUDE1 85 BCD*10.3 Included Tax Amount 1 A X 
TXINCLUDE2 86 BCD*10.3 Included Tax Amount 2 A X 
TXINCLUDE3 87 BCD*10.3 Included Tax Amount 3 A X 
TXINCLUDE4 88 BCD*10.3 Included Tax Amount 4 A X 
TXINCLUDE5 89 BCD*10.3 Included Tax Amount 5 A X 
TXEXCLUDE1 90 BCD*10.3 Excluded Tax Amount 1 A X 
TXEXCLUDE2 91 BCD*10.3 Excluded Tax Amount 2 A X 
TXEXCLUDE3 92 BCD*10.3 Excluded Tax Amount 3 A X 
TXEXCLUDE4 93 BCD*10.3 Excluded Tax Amount 4 A X 
TXEXCLUDE5 94 BCD*10.3 Excluded Tax Amount 5 A X 
TAXAMOUNT1 95 BCD*10.3 Tax Amount 1 E A X 
TAXAMOUNT2 96 BCD*10.3 Tax Amount 2 E A X 
TAXAMOUNT3 97 BCD*10.3 Tax Amount 3 E A X 
TAXAMOUNT4 98 BCD*10.3 Tax Amount 4 E A X 
TAXAMOUNT5 99 BCD*10.3 Tax Amount 5 E A X 
TXRECVAMT1 100 BCD*10.3 Tax Recoverable Amount 1 A X 
TXRECVAMT2 101 BCD*10.3 Tax Recoverable Amount 2 A X 
TXRECVAMT3 102 BCD*10.3 Tax Recoverable Amount 3 A X 
TXRECVAMT4 103 BCD*10.3 Tax Recoverable Amount 4 A X 
TXRECVAMT5 104 BCD*10.3 Tax Recoverable Amount 5 A X 
TXEXPSAMT1 105 BCD*10.3 Tax Expense Amount 1 A X 
TXEXPSAMT2 106 BCD*10.3 Tax Expense Amount 2 A X 
TXEXPSAMT3 107 BCD*10.3 Tax Expense Amount 3 A X 
TXEXPSAMT4 108 BCD*10.3 Tax Expense Amount 4 A X 
TXEXPSAMT5 109 BCD*10.3 Tax Expense Amount 5 A X 
TXALLOAMT1 110 BCD*10.3 Tax Allocated Amount 1 A X 
TXALLOAMT2 111 BCD*10.3 Tax Allocated Amount 2 A X 
TXALLOAMT3 112 BCD*10.3 Tax Allocated Amount 3 A X 
TXALLOAMT4 113 BCD*10.3 Tax Allocated Amount 4 A X 
TXALLOAMT5 114 BCD*10.3 Tax Allocated Amount 5 A X 
TXBASEALLO 115 BCD*10.3 Net of Tax A X 
TXINCLUDED 116 BCD*10.3 Tax Included A C X 
TXEXCLUDED 117 BCD*10.3 Tax Excluded A C X 
TAXAMOUNT 118 BCD*10.3 Total Tax A C X 
TXRECVAMT 119 BCD*10.3 Total Tax Recoverable A X 
TXEXPSAMT 120 BCD*10.3 Total Tax Expensed A X 
TXALLOAMT 121 BCD*10.3 Total Tax Allocated A X 
F1099CLASS 122 String*6 1099/CPRS Class E A X  Mask: %-6N
F1099AMT 123 BCD*10.3 The 1099/CPRS Amount E 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 
MEXPENSED 126 BCD*10.3 Manual Proration Expensed A C X 
SCAMOUNT 127 BCD*10.3 Conversion Source Amount A C X 
FCAMOUNT 128 BCD*10.3 Conversion Functional Amount A C X 
MULTIRCP 129 Boolean Multiple Receipts E A X  List:2 entries
0 = No
1 = Yes
RCPS 130 Long Receipts E 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 
LASTRECEIP 193 String*22 Last Receipt Number A X  Mask: %-22C
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 Description A C X 
TCBASEALLO 198 BCD*10.3 Net of Tax 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 Amount E A C X 
INVTOTAL 225 BCD*10.3 Invoice Total E A X 
SUBTOTAL 226 BCD*10.3 Subtotal A C X 
PENDINGCAL 227 Boolean Tax calculation is pending A C X  List:2 entries
0 = No
1 = Yes
USE1099 228 Boolean Subject to 1099/CPRS Reporting A C X  List:2 entries
0 = No
1 = Yes
LOCKED 229 Boolean Document Locked A C X  List:2 entries
0 = No
1 = Yes
CANDELETE 230 Boolean Is Document Deletable A C X  List:2 entries
0 = No
1 = Yes
RATEEXISTS 231 Boolean Exchange Rate Exists A C X  List:2 entries
0 = No
1 = Yes
HASDETAILS 232 Boolean Has Details A C X  List:2 entries
0 = No
1 = Yes
COSTGRPS 233 Long Number of Cost Groups A C X 
VDEMAIL 234 String*50 E-mail E A X 
VDPHONEC 235 String*30 Contact Phone E A X  Mask: (%-3C) %-3C-%-24C
VDFAXC 236 String*30 Contact Fax E A X  Mask: (%-3C) %-3C-%-24C
VDEMAILC 237 String*50 Contact E-mail E A X 
BTEMAIL 238 String*50 Bill-To E-mail E A X 
BTPHONEC 239 String*30 Bill-To Contact Phone E A X  Mask: (%-3C) %-3C-%-24C
BTFAXC 240 String*30 Bill-To Contact Fax E A X  Mask: (%-3C) %-3C-%-24C
BTEMAILC 241 String*50 Bill-To Contact E-mail E A X 
STEMAIL 242 String*50 Ship-To E-mail E A X 
STPHONEC 243 String*30 Ship-To Contact Phone E A X  Mask: (%-3C) %-3C-%-24C
STFAXC 244 String*30 Ship-To Contact Fax E A X  Mask: (%-3C) %-3C-%-24C
STEMAILC 245 String*50 Ship-To Contact E-mail E A X 
RTEMAIL 246 String*50 Remit-To E-mail A X 
RTPHONEC 247 String*30 Remit-To Contact Phone A X  Mask: (%-3C) %-3C-%-24C
RTFAXC 248 String*30 Remit-To Contact Fax A X  Mask: (%-3C) %-3C-%-24C
RTEMAILC 249 String*50 Remit-To Contact E-mail A X 
DISCPCT 250 BCD*5.5 Discount Percentage E A X 
DISCOUNT 251 BCD*10.3 Discount Amount E A X 
DISCOUNTC 252 BCD*10.3 Discount Amount Sum E A C X 
NETXTENDED 253 BCD*10.3 Net Extended Cost A C X 
VALUES 254 Long Optional Fields E A C X 
PROCESSCMD 255 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 256 Boolean On Hold E A X  List:2 entries
0 = No
1 = Yes
TERMDBWT 257 BCD*10.3 Payment Discount Base With Tax A X 
TERMDBNT 258 BCD*10.3 Payment Discount Base Without Tax A X 
VERPRORATE 259 Integer Proration Version A X  List:2 entries
1 = 3.0A
2 = 5.3B
HASRTG 260 Boolean Has Retainage A X  List:2 entries
0 = No
1 = Yes
RTGRATE 261 Integer Retainage Exchange Rate A X  List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGBASE 262 Integer Retainage Base A X  List:2 entries
0 = Total After Taxes
1 = Total Before Taxes
RTGTERMS 263 String*6 Retainage Terms Code A X  Mask: %-6N
RTGAMOUNT 264 BCD*10.3 Retainage Amount E A C X 
JOBLINES 265 Long Job Related Lines A C X 
JOBCOSTS 266 Long Job Related Costs E A C X 
RTGTERMSD 267 String*60 Retainage Terms Code Description A C X 
HASJOB 268 Boolean Job Related E A X  List:2 entries
0 = No
1 = Yes
URTDTOTAL 269 BCD*10.3 Unretained Total A C X 
TRCURRENCY 270 String*3 Tax Reporting Currency A X  Mask: %-3N
RATERC 271 BCD*8.7 Tax Reporting Exchange Rate A X 
SPREADRC 272 BCD*8.7 Tax Reporting Rate Spread A X 
RATETYPERC 273 String*2 Tax Reporting Rate Type A X  Mask: %-2N
RATEMTCHRC 274 Integer Tax Reporting Rate Match Type A X 
RATEDATERC 275 Date Tax Reporting Rate Date A X 
RATEOPERRC 276 Integer Tax Reporting Rate Operation A X  List:2 entries
1 = Multiply
2 = Divide
RATERCOVER 277 Boolean Tax Reporting Rate Overridden A X  List:2 entries
0 = No
1 = Yes
RCURNDECML 278 Integer Tax Reporting Decimal Places A X 
TARAMOUNT1 279 BCD*10.3 Tax Reporting Amount 1 A X 
TARAMOUNT2 280 BCD*10.3 Tax Reporting Amount 2 A X 
TARAMOUNT3 281 BCD*10.3 Tax Reporting Amount 3 A X 
TARAMOUNT4 282 BCD*10.3 Tax Reporting Amount 4 A X 
TARAMOUNT5 283 BCD*10.3 Tax Reporting Amount 5 A X 
TRINCLUDE1 284 BCD*10.3 Tax Reporting Included Amount 1 A X 
TRINCLUDE2 285 BCD*10.3 Tax Reporting Included Amount 2 A X 
TRINCLUDE3 286 BCD*10.3 Tax Reporting Included Amount 3 A X 
TRINCLUDE4 287 BCD*10.3 Tax Reporting Included Amount 4 A X 
TRINCLUDE5 288 BCD*10.3 Tax Reporting Included Amount 5 A X 
TREXCLUDE1 289 BCD*10.3 Tax Reporting Excluded Amount 1 A X 
TREXCLUDE2 290 BCD*10.3 Tax Reporting Excluded Amount 2 A X 
TREXCLUDE3 291 BCD*10.3 Tax Reporting Excluded Amount 3 A X 
TREXCLUDE4 292 BCD*10.3 Tax Reporting Excluded Amount 4 A X 
TREXCLUDE5 293 BCD*10.3 Tax Reporting Excluded Amount 5 A X 
TRRECVAMT1 294 BCD*10.3 Tax Reporting Recoverable Amt. 1 A X 
TRRECVAMT2 295 BCD*10.3 Tax Reporting Recoverable Amt. 2 A X 
TRRECVAMT3 296 BCD*10.3 Tax Reporting Recoverable Amt. 3 A X 
TRRECVAMT4 297 BCD*10.3 Tax Reporting Recoverable Amt. 4 A X 
TRRECVAMT5 298 BCD*10.3 Tax Reporting Recoverable Amt. 5 A X 
TREXPSAMT1 299 BCD*10.3 Tax Reporting Expense Amount 1 A X 
TREXPSAMT2 300 BCD*10.3 Tax Reporting Expense Amount 2 A X 
TREXPSAMT3 301 BCD*10.3 Tax Reporting Expense Amount 3 A X 
TREXPSAMT4 302 BCD*10.3 Tax Reporting Expense Amount 4 A X 
TREXPSAMT5 303 BCD*10.3 Tax Reporting Expense Amount 5 A X 
TRALLOAMT1 304 BCD*10.3 Tax Reporting Allocated Amount 1 A X 
TRALLOAMT2 305 BCD*10.3 Tax Reporting Allocated Amount 2 A X 
TRALLOAMT3 306 BCD*10.3 Tax Reporting Allocated Amount 3 A X 
TRALLOAMT4 307 BCD*10.3 Tax Reporting Allocated Amount 4 A X 
TRALLOAMT5 308 BCD*10.3 Tax Reporting Allocated Amount 5 A X 
PDRATERC 309 BCD*8.7 Pred. Tax Reporting Exch. Rate A X 
PDRATTYPRC 310 String*2 Pred. Tax Reporting Rate Type A X  Mask: %-2N
PDRATEDTRC 311 Date Pred. Tax Reporting Rate Date A X 
PDRATEOPRC 312 Integer Pred. Tax Reporting Rate Oper. A X  List:2 entries
1 = Multiply
2 = Divide
PDRATERCOV 313 Boolean Pred. Tax Reporting Rate Overrd. A X  List:2 entries
0 = No
1 = Yes
RATERCEXST 314 Boolean Tax Reporting Exch. Rate Exists A C X  List:2 entries
0 = No
1 = Yes
RATERCC 315 BCD*8.7 Derived Tax Reporting Exch. Rate A C X 
TRCURRDESC 316 String*60 Tax Reporting Currency Desc. A C X 
RATETYPRCD 317 String*60 Tax Reporting Rate Type Desc. A C X 
PDRATTPRCD 318 String*60 Pred. Tax Rep. Rate Type Desc. A C X 
TARAMOUNT 319 BCD*10.3 Tax Reporting Total Amount A X 
TRINCLUDED 320 BCD*10.3 Tax Reporting Included Amount A X 
TREXCLUDED 321 BCD*10.3 Tax Reporting Excluded Amount A X 
TRRECVAMT 322 BCD*10.3 Tax Reporting Recoverable Amount A X 
TREXPSAMT 323 BCD*10.3 Tax Reporting Expensed Amount A X 
TRALLOAMT 324 BCD*10.3 Tax Reporting Allocated Amount A X 
TACBASE1 325 BCD*10.3 Tax Base 1 Sum E A C X 
TACBASE2 326 BCD*10.3 Tax Base 2 Sum E A C X 
TACBASE3 327 BCD*10.3 Tax Base 3 Sum E A C X 
TACBASE4 328 BCD*10.3 Tax Base 4 Sum E A C X 
TACBASE5 329 BCD*10.3 Tax Base 5 Sum E A C X 
TACAMOUNT1 330 BCD*10.3 Tax Amount 1 Sum E A C X 
TACAMOUNT2 331 BCD*10.3 Tax Amount 2 Sum E A C X 
TACAMOUNT3 332 BCD*10.3 Tax Amount 3 Sum E A C X 
TACAMOUNT4 333 BCD*10.3 Tax Amount 4 Sum E A C X 
TACAMOUNT5 334 BCD*10.3 Tax Amount 5 Sum E A C X 
TCEXCLUDE1 335 BCD*10.3 Tax Excluded 1 Sum E A C X 
TCEXCLUDE2 336 BCD*10.3 Tax Excluded 2 Sum E A C X 
TCEXCLUDE3 337 BCD*10.3 Tax Excluded 3 Sum E A C X 
TCEXCLUDE4 338 BCD*10.3 Tax Excluded 4 Sum E A C X 
TCEXCLUDE5 339 BCD*10.3 Tax Excluded 5 Sum E A C X 
TALAMOUNT1 340 BCD*10.3 Tax Reporting Amount 1 Sum E A C X 
TALAMOUNT2 341 BCD*10.3 Tax Reporting Amount 2 Sum E A C X 
TALAMOUNT3 342 BCD*10.3 Tax Reporting Amount 3 Sum E A C X 
TALAMOUNT4 343 BCD*10.3 Tax Reporting Amount 4 Sum E A C X 
TALAMOUNT5 344 BCD*10.3 Tax Reporting Amount 5 Sum E A C X 
TLINCLUDE1 345 BCD*10.3 Tax Reporting Included 1 Sum E A C X 
TLINCLUDE2 346 BCD*10.3 Tax Reporting Included 2 Sum E A C X 
TLINCLUDE3 347 BCD*10.3 Tax Reporting Included 3 Sum E A C X 
TLINCLUDE4 348 BCD*10.3 Tax Reporting Included 4 Sum E A C X 
TLINCLUDE5 349 BCD*10.3 Tax Reporting Included 5 Sum E A C X 
TLEXCLUDE1 350 BCD*10.3 Tax Reporting Excluded 1 Sum E A C X 
TLEXCLUDE2 351 BCD*10.3 Tax Reporting Excluded 2 Sum E A C X 
TLEXCLUDE3 352 BCD*10.3 Tax Reporting Excluded 3 Sum E A C X 
TLEXCLUDE4 353 BCD*10.3 Tax Reporting Excluded 4 Sum E A C X 
TLEXCLUDE5 354 BCD*10.3 Tax Reporting Excluded 5 Sum E A C X 
TLALLOAMT1 355 BCD*10.3 Tax Rep. Allocated Amount 1 Sum E A C X 
TLALLOAMT2 356 BCD*10.3 Tax Rep. Allocated Amount 2 Sum E A C X 
TLALLOAMT3 357 BCD*10.3 Tax Rep. Allocated Amount 3 Sum E A C X 
TLALLOAMT4 358 BCD*10.3 Tax Rep. Allocated Amount 4 Sum E A C X 
TLALLOAMT5 359 BCD*10.3 Tax Rep. Allocated Amount 5 Sum E A C X 
TLRECVAMT1 360 BCD*10.3 Tax Rep. Recoverable Amt. 1 Sum E A C X 
TLRECVAMT2 361 BCD*10.3 Tax Rep. Recoverable Amt. 2 Sum E A C X 
TLRECVAMT3 362 BCD*10.3 Tax Rep. Recoverable Amt. 3 Sum E A C X 
TLRECVAMT4 363 BCD*10.3 Tax Rep. Recoverable Amt. 4 Sum E A C X 
TLRECVAMT5 364 BCD*10.3 Tax Rep. Recoverable Amt. 5 Sum E A C X 
TLEXPSAMT1 365 BCD*10.3 Tax Rep. Expense Amount 1 Sum E A C X 
TLEXPSAMT2 366 BCD*10.3 Tax Rep. Expense Amount 2 Sum E A C X 
TLEXPSAMT3 367 BCD*10.3 Tax Rep. Expense Amount 3 Sum E A C X 
TLEXPSAMT4 368 BCD*10.3 Tax Rep. Expense Amount 4 Sum E A C X 
TLEXPSAMT5 369 BCD*10.3 Tax Rep. Expense Amount 5 Sum E A C X 
RTGTAXREP 370 Integer Report Retainage Tax A X  List:2 entries
0 = At Time of Original Document
1 = As Per Tax Authority
TAXVERSION 371 Long Tax State Version A X 
RAXBASE1 372 BCD*10.3 Retainage Tax Base 1 A X 
RAXBASE2 373 BCD*10.3 Retainage Tax Base 2 A X 
RAXBASE3 374 BCD*10.3 Retainage Tax Base 3 A X 
RAXBASE4 375 BCD*10.3 Retainage Tax Base 4 A X 
RAXBASE5 376 BCD*10.3 Retainage Tax Base 5 A X 
RAXAMOUNT1 377 BCD*10.3 Retainage Tax Amount 1 A X 
RAXAMOUNT2 378 BCD*10.3 Retainage Tax Amount 2 A X 
RAXAMOUNT3 379 BCD*10.3 Retainage Tax Amount 3 A X 
RAXAMOUNT4 380 BCD*10.3 Retainage Tax Amount 4 A X 
RAXAMOUNT5 381 BCD*10.3 Retainage Tax Amount 5 A X 
RXRECVAMT1 382 BCD*10.3 Retainage Tax Recoverable Amt. 1 A X 
RXRECVAMT2 383 BCD*10.3 Retainage Tax Recoverable Amt. 2 A X 
RXRECVAMT3 384 BCD*10.3 Retainage Tax Recoverable Amt. 3 A X 
RXRECVAMT4 385 BCD*10.3 Retainage Tax Recoverable Amt. 4 A X 
RXRECVAMT5 386 BCD*10.3 Retainage Tax Recoverable Amt. 5 A X 
RXEXPSAMT1 387 BCD*10.3 Retainage Tax Expense Amount 1 A X 
RXEXPSAMT2 388 BCD*10.3 Retainage Tax Expense Amount 2 A X 
RXEXPSAMT3 389 BCD*10.3 Retainage Tax Expense Amount 3 A X 
RXEXPSAMT4 390 BCD*10.3 Retainage Tax Expense Amount 4 A X 
RXEXPSAMT5 391 BCD*10.3 Retainage Tax Expense Amount 5 A X 
RXALLOAMT1 392 BCD*10.3 Retainage Tax Allocated Amount 1 A X 
RXALLOAMT2 393 BCD*10.3 Retainage Tax Allocated Amount 2 A X 
RXALLOAMT3 394 BCD*10.3 Retainage Tax Allocated Amount 3 A X 
RXALLOAMT4 395 BCD*10.3 Retainage Tax Allocated Amount 4 A X 
RXALLOAMT5 396 BCD*10.3 Retainage Tax Allocated Amount 5 A X 
RTGTXSHIFT 397 Boolean Warn On Retainage Tax Shift A C X  List:2 entries
0 = No
1 = Yes
RAXAMOUNT 398 BCD*10.3 Retainage Tax Total Amount A X 
TXRXAMT1 399 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 1 A X 
TXRXAMT2 400 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 2 A X 
TXRXAMT3 401 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 3 A X 
TXRXAMT4 402 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 4 A X 
TXRXAMT5 403 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 5 A X 
RACBASE1 404 BCD*10.3 Retainage Tax Base 1 Sum E A C X 
RACBASE2 405 BCD*10.3 Retainage Tax Base 2 Sum E A C X 
RACBASE3 406 BCD*10.3 Retainage Tax Base 3 Sum E A C X 
RACBASE4 407 BCD*10.3 Retainage Tax Base 4 Sum E A C X 
RACBASE5 408 BCD*10.3 Retainage Tax Base 5 Sum E A C X 
RACAMOUNT1 409 BCD*10.3 Retainage Tax Amount 1 Sum E A C X 
RACAMOUNT2 410 BCD*10.3 Retainage Tax Amount 2 Sum E A C X 
RACAMOUNT3 411 BCD*10.3 Retainage Tax Amount 3 Sum E A C X 
RACAMOUNT4 412 BCD*10.3 Retainage Tax Amount 4 Sum E A C X 
RACAMOUNT5 413 BCD*10.3 Retainage Tax Amount 5 Sum E A C X 
RCRECVAMT1 414 BCD*10.3 Rtg. Tax Recoverable Amt. 1 Sum E A C X 
RCRECVAMT2 415 BCD*10.3 Rtg. Tax Recoverable Amt. 2 Sum E A C X 
RCRECVAMT3 416 BCD*10.3 Rtg. Tax Recoverable Amt. 3 Sum E A C X 
RCRECVAMT4 417 BCD*10.3 Rtg. Tax Recoverable Amt. 4 Sum E A C X 
RCRECVAMT5 418 BCD*10.3 Rtg. Tax Recoverable Amt. 5 Sum E A C X 
RCEXPSAMT1 419 BCD*10.3 Rtg. Tax Expense Amount 1 Sum E A C X 
RCEXPSAMT2 420 BCD*10.3 Rtg. Tax Expense Amount 2 Sum E A C X 
RCEXPSAMT3 421 BCD*10.3 Rtg. Tax Expense Amount 3 Sum E A C X 
RCEXPSAMT4 422 BCD*10.3 Rtg. Tax Expense Amount 4 Sum E A C X 
RCEXPSAMT5 423 BCD*10.3 Rtg. Tax Expense Amount 5 Sum E A C X 
RCALLOAMT1 424 BCD*10.3 Rtg. Tax Allocated Amount 1 Sum E A C X 
RCALLOAMT2 425 BCD*10.3 Rtg. Tax Allocated Amount 2 Sum E A C X 
RCALLOAMT3 426 BCD*10.3 Rtg. Tax Allocated Amount 3 Sum E A C X 
RCALLOAMT4 427 BCD*10.3 Rtg. Tax Allocated Amount 4 Sum E A C X 
RCALLOAMT5 428 BCD*10.3 Rtg. Tax Allocated Amount 5 Sum E A C X 
VDACCTSET 429 String*6 Vendor Account Set E A X  Mask: %-6N
VDACCTDESC 430 String*60 Vendor Account Set Description A X 
DATEBUS 431 Date Posting Date E A X 
ENTEREDBY 432 String*8 Entered By A X 
DETAILNEXT 433 Integer Next Detail Number A X 
IDN 434 String*30 Import Declaration Number E A X 
CAXBASE1 435 BCD*10.3 Reverse Charges Base 1 E A C X 
CAXBASE2 436 BCD*10.3 Reverse Charges Base 2 E A C X 
CAXBASE3 437 BCD*10.3 Reverse Charges Base 3 E A C X 
CAXBASE4 438 BCD*10.3 Reverse Charges Base 4 E A C X 
CAXBASE5 439 BCD*10.3 Reverse Charges Base 5 E A C X 
CAXDTAMT1 440 BCD*10.3 Reverse Charges Detail Amount 1 A C X 
CAXDTAMT2 441 BCD*10.3 Reverse Charges Detail Amount 2 A C X 
CAXDTAMT3 442 BCD*10.3 Reverse Charges Detail Amount 3 A C X 
CAXDTAMT4 443 BCD*10.3 Reverse Charges Detail Amount 4 A C X 
CAXDTAMT5 444 BCD*10.3 Reverse Charges Detail Amount 5 A C X 
CAXAPPLY1 445 Boolean Reverse Charges Applied 1 A C X  List:2 entries
0 = No
1 = Yes
CAXAPPLY2 446 Boolean Reverse Charges Applied 2 A C X  List:2 entries
0 = No
1 = Yes
CAXAPPLY3 447 Boolean Reverse Charges Applied 3 A C X  List:2 entries
0 = No
1 = Yes
CAXAPPLY4 448 Boolean Reverse Charges Applied 4 A C X  List:2 entries
0 = No
1 = Yes
CAXAPPLY5 449 Boolean Reverse Charges Applied 5 A C X  List:2 entries
0 = No
1 = Yes
CAXAMOUNT1 450 BCD*10.3 Reverse Charges Amount 1 E A C X 
CAXAMOUNT2 451 BCD*10.3 Reverse Charges Amount 2 E A C X 
CAXAMOUNT3 452 BCD*10.3 Reverse Charges Amount 3 E A C X 
CAXAMOUNT4 453 BCD*10.3 Reverse Charges Amount 4 E A C X 
CAXAMOUNT5 454 BCD*10.3 Reverse Charges Amount 5 E A C X 
CAXAMOUNT 455 BCD*10.3 Reverse Charges Total Amount A C X 
TXEXNETCAX 456 BCD*10.3 Excluded Tax Less Reverse Charge A C 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).