View: Shipments

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

Compositions: 6

RotoID Tables Title DLL

OE0691 OESHID Shipment Details OESHID
OE0999 GENSTUB
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: 8

Title Fields

Shipment Uniquifier Key SHIUNIQ
Shipment Number Key SHINUMBER
Order/Shipment ORDNUMBERSHINUMBER
Customer/Shipment CUSTOMERSHINUMBER
Reference/Shipment REFERENCESHINUMBER
Shipment Completed COMPLETESHIUNIQ
Customer/PO No./Order No. CUSTOMERPONUMBERORDNUMBER
Order No./Shipment Completed ORDUNIQCOMPLETE

Fields: 375

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 C  Mask: %-8N
DATEBUS 217 Date Posting Date E A 
OPPOLINES 218 Integer Sage CRM Opportunity Lines E A C 
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 C 
SALES2NAME 405 String*60 Salesperson Name 2 E A C 
SALES3NAME 406 String*60 Salesperson Name 3 E A C 
SALES4NAME 407 String*60 Salesperson Name 4 E A C 
SALES5NAME 408 String*60 Salesperson Name 5 E A C 
TAUTH1DESC 409 String*60 Tax Authority 1 Desc. E A C 
TAUTH2DESC 410 String*60 Tax Authority 2 Desc. E A C 
TAUTH3DESC 411 String*60 Tax Authority 3 Desc. E A C 
TAUTH4DESC 412 String*60 Tax Authority 4 Desc. E A C 
TAUTH5DESC 413 String*60 Tax Authority 5 Desc. E A C 
TCLAS1DESC 414 String*60 Tax Class 1 Description E A C 
TCLAS2DESC 415 String*60 Tax Class 2 Description E A C 
TCLAS3DESC 416 String*60 Tax Class 3 Description E A C 
TCLAS4DESC 417 String*60 Tax Class 4 Description E A C 
TCLAS5DESC 418 String*60 Tax Class 5 Description E A C 
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: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
OECOMMAND 477 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 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:6 entries
0 = (None)
1 = Cash
2 = Check
3 = Credit Card
4 = Other
5 = SPS Credit Card
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 C 
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 
RTXAMTTOT 575 BCD*10.3 Total Retainage Tax Amount E A C 
PAUTHEXIST 576 Boolean Pre-Auth Exists for the Shipment E A C  List:2 entries
0 = No
1 = Yes
PAYMONORD 577 Integer Payment Type On Order E A  List:6 entries
0 = (None)
1 = Cash
2 = Check
3 = Credit Card
4 = Other
5 = SPS Credit Card
PAYMCODE 578 String*12 Payment Code On Order E A 
IDCARD 579 String*12 Payment Card ID E A