View: Invoices

RotoID: OE0420
Table: OEINVH
Protocol: Header, Key auto generate
DLL:OEINVH

Compositions: 6

RotoID Tables Title DLL

OE0400 OEINVD Invoice Details OEINVD
OE0999 GENSTUB
OE0160 OECOINI Invoice Comments/Instructions OECOINI
OE0720 OETERMI Invoice Payment Schedules OETERMI
OE0427 OEINVR Multiple Shipments to Invoice OEINVR
OE0422 OEINVHO Invoice Optional Fields OEINVHO

Keys: 8

Title Fields

Invoice Uniquifier INVUNIQ
Order Number/Invoice Number ORDNUMBERINVNUMBER
I/C Day End Trans. Number DAYENDNUM
Customer Number CUSTOMER
Customer/Invoice CUSTOMERINVNUMBER
Reference/Invoice REFERENCEINVNUMBER
Invoice Number INVNUMBER
Shipment Number/Invoice Number SHINUMBERINVNUMBER

Fields: 341

Field Index Type Title Attributes Presentation

INVUNIQ 1 BCD*10.0 Invoice Uniquifier E A K R 
ORDNUMBER 2 String*22 Order Number E A  Mask: %-22C
DAYENDNUM 3 BCD*10.0 I/C Day End Trans. Number E A 
CUSTOMER 4 String*12 Customer Number E A  Mask: %-12C
BILNAME 5 String*60 Bill To E A 
BILADDR1 6 String*60 Bill-To Address 1 E A 
BILADDR2 7 String*60 Bill-To Address 2 E A 
BILADDR3 8 String*60 Bill-To Address 3 E A 
BILADDR4 9 String*60 Bill-To Address 4 E A 
BILCITY 10 String*30 Bill-To City E A 
BILSTATE 11 String*30 Bill-To State E A 
BILZIP 12 String*20 Bill-To Zip Code E A 
BILCOUNTRY 13 String*30 Bill-To Country E A 
BILPHONE 14 String*30 Bill-To Phone E A  Mask: (%-3C) %-3C-%-24C
BILFAX 15 String*30 Bill-To Fax E A  Mask: (%-3C) %-3C-%-24C
BILCONTACT 16 String*60 Bill-To Contact E A 
SHIPTO 17 String*6 Ship to Address Code E A  Mask: %-6C
SHPNAME 18 String*60 Ship To E A 
SHPADDR1 19 String*60 Ship-To Address 1 E A 
SHPADDR2 20 String*60 Ship-To Address 2 E A 
SHPADDR3 21 String*60 Ship-To Address 3 E A 
SHPADDR4 22 String*60 Ship-To Address 4 E A 
SHPCITY 23 String*30 Ship-To City E A 
SHPSTATE 24 String*30 Ship-To State E A 
SHPZIP 25 String*20 Ship-To Zip Code E A 
SHPCOUNTRY 26 String*30 Ship-To Country E A 
SHPPHONE 27 String*30 Ship-To Phone E A  Mask: (%-3C) %-3C-%-24C
SHPFAX 28 String*30 Ship-To Fax E A  Mask: (%-3C) %-3C-%-24C
SHPCONTACT 29 String*60 Ship-To Contact E A 
CUSTDISC 30 Integer Customer Discount Level E A  List:6 entries
0 = Base
1 = A
2 = B
3 = C
4 = D
5 = E
PRICELIST 31 String*6 Price List Code E A  Mask: %-6N
PONUMBER 32 String*22 Purchase Order Number A X  Mask: %-22C
TERRITORY 33 String*6 Territory E A  Mask: %-6N
TERMS 34 String*6 Terms Code E A  Mask: %-6N
TERMTTLDUE 35 BCD*10.3 Total Terms Amount Due E A 
TERMOVERRD 36 Boolean Terms Rate Override E A 
REFERENCE 37 String*60 Reference E A 
ORDDATE 38 Date Order Date E A 
SHIPVIA 39 String*6 Ship-Via Code E A  Mask: %-6N
VIADESC 40 String*60 Ship-Via Code Description E A 
FOB 41 String*60 Free On Board Point E A 
TEMPLATE 42 String*6 Template Code E A  Mask: %-6N
LOCATION 43 String*6 Location E A  Mask: %-6N
DESC 44 String*60 Description E A 
COMMENT 45 String*250 Comment E A 
SHIPDATE 46 Date Shipment Date E A 
INVDATE 47 Date Invoice Date E A 
INVFISCYR 48 String*4 Invoice Fiscal Year E A  Mask: %-4d
INVFISCPER 49 Integer Invoice Fiscal Period E A  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
INVLINES 50 Integer Number of Lines in Invoice E A 
NUMLABELS 51 Integer Number of Labels E A 
NUMPAYMENT 52 BCD*3.0 Number of Terms Payments E A 
PAYMNTASOF 53 Date Terms Payments As Of Date E A 
INVWEIGHT 54 BCD*10.4 Invoice Total Estimated Weight E A 
NEXTDTLNUM 55 Integer Next Detail Number E A 
INVSTATUS 56 Integer Invoice Status E A  List:2 entries
1 = Document shipped not costed
2 = Document costed
INVPRINTED 57 Boolean Invoice Printed E A  List:2 entries
0 = No
1 = Yes
IDISONMISC 58 Boolean Invoice Disc. on Misc. Charges E A 
POSTDATE 59 Date Posting Date E A C 
COMPDATE 60 Date Completion Date E A 
SHIPLABEL 61 Boolean Requires Shipping Labels E A 
LBLPRINTED 62 Boolean Shipping Labels Printed E A 
INVNETNOTX 63 BCD*10.3 Invoice Total Before Tax E A 
INVITAXTOT 64 BCD*10.3 Invoice Included Tax Tot. Amount E A 
INVITMTOT 65 BCD*10.3 Invoice Item Total Amount E A 
INVDISCBAS 66 BCD*10.3 Invoice Discount Base E A 
INVDISCPER 67 BCD*5.5 Invoice Discount Percentage E A 
INVDISCAMT 68 BCD*10.3 Invoice Discount Amount E A 
INVMISC 69 BCD*10.3 Invoice Total Misc. Charges E A 
INVSUBTOT 70 BCD*10.3 Invoice Subtotal Amount E A 
INVNET 71 BCD*10.3 Invoice Total With Invoice Disc. E A 
INVETAXTOT 72 BCD*10.3 Invoice Excluded Tax Tot. Amount E A 
INVNETWTX 73 BCD*10.3 Invoice Total With Tax E A 
INHOMECURR 74 String*3 Invoice Home Currency E A  Mask: %-3N
INRATETYPE 75 String*2 Invoice Rate Type E A X  Mask: %-2N
INSOURCURR 76 String*3 Invoice Source Currency E A  Mask: %-3N
INRATEDATE 77 Date Invoice Rate Date E A X 
INRATE 78 BCD*8.7 Invoice Rate E A X 
INSPREAD 79 BCD*8.7 Invoice Spread E A 
INDATEMTCH 80 Integer Invoice Rate Date Matching E A 
INRATEREP 81 Integer Invoice Rate Operator E A 
INRATEOVER 82 Boolean Invoice Rate Override Flag E A 
SALESPER1 83 String*8 Salesperson 1 E A  Mask: %-8N
SALESPER2 84 String*8 Salesperson 2 E A  Mask: %-8N
SALESPER3 85 String*8 Salesperson 3 E A  Mask: %-8N
SALESPER4 86 String*8 Salesperson 4 E A  Mask: %-8N
SALESPER5 87 String*8 Salesperson 5 E A  Mask: %-8N
SALESPLT1 88 BCD*5.5 Sales Percentage 1 E A 
SALESPLT2 89 BCD*5.5 Sales Percentage 2 E A 
SALESPLT3 90 BCD*5.5 Sales Percentage 3 E A 
SALESPLT4 91 BCD*5.5 Sales Percentage 4 E A 
SALESPLT5 92 BCD*5.5 Sales Percentage 5 E A 
TAXOVERRD 93 Boolean Tax Overridden E A 
TAXGROUP 94 String*12 Tax Group E A  Mask: %-12N
TAUTH1 95 String*12 Tax Authority 1 E A  Mask: %-12N
TAUTH2 96 String*12 Tax Authority 2 E A  Mask: %-12N
TAUTH3 97 String*12 Tax Authority 3 E A  Mask: %-12N
TAUTH4 98 String*12 Tax Authority 4 E A  Mask: %-12N
TAUTH5 99 String*12 Tax Authority 5 E A  Mask: %-12N
TCLASS1 100 Integer Tax Class 1 E A 
TCLASS2 101 Integer Tax Class 2 E A 
TCLASS3 102 Integer Tax Class 3 E A 
TCLASS4 103 Integer Tax Class 4 E A 
TCLASS5 104 Integer Tax Class 5 E A 
TBASE1 105 BCD*10.3 Tax Base 1 A C X 
TBASE2 106 BCD*10.3 Tax Base 2 A C X 
TBASE3 107 BCD*10.3 Tax Base 3 A C X 
TBASE4 108 BCD*10.3 Tax Base 4 A C X 
TBASE5 109 BCD*10.3 Tax Base 5 A C X 
TEAMOUNT1 110 BCD*10.3 Excluded Tax Amount 1 E A 
TEAMOUNT2 111 BCD*10.3 Excluded Tax Amount 2 E A 
TEAMOUNT3 112 BCD*10.3 Excluded Tax Amount 3 E A 
TEAMOUNT4 113 BCD*10.3 Excluded Tax Amount 4 E A 
TEAMOUNT5 114 BCD*10.3 Excluded Tax Amount 5 E A 
TIAMOUNT1 115 BCD*10.3 Included Tax Amount 1 E A 
TIAMOUNT2 116 BCD*10.3 Included Tax Amount 2 E A 
TIAMOUNT3 117 BCD*10.3 Included Tax Amount 3 E A 
TIAMOUNT4 118 BCD*10.3 Included Tax Amount 4 E A 
TIAMOUNT5 119 BCD*10.3 Included Tax Amount 5 E A 
TEXEMPT1 120 String*20 Registration 1 E A 
TEXEMPT2 121 String*20 Registration 2 E A 
TEXEMPT3 122 String*20 Registration 3 E A 
TEXEMPT4 123 String*20 Registration 4 E A 
TEXEMPT5 124 String*20 Registration 5 E A 
PCODDESC 133 String*60 Price List Code Description E A 
TERMDESC 134 String*60 Terms Code Description E A 
TXGRPDESC 135 String*60 Tax Group Code Description E A 
LOCDESC 136 String*60 Location Code Description E A 
SALES1NAME 137 String*60 Salesperson Name 1 E A C 
SALES2NAME 138 String*60 Salesperson Name 2 E A C 
SALES3NAME 139 String*60 Salesperson Name 3 E A C 
SALES4NAME 140 String*60 Salesperson Name 4 E A C 
SALES5NAME 141 String*60 Salesperson Name 5 E A C 
TAUTH1DESC 142 String*60 Tax Authority 1 Description E A C 
TAUTH2DESC 143 String*60 Tax Authority 2 Description E A C 
TAUTH3DESC 144 String*60 Tax Authority 3 Description E A C 
TAUTH4DESC 145 String*60 Tax Authority 4 Description E A C 
TAUTH5DESC 146 String*60 Tax Authority 5 Description E A C 
TCLAS1DESC 147 String*60 Tax Class 1 Description E A C 
TCLAS2DESC 148 String*60 Tax Class 2 Description E A C 
TCLAS3DESC 149 String*60 Tax Class 3 Description E A C 
TCLAS4DESC 150 String*60 Tax Class 4 Description E A C 
TCLAS5DESC 151 String*60 Tax Class 5 Description E A C 
INSRCDESC 152 String*60 Invoice Source Currency Desc. E A 
INHOMDESC 153 String*60 Invoice Home Currency Desc. E A 
INRTTYDESC 154 String*60 Invoice Rate Type Description E A 
PASRCDESC 155 String*60 Payment Source Currency Desc. E A 
PAHOMDESC 156 String*60 Payment Home Currency Desc. E A 
PARTTYDESC 157 String*60 Payment Rate Type Description E A 
TAMOUNT1 158 BCD*10.3 Total Tax Amount 1 A C X 
TAMOUNT2 159 BCD*10.3 Total Tax Amount 2 A C X 
TAMOUNT3 160 BCD*10.3 Total Tax Amount 3 A C X 
TAMOUNT4 161 BCD*10.3 Total Tax Amount 4 A C X 
TAMOUNT5 162 BCD*10.3 Total Tax Amount 5 A C X 
INVTAXTOT 163 BCD*10.3 Total Tax Amount E A 
INVPAYMENT 164 BCD*10.3 Invoice Paymnt in Customer Curr. E A 
INVPAYDISC 165 BCD*10.3 Invoice Payment Discount E A 
INVDUE 166 BCD*10.3 Invoice Amount Due E A 
AUTOTAXCAL 167 Boolean Auto-Tax Calculation Status E A 
ORDPAYTOT 168 BCD*10.3 Order Payments Total E A 
BILEMAIL 169 String*50 Bill-To E-mail E A 
BILPHONEC 170 String*30 Bill-To Contact Phone E A  Mask: (%-3C) %-3C-%-24C
BILFAXC 171 String*30 Bill-To Contact Fax E A  Mask: (%-3C) %-3C-%-24C
BILEMAILC 172 String*50 Bill-To Contact E-mail E A 
SHPEMAIL 173 String*50 Ship-To E-mail E A 
SHPPHONEC 174 String*30 Ship-To Contact Phone E A  Mask: (%-3C) %-3C-%-24C
SHPFAXC 175 String*30 Ship-To Contact Fax E A  Mask: (%-3C) %-3C-%-24C
SHPEMAILC 176 String*50 Ship-To Contact E-mail E A 
RECALCTAX 177 Boolean Recalculate Tax E A C 
DISCAVAIL 178 BCD*10.3 Discount Available E A C 
SHHOMECURR 179 String*3 Shipment Home Currency E A C  Mask: %-3N
SHRATETYPE 180 String*2 Shipment Rate Type E A X  Mask: %-2N
SHSOURCURR 181 String*3 Shipment Source Currency E A  Mask: %-3N
SHRATEDATE 182 Date Shipment Rate Date E A X 
SHRATE 183 BCD*8.7 Shipment Rate E A X 
SHSPREAD 184 BCD*8.7 Shipment Spread E A C 
SHDATEMTCH 185 Integer Shipment Rate Date Matching E A C 
SHRATEREP 186 Integer Shipment Rate Operator E A C 
SHRATEOVER 187 Boolean Shipment Rate Override Flag E A C 
SHINUMBER 188 String*22 Shipment Number E A  Mask: %-22C
MULTISHI 189 Boolean Generate From Multiple Shipments E A X  List:2 entries
0 = No
1 = Yes
SHIS 190 Integer From How Many Shipments E A C 
INVNUMBER 191 String*22 Invoice Number E A  Mask: %-22C
REBATCHNUM 192 BCD*5.0 Prepayment Batch Number E A 
BANKCODE 193 String*8 Prepayment Bank Code E A  Mask: %-8N
BANKRECTYP 194 String*12 Prepayment Receipt Type E A  Mask: %-12C
CHECKDATE 195 Date Prepayment Check Date E A 
CHKFISCYR 196 String*4 Prepayment Fiscal Year E A  Mask: %-4d
CHKFISCPER 197 Integer Prepayment Fiscal Period E A P 
CHECKNUM 198 String*24 Prepayment Check Number E A 
APPLYTO 199 Integer Prepayment Apply To E A  List:3 entries
2 = Invoice No.
4 = Order No.
9 = Shipment No.
BANKPAYMNT 200 BCD*10.3 Prepayment in Bank Currency E A 
PAHOMECURR 201 String*3 Prepayment Home Currency E A  Mask: %-3N
PARATETYPE 202 String*2 Prepayment Rate Type E A  Mask: %-2N
PASOURCURR 203 String*3 Prepayment Source Currency E A  Mask: %-3N
PARATEDATE 204 Date Prepayment Rate Date E A 
PARATE 205 BCD*8.7 Prepayment Rate E A 
PASPREAD 206 BCD*8.7 Prepayment Spread E A 
PADATEMTCH 207 Integer Prepayment Date Match E A 
PARATEREP 208 Integer Prepayment Rate Operator E A 
GOCALCTAX 209 Boolean Recalculate Tax E A 
GOCHKCRDT 210 Boolean Perform Credit Limit Check E A 
GOSHIPALL 211 Boolean Ship All E A 
DOSCONVERT 212 Boolean Dos Convert E A  List:2 entries
0 = No
1 = Yes
GOFCALCTAX 213 Boolean Force Tax Calculation E A 
GODISTTAX 214 Boolean Distribute Manual Tax E A 
TXCALCINPG 215 Boolean Tax Calculation in Progress E A C 
RUNNINGTOT 216 BCD*10.3 Invoice Running Total E A 
RTWARNMSG 227 Boolean Display Rate Warning E A 
CUSTEXIST 228 Boolean Customer Exists E A 
GOCALCPYDT 229 Boolean Recalc. Multi-Payment Dates E A 
INV1SHIPMT 230 Boolean Generate Inv. from Single Ship. E A 
INVSHIPMTS 231 Boolean Generate Inv. from Mult. Ships. E A 
SHRTTYDESC 233 String*60 Shipment Rate Type Description E A 
SHIPTRACK 234 String*36 Shipment Tracking Number E A 
SWPARTSHIP 235 Integer Allow partial shipments E A  List:2 entries
0 = No
1 = Yes
OVERCREDIT 236 Boolean Over Credit Limit E A C 
APPROVELMT 237 BCD*10.3 Approved Limit A C X 
APPROVEBY 238 String*8 Authorizing User ID E A C  Mask: %-8N
APPPASSWRD 239 String*64 Authorizing User Password E A 
GOAPPROSEC 240 Boolean User Can Approve Credit Lift E A 
VALUES 241 Long Optional Fields E A C 
SHIUNIQ 242 BCD*10.0 Shipment Uniquifier E A 
PROCESSCMD 243 Integer Process OIP Command E A C  List:17 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
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 List of Existing Serials/Lots
31 = Post Serials/Lots to IC Inventory
32 = Verify Serials/Lots
TERMDBWT 244 BCD*10.3 Document Discount Base With Tax E A 
TERMDBNT 245 BCD*10.3 Document Discount Base w/o Tax E A 
OECOMMAND 246 Integer Process O/E Command E A C  List:28 entries
0 = No Action
1 = Calculate Tax
2 = Force Calculate Tax
3 = Distribute Manual Tax
4 = Check Customer Credit Limit
5 = Pre-Check Customer Credit Limit
6 = Validate Credit Check Approval Authority
7 = Validate Credit Pre-Check Approval Authority
8 = Ship All
9 = Recalculate Payment Schedule Dates
10 = Check Partial Shipment
11 = Create Order From Quotes
16 = Derive Tax Reporting Rate
18 = Calculate Shipment Amount Due
19 = Check Job Related Quote Details
20 = Validate Job-Related Prepayment
21 = Distribute Prepayment to Job Details
23 = Create Sage CRM Address
24 = Set lock for Credit Card Transaction
25 = Find Incomplete Shipment for a Given Order
26 = Set lock for editing a document that has been pre-authorized.
27 = Confirm Web Credit Approval
28 = Confirm Web Credit Pre-Check Approval
29 = Pre-authorize
30 = Pre-Authorize CNA2 Part 1
31 = Pre-Authorize CNA2 Part 2
32 = Update Location from Header
33 = Update Ship Date from Header
EDAPRVLMT 247 BCD*10.3 User-Entered Approval Amount E A C 
SWCHKLIMC 248 Boolean Checking Customer Credit Limit E A C 
SWCHKODUEC 249 Boolean Checking Customer Aging Limit E A C 
SWCHKLIMA 250 Boolean Checking Nat. Acct. Credit Limit E A C 
SWCHKODUEA 251 Boolean Checking Nat. Acct. Aging Limit E A C 
SWOVERLIMC 252 Boolean Customer Is Over Credit Limit E A C 
SWOVERDUEC 253 Boolean Customer Is Over Aging Limit E A C 
SWOVERLIMA 254 Boolean Nat. Acct. Is Over Credit Limit E A C 
SWOVERDUEA 255 Boolean Nat. Acct. Is Over Aging Limit E A C 
AMTLIMITC 256 BCD*10.3 Customer Credit Limit E A C 
AMTBALCUST 257 BCD*10.3 Customer Balance (Posted) E A C 
OVDUEDAYSC 258 Integer Customer Days Overdue E A C 
OVDUELMTC 259 BCD*10.3 Customer Overdue Limit E A C 
OVDUEBALC 260 BCD*10.3 Customer Balance Overdue E A C 
AMTLIMITA 261 BCD*10.3 Nat. Acct. Credit Limit E A C 
AMTBALACCT 262 BCD*10.3 Nat. Acct. Balance E A C 
OVDUEDAYSA 263 Integer Nat. Acct. Days Overdue E A C 
OVDUELMTA 264 BCD*10.3 Nat. Acct. Overdue Limit E A C 
OVDUEBALA 265 BCD*10.3 Nat. Acct. Balance Overdue E A C 
SWARPEND 266 Boolean A/R Pending Trans. Included E A C 
SWOEPEND 267 Boolean O/E Pending Trans. Included E A C 
SWXXPEND 268 Boolean Other Pending Trans. Included E A C 
AMTARPEND 269 BCD*10.3 A/R Pending Balance E A C 
AMTOEPEND 270 BCD*10.3 O/E Pending Balance E A C 
AMTXXPEND 271 BCD*10.3 Other Pending Balance E A C 
AMTTOTCUST 272 BCD*10.3 Customer Total Outstanding E A C 
AMTTOTACCT 273 BCD*10.3 Nat. Acct. Total Outstanding E A C 
AMTLEFTC 274 BCD*10.3 Customer Limit Left E A C 
AMTLEFTA 275 BCD*10.3 Nat. Acct. Limit Left E A C 
AMTOVERC 276 BCD*10.3 Customer Limit Exceeded E A C 
AMTOVERA 277 BCD*10.3 Nat. Acct. Limit Exceeded E A C 
AMTLASTIVT 278 BCD*10.3 Last Invoice Amount E A C 
DATELASTIV 279 Date Last Invoice Date E A C 
AMTLASTPYT 280 BCD*10.3 Last Payment Amount E A C 
DATELASTPA 281 Date Last Payment Date E A C 
DRIVENBYUI 282 Boolean Driven by UI E A 
ITEMDISTOT 283 BCD*10.3 Item Detail Discount Total E A 
MISCDISTOT 284 BCD*10.3 Misc. Charge Detail Discount Total E A 
DTLDISCTOT 285 BCD*10.3 Detail Discount Total E A 
DTLDISCPER 286 BCD*5.5 Detail Discount Percentage E A 
INVNTDTDIS 287 BCD*10.3 Document Net of Detail Disc. E A C 
ITRMETHOD 288 Integer Auto-Calc. Tax Reporting Amounts E A 
ITRCURRNCY 289 String*3 Tax Reporting (TR) Currency E A C  Mask: %-3N
ITRRATTYPE 290 String*2 TR Rate Type E A X  Mask: %-2N
ITRRATDATE 291 Date TR Rate Date E A X 
ITRRATE 292 BCD*8.7 TR Rate E A X 
ITRSPREAD 293 BCD*8.7 TR Spread E A C 
ITRDATMTCH 294 Integer TR Rate Date Matching E A C 
ITRRATEOP 295 Integer TR Rate Operator E A C 
ITRRATOVER 296 Boolean TR Rate Override Flag E A C 
ITREAMNT1 297 BCD*10.3 TR Excluded Tax Amount 1 E A C 
ITREAMNT2 298 BCD*10.3 TR Excluded Tax Amount 2 E A C 
ITREAMNT3 299 BCD*10.3 TR Excluded Tax Amount 3 E A C 
ITREAMNT4 300 BCD*10.3 TR Excluded Tax Amount 4 E A C 
ITREAMNT5 301 BCD*10.3 TR Excluded Tax Amount 5 E A C 
ITRIAMNT1 302 BCD*10.3 TR Included Tax Amount 1 E A C 
ITRIAMNT2 303 BCD*10.3 TR Included Tax Amount 2 E A C 
ITRIAMNT3 304 BCD*10.3 TR Included Tax Amount 3 E A C 
ITRIAMNT4 305 BCD*10.3 TR Included Tax Amount 4 E A C 
ITRIAMNT5 306 BCD*10.3 TR Included Tax Amount 5 E A C 
ITRAMOUNT1 307 BCD*10.3 TR Tax Amount 1 A C X 
ITRAMOUNT2 308 BCD*10.3 TR Tax Amount 2 A C X 
ITRAMOUNT3 309 BCD*10.3 TR Tax Amount 3 A C X 
ITRAMOUNT4 310 BCD*10.3 TR Tax Amount 4 A C X 
ITRAMOUNT5 311 BCD*10.3 TR Tax Amount 5 A C X 
ITRETOTAL 312 BCD*10.3 TR Excluded Tax Total E A C 
ITRITOTAL 313 BCD*10.3 TR Included Tax Total E A C 
ITRTOTAL 314 BCD*10.3 TR Tax Total E A C 
STRCURRNCY 315 String*3 Tax Reporting Shipment (TR) Currency E A C  Mask: %-3N
STRRATTYPE 316 String*2 TR Shipment Rate Type E A C  Mask: %-2N
STRRATDATE 317 Date TR Shipment Rate Date E A C 
STRRATE 318 BCD*8.7 TR Shipment Rate E A C 
STRSPREAD 319 BCD*8.7 TR Shipment Spread E A C 
STRDATMTCH 320 Integer TR Shipment Rate Date Matching E A C 
STRRATEOP 321 Integer TR Shipment Rate Operator E A C 
STRRATOVER 322 Boolean TR Shipment Rate Override Flag E A C 
STRCURDESC 323 String*60 TR Shipment Currency Description E A 
ITRCURDESC 324 String*60 TR Invoice Currency Description E A 
STRRTYDESC 325 String*60 TR Shipment Rate Type Description E A 
ITRRTYDESC 326 String*60 TR Invoice Rate Type Description E A 
TAXVERSION 327 Long Tax Version E A C 
PAYMTYPE 328 Integer Payment Type E A  List:6 entries
0 = (None)
1 = Cash
2 = Check
3 = Credit Card
4 = Other
5 = SPS Credit Card
DISAMTOVER 333 Boolean Invoice Discount Amount Override E A C 
HASJOB 334 Boolean Job Related A C  List:2 entries
0 = No
1 = Yes
JOBLINES 335 Long Job Related Detail Lines E A C 
HASRTG 336 Boolean Has Retainage A X  List:2 entries
0 = No
1 = Yes
RTGTERMS 337 String*6 Retainage Terms A X  Mask: %-6N
RTGAMOUNT 338 BCD*10.3 Retainage Amount E A C 
RTGPERCENT 339 BCD*5.5 Retainage Percent A X 
RTGRATE 340 Integer Retainage Exchange Rate A X  List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGTXBASE1 341 BCD*10.3 Retainage Tax Base 1 E A 
RTGTXBASE2 342 BCD*10.3 Retainage Tax Base 2 E A 
RTGTXBASE3 343 BCD*10.3 Retainage Tax Base 3 E A 
RTGTXBASE4 344 BCD*10.3 Retainage Tax Base 4 E A 
RTGTXBASE5 345 BCD*10.3 Retainage Tax Base 5 E A 
RTGTXAMT1 346 BCD*10.3 Retainage Tax Amount 1 E A 
RTGTXAMT2 347 BCD*10.3 Retainage Tax Amount 2 E A 
RTGTXAMT3 348 BCD*10.3 Retainage Tax Amount 3 E A 
RTGTXAMT4 349 BCD*10.3 Retainage Tax Amount 4 E A 
RTGTXAMT5 350 BCD*10.3 Retainage Tax Amount 5 E A 
RTGTERMDSC 351 String*60 Retainage Terms Description A 
CUSACCTSET 352 String*6 Customer Account Set E A  Mask: %-6N
CUSACTDESC 353 String*60 Customer Account Set Description E A C 
ENTEREDBY 354 String*8 Entered By E A C  Mask: %-8N
DATEBUS 355 Date Posting Date E A 
SHIPAYTOT 356 BCD*10.3 Shipment Payments Total E A 
PAYDISTTOT 357 BCD*10.3 Prepayment Distributed Amount E A C 
UNAPPLDPAY 358 BCD*10.3 Prepayment Unapplied Amount E A C 
RTXAMTTOT 359 BCD*10.3 Total Retainage Tax Amount E A C 
OPPOLINES 360 Integer Sage CRM Opportunity Lines E A C 
PAUTHEXIST 361 Boolean Pre-Auth Exists for Invoice E A C  List:2 entries
0 = No
1 = Yes
EDN 362 String*30 Export Declaration Number E A 
SFPAURL 363 String*100 Payments Acceptance URL E A 
SFPAID 364 String*36 Payments Acceptance ID E A