CFM30500 - CFM_SOPSQL
Dynamics GP table CFM30500 (CFM_SOPSQL) contains 10 columns including CUSTNMBR, SOPNUMBE, SOPTYPE....
SQL Query Builder
10 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| CUSTNMBR | Customer Number | String | 16 | ||
| SOPNUMBE | SOP Number | String | 22 | ||
| SOPTYPE | SOP Type1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order (In SBF, this value is not available.) | Integer | 2 | ||
SOP Document Type values (6) 1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order | |||||
| DOCDATE | Document Date | Date | 4 | ||
| DUEDATE | Due Date | Date | 4 | ||
| PYMTRMID | Payment Terms ID | String | 22 | ||
| DISGRPER | Discount Grace Period | Integer | 2 | ||
| DUEGRPER | Due Date Grace Period | Integer | 2 | ||
| Amount | Amount | Currency | 10 | ||
| AMNTPAID | Amount Paid | Currency | 10 | ||
Related Tables
Tables that share columns with CFM30500. Click "Join" to add to your query.
Amount