Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | Entry No. | Integer | ||
3 | CV No. | Code20 |
|
|
4 | Posting Date | Date | ||
5 | Document Type | Option | [ ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund] | |
6 | Document No. | Code20 | ||
7 | Description | Text50 | ||
11 | Currency Code | Code10 |
|
|
13 | Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
14 | Remaining Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
15 | Original Amt. (LCY) | Decimal | AutoFormatType: 1 | |
16 | Remaining Amt. (LCY) | Decimal | AutoFormatType: 1 | |
17 | Amount (LCY) | Decimal | AutoFormatType: 1 | |
18 | Sales/Purchase (LCY) | Decimal | AutoFormatType: 1 | |
19 | Profit (LCY) | Decimal | AutoFormatType: 1 | |
20 | Inv. Discount (LCY) | Decimal | AutoFormatType: 1 | |
21 | Bill-to/Pay-to CV No. | Code20 |
|
|
22 | CV Posting Group | Code10 |
|
|
23 | Global Dimension 1 Code | Code20 | CaptionClass: '1,1,1'
|
|
24 | Global Dimension 2 Code | Code20 | CaptionClass: '1,1,2'
|
|
25 | Salesperson Code | Code10 |
|
|
27 | User ID | Code50 |
|
|
28 | Source Code | Code10 |
|
|
33 | On Hold | Code3 | ||
34 | Applies-to Doc. Type | Option | [ ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund] | |
35 | Applies-to Doc. No. | Code20 | ||
36 | Open | Boolean | ||
37 | Due Date | Date | ||
38 | Pmt. Discount Date | Date | ||
39 | Original Pmt. Disc. Possible | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
40 | Pmt. Disc. Given (LCY) | Decimal | AutoFormatType: 1 | |
43 | Positive | Boolean | ||
44 | Closed by Entry No. | Integer |
|
|
45 | Closed at Date | Date | ||
46 | Closed by Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
47 | Applies-to ID | Code50 | ||
49 | Journal Batch Name | Code10 | ||
50 | Reason Code | Code10 |
|
|
51 | Bal. Account Type | Option | [G/L Account,Customer,Vendor,Bank Account,Fixed Asset] | |
52 | Bal. Account No. | Code20 |
|
|
53 | Transaction No. | Integer | ||
54 | Closed by Amount (LCY) | Decimal | AutoFormatType: 1 | |
58 | Debit Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
BlankZero: Yes |
59 | Credit Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
BlankZero: Yes |
60 | Debit Amount (LCY) | Decimal | AutoFormatType: 1 | BlankZero: Yes |
61 | Credit Amount (LCY) | Decimal | AutoFormatType: 1 | BlankZero: Yes |
62 | Document Date | Date | ||
63 | External Document No. | Code35 | ||
64 | Calculate Interest | Boolean | ||
65 | Closing Interest Calculated | Boolean | ||
66 | No. Series | Code10 |
|
|
67 | Closed by Currency Code | Code10 |
|
|
68 | Closed by Currency Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: "Closed by Currency Code" |
|
70 | Rounding Currency | Code10 | ||
71 | Rounding Amount | Decimal | AutoFormatType: 1 | |
72 | Rounding Amount (LCY) | Decimal | AutoFormatType: 1 | |
73 | Adjusted Currency Factor | Decimal | AutoFormatType: 1 | |
74 | Original Currency Factor | Decimal | AutoFormatType: 1 | |
75 | Original Amount | Decimal | AutoFormatType: 1 | |
77 | Remaining Pmt. Disc. Possible | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
78 | Pmt. Disc. Tolerance Date | Date | ||
79 | Max. Payment Tolerance | Decimal | ||
81 | Accepted Payment Tolerance | Decimal | ||
82 | Accepted Pmt. Disc. Tolerance | Boolean | ||
83 | Pmt. Tolerance (LCY) | Decimal | ||
84 | Amount to Apply | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
90 | Prepayment | Boolean | ||
480 | Dimension Set ID | Integer |
|
Editable: No |
Keys
# | Fields | ||
---|---|---|---|
0 | Entry No. | Clustered: Yes |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Bal. Account No. | Bank Account | No. |
|
1..n |
Closed by Currency Code | Currency | Code |
|
1..n |
Closed by Entry No. | Cust. Ledger Entry | Entry No. |
|
1..n |
Bal. Account No. | Customer | No. |
|
1..n |
CV Posting Group | Customer Posting Group | Code |
|
1..n |
Dimension Set ID | Dimension Set Entry |
|
1..n | |
Global Dimension 2 Code | Dimension Value | Code |
|
1..n |
Bal. Account No. | Fixed Asset | No. |
|
1..n |
Bal. Account No. | G/L Account | No. |
|
1..n |
No. Series | No. Series | Code |
|
1..n |
Reason Code | Reason Code | Code |
|
1..n |
Salesperson Code | Salesperson/Purchaser | Code |
|
1..n |
Source Code | Source Code | Code |
|
1..n |
User ID | User | User Name |
|
1..n |
Bal. Account No. | Vendor | No. |
|
1..n |
Table Relations From Other Tables
From Table | From Field |
---|