JC20501 - JC_Invoice_OPEN
SQL Query Builder
146 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| WS_Job_Number | char(17) | ||||
| Project_Number | char(17) | ||||
| RMDNUMWK | char(17) | ||||
| RMDTYPAL | smallint | ||||
| WS_Application_Number | char(5) | ||||
| DOCNUMBR | char(21) | ||||
| TRXSORCE | char(13) | ||||
| Dynamics_Status | 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 | ||||
| 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_Misc_1_TTD | numeric(19,5) | ||||
| Billed_Misc_2_TTD | numeric(19,5) | ||||
| Billed_Misc_3_TTD | numeric(19,5) | ||||
| Billed_Misc_4_TTD | numeric(19,5) | ||||
| Billed_Misc_5_TTD | numeric(19,5) | ||||
| Billed_Amount_TTD | numeric(19,5) | ||||
| Retention_Amount_TTD | numeric(19,5) | ||||
| Retention_Billed_TTD | numeric(19,5) | ||||
| OrigBilledAmtTTD | numeric(19,5) | ||||
| OrigRetentionAmtTTD | numeric(19,5) | ||||
| OrigRetentionBilledTTD | numeric(19,5) | ||||
| ORTDISAM | numeric(19,5) | ||||
| ORMSCTAX | numeric(19,5) | ||||
| ORTAXAMT | numeric(19,5) | ||||
| ORSUBTOT | numeric(19,5) | ||||
| ORDOCAMT | 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) | ||||
| Invoice_Style | smallint | ||||
| No_Times_Printed | smallint | ||||
| Printed_Date | datetime | ||||
| Chgd_Since_Printing_Flag | tinyint | ||||
| PSTGSTUS | smallint | ||||
Posting Status values (11) 0 = Unposted / New1 = Unposted / Work2 = Posted / Open3 = History / Posted with Error10 = First entry before save20 = Saved and unposted30 = Currently posting40 = Posted50 = Error during posting60 = Edited after save70 = Edited recurring batch | |||||
| Cash_Remaining_Amount | 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) | ||||
| Bill | tinyint | ||||
| Reimbursable | tinyint | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
| Invoice_Description | text | ||||
Related Tables
Tables that share columns with JC20501. Click "Join" to add to your query.