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 ORDNUMBER, INVNUMBER
I/C Day End Trans. Number DAYENDNUM
Customer Number CUSTOMER
Customer/Invoice CUSTOMER, INVNUMBER
Reference/Invoice REFERENCE, INVNUMBER
Invoice Number INVNUMBER
Shipment Number/Invoice Number SHINUMBER, INVNUMBER

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 

This page was generated on 2023-Aug-31

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