GP Tables

JC20511 - JC_Invoice_Project_OPEN

SQL Query Builder

123 Columns

Column Description Type Length
Project_Number char(17)
RMDNUMWK char(17)
RMDTYPAL smallint
DOCNUMBR char(21)
WS_Application_Number char(5)
DOCTYPE smallint
Document Type (Payables) values (7)
1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment
BACHNUMB char(15)
BCHSOURC char(15)
ACCTAMNT numeric(19,5)
PYMTRMID char(21)
TAXSCHID char(15)
CASHAMNT numeric(19,5)
DOCDATE datetime
POSTDATE datetime
PSTUSRID char(15)
GLPOSTDT datetime
Dynamics_Status char(5)
CUSTNMBR char(15)
ADRSCODE char(15)
SLPRSNID char(15)
COMPRCNT smallint
COMMERNG numeric(19,5)
SALSTERR char(15)
CSTPONBR char(21)
TRDISAMT numeric(19,5)
DISCDATE datetime
DUEDATE datetime
Date_Paid datetime
Amount_Received numeric(19,5)
FRTTXAMT numeric(19,5)
MSCTXAMT numeric(19,5)
TAXAMNT numeric(19,5)
TAXDTLID char(15)
Tax_Amount_1 numeric(19,5)
Tax_Detail_ID_1 char(15)
Tax_Amount_2 numeric(19,5)
Tax_Detail_ID_2 char(15)
Tax_Amount_3 numeric(19,5)
Tax_Detail_ID_3 char(15)
Tax_Amount_4 numeric(19,5)
Tax_Detail_ID_4 char(15)
SUBTOTAL numeric(19,5)
DOCAMNT numeric(19,5)
COMMNTID char(15)
CURNCYID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. char(15)
Act_Labor_Cost_TTD_Mkup numeric(19,5)
Act_Materials_TTD_Mkup numeric(19,5)
Act_Equip_Cost_TTD_Mkup numeric(19,5)
Act_Subs_Cost_TTD_Mkup numeric(19,5)
Act_Other_Cost_TTD_Mkup numeric(19,5)
Act_UserDef1_TTD_Mkup numeric(19,5)
Act_UserDef2_TTD_Mkup numeric(19,5)
Act_UserDef3_TTD_Mkup numeric(19,5)
Act_UserDef4_TTD_Mkup numeric(19,5)
Billed_Labor_TTD_Mkup numeric(19,5)
Billed_Mat_Cst_TTD_Mkup numeric(19,5)
Billed_EquipTTD_Mkup numeric(19,5)
Billed_Subs_TTD_Mkup numeric(19,5)
Billed_Other_TTD_Mkup numeric(19,5)
Billed_UsrDef1_TTD_Mkup numeric(19,5)
Billed_UsrDef2_TTD_Mkup numeric(19,5)
Billed_UsrDef3_TTD_Mkup numeric(19,5)
Billed_UsrDef4_TTD_Mkup numeric(19,5)
Billed_Amount_TTD numeric(19,5)
Retention_Amount_TTD numeric(19,5)
Retention_Billed_TTD numeric(19,5)
Current_Bill_Labor numeric(19,5)
Current_Bill_Materials numeric(19,5)
Current_Bill_Equipment numeric(19,5)
Current_Bill_Subs numeric(19,5)
Current_Bill_Misc_Other numeric(19,5)
Current_Bill_UserDef1 numeric(19,5)
Current_Bill_UserDef2 numeric(19,5)
Current_Bill_UserDef3 numeric(19,5)
Current_Bill_UserDef4 numeric(19,5)
Current_Due_Labor numeric(19,5)
Current_Due_Materials numeric(19,5)
Current_Due_Equipment numeric(19,5)
Current_Due_Subs numeric(19,5)
Current_Due_Misc_Other numeric(19,5)
Current_Due_UserDef1 numeric(19,5)
Current_Due_UserDef2 numeric(19,5)
Current_Due_UserDef3 numeric(19,5)
Current_Due_UserDef4 numeric(19,5)
Tax_Date datetime
USERID char(15)
User_Define_1 char(31)
User_Define_2 char(31)
USERDEF1 char(21)
USERDEF2 char(21)
User_Def_Integer_1 int
User_Def_Integer_2 int
User_Defined_Integer_3 int
User_Defined_Integer_4 int
User_Defined_Dollar_1 numeric(19,5)
User_Defined_Dollar_2 numeric(19,5)
User_Defined_Dollar_3 numeric(19,5)
User_Defined_Dollar_4 numeric(19,5)
USRDAT01 datetime
USRDAT02 datetime
User_Defined_Date_3 datetime
User_Defined_Date_4 datetime
User_Defined_CB_1 tinyint
User_Defined_CB_2 tinyint
User_Defined_CB_3 tinyint
User_Defined_CB_4 tinyint
Wennsoft_Affiliate char(15)
Wennsoft_Branch char(15)
Wennsoft_Region char(15)
MODIFDT datetime
Modified_Time datetime
MDFUSRID char(15)
SV_Language_ID smallint
Time_Zone char(3)
WSReserved_CB1 tinyint
WSReserved_CB2 tinyint
WSReserved_CB3 tinyint
WSReserved_CB4 tinyint
WSReserved_CB5 tinyint
WSReserved_STR1 char(11)
WSReserved_STR2 char(11)
DEX_ROW_ID int auto number (1,1)
Invoice_Description text

Related Tables

Tables that share columns with JC20511. Click "Join" to add to your query.

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11

MDFUSRID

ASIEXP09 ASIEXP19 ASIEXP22 CM20200 CM20300 CT00002 CT00102 CT40401

USERID

AAG50001 AAG60001 AAG70001 ACTIVITY AHPSLH01 APR_APR30000 APR_APR30300 ASIEXP100

Modified_Time

PDK10500 JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00301

WSReserved_CB1

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

WSReserved_CB2

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

WSReserved_CB3

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

WSReserved_CB5

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

WSReserved_CB4

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301