Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
RPTGRIND | Report Group Index |
Integer | 2 | View | |
RTPACHIN | Report Palette Choice Index |
Integer | 2 | View | |
RTGRSBIN | Report Group Sub Index |
Currency | 10 | View | |
REPORTID | Report ID |
Integer | 2 | View | |
RPTGRNMS | Report Group Names |
String | 22 | View | |
ASKECHTM | Ask Each Time |
Boolean | 2 | View | |
PRTOSCRN | Print to Screen |
Boolean | 2 | View | |
PRTOPRTR | Print to Printer |
Boolean | 2 | View | |
PRNTOFIL | Print to File |
Boolean | 2 | View | |
EXPTTYPE | Export Type |
Integer | 2 | View | |
FILEXPNM | File Export Name |
String | 256 | View | |
IFFILXST | If File Existing |
Integer | 2 | View | |
PRNTTYPE | Print Type |
Integer | 2 | View | |
SORTBY | Sort By |
Integer | 2 | View | |
RANGEBY | Range By |
Integer | 2 | View | |
YEAR1 | Year |
Integer | 2 | View | |
PERIODID | Period ID |
Integer | 2 | View | |
PATU | PA Transaction Usage 1 = Timesheet |
Integer | 2 | View | |
PAReport_Include | PA Report Include |
Integer | 2 | View | |
PARange_By_Array_1 | PA Range By Array[1] |
Boolean | 2 | View | |
PARange_By_Array_2 | PA Range By Array[2] |
Boolean | 2 | View | |
PARange_By_Array_3 | PA Range By Array[3] |
Boolean | 2 | View | |
PARange_By_Array_4 | PA Range By Array[4] |
Boolean | 2 | View | |
PARange_By_Array_5 | PA Range By Array[5] |
Boolean | 2 | View | |
PARange_By_Array_6 | PA Range By Array[6] |
Boolean | 2 | View | |
PARange_By_Array_7 | PA Range By Array[7] |
Boolean | 2 | View | |
PARange_By_Array_8 | PA Range By Array[8] |
Boolean | 2 | View | |
PARange_By_Array_9 | PA Range By Array[9] |
Boolean | 2 | View | |
PARange_By_Array_10 | PA Range By Array[10] |
Boolean | 2 | View | |
PAExclude_Array_1 | PA Exclude Array[1] |
Boolean | 2 | View | |
PAExclude_Array_2 | PA Exclude Array[2] |
Boolean | 2 | View | |
PAExclude_Array_3 | PA Exclude Array[3] |
Boolean | 2 | View | |
PAExclude_Array_4 | PA Exclude Array[4] |
Boolean | 2 | View | |
PAExclude_Array_5 | PA Exclude Array[5] |
Boolean | 2 | View | |
PAExclude_Array_6 | PA Exclude Array[6] |
Boolean | 2 | View | |
PAExclude_Array_7 | PA Exclude Array[7] |
Boolean | 2 | View | |
PAExclude_Array_8 | PA Exclude Array[8] |
Boolean | 2 | View | |
PAExclude_Array_9 | PA Exclude Array[9] |
Boolean | 2 | View | |
PAExclude_Array_10 | PA Exclude Array[10] |
Boolean | 2 | View | |
PA_Net_Write_Down_In_Exc | PA Net Write Down In Excess Of |
Currency | 10 | View | |
DETLDRPT | Detailed Report |
Boolean | 2 | View | |
MTHSLCTD | Month Selected |
Integer | 2 | View | |
SUMDTTKN | Summary Date Token |
Integer | 2 | View | |
SMRYDATE | Summary Date |
Date | 4 | View | |
PACashBudgetSalesLevel | PA Cash Budget Sales Level |
Integer | 2 | View | |
PACashBudgetPctgLevels_1 | PA Cash Budget Percentage Levels[1] |
Integer | 2 | View | |
PACashBudgetPctgLevels_2 | PA Cash Budget Percentage Levels[2] |
Integer | 2 | View | |
PACashBudgetPctgLevels_3 | PA Cash Budget Percentage Levels[3] |
Integer | 2 | View | |
PACashBudgetStartingCash | PA Cash Budget Starting Cash Position |
Currency | 10 | View | |
PACashBudgetCashNeedsLev | PA Cash Budget Cash Needs Level |
Currency | 10 | View | |
PRPSTJCB | Print Posting Journal CB |
Boolean | 2 | View | |
PRTDBRCD | Print Detail Breakdown Reg CB |
Boolean | 2 | View | |
PRSBDRCB | Print Summary Breakdown Reg CB |
Boolean | 2 | View | |
STRTYEAR | Start Year |
Integer | 2 | View | |
ENDYEAR | End Year |
Integer | 2 | View | |
STBCHNUM | Start Batch Number |
String | 16 | View | |
ENDBNMBR | End Batch Number |
String | 16 | View | |
STDOCN | Start Doc No |
Long Integer | 4 | View | |
ENDOCN | End Doc No |
Long Integer | 4 | View | |
STTPRJCLID | Start Project Class ID |
String | 16 | View | |
ENDPRJCLID | End Project Class ID |
String | 16 | View | |
PASTPROJN | PA Start Project Number |
String | 16 | View | |
PAENPROJN | PA End Project Number |
String | 16 | View | |
STTPROJID | Start Project ID |
String | 16 | View | |
ENDPROJID | End Project ID |
String | 16 | View | |
StartProjectMgrID | Start Project Mgr ID |
String | 16 | View | |
EndProjectMgrID | End Project Mgr ID |
String | 16 | View | |
StartBusinessMgrID | Start Business Mgr ID |
String | 16 | View | |
EndBusinessMgrID | End Business Mgr ID |
String | 16 | View | |
STRTDEPT | Start Department |
String | 8 | View | |
ENDDEPT | End Department |
String | 8 | View | |
STTCNTRCLID | Start Contract Class ID |
String | 16 | View | |
ENDCNTRCLID | End Contract Class ID |
String | 16 | View | |
Start_Contract_Number | Start Contract Number |
String | 12 | View | |
End_Contract_Number | End Contract Number |
String | 12 | View | |
STTCONTRID | Start Contract ID |
String | 16 | View | |
ENDCONTRID | End Contract ID |
String | 16 | View | |
STSPRSID | Start Salesperson ID |
String | 16 | View | |
ENSPSNID | End Salesperson ID |
String | 16 | View | |
STDATEIN | Start Date Incurred |
Date | 4 | View | |
ENDATEIN | End Date Incurred |
Date | 4 | View | |
STREFDOC | Start Ref Doc No |
Long Integer | 4 | View | |
ENREFDOC | End Ref Doc No |
Long Integer | 4 | View | |
STDISTT | Start Dist Type |
Integer | 2 | View | |
ENDISTT | End Dist Type |
Integer | 2 | View | |
STACCNDX | Start Account Index |
Long Integer | 4 | View | |
EDACCNDX | End Account Index |
Long Integer | 4 | View | |
STRTNGDT | Starting Date |
Date | 4 | View | |
ENDINGDT | Ending Date |
Date | 4 | View | |
STTUDEF1 | Start User Defined 1 |
String | 22 | View | |
ENUSRDF1 | End User Defined 1 |
String | 22 | View | |
STTDOCDT | Start Document Date |
Date | 4 | View | |
ENDDOCDT | End Document Date |
Date | 4 | View | |
STTPSTDT | Start Post Date |
Date | 4 | View | |
ENDPSTDT | End Post Date |
Date | 4 | View | |
STRXSRC | Start TRX Source |
String | 14 | View | |
ENTRXSRC | End TRX Source |
String | 14 | View | |
STCUSTID | Start Customer ID |
String | 16 | View | |
ENCUSTID | End Customer ID |
String | 16 | View | |
STCUSTNM | Start Customer Name |
String | 66 | View | |
ENCSTNAM | End Customer Name |
String | 66 | View | |
PAStart_ID_Array_1 | PA Start ID Array[1] |
String | 16 | View | |
PAStart_ID_Array_2 | PA Start ID Array[2] |
String | 16 | View | |
PAStart_ID_Array_3 | PA Start ID Array[3] |
String | 16 | View | |
PAStart_ID_Array_4 | PA Start ID Array[4] |
String | 16 | View | |
PAStart_ID_Array_5 | PA Start ID Array[5] |
String | 16 | View | |
PAStart_ID_Array_6 | PA Start ID Array[6] |
String | 16 | View | |
PAStart_ID_Array_7 | PA Start ID Array[7] |
String | 16 | View | |
PAStart_ID_Array_8 | PA Start ID Array[8] |
String | 16 | View | |
PAStart_ID_Array_9 | PA Start ID Array[9] |
String | 16 | View | |
PAStart_ID_Array_10 | PA Start ID Array[10] |
String | 16 | View | |
PAEnd_ID_Array_1 | PA End ID Array[1] |
String | 16 | View | |
PAEnd_ID_Array_2 | PA End ID Array[2] |
String | 16 | View | |
PAEnd_ID_Array_3 | PA End ID Array[3] |
String | 16 | View | |
PAEnd_ID_Array_4 | PA End ID Array[4] |
String | 16 | View | |
PAEnd_ID_Array_5 | PA End ID Array[5] |
String | 16 | View | |
PAEnd_ID_Array_6 | PA End ID Array[6] |
String | 16 | View | |
PAEnd_ID_Array_7 | PA End ID Array[7] |
String | 16 | View | |
PAEnd_ID_Array_8 | PA End ID Array[8] |
String | 16 | View | |
PAEnd_ID_Array_9 | PA End ID Array[9] |
String | 16 | View | |
PAEnd_ID_Array_10 | PA End ID Array[10] |
String | 16 | View | |
PAStart_Name_Array_1 | PA Start Name Array[1] |
String | 32 | View | |
PAStart_Name_Array_2 | PA Start Name Array[2] |
String | 32 | View | |
PAStart_Name_Array_3 | PA Start Name Array[3] |
String | 32 | View | |
PAStart_Name_Array_4 | PA Start Name Array[4] |
String | 32 | View | |
PAStart_Name_Array_5 | PA Start Name Array[5] |
String | 32 | View | |
PAStart_Name_Array_6 | PA Start Name Array[6] |
String | 32 | View | |
PAStart_Name_Array_7 | PA Start Name Array[7] |
String | 32 | View | |
PAStart_Name_Array_8 | PA Start Name Array[8] |
String | 32 | View | |
PAStart_Name_Array_9 | PA Start Name Array[9] |
String | 32 | View | |
PAStart_Name_Array_10 | PA Start Name Array[10] |
String | 32 | View | |
PAEnd_Name_Array_1 | PA End Name Array[1] |
String | 32 | View | |
PAEnd_Name_Array_2 | PA End Name Array[2] |
String | 32 | View | |
PAEnd_Name_Array_3 | PA End Name Array[3] |
String | 32 | View | |
PAEnd_Name_Array_4 | PA End Name Array[4] |
String | 32 | View | |
PAEnd_Name_Array_5 | PA End Name Array[5] |
String | 32 | View | |
PAEnd_Name_Array_6 | PA End Name Array[6] |
String | 32 | View | |
PAEnd_Name_Array_7 | PA End Name Array[7] |
String | 32 | View | |
PAEnd_Name_Array_8 | PA End Name Array[8] |
String | 32 | View | |
PAEnd_Name_Array_9 | PA End Name Array[9] |
String | 32 | View | |
PAEnd_Name_Array_10 | PA End Name Array[10] |
String | 32 | View | |
PASTDOCT | PA Start Doc Type |
Integer | 2 | View | |
PAENDOCT | PA End Doc Type |
Integer | 2 | View | |
PAStart_PO_Number | PA Start PO Number |
Long Integer | 4 | View | |
PAEnd_PO_Number | PA End PO Number |
Long Integer | 4 | View | |
PAStart_TRX_Type | PA Start TRX Type |
Integer | 2 | View | |
PAEnd_TRX_Type | PA End TRX Type |
Integer | 2 | View | |
PRTCURIN | Print Currency In |
Integer | 2 | View | |
RPTXRATE | Reporting Exchange Rate |
Currency (Variable) | 10 | View | |
RPRTCLMD | Reporting Rate Calculation Method |
Integer | 2 | View | |
INCLUDEHOLDPO | Include Hold PO |
Boolean | 2 | View | |
INCLUDEHOLDPOONLY | Include Hold PO Only |
Boolean | 2 | View | |
Include_New | Include New |
Boolean | 2 | View | |
Include_Released | Include Released |
Boolean | 2 | View | |
Include_Change_Order | Include Change Order |
Boolean | 2 | View | |
Include_Received | Include Received |
Boolean | 2 | View | |
Include_Closed | Include Closed |
Boolean | 2 | View | |
Include_Canceled | Include Canceled |
Boolean | 2 | View | |
INCRCPTS | Include Receipts |
Boolean | 2 | View | |
ENDVNDID | End Vendor ID |
String | 16 | View | |
ENDVNDNM | End Vendor Name |
String | 66 | View | |
ENDPOSTA | End PO Status |
Integer | 2 | View | |
EndPOPRcptNum | End POP Receipt Number |
String | 18 | View | |
DISSRLOT | Display Serial/Lot Number |
Boolean | 2 | View | |
ENITMNBR | End Item Number |
String | 32 | View | |
End_Promised_Date | End Promised Date |
Date | 4 | View | |
End_Required_Date | End Required Date |
Date | 4 | View | |
ENDLOCID | End Location ID |
String | 16 | View | |
ENRCTDT | End Receipt Date |
Date | 4 | View | |
ENDBUYERID | End Buyer ID |
String | 16 | View | |
ENDLINEORIGIN | End Line Origin |
Integer | 2 | View | |
ENDRELEASEBYDATE | End Release By Date |
Date | 4 | View | |
PAENDCOSTID | PA End Cost Category ID |
String | 16 | View | |
ENAUCNCD | End Audit Control Code |
String | 14 | View | |
Days_Overdue | Days Overdue |
Boolean | 2 | View | |
DATEOVERDUE | Date Overdue |
Date | 4 | View | |
COMPTYPE | Compare Type |
Integer | 2 | View | |
POP_Date_Selection1 | PA_Date_Selection |
Integer | 2 | View | |
INCLFUNC | Include Functional Currency |
Boolean | 2 | View | |
INCMCINF | Include Multicurrency Info |
Boolean | 2 | View | |
STVNDRID | Start Vendor ID |
String | 16 | View | |
STVNDNAM | Start Vendor Name |
String | 66 | View | |
STRPOSTA | Start PO Status |
Integer | 2 | View | |
STRPONUM | Start PO Number |
String | 18 | View | |
StartPOPRcptNum | Start POP Receipt Number |
String | 18 | View | |
ENDPONUM | End PO Number |
String | 18 | View | |
STTITNUM | Start Item Number |
String | 32 | View | |
Start_Promised_Date | Start Promised Date |
Date | 4 | View | |
Start_Required_Date | Start Required Date |
Date | 4 | View | |
STTLOCID | Start Location ID |
String | 16 | View | |
STRCTDT | Start Receipt Date |
Date | 4 | View | |
STARTBUYERID | Start Buyer ID |
String | 16 | View | |
STARTLINEORIGIN | Start Line Origin |
Integer | 2 | View | |
STARTRELEASEBYDATE | Start Release By Date |
Date | 4 | View | |
PASTTCOSTID | PA Start Cost Category ID |
String | 16 | View | |
STTACNCD | Start Audit Control Code |
String | 14 | View |