Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
ORIGINGB | Origins GB |
Integer | 2 | View | |
STRTYEAR | Start Year |
Integer | 2 | View | |
ENDYEAR | End Year |
Integer | 2 | View | |
STICID | Start Intercompany ID |
String | 6 | View | |
ENDICID | End Intercompany ID |
String | 6 | View | |
FINRPTNM | Financial Report Name |
String | 32 | View | |
SJRNTPRT | Show Journals To Print |
Boolean | 2 | View | |
PRNTNOTS | Print Notes |
Boolean | 2 | View | |
PRNTTYPE | Print Type |
Integer | 2 | View | |
ASKECHTM | Ask Each Time |
Boolean | 2 | View | |
PRNTOFIL | Print to File |
Boolean | 2 | View | |
PRTOPRTR | Print to Printer |
Boolean | 2 | View | |
PRTOSCRN | Print to Screen |
Boolean | 2 | View | |
INCLGNDS | Include Legends |
Boolean | 2 | View | |
IFFILXST | If File Existing |
Integer | 2 | View | |
FILEXPNM | File Export Name |
String | 256 | View | |
EXPTTYPE | Export Type |
Integer | 2 | View | |
RPTGRIND | Report Group Index |
Integer | 2 | View | |
RTPACHIN | Report Palette Choice Index |
Integer | 2 | View | |
RTGRSBIN | Report Group Sub Index |
Currency | 10 | View | |
SORTBY | Sort By |
Integer | 2 | View | |
STTLOCID | Start Location ID |
String | 16 | View | |
STTLOCNM | Start Location Name |
String | 32 | View | |
STADDCTT | Start Address Contact |
String | 62 | View | |
SSRCEDOC | Start Source Document |
String | 12 | View | |
SSDOCDSC | Start Source Document Description |
String | 32 | View | |
STTSTATE | Start State |
String | 30 | View | |
STRTZPCD | Start Zip Code |
String | 12 | View | |
STTFLSRS | Start File Series |
Integer | 2 | View | |
STARTSRS | Start Series |
Integer | 2 | View | |
STTRXSRC | Start Transaction Source |
String | 26 | View | |
STTNOTNM | Start Note Name |
String | 46 | View | |
SRPTGRNM | Start Report Group Names |
String | 22 | View | |
STTPALNM | Start Palette Name |
String | 32 | View | |
STTUSRID | Start User ID |
String | 16 | View | |
STENDTYP | Start End Type |
Integer | 2 | View | |
STTCRDNM | Start Card Name |
String | 16 | View | |
STTPYTID | Start Payment Terms ID |
String | 22 | View | |
STTSHMTH | Start Shipping Method |
String | 16 | View | |
SRTCOMSR | Start Comment Series |
Integer | 2 | View | |
SRTCOMID | Start Comment ID |
String | 16 | View | |
ENDLOCID | End Location ID |
String | 16 | View | |
ENDLOCNM | End Location Name |
String | 32 | View | |
ENDADDCT | End Address Contact |
String | 62 | View | |
ENDSRCDC | End Source Document |
String | 12 | View | |
ENDSDDSC | End Source Document Description |
String | 32 | View | |
ENDSTATE | End State |
String | 30 | View | |
ENDZIPCD | End Zip Code |
String | 12 | View | |
ENDFLSRS | End File Series |
Integer | 2 | View | |
ENDSERIS | End Series |
Integer | 2 | View | |
ENDTRXSR | End Transaction Source |
String | 26 | View | |
ENDNOTNM | End Note Name |
String | 46 | View | |
ENDRPGNM | End Report Group Names |
String | 22 | View | |
ENDPALNM | End Palette Name |
String | 32 | View | |
ENDUSRID | End User ID |
String | 16 | View | |
ENDENDTY | End End Type |
Integer | 2 | View | |
ENDCRDNM | End Card Name |
String | 16 | View | |
ENDPYTID | End Payment Terms ID |
String | 22 | View | |
ENDSHMTH | End Shipping Method |
String | 16 | View | |
ENDCOMID | End Comment ID |
String | 16 | View | |
ENDCOMSR | End Comment Series |
Integer | 2 | View | |
ENDNAME | End Name |
String | 66 | View | |
ENDID | End ID |
String | 16 | View | |
STARTID | Start ID |
String | 16 | View | |
STRTNAME | Start Name |
String | 66 | View | |
STRTCITY | Start City |
String | 36 | View | |
ENDCITY | End City |
String | 36 | View | |
ENDCNTRY | End Country |
String | 62 | View | |
STTCNTRY | Start Country |
String | 62 | View | |
LBLFRMAT | Label Format |
Integer | 2 | View | |
NUMOCPIS | Number of Copies |
Integer | 2 | View | |
NUMACROS | Number Across |
Integer | 2 | View | |
INCADADR | Include Additional Addresses |
Boolean | 2 | View | |
INCCNTCT | Include Contact |
Boolean | 2 | View | |
FRCEUPCS | Force Uppercase |
Boolean | 2 | View | |
YEAR1 | Year |
Integer | 2 | View | |
PRNTDTLD | Print Detailed |
Boolean | 2 | View | |
ENTXDDSC | End Tax Detail Description |
String | 32 | View | |
ETXDTLID | End Tax Detail ID |
String | 16 | View | |
ETXSCHDS | End Tax Schedule Description |
String | 32 | View | |
ETXSCHID | End Tax Schedule ID |
String | 16 | View | |
STTXDDSC | Start Tax Detail Description |
String | 32 | View | |
STTXDTID | Start Tax Detail ID |
String | 16 | View | |
STXSCDSC | Start Tax Schedule Description |
String | 32 | View | |
STXSCHID | Start Tax Schedule ID |
String | 16 | View | |
ENDPEROD | End Period |
Integer | 2 | View | |
STPERIOD | Start Period |
Integer | 2 | View | |
STDTLTYP | Start Detail Type |
Integer | 2 | View | |
ENDETTYP | End Detail Type |
Integer | 2 | View | |
STXIDNUM | Start Tax ID Number |
String | 16 | View | |
ETXIDNBR | End Tax ID Number |
String | 16 | View | |
HISTTYPE | History Type |
Integer | 2 | View | |
STBCHNUM | Start Batch Number |
String | 16 | View | |
STRTDATE | Start Date |
Date | 4 | View | |
STDOCNUM | Start Document Number |
String | 22 | View | |
ENDBNMBR | End Batch Number |
String | 16 | View | |
ENDOCNUM | End Document Number |
String | 22 | View | |
ENDDATE | End Date |
Date | 4 | View | |
PRNSHPTO | Print Ship to Address |
Boolean | 2 | View | |
PRTBLLTO | Print Bill to Address |
Boolean | 2 | View | |
ARVLDEPART | Arrival/Departure GB |
Integer | 2 | View | |
STCUSTID | Start Customer ID |
String | 16 | View | |
ENCUSTID | End Customer ID |
String | 16 | View | |
STSOPTYP | Start SOP Type |
Integer | 2 | View | |
EDSOPTYP | End SOP Type |
Integer | 2 | View | |
UPSIDNBR | UPS Identification Number |
String | 16 | View | |
STTDOCDT | Start Document Date |
Date | 4 | View | |
ENDDOCDT | End Document Date |
Date | 4 | View | |
STDOCTYP | Start Document Type |
Integer | 2 | View | |
ENDOCTYP | End Document Type |
Integer | 2 | View | |
STVNDRID | Start Vendor ID |
String | 16 | View | |
ENDVNDID | End Vendor ID |
String | 16 | View | |
STRMTKDT | Start RM Token Date |
Integer | 2 | View | |
ENRMTKDT | End RM Token Date |
Integer | 2 | View | |
STTXUSR1 | Start Tax User Defined 1 |
String | 22 | View | |
ENTXUSR1 | End Tax User Defined 1 |
String | 22 | View | |
STTOKNDT | Start Token Date |
Integer | 2 | View | |
ENDTKNDT | End Token Date |
Integer | 2 | View | |
STTXPYDT | Start Tax Payment Date |
Date | 4 | View | |
ENTXPYDT | End Tax Payment Date |
Date | 4 | View | |
STTPSTDT | Start Post Date |
Date | 4 | View | |
ENDPSTDT | End Post Date |
Date | 4 | View | |
STGENINT1 | Start Generic Integer1 |
Integer | 2 | View | |
STDECLID | Start Declarant ID |
String | 16 | View | |
ENDDECLID | End Declarant ID |
String | 16 | View | |
STINTRSTTRTRNID | Start Intrastat Return ID |
String | 22 | View | |
ENDINTRSTTRTRNID | End Intrastat Return ID |
String | 22 | View | |
STTCC | Start Tax Commodity Code |
String | 32 | View | |
ENDTCC | End Tax Commodity Code |
String | 32 | View | |
STTXRGNNUM | Start Tax Registration Number |
String | 26 | View | |
ENDTXRGNNUM | End Tax Registration Number |
String | 26 | View | |
STRTAMNT | Start Amount |
Currency | 10 | View | |
ENDAMNT | End Amount |
Currency | 10 | View | |
GROUPBOX | Group Box |
Integer | 2 | View | |
GROUPBX2 | Group Box 2 |
Integer | 2 | View | |
EXCLVOID | Exclude Voided |
Boolean | 2 | View | |
PRNTCSV | Print CSV |
Boolean | 2 | View |