| field name | data type | mnd. | description |
|---|---|---|---|
| BudgetLinkAcc_ID | integer | yes | Record ID |
| Budget_ID | integer | yes | Link to Budget |
| Period_ID | integer | yes | Link to Period |
| BudgetWBS_ID | integer | yes | Link to BudgetWBS |
| Layer_ID | integer | yes | Link to Layer |
| BudgetLinkAccDebitLC | decimal(4) | no | BC Debit |
| BudgetLinkAccCreditLC | decimal(4) | no | BC Credit |
| BudgetLinkAccDebitCC | decimal(4) | no | SC Debit |
| BudgetLinkAccCreditCC | decimal(4) | no | SC Credit |
| QADC01 | character(40) | no | unused QAD reserved field |
| QADC02 | character | no | unused QAD reserved field |
| QADT01 | date | no | unused QAD reserved field |
| QADD01 | decimal(10) | no | unused QAD reserved field |
| BudgetLinkAccQTY | decimal(10) | no | Qty |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | no | empty string |
| tc_Status | character | no | update status |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |