JCRFP300 - JC_RFP_Transaction_HIST_File
SQL Query Builder
105 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| BACHNUMB | char(15) | ||||
| BCHSOURC | char(15) | ||||
| VCHNUMWK | char(17) | ||||
| VENDORID | char(15) | ||||
| DOCNUMBR | char(21) | ||||
| DOCTYPE | smallint | ||||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| SOURCDOC | char(11) | ||||
| DOCAMNT | numeric(19,5) | ||||
| DOCDATE | datetime | ||||
| PSTGDATE | datetime | ||||
| VADDCDPR | char(15) | ||||
| PYMTRMID | char(21) | ||||
| TAXSCHID | char(15) | ||||
| DUEDATE | datetime | ||||
| DSCDLRAM | numeric(19,5) | ||||
| DISCDATE | datetime | ||||
| PRCHAMNT | numeric(19,5) | ||||
| CHRGAMNT | numeric(19,5) | ||||
| CASHAMNT | numeric(19,5) | ||||
| CAMCBKID | char(15) | ||||
| CDOCNMBR | char(21) | ||||
| CAMTDATE | datetime | ||||
| CAMPMTNM | char(21) | ||||
| CHEKAMNT | numeric(19,5) | ||||
| CHAMCBID | char(15) | ||||
| CHEKDATE | datetime | ||||
| CAMPYNBR | char(21) | ||||
| CRCRDAMT | numeric(19,5) | ||||
| CCAMPYNM | char(21) | ||||
| CHEKNMBR | char(21) | ||||
| CARDNAME | char(15) | ||||
| CCRCTNUM | char(21) | ||||
| CRCARDDT | datetime | ||||
| CURNCYID | Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | char(15) | |||
| CHEKBKID | char(15) | ||||
| TRXDSCRN | char(31) | ||||
| UN1099AM | numeric(19,5) | ||||
| TRDISAMT | numeric(19,5) | ||||
| TAXAMNT | numeric(19,5) | ||||
| FRTAMNT | numeric(19,5) | ||||
| TEN99AMNT | numeric(19,5) | ||||
| MSCCHAMT | numeric(19,5) | ||||
| PORDNMBR | char(21) | ||||
| SHIPMTHD | char(15) | ||||
| DISAMTAV | numeric(19,5) | ||||
| DISTKNAM | numeric(19,5) | ||||
| APDSTKAM | numeric(19,5) | ||||
| WROFAMNT | numeric(19,5) | ||||
| CURTRXAM | numeric(19,5) | ||||
| TXENGCLD | tinyint | ||||
| PMWRKMSG | binary(4) | ||||
| PMDSTMSG | binary(4) | ||||
| GSTDSAMT | numeric(19,5) | ||||
| PGRAMSBJ | smallint | ||||
| PPSAMDED | numeric(19,5) | ||||
| PPSTAXRT | smallint | ||||
| 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 | |||||
| POSTED | tinyint | ||||
| APPLDAMT | numeric(19,5) | ||||
| VCHRNMBR | char(21) | ||||
| CNTRLTYP | smallint | ||||
Control Type values (3) 0 = Voucher types1 = Payment types2 = Printed alignment forms | |||||
| MODIFDT | datetime | ||||
| MDFUSRID | char(15) | ||||
| POSTEDDT | datetime | ||||
| PTDUSRID | char(15) | ||||
| NOTEINDX | numeric(19,5) | ||||
| BKTFRTAM | numeric(19,5) | ||||
| BKTMSCAM | numeric(19,5) | ||||
| BKTPURAM | numeric(19,5) | ||||
| PCHSCHID | char(15) | ||||
| FRTSCHID | char(15) | ||||
| MSCSCHID | char(15) | ||||
| PRINTED | tinyint | ||||
| PRCTDISC | smallint | ||||
| RETNAGAM | numeric(19,5) | ||||
| ICTRX | tinyint | ||||
| ICDISTS | tinyint | ||||
| PMICMSGS | binary(4) | ||||
| Tax_Date | datetime | ||||
| PRCHDATE | datetime | ||||
| CORRCTN | tinyint | ||||
| SIMPLIFD | tinyint | ||||
| CORRNXST | tinyint | ||||
| VCHRNCOR | char(21) | ||||
| PMWRKMS2 | binary(4) | ||||
| BNKRCAMT | numeric(19,5) | ||||
| APLYWITH | tinyint | ||||
| Electronic | tinyint | ||||
| ECTRX | tinyint | ||||
| DocPrinted | tinyint | ||||
| TaxInvReqd | tinyint | ||||
| BackoutTradeDisc | numeric(19,5) | ||||
| CIS_Amount | numeric(19,5) | ||||
| CITB_Amount | numeric(19,5) | ||||
| Originating_CIS_Amount | numeric(19,5) | ||||
| Originating_CITB_Amount | numeric(19,5) | ||||
| Retention_Amount | numeric(19,5) | ||||
| Originating_Retention_Am | numeric(19,5) | ||||
| RetainageDocument | tinyint | ||||
| ORIG_VOUCHER_NUM | char(21) | ||||
| Posted_To_WIP | tinyint | ||||
| CIS_Certificate_Type | smallint | ||||
| JCCIS_Payment_Status | smallint | ||||
| Subcontractor_Type | smallint | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Related Tables
Tables that share columns with JCRFP300. Click "Join" to add to your query.