# View: Shipments

RotoID: OE0692
Table: OESHIH
Protocol: Header, Key auto generate
DLL: OESHIH

## Compositions: 6

RotoID | Tables | Title | DLL
--- | --- | --- | ---
OE0691 | OESHID | Shipment Details | OESHID
OE0682 | OESELS | Shipment Serial Numbers | OESELS
OE0190 | OECOINS | Shipment Comments/Instructions | OECOINS
OE0745 | OETERMS | Shipment Payment Schedules | OETERMS
OE0694 | OESHIR | Multiple Orders to Shipment | OESHIR
OE0704 | OESHIHO | Shipment Optional Fields | OESHIHO

## Keys: 7

Title | Fields
--- | ---
Shipment Uniquifier Key | SHIUNIQ
Shipment Number Key | SHINUMBER
Order/Shipment | ORDNUMBER, SHINUMBER
Customer/Shipment | CUSTOMER, SHINUMBER
Reference/Shipment | REFERENCE, SHINUMBER
Shipment Completed | COMPLETE, SHIUNIQ
Customer/PO No./Order No. | CUSTOMER, PONUMBER, ORDNUMBER

## Fields: 373

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
SHIUNIQ | 1 | BCD*10.0 | Shipment Uniquifier | E A K R |
SHINUMBER | 2 | String*22 | Shipment Number | E A | Mask: %-22C
ORDNUMBER | 3 | String*22 | Order Number | E A X | Mask: %-22C
DAYENDNUM | 4 | BCD*10.0 | I/C Day End Trans. Number | E A C |
CUSTOMER | 5 | String*12 | Customer Number | E A | Mask: %-12C
CUSTGROUP | 6 | String*6 | Customer Group Code | E A | Mask: %-6C
BILNAME | 7 | String*60 | Bill-To Name | E A |
BILADDR1 | 8 | String*60 | Bill-To Address Line 1 | E A |
BILADDR2 | 9 | String*60 | Bill-To Address Line 2 | E A |
BILADDR3 | 10 | String*60 | Bill-To Address Line 3 | E A |
BILADDR4 | 11 | String*60 | Bill-To Address Line 4 | E A |
BILCITY | 12 | String*30 | Bill-To City | E A |
BILSTATE | 13 | String*30 | Bill-To State/Province | E A |
BILZIP | 14 | String*20 | Bill-To Zip/Postal Code | E A |
BILCOUNTRY | 15 | String*30 | Bill-To Country | E A |
BILPHONE | 16 | String*30 | Bill-To Phone Number | E A | Mask: (%-3C) %-3C-%-24C
BILFAX | 17 | String*30 | Bill-To Fax Number | E A | Mask: (%-3C) %-3C-%-24C
BILCONTACT | 18 | String*60 | Bill-To Contact | E A |
BILEMAIL | 19 | String*50 | Bill-To E-mail | E A |
BILPHONEC | 20 | String*30 | Bill-To Contact Phone | E A | Mask: (%-3C) %-3C-%-24C
BILFAXC | 21 | String*30 | Bill-To Contact Fax | E A | Mask: (%-3C) %-3C-%-24C
BILEMAILC | 22 | String*50 | Bill-To Contact E-mail | E A |
SHIPTO | 23 | String*6 | Ship-To Location Code | E A | Mask: %-6C
SHPNAME | 24 | String*60 | Ship-To Name | E A |
SHPADDR1 | 25 | String*60 | Ship-To Address Line 1 | E A |
SHPADDR2 | 26 | String*60 | Ship-To Address Line 2 | E A |
SHPADDR3 | 27 | String*60 | Ship-To Address Line 3 | E A |
SHPADDR4 | 28 | String*60 | Ship-To Address Line 4 | E A |
SHPCITY | 29 | String*30 | Ship-To City | E A |
SHPSTATE | 30 | String*30 | Ship-To State/Province | E A |
SHPZIP | 31 | String*20 | Ship-To Zip/Postal Code | E A |
SHPCOUNTRY | 32 | String*30 | Ship-To Country | E A |
SHPPHONE | 33 | String*30 | Ship-To Phone Number | E A | Mask: (%-3C) %-3C-%-24C
SHPFAX | 34 | String*30 | Ship-To Fax Number | E A | Mask: (%-3C) %-3C-%-24C
SHPCONTACT | 35 | String*60 | Ship-To Contact | E A |
SHPEMAIL | 36 | String*50 | Ship-To E-mail | E A |
SHPPHONEC | 37 | String*30 | Ship-To Contact Phone | E A | Mask: (%-3C) %-3C-%-24C
SHPFAXC | 38 | String*30 | Ship-To Contact Fax | E A | Mask: (%-3C) %-3C-%-24C
SHPEMAILC | 39 | String*50 | Ship-To Contact E-mail | E A |
CUSTDISC | 40 | Integer | Customer Discount Level | E A | List: 6 entries
0 | = | Base
1 | = | A
2 | = | B
3 | = | C
4 | = | D
5 | = | E
PRICELIST | 41 | String*6 | Default Price List Code | E A | Mask: %-6N
PONUMBER | 42 | String*22 | Purchase Order Number | E A X | Mask: %-22C
TERRITORY | 43 | String*6 | Territory | E A | Mask: %-6N
TERMS | 44 | String*6 | Terms Code | E A | Mask: %-6N
REFERENCE | 45 | String*60 | Shipment Reference | E A |
SHIDATE | 46 | Date | Shipment Date | E A |
EXPDATE | 47 | Date | Expected Ship Date | E A |
SHIPVIA | 48 | String*6 | Ship-Via Code | E A | Mask: %-6N
VIADESC | 49 | String*60 | Ship-Via Code Description | E A |
SHIFISCYR | 50 | String*4 | Shipment Fiscal Year | E A | Mask: %-4d
SHIFISCPER | 51 | Integer | Shipment Fiscal Period | E A P | 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
LASTINVNUM | 52 | String*22 | Last Invoice Number | E A C | Mask: %-22C
NUMINVOICE | 53 | Integer | Number of Invoices | E A |
FOB | 54 | String*60 | Free On Board Point | E A |
TEMPLATE | 55 | String*6 | Template Code | E A | Mask: %-6N
LOCATION | 56 | String*6 | Default Location Code | E A | Mask: %-6N
DESC | 57 | String*60 | Shipment Description | E A |
COMMENT | 58 | String*250 | Shipment Comment | E A |
OVERCREDIT | 59 | Boolean | Over Credit Limit | E A C |
APPROVELMT | 60 | BCD*10.3 | Approved Limit | A C X |
APPROVEBY | 61 | String*8 | Authorizing User ID | E A C | Mask: %-8N
PRINTSTAT | 62 | Integer | Order Print Status | E A C P | List: 5 entries
1 | = |
2 | = | Quote printed
3 | = | Picking slip printed
0 | = | Internet
-1 | = | Electronic Commerce
LASTPOST | 63 | Date | Last Posting Date | E A C |
SHIPLABEL | 64 | Boolean | Requires Shipping Labels | E A C |
LBLPRINTED | 65 | Boolean | Shipping Labels Printed | E A C |
SHHOMECURR | 66 | String*3 | Shipment Home Currency | E A C | Mask: %-3N
SHRATETYPE | 67 | String*2 | Shipment Rate Type | E A X | Mask: %-2N
SHSOURCURR | 68 | String*3 | Shipment Source Currency | E A | Mask: %-3N
SHRATEDATE | 69 | Date | Shipment Rate Date | E A X |
SHRATE | 70 | BCD*8.7 | Shipment Rate | E A X |
SHSPREAD | 71 | BCD*8.7 | Shipment Spread | E A C |
SHDATEMTCH | 72 | Integer | Shipment Rate Date Matching | E A C |
SHRATEREP | 73 | Integer | Shipment Rate Operator | E A C |
SHRATEOVER | 74 | Boolean | Shipment Rate Override Flag | E A C |
SHITOTAL | 75 | BCD*10.3 | Total Amt. Items | E A C |
SHIMTOTAL | 76 | BCD*10.3 | Total Amt. Misc. Charges | E A C |
SHILINES | 77 | Integer | Number of Lines on Shipment | E A C |
NUMLABELS | 78 | Integer | Number of Labels | E A |
SHIPAYTOT | 79 | BCD*10.3 | Prev. Payments Total | E A C |
SHIPYDSTOT | 80 | BCD*10.3 | Prev. Payment Disc. Total | E A C |
SALESPER1 | 81 | String*8 | Salesperson 1 | E A | Mask: %-8N
SALESPER2 | 82 | String*8 | Salesperson 2 | E A | Mask: %-8N
SALESPER3 | 83 | String*8 | Salesperson 3 | E A | Mask: %-8N
SALESPER4 | 84 | String*8 | Salesperson 4 | E A | Mask: %-8N
SALESPER5 | 85 | String*8 | Salesperson 5 | E A | Mask: %-8N
SALESPLT1 | 86 | BCD*5.5 | Sales Percentage 1 | E A |
SALESPLT2 | 87 | BCD*5.5 | Sales Percentage 2 | E A |
SALESPLT3 | 88 | BCD*5.5 | Sales Percentage 3 | E A |
SALESPLT4 | 89 | BCD*5.5 | Sales Percentage 4 | E A |
SALESPLT5 | 90 | BCD*5.5 | Sales Percentage 5 | E A |
RECALCTAX | 91 | Boolean | Recalculate Tax | E A C |
TAXOVERRD | 92 | Boolean | Tax Overridden | E A C |
TAXGROUP | 93 | String*12 | Tax Group | E A X | Mask: %-12N
TAUTH1 | 94 | String*12 | Tax Authority 1 | E A | Mask: %-12N
TAUTH2 | 95 | String*12 | Tax Authority 2 | E A | Mask: %-12N
TAUTH3 | 96 | String*12 | Tax Authority 3 | E A | Mask: %-12N
TAUTH4 | 97 | String*12 | Tax Authority 4 | E A | Mask: %-12N
TAUTH5 | 98 | String*12 | Tax Authority 5 | E A | Mask: %-12N
TCLASS1 | 99 | Integer | Tax Class 1 | E A X |
TCLASS2 | 100 | Integer | Tax Class 2 | E A X |
TCLASS3 | 101 | Integer | Tax Class 3 | E A X |
TCLASS4 | 102 | Integer | Tax Class 4 | E A X |
TCLASS5 | 103 | Integer | Tax Class 5 | E A X |
TBASE1 | 104 | BCD*10.3 | Tax Base 1 | A C X |
TBASE2 | 105 | BCD*10.3 | Tax Base 2 | A C X |
TBASE3 | 106 | BCD*10.3 | Tax Base 3 | A C X |
TBASE4 | 107 | BCD*10.3 | Tax Base 4 | A C X |
TBASE5 | 108 | BCD*10.3 | Tax Base 5 | A C X |
TEAMOUNT1 | 109 | BCD*10.3 | Excluded Tax Amount 1 | E A C |
TEAMOUNT2 | 110 | BCD*10.3 | Excluded Tax Amount 2 | E A C |
TEAMOUNT3 | 111 | BCD*10.3 | Excluded Tax Amount 3 | E A C |
TEAMOUNT4 | 112 | BCD*10.3 | Excluded Tax Amount 4 | E A C |
TEAMOUNT5 | 113 | BCD*10.3 | Excluded Tax Amount 5 | E A C |
TIAMOUNT1 | 114 | BCD*10.3 | Included Tax Amount 1 | E A C |
TIAMOUNT2 | 115 | BCD*10.3 | Included Tax Amount 2 | E A C |
TIAMOUNT3 | 116 | BCD*10.3 | Included Tax Amount 3 | E A C |
TIAMOUNT4 | 117 | BCD*10.3 | Included Tax Amount 4 | E A C |
TIAMOUNT5 | 118 | BCD*10.3 | Included Tax Amount 5 | E A C |
TEXEMPT1 | 119 | String*20 | Registration 1 | E A X |
TEXEMPT2 | 120 | String*20 | Registration 2 | E A X |
TEXEMPT3 | 121 | String*20 | Registration 3 | E A X |
TEXEMPT4 | 122 | String*20 | Registration 4 | E A X |
TEXEMPT5 | 123 | String*20 | Registration 5 | E A X |
COMPLETE | 132 | Integer | Shipment Completed | E A C | List: 5 entries
1 | = | Incomplete/Not Included
2 | = | Incomplete/Included
3 | = | Complete/Not Included
4 | = | Complete/Included
5 | = | Complete/Day End
COMPDATE | 133 | Date | Shipment Completion Date | E A C |
SHIWEIGHT | 134 | BCD*10.4 | Shipment Total Est. Weight | E A C |
NEXTDTLNUM | 135 | Integer | Next Detail Number | E A C |
SDISONMISC | 136 | Boolean | Shipment Disc. Misc. Charges | E A |
NOSHIPLINE | 137 | Integer | No. Lines Qty. Shipped | E A C |
NOMISCLINE | 138 | Integer | No. Misc. Charges Lines | E A C |
SHINETNOTX | 139 | BCD*10.3 | Shipment Total Before Tax | E A C |
SHIITAXTOT | 140 | BCD*10.3 | Shipment Incl. Tax Total | E A C |
SHIITMTOT | 141 | BCD*10.3 | Shipment Item Total Amount | E A C |
SHIDISCBAS | 142 | BCD*10.3 | Shipment Discount Base | E A C |
SHIDISCPER | 143 | BCD*5.5 | Shipment Discount Percentage | E A |
SHIDISCAMT | 144 | BCD*10.3 | Shipment Discount Amount | E A |
SHIMISC | 145 | BCD*10.3 | Shipment Total Misc. Charges | E A C |
SHISUBTOT | 146 | BCD*10.3 | Shipment Subtotal Amount | E A C |
SHINET | 147 | BCD*10.3 | Shipment Total With Inv. Disc. | E A C |
SHIETAXTOT | 148 | BCD*10.3 | Shipment Excl. Tax Total | E A C |
SHINETWTX | 149 | BCD*10.3 | Shipment Total | E A C |
ORDDATE | 150 | Date | Order Date | E A C |
ORHOMECURR | 151 | String*3 | Order Home Currency | E A C | Mask: %-3N
ORRATETYPE | 152 | String*2 | Order Rate Type | E A C | Mask: %-2N
ORSOURCURR | 153 | String*3 | Order Source Currency | E A C | Mask: %-3N
ORRATEDATE | 154 | Date | Order Rate Date | E A C |
ORRATE | 155 | BCD*8.7 | Order Rate | E A C |
ORSPREAD | 156 | BCD*8.7 | Order Spread | E A C |
ORDATEMTCH | 157 | Integer | Order Rate Date Matching | E A C |
ORRATEREP | 158 | Integer | Order Rate Operator | E A C |
ORRATEOVER | 159 | Boolean | Order Rate Override Flag | E A C |
AUTOTAXCAL | 160 | Boolean | Auto-Tax Calculation Status | E A X |
MULTIORD | 161 | Boolean | Generate From Multiple Orders | E A X | List: 2 entries
0 | = | No
1 | = | Yes
ORDS | 162 | Integer | From How Many Orders | E A C |
SHIPTRACK | 163 | String*36 | Shipment Tracking Number | E A |
NUMSHPMENT | 164 | Integer | Number of Shipments | E A |
VALUES | 165 | Long | Optional Fields | E A C |
ORDUNIQ | 166 | BCD*10.0 | Order Uniquifier | E A |
ITEMDISTOT | 167 | BCD*10.3 | Item Detail Discount Total | E A |
MISCDISTOT | 168 | BCD*10.3 | Misc. Charge Detail Discount Total | E A |
STRMETHOD | 169 | Integer | Auto-Calc. Tax Reporting Amounts | E A X |
STRCURRNCY | 170 | String*3 | Tax Reporting (TR) Currency | E A C | Mask: %-3N
STRRATTYPE | 171 | String*2 | TR Rate Type | E A X | Mask: %-2N
STRRATDATE | 172 | Date | TR Rate Date | E A X |
STRRATE | 173 | BCD*8.7 | TR Rate | E A X |
STRSPREAD | 174 | BCD*8.7 | TR Spread | E A C |
STRDATMTCH | 175 | Integer | TR Rate Date Matching | E A C |
STRRATEOP | 176 | Integer | TR Rate Operator | E A C |
STRRATOVER | 177 | Boolean | TR Rate Override Flag | E A C |
STREAMNT1 | 178 | BCD*10.3 | TR Excluded Tax Amount 1 | E A C |
STREAMNT2 | 179 | BCD*10.3 | TR Excluded Tax Amount 2 | E A C |
STREAMNT3 | 180 | BCD*10.3 | TR Excluded Tax Amount 3 | E A C |
STREAMNT4 | 181 | BCD*10.3 | TR Excluded Tax Amount 4 | E A C |
STREAMNT5 | 182 | BCD*10.3 | TR Excluded Tax Amount 5 | E A C |
STRIAMNT1 | 183 | BCD*10.3 | TR Included Tax Amount 1 | E A C |
STRIAMNT2 | 184 | BCD*10.3 | TR Included Tax Amount 2 | E A C |
STRIAMNT3 | 185 | BCD*10.3 | TR Included Tax Amount 3 | E A C |
STRIAMNT4 | 186 | BCD*10.3 | TR Included Tax Amount 4 | E A C |
STRIAMNT5 | 187 | BCD*10.3 | TR Included Tax Amount 5 | E A C |
OTRCURRNCY | 188 | String*3 | Tax Reporting (TR) Order Currency | E A C | Mask: %-3N
OTRRATTYPE | 189 | String*2 | TR Order Rate Type | E A C | Mask: %-2N
OTRRATDATE | 190 | Date | TR Order Rate Date | E A C |
OTRRATE | 191 | BCD*8.7 | TR Order Rate | E A C |
OTRSPREAD | 192 | BCD*8.7 | TR Order Spread | E A C |
OTRDATMTCH | 193 | Integer | TR Order Rate Date Matching | E A C |
OTRRATEOP | 194 | Integer | TR Order Rate Operator | E A C |
OTRRATOVER | 195 | Boolean | TR Order Rate Override Flag | E A C |
DISAMTOVER | 196 | Boolean | Shipment Discount Amount Override | E A C |
SHNOPREPAY | 197 | Integer | Shipment No. of Prepayments | E A C |
JOBLINES | 198 | Long | Job Related Detail Lines | E A C |
LNINVABLE | 199 | Long | Invoiceable Detail Lines | E A C |
HASRTG | 200 | Boolean | Has Retainage | A X | List: 2 entries
0 | = | No
1 | = | Yes
RTGTERMS | 201 | String*6 | Retainage Terms | A X | Mask: %-6N
RTGAMOUNT | 202 | BCD*10.3 | Retainage Amount | E A C |
RTGPERCENT | 203 | BCD*5.5 | Retainage Percent | A X |
RTGRATE | 204 | Integer | Retainage Exchange Rate | A X | List: 2 entries
0 | = | Use Original Document Exchange Rate
1 | = | Use Current Exchange Rate
RTGTXBASE1 | 205 | BCD*10.3 | Retainage Tax Base 1 | E A |
RTGTXBASE2 | 206 | BCD*10.3 | Retainage Tax Base 2 | E A |
RTGTXBASE3 | 207 | BCD*10.3 | Retainage Tax Base 3 | E A |
RTGTXBASE4 | 208 | BCD*10.3 | Retainage Tax Base 4 | E A |
RTGTXBASE5 | 209 | BCD*10.3 | Retainage Tax Base 5 | E A |
RTGTXAMT1 | 210 | BCD*10.3 | Retainage Tax Amount 1 | E A |
RTGTXAMT2 | 211 | BCD*10.3 | Retainage Tax Amount 2 | E A |
RTGTXAMT3 | 212 | BCD*10.3 | Retainage Tax Amount 3 | E A |
RTGTXAMT4 | 213 | BCD*10.3 | Retainage Tax Amount 4 | E A |
RTGTXAMT5 | 214 | BCD*10.3 | Retainage Tax Amount 5 | E A |
CUSACCTSET | 215 | String*6 | Customer Account Set | E A | Mask: %-6N
ENTEREDBY | 216 | String*8 | Entered By | E A | Mask: %-8N
DATEBUS | 217 | Date | Posting Date | E A |
PCODDESC | 400 | String*60 | Price List Code Desc. | E A |
TERMDESC | 401 | String*60 | Terms Code Description | E A |
TXGRPDESC | 402 | String*60 | Tax Group Code Desc. | E A |
LOCDESC | 403 | String*60 | Location Code Desc. | E A |
SALES1NAME | 404 | String*60 | Salesperson Name 1 | E A |
SALES2NAME | 405 | String*60 | Salesperson Name 2 | E A |
SALES3NAME | 406 | String*60 | Salesperson Name 3 | E A |
SALES4NAME | 407 | String*60 | Salesperson Name 4 | E A |
SALES5NAME | 408 | String*60 | Salesperson Name 5 | E A |
TAUTH1DESC | 409 | String*60 | Tax Authority 1 Desc. | E A |
TAUTH2DESC | 410 | String*60 | Tax Authority 2 Desc. | E A |
TAUTH3DESC | 411 | String*60 | Tax Authority 3 Desc. | E A |
TAUTH4DESC | 412 | String*60 | Tax Authority 4 Desc. | E A |
TAUTH5DESC | 413 | String*60 | Tax Authority 5 Desc. | E A |
TCLAS1DESC | 414 | String*60 | Tax Class 1 Description | E A |
TCLAS2DESC | 415 | String*60 | Tax Class 2 Description | E A |
TCLAS3DESC | 416 | String*60 | Tax Class 3 Description | E A |
TCLAS4DESC | 417 | String*60 | Tax Class 4 Description | E A |
TCLAS5DESC | 418 | String*60 | Tax Class 5 Description | E A |
SHSRCDESC | 419 | String*60 | Shipment Source Curr. Desc. | E A |
SHHOMDESC | 420 | String*60 | Shipment Home Currency Desc. | E A |
SHRTTYDESC | 421 | String*60 | Shipment Rate Type Desc. | E A |
ORSRCDESC | 422 | String*60 | Shipment Source Currency Desc. | E A |
ORHOMDESC | 423 | String*60 | Shipment Home Currency Desc. | E A |
ORRTTYDESC | 424 | String*60 | Shipment Rate Type Description | E A |
TAMOUNT1 | 425 | BCD*10.3 | Total Tax Amount 1 | A C X |
TAMOUNT2 | 426 | BCD*10.3 | Total Tax Amount 2 | A C X |
TAMOUNT3 | 427 | BCD*10.3 | Total Tax Amount 3 | A C X |
TAMOUNT4 | 428 | BCD*10.3 | Total Tax Amount 4 | A C X |
TAMOUNT5 | 429 | BCD*10.3 | Total Tax Amount 5 | A C X |
SHITAXTOT | 430 | BCD*10.3 | Total Tax Amount | E A |
RUNNINGTOT | 431 | BCD*10.3 | Shipment Running Total | E A |
GOCALCTAX | 432 | Boolean | Perform Tax Calculation | E A |
GOSHIPALL | 433 | Boolean | Perform Ship All | E A |
DOSCONVERT | 434 | Boolean | DOS Conversion in Progress | E A | List: 2 entries
0 | = | No
1 | = | Yes
GOFCALCTAX | 435 | Boolean | Perform Forced Tax Calculation | E A |
GODISTTAX | 436 | Boolean | Perform Manual Tax Distribution | E A |
TXCALCINPG | 437 | Boolean | Tax Calculation in Progress | E A C |
RTWARNMSG | 448 | Boolean | Display Rate Warning | E A |
CUSTEXIST | 449 | Boolean | Customer Exists | E A |
SECENABLED | 450 | Boolean | Security Enabled | E A |
GOAPPROSEC | 451 | Boolean | User Can Approve Credit Lift | E A |
GOCHKCRDT | 452 | Boolean | Perform Credit Limit Check | E A |
APPPASSWRD | 453 | String*64 | Authorizing User Password | E A X |
SWPARTSHIP | 454 | Integer | Allow partial shipments | E A | List: 2 entries
0 | = | No
1 | = | Yes
SHIP1ORDER | 455 | Boolean | Generate Ship. from Single Order | E A |
SHIPORDERS | 456 | Boolean | Generate Ship. from Mult. Orders | E A |
CREATEINV | 457 | Boolean | Create Invoice from Shipment | E A X |
INVNUMBER | 458 | String*22 | Invoice Number | E A | Mask: %-22C
POSTSEQNUM | 460 | Long | Post Sequence Number | A C |
INVUNIQ | 461 | BCD*10.0 | Invoice Uniquifier | E A |
INVDATE | 462 | Date | Invoice Date | E A |
INHOMECURR | 463 | String*3 | Invoice Home Currency | E A C | Mask: %-3N
INRATETYPE | 464 | String*2 | Invoice Rate Type | E A X | Mask: %-2N
INSOURCURR | 465 | String*3 | Invoice Source Currency | E A C | Mask: %-3N
INRATEDATE | 466 | Date | Invoice Rate Date | E A X |
INRATE | 467 | BCD*8.7 | Invoice Rate | E A X |
INSPREAD | 468 | BCD*8.7 | Invoice Spread | E A C |
INDATEMTCH | 469 | Integer | Invoice Rate Date Matching | E A C |
INRATEREP | 470 | Integer | Invoice Rate Operator | E A C |
INRATEOVER | 471 | Boolean | Invoice Rate Override Flag | E A C |
INSRCDESC | 472 | String*60 | Invoice Source Currency Desc. | E A |
INHOMDESC | 473 | String*60 | Invoice Home Currency Desc. | E A |
INRTTYDESC | 474 | String*60 | Invoice Rate Type Description | E A |
FROMORDER | 475 | Boolean | Created from Order | E A |
PROCESSCMD | 476 | Integer | Process OIP Command | E A C | List: 6 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
OECOMMAND | 477 | 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 | 478 | BCD*10.3 | User-Entered Approval Amount | E A C |
SWCHKLIMC | 479 | Boolean | Checking Customer Credit Limit | E A C |
SWCHKODUEC | 480 | Boolean | Checking Customer Aging Limit | E A C |
SWCHKLIMA | 481 | Boolean | Checking Nat. Acct. Credit Limit | E A C |
SWCHKODUEA | 482 | Boolean | Checking Nat. Acct. Aging Limit | E A C |
SWOVERLIMC | 483 | Boolean | Customer Is Over Credit Limit | E A C |
SWOVERDUEC | 484 | Boolean | Customer Is Over Aging Limit | E A C |
SWOVERLIMA | 485 | Boolean | Nat. Acct. Is Over Credit Limit | E A C |
SWOVERDUEA | 486 | Boolean | Nat. Acct. Is Over Aging Limit | E A C |
AMTLIMITC | 487 | BCD*10.3 | Customer Credit Limit | E A C |
AMTBALCUST | 488 | BCD*10.3 | Customer Balance (Posted) | E A C |
OVDUEDAYSC | 489 | Integer | Customer Days Overdue | E A C |
OVDUELMTC | 490 | BCD*10.3 | Customer Overdue Limit | E A C |
OVDUEBALC | 491 | BCD*10.3 | Customer Balance Overdue | E A C |
AMTLIMITA | 492 | BCD*10.3 | Nat. Acct. Credit Limit | E A C |
AMTBALACCT | 493 | BCD*10.3 | Nat. Acct. Balance | E A C |
OVDUEDAYSA | 494 | Integer | Nat. Acct. Days Overdue | E A C |
OVDUELMTA | 495 | BCD*10.3 | Nat. Acct. Overdue Limit | E A C |
OVDUEBALA | 496 | BCD*10.3 | Nat. Acct. Balance Overdue | E A C |
SWARPEND | 497 | Boolean | A/R Pending Trans. Included | E A C |
SWOEPEND | 498 | Boolean | O/E Pending Trans. Included | E A C |
SWXXPEND | 499 | Boolean | Other Pending Trans. Included | E A C |
AMTARPEND | 500 | BCD*10.3 | A/R Pending Balance | E A C |
AMTOEPEND | 501 | BCD*10.3 | O/E Pending Balance | E A C |
AMTXXPEND | 502 | BCD*10.3 | Other Pending Balance | E A C |
AMTTOTCUST | 503 | BCD*10.3 | Customer Total Outstanding | E A C |
AMTTOTACCT | 504 | BCD*10.3 | Nat. Acct. Total Outstanding | E A C |
AMTLEFTC | 505 | BCD*10.3 | Customer Limit Left | E A C |
AMTLEFTA | 506 | BCD*10.3 | Nat. Acct. Limit Left | E A C |
AMTOVERC | 507 | BCD*10.3 | Customer Limit Exceeded | E A C |
AMTOVERA | 508 | BCD*10.3 | Nat. Acct. Limit Exceeded | E A C |
AMTLASTIVT | 509 | BCD*10.3 | Last Invoice Amount | E A C |
DATELASTIV | 510 | Date | Last Invoice Date | E A C |
AMTLASTPYT | 511 | BCD*10.3 | Last Payment Amount | E A C |
DATELASTPA | 512 | Date | Last Payment Date | E A C |
DRIVENBYUI | 513 | Boolean | Driven by UI | E A |
DTLDISCTOT | 514 | BCD*10.3 | Detail Discount Total | E A C |
DTLDISCPER | 515 | BCD*5.5 | Detail Discount Percentage | E A C |
SHINTDTDIS | 516 | BCD*10.3 | Document Net of Detail Disc. | E A C |
STRAMOUNT1 | 517 | BCD*10.3 | TR Tax Amount 1 | A C X |
STRAMOUNT2 | 518 | BCD*10.3 | TR Tax Amount 2 | A C X |
STRAMOUNT3 | 519 | BCD*10.3 | TR Tax Amount 3 | A C X |
STRAMOUNT4 | 520 | BCD*10.3 | TR Tax Amount 4 | A C X |
STRAMOUNT5 | 521 | BCD*10.3 | TR Tax Amount 5 | A C X |
STRETOTAL | 522 | BCD*10.3 | TR Excluded Tax Total | E A C |
STRITOTAL | 523 | BCD*10.3 | TR Included Tax Total | E A C |
STRTOTAL | 524 | BCD*10.3 | TR Tax Total | E A C |
ITRCURRNCY | 525 | String*3 | Tax Reporting Invoice (TR) Currency | E A C | Mask: %-3N
ITRRATTYPE | 526 | String*2 | TR Invoice Rate Type | E A X | Mask: %-2N
ITRRATDATE | 527 | Date | TR Invoice Rate Date | E A X |
ITRRATE | 528 | BCD*8.7 | TR Invoice Rate | E A X |
ITRSPREAD | 529 | BCD*8.7 | TR Invoice Spread | E A C |
ITRDATMTCH | 530 | Integer | TR Invoice Rate Date Matching | E A C |
ITRRATEOP | 531 | Integer | TR Invoice Rate Operator | E A C |
ITRRATOVER | 532 | Boolean | TR Invoice Rate Override Flag | E A C |
OTRCURDESC | 533 | String*60 | TR Currency Description | E A |
STRCURDESC | 534 | String*60 | TR Shipment Currency Description | E A |
ITRCURDESC | 535 | String*60 | TR Invoice Currency Description | E A |
OTRRTYDESC | 536 | String*60 | TR Rate Type Description | E A |
STRRTYDESC | 537 | String*60 | TR Shipment Rate Type Description | E A |
ITRRTYDESC | 538 | String*60 | TR Invoice Rate Type Description | E A |
REBATCHNUM | 539 | BCD*5.0 | Receipt Batch Number | E A |
BANKCODE | 540 | String*8 | Bank Code | E A | Mask: %-8N
BANKRECTYP | 541 | String*12 | Receipt Type | E A | Mask: %-12C
CHECKDATE | 542 | Date | Check Date | E A |
CHKFISCYR | 543 | String*4 | Check Fiscal Year | E A | Mask: %-4d
CHKFISCPER | 544 | Integer | Check Fiscal Period | E A P |
CHECKNUM | 545 | String*24 | Check Number | E A |
APPLYTO | 546 | Integer | Payment Applied To | E A | List: 3 entries
2 | = | Invoice No.
4 | = | Order No.
9 | = | Shipment No.
PAYMENT | 547 | BCD*10.3 | Payment In Cust. Currency | E A |
PAYDISC | 548 | BCD*10.3 | Payment Disc. | E A |
BANKPAYMNT | 549 | BCD*10.3 | Payment In Bank Currency | E A |
PENDPREPAY | 550 | BCD*10.3 | Pending Prepayment Amount | E A |
PAHOMECURR | 551 | String*3 | Payment Home Currency | E A | Mask: %-3N
PARATETYPE | 552 | String*2 | Payment Rate Type | E A | Mask: %-2N
PASOURCURR | 553 | String*3 | Payment Source Currency | E A | Mask: %-3N
PARATEDATE | 554 | Date | Payment Rate Date | E A |
PARATE | 555 | BCD*8.7 | Payment Rate | E A |
PASPREAD | 556 | BCD*8.7 | Payment Spread | E A |
PADATEMTCH | 557 | Integer | Payment Rate Date Matching | E A |
PARATEREP | 558 | Integer | Payment Rate Operator | E A |
PAYMTYPE | 559 | Integer | Payment Type | E A | List: 5 entries
0 | = | (None)
1 | = | Cash
2 | = | Check
3 | = | Credit Card
4 | = | Other
CCTYPE | 560 | String*12 | Credit Card Type | E A | Mask: %-12N
CCNUMBER | 561 | Binary*32 | Credit Card Number | E A |
CCNAME | 562 | String*60 | Credit Card Name | E A |
CCAUTHCODE | 563 | String*20 | Authorization Code | E A |
SHIPAYMENT | 564 | BCD*10.3 | Shipment Total Payment | E A |
SHIAMTDUE | 565 | BCD*10.3 | Shipment Amount Due | E A |
AMTDUENODS | 566 | BCD*10.3 | Amount Due Less Curr. Prepayment | E A |
HASJOB | 567 | Boolean | Job Related | A X | List: 2 entries
0 | = | No
1 | = | Yes
NONINVABLE | 568 | Boolean | Project Invoicing | A X | List: 2 entries
0 | = | No
1 | = | Yes
RTGTERMDSC | 569 | String*60 | Retainage Terms Description | A |
CUSACTDESC | 570 | String*60 | Customer Account Set Description | E A |
INVDATEBUS | 571 | Date | Invoice Posting Date | E A |
ORDPAYTOT | 572 | BCD*10.3 | Order Payments Total | E A |
PAYDISTTOT | 573 | BCD*10.3 | Prepayment Distributed Amount | E A C |
UNAPPLDPAY | 574 | BCD*10.3 | Prepayment Unapplied Amount | E A C |

This page was generated on 2008-May-01

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