JC30001L - JC_RFP_Transaction_HIST_LINES
SQL Query Builder
15 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| VCHNUMWK | char(17) | ||||
| DOCTYPE | smallint | ||||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| SEQNUMBR | int | ||||
| WS_Job_Number | char(17) | ||||
| Cost_Code_Number_Alias | char(35) | ||||
| GROSAMNT | numeric(19,5) | ||||
| TAXABLE | tinyint | ||||
| TAXSCHID | char(15) | ||||
| TRDISAMT | numeric(19,5) | ||||
| RETNAGAM | numeric(19,5) | ||||
| CIS_Amount | numeric(19,5) | ||||
| CITB_Amount | numeric(19,5) | ||||
| TAXAMNT | numeric(19,5) | ||||
| TXENGCLD | tinyint | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Related Tables
Tables that share columns with JC30001L. Click "Join" to add to your query.