Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|
1 | Enviroment No. | Enviroment No. | Normal | Code | 20 | | |
2 | Company Name | Company Name | Normal | Text | 50 | | |
4 | Company Display Name | Company Display Name | Normal | Text | 50 | | |
5 | Assigned To | Assigned To | Normal | GUID | 16 | | |
100 | Overdue Sales Documents | Overdue Sales Documents | Normal | Text | 30 | | |
101 | Purchase Documents Due Today | Purchase Documents Due Today | Normal | Text | 30 | | |
102 | POs Pending Approval | POs Pending Approval | Normal | Text | 30 | | |
103 | SOs Pending Approval | SOs Pending Approval | Normal | Text | 30 | | |
104 | Approved Sales Orders | Approved Sales Orders | Normal | Text | 30 | | |
105 | Approved Purchase Orders | Approved Purchase Orders | Normal | Text | 30 | | |
106 | Vendors – Payment on Hold | Vendors – Payment on Hold | Normal | Text | 30 | | |
107 | Purchase Return Orders | Purchase Return Orders | Normal | Text | 30 | | |
108 | Sales Return Orders – All | Sales Return Orders – All | Normal | Text | 30 | | |
109 | Enviroments – Blocked | Enviroments – Blocked | Normal | Text | 30 | | |
110 | Overdue Purchase Documents | Overdue Purchase Documents | Normal | Text | 30 | | |
111 | Purchase Discounts Next Week | Purchase Discounts Next Week | Normal | Text | 30 | | |
112 | Purch. Invoices Due Next Week | Purch. Invoices Due Next Week | Normal | Text | 30 | | |
113 | New Incoming Documents | New Incoming Documents | Normal | Text | 30 | | |
114 | Approved Incoming Documents | Approved Incoming Documents | Normal | Text | 30 | | |
115 | OCR Pending | OCR Pending | Normal | Text | 30 | | |
116 | OCR Completed | OCR Completed | Normal | Text | 30 | | |
117 | Requests to Approve | Requests to Approve | Normal | Text | 30 | | |
118 | Requests Sent for Approval | Requests Sent for Approval | Normal | Text | 30 | | |
119 | Non-Applied Payments | Non-Applied Payments | Normal | Text | 30 | | |
120 | Cash Accounts Balance | Cash Accounts Balance | Normal | Text | 30 | | |
121 | Last Depreciated Posted Date | Last Depreciated Posted Date | Normal | Text | 30 | | |
130 | Environment Name | Environment Name | FlowField | Text | 100 | | |
200 | Ongoing Sales Invoices | Ongoing Sales Invoices | Normal | Text | 30 | | |
201 | Ongoing Purchase Invoices | Ongoing Purchase Invoices | Normal | Text | 30 | | |
202 | Sales This Month | Sales This Month | Normal | Text | 30 | | |
203 | Top 10 Company Sales YTD | Top 10 Company Sales YTD | Normal | Text | 30 | | |
204 | Overdue Purch. Invoice Amount | Overdue Purch. Invoice Amount | Normal | Text | 30 | | |
205 | Overdue Sales Invoice Amount | Overdue Sales Invoice Amount | Normal | Text | 30 | | |
206 | Average Collection Days | Average Collection Days | Normal | Text | 30 | | |
207 | Ongoing Sales Quotes | Ongoing Sales Quotes | Normal | Text | 30 | | |
208 | Sales Inv. – Pending Doc.Exch. | Sales Invoices – Pending Document Exchange | Normal | Text | 30 | | |
209 | Sales CrM. – Pending Doc.Exch. | Sales Credit Memos – Pending Document Exchange | Normal | Text | 30 | | |
210 | My Incoming Documents | My Incoming Documents | Normal | Text | 30 | | |
211 | Sales Invoices Due Next Week | Sales Invoices Due Next Week | Normal | Text | 30 | | |
212 | Ongoing Sales Orders | Ongoing Sales Orders | Normal | Text | 30 | | |
213 | Inc. Doc. Awaiting Verfication | Inc. Doc. Awaiting Verification | Normal | Text | 30 | | |
214 | Purchase Orders | Purchase Orders | Normal | Text | 30 | | |
215 | Last Login Date | Last Login Date | Normal | Text | 30 | | |
216 | Contact Name | Contact Name | Normal | Text | 50 | | |
300 | Overdue Sales Documents Style | Overdue Sales Documents Style | Normal | Text | 30 | | |
301 | Purch. Docs Due Today Style | Purch. Docs Due Today Style | Normal | Text | 30 | | |
302 | POs Pending Approval Style | POs Pending Approval Style | Normal | Text | 30 | | |
303 | SOs Pending Approval Style | SOs Pending Approval Style | Normal | Text | 30 | | |
304 | Approved Sales Orders Style | Approved Sales Orders Style | Normal | Text | 30 | | |
305 | Approved Purchase Orders Style | Approved Purchase Orders Style | Normal | Text | 30 | | |
306 | Vendors-Payment on Hold Style | Vendors-Payment on Hold Style | Normal | Text | 30 | | |
307 | Purchase Return Orders Style | Purchase Return Orders Style | Normal | Text | 30 | | |
308 | Sales Return Orders-All Style | Sales Return Orders-All Style | Normal | Text | 30 | | |
309 | Enviroments – Blocked Style | Enviroments – Blocked Style | Normal | Text | 30 | | |
310 | Overdue Purch. Docs Style | Overdue Purch. Docs Style | Normal | Text | 30 | | |
311 | Purch. Disc Next Week Style | Purch. Disc Next Week Style | Normal | Text | 30 | | |
312 | Purch. Inv Due Next Week Style | Purch. Inv Due Next Week Style | Normal | Text | 30 | | |
313 | New Incoming Documents Style | New Incoming Documents Style | Normal | Text | 30 | | |
314 | Approved Incoming Docs Style | Approved Incoming Docs Style | Normal | Text | 30 | | |
315 | OCR Pending Style | OCR Pending Style | Normal | Text | 30 | | |
316 | OCR Completed Style | OCR Completed Style | Normal | Text | 30 | | |
317 | Requests to Approve Style | Requests to Approve Style | Normal | Text | 30 | | |
318 | Req Sent for Approval Style | Req Sent for Approval Style | Normal | Text | 30 | | |
319 | Non-Applied Payments Style | Non-Applied Payments Style | Normal | Text | 30 | | |
320 | Cash Accounts Balance Style | Cash Accounts Balance Style | Normal | Text | 30 | | |
321 | Last Dep Posted Date Style | Last Dep Posted Date Style | Normal | Text | 30 | | |
400 | Ongoing Sales Invoices Style | Ongoing Sales Invoices Style | Normal | Text | 30 | | |
401 | Ongoing Purch. Invoices Style | Ongoing Purch. Invoices Style | Normal | Text | 30 | | |
402 | Sales This Month Style | Sales This Month Style | Normal | Text | 30 | | |
403 | Top 10 Cust Sales YTD Style | Top 10 Cust Sales YTD Style | Normal | Text | 30 | | |
404 | Overdue Purch. Inv Amt Style | Overdue Purch. Inv Amt Style | Normal | Text | 30 | | |
405 | Overdue Sales Inv Amt Style | Overdue Sales Inv Amt Style | Normal | Text | 30 | | |
406 | Average Collection Days Style | Average Collection Days Style | Normal | Text | 30 | | |
407 | Ongoing Sales Quotes Style | Ongoing Sales Quotes Style | Normal | Text | 30 | | |
408 | Sales Inv-Pend DocExch Style | Sales Invoices – Pending Document Exchange | Normal | Text | 30 | | |
409 | Sales CrM-Pend DocExch Style | Sales Credit Memos – Pending Document Exchange | Normal | Text | 30 | | |
410 | My Incoming Documents Style | My Incoming Documents Style | Normal | Text | 30 | | |
411 | Sales Inv Due Next Week Style | Sales Inv Due Next Week Style | Normal | Text | 30 | | |
412 | Ongoing Sales Orders Style | Ongoing Sales Orders Style | Normal | Text | 30 | | |
413 | Inc Doc Awaiting Verf Style | Inc Doc Awaiting Verf Style | Normal | Text | 30 | | |
414 | Purchase Orders Style | Purchase Orders Style | Normal | Text | 30 | | |
415 | Last Login Date Style | Last Login Date Style | Normal | Text | 30 | | |
416 | Contact Name Style | Contact Name Style | Normal | Text | 50 | | |
500 | Last Refreshed | Last Refreshed | Normal | DateTime | 8 | | |
501 | My User Task Style | My User Task Style | Normal | Text | 30 | | |
502 | Group Code | Group Code | FlowField | Code | 20 | | |
510 | Currency Symbol | Currency Symbol | Normal | Text | 10 | | |
511 | Cash Accounts Balance Decimal | Cash Accounts Balance Decimal | Normal | Decimal | 12 | | |
512 | Overdue Purch. Inv. Amt. Dec. | Overdue Purch. Inv. Amt. Dec. | Normal | Decimal | 12 | | |
513 | Overdue Sales Inv. Amt. Dec. | Overdue Sales Inv. Amt. Dec. | Normal | Decimal | 12 | | |
2000000000 | $systemId | System ID | Normal | GUID | 16 | | |
2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | | |
2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | | |
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | | |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | | |