field name | data type | mnd. | description |
---|---|---|---|
COACrossRef_ID | integer | yes | COA Cross Reference |
SourceDomain_ID | integer | yes | Source Domain |
TargetDomain_ID | integer | yes | Target Domain |
AltCOAStruct_ID | integer | no | Alternate COA Structure |
COACrossRefCode | character(20) | yes | Code |
COACrossRefDescription | character(40) | no | Description |
COACrossRefIsActive | logical | yes | Active |
COACrossRefType | character(20) | yes | Type |
value list: | {&COACROSSREFTYPES} | ||
tcSourceDomainCode | character(8) | yes | |
tcTargetDomainCode | character(8) | yes | |
tcAltCOAStructCode | character(20) | no | |
LastModifiedDate | date | no | Last Mod Date |
LastModifiedTime | integer | no | Last Mod Time |
LastModifiedUser | character(20) | no | Last Mod User |
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 |
tc_Rowid | character | yes | primary index |
tc_ParentRowid | character | no | empty string |
tc_Status | character | no | update status |
field name | data type | mnd. | description |
---|---|---|---|
COACrossRefDet_ID | integer | yes | Cross Reference Detail |
COACrossRef_ID | integer | yes | Cross Reference |
TargetGL_ID | integer | no | Target GL Account |
TargetDivision_ID | integer | no | Target Sub-Account |
TargetCostCentre_ID | integer | no | Target Cost Center |
TargetProject_ID | integer | no | Target Project |
TargetAltCOAStructDet_ID | integer | no | Target Alternate COA |
COACrossRefDetSrcGLFrom | character(20) | no | Source GL Account From |
COACrossRefDetSrcGLTo | character(20) | no | Source GL Account To |
COACrossRefDetSrcDivFrom | character(20) | no | Source Sub-Account From |
COACrossRefDetSrcDivTo | character(20) | no | Source Sub-Account To |
COACrossRefDetSrcCCFrom | character(20) | no | Source Cost Center From |
COACrossRefDetSrcCCTo | character(20) | no | Source Cost Center To |
COACrossRefDetSrcProjFrom | character(20) | no | Source Project From |
COACrossRefDetSrcProjTo | character(20) | no | Source Project To |
tcTargetGLCode | character(8) | no | |
tcTargetDivisionCode | character(8) | no | |
tcTargetCostCentreCode | character(4) | no | |
tcTargetProjectCode | character(8) | no | |
tcTargetAltCOAStructDetCode | character(20) | no | |
LastModifiedDate | date | no | Last Mod Date |
LastModifiedTime | integer | no | Last Mod Time |
LastModifiedUser | character(20) | no | Last Mod User |
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 |
tc_Rowid | character | yes | primary index |
tc_ParentRowid | character | yes | = tCOACrossRef.tc_Rowid |
tc_Status | character | no | update status |
field name | data type | description |
---|---|---|
tiParentObject_ID | integer | |
tcLngCode | character | |
tcTranslationStringText | character | |
tc_ParentRowid | character | |
tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
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 |
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 |