SOP10200 - Sales Transaction Amounts Work - table structure
Great Plains Table Structure- SOP10200 - Sales Transaction Amounts Work
- Technical Name - SOP_LINE_WORK
- Series - Sales
- Physical Name - SOP10200
| Name | Data Type | Description |
| SOPTYPE | smallint | SOP Type |
| SOPNUMBE | char(21) | SOP Number |
| LNITMSEQ | int | Line Item Sequence |
| CMPNTSEQ | int | Component Sequence |
| ITEMNMBR | char(31) | Item Number |
| ITEMDESC | char(101) | Item Description |
| NONINVEN | smallint | Non IV |
| DROPSHIP | smallint | Drop Ship |
| UOFM | char(9) | U Of M |
| LOCNCODE | char(11) | Location Code |
| UNITCOST | numeric(19,5) | Unit Cost |
| ORUNTCST | numeric(19,5) | Originating Unit Cost |
| UNITPRCE | numeric(19,5) | Unit Price |
| ORUNTPRC | numeric(19,5) | Originating Unit Price |
| XTNDPRCE | numeric(19,5) | Extended Price |
| OXTNDPRC | numeric(19,5) | Originating Extended Price |
| REMPRICE | numeric(19,5) | Remaining Price |
| OREPRICE | numeric(19,5) | Originating Remaining Price |
| EXTDCOST | numeric(19,5) | Extended Cost |
| OREXTCST | numeric(19,5) | Originating Extended Cost |
| MRKDNAMT | numeric(19,5) | Markdown Amount |
| ORMRKDAM | numeric(19,5) | Originating Markdown Amount |
| MRKDNPCT | smallint | Markdown Percent |
| MRKDNTYP | smallint | Markdown Type |
| INVINDX | int | Inventory Index |
| CSLSINDX | int | Cost Of Sales Index |
| SLSINDX | int | Sales Index |
| MKDNINDX | int | Markdown Index |
| RTNSINDX | int | Returns Index |
| INUSINDX | int | In Use Index |
| INSRINDX | int | In Service Index |
| DMGDINDX | int | Damaged Index |
| ITMTSHID | char(15) | Item Tax Schedule ID |
| IVITMTXB | smallint | IV Item Taxable |
| BKTSLSAM | numeric(19,5) | Backout Sales Amount |
| ORBKTSLS | numeric(19,5) | Originating Backout Sales Amount |
| TAXAMNT | numeric(19,5) | Tax Amount |
| ORTAXAMT | numeric(19,5) | Originating Tax Amount |
| TXBTXAMT | numeric(19,5) | Taxable Tax Amount |
| OTAXTAMT | numeric(19,5) | Originating Taxable Tax Amount |
| BSIVCTTL | tinyint | Based On Invoice Total |
| TRDISAMT | numeric(19,5) | Trade Discount Amount |
| ORTDISAM | numeric(19,5) | Originating Trade Discount Amount |
| DISCSALE | numeric(19,5) | Discount Available Sales |
| ORDAVSLS | numeric(19,5) | Originating Discount Available Sales |
| QUANTITY | numeric(19,5) | QTY |
| ATYALLOC | numeric(19,5) | QTY Allocated |
| QTYINSVC | numeric(19,5) | QTY In Service |
| QTYINUSE | numeric(19,5) | QTY In Use |
| QTYDMGED | numeric(19,5) | QTY Damaged |
| QTYRTRND | numeric(19,5) | QTY Returned |
| QTYONHND | numeric(19,5) | QTY On Hand |
| QTYCANCE | numeric(19,5) | QTY Canceled |
| QTYCANOT | numeric(19,5) | QTY Canceled Other |
| QTYONPO | numeric(19,5) | QTY On PO |
| QTYORDER | numeric(19,5) | QTY Ordered |
| QTYPRBAC | numeric(19,5) | QTY Prev Back Ordered |
| QTYPRBOO | numeric(19,5) | QTY Prev BO On Order |
| QTYPRINV | numeric(19,5) | QTY Prev Invoiced |
| QTYPRORD | numeric(19,5) | QTY Prev Ordered |
| QTYPRVRECVD | numeric(19,5) | QTY Prev Received |
| QTYRECVD | numeric(19,5) | QTY Received |
| QTYREMAI | numeric(19,5) | QTY Remaining |
| QTYREMBO | numeric(19,5) | QTY Remaining On BO |
| QTYTBAOR | numeric(19,5) | QTY To Back Order |
| QTYTOINV | numeric(19,5) | QTY To Invoice |
| QTYTORDR | numeric(19,5) | QTY To Order |
| QTYFULFI | numeric(19,5) | QTY Fulfilled |
| QTYSLCTD | numeric(19,5) | QTY Selected |
| QTYBSUOM | numeric(19,5) | QTY In Base U Of M |
| EXTQTYAL | numeric(19,5) | Existing Qty Available |
| EXTQTYSEL | numeric(19,5) | Existing Qty Selected |
| ReqShipDate | datetime | Requested Ship Date |
| FUFILDAT | datetime | Fulfillment Date |
| ACTLSHIP | datetime | Actual Ship Date |
| SHIPMTHD | char(15) | Shipping Method |
| SALSTERR | char(15) | Sales Territory |
| SLPRSNID | char(15) | Salesperson ID |
| PRCLEVEL | char(11) | PriceLevel |
| COMMNTID | char(15) | Comment ID |
| BRKFLD1 | smallint | Break Field 1 |
| BRKFLD2 | smallint | Break Field 2 |
| BRKFLD3 | smallint | Break Field 3 |
| CURRNIDX | smallint | Currency Index |
| TRXSORCE | char(13) | TRX Source |
| SOPLNERR | binary | SOP LINE Errors |
| ORGSEQNM | int | Original Sequence Number Corrected |
| ITEMCODE | char(15) | Item Code |
| PURCHSTAT | smallint | Purchasing Status |
| DECPLQTY | smallint | Decimal Places QTYS |
| DECPLCUR | smallint | Decimal Places Currency |
| ODECPLCU | smallint | Originating Decimal Places Currency |
| QTYTOSHP | numeric(19,5) | QTY To Ship |
| XFRSHDOC | tinyint | Transferred To Shipping Document |
| EXCEPTIONALDEMAND | tinyint | Exceptional Demand |
| TAXSCHID | char(15) | Tax Schedule ID |
| TXSCHSRC | smallint | Tax Schedule Source |
| PRSTADCD | char(15) | Primary Shipto Address Code |
| ShipToName | char(65) | ShipToName |
| CNTCPRSN | char(61) | Contact Person |
| ADDRESS1 | char(61) | Address 1 |
| ADDRESS2 | char(61) | Address 2 |
| ADDRESS3 | char(61) | Address 3 |
| CITY | char(35) | City |
| STATE | char(29) | State |
| ZIPCODE | char(11) | Zip Code |
| CCode | char(7) | Country Code |
| COUNTRY | char(61) | Country |
| PHONE1 | char(21) | Phone 1 |
| PHONE2 | char(21) | Phone 2 |
| PHONE3 | char(21) | Phone 3 |
| FAXNUMBR | char(21) | Fax Number |
| Flags | smallint | Flags |
| BackoutTradeDisc | numeric(19,5) | Backout Trade Discount Amount |
| OrigBackoutTradeDisc | numeric(19,5) | Originating Backout Trade Discount Amount |
| GPSFOINTEGRATIONID | char(31) | GPSFO Integration ID |
| INTEGRATIONSOURCE | smallint | Integration Source |
| INTEGRATIONID | char(31) | Integration ID |
| CONTNBR | char(11) | Contract Number |
| CONTLNSEQNBR | numeric(19,5) | Contract Line SEQ Number |
| CONTSTARTDTE | datetime | Contract Start Date |
| CONTENDDTE | datetime | Contract End Date |
| CONTITEMNBR | char(31) | Contract Item Number |
| CONTSERIALNBR | char(21) | Contract Serial Number |
| BULKPICKPRNT | tinyint | Bulk Pick Printed |
| INDPICKPRNT | tinyint | Individual Pick Printed |
| ISLINEINTRA | tinyint | IsLineIntrastat |
| SOFULFILLMENTBIN | char(15) | SO Fulfillment Bin |
| MULTIPLEBINS | tinyint | Multiple Bins |
| Print_Phone_NumberGB | smallint | Print Phone Number GB |
| DEX_ROW_TS | datetime | Time Stamp |
| DEX_ROW_ID | int | GPS_Reserved |
Related
- GP Table Listing - Dynamics Great Plains Table listing
Last modified by Mohit @ 4/16/2025 3:28:51 AM