| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CurrCode | Currency Code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | CurrName | Currency | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | ChkName | Name on Printed Checks | nvarchar | 20 | 0 | | | | Allow NULL? |
| 4 | Chk100Name | Name of 100's on checks | nvarchar | 20 | 0 | | | | Allow NULL? |
| 5 | DocCurrCod | Name on Printed Docs. | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | FrgnName | English | nvarchar | 20 | 0 | | | | Allow NULL? |
| 7 | F100Name | English Hundredth Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 8 | Locked | Locked | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 9 | DataSource | Data Source | char | 1 | 0 | | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update | Allow NULL? |
| 10 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 11 | RoundSys | Rounding | int | 6 | 0 | | 0 | 0=No Rounding, 1=Round to Ten Hundredth, 2=Round to One, 3=Round to Ten, 4=Round to Five Hundredth | Allow NULL? |
| 12 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 13 | Decimals | Decimals | int | 6 | 0 | | -1 | -1=Default, 0=Without Decimals, 1=1 Digit, 2=2 Digits, 3=3 Digits, 4=4 Digits, 5=5 Digits, 6=6 Digits | Allow NULL? |
| 14 | ISRCalc | ISR Calculation | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 15 | RoundPym | Rounding in Pmnt | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 16 | ConvUnit | Is a Conventional Unit | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 17 | BaseCurr | Base Currency for Conv. Unit | nvarchar | 3 | 0 | OCRN | | | Allow NULL? |
| 18 | Factor | Factor | num | 19 | 6 | | | | Allow NULL? |
| 19 | ChkNamePl | Plural for Int.Description | nvarchar | 20 | 0 | | | | Allow NULL? |
| 20 | Chk100NPl | Plural for Hundredth Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 21 | FrgnNamePl | Plural for English | nvarchar | 20 | 0 | | | | Allow NULL? |
| 22 | F100NamePl | Plural for Eng. Hundredth Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 23 | ISOCurrCod | ISO Currency Code | nvarchar | 3 | 0 | | | AED=United Arab Emirates, Dirhams, AFN=Afghanistan, Afghanis, ALL=Albania, Leke, AMD=Armenia, Drams, ANG=Netherlands Antilles, Guilders (also called Florins), AOA=Angola, Kwanzas, ARS=Argentina, Pesos, AUD=Australia, Dollars, AWG=Aruba, Guilders (also called Florins), AZM=Azerbaijan, Manats [obsolete], AZN=Azerbaijan, New Manats, BAM=Bosni | Allow NULL? |
| 24 | MaxInDiff | Incoming Amt Diff. Allowed | num | 19 | 6 | | | | Allow NULL? |
| 25 | MaxOutDiff | Outgoing Amt Diff. Allowed | num | 19 | 6 | | | | Allow NULL? |
| 26 | MaxInPcnt | Incoming % Diff. Allowed | num | 19 | 6 | | | | Allow NULL? |
| 27 | MaxOutPcnt | Outgoing % Diff. Allowed | num | 19 | 6 | | | | Allow NULL? |
| 28 | ISOCurrNum | ISO Currency Number | nvarchar | 3 | 0 | | | | Allow NULL? |
