|
Table Owner |
Table Name |
Table Comment |
Table Column Name |
Table Column Datatype |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|---|---|---|---|---|---|---|---|
|
dbo |
mac_budget_header_tmp1 |
|
ma_ou_id |
int |
Organization Unit Id |
No |
No |
|
|
|
|
ma_budget_no |
sql_variant |
Budget Number |
|
|
|
|
|
|
ma_version_no |
int |
Version Number |
|
|
|
|
|
|
ma_ouname |
sql_variant |
Organization Unit Name |
|
|
|
|
|
|
ma_aggr_flag |
|
Aggregated Flag |
|
|
|
|
|
|
ma_budget_for |
|
Budget For |
|
|
|
|
|
|
ma_budget_type |
|
Budget Type |
|
|
|
|
|
|
ma_budget_resp |
|
Budget Response |
|
|
|
|
|
|
ma_budget_ou |
|
Budget Organization Unit |
|
|
|
|
|
|
ma_start_date |
datetime |
Start Date |
|
|
|
|
|
|
ma_end_date |
|
End Date |
|
|
|
|
|
|
ma_status |
sql_variant |
Status.Values F-Fresh,A-Active,I-Inactive |
|
|
|
|
|
|
ma_defstatus |
|
Default Status .Values F-Fresh,A-Active,I-Inactive |
|
|
|
|
|
|
ma_gen_basis |
|
Generate Basis |
|
|
|
|
|
|
ma_incr_decr |
bigint |
Increase / Decrease |
|
|
|
|
|
|
ma_maint_seas |
sql_variant |
Maintenance Seasons |
|
|
|
|
|
|
ma_basis_parent |
|
Basis Parent |
|
|
|
|
|
|
ma_basis_version |
int |
Basis Version |
|
|
|
|
|
|
ma_guid |
sql_variant |
Guid |
|
|
|
|
mac_repmac_bdetlist_tmp |
|
bu_id |
|
Business Unit Id |
|
|
|
|
|
|
bu_desc |
|
Business Unit Description |
|
|
|
|
|
|
budfrom |
|
Budget From |
|
|
|
|
|
|
budto |
|
Budget To |
|
|
|
|
|
|
budgetno |
|
Budget Number |
|
|
|
|
|
|
versionno |
int |
Version Number |
|
|
|
|
|
|
buddesc |
sql_variant |
Budget Description |
|
|
|
|
|
|
budgettype |
|
Budget Type |
|
|
|
|
|
|
budgetfor |
|
Budget For |
|
|
|
|
|
|
aggprd |
|
Aggregated Period |
|
|
|
|
|
|
accperiod |
|
Account Period |
|
|
|
|
|
|
budspan |
|
Budget Span |
|
|
|
|
|
|
budstatus |
|
Budget Status.Values F-Fresh,A-Active,I-Inactive |
|
|
|
|
|
|
amount |
bigint |
Amount |
|
|
|
|
|
|
ccno |
sql_variant |
Cost Center Number |
|
|
|
|
|
|
ccdesc |
|
Cost Center Description |
|
|
|
|
|
|
ceno |
|
Cost Exchange Number |
|
|
|
|
|
|
cedesc |
|
Cost Exchange Description |
|
|
|
|
|
|
curstatus |
|
Current Status.Values F-Fresh,A-Active,I-Inactive |
|
|
|
|
|
|
eff_date |
datetime |
Effective Period |
|
|
|
|
|
|
exp_date |
|
Expiry Date |
|
|
|
|
|
|
defitype |
sql_variant |
Definition Type |
|
|
|
|
|
|
fixedcost |
bigint |
Fixed Cost |
|
|
|
|
|
|
itemcode |
sql_variant |
Item Code |
|
|
|
|
|
|
itemvar |
|
Item Variance |
|
|
|
|
|
|
itemvardesc |
|
Item Variance Description |
|
|
|
|
|
|
qty |
bigint |
Quantity |
|
|
|
|
|
|
reportid |
sql_variant |
Report Id |
|
|
|
|
|
|
respons |
|
Response |
|
|
|
|
|
|
respou |
|
Response Organization Unit |
|
|
|
|
|
|
totcost |
bigint |
Total Cost |
|
|
|
|
|
|
varcost |
|
Variant Cost |
|
|
|
|
|
|
varproportion |
|
Variant Proportion |
|
|
|
|
|
|
guid |
sql_variant |
Guid |
|
|
|
|
|
|
ma_acc_yr_no |
|
Year Number |
|
|
|
|
|
|
ma_acc_prd_no |
|
Period Number |
|
|
|
|
mac_repmac_cccemapp_tmp |
|
bu_id |
|
Business Unit Id |
|
|
|
|
|
|
ccfrom |
|
Cost Center From |
|
|
|
|
|
|
ccto |
|
Cost Center To |
|
|
|
|
|
|
cefrom |
|
Cost Exchange From |
|
|
|
|
|
|
ceto |
|
Cost Exchange To |
|
|
|
|
|
|
ccno |
|
Cost Center Number |
|
|
|
|
|
|
ceno |
|
Cost Exchange Number |
|
|
|
|
|
|
ccdesc |
|
Cost Center Description |
|
|
|
|
|
|
cedesc |
|
Cost Exchange Description |
|
|
|
|
|
|
accperiodfrom |
|
Account Period From |
|
|
|
|
|
|
accperiodto |
|
Account Period To |
|
|
|
|
|
|
accyearfrom |
|
Account Year From |
|
|
|
|
|
|
accyearto |
|
Account Year To |
|
|
|
|
|
|
budget_no |
|
Budget Number |
|
|
|
|
|
|
behavior |
|
Behavior |
|
|
|
|
|
|
traceablity |
|
Traceability |
|
|
|
|
|
|
reportid |
|
Report Id |
|
|
|
|
|
|
cctype |
|
Cost Center Type |
|
|
|
|
|
|
cctypedesc |
|
Cost Center Type Description |
|
|
|
|
|
|
cetype |
|
Cost Exchange Type |
|
|
|
|
|
|
cetypedesc |
|
Cost Exchange Type Description |
|
|
|
|
|
|
defaultrate |
|
Default Rate |
|
|
|
|
|
|
standardrate |
bigint |
Standard Rate |
|
|
|
|
|
|
AltRate1 |
|
Alternate Rate 1 |
|
|
|
|
|
|
AltRate2 |
|
Alternate Rate 2 |
|
|
|
|
|
|
AltRate3 |
|
Alternate Rate 3 |
|
|
|
|
|
|
AltRate4 |
|
Alternate Rate 4 |
|
|
|
|
|
|
AltRate5 |
|
Alternate Rate 5 |
|
|
|
|
|
|
AltRate6 |
|
Alternate Rate 6 |
|
|
|
|
|
|
AltRate7 |
|
Alternate Rate 7 |
|
|
|
|
|
|
AltRate8 |
|
Alternate Rate 8 |
|
|
|
|
|
|
guid |
sql_variant |
Guid |
|
|
|
|
mac_repmac_ccentry_tmp |
|
center_no |
|
Center Number |
|
|
|
|
|
|
traversed_flag |
|
Traversed Flag |
|
|
|
|
|
|
strid |
|
Structure Id |
|
|
|
|
|
|
ma_guid |
|
Guid |
|
|
|
|
mac_repmac_ccstru_entrytmp |
|
budesc |
|
Budget Description |
|
|
|
|
|
|
ccstructurefr |
|
Cost Center Structure From |
|
|
|
|
|
|
ccstructureto |
|
Cost Center Structure To |
|
|
|
|
|
|
centertypenum |
|
Center Type Number |
|
|
|
|
|
|
centerunitfrom |
|
Center Unit From |
|
|
|
|
|
|
costcenterunitml |
|
Cost Center Unit Multiline |
|
|
|
|
|
|
curstatushdr |
|
Current Status Header.Values A-Active,I-Inactive |
|
|
|
|
|
|
effectivedatehdr |
datetime |
Effective Date Header |
|
|
|
|
|
|
expirydatehdr |
|
Expiry Date Header |
|
|
|
|
|
|
levelnumber |
int |
Level Number |
|
|
|
|
|
|
parentcostcenter |
sql_variant |
Parent Cost Center |
|
|
|
|
|
|
parentdescription |
|
Parent Description |
|
|
|
|
|
|
structuredescription |
|
Structured Description |
|
|
|
|
|
|
structureid |
|
Structure Id |
|
|
|
|
|
|
typedesc |
|
Type Description |
|
|
|
|
|
|
guid |
|
Guid |
|
|
|
|
|
|
traversed_flag |
|
Traversed Flag |
|
|
|
|
mac_repmac_ccstru_tmp |
|
budesc |
|
Budget Description |
|
|
|
|
|
|
ccstructurefr |
|
Cost Center Structure From |
|
|
|
|
|
|
ccstructureto |
|
Cost Center Structure To |
|
|
|
|
|
|
centertypenum |
|
Cost Exchange Type Number |
|
|
|
|
|
|
centerunitfrom |
|
Center Unit From |
|
|
|
|
|
|
costcenterunitml |
|
Cost Center Unit Multiline |
|
|
|
|
|
|
curstatushdr |
|
Current Status Header.Values A-Active,I-Inactive |
|
|
|
|
|
|
effectivedatehdr |
datetime |
Effective Date Header |
|
|
|
|
|
|
expirydatehdr |
|
Expiry Date Header |
|
|
|
|
|
|
levelnumber |
int |
Level Number |
|
|
|
|
|
|
parentcostcenter |
sql_variant |
Parent Cost Center |
|
|
|
|
|
|
parentdescription |
|
Parent Description |
|
|
|
|
|
|
structuredescription |
|
Structured Description |
|
|
|
|
|
|
structureid |
|
Structure Id |
|
|
|
|
|
|
typedesc |
|
Type Description |
|
|
|
|
|
|
guid |
|
Guid |
|
|
|
|
|
|
traversed_flag |
|
Traversed Flag |
|
|
|
|
mac_repmac_cestr_tmp |
|
budesc |
|
Budget Description |
|
|
|
|
|
|
cestrfrom |
|
Cost Exchange Starts From |
|
|
|
|
|
|
cestrto |
|
Cost Exchange Starts To |
|
|
|
|
|
|
cefrom |
|
Cost Exchange From |
|
|
|
|
|
|
ceto |
|
Cost Exchange To |
|
|
|
|
|
|
curstatus |
|
Current Status.Values A-Active,I-Inactive |
|
|
|
|
|
|
ma_variable |
|
Variable |
|
|
|
|
|
|
ma_ouid |
int |
Organization Unit Id |
|
|
|
|
|
|
formulacont |
sql_variant |
Formula Condition |
|
|
|
|
|
|
formuladesc |
|
Formula Description |
|
|
|
|
|
|
formulaid |
|
Formula Id |
|
|
|
|
|
|
printnn |
|
Print Number |
|
|
|
|
|
|
reversenn |
|
Reverse Number |
|
|
|
|
|
|
roundoffnn |
|
Round Off Number |
|
|
|
|
|
|
rowdesc |
|
Row Description |
|
|
|
|
|
|
rowid |
|
Row Id |
|
|
|
|
|
|
structuredesc |
|
Structure Description |
|
|
|
|
|
|
structureid |
|
Structure Id |
|
|
|
|
|
|
rowflag |
|
Row Flag |
|
|
|
|
|
|
typedesc |
|
Type Description |
|
|
|
|
|
|
guid |
|
Guid |
|
|