| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | AbsEntry | Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | WizName | Wizard Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 3 | PostDateTo | Posting Date To | date | 8 | 0 | | | | |
| 4 | WizType | Wizard Type | char | 1 | 0 | | | 1=GL Account Revaluation Wizard, 2=Stock Revaluation Wizard, 3=Cost of Sale Revaluation Wizard | Allow NULL? |
| 5 | IndexCode | Index Code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | IndexRate | Index Rate | num | 19 | 6 | | | | Allow NULL? |
| 7 | CashAcct | Cash Account | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 8 | CashFrmBl | Cash from Balance | num | 19 | 6 | | | | Allow NULL? |
| 9 | CashCancel | Cash Cancel | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 10 | FromItem | Item Number To | nvarchar | 20 | 0 | | | | Allow NULL? |
| 11 | ToItem | Item Number To | nvarchar | 20 | 0 | | | | Allow NULL? |
| 12 | ItemGroup | Item Group | int | 6 | 0 | | | | Allow NULL? |
| 13 | Properties | Item Properties | nvarchar | 250 | 0 | | | | Allow NULL? |
| 14 | RvalMethod | Inventory Revaluation Method | char | 1 | 0 | | P | I=Inflation Only, P=Price Source | Allow NULL? |
| 15 | PriceSour | Price Source | int | 6 | 0 | | | | Allow NULL? |
| 16 | TransAbs | Journal Entry Absolute Entry | int | 11 | 0 | | | | Allow NULL? |
| 17 | UseDLN | Use Delivery Notes | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 18 | UsePCH | Use Invoices with Stock Trans. | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 19 | UsePCHNoSt | Use Invoices without Trans. | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 20 | UseImport | Use Import Data | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 21 | CashDifBal | Cash Acct Difference Balance | num | 19 | 6 | | | | Allow NULL? |
| 22 | CashExecut | Cash Executed | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 23 | ActType | Account Type | char | 1 | 0 | | A | A=Post amount to adjustment account, S=Post amount to stock account | Allow NULL? |
| 24 | VarRate | Price Variance Rate | num | 19 | 6 | | | | Allow NULL? |
| 25 | FilterExe | Filter Executed | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 26 | CashErrRes | Cash Account Error Reason | int | 11 | 0 | | | | Allow NULL? |
| 27 | CshRvToAct | Cash Revaluate to Account | nvarchar | 15 | 0 | | | | Allow NULL? |
| 28 | MarkVar | Mark Items with Varient Price | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 29 | ChngPrice | Change Price | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 30 | UseSemestr | Revaluate by Semesters Index | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 31 | CreateDate | Create Date | date | 8 | 0 | | | | |
| 32 | CshLstRvBl | Cash Last Revaluation Balance | num | 19 | 6 | | | | Allow NULL? |
| 33 | userSign | Creating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 34 | userSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 35 | CshCanclD | Cash Acct Cancellation Date | date | 8 | 0 | | | | |