JC10514 - JC_Project_TRX_Level_Transfer
SQL Query Builder
20 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| WS_Job_Number | char(17) | |||
| Cost_Element | smallint | |||
| Cost_Code_Number_1 | char(7) | |||
| Cost_Code_Number_2 | char(7) | |||
| Cost_Code_Number_3 | char(7) | |||
| Cost_Code_Number_4 | char(7) | |||
| Cost_Code_Description | char(31) | |||
| Job_TRX_Number | char(21) | |||
| Document_Source | char(3) | |||
| LNSEQNBR | numeric(19,5) 0 | |||
| GLPOSTDT | datetime | |||
| QUANTITY | numeric(19,5) | |||
| Bill_Amount | numeric(19,5) | |||
| Billable_Check_Box | tinyint | |||
| TRXDSCRN | char(31) | |||
| Bill_Code_Number | char(27) | |||
| ID | char(21) | |||
| EMPLOYID | char(15) | |||
| LASTNAME | char(21) | |||
| DEX_ROW_ID | int auto number (1,1) |
Related Tables
Tables that share columns with JC10514. Click "Join" to add to your query.