| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
Comments |
| AllocationSeq |
int identity |
4 |
|
√ |
null |
|
|
|
| TransactionSeq |
int |
4 |
|
|
null |
|
|
|
| GLCode |
varchar |
15 |
|
|
null |
|
|
|
| GLSubAllocationCode |
varchar |
15 |
|
|
('') |
|
|
|
| Amount |
money |
21,4 |
|
|
((0)) |
|
|
|
| Description |
varchar |
255 |
|
|
('') |
|
|
|
| EnteredAmount |
money |
21,4 |
|
|
((0)) |
|
|
|
| TaxCode |
varchar |
5 |
|
|
('') |
|
|
|
| TaxAmount |
money |
21,4 |
|
|
((0)) |
|
|
|
| OrderNumber |
int |
4 |
|
|
((0)) |
|
|
|
| AssetSeq |
int |
4 |
|
|
((0)) |
|
|
|
| BusinessUnitCode |
varchar |
15 |
|
|
('') |
|
|
|
| GLJournalSeq |
int |
4 |
√ |
|
null |
|
|
|
| LocalCurrencyGLAmount |
money |
21,4 |
√ |
|
null |
|
|
|
| LocalCurrencyTaxAmount |
money |
21,4 |
√ |
|
null |
|
|
|
| BankFeeFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| CreatedDate |
datetime |
16,3 |
|
|
(getdate()) |
|
|
|
| DeletedFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| HoldGLJournalSeq |
int |
4 |
√ |
|
null |
|
|
|
Table contained -1 rows
| Constraint Name |
Type |
Sort |
Column(s) |
| PK_wkCreditorAllocGL |
Primary key |
Asc |
AllocationSeq |