K_SALSFLW - Sales Entries

Apr 26, 2024

File Name . . . . K_SALSFLW
Library . . . .   K3S_5DTA
Format Descr. . . Sales Entries
Format Name . . . RK_SALSFLW
File Type . . . . PF

Field Name FMT Start Lngth Dec Key Field Description
SF_COMP     A      1     1         Company ID
SF_LOCN     A      2     5         Location ID
SF_CHAIN    A      7    10         Chain ID
SF_STORE    A     17    10         Store ID
SF_CUSTOMR  A     27    10         Customer ID
SF_PROD     A     37    15         Product ID
SF_SFID     P     52     8   0     Sales Entry ID
SF_BIRTH    A     60    10         Record birth date
SF_LASTUPD  A     70    10         Record last update date
SF_CREATE   A     80    10         Hold Out Creation Date
SF_BEGIN    A     90    10         Ship Date
SF_END      A    100    10         Product Hold Out End
SF_HLDCAP   A    110     7   0     Hold Out Cap
SF_HDCPCNT  A    117     7   0     Last Hold Out Cap
SF_HLDQTY   P    124     7   0     Hold Out Quantity
SF_HLDREAS  A    131    40         Hold Out Reason
SF_TIMESTP  T    171    19         Time Stamp
SF_EXISTS   A    190     1         Product Exists
SF_APPROVE  A    191     1         Request Approved
SF_USERREQ  A    192    10         User Requesting
SF_USERAPR  A    202    10         User Approving
SF_RELEASE  A    212     1         Request Released
SF_CANCEL   A    213     1         Request Cancelled
SF_MEMO     A    214   500         Memo
SF_BATCH    A    714     8  0      Batch ID
SF_PROCESS  A    722     1         Process Flag
SF_STOREXT  A    723     1         Store Exists Flag
SF_CUSTEXT  A    724     1         Customer Exists Flag
SF_CHNEXT   A    725     1         Chain Exists Flag
SF_QTYSHIP  A    726     7  0      Quantity Shipped
SF_QTYRECV  A    733     7  0      Quantity Received
SF_QTYOORD  A    740     7  0      Quantity Ordered
SF_REQNUM   A    747    25         Request Number
SF_INVNUM   A    772    10         Invoice Number
SF_PARENT   A    782     8  0      Parent SF ID
SF_CHILD    A    790     8  0      Child SF ID
SF_SPECPO   A    798     1         Special Order Flag
SF_REASON   A    799     1         Reasonable Request
SF_DENYRSN  A    800   100         Reason Denied
SF_PRODTYP  A    900     1         Product Type
SF_USERA1   A    901     1         User defined alpha 1
SF_USERA2   A    902     3         User defined alpha 2
SF_USERA3   A    905    10         User defined alpha 3
SF_USERA4   A    915    50         User defined alpha 4
SF_USERN1   A    965     5  0      User defined number 1
SF_USERN2   A    970     7  2      User defined number 2
SF_USERN3   A    977    11  4      User defined number 3
SF_USERN4   A    988    11  4      User defined number 4
SF_BCHTYP   A    999     3         Batch Type
SF_BUYMULT  P   1002     7  0      Buy multiple
SF_COUNT    P   1009     7  0      Count
SF_PRETYPE  A   1016     1         Pre Order Type
SF_PRENUM   A   1017    10         Pre Order Number
SF_SALEPRI  P   1027    11  4      Sales Price
SF_RETPRI   P   1038    11  4      Retail Price
SF_SALEFLG  A   1049     1         Sales Flag
SF_RETFLAG  A   1050     1         Retail Flag
SF_EDIFLAG  A   1051     1         EDI Flag
SF_TRKFLAG  A   1052     1         Tracking Flag
SF_BROKFLG  A   1053     1         Broken Flag
SF_DESC1    A   1054    40         Product Description 1
SF_DESC2    A   1094    40         Product Description 2
SF_PBPROD   A   1134    15         Prebook Product ID
SF_CHKFLG   A   1149     1         Item Checkin Flag
SF_LWDEV    P   1150     5  0      Lowest Deliverable Count

---