# 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: 340

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: %-30c
BILFAX | 15 | String*30 | Bill-To Fax | E A | Mask: %-30c
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: %-30c
SHPFAX | 28 | String*30 | Ship-To Fax | E A | Mask: %-30c
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 | E A | 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 |
SALES2NAME | 138 | String*60 | Salesperson Name 2 | E A |
SALES3NAME | 139 | String*60 | Salesperson Name 3 | E A |
SALES4NAME | 140 | String*60 | Salesperson Name 4 | E A |
SALES5NAME | 141 | String*60 | Salesperson Name 5 | E A |
TAUTH1DESC | 142 | String*60 | Tax Authority 1 Description | E A |
TAUTH2DESC | 143 | String*60 | Tax Authority 2 Description | E A |
TAUTH3DESC | 144 | String*60 | Tax Authority 3 Description | E A |
TAUTH4DESC | 145 | String*60 | Tax Authority 4 Description | E A |
TAUTH5DESC | 146 | String*60 | Tax Authority 5 Description | E A |
TCLAS1DESC | 147 | String*60 | Tax Class 1 Description | E A |
TCLAS2DESC | 148 | String*60 | Tax Class 2 Description | E A |
TCLAS3DESC | 149 | String*60 | Tax Class 3 Description | E A |
TCLAS4DESC | 150 | String*60 | Tax Class 4 Description | E A |
TCLAS5DESC | 151 | String*60 | Tax Class 5 Description | E A |
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: %-30c
BILFAXC | 171 | String*30 | Bill-To Contact Fax | E A | Mask: %-30c
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: %-30c
SHPFAXC | 175 | String*30 | Ship-To Contact Fax | E A | Mask: %-30c
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: 17 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
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: 5 entries
0 | = | (None)
1 | = | Cash
2 | = | Check
3 | = | Credit Card
4 | = | Other
CCTYPE | 329 | String*12 | Credit Card Type | E A | Mask: %-12N
CCNUMBER | 330 | Binary*32 | Credit Card Number | E A |
CCNAME | 331 | String*60 | Credit Card Name | E A |
CCAUTHCODE | 332 | String*20 | Authorization Code | E A |
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 |
ENTEREDBY | 354 | String*8 | Entered By | E A | 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 |

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.